Intensive review of a big dataset which contained several thousands of records. It follows a meticulous process of data cleaning and preparation to conduct a further analysis via interactive plots.
● Process a big climate dataset distributed across several thousands .csv files
● Import the data into a climate database on a cloud server
● Cleanup the data with SQL queries
● Create derived tables that contain yearly temperature averages for all weather stations
● Import a subset of the data into a Python DataFrame
● Create interactive temperature bar plots for different locations using plotly
● Create an interactive climate map with plotly
The pre defined datasets of the the European Climate Assessment can be found under the following link (Blended ECA dataset- Daily mean temperature TG):