Question
The modified 837 kB file Public_Passenger_Vehicle_Licenses.csv contains information about public passenger vehicles operating in the City of Chicago. The file contains 11 columns: Vehicle Type,
The modified 837 kB file Public_Passenger_Vehicle_Licenses.csv contains information about public passenger vehicles operating in the City of Chicago. The file contains 11 columns: Vehicle Type, Status, Vehicle Make, Vehicle Model, Vehicle Model Year, Vehicle Color, Vehicle Fuel Source, Wheelchair Accessible, City, State, ZIP Code. Each row corresponds to one vehicle. For Project 3: Create a one-table SQLite database of the file Public_Passenger_Vehicle_Licenses.csv using SQLite with Python, where each column corresponds to the column in the file. In addition, using either SQLite commands alone, or in combination with Python, answer the following questions. 1. How large is the database in kilobytes? (You don't need to use SQL or Python for this)***(dont need to do this)*** 2. What percent of the cars are hybrid fuel based? 3. How old is the average car (in years), based on vehicle model year? 4. How many different vehicle models are there? 5. What is the most common vehicle model? 6 Aside from Chicago, what is the second most common city/town of origin of these cars? 7. What zip code contains the most registered public passenger vehicles?
Sample of the data:
Vehicle Type,Status,Vehicle Make,Vehicle Model,Vehicle Model Year,Vehicle Color,Vehicle Fuel Source,Wheelchair Accessible,City,State,ZIP Code Taxi,INACTIVE,,,,,Gasoline,N,CHICAGO,IL,60608 Taxi,INACTIVE,,,,,Gasoline,N,CHICAGO,IL,60608 Charter Sightseeing,ACTIVE,FREIGHTLINER,M2,2008,BLACK,Gasoline,N,CHICAGO,IL,60630 Taxi,INACTIVE,,,,,Gasoline,N,CHICAGO,IL,60608 Taxi,ACTIVE,TOYOTA,CAMRY,2012,WHITE/BLUE/STRIPES,Hybrid,N,CHICAGO,IL,60646 Taxi,ACTIVE,DODGE,CARAVAN,2013,WHITE/BLUE,Flex Fuel,N,CHICAGO,IL,60659 Medicar,INACTIVE,FORD,E150,2007,WHITE,Gasoline,N,CHICAGO,IL,60649 Taxi,ACTIVE,FORD,ESCAPE,2012,MAROON/BLUE/STRIPES,Hybrid,N,CHICAGO,IL,60616 Charter Sightseeing,ACTIVE,BOYERTOWN,TROLLEY,1984,RED/GREEN,Gasoline,N,CHICAGO,IL,60639 Livery,ACTIVE,LINCOLN,NAVIGATOR,2017,BLACK,Gasoline,N,CHICAGO,IL,60634 Charter Sightseeing,ACTIVE,FREIGHTLINER,TROLLEY,1999,BROWN,Gasoline,N,CHICAGO,IL,60639 Taxi,ACTIVE,FORD,ESCAPE,2012,MAROON/BLUE/STRIPES,Hybrid,N,CHICAGO,IL,60616 Taxi,ACTIVE,TOYOTA,CAMRY,2013,BLUE/WHITE,Hybrid,N,CHICAGO,IL,60657 Medicar,VIOLATION,FORD,E250,2010,WHITE,Gasoline,N,SKOKIE,IL,60077 Medicar,INACTIVE,FORD,E350,2010,WHITE,Gasoline,N,MOKENA,IL,60448 Taxi,SURRENDER,TOYOTA,CAMRY,2012,WHITE,Hybrid,N,CHICAGO,IL,60659
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started