Weather Database Analysis with MySQL
Ademola Ibitayo
0
Data Analyst
MySQL
Python
R
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
0
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
9
Tags
Data Analyst
MySQL
Python
R
Ademola Ibitayo
Leveraging data and technology for business profitability.
Machine Learning Model to Predict CTR with Python
Sentiment Analysis of TED Talk Data with R
Store Purchases Analysis And Prediction with Python
Social Media Management