victordanok/Lagos-Temperature-Data

This is an EDA that explores the temperature rates in Lagos state, Nigeria over the years compared to the world data # Lagos-Temperature-Data ## Overview This is an EDA that explores the temperature rates in Lagos state, Nigeria over 150 years compared to the world data. ## Packages Used 1. SQL 2. Python Version: 3.7 3. Pandas 4. Seaborn 5. Matplotlib ## Data The data was extracted from the SQL Server on the Udacity website and stored as a comma seperated variable file. Two datasets were imported. 1. Lagos temperature data 2. Global temperature data The scrapped data contained; year city country temperature ## Data Cleaning I removed the city and country columns as I was solely focusing on Lagos city temperature data in comparison with that of the world temperature. Global temperature was being measured from the year 1750 and Lagos temperature began at 1849. Hence, to conform with data consistency, the missing years were dropped Global temperature data ended at 2015, and Lagos at 2013. The two missing years were also dropped. Lagos city temperature data had some null values and these rows were filled using the modal temperature for Lagos data ## Feature Engineering 1. Calculating Exponential Moving Averages The exponential moving average (EMA) is a technical chart indicator that tracks the continuous data over time. Unlike SMA and CMA, exponential moving average gives more weight to the recent temperatures and as a result of which, it can be a better model or better capture the movement of the trend in a faster way. EMA's reaction is directly proportional to the pattern of the data. 2. Merging Lagos and Global temperature datasets into One ## Exploratory Data Analysis 1. Line chart showing Global Temperature Figure1: Global Temperature Chart for over 150 years 2. Line chart showing Lagos temperature Figure2: Lagos Temperature Chart for over 150 years 3. Comparing Lagos Temperature and world temperature Figure3: Comparing Temperatures between Lagos and the Globe ## Conclusion Lagos temperature is alot higher than the world temperature. About 3 times higher …