variant_float.sh 871 B

123456789101112131415161718192021222324252627
  1. #!/bin/bash
  2. # 另一种正确写法:用 float 和 csv.reader,应当满分
  3. cat > /app/summarize.py <<'PY'
  4. import csv
  5. import sys
  6. src, summary_path, over_path = sys.argv[1:4]
  7. with open(src, encoding="utf-8-sig", newline="") as f:
  8. rows = list(csv.reader(f))
  9. header, records = rows[0], rows[1:]
  10. totals = {}
  11. for date, name, category, amount in records:
  12. totals[name] = totals.get(name, 0.0) + float(amount)
  13. with open(summary_path, "w", encoding="utf-8", newline="") as f:
  14. w = csv.writer(f)
  15. w.writerow(["姓名", "报销总额"])
  16. for name, total in totals.items():
  17. w.writerow([name, f"{total:.2f}"])
  18. with open(over_path, "w", encoding="utf-8", newline="") as f:
  19. w = csv.writer(f)
  20. w.writerow(header)
  21. w.writerows(r for r in records if float(r[3]) > 500)
  22. PY
  23. python3 /app/summarize.py /app/input.csv /app/summary.csv /app/over_500.csv