How to handle messy CSV files CleverCSV is a Python package for detecting the dialect of CSV files with high accuracy. It is modeled on the way in which a human would determine the dialect: by looking for patterns that result in a regular tabular structure with “clean data” in the cells (such as numbers, dates, etc.).
The package is designed to help a data scientist with messy CSV files. It also provides a handy command line tool that can standardize a messy file or generate Python code to import it.
Installation
pip install clevercsv[full]
GitHub
Docs
[Research] Wrangling Messy CSV Files by Detecting Row and TypePatterns
#clevercsv #csv