diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/load_globeop_report.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/python/load_globeop_report.py b/python/load_globeop_report.py index 0ce09187..f54ab650 100644 --- a/python/load_globeop_report.py +++ b/python/load_globeop_report.py @@ -34,7 +34,7 @@ def read_valuation_report(f): df = df.rename(columns={'CounterPartyCode': 'counterparty'}) if "Strat" in df: df.Strat = df.Strat.str.replace("^(SERCGMAST__){1,2}(M_|SER_)?", "", 1) - df = df.replace({"Strat": {"TCDSCSH": "TCSH"}}) + df = df.replace({"Strat": {"TCDSCSH": "TCSH", "MTG_CRT_LD": "CRT_LD"}}) if "Port" in df: df.Port = df.Port.str.replace("^(SERCGMAST__){1,2}(SERG__|SERG_)?", "", 1) df.columns = df.columns.str.lower() @@ -51,7 +51,7 @@ def valuation_reports(): def read_pnl_report(f): df = pd.read_csv(f) df.Strat = df.Strat.str.replace("^(SERCGMAST__){1,2}(M_|SER_)?", "", 1) - df = df.replace({"Strat": {"TCDSCSH": "TCSH"}}) + df = df.replace({"Strat": {"TCDSCSH": "TCSH", "MTG_CRT_LD": "CRT_LD"}}) df.Port = df.Port.str.replace("^(SERCGMAST__){1,2}(SERG__|SERG_)?", "", 1) df['LongShortIndicator'] = df['LongShortIndicator'].str.strip() df.columns = df.columns.str.lower().str.replace(" ", "") |