Skip to content

A simple Python program to align the columns for the CSV files with neglected commas at the end of the rows. If you encounter "pandas.errors.parsererror: error tokenizing data. c error" when opening CSV file with pandas, use this to convert the CSV file to the correct format.

License

Notifications You must be signed in to change notification settings

excusezmoi/CSVColumnAlignment

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 

Repository files navigation

CSVColumnAlignment

A simple Python program to align the columns for the CSV files with neglected commas at the end of the rows. This solves the error "pandas.errors.parsererror: error tokenizing data. c error".

About

This Python file uses Excel to open the CSV file with colunms not aligned, and save as a new file with correct number of commas in each row.

Requirement

Program

Python 3.x

Microsoft Excel

Package

win32com

Note

Please enter absolute file path.

Please follow the instruction of the file path format.

About

A simple Python program to align the columns for the CSV files with neglected commas at the end of the rows. If you encounter "pandas.errors.parsererror: error tokenizing data. c error" when opening CSV file with pandas, use this to convert the CSV file to the correct format.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages