An interactive data science portfolio project demonstrating end-to-end data profiling, pivot table transformations, and modern interactive data visualizations using Python.
- Dataset Overview: Loading, cleaning, and filtering missing values from raw demographic data.
- Pivot Table Manipulation: Aggregating raw multi-row records into readable structural summaries.
- Interactive Visualizations: Building dynamic, interactive line charts and pie charts using Plotly Express.
population_total.csv- The raw global population source dataset.1.Dataset Overview and Making Pivot Table and Data Visulization.ipynb- Data exploration and data preparation.Interactive Visualization with pandas .ipynb- Advanced interactive charting workflows.
- How to Run Locally
git clone https://github.com/lmao2124345/pandas-data-visualization-guide-
Install the required dependencies:
pip install -r requirements.txt
-
Launch Jupyter Notebook to view the files:
jupyter notebook
- Python 3
- Pandas (Data manipulation)
- Plotly Express (Interactive rendering engine)
- OpenPyXL (Excel spreadsheet exporting)