diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/markit/import_quotes.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/python/markit/import_quotes.py b/python/markit/import_quotes.py index 5a4f75d5..88166dd8 100644 --- a/python/markit/import_quotes.py +++ b/python/markit/import_quotes.py @@ -124,7 +124,7 @@ def insert_index(engine, workdate=None): if workdate is None or \ datetime.datetime.fromtimestamp(os.path.getmtime(f)).date()==(workdate+BDay(1)).date(): data = pd.read_csv(f, skiprows=2, parse_dates=[0,7], engine='python') - data.rename(columns=colmapping, inplace=True) + data = data.rename(columns=colmapping) data.dropna(subset=['closeprice'], inplace=True) for col in cols: data[col] = data[col].str.replace('%', '').astype('float') @@ -142,7 +142,7 @@ def insert_index(engine, workdate=None): data.reset_index(inplace=True) data[ext_cols].to_sql('index_quotes', engine, if_exists='append', index=False) -def insert_tranche(engine, workdate = None): +def insert_tranche(engine, workdate=None): """insert Markit index quotes into the database :param engine: sqlalchemy engine to the database |