diff options
Diffstat (limited to 'python/load_globeop_report.py')
| -rw-r--r-- | python/load_globeop_report.py | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/python/load_globeop_report.py b/python/load_globeop_report.py index 52a86cbc..0ce09187 100644 --- a/python/load_globeop_report.py +++ b/python/load_globeop_report.py @@ -34,6 +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"}}) if "Port" in df: df.Port = df.Port.str.replace("^(SERCGMAST__){1,2}(SERG__|SERG_)?", "", 1) df.columns = df.columns.str.lower() @@ -50,6 +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.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(" ", "") |