我像这样用UInt64Index设置数据框

df = pandas.DataFrame([[1,2,3],[4,5,9223943912072220999],[7,8,9]], columns=['a','b','c'])

df = df.set_index('c')

>>> df

a b

c

3 1 2

9223943912072220999 4 5

9 7 8

>>> df.index

UInt64Index([3, 9223943912072220999, 9], dtype='uint64', name=u'c')

现在尝试通过索引值访问元素适用于较小的值

>>> df.index[0]

3

>>> df.loc[3]

a 1

b 2

Name: 3, dtype: int64

但是尝试对大价值做同样的事情会导致错误

>>> df.index[1]

9223943912072220999

>>> df.loc[9223943912072220999]

Traceback (most recent call last):

File "", line 1, in

File "/home/u1/mprager/.virtualenvs/jupyter/local/lib/python2.7/site-packages/pandas/core/indexing.py", line 1373, in __getitem__

return self._getitem_axis(maybe_callable, axis=axis)

File "/home/u1/mprager/.virtualenvs/jupyter/local/lib/python2.7/site-packages/pandas/core/indexing.py", line 1626, in _getitem_axis

self._has_valid_type(key, axis)

File "/home/u1/mprager/.virtualenvs/jupyter/local/lib/python2.7/site-packages/pandas/core/indexing.py", line 1514, in _has_valid_type

error()

File "/home/u1/mprager/.virtualenvs/jupyter/local/lib/python2.7/site-packages/pandas/core/indexing.py", line 1501, in error

axis=self.obj._get_axis_name(axis)))

KeyError: u'the label [9223943912072220999] is not in the [index]'

我认为这可能是某种dtype问题,但是即使执行df.loc [df.index [1]],我也会遇到相同的错误.

这是在python 2.7.9上使用pandas 0.22.0

Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐