Import an excel csv file in python

Question

I am currently struggling to import an excel-csv file to python. I'm sure my problem is very easy to solve, but I'm quite new to programming in python.

The code I used:

train1 = pd.read_csv(r"D:\Foldername1\Foldername2\data.csv")

Then I get this kind of error:

  File "pandas\_libs\parsers.pyx", line 697, in pandas._libs.parsers.TextReader._setup_parser_source

OSError: Initializing from file failed

I thought about the need to add something like sep=',' but this didn't work either. So I'm kinda helpless at the moment. Thank you very much already! :)

Does this answer your question? OSError: Initializing from file failed on csv in Pandas — gold_cy
– gold_cy, Commented Jan 19, 2020 at 14:35

Saroj Rai · Accepted Answer · 2020-01-19 14:56:38Z

0

try this,

train1 = pd.read_csv(r"D:\Foldername1\Foldername2\data.csv", engine='python')

If raises Permission denied, then give read permission to your file.

edited Jan 19, 2020 at 14:56

answered Jan 19, 2020 at 14:46

Saroj Rai

1,66915 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

Import an excel csv file in python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related