Tesla Deaths is a record of Tesla accidents that involved a driver, occupant, cyclist, motorcyclist, or...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Tesla Deaths is a record of Tesla accidents that involved a driver, occupant, cyclist, motorcyclist, or pedestrian death, whether or not the Tesla or its driver were at fault The Tesla Deaths website makes their data publicly available as a spreadsheet. This file is available in your workspace already. Write a Python script that prints the average of the total number of individuals involved in the crashes, limited to the United States of America, aggregated by each State and sorted from most to least deaths. 1. You may want to download the excel file to view the available column names and structure of the file. 2. The last 10 lines of the excel file contain summary information. You will need to ignore this section of the file. 3. You will need to calculate the total deaths from the multiple columns representing the individuals involved. Verified Tesla AutoPilot Reported in Model claimed NHTSA SGO Autopilot Death Case # Year Date Country State Description Tesla Tesla Other Cyclists/ TSLA+cycl Deaths driver occupant vehicle Peds /peds 322 2023 5/7/2023 Ireland 321 2023 5/5/2023 USA Tesla and motorbike collide Motorcycle crashes into Tesla 1 1 1 1 320 2023 5/5/2023 China Tesla hits barrier, DUI 2 1 1 2 319 2023 4/30/2023 USA NJ Collision 1 1 318 2023 4/25/2023 USA Tesla hits electric bike 1 1 1 317 2023 4/23/2023 USA Multicar crash 2 2 316 2023 4/18/2023 USA Tesla hits car, car crashes into median 1 1 315 2023 4/17/2023 USA TX Two car collision 1 1 1 1 3 314 2023 4/14/2023 USA AL Tesla crashes into semi 2 1 1 2 313 2023 4/3/2023 USA 312.1 2023 3/28/2023 USA Fiery crash 1 1 1 312 2023 3/25/2023 USA 311 2023 3/12/2023 USA 310 2023 2/25/2023 USA 309 2023 2/25/2023 USA CA 308 2023 2/21/2023 USA DC 307 2023 2/20/2023 USA 306 2023 2/20/2023 USA 305 2023 2/18/2023 USA CA 304 2023 2/17/2023 China 303 2023 2/17/2023 USA 302 2023 2/15/2023 USA 301 2023 2/14/2023 USA NJ 300 2023 2/7/2023 USA 299 2023 1/31/2023 USA PA JJ5JXQJG. MONZA Pickup hits Tesla 1 1 Hit and run 1 1 1 3 Car hits Tesla that crashed into cable barrier; inclement weather 1 1 Tesla hits turning car 1 1 Collision 2 1 1 Multi-car crash 1 1 Tesla drives into embankment 1 1 Tesla drives into opposite lane 3 2 1 Tesla crashes into fire truck 1 1 Tesla lands on front end, crashes into vehicles 1 1 NY Tesla collides with car head-on 4 1 1 2 2112112 3 3 CO Four vehicle collision 1 1 Pickup hits Tesla 1 1 Two-car collision 2 1 1 Speeding Tesla hits pedestrian 1 1 298 2023 1/30/2023 USA MO Speeding Tesla crashes into car 1 31 21 13781-5165 1 1 13781-4963 1 Excerpt Verifying Tesla Autopilot Deat Tesla Deaths is a record of Tesla accidents that involved a driver, occupant, cyclist, motorcyclist, or pedestrian death, whether or not the Tesla or its driver were at fault The Tesla Deaths website makes their data publicly available as a spreadsheet. This file is available in your workspace already. Write a Python script that prints the average of the total number of individuals involved in the crashes, limited to the United States of America, aggregated by each State and sorted from most to least deaths. 1. You may want to download the excel file to view the available column names and structure of the file. 2. The last 10 lines of the excel file contain summary information. You will need to ignore this section of the file. 3. You will need to calculate the total deaths from the multiple columns representing the individuals involved. Verified Tesla AutoPilot Reported in Model claimed NHTSA SGO Autopilot Death Case # Year Date Country State Description Tesla Tesla Other Cyclists/ TSLA+cycl Deaths driver occupant vehicle Peds /peds 322 2023 5/7/2023 Ireland 321 2023 5/5/2023 USA Tesla and motorbike collide Motorcycle crashes into Tesla 1 1 1 1 320 2023 5/5/2023 China Tesla hits barrier, DUI 2 1 1 2 319 2023 4/30/2023 USA NJ Collision 1 1 318 2023 4/25/2023 USA Tesla hits electric bike 1 1 1 317 2023 4/23/2023 USA Multicar crash 2 2 316 2023 4/18/2023 USA Tesla hits car, car crashes into median 1 1 315 2023 4/17/2023 USA TX Two car collision 1 1 1 1 3 314 2023 4/14/2023 USA AL Tesla crashes into semi 2 1 1 2 313 2023 4/3/2023 USA 312.1 2023 3/28/2023 USA Fiery crash 1 1 1 312 2023 3/25/2023 USA 311 2023 3/12/2023 USA 310 2023 2/25/2023 USA 309 2023 2/25/2023 USA CA 308 2023 2/21/2023 USA DC 307 2023 2/20/2023 USA 306 2023 2/20/2023 USA 305 2023 2/18/2023 USA CA 304 2023 2/17/2023 China 303 2023 2/17/2023 USA 302 2023 2/15/2023 USA 301 2023 2/14/2023 USA NJ 300 2023 2/7/2023 USA 299 2023 1/31/2023 USA PA JJ5JXQJG. MONZA Pickup hits Tesla 1 1 Hit and run 1 1 1 3 Car hits Tesla that crashed into cable barrier; inclement weather 1 1 Tesla hits turning car 1 1 Collision 2 1 1 Multi-car crash 1 1 Tesla drives into embankment 1 1 Tesla drives into opposite lane 3 2 1 Tesla crashes into fire truck 1 1 Tesla lands on front end, crashes into vehicles 1 1 NY Tesla collides with car head-on 4 1 1 2 2112112 3 3 CO Four vehicle collision 1 1 Pickup hits Tesla 1 1 Two-car collision 2 1 1 Speeding Tesla hits pedestrian 1 1 298 2023 1/30/2023 USA MO Speeding Tesla crashes into car 1 31 21 13781-5165 1 1 13781-4963 1 Excerpt Verifying Tesla Autopilot Deat
Expert Answer:
Related Book For 
Statistics For Business And Economics
ISBN: 9780132745659
8th Edition
Authors: Paul Newbold, William Carlson, Betty Thorne
Posted Date:
Students also viewed these operating system questions
-
Googles ease of use and superior search results have propelled the search engine to its num- ber one status, ousting the early dominance of competitors such as WebCrawler and Infos- eek. Even later...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Assume the premises: S. S-P. P~N, ~R-N. Give a detailed informal proof of: R. Number each step and give an explanation for each. Write all the steps in the proof at once in the Math Editor. (it works...
-
Hard Bodies Co. is a fitness chain that has just completed its second year of operations. At the beginning of its first fiscal year, the company purchased fitness equipment at a cost of $600,000 and...
-
The winch takes in cable at the rate of 200 mm /s, and this rate is momentarily increasing at 500 mm /s each second. Determine the tensions in the three cables. Neglect the weights of the pulleys. 2...
-
Consider the following cash flow profile and assume MARR is 10 percent/year. a. What does Descartes' rule of signs tell us about the IRR(s) of this project? b. What does Norstrom's criterion tell us...
-
The Kelly Services, Inc., and Subsidiaries balance sheets from its 2008 annual report are presented in Exhibit 5-4. Required a. Using the balance sheets, prepare a vertical common-size analysis for...
-
Objectives: Your company is currently planning to automate many different system administration tasks. Your manager has asked you to research a system administration task and implement it using...
-
Which of the following is NOT a cognitive constraint that is proposed to resolve referential ambiguity? A. whole object assumption B. joint attention assumption C. taxonomic assumption D. mutual...
-
Why is there a need for integrity tests?
-
Assess the value of equity theory.
-
How does an LCC benefit from operating a single- fleet type?
-
What happened to transform computer reservation systems into global distribution systems?
-
Star Industries has published its annual account. It indicates that during the year the firm had sales of $3,500,000, cost of goods sold totaled $2,300,000, operating expenses were $420,000, and...
-
A 700-g ball B is hanging from an in extensible cord attached to a support at C. A 350-g ball A strikes B with a velocity of 6 m/s at an angle of 20 degrees with the vertical. Assuming no friction...
-
If the joint cost function for two products is C(x, y) = xy2 + 1 dollars (a) Find the marginal cost (function) with respect to x. (b) Find the marginal cost with respect to y.
-
Using the data of Exercise 15.6, carry out a test of the null hypothesis of equality of the three population mean numbers of parts per shipment not conforming to standards without assuming normality...
-
A random sample of data has a mean of 75 and a variance of 25. a. Use Chebyshev's theorem to determine the percent of observations between 65 and 85. b. If the data are mounded, use the empirical...
-
The following model was fitted to data on 32 insurance companies: where y` = price-earnings ratio x1 = size of insurance company assets, in billions of dollars x2 = dummy variable taking the value 1...
-
N = 230, n = 15, k = 200 Compute the mean and standard deviation of the hypergeometric random variable X.
-
One study showed that in a certain year, airline fatalities occur at the rate of 0.011 deaths per 100 million miles. Find the probability that, during the next 100 million miles of flight, there will...
-
N = 60, n = 8, k = 25 Compute the mean and standard deviation of the hypergeometric random variable X.
Study smarter with the SolutionInn App