【Python】第四章（文件操作）综合练习

最新推荐文章于 2025-04-01 20:32:02 发布

原创最新推荐文章于 2025-04-01 20:32:02 发布 · 528 阅读

1 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#python

python 专栏收录该内容

28 篇文章

订阅专栏

这段代码展示了如何使用openpyxl库读取Excel文件，计算员工销售总额、时段销售额和柜台销售额，并将CSV文件转换为JSON格式。此外，还演示了如何将CSV数据写入到新的Excel文件中。

import openpyxl
# 1：打开工作簿
wb = openpyxl.load_workbook("超市营业额1.xlsx")
# 2：选取表单
sh = wb['Sheet1']
# 3：读表头
head_row = list(sh.rows)[0]
print(head_row)
# 员工数量
id = set([item[0].value for item in list(sh.rows)[1:]])  # 不重复的员工工号
# 每个员工销售总额
for pr in id:
    w = sum([item[4].value for item in list(sh.rows)[1:] if item[0].value == pr])
    print("工号:", pr, ",销售额:", w)
# 时段数量
duration = set([item[3].value for item in list(sh.rows)[1:]])  # 不重复的时段名字
# 每个时段的销售额
for du in duration:
    w2 = sum([item[4].value for item in list(sh.rows)[1:] if item[3].value == du])
    print("时段:", du, ",销售额:", w2)
# 柜台数量
counter = set([item[5].value for item in list(sh.rows)[1:]])  # 不重复的柜台名字
# 每个柜台的销售额
for co in counter:
    w3 = sum([item[4].value for item in list(sh.rows)[1:] if item[5].value == co])
    print("时段:", co, ",销售额:", w3)
wb.close()

import csv
import json

with open("exer4.csv", "r") as fp1:
    reader = csv.reader(fp1)
    data = [row for row in reader]
    keys = data[0]
    values = data[1:]
    res = [dict(zip(keys, item)) for item in values]

with open("exer4.json", "w") as fp:
    json.dump(res, fp, indent=4, separators=(",", ":"))

import openpyxl
import csv
with open("exer4.csv", "r") as fp:
    reader = csv.reader(fp)
    data = [row for row in reader]
wb = openpyxl.Workbook()
sh = wb.active
[sh.append(row) for row in data]
wb.save('ExCsv2Excel.xlsx')