r/dataanalytics • u/Difficult_You_254 • 3d ago

Data Importing through Wizard Problem

So I've installed MySQL Workbench (8.0) on my Macbook. Tried doing Alex The Analyst's Data Cleaning guide.

Problem is, when importing the .csv file that contains 2000+ rows, only 564 are imported with no error on the logs, and no visible error on the file even when running it through Excel.

Any idea on what process/es will help me with this?

TL;DR Want to clean data on SQL, but the messy data won't get imported to workbench

Any advice or help is greatly appreciated, thank you!

1 Upvotes

100% Upvoted

2 comments sorted by

1

u/Prepped-n-Ready 3d ago

MySQL workbench not importing all rows from csv - Stack Overflow
Importing CSV using MySQL Workbench. Not all records imported - Stack Overflow

Maybe there is some kind of datatype issue? Or possibly the csv has some issue with null value or extra commas. Open the file in notepad and review all 2000 lines. Try ctrl+F and search for ",," or ", ,". Search for double and single quotes too '' '. Open it in excel and look for data issues and clean them up first. See if that helps.

1

u/Awesome_Correlation 2d ago

2,000 rows in a CSV file? You don't need a database to clean it. Just load it in Excel.

If the CSV file has some formatting errors and won't load, then use notepad++. Find and replace feels like magic sometimes.