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.
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

12

Machine Learning Model to Predict CTR with Python
Machine Learning Model to Predict CTR with Python
Sentiment Analysis of TED Talk Data with R
Sentiment Analysis of TED Talk Data with R
Store Purchases Analysis And Prediction with Python
Store Purchases Analysis And Prediction with Python
Social Media Management
Social Media Management

Join 50k+ companies and 1M+ independents

Contra Logo

© 2025 Contra.Work Inc