Anaconda IDE无法读取csv文件 [英] Unable to read csv file by Anaconda IDE

问题描述

我的Anaconda IDE无法使用panda.read_csv()函数读取csv文件.

My Anaconda IDE is unable to read csv file using panda.read_csv() function.

文件名是棒球，保存在位置 C:\ Users \ Firdaus \ Desktop

File name is baseball which is kept at location C:\Users\Firdaus\Desktop

我写了以下代码:

# Import pandas as pd
import pandas as pd
# Import the cars.csv data as Base
Base = pd.read_csv('C:\Users\Firdaus\Desktop\baseball.csv')
# Print out Base
print(Base)

错误是:

SyntaxError:(unicode错误)"unicodeescape"编解码器无法解码字节 位置2-3:截断\ UXXXXXXXX逃脱

SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape

推荐答案

在常规python字符串中，\ U字符组合表示扩展的Unicode代码点转义. 您可以使用以下之一:

In regular python strings, the \U character combination signals an extended Unicode codepoint escape. You can use one of the following:

r'C:\Users\Firdaus\Desktop\baseball.csv' #r stands for raw strings
'C:\\Users\\Firdaus\\Desktop\\baseball.csv' #using double slashes
'C:/Users/Firdaus/Desktop/baseball.csv' #using forward slashes

希望这会有所帮助.

这篇关于Anaconda IDE无法读取csv文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！