diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/load_bbh_reports.py | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/python/load_bbh_reports.py b/python/load_bbh_reports.py index 586ac657..67688a80 100644 --- a/python/load_bbh_reports.py +++ b/python/load_bbh_reports.py @@ -59,11 +59,18 @@ def val_report(f): "Total Current Assets", "Total Current Liabilities", "Total Net Assets", + "Interest Rate", + "Quantity", + "Quantity Scale", + "Long/Short Indicator", + "FX Rate", + "Maturity Date", ], + parse_dates=["Accounting Date", "Maturity Date"], ) for col in df.select_dtypes(include="object"): df[col] = df[col].str.strip() - df.columns = df.columns.str.lower().str.replace(" ", "_") + df.columns = df.columns.str.lower().str.replace(" ", "_").str.replace("/", "_") df["row"] = df.index df.to_sql("bbh_val", dbengine("dawndb"), if_exists="append", index=False) |