DEV Community

Golden Alien
Golden Alien

Posted on

🛠️ gumroad_stripe_paypal_merger: Merge Gumroad, Stripe, PayPal CSVs into one ledger

Gumroad Stripe PayPal Merger

Introduction

This tool merges Gumroad, Stripe, and PayPal CSVs into a single ledger.

Features

  • Merges multiple CSV files into one
  • Supports Gumroad, Stripe, and PayPal CSV formats
  • Handles duplicate transactions ## Usage
  • Install the required libraries: pip install pandas
  • Run the script: python main.py -g gumroad.csv -s stripe.csv -p paypal.csv -o output.csv
import pandas as pd
import argparse

parser = argparse.ArgumentParser()
parser.add_argument('-g', '--gumroad', help='Gumroad CSV file', required=True)
parser.add_argument('-s', '--stripe', help='Stripe CSV file', required=True)
parser.add_argument('-p', '--paypal', help='PayPal CSV file', required=True)
parser.add_argument('-o', '--output', help='Output CSV file', required=True)
args = parser.parse_args()

gumroad_df = pd.read_csv(args.gumroad)
stripe_df = pd.read_csv(args.stripe)
paypal_df = pd.read_csv(args.paypal)

df = pd.concat([gumroad_df, stripe_df, paypal_df])
df.drop_duplicates(inplace=True)
df.to_csv(args.output, index=False)
Enter fullscreen mode Exit fullscreen mode

Top comments (0)