导入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 尝试比较每个值时,由于类型不同,它会失败。请查看列数据并确保所有数据的格式均有效。
