问题遇到的现象和发生背景
excel数据如下
问题相关代码,请勿粘贴截图
import pandas as pd
df = pd.read_csv(r"C:\Users\陌生的雨\PycharmProjects\pythonProject\数据分析实训\task1_2.csv", sep=",")
data = df[['省份', '日期']]
data['在院人数'] = (df['累计确诊人数'] - df['累计治愈人数'] - df['累计确诊死亡'])
list2 = ["湖北", "广东", "上海"]
for j in list2:
tem_20 = []
da = data[data['省份'] == j]
for i in range(1, 7):
tem_20.append(da[da['日期'] == f"2020-0{i}-20"].index.to_list()[0])
print(da.loc[tem_20, :])
data.to_csv(r"C:\Users\陌生的雨\PycharmProjects\pythonProject\数据分析实训\task1_3.csv", index=False, na_rep='0',
encoding='utf-8', mode='a') # 写入csv文件,包括表头和索引
运行结果及报错内容
Traceback (most recent call last):
File "C:\Users\陌生的雨\PycharmProjects\pythonProject\venv\lib\site-packages\pandas\core\ops\array_ops.py", line 163, in _na_arithmetic_op
result = func(left, right)
File "C:\Users\陌生的雨\PycharmProjects\pythonProject\venv\lib\site-packages\pandas\core\computation\expressions.py", line 239, in evaluate
return _evaluate(op, op_str, a, b) # type: ignore[misc]
File "C:\Users\陌生的雨\PycharmProjects\pythonProject\venv\lib\site-packages\pandas\core\computation\expressions.py", line 69, in _evaluate_standard
return op(a, b)
TypeError: unsupported operand type(s) for -: 'str' and 'str'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\陌生的雨\PycharmProjects\pythonProject\数据分析实训\gg.py", line 5, in
data['在院人数'] = (df['累计确诊人数'] - df['累计治愈人数'] - df['累计确诊死亡'])
File "C:\Users\陌生的雨\PycharmProjects\pythonProject\venv\lib\site-packages\pandas\core\ops\common.py", line 70, in new_method
return method(self, other)
File "C:\Users\陌生的雨\PycharmProjects\pythonProject\venv\lib\site-packages\pandas\core\arraylike.py", line 108, in sub
return self._arith_method(other, operator.sub)
File "C:\Users\陌生的雨\PycharmProjects\pythonProject\venv\lib\site-packages\pandas\core\series.py", line 5639, in _arith_method
return base.IndexOpsMixin._arith_method(self, other, op)
File "C:\Users\陌生的雨\PycharmProjects\pythonProject\venv\lib\site-packages\pandas\core\base.py", line 1295, in _arith_method
result = ops.arithmetic_op(lvalues, rvalues, op)
File "C:\Users\陌生的雨\PycharmProjects\pythonProject\venv\lib\site-packages\pandas\core\ops\array_ops.py", line 222, in arithmetic_op
res_values = _na_arithmetic_op(left, right, op)
File "C:\Users\陌生的雨\PycharmProjects\pythonProject\venv\lib\site-packages\pandas\core\ops\array_ops.py", line 170, in _na_arithmetic_op
result = _masked_arith_op(left, right, op)
File "C:\Users\陌生的雨\PycharmProjects\pythonProject\venv\lib\site-packages\pandas\core\ops\array_ops.py", line 108, in _masked_arith_op
result[mask] = op(xrav[mask], yrav[mask])
TypeError: unsupported operand type(s) for -: 'str' and 'str'
我的解答思路和尝试过的方法
无
我想要达到的结果
解决报错问题