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

我建议两件事

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

• 键入绝对路径（代码段中的等式），并告诉索引、分隔符和小数。代码例如：

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

Answer 2

尝试不使用双反斜杠，而是使用一个反斜杠，并在路径前面添加r，这将仅读取文件。我假定您正在使用整个路径，例如"C:\Spyder\california\housing.csv"（？）

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