Pandas, ParserError: Error tokenizing data

Question

I'm studying the book "Python for Data Analysis (written by Wes McKinney)."

While working on CH10, I had a problem.

The code below is what I wrote in Google Colab.

!wget https://github.com/wesm/pydata-book/blob/2nd-edition/examples/stock_px_2.csv

close_px = pd.read_csv('stock_px_2.csv', parse_dates=True, index_col=0)

close_px.head()

Then I got this error.

ParserError: Error tokenizing data. C error: Expected 1 fields in line 107, saw 2

How can I fix this?

Thanks!

try using the link https://raw.githubusercontent.com/wesm/pydata-book/2nd-edition/examples/stock_px_2.csv — arshovon
– arshovon, Commented Jan 7, 2022 at 7:45

arshovon · Accepted Answer · 2022-01-07 07:47:20Z

1

Using the raw CSV file, I can read the values:

import pandas as pd

csv_url = "https://raw.githubusercontent.com/wesm/pydata-book/2nd-edition/examples/stock_px_2.csv"
close_px = pd.read_csv(csv_url, parse_dates=True, index_col=0)
print(close_px.head())

Output:

            AAPL   MSFT    XOM     SPX
2003-01-02  7.40  21.11  29.22  909.03
2003-01-03  7.45  21.14  29.24  908.59
2003-01-06  7.45  21.52  29.96  929.01
2003-01-07  7.43  21.93  28.95  922.93
2003-01-08  7.28  21.31  28.83  909.93

answered Jan 7, 2022 at 7:47

arshovon

13.7k9 gold badges54 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pandas, ParserError: Error tokenizing data

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related