Python Projects - Data Analytics - Project - 5 | Data Analysis with Python | #DataScience | London Housing Data

📩 Download All 15 Projects Source Codes + Datasets : https://rzp.io/rzp/all15projects Download Dataset - https://drive.google.com/file/d/1y7GKWfD9bJN80IQ4e-oy_fun6I_uTICE/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 & Dataset) - https://rzp.io/l/project5sourcecode 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 --------------------------------------- Watch demo of Self Study Material - https://youtu.be/LoFpsODdkuo --------------------------------------- In this video, the London Housing Data is analyzed in a very Easy To Understand (ETU) language. Here, 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. 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 * df.count() - It counts the no. of non-null values of each column. * df.isnull().sum() - It detects the missing values from the dataframe. * import seaborn as sns - To import the Seaborn library. * import matplotlib.pyplot as plt - To import the Matplotlib library. * sns.heatmap(df.isnull()) - It will show the all columns & missing values in them in heat map form. * plt.show() - To show the plot. * df.dtypes - To show the datatype of each column. * pd.to_datetime(df.Date_Time_Col) - Converts the data-type of Date-Time Column into datetime[ns] datatype. * df.Time_Col.dt.year - Creating a new column with only year values * df.Time_Col.dt.month - Creating a new column with only month values. * df.insert( index , ‘new_column_name’, new_column_values) - To insert a New column at a particular position with values in it. * df.drop(['Col_name'] , axis=1 , inplace = True) - To drop a column from the dataframe permanently. * df.groupby(‘Col_name’) - To form groups of all unique values of the column. * df[df.Col_1 = = ‘Element1’] - Filtering – We are accessing all records with Element1 only of Col_1. * df.groupby(‘Col_1’)[‘Col_2’] .mean( ) - To create groups - Two Keys – Apply on Col_2 grouped by Col_1. ----------------------------------- Q. 1) Convert the Datatype of 'Date' column to Date-Time format. Q. 2) Add a new column ''year'' in the dataframe, which contains years only. (2.B) Add a new column ''month'' as 2nd column in the dataframe, which contains month only. Q. 3) Remove the columns 'year' and 'month' from the dataframe. Q. 4) Show all the records where 'No. of Crimes' is 0. And, how many such records are there ? Q. 5) What is the maximum & minimum 'average_price' per year in england ? Q. 6) What is the Maximum & Minimum No. of Crimes recorded per area ? Q. 7) Show the total count of records of each area, where average price is less than 100000. ---------------------- 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