Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Tesla Deaths is a record of Tesla accidents that involved a driver, occupant, cyclist, motorcyclist, or pedestrian death, whether or not the Tesla or

   

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistics For Business And Economics

Authors: Paul Newbold, William Carlson, Betty Thorne

8th Edition

0132745658, 978-0132745659

More Books

Students also viewed these Operating System questions

Question

Show that if n0 / N 1, the value of n in (2.25) satisfies

Answered: 1 week ago