如何将csv文件格式加载到jupyter笔记本？

Question

我试图从本地存储中读取一个具有CSV扩展名的文件，但它给了我以下错误消息

File "<ipython-input-12-bbfa50761a08>", line 5
    data=pd.read_csv("C:\Users\user\Documents\Projects\Data Science\weather_data.csv")
                    ^
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape

我该怎么办

Answer 1

首先尝试加载像numpy和pandas这样的包，然后尝试加载数据

import numpy as np

import pandas as pd

data=pd.read_csv("C:\Users\user\Documents\Projects\Data Science\weather_data.csv")
print(data)

data.head

Answer 2

请尝试：

import numpy as np
import pandas as pd

data=pd.read_csv(r"C:\Users\user\Documents\Projects\Data Science\weather_data.csv")

Answer 3

尝试缩短路径（参见参考资料），然后执行以下操作：

import numpy as np
import pandas as pd

data = pd.read_csv(r"C:\Users\user\Documents\weather_data.csv")
print(data)

参考：How to load CSV file in Jupyter Notebook?