diff options
Diffstat (limited to 'python/bowdst.py')
| -rw-r--r-- | python/bowdst.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/python/bowdst.py b/python/bowdst.py index ee641b47..a76c82ef 100644 --- a/python/bowdst.py +++ b/python/bowdst.py @@ -93,7 +93,7 @@ def load_report(workdate: datetime.date): "local_notional_value", "base_notional_value", ]: - df[col] = df[col].apply(lambda s: s[1:-1] if s.startswith("(") else s) + df[col] = df[col].apply(lambda s: "-" + s[1:-1] if s.startswith("(") else s) df[col] = pd.to_numeric(df[col].str.replace(",", "")) df["row"] = df.index df.to_sql("bowdst_val", dawn_engine, if_exists="append", index=False) |