iframe-proxy | Sunbelt Computer Software

executable file

40 lines (30 loc) · 915 Bytes

#!/usr/bin/env python3
with open('input.csv') as f:
    reader = csv.DictReader(f)
    all_rows = list(reader)
# remove rows without BIOGUIDE_ID
filtered_rows = []
for row in all_rows:
    if row['BIOGUIDE_ID']:
        filtered_rows.append(row)
# sum cost by category
costs_by_category = {}
for row in filtered_rows:
    category = row['CATEGORY']
    amount = float(row['AMOUNT'])
    if category in costs_by_category:
        costs_by_category[category] += amount
        costs_by_category[category] = amount
# write output
with open('output.csv', 'w') as f:
    writer = csv.writer(f)
    writer.writerow(['path', 'size'])
    # write empty row for root
    writer.writerow(['root', ''])
    for category, total_cost in costs_by_category.items():
        path = "root/" + category + ".txt"
        size = total_cost
        new_row = [path, size]
        writer.writerow(new_row)

Sunbelt Computer Software

PL/B Language Development and Support

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Sunbelt Computer Software

PL/B Language Development and Support

Uh oh!

FilesExpand file tree

convert.py

Latest commit

History

convert.py

File metadata and controls