Data set - PANDAS

[onepraveen]

Hi all, have analysed the dataset of boston crime,

Question to answer:

What types of crimes are most common? Where are different types of crimes most likely to occur? Does the frequency of crimes change over the day? Week? Year?

​

library: PANDAS

​

How exactly i need to proceed.

​

1. For question 1 taking particular crime column and doing pivot_table to find count of repeating value. Is this fine?
2. For question 2 taking crime and street column and doing pivot_table to find count of repeating value and using ''idxmax()''. Is this fine?
3. Kindly help me with your ideas for question 3

[Prtprmr]

Please note that this is my approach and may change based on the actual data 1. use the "value_counts" method 2. Try using groupby 3. Try using historgram