excel表格分组求和

Question

问题遇到的现象和发生背景

Excel分组并求和

用代码块功能插入代码，请勿粘贴截图

import pandas as pd
df = pd.read_excel('F:\123.xlsx')
df_sum = df.groupby(by=['name'])['value1'].sum()
df_sum.to_excel('F:\huizong.xlsx')

运行结果及报错内容

Traceback (most recent call last):
File "E:\Python project\chap10\成绩.py", line 6, in
df = pd.read_excel('F:\123.xlsx')
File "E:\Python project\venv\lib\site-packages\pandas\util_decorators.py", line 311, in wrapper
return func(*args, **kwargs)
File "E:\Python project\venv\lib\site-packages\pandas\io\excel_base.py", line 457, in read_excel
io = ExcelFile(io, storage_options=storage_options, engine=engine)
File "E:\Python project\venv\lib\site-packages\pandas\io\excel_base.py", line 1376, in init
ext = inspect_excel_format(
File "E:\Python project\venv\lib\site-packages\pandas\io\excel_base.py", line 1250, in inspect_excel_format
with get_handle(
File "E:\Python project\venv\lib\site-packages\pandas\io\common.py", line 795, in get_handle
handle = open(handle, ioargs.mode)
FileNotFoundError: [Errno 2] No such file or directory: 'F:S.xlsx'

我的解答思路和尝试过的方法

我想要达到的结果 这是啥情况呀？

Answer 1

试试

import pandas as pd
df = pd.read_excel(r'F:\123.xlsx')
df_sum = df.groupby(by=['name'])['value1'].sum()
df_sum.to_excel(r'F:\huizong.xlsx')