diff options
Diffstat (limited to 'python/load_globeop_report.py')
| -rw-r--r-- | python/load_globeop_report.py | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/python/load_globeop_report.py b/python/load_globeop_report.py index 519ecaa0..678046ea 100644 --- a/python/load_globeop_report.py +++ b/python/load_globeop_report.py @@ -33,6 +33,7 @@ def read_valuation_report(f): df["PeriodEndDate"] = date - bus_day df["row"] = df.index df["Fund"] = df.Fund.str.replace("BOS_PAT_BOWDOIN", "BOWDST") + df["CounterPartyCode"] = df["CounterPartyCode"].str.replace("BTIGNY", "BTIG") if "AccountingPeriod" in df: del df["AccountingPeriod"] if "CounterParty" in df: @@ -154,7 +155,7 @@ def read_cds_report(f): df.loc[df.strategy == "SERCGMAST__MBSCDS", "strategy"] = "MBSCDS" df.strategy = df.strategy.str.replace("SER_", "") df["buy/sell"] = df["buy/sell"].astype("category") - df["buy/sell"].cat.categories = ["Buyer", "Seller"] + df["buy/sell"] = df["buy/sell"].cat.rename_categories(["Buyer", "Seller"]) del df["independent_%"] df2 = df2.rename(columns={"independent_%": "independent_perc"}) df.prime_broker = df.prime_broker.where(df.prime_broker != "NONE") |