Problem Set 2

Group project

This is a group project. You should work in groups of 2 to 4 (not alone and not more than 4). If this is a problem, please let me know ahead of time.

Due date

You will have time in class between 9/12/18 and 9/21/18 to work on this project. It is my hope that is can be turned in on Friday, 9/21, but I will take it until 9/28 at the latest.

The dataset

I have provided a dataset that you will use for this. The dataset and it's description are on the cluster as well as in github.

• The dataset is at: /ufrc/zoo6927/share/Class_Files/data/flights.May2017-Apr2018.csv
• The metadata (description of the data) is at: /ufrc/zoo6927/share/Class_Files/data/flights_metadata.md
  • It is also nicely rendered on github.

Instructions

The goal of this project is to write a Bash script that:

1. Counts the number of flights that were delayed more than 15 minutes into or out of Gainesville, FL (airport code GNV) during the timeframe covered by the dataset. (2 points) Flight_Query.PS2.1.sh

**Just a note here...Your script works and that is fine, but by going line by line, it is quite slow:

[magitz@login2 PS2-plantsruleantsdrool]$ time bash Flight_Query.PS2.1.sh 
The number of flights that were delayed more than 15 minutes into or out of Gainesville is:
950

real	0m12.465s
user	0m9.914s
sys	0m8.528s
[magitz@login2 PS2-plantsruleantsdrool]$ time grep GNV data/flights.May2017-Apr2018.csv | cut -d"," -f 13,16 | grep 1|wc -l
950

real	0m0.239s
user	0m0.092s
sys	0m0.154s
[magitz@login2 PS2-plantsruleantsdrool]$ 

So 12.5 seconds vs 0.25 for a grep-based solution.

2. Produces a table (text is fine) with the data to fill in this table (13 points):

GNV to:	Total flights	Total flights delayed (>15min)	Total flights delayed due to Weather
ATL
CLT
MIA
Flight_Query.PS2.2.sh

3. Within a function, prints a list of all unique airport codes contained in the dataset. (3 points) Flight_Query.PS2.3.sh
4. Within a function lists the cities in Florida that have airports in the dataset. (2 points) Flight_Query.PS2.4.sh Bonus question: Asks for user input (see chapter 28) to enter either a airport code or city, state name and then calculates the number of flights as in question 1. (5 points extra credit) Flight_Query.PS2.BONUS.sh

To submit

You should submit your answer as one or more scripts in a git repository. Submit the link in Canvas.

You should start in Canvas, creating your group and then create the same group in github.

Grading

For questions, 1, 3 and 4, I will mostly be looking for the right answer.

Your score on 1,3,4 (I'll fill this in when I grade):

1. 2pts, see notes above on time.
2. 3pts
3. 2pts

For question 2, you will receive points for:

Rubric item	Points	Your score
Using github	1 point	1
Having at least one commit from each member of the team	2 points	2
Using meaningful commit messages	2 points	2
Using functions correctly	2 points	0: Not done as functions
Using comments in code	2 points	2
Using spacing to make code readable	2 points	2
Getting the correct answer	2 points	2

Extra credit:

5 pts

Total points:

23/20