Importing a file using pandas

Question

Data visualisation: I want to import a file using pandas. I assigned a variable and file name given is correct but it shows a error message as file does not exist

Code: sample_data = pd.read_csv('sample_data.csv')

Answer 1

You're probably in the wrong working directory. Run os.getcwd() to check. If so, you can either change working directories with os.chdir() or give an absolute path to the file instead of a relative path.

If you're already in the right working directory, run os.listdir() to make sure the file is actually there.

Answer 2

Ok, in this case, what you will have to do is get the path file by right-clicking on the file and going to properties(Windows, don't know about Mac). Then just copy the file path and paste it instead of the file name. So for now, it should be something like this(as I don't know your file path):

sample_data = pd.read_csv('C:\Users\SVISHWANATH\Downloads\datasets')

Now, after the last folder, give in your file name. So now, it should look like this:

sample_data = pd.read_csv('C:\Users\SVISHWANATH\Downloads\datasets\sample_data.csv')

However, this will still not work as the slashes need to be the other way. Because of this, there will have to be an r before the quotes.

sample_data = pd.read_csv(r'C:\Users\SVISHWANATH\Downloads\datasets\sample_data.csv')

Now this should work as all the requirements are met.

Answer 3

You need to store the .csv file in a folder where the actual program is stored, otherwise you have to give a proper path to the file:

sample_data = pd.read_csv('filepath')