How can I fix "Error tokenizing data" on pandas csv reader?

I struggled with this almost a half day , I opened the csv with notepad and noticed that separate is TAB not comma and then tried belo combination.

df = pd.read_csv('C:\\myfile.csv',sep='\t', lineterminator='\r')

Try df = pd.read_csv(file, header=None, error_bad_lines=False)

The existing answer will not include these additional lines in your dataframe. If you'd like your dataframe to be as wide as its widest point, you can use the following:

delimiter = ','
max_columns = max(open(path_name, 'r'), key = lambda x: x.count(delimiter)).count(delimiter)
df = pd.read_csv(path_name, header = None, skiprows = 1, names = list(range(0,max_columns)))

Set skiprows = 1 if there's actually a header, you can always retrieve the header column names later. You can also identify rows that have more columns populated than the number of column names in the original header.

A quick a dirty solution that may be helpful to people, you can copy and paste values of your data into a new excel file and save as csv. That can help remove some of those invisible funky characters from files sometimes.

for me there was a different number of columns in the file at a certain line. it helped passing names arguement when reading csv (which fixed the column count).
fix different column count in file