使用pandas在python中读取excel文件

Question

我正在尝试用pandas在pycharm中读取excel文件。我成功地安装了这个包。我的问题是，我试图使用文件的位置，除了它的名称，我尝试了许多事情，如下所示：

import pandas as pd
fileLocation = "C:\\Users\\GTS\\Desktop\\Network Interdiction Problem\\Manuscript\\Interdiction_Data.xlsx"
fileName = 'Interdiction_Data.xlsx'
data = pd.read_excel('fileLocation'+'fileName')

但是，我一直收到以下错误

Traceback (most recent call last):
  File "C:/Users/GTS/PycharmProjects/Reliability1/Reliability1.py", line 4, in <module>
    data = pd.read_excel('fileLocation'+'fileName')
  File "C:\Users\GTS\PycharmProjects\Reliability1\venv\lib\site-packages\pandas\io\excel\_base.py", line 304, in read_excel
    io = ExcelFile(io, engine=engine)
  File "C:\Users\GTS\PycharmProjects\Reliability1\venv\lib\site-packages\pandas\io\excel\_base.py", line 824, in __init__
    self._reader = self._engines[engine](self._io)
  File "C:\Users\GTS\PycharmProjects\Reliability1\venv\lib\site-packages\pandas\io\excel\_xlrd.py", line 21, in __init__
    super().__init__(filepath_or_buffer)
  File "C:\Users\GTS\PycharmProjects\Reliability1\venv\lib\site-packages\pandas\io\excel\_base.py", line 353, in __init__
    self.book = self.load_workbook(filepath_or_buffer)
  File "C:\Users\GTS\PycharmProjects\Reliability1\venv\lib\site-packages\pandas\io\excel\_xlrd.py", line 36, in load_workbook
    return open_workbook(filepath_or_buffer)
  File "C:\Users\GTS\PycharmProjects\Reliability1\venv\lib\site-packages\xlrd\__init__.py", line 111, in open_workbook
    with open(filename, "rb") as f:
FileNotFoundError: [Errno 2] No such file or directory: 'fileLocationfileName'

有什么想法吗？

提前感谢

Answer 1

fileLocation变量包含文件的名称。阅读fileLocation + fileName实质上就是阅读

C:\\Users\\GTS\\Desktop\\Network Interdiction Problem\\Manuscript\\Interdiction_Data.xlsxInterdiction_Data.xlsx

另一个问题是，在调用pd.read_excel()时，变量名称两边有引号，这意味着要将字符串传递给函数。

尝试：

data = pd.read_excel(fileLocation)

Answer 2

我在你的代码中发现了一些问题...首先，让我们从pd.read_excel()文档开始：https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html

如果文件保存在当前工作目录中，只需将文件名传递给函数即可。

import pandas as pd
fileName = 'Interdiction_Data.xlsx'
data = pd.read_excel(fileName) # notice that when we call an object, we didn't use quotation marks.

但是，如果您的文件不在当前目录中，只需传递该文件的路径或您称为"filelocation“的路径即可。

import pandas as pd
fileLocation = "C:\\Users\\GTS\\Desktop\\Network Interdiction Problem\\Manuscript\\Interdiction_Data.xlsx"
data = pd.read_excel(fileLocation) # notice that when we call an object, we didn't use quotation marks.

提示:为了避免文件路径或目录名的一些错误或问题，请尽量不要使用空格，因此请将单词分开...

希望你能解决你的问题。