diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/bowdst.py | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/python/bowdst.py b/python/bowdst.py index 436d0e8e..cea2c2e3 100644 --- a/python/bowdst.py +++ b/python/bowdst.py @@ -226,6 +226,7 @@ def load_cash_report(workdate: datetime.date): / f"Settled Cash Statement_{workdate:%d %b %Y}.csv" ) df = pd.read_csv(p, thousands=",") + df = df[df["Transaction Type"].isna()] df = df.groupby(["Account Name", "Account Number", "Local Currency Code"]).sum() df["date"] = workdate df["fund"] = "BOWDST" |
