我试图让这段代码正常工作，但它有错误：for myname in mn:
mydf = df.loc[df.Teacher_name == myname]
mydf.to_excel(writer, sheet_name = myname)
writer.save()
File “”, line 4
writer.save()
SyntaxError: invalid syntax
导入=
^{pr2}$
写入程序=writer = pd.ExcelWriter(“MyData.xlsx”, engine=’xlsxwriter’)
锰=mn = df[‘name’].unique().tolist()
mn = [‘Teacher A’, ‘Teacher B’, ‘Teacher C’]
使用以下查询生成df：df = pd.read_csv(‘XXX.csv’, names=[‘Teacher_name’, ‘Studen_name’,’Extra’])
数据框输出：Teacher_name Student_name Extra
1 Teacher A Student 1 xxxx
2 Teacher A Student 2 xxxx
3 Teacher B Student 3 xxxx
4 Teacher C Student 4 xxxx
Original: https://blog.csdn.net/weixin_36242060/article/details/114913424
Author: 秦少爷的琪琪
Title: python 写excel saves报错_Python（Pandas）语法错误无效语法writer.save文件()
原创文章受到原创版权保护。转载请注明出处：https://www.johngo689.com/753960/
转载文章受原作者版权保护。转载请注明原作者出处！