diff options
Diffstat (limited to 'python/globeop_reports.py')
| -rw-r--r-- | python/globeop_reports.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/python/globeop_reports.py b/python/globeop_reports.py index a49cae6c..2fe60c8e 100644 --- a/python/globeop_reports.py +++ b/python/globeop_reports.py @@ -15,7 +15,7 @@ def get_monthly_pnl(group_by=["identifier"]): df_pnl = pd.read_sql_query( sql_string, dawn_engine, parse_dates=["date"], index_col=["date"] ) - df_pnl["identifier"] = df_pnl.invid.str.replace("_A$", "") + df_pnl["identifier"] = df_pnl.invid.str.replace("_A$", "", regex=True) pnl_cols = [ "bookunrealmtm", "bookrealmtm", @@ -49,7 +49,7 @@ def get_portfolio(report_date=None): parse_dates=["periodenddate"], index_col=["periodenddate"], ) - df["identifier"] = df.invid.str.replace("_A$", "") + df["identifier"] = df.invid.str.replace("_A$", "", regex=True) return df |