In this blog post, we will be working with SQL querying and the python plotly package to generate insightful visualizations of the NOAA Climate Data.
Step 1. Creating a Database
The first step to querying with SQL is to create a database containing all the relevant tables. Here, we will be working with these tables (given as csv files):
-
temperatures: (giving temperatures at various weather stations all over the world for each month of each year )
-
countries: (a reference table providing the country code used for station identifiers in each country)
-
stations: (giving the name and location in latitude and longitude of each weather station)