python - "CSV file does not exist" for a filename with embedded quotes

Question

I am currently learning Pandas for data analysis and having some issues reading a csv file in Atom editor.

When I am running the following code:

import pandas as pd 

df = pd.read_csv("FBI-CRIME11.csv")

print(df.head())

I get an error message, which ends with

OSError: File b'FBI-CRIME11.csv' does not exist

Here is the directory to the file: /Users/alekseinabatov/Documents/Python/"FBI-CRIME11.csv".

When i try to run it this way:

df = pd.read_csv(Users/alekseinabatov/Documents/Python/"FBI-CRIME11.csv")

I get another error:

NameError: name 'Users' is not defined

I have also put this directory into the "Project Home" field in the editor settings, though I am not quite sure if it makes any difference.

I bet there is an easy way to get it to work. I would really appreciate your help!

Answer 1

Have you tried?

df = pd.read_csv("Users/alekseinabatov/Documents/Python/FBI-CRIME11.csv")

or maybe

df = pd.read_csv('Users/alekseinabatov/Documents/Python/"FBI-CRIME11.csv"')

(If the file name has quotes)