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

User · Answer

You are missing     before Users  I assume that you are using a MAC guessing from the file path names  You root directory is

User · Answer

I am using a Mac  I had the same problem wherein  csv file was in the same folder where the python script was placed  however  Spyder still was unable to locate the file  I changed the file name from capital letters to all small letters and it worked

User · Answer

Sometimes we ignore a little bit issue which is not a Python or IDE fault its logical error  We assumed a file  csv which is not a  csv file its a Excell Worksheet file have a look        When you try to open that file using Import compiler will through the error  have a look   To Resolve the issue  open your Target file into Microsoft Excell and save that file in  csv format it is important to note that Encoding is important because it will help you to open the file when you try to open it with   with open  YourTargetFile csv   r  encoding  UTF-8   as file      So you are set to go  now Try to open your file as this  import csv with open  plain csv   r  encoding  UTF-8   as file  load   csv reader file  for line in load      print line    Here is the Output

User · Answer

Run  pwd  command first in cli to find out what is your current project s direction and then add the name of the file to your path

User · Answer

What works for me is  dataset   pd read csv  FBI CRIME11 csv     Highlight it and press enter  It also depends on the IDE you are using  I am using Anaconda Spyder or Jupiter

User · Answer

In my case I just removed  csv from the end  I am using ubuntu   pd read csv   home mypc Documents pcap s2csv

User · Answer

What worked for me    import csv import pandas as pd import os  base  os path normpath r path      with open base   r   as csvfile      readCSV   csv reader csvfile  delimiter          data        for row in readCSV          data append row      df   pd DataFrame data 1   columns data 0  0 15       print df    This reads in the file   delimit by    and appends to list which is converted to a pandas df  taking 15 columns

User · Answer

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

User · Answer

If you get this type of Error Then fix the path of the directory

User · Answer

Try this   import os  cd   os getcwd   dataset train   pd read csv cd   Google Stock Price Train csv

User · Answer

I had the same issue  but it was happening because my file was called  geo data csv csv  - new laptop wasn t showing file extensions  so the name issue was invisible in Windows Explorer   Very silly  I know  but if this solution doesn t work for you  try that  -

User · Answer

Just change the CSV file name  Once I changed it for me  it worked fine  Previously I gave data csv then I changed it to CNC 1 csv

User · Answer

I also experienced the same problem I solved as follows   dataset   pd read csv  C   Users  path  to  file csv

User · Answer

Make sure your source file is saved in  csv format  I tried all the steps of adding the full path to the file  including and deleting the header 0  adding skiprows 0  but nothing works as I saved the excel file data file  in workbook format and not in CSV format  so keep in mind to first check your file extension

User · Answer

Being on jupyter notebook it works for me including the relative path only  For example   df   pd read csv   file csv     But  for example  in vscode I have to put the complete path   df   pd read csv    home code file csv

User · Answer

Adnane s answer helped me   Here s my full code on mac  hope this helps someone  All my csv files are saved in  Users lionelyu Documents Python Python Projects   import numpy as np import pandas as pd import matplotlib pyplot as plt plt style use  ggplot    path     Users lionelyu Documents Python Python Projects    aapl   pd read csv path    AAPL CLOSE csv  index col  Date  parse dates True  cisco   pd read csv path    CISCO CLOSE csv  index col  Date  parse dates True  ibm   pd read csv path    IBM CLOSE csv  index col  Date  parse dates True  amzn   pd read csv path    AMZN CLOSE csv  index col  Date  parse dates True

User · Answer

Just referring to the filename like  df   pd read csv  FBI-CRIME11 csv     generally only works if the file is in the same directory as the script   If you are using windows  make sure you specify the path to the file as follows   PATH    C   Users  path  to  file csv

User · Answer

Had an issue with the path  it turns out that you need to specify the first     to get it to work  I am using VSCode Python on macOS

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

Examples related to python

Examples related to csv

Examples related to pandas

Examples related to atom-editor