Here we explore weather trends of the World the Delhi city over last 150 years. And analyse the trends of these two. This analysis is based on the results.csv
file which contains average temperature data of the World and Delhi(India) city along with years.
The details and findings of the analysis is in the Explore_weather_trend.pdf
file.
- data/city_data.csv This file contains average temperatures(°C) of cities around the World by year. This file consists of
year
,city
,country
andavg_temp
columns. - data/global_data.csv This file contains average global temperatures(°C) by year. This ffile consists of
year
andavg_temp
columns. - data/results.csv This file is created by extracting necessary data from the above two files using SQL queries for our analysis. This has
Year
,Global_Temp
,City_Temp
columns.
- SQL
- Python3
- Google Spreadsheet
- Jupyter Notebook
This project is under MIT License see more in LICENSE