SUMcsv有以下列:销售日期扫码销售时间单品编码单品名称分类名称销量千克销售单价元千克销售类型是否打折销售批发价格单品损耗率处理SUMcsv文件如果销售日期相同并且单品编码相同且销售类型则把它们的销量千克相加其它列不变生成新行到SUMsmallcsv
以下是处理SUM.csv文件的Python代码,生成SUMsmall.csv文件:
import csv
# 读取SUM.csv文件
with open('SUM.csv', 'r') as file:
reader = csv.DictReader(file)
rows = list(reader)
# 创建SUMsmall.csv文件
with open('SUMsmall.csv', 'w', newline='') as file:
fieldnames = reader.fieldnames
writer = csv.DictWriter(file, fieldnames=fieldnames)
writer.writeheader()
# 处理数据
for i in range(len(rows)):
row = rows[i]
sales_date = row['销售日期']
product_code = row['单品编码']
sales_type = row['销售类型']
sales_volume = float(row['销量(千克)'])
# 查找是否有相同的销售日期、单品编码和销售类型的行
for j in range(i+1, len(rows)):
next_row = rows[j]
next_sales_date = next_row['销售日期']
next_product_code = next_row['单品编码']
next_sales_type = next_row['销售类型']
# 如果找到相同的行,则将销量相加
if sales_date == next_sales_date and product_code == next_product_code and sales_type == next_sales_type:
sales_volume += float(next_row['销量(千克)'])
# 写入新行到SUMsmall.csv文件
row['销量(千克)'] = str(sales_volume)
writer.writerow(row)
请将上述代码保存为一个Python文件,并确保SUM.csv文件与该Python文件在同一目录下。运行该Python文件后,将生成SUMsmall.csv文件,其中包含了按要求处理后的数据。
原文地址: https://www.cveoy.top/t/topic/i2mD 著作权归作者所有。请勿转载和采集!