我像这样用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