Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help with creating this scatterplot. I am having trouble answering the question below. The data I am using is in the following 2 tables

Please help with creating this scatterplot. I am having trouble answering the question below.image text in transcribed

The data I am using is in the following 2 tables below:

The first table is called "chicago". Theft, battery, assault, and robbery can be found in rows within the "primary_type" column. image text in transcribed

The other table I am working with below is called "police_stations".

image text in transcribed

The sample output of the Seaborn Scatterplot should look like this:

image text in transcribed

PLease help with any suggestions

Requirement \#6: (10 points) - Create a seaborn scatterplot to show THEFT, BATTERY, ASSAULT , by the hour of the day. (Reference: https://seaborn.pydata.org/generated/seaborn.scatterplot.html) - You can use SQL and/or Python to prepare the data for the plot. If you choose to extract the hour from date_of_occurrence using SQL, check out https://www.postgresql.org/docs/current/functions-datetime.html. - Number of crimes will be on the y-axis and hour of day will be on the x-axis. Be sure to provide a title and a legend for your plot. - Using a markdown cell, explain the findings from the plot. \( \begin{aligned} \text { Out[10]: } & (\text { 'district',), } \\ & (\text { 'district_name',), } \\ & (\text { 'address',), } \\ & (\text { 'city',), } \\ & (\text { 'state',), } \\ & (\text { zip',), } \\ & (\text { 'website',), } \\ & (\text { phone',), } \\ & (\text { 'fax',), } \\ & (\text { tty', , } \\ & (\text { 'x_coordinate',), } \\ & (\text { 'y_coordinate',), } \\ & (\text { latitude', , } \\ & (\text { longitude',), } \\ & (\text { 'location',), } \\ & (\text { 'where_is',)] }\end{aligned} \) Here is a sample output for Req. 6

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_2

Step: 3

blur-text-image_3

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

Time Series Databases New Ways To Store And Access Data

Authors: Ted Dunning, Ellen Friedman

1st Edition

1491914726, 978-1491914724

More Books

Students also viewed these Databases questions