BUSN5101 – Programming for Business

Python Programming

Assignment

Assignment details:

Assignment Mark:               30% of Final Mark

Submission Date:                30/05/2021 at 11:59 pm

Late Submission Penalty:     10% per day

Learning outcome of the assignment:

●  Practice with real-world data sets and understand the structure and organisation of data

●  Learn to import raw data into programming environments, and to perform basic data wrangling (cleaning and formatting data for downstream process)

●  Learn to apply programming skills to process raw data to solve business related problems

●  Learn to visualize data to effectively display the results, and communicate the gained insights with clients and stakeholders

Two csv files contain some information about airports in the US and the details of the cause of airline delays in Feb 2020.

Using Python programming complete the following activities:

Part A:

To complete this section, you are asked to use the Python csv module to load data into the IDE.

The first csv file lists information about the airports like name, city, latitude (lat) and longitude (long) coordinates. We’d like to create a text file including only the airport names and their coordinates. Also, we need to automate the process of loading data into an IDE, and writing the text file.

1.  Develop a flowchart for completing the activity.

2.  Develop a Python script for loading the csv file and creating the text file with the requested information.

3.  Plot the coordinates of the airports using a scatter diagram with only the negative longitudinal coordinate values.

Part B:

To complete this section, you are asked to use the Python Pandas module.

The second csv file contains details of the airline delays. The delays are presented in two forms: counts of the delayed flights, and the time of delays in minutes. The file also contains the cause of the airline delays which are listed in the table below:

Using Pandas and other Python functions and tools develop scripts to complete the following activities:

1.  Find the total number of flights (operations).

2.  Find the total number of delayed flights.

3.  Find the total delayed time in minutes.

4.  Find the airport with largest number of delayed flights.

5.  Find the coordinates (from Part A) of the airport with highest delayed time.

6.  Find the airport in Texas which has the largest number of delayed flights?

7.  Using a pie chart present a display the percentage of on-time flights, and the items listed in the table above.

Brief Marking Criteria: