时间戳

首页 > 解决方案 > Python：TypeError：不可排序的类型：int() <= NoneType()

python - Python：TypeError：不可排序的类型：int() <= NoneType()

问题描述

我试图在 Python 3.4 中简单地打开一个 .xls 文件，但一直收到此错误：

TypeError: unorderable types: int() <= NoneType()

这是我的代码：

import pandas as pd
file = r"directory_path"
df = pd.ExcelFile(file)
data = df.parse(1)

当我尝试只运行前三行时，我仍然收到错误。

这是错误的完整扩展：

Traceback (most recent call last):

  File "<ipython-input-16-278e482d38eb>", line 2, in <module>
    df = pd.ExcelFile(r"I:\usr\m1ars04\model_dev\test\suptot.xls")

  File "C:\Anaconda3\lib\site-packages\pandas\io\excel.py", line 169, in __init__
    self.book = xlrd.open_workbook(io)

  File "C:\Anaconda3\lib\site-packages\xlrd\__init__.py", line 435, in open_workbook
    ragged_rows=ragged_rows,

  File "C:\Anaconda3\lib\site-packages\xlrd\book.py", line 107, in open_workbook_xls
    bk.fake_globals_get_sheet()

  File "C:\Anaconda3\lib\site-packages\xlrd\book.py", line 687, in fake_globals_get_sheet
    self.get_sheets()

  File "C:\Anaconda3\lib\site-packages\xlrd\book.py", line 678, in get_sheets
    self.get_sheet(sheetno)

  File "C:\Anaconda3\lib\site-packages\xlrd\book.py", line 669, in get_sheet
    sh.read(self)

  File "C:\Anaconda3\lib\site-packages\xlrd\sheet.py", line 1470, in read
    self.update_cooked_mag_factors()

  File "C:\Anaconda3\lib\site-packages\xlrd\sheet.py", line 1538, in update_cooked_mag_factors
    elif not (10 <= zoom <= 400):

TypeError: unorderable types: int() <= NoneType()

标签： pythonpandastypeerrorxls

解决方案

推荐阅读