Skip to main content
 首页 » 编程设计

python之在 python 3.7 中导入 pandas 时出错

2024年12月31日6www_RR

导入panda时出现错误

Traceback (most recent call last): 
  File "C:/Users/kj/PycharmProjects/kj/parsing.py", line 5, in <module> 
    import pandas 
  File "H:\Python\New\lib\pandas\__init__.py", line 23, in <module> 
    from pandas.compat.numpy import * 
  File "H:\Python\New\lib\pandas\compat\__init__.py", line 421, in <module> 
    if LooseVersion(dateutil.__version__) < LooseVersion('2.5'): 
  File "C:\Program Files\Python\Python37\Lib\distutils\version.py", line 52, in __lt__ 
    c = self._cmp(other) 
  File "C:\Program Files\Python\Python37\Lib\distutils\version.py", line 337, in _cmp 
    if self.version < other.version: 
TypeError: '<' not supported between instances of 'str' and 'int' 
 
import pandas 
df = pandas.read_excel(open('Test.csv','rb'), sheetname='Sheet 1') 
grouped = df.groupby('Date (IT)') 

请您参考如下方法:

看起来您的 Date (IT) 列具有混合值(字符串和整数、日期或缺失值)。因此,当 pandas 尝试比较每个值时,由于类型不同,它会失败。请查看列数据并确保所有数据的格式均有效。