Python Projects - Data Analytics - Project - 3 | Data Analysis with Python | #DataScience | Police Dataset

📩 Download All 15 Projects Source Codes + Datasets : https://rzp.io/rzp/all15projects Download Dataset - https://drive.google.com/file/d/1qPIX7DzuKMRRo0zenCnmOeUbI9glWHkw/view?usp=sharing 👉Connect with me on LinkedIn - https://www.linkedin.com/in/rohit-grewal 👉Purchase - Python Data Analysis Self Study Notes & All Projects Source Codes (Rs.499 only) - https://rzp.io/l/dslnotes239 👉Download Project (Python Code & Data) - https://rzp.io/l/project3sourcecode Download - Python Pandas Notes ( Rs.50 ) - http://bit.ly/3KxMpgA --------------------------------- Watch our videos in Hindi on new channel: https://www.youtube.com/@ITCoursesEasy --------------------------------- 👉Enroll in our Udemy courses : 1. Python Data Analytics 13 Projects - https://www.udemy.com/course/bigdata-analysis-python/?referralCode=F75B5F25D61BD4E5F161 2. Python For Data Science - https://www.udemy.com/course/python-for-data-science-real-time-exercises/?referralCode=9C91F0B8A3F0EB67FE67 3. Numpy For Data Science - https://www.udemy.com/course/python-numpy-exercises/?referralCode=FF9EDB87794FED46CBDF ------------------------------------ 👉Join Facebook Group - https://www.facebook.com/groups/datasciencelovers 👉Join WhatsApp Group - https://chat.whatsapp.com/JKBkj7Lc9Ba6ZpzVSP5N4O 👉Join LinkedIn Group - https://www.linkedin.com/groups/9247278 👉Follow on Instagram - https://www.instagram.com/data_science_lovers Contact Mail Id : [email protected] ---------------------------------------- Download Free Core Python Notes - https://datasciencelovers.graphy.com/products/Core-Python-Notes-64d116f7c7a9985f7b99a5bf?dgps_s=dsh&dgps_u=c&dgps_uid=64cb5694e4b000cf748a30c2&dgps_t=cp_m --------------------------------------- In this video, you will learn how to work on a real project of Data Analysis with Python. Questions are given in the project and then solved with the help of Python. It is a project of Data Analysis with Python or you can say, Data Science with Python. The commands that we used in this project : * import pandas as pd -- To import Pandas library * pd.read_csv - To import the CSV file in Jupyter notebook * head() - It shows the first N rows in the data (by default, N=5) * df.isnull( ).sum( ) - It detects the missing values from each column of the dataframe. * df.drop(‘Col_name’ ) - To drop a column from dataframe. * value_counts - In a column, it shows all the unique values with their count. It can be applied on a single column only. * df.groupby(‘Col_1’)[‘Col_2’] .sum( ) - To create groups - Two Keys – Apply on Col_2 grouped by Col_1. * df['Column_name'].map( { old1:new1 , old2:new2} ) – Change the all values of a column from old to new. We have to write for all values of column otherwise Nan will appear. * df['Column_name'].mean() - To show Mean value of a column. * df.groupby('Column_1').Column_2.describe() - To create groups based on Column1 and show statistics summary based on Column2. ....................................................................... Q. 1) Instruction ( For Data Cleaning ) - Remove the column that only contains missing values. Q. 2) Question ( Based on Filtering + Value Counts ) - For Speeding , were Men or Women stopped more often ? Q. 3) Question ( Groupby ) - Does gender affect who gets searched during a stop ? Question ( mapping + data-type casting ) Q. 4) Question ( mapping + data-type casting ) - What is the mean stop_duration ? Q. 5) Question ( Groupby , Describe ) - Compare the age distributions for each violation. ------------------------------------------------------- You must check our other Data Analytics Projects : Project 14 - Salary Data Analysis - https://youtu.be/TLIotspGcng Project 13 - HR Data Analytics - https://youtu.be/fykrwQD3HR4 Project 12 - AI Market Financial Data Analysis - https://youtu.be/WmJYHz_qn5s Project 11 - Airlines' Flights Data Analysis - https://youtu.be/gu3Ot78j_Gc Project 10 - Spotify-YouTube Data Analysis - https://youtu.be/xqtbBosGMl0 Project 9 - https://youtu.be/dQwnyCEZ-UU Project 8 - https://youtu.be/b7Kd0fLwgO4 Project 7 - https://youtu.be/AO5uhxa1R84 Project 6 - https://youtu.be/e1zKFSrKeLs Project 5 - https://youtu.be/q-Omt6LgRLc Project 4 - https://youtu.be/89eYAAPyRfo Project 3 - https://youtu.be/GyUbo45mVSE Project 2 - https://www.youtube.com/watch?v=fhiUl7f5DnI Project 1 - https://youtu.be/4hYOkHijtNw #python #dataanalytics #datascience #project