Simple script to transform the Dreamborn.ink Export CSV into the Bulk Add CSV

lorcana_transform.py

import csv
import os

input_file = "input.csv"
output_file = "output.csv"

input_path = os.path.join(os.path.dirname(__file__), input_file)
output_path = os.path.join(os.path.dirname(__file__), output_file)

with open(input_path, newline='', encoding='utf-8') as infile, open(output_path, 'w', newline='', encoding='utf-8') as outfile:
    reader = csv.DictReader(infile)
    writer = csv.DictWriter(outfile, fieldnames=["Set Number", "Card Number", "Variant", "Count"])
    writer.writeheader()
    for row in reader:
        # Normal variant
        normal_count = int(row["Normal"])
        if normal_count > 0:
            writer.writerow({
                "Set Number": row["Set Number"],
                "Card Number": row["Card Number"],
                "Variant": "normal",
                "Count": normal_count
            })
        # Foil variant
        foil_count = int(row["Foil"])
        if foil_count > 0:
            writer.writerow({
                "Set Number": row["Set Number"],
                "Card Number": row["Card Number"],
                "Variant": "foil",
                "Count": foil_count
            })