Python pandas library can allow us to load data from csv files, however, when you are loading data, you may find this error: pandas.errors.ParserError: Error tokenizing data. C error. In this tutorial, we will introduce how to fix this error.
Create a csv file
We have created a csv file called pandas_csv.csv, we will add some data in this csv file.
Open this file with excel
Many computers open csv files with microsoft excel application defaultly, we also open this csv file with excel and add some data.
Load csv data with pandas
We will use pandas to load csv data into pandas dataframe.
import pandas as pd csv_file = 'pandas_csv.csv' df = pd.read_csv(csv_file) print(df)
Then you will find this ParserError.
Open this csv file with notepad
Notepad is a good text editor, we use it to open this csv file. You may find
data in this csv file is garbled. Which tell us we should add our data with notepad, not excel.
Add data with notepad
We open our csv file with notepad and add our data int this file.
Then load data with pandas again, we will get result like this:
Acc1\tAcc2 0 80.0%\t81.20% 1 81.20%\t83.10% 2 81.6%\t83.40% 3 84.2%\t84.25% 4 82.6%\t80.30% 5 85.10%\t81.20%
This error is fixed.