Using Python in Jupyter Notebook to recreate queries for imaginary stakeholders. Demonstrates connecting to MySQL, exporting tables to Excel, merging data, cleaning datasets, and counting orders. Visualizations include bar plots, revenue plots, pie charts, scatter charts, and map manipulation with geopandas. Dataset from MySQL.
python
jupyter-notebook
pandas
data-science-portfolio
ireland
dublin
pymysql
getpass
geopandas
python-data-science
python-jupyter
python-jupyter-notebook
sqlalchemy-python
matplotlib-pyplot
portfolio-data
jose-rico
jose-maria-rico-leal
jose-rico-data
-
Updated
Jul 2, 2024 - Jupyter Notebook