Here are some of the Objectives the Professor gave us: Load data from csv file into a
Question:
Here are some of the Objectives the Professor gave us:
- Load data from csv file into a DataFrame Object
- Analyze the data using SQL and Python
- Use SQLalchemy to load data stored in a DataFrame object into the SQLite database engine
- Use sqlalchemy to connect to SQLite database engine to execute SQL queries
- Execute different SQL queries
Load traffic data into a table in a SQLite database
- we are creating a database called LAtraffic
- we are creating a table called traffic
Because you don't have access to all the cleaning/ pre-processing that i did, you can just give me the answer in the simple version i represent. The answer is a mix of SQL and PYTHON
Question (Requirement 4) to Answer: ( this has 3 parts, 1, 2, and 3),
please answer 1-3 . ALL SQL inputs must be in clean code each line of code needs to be in a separate line. I am using Jupyter notebook. I am also sending you some screenshots of my requirement 3 so you can see what the input was and how the answer looked. Below is your typical SQL format, which you should be familar with. 2 and 3 must be answered in Python.
Requirement 4: (10 points) Let's analyze the accidents for teenagers, 16 to 19, and for the older group over 80.3
You might have to use logical operators or Between statements, please figure it out.
- Use SQL to select those in the age ranges described.
- Based on percentage, how does the younger group differ from the older group by Gender? (Answer with Python). you can scroll below to see a snapshot of how the databse looks, but remember it has to be in percentage.
- Based on percentage, how does the younger group differ from the older group by Descent?
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill