Data analysis

Crimes Los Angeles

Import required libraries for analysis and mount drive:


Read csv file, assign to variable and display content:


Information about data frame:
1. Get names of all columns in df.
2. What type of data is stored in particular column (float64 or object)


How many rows is in the df?


Remove all rows where name of crime is unknown?


How many rows have been removed?


Find all unique types of crimes:


How many are there unique crimes types?


Find 30 the most popular crimes with ferquency of their occurence (Cm Cd Desc):


Find all districts with number of all crimes occured in that area:


Sort the data by districts starting with the most dangerous district:


Filter specific columns from main df:


Export specyfic columns to csv file and save it on the computer disk: