diff options
| -rw-r--r-- | python/citco_ops/remote.py | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/python/citco_ops/remote.py b/python/citco_ops/remote.py index 5ec50028..9c90bd18 100644 --- a/python/citco_ops/remote.py +++ b/python/citco_ops/remote.py @@ -72,6 +72,8 @@ class Report: (self.date,), ) self._conn.commit() + if "strategy" in df.columns: + df["strategy"] = df["strategy"].str.replace("MORTGAGES/M_", "MORTGAGES/") df.to_sql(self.table, dawn_engine, if_exists="append", index=False) |