Name: London Housing Data
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

London Housing Data

📹Project Video available on YouTube - https://youtu.be/q-Omt6LgRLc

🖇️Connect with me on LinkedIn - https://www.linkedin.com/in/rohit-grewal

London Housing Price Dataset

The dataset contains housing market information for different areas of London over time. It includes details such as average house prices, the number of houses sold, and crime statistics. The data spans multiple years and is organized by date and geographic area.

This data is available as a CSV file. We are going to analyze this data set using the Pandas DataFrame.

Using this dataset, we answered multiple questions with Python in our Project.

Q. 1) Convert the Datatype of 'Date' column to Date-Time format.

Q. 2.A) Add a new column ''year'' in the dataframe, which contains years only.

Q. 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.

Enrol in our Udemy courses :

Python Data Analytics Projects - https://www.udemy.com/course/bigdata-analysis-python/?referralCode=F75B5F25D61BD4E5F161
Python For Data Science - https://www.udemy.com/course/python-for-data-science-real-time-exercises/?referralCode=9C91F0B8A3F0EB67FE67
Numpy For Data Science - https://www.udemy.com/course/python-numpy-exercises/?referralCode=FF9EDB87794FED46CBDF

These are the main Features/Columns available in the dataset :

Date – The month and year when the data was recorded.
Area – The London borough or area for which the housing and crime data is reported.
Average_price – The average house price in the given area during the specified month.
Code – The unique area code (e.g., government statistical code) corresponding to each borough or region.
Houses_sold – The number of houses sold in the given area during the specified month.
No_of_crimes – The number of crimes recorded in the given area during the specified month.

Tables

London Housing Data

@kaggle.rohitgrewal_london_housing_data.london_housing_data

160.69 kB
13,549 rows
6 columns

CREATE TABLE london_housing_data (
  "date" TIMESTAMP,
  "area" VARCHAR,
  "average_price" BIGINT,
  "code" VARCHAR,
  "houses_sold" DOUBLE,
  "no_of_crimes" DOUBLE
);