DEV Community

Bobo
Bobo

Posted on

Merge Financial Reports Automatically: A Real-World csv-toolkit Workflow

#javascript #node #csv #finance

Merge Financial Reports Automatically: A Real-World csv-toolkit Workflow

A real example of processing monthly financial reports.

The Setup

You have 12 monthly CSV reports that need to be merged and analyzed.

Step 1: Merge 

csv-toolkit-pro merge ./reports/*.csv --on "account_id" -o merged.csv
Enter fullscreen mode Exit fullscreen mode

Step 2: Clean 

csv-toolkit-pro clean merged.csv --remove-empty --fill-missing 0 -o clean.csv
Enter fullscreen mode Exit fullscreen mode

Step 3: Analyze 

csv-toolkit-pro analyze clean.csv --group-by "department" --agg "sum:revenue"
Enter fullscreen mode Exit fullscreen mode

Step 4: Export 

csv-toolkit-pro query clean.csv --sql "SELECT department, SUM(revenue) FROM data GROUP BY department ORDER BY revenue DESC"
Enter fullscreen mode Exit fullscreen mode 
npm install -g csv-toolkit-pro
Enter fullscreen mode Exit fullscreen mode

Visit us | Get free DigitalOcean credit | CLI Toolkit Pro $9.99

Top comments (0)