diff options
Diffstat (limited to 'python/report_ops/cash.py')
| -rw-r--r-- | python/report_ops/cash.py | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/python/report_ops/cash.py b/python/report_ops/cash.py index 3d2ddab2..da8709c4 100644 --- a/python/report_ops/cash.py +++ b/python/report_ops/cash.py @@ -98,7 +98,9 @@ class SerenitasUMBCashReport( p = self.get_cash_report("umb_") df = pd.read_excel(p, skiprows=3) for row in ( - df.groupby(["Portfolio #", "Currency"]).sum()["Current Balance"].items() + df.groupby(["Portfolio #", "Currency"]) + .sum(numeric_only=True)["Current Balance"] + .items() ): self.stage_from_row(row) self.commit() @@ -119,7 +121,7 @@ class BowdstBNYCashReport( ) for row in ( df.groupby(["Account Number", "Local Currency Code"]) - .sum()["Beginning Balance Local"] + .sum(numeric_only=True)["Beginning Balance Local"] .items() ): self.stage_from_row(row) |