blocks|key|2557306|text|你试过吗？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2557307|df+=+pd.read_csv("Users/alekseinabatov/Documents/Python/FBI-CRIME11.csv")|code-block|syntax|javascript|2557308|或者也许|2557309|df+=+pd.read_csv('Users/alekseinabatov/Documents/Python/"FBI-CRIME11.csv"')|2557310|(如果文件名有引号)|2557311|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Have you tried?

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

or maybe

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

(If the file name has quotes)

blocks|key|2557320|text|仅指文件名，如|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2557321|df+=+pd.read_csv("FBI-CRIME11.csv")|code-block|syntax|javascript|2557322|通常，只有当文件与脚本位于同一个目录时才能工作。|2557323|如果使用的是windows，请确保按如下方式指定文件的路径：|2557324|PATH+=+"C:\\Users\\path\\to\\file.csv"|2557325|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|S|8|@]|9|@]|A|$E|F]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

Just referring to the filename like

<pre><code>df = pd.read_csv("FBI-CRIME11.csv")
</code></pre>

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:

<pre><code>PATH = "C:\\Users\\path\\to\\file.csv"
</code></pre>

blocks|key|2557382|text|路径出现问题时，您需要指定第一个“/”才能使其工作！我在macOS上使用VSCode/Python|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2557383|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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

blocks|key|2148345|text|我也经历了同样的问题，我解决了如下：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2148346|dataset+=+pd.read_csv('C:\\Users\\path\\to\\file.csv')|code-block|syntax|javascript|2148347|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I also experienced the same problem I solved as follows:

<pre><code>dataset = pd.read_csv('C:\\Users\\path\\to\\file.csv')
</code></pre>

blocks|key|2557412|text|在jupyter笔记本上，它为我工作，只包括相对路径。例如：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2557413|df+=+pd.read_csv+('file.csv')|code-block|syntax|javascript|2557414|但是，例如，在vscode中，我必须放置完整的路径：|2557415|df+=+pd.read_csv+('/home/code/file.csv')|2557416|entityMap^0|1|A|0|0|7|6|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|P|$]]

Being on jupyter notebook it works for me including the relative path only. For example:

<pre><code>df = pd.read_csv ('file.csv')
</code></pre>

But, for example, in vscode I have to put the complete path:

<pre><code>df = pd.read_csv ('/home/code/file.csv')
</code></pre>

blocks|key|1339223|text|您在用户之前丢失了“/”。我假设您使用的是文件路径名中的MAC猜测。根目录是'/‘。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1339224|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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

blocks|key|1336478|text|我也遇到了同样的问题，但它之所以发生，是因为我的文件名为"geo_data.csv.csv“--新的笔记本电脑没有显示文件扩展名，所以在Windows中这个名称问题是不可见的。很傻，我知道，但是如果这个解决方案对你不管用，那就试试:-)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1336479|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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 :-)

blocks|key|2557506|text|只需更改CSV文件名即可。一旦我为自己换了它，它就能正常工作。以前我给了data.csv，然后我把它改成了CNC_1.csv。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2557507|entityMap^0|10|8|1H|9|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

Just change the CSV file name. Once I changed it for me, it worked fine. Previously I gave <code>data.csv</code> then I changed it to <code>CNC_1.csv</code>.

blocks|key|2148442|text|对我有用的是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2148443|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='%7C')
++++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+%7C,+and+appends+to+list+which+is+converted+to+a+pandas+df+(taking+15+columns)|code-block|syntax|javascript|2148444|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

What worked for me: 

<pre><code>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)
</code></pre>

blocks|key|2148356|text|确保以.csv格式保存源文件。我尝试了将完整路径添加到文件的所有步骤，包括和删除header=0，添加skiprows=0，但是没有任何操作，因为我以工作簿格式而不是CSV格式保存了excel文件(数据文件)。所以请记住，首先检查您的文件扩展名。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2148357|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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.

blocks|key|1336510|text|阿德纳的回答帮了我。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1336511|这是我在mac上的完整代码，希望这能帮到别人。我所有的csv文件都保存在/Users/lionelyu/Documents/Python/Python项目/|1336512|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+%2B+'AAPL_CLOSE.csv',index_col='Date',parse_dates=True)
cisco+=+pd.read_csv(path+%2B+'CISCO_CLOSE.csv',index_col='Date',parse_dates=True)
ibm+=+pd.read_csv(path+%2B+'IBM_CLOSE.csv',index_col='Date',parse_dates=True)
amzn+=+pd.read_csv(path+%2B+'AMZN_CLOSE.csv',index_col='Date',parse_dates=True)|code-block|syntax|javascript|1336513|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

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/

<pre><code>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)
</code></pre>

blocks|key|2148419|text|首先在cli中运行"pwd“命令，找出您当前项目的方向，然后将文件的名称添加到您的路径中！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2148420|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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!

blocks|key|1339299|text|在我的例子中，我刚刚从最后删除了.csv。我用的是ubuntu。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1339300|pd.read_csv("/home/mypc/Documents/pcap/s2csv")|code-block|syntax|javascript|1339301|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In my case I just removed .csv from the end. I am using ubuntu.

<pre><code>pd.read_csv("/home/mypc/Documents/pcap/s2csv")
</code></pre>

blocks|key|2148512|text|如果您得到这类错误
然后修复目录的路径。|type|blockquote|depth|inlineStyleRanges|entityRanges|data|2148513|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|E|8|@]|9|@]|A|$]]|$1|B|3|-4|5|C|7|F|8|@]|9|@]|A|$]]]|D|$]]

<blockquote>
If you get this type of Error
Then fix the path of the directory
</blockquote>

blocks|key|2148630|text|有时我们忽略一个小问题，它不是、Python、或IDE的错误，它的逻辑错误我们假设文件.csv不是.csv文件，它是Excell工作表文件。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2148631|​|2148632|📷|atomic|2148633|2148634|当您尝试使用Import编译器打开该文件时，将通过错误查看|2148635|2148636|2148637|解决问题|2148638|将目标文件打开到Microsoft中并以.csv格式保存该文件--注意编码很重要，因为它将帮助您在尝试用|2148639|with+open('YourTargetFile.csv','r',encoding='UTF-8')+as+file:|code-block|syntax|javascript|2148640|2148641|2148642|2148643|所以你准备好了，现在试着像下面这样打开你的文件|2148644|import+csv
with+open('plain.csv','r',encoding='UTF-8')+as+file:
load+=+csv.reader(file)
for+line+in+load:
++++print(line)|2148645|这是输出|2148646|2148647|2148648|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/945f5fd415f269bbaa105cf153a2879d.png|imageAlt|1|https://developer.qcloudimg.com/http-save/yehe-900000/cfb94c2ce124b2817f8036910b0884e9.png|2|https://developer.qcloudimg.com/http-save/yehe-900000/540e3d15bf7fedec71210a49d22bc93b.png|3|https://developer.qcloudimg.com/http-save/yehe-900000/ad03582df39a8fe0c01fe1ea6469b393.png^0|F|8|O|3|0|0|0|1|0|0|0|0|0|1|1|0|0|0|0|0|0|0|1|2|0|0|0|0|0|0|1|3|0|0^^$0|@$1|2|3|4|5|6|7|1O|8|@$9|1P|A|1Q|B|C]|$9|1R|A|1S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1T|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|1U|8|@]|D|@$9|1V|A|1W|1|1X]]|E|$]]|$1|K|3|G|5|6|7|1Y|8|@]|D|@]|E|$]]|$1|L|3|M|5|6|7|1Z|8|@]|D|@]|E|$]]|$1|N|3|I|5|J|7|20|8|@]|D|@$9|21|A|22|1|23]]|E|$]]|$1|O|3|G|5|6|7|24|8|@]|D|@]|E|$]]|$1|P|3|Q|5|6|7|25|8|@]|D|@]|E|$]]|$1|R|3|S|5|6|7|26|8|@]|D|@]|E|$]]|$1|T|3|U|5|V|7|27|8|@]|D|@]|E|$W|X]]|$1|Y|3|G|5|6|7|28|8|@]|D|@]|E|$]]|$1|Z|3|I|5|J|7|29|8|@]|D|@$9|2A|A|2B|1|2C]]|E|$]]|$1|10|3|G|5|6|7|2D|8|@]|D|@]|E|$]]|$1|11|3|12|5|6|7|2E|8|@]|D|@]|E|$]]|$1|13|3|14|5|V|7|2F|8|@]|D|@]|E|$W|X]]|$1|15|3|16|5|6|7|2G|8|@]|D|@]|E|$]]|$1|17|3|I|5|J|7|2H|8|@]|D|@$9|2I|A|2J|1|2K]]|E|$]]|$1|18|3|G|5|6|7|2L|8|@]|D|@]|E|$]]|$1|19|3|-4|5|6|7|2M|8|@]|D|@]|E|$]]]|1A|$1B|$5|1C|1D|1E|E|$1F|1G|1H|-4]]|1I|$5|1C|1D|1E|E|$1F|1J|1H|-4]]|1K|$5|1C|1D|1E|E|$1F|1L|1H|-4]]|1M|$5|1C|1D|1E|E|$1F|1N|1H|-4]]]]

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

<hr>

<a href="https://i.stack.imgur.com/faP5r.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/faP5r.png" alt="Tiktok file which is worksheet file not a CSV file Shown in Green border"></a>

<hr>

When you try to open that file using Import compiler will through the error 
have a look
<a href="https://i.stack.imgur.com/45q7n.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/45q7n.png" alt="enter image description here"></a>

<h2>To Resolve the issue</h2>

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 

<pre><code>with open('YourTargetFile.csv','r',encoding='UTF-8') as file:
</code></pre>

<a href="https://i.stack.imgur.com/qjjqL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qjjqL.png" alt="enter image description here"></a>

So you are set to go 
now Try to open your file as this

<pre><code>import csv
with open('plain.csv','r',encoding='UTF-8') as file:
load = csv.reader(file)
for line in load:
 print(line)
</code></pre>

Here is the Output
<a href="https://i.stack.imgur.com/sxDF7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sxDF7.png" alt="Plain.csv File Running"></a>

blocks|key|2557652|text|对我有用的是|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2557653|dataset+=+pd.read_csv('FBI_CRIME11.csv')|code-block|syntax|javascript|2557654|高亮显示并按enter键。它还取决于您正在使用的IDE。我正在使用Anaconda+Spyder或木星。|2557655|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

What works for me is

<pre><code>dataset = pd.read_csv('FBI_CRIME11.csv')
</code></pre>

Highlight it and press enter. It also depends on the IDE you are using. I am using Anaconda Spyder or Jupiter.

blocks|key|2148470|text|我用的是Mac。我遇到了同样的问题，.csv文件位于放置python脚本的同一个文件夹中，但是Spyder仍然无法找到该文件。我把文件名从大写字母改成了所有小写字母，它起了作用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2148471|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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.

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:

<pre><code>import pandas as pd 

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

print(df.head())
</code></pre>

I get an error message, which ends with 

<blockquote>
 OSError: File b'FBI-CRIME11.csv' does not exist
</blockquote>

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

When i try to run it this way:

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

I get another error:

<blockquote>
 NameError: name 'Users' is not defined
</blockquote>

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!

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

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我目前正在学习用于数据分析的Pandas，以及在Atom编辑器中读取csv文件时遇到的一些问题。当我运行以下代码时：import pandas as pd df = pd.read_csv("FBI-CRIME11.csv")print(df.head())我收到一条错误消息，以OSError: b‘’FBI CRIME11.csv‘文件不存在下面是文件的目录: /Users/alekseinab

问嵌入引号的文件名"CSV文件不存在“
EN

回答 17

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问嵌入引号的文件名"CSV文件不存在“EN

回答 17

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问嵌入引号的文件名"CSV文件不存在“
EN