Discover more from Daily Dose of Data Science
Never Worry About Parsing Errors Again While Reading CSV with Pandas
Pandas isn't smart (yet) to read messy CSV files.
Its read_csv method assumes the data source to be in a standard tabular format. Thus, any irregularity in data raises parsing errors, which may require manual intervention.
Instead, try CleverCSV. It detects the format of CSVs and makes it easier to load them, saving you tons of time.
Find more info here: CleverCSV.
Share this post on LinkedIn: Post Link.
Thanks for reading Daily Dose of Data Science! Subscribe for free to learn something new about Python and Data Science every day.
Find the code for my tips here: GitHub.