python 用列表来创建DataFrame

import os
import pandas as pd

os.chdir(r"D:\泰迪杯")

data = pd.read_csv("fujian1.csv",encoding='gbk')
def duty2():
    type_of_goods = data[['大类名称','销售金额']].copy()

    # 将大类商品的名称作为列表
    dict_name_num = dict(type_of_goods['大类名称'].value_counts())
    list_name = list(dict_name_num.keys()) # 键

    # 遍历list_name; 算出每一类商品的总销售额
    list_value = []
    for i in list_name:
        data_sum = type_of_goods[type_of_goods['大类名称'] == i]['销售金额']

        print("{}的销售金额={}元".format(i,round(data_sum.sum(),2)))
        list_value.append(round(data_sum.sum(),2))


    # 要导出CSV文件, 所以要先构建DF; 可以通过字典来构建DF
    # 创建df
    df = pd.DataFrame(data=list_value,index=list_name,columns=['销售金额'])
    print(df)


duty2()