Question: Please provide python code for this assignment please! (Links below) https://www.cse.msu.edu/~cse231/Online/Projects/Project07/Project07.pdf https://www.cse.msu.edu/~cse231/Online/Projects/Project07/proj07.py https://www.cse.msu.edu/~cse231/Online/Projects/Project07/tsa_claims.csv https://www.cse.msu.edu/~cse231/Online/Projects/Project07/tsa_claims_small.csv https://www.cse.msu.edu/~cse231/Online/Projects/Project07/tsa_claims_tiny.csv Assignment Overview (learning objectives) This assignment will give you more

Please provide python code for this assignment please! (Links below)

Please provide python code for this assignment please! (Links below) https://www.cse.msu.edu/~cse231/Online/Projects/Project07/Project07.pdf https://www.cse.msu.edu/~cse231/Online/Projects/Project07/proj07.pyhttps://www.cse.msu.edu/~cse231/Online/Projects/Project07/tsa_claims.csv https://www.cse.msu.edu/~cse231/Online/Projects/Project07/tsa_claims_small.csv https://www.cse.msu.edu/~cse231/Online/Projects/Project07/tsa_claims_tiny.csv Assignment Overview (learning objectives) This assignment will give youmore experience on the use of 1. Lists 2. iteration 3. string

https://www.cse.msu.edu/~cse231/Online/Projects/Project07/Project07.pdf

https://www.cse.msu.edu/~cse231/Online/Projects/Project07/proj07.py

https://www.cse.msu.edu/~cse231/Online/Projects/Project07/tsa_claims.csv

https://www.cse.msu.edu/~cse231/Online/Projects/Project07/tsa_claims_small.csv

https://www.cse.msu.edu/~cse231/Online/Projects/Project07/tsa_claims_tiny.csv

Assignment Overview (learning objectives) This assignment will give you more experience on the use of 1. Lists 2. iteration 3. string The goal of this project is to analyze TSA claims data. Assignment Background Did you know that claims can be filed against TSA? Sometimes the US Terminal Security Agency (TSA) makes mistakes. People can get hurt and property can be damaged, lost, or stolen. Claims are generally filed against TSA for personal injuries and lost or damaged property during screenings and they keep records of every claim! In this project you will be analyzing the claims made to TSA. The tsa_claims.csv file contains a lot of data, but we are interested in Date Received (column 1), Airport Name (column 4), Airport Claim Amount (column 9), Status (column 10), and Close Amount (column 11). Note: column count starts at zero We will be calculating total number of approved, settled, and denied application against the TSA. Take a look at the data: what is the difference between 'approved' and 'settled' cases? We will also calculate average settlement amount (close amount). Next we will find the airport with the largest claim against the TSA. Finally, we will plot the data for accepted, settled and denied cases for each year from 2002 to 2009 Assignment Overview (learning objectives) This assignment will give you more experience on the use of 1. Lists 2. iteration 3. string The goal of this project is to analyze TSA claims data. Assignment Background Did you know that claims can be filed against TSA? Sometimes the US Terminal Security Agency (TSA) makes mistakes. People can get hurt and property can be damaged, lost, or stolen. Claims are generally filed against TSA for personal injuries and lost or damaged property during screenings and they keep records of every claim! In this project you will be analyzing the claims made to TSA. The tsa_claims.csv file contains a lot of data, but we are interested in Date Received (column 1), Airport Name (column 4), Airport Claim Amount (column 9), Status (column 10), and Close Amount (column 11). Note: column count starts at zero We will be calculating total number of approved, settled, and denied application against the TSA. Take a look at the data: what is the difference between 'approved' and 'settled' cases? We will also calculate average settlement amount (close amount). Next we will find the airport with the largest claim against the TSA. Finally, we will plot the data for accepted, settled and denied cases for each year from 2002 to 2009

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!