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)



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
Get step-by-step solutions from verified subject matter experts
