Opening local saved files with pandas

Question

i'm doing my first experiments with pandas and I can't succeed in opening a locally stored file.

the path of the file is the following:

:\Users\MATTEO\Desktop

and the name of the file is yelp.csv

I'm trying the following code (Python 3)

import pandas as pd


yelp_raw_data = pd.read_csv(":\Users\MATTEO\Desktop\yelp.csv")

What is the error you receive? Are you using Windows? Also are you sure the path isn't `'C:\...'`. — ALollz, Oct 30 '18 at 20:23

score 0 · Accepted Answer · answered Oct 30 '18 at 20:30

0

if yelp.csv is in the same directory as your .py file,

yelp_raw_data = pd.read_csv("yelp.csv")

should work fine.

answered Oct 30 '18 at 20:30

Captain Trips

score 0 · Answer 2 · answered Oct 30 '18 at 22:12

0

If you're ever having trouble with the file path, you can use the absolute path:

import pandas as pd
import os

yelp_raw_data = pd.read_csv(os.path.abspath("MATTEO\Desktop\yelp.csv"))

answered Oct 30 '18 at 22:12

user1394

2 Answers2