Skip to content

Instantly share code, notes, and snippets.

View atraining's full-sized avatar

Christopher Helm atraining

View GitHub Profile
@atraining
atraining / combine_json_to_csv.py
Created December 9, 2021 08:01
Combine multiple json files into one csv
import glob
import json
from copy import deepcopy
import pandas
def cross_join(left, right):
new_rows = [] if right else left
for left_row in left:

Invoice

Invoice Number

Invoice Date

Order ID (Prio)

Supplier Order ID (Prio)

Net Amount

Gross Amount

Due Date

allowances/charges (skonto, freight)

Type (invoice or credit note)

---
marp: true
paginate: true
header: 'Name | Kunde | Datum'
style: |
section{background:#0d1f2d;color:#f5f0eb;font-family:Georgia,serif;padding:40px 40px 10px 40px;display:grid;grid-template-columns:2fr 1fr;grid-template-rows:auto auto 1fr;gap:0.4rem 1.5rem}section::before{grid-column:1/1}h2{color:#c45c3e;font-size:0.65em;font-weight:600;text-transform:uppercase;letter-spacing:0.08em;margin:1em 1em -1em 0em;grid-column:1/-1;grid-row:1;padding:1em 1em 1em 0em!important}h1{color:#f5f0eb;font-size:1.35em;font-weight:400;margin:0 0 0em 0;grid-column:1/-1;grid-row:2;line-height:1.2}header{color:rgba(255,255,255,0.5);font-size:0.55em}section::after{font-size:0.5em;color:rgba(255,255,255,0.4)}.left{font-size:0.75em;line-height:1.5}.right{font-size:0.55em;display:flex;flex-direction:column;gap:0.35rem}.right h4{color:rgba(255,255,255,0.6);font-size:0.8em;margin:0 0 0.15rem 0;font-weight:400}.box{background:rgba(255,255,255,0.05);padding:0.45rem 0.55rem;border-radius:5px;border-left:3px solid;line-height:1.35}.box.