Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
185 views
in Technique[技术] by (71.8m points)

python - While reading a csv file i am getting a parser error , when given in list it is giving the same error what should I do to avoid the error

This is the code:

pd.read_csv('https://github.com/vincentarelbundock/Rdatasets/blob/master/datasets.csv',skiprows=[69,88],header=None)

I am getting following error:

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

I have tried skipping the rows When giving individual skiprow value it works for one , but when given in list (rows to skip) it shows the above error.

question from:https://stackoverflow.com/questions/65830124/while-reading-a-csv-file-i-am-getting-a-parser-error-when-given-in-list-it-is

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

The thing is when you are fetching it using this url, you are getting the web page and not csv. To get csv click on the raw button which is there and then use that url. Use the below and you'd get it correctly.

import pandas as pd

data = pd.read_csv('https://raw.githubusercontent.com/vincentarelbundock/Rdatasets/master/datasets.csv')
data.head()

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...