logo标签列表

基于索引，在pandas数据框中查找特定列的值。

pythonpandas
3
我使用 Python - 3.6 和 pandas - 0.24.1。 我有一个名为 df1 的 pandas 数据帧。
    col1    col2
0  8388611  3.9386
1  8388612  1.9386

我需要找到特定索引位置的col1的值。
 print(df1['col1'][1])

错误：

Traceback (most recent call last):
  File "/home/runner/.site-packages/pandas/core/indexes/base.py", line 2656, inget_loc
    return self._engine.get_loc(key)
  File "pandas/_libs/index.pyx", line 108, in pandas._libs.index.IndexEngine.get_loc
  File "pandas/_libs/index.pyx", line 132, in pandas._libs.index.IndexEngine.get_loc
  File "pandas/_libs/hashtable_class_helper.pxi", line 1601, in pandas._libs.hashtable.PyObjectHashTable.get_item
  File "pandas/_libs/hashtable_class_helper.pxi", line 1608, in pandas._libs.hashtable.PyObjectHashTable.get_item
KeyError: 1

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "main.py", line 24, in <module>
    print(df1['col1'][1])
  File "/home/runner/.site-packages/pandas/core/frame.py", line 2927, in __getitem__
    indexer = self.columns.get_loc(key)
  File "/home/runner/.site-packages/pandas/core/indexes/multi.py", line 2397, in get_loc
    loc = self._get_level_indexer(key, level=0)
  File "/home/runner/.site-packages/pandas/core/indexes/multi.py", line 2652, in _get_level_indexer
    code = level_index.get_loc(key)
  File "/home/runner/.site-packages/pandas/core/indexes/base.py", line 2658, inget_loc
    return self._engine.get_loc(self._maybe_cast_indexer(key))
  File "pandas/_libs/index.pyx", line 108, in pandas._libs.index.IndexEngine.get_loc
  File "pandas/_libs/index.pyx", line 132, in pandas._libs.index.IndexEngine.get_loc
  File "pandas/_libs/hashtable_class_helper.pxi", line 1601, in pandas._libs.hashtable.PyObjectHashTable.get_item
  File "pandas/_libs/hashtable_class_helper.pxi", line 1608, in pandas._libs.hashtable.PyObjectHashTable.get_item
KeyError: 1

在pandas中，迭代某一列的所有元素有什么理想方法？

使用 print(df1.loc[1, 'col1'])，它是重复的。 - jezrael
1个回答
7
您可以使用 iloc。 df [“column”] .iloc [index]
网页内容由stack overflow 提供, 点击上面的
可以查看英文原文，
原文链接