which cities have a population that is greater than the average population

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Exercise 2 (25pts) Using the ‘departuredelays.csv’ file (included), answer the following questions. You’ll need to load the data in a dataframe first. Write your code to answer the question. An answer without code will receive 0 points.

(a) How many records are in the dataset?

(b) Which flight had the longest delay?

(c) Show all flights between San Francisco (SFO) and Chicago (ORD) with at least an 1 ½ hour delay

(d) How many flights had delays between 2 and 5 hours?

(e) What is the average delay? Distance? Instructor – Papa Niang BGDA511 – Big Data & Analytics Spring 2021

Exercise 3 (50pts) Using the ‘us_population.json’ file (included), answer the following questions. You’ll need to load the data in a dataframe first. Write the code that you used to answer the question. An answer without code will receive 0 points.

(a) What is the population of Massachusetts (MA)?

(b) What is the city with lowest population? Highest population?

(c) Which cities have a population that is greater than the average population?

(d) Which state has the highest population? Lowest population?

(e) What is the average population in each state?

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme