solve.sh 939 B

123456789101112131415161718192021222324252627
  1. #!/bin/sh
  2. set -eu
  3. python - <<'PY'
  4. import csv
  5. from collections import OrderedDict
  6. from decimal import Decimal
  7. with open("/app/input.csv", encoding="utf-8-sig", newline="") as source:
  8. rows = list(csv.DictReader(source))
  9. totals = OrderedDict()
  10. for row in rows:
  11. totals[row["姓名"]] = totals.get(row["姓名"], Decimal("0")) + Decimal(row["金额"])
  12. with open("/app/summary.csv", "w", encoding="utf-8", newline="") as output:
  13. writer = csv.writer(output)
  14. writer.writerow(["姓名", "报销总额"])
  15. for name, total in totals.items():
  16. writer.writerow([name, f"{total:.2f}"])
  17. with open("/app/over_500.csv", "w", encoding="utf-8", newline="") as output:
  18. writer = csv.writer(output)
  19. writer.writerow(["日期", "姓名", "类别", "金额"])
  20. for row in rows:
  21. if Decimal(row["金额"]) > Decimal("500"):
  22. writer.writerow([row["日期"], row["姓名"], row["类别"], row["金额"]])
  23. PY