diff options
Diffstat (limited to 'python/build_default_table.py')
| -rw-r--r-- | python/build_default_table.py | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/python/build_default_table.py b/python/build_default_table.py index 7a4318b2..56f1cf51 100644 --- a/python/build_default_table.py +++ b/python/build_default_table.py @@ -1,6 +1,6 @@ import pandas as pd from bbg_helpers import init_bbg_session, BBG_IP, retrieve_data -from db import dbengine +from db import serenitas_engine indices = ["CDX HY CDSI S19 5Y", "ITRX XOVER CDSI S25 5Y", "CDX HY CDSI S15 5Y", "ITRX XOVER CDSI S20 5Y", "CDX HY CDSI S25 5Y", @@ -15,5 +15,4 @@ df = df[~df.duplicated(['Company ID'])] breakpoint() df = df[['Company ID', 'Auction Date', 'Event Date', 'CDS Recovery Rate']] df.columns = ['id', 'auction_date', 'event_date', 'recovery'] -serenitas_engine = dbengine('serenitasdb') df.to_sql('defaulted', serenitas_engine, if_exists='append', index=False) |