文件xlsb:[Errno 2]没有这样的文件或目录：

Question

我试图打开一个CSV文件，但由于某种原因python无法找到它

import pandas as pd
base = pd.read_excel("C:\\Users\\Ricardo\\Downloads\\PRODUÇÃO_TELA_UNICA_2020_06_10.xlsb", sheet_name = "PRODUÇÃO_TELA_UNICA")

FileNotFoundError: [Errno 2] No such file or directory: 'C:\\Users\\Ricardo\\Downloads\\PRODUÇÃO_TELA_UNICA_2020_06_10.xlsb'

Answer 1

尝试设置二进制文件引擎：

import pandas as pd
df = pd.read_excel('path_and_filename.xlsb', engine='pyxlsb')

您可能还希望将路径设置为原始字符串，如下所示：

path = r"C:\Users\Ricardo\Downloads\PRODUÇÃO_TELA_UNICA_2020_06_10.xlsb"
df = pd.read_excel(path, engine='pyxlsb')

或者更好地使用os.path方法，如下所示：

import pandas as pd
import os
path = os.path.join(r"C:\Users\Ricardo\Downloads", r"PRODUÇÃO_TELA_UNICA_2020_06_10.xlsb")
df = pd.read_excel(path, engine='pyxlsb')

Answer 2

打开文件目录，按下键盘上的shift按钮，然后按下鼠标右键 按下shift时，开发人员模式处于活动状态，您可以从打开的窗口复制文件的拉取路径 然后你应该把它粘贴到r-string 最后会是这样

file_path = r"C:\Users\Ricardo\Downloads\TELA_UNICA.xlsb"