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...
-
The following table shows the sales and average book value of fixed assets for three different companies from three different industries for a recent year: A. For each company, determine the fixed...
-
Consider the diagram at the right depicting the demand and cost conditions faced by a monopolistically competitive firm. a. What are the total revenues, total costs, and economic profits experienced...
-
Jennifer Vera, Inc., is the only company with a distribution network for its imported goods. The company does a brisk business with specialty stores such as Neiman Marcus, Saks Fifth Avenue, and...
-
Lewiss management has been considering moving to a new downtown location, and they are concerned that these plans may come to fruition prior to the expiration of the lease. If the move occurs, Lewis...
-
a) Consider the fixed asset cost of the Limited Production and Full Production scenarios. Some managers believe that these costs are S890, 000 and $480,000, respectively, which are the amounts that...
-
Large Manufacturer, Inc. has grown quickly in the last few years and is now interested in providing a retirement plan for its 2,000 employees. Which of the following is(are) a factor that should...
-
Give examples of activities covered by ESG and sustainability that are not climate risk issues.
-
How can pension plans and mutual funds help solve the global warming problem?
-
What are the investment grade ratings used by S&P.
-
What are the advantages of expected shortfall over value at risk?
-
Explain how machine learning is changing the way lending decisions are made. What are the risks in relying on machine learning algorithms for these decisions?
-
Fill-in the blank. Using algebraic substitution, the f x?Vx + 3dx equals 2/(x + 3)3 +3) _ 6(x+3) |+c. +. 7 3 . x+3 . . 3 D. 3(x + 3)2
-
An investor sells a European call on a share for $4. The stock price is $47 and the strike price is $50. Under what circumstances does the investor make a profit? Under what circumstances will the...
-
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...
-
Using only the linear part of the moisture absorption curve for a temperature of \(77^{\circ} \mathrm{C}\) in Figure 5.12, and assuming a thickness of \(2.54 \mathrm{~mm}\), estimate the diffusivity...
-
The filament-wound E-glass/epoxy pressure vessel described in Example 4.4 is to be used in a hot-wet environment with temperature \(T=100^{\circ} \mathrm{F}\) \(\left(38^{\circ} \mathrm{C} ight)\)...
-
For the composite properties and environmental conditions described in Examples 3.6, 4.7, and 5.3, determine the hygrothermally degraded values of the longitudinal and transverse tensile strengths....
Study smarter with the SolutionInn App