首页 > 解决方案 > 在数据框中划分两个数字列时获取 Key_error

问题描述

我有 Petrole_price 数据集,我正在检查条件是否大于昨天。如果是真的,它将创建一个子集。

petrole_price

   Country Today Yesterday
0   India   120    117 
1   US       90     92
2   UAE      32     31
3   Russia   70     69
4   UK       55     55

在执行以下代码时,我收到错误key_error 'Today'

petrole_price = petrole_price[petrole_price['Today'] > petrole_price['Yesterday']]

这是整个错误:

petrole_price = petrole_price[petrole_price['Today'] > petrole_price['Yesterday']]
  File "/home/tgphamifm/.local/lib/python3.9/site-packages/pandas/core/frame.py", line 3458, in __getitem__
    indexer = self.columns.get_loc(key)
  File "/home/tgphamifm/.local/lib/python3.9/site-packages/pandas/core/indexes/base.py", line 3363, in get_loc
    raise KeyError(key) from err
KeyError: 'Today'

标签: pythonpython-3.xpandasdataframe

解决方案


推荐阅读