Weather Database Analysis with MySQL
Ademola Ibitayo
Weather-Database-Analysis-with-MySQL
In this project, the weather database was explored using MySQL. There are 5 sessions with different questions answered based on the data from the database which include;
cat_locations
metoffice_dailyweatherdata
weathertype
zones
timezone among other tables in the database.
The questions in the weather_db_script were answered using different methods like common table expressions (CTEs), JOINS (INNER JOIN, LEFT JOIN) etc.
We also connected R to MySQL to explore the weather database as seen in the MySQL_Connector_R_Prog.R and MySQL_Connector_R_Prog.pdf file.
Similarly, python was connected to MySQL as seen in the MySQL_Connector_Python.ipynb.
View the full project on GitHub - https://github.com/AdemolaI/Weather-Database-Analysis-with-MySQL
Like this project
Posted Dec 4, 2023
In this project, the weather database was explored using MySQL. The questions were answered using methods like (CTEs), JOINS (INNER JOIN, LEFT JOIN) etc.
Likes
0
Views
22
