使用Pandas读取CSV文件遇错误,求正确文件路径格式
解决Pandas读取文件时的OSError问题
核心问题
你的路径字符串开头包含了不可见的Unicode控制字符(\u202a,左到右嵌入标记),这是从资源管理器复制路径时自动带入的隐藏字符,直接导致路径解析失败。
可行的路径格式与解决方案
1. 手动输入路径(彻底避免隐藏字符)
不要从文件夹复制路径,直接手动敲入完整路径:
import pandas as pd user = pd.read_csv(r"C:\Users\Luca\Documents\ml-100k\u.user", sep="|", names=["User ID","Age","Gender","Occupation","Zip Code"])
2. 清理复制的路径
如果要复制路径,先把路径粘贴到记事本中,再重新复制纯文本内容(此时隐藏字符会被过滤),再用于代码:
import pandas as pd user = pd.read_csv("C:/Users/Luca/Documents/ml-100k/u.user", sep="|", names=["User ID","Age","Gender","Occupation","Zip Code"])
3. 使用相对路径(更便捷)
将u.user文件放到你的Python脚本同一目录下,直接用文件名读取:
import pandas as pd user = pd.read_csv("u.user", sep="|", names=["User ID","Age","Gender","Occupation","Zip Code"])
4. 用pathlib库处理路径(推荐)
Python的pathlib库会自动适配系统路径格式,避免手动拼接的字符问题:
from pathlib import Path import pandas as pd file_path = Path("C:/Users/Luca/Documents/ml-100k/u.user") user = pd.read_csv(file_path, sep="|", names=["User ID","Age","Gender","Occupation","Zip Code"])
内容的提问来源于stack exchange,提问作者luca dahlmann
相关产品推荐
相关产品推荐

