Spyder - Python CSV加载

Question

我想在spyder中加载csv文件：

import pandas as pd
california = pd.read_csv("...\\Spyder\\california\\housing.csv")

但是我得到了这个错误：

Reloaded modules: ipykernel, ipykernel._version, ipykernel.connect, ipykernel.kernelapp, zmq.eventloop, zmq.eventloop.ioloop, tornado.platform, tornado.platform.asyncio, tornado.gen, zmq.eventloop.zmqstream, ipykernel.iostream, jupyter_client.session, jupyter_client.jsonutil, jupyter_client.adapter, ipykernel.heartbeat, ipykernel.ipkernel, IPython.utils.tokenutil, ipykernel.comm, ipykernel.comm.manager, ipykernel.comm.comm, ipykernel.kernelbase, tornado.queues, tornado.locks, ipykernel.jsonutil, ipykernel.zmqshell, IPython.core.payloadpage, ipykernel.displayhook, ipykernel.datapub, ipykernel.serialize, ipykernel.pickleutil, ipykernel.codeutil, ipykernel.eventloops, ipykernel.parentpoller, pyparsing, cycler, kiwisolver, win32api, win32security, ntsecuritycon, IPython.core.completerlib, storemagic, autoreload, PIL, PIL._version, PIL.Image, PIL.ImageMode, PIL.TiffTags, PIL._binary, PIL._util, PIL._imaging, cffi, cffi.api, cffi.lock, cffi.error, cffi.model, PIL.PngImagePlugin, PIL.ImageChops, PIL.ImageFile, PIL.ImagePalette, PIL.GimpGradientFile, PIL.GimpPaletteFile, PIL.ImageColor, PIL.PaletteFile, PIL.ImageSequence, dateutil.rrule, mpl_toolkits.mplot3d, mpl_toolkits.mplot3d.axes3d, mpl_toolkits.mplot3d.art3d, mpl_toolkits.mplot3d.proj3d, mpl_toolkits.mplot3d.axis3d, ipykernel.pylab, ipykernel.pylab.backend_inline, ipykernel.pylab.config, spyder, spyder.pil_patch

我已经更新了Python和Spyder，但错误一直出现。

编辑:不知道我做了什么，但现在已经修复了，魔术！Thx

Answer 1

尝试不使用双反斜杠，而是使用双反斜杠，并在路径前面添加r，这将只读取文件。我假设您使用的是整个路径，例如"C:\Spyder\california\housing.csv" (?)

import pandas as pd
california = pd.read_csv(r"...\Spyder\california\housing.csv")

Answer 2

我建议做两件事，

• 尝试将文件移动到同一文件夹中，这样您就可以像阅读pd.read_csv("housing.csv")

一样阅读它

• 类型绝对路径，(等式在代码片段中)，并告诉熊猫yoru index_col，分隔符和小数。代码例如。：

california = pd.read_csv("C:/Spyder/california/housing.csv"", index_col=0, sep=',', decimal='.')