For循环导出到带有动态CSV命名的CSV

Question

我对Python比较陌生（我的大部分经验都是在SAS领域），所以请大家多多忍耐。

我试图从现有的数据集创建一些CSV，并根据定义的列表导出它们。CSV的命名应该基于相应的列表值是动态的。

cc = ['AD-1','AD-2','AD-3'] #the list I want it to cycle through
for index in range(len(cc)): 
    df1_cc = df[df['charge'].isin(cc)] #df is predefined 
    #set "charge" as the index variable so you can aggregate on it           
    df1_cc = df1_cc.set_index('charge')
    df1_cc
    #sum up values based on individual values of 'charge'
    table1_cc = df1_cc.sum(level='charge')
    table1_cc
    #output to CSV
    table1_cc.to_csv(r"C:\Users\etc\table1_"+cc+".csv")

表1_cc.to_csv（r“C:\users\etc\”+cc+“.csv”）

我得到的错误是：typeerror：只能将str（而不是“list”）连接到str

输出应该是3个文件:table1_ad-1.CSV，table1_ad-2.CSV和table1_ad-3.CSV，并且每个文件都应该包含每个单独的求和值（同样，该部分工作。真正的问题是循环通过并将每个单独值的输出导出到CSV（以cc为单位）。

感谢任何帮助！

Answer 1

您需要将的最后一行更改为_csv

cc = ['AD-1','AD-2','AD-3'] #the list I want it to cycle through
for index in range(len(cc)): 
    df1_cc = df[df['charge'].isin([cc[index]])] #df is predefined 
    #set "charge" as the index variable so you can aggregate on it           
    df1_cc = df1_cc.set_index('charge')
    df1_cc
    #sum up values based on individual values of 'charge'
    table1_cc = df1_cc.sum(level='charge')
    table1_cc
    #output to CSV
    table1_cc.to_csv(r"C:\Users\etc\table1_"+cc[index]+".csv")