Load Large Datasets into MySQL using Python

Python script to load large Excel/CSV datasets into MySQL using Jupyter Notebook, pandas, and SQLAlchemy.

Excel/CSV to MySQL Using Python

This repository contains a step-by-step Jupyter Notebook that demonstrates how to efficiently load large datasets from Excel or CSV files into a MySQL database using Python.

🔧 Tools Used:

• Python (Jupyter Notebook)
• pandas
• SQLAlchemy
• MySQL
• Excel/CSV files

📌 Key Features:

• Clean and transform data using pandas
• Connect Jupyter Notebook to MySQL with SQLAlchemy and PyMySQL
• Insert data in bulk using to_sql() method
• Handle large files with chunksize for efficient uploading

🚀 Ideal For:

• Data Analysts
• Data Engineers
• Students and beginners working with databases
• Anyone automating data imports into MySQL

---

📂 The notebook is well-commented and beginner-friendly.

Feel free to fork, use, and modify it in your own projects. Contributions and suggestions are welcome!

🤝 Connect with Me

• 📫 LinkedIn: Aniruddha Biswas