import pandas as pd
dt = {"城市":["北京","上海","杭州","广州","上海"],
"最低温度":["10℃","15℃","15℃","5℃","5℃"],
"风向":["东","西","南","北","北"]}
weather = pd.DataFrame(dt)
weather["最低温度"] = weather["最低温度"].str.replace("℃","").astype("int")
weather["最高温度"] = sorted(weather["最低温度"],reverse= True)
f = lambda x:"高温" if x["最高温度"]>=15 else ("低温" if x["最低温度"]<=5 else "常温")
weather["温度类型"] = weather.apply(f,axis=0)
print(weather)
运行错误:
Traceback (most recent call last):
File "E:/Testcode/hello.py", line 9, in
weather["温度类型"] = weather.apply(f,axis=0)
File "E:\python&vscode\lib\site-packages\pandas\core\frame.py", line 8736, in apply
return op.apply()
File "E:\python&vscode\lib\site-packages\pandas\core\apply.py", line 688, in apply
return self.apply_standard()
File "E:\python&vscode\lib\site-packages\pandas\core\apply.py", line 805, in apply_standard
results, res_index = self.apply_series_generator()
File "E:\python&vscode\lib\site-packages\pandas\core\apply.py", line 821, in apply_series_generator
results[i] = self.f(v)
File "E:/Testcode/hello.py", line 8, in
f = lambda x:"高温" if x["最高温度"]>=15 else ("低温" if x["最低温度"]<=5 else "常温")
File "E:\python&vscode\lib\site-packages\pandas\core\series.py", line 942, in getitem
return self._get_value(key)
File "E:\python&vscode\lib\site-packages\pandas\core\series.py", line 1051, in _get_value
loc = self.index.get_loc(label)
File "E:\python&vscode\lib\site-packages\pandas\core\indexes\range.py", line 388, in get_loc
raise KeyError(key)
KeyError: '最高温度'