我已经开始学熊猫了。 我在用笔记本。 我已经导入了测试数据文件-Weather 我用熊猫读了文件。 下面我给出了代码。 当我试图读取温度或任何其他列的最大值时。 我正在犯错误。 你能帮我解决这个问题吗。
import pandas as pd
df = pd.read_csv("C:\\Users\\XXXXXXX\\Downloads\\delhi-weather-data\\testset.csv")
df['hum'].max()
错误如下:
KeyError Traceback (most recent call last)
//**C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\indexes\base.py in get_loc(self, key, method, tolerance)
2441 try:
-> 2442 return self._engine.get_loc(key)
2443 except KeyError:
pandas\_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc()
pandas\_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc()
pandas\_libs\hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()
pandas\_libs\hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()
KeyError: 'hum'
During handling of the above exception, another exception occurred:
KeyError Traceback (most recent call last)
<ipython-input-9-fed23426605b> in <module>()
----> 1 df['hum'].max()
C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\frame.py in __getitem__(self, key)
1962 return self._getitem_multilevel(key)
1963 else:
-> 1964 return self._getitem_column(key)
1965
1966 def _getitem_column(self, key):
C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\frame.py in _getitem_column(self, key)
1969 # get column
1970 if self.columns.is_unique:
-> 1971 return self._get_item_cache(key)
1972
1973 # duplicate columns & possible reduce dimensionality
C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\generic.py in _get_item_cache(self, item)
1643 res = cache.get(item)
1644 if res is None:
-> 1645 values = self._data.get(item)
1646 res = self._box_item_values(item, values)
1647 cache[item] = res
C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\internals.py in get(self, item, fastpath)
3588
3589 if not isnull(item):
-> 3590 loc = self.items.get_loc(item)
3591 else:
3592 indexer = np.arange(len(self.items))[isnull(self.items)]
C:\ProgramData\Anaconda3\lib\site-packages\pandas\core\indexes\base.py in get_loc(self, key, method, tolerance)
2442 return self._engine.get_loc(key)
2443 except KeyError:
-> 2444 return self._engine.get_loc(self._maybe_cast_indexer(key))
2445
2446 indexer = self.get_indexer([key], method=method, tolerance=tolerance)
pandas\_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc()
pandas\_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc()
pandas\_libs\hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()
pandas\_libs\hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()
df.head()
datetime_utc conds dewptm fog hail heatindexm hum precipm pressurem rain snow tempm thunder tornado vism wdird wdire wgustm windchillm wspdm
0 19961101-11:00 Smoke 9.0 0 0 NaN 27.0 NaN 1010.0 0 0 30.0 0 0 5.0 280.0 West NaN NaN 7.4
1 19961101-12:00 Smoke 10.0 0 0 NaN 32.0 NaN -9999.0 0 0 28.0 0 0 NaN 0.0 North NaN NaN NaN
2 19961101-13:00 Smoke 11.0 0 0 NaN 44.0 NaN -9999.0 0 0 24.0 0 0 NaN 0.0 North NaN NaN NaN
3
@vivekrajagopalan很简单,也许你的列名末尾有空格。只需执行df.columns=df.columns.str.strip(),然后重试–20小时前的黑暗
非常感谢你 在运行命令df.columns=df.columns.str.strip()之后
它的工作。 df['hum'].min() 4.0条 df['hum'].max() 243.0分
非常感谢。
目前没有回答
相关问题 更多 >
编程相关推荐