diff options
Diffstat (limited to 'python/load_indicative.py')
| -rw-r--r-- | python/load_indicative.py | 13 |
1 files changed, 1 insertions, 12 deletions
diff --git a/python/load_indicative.py b/python/load_indicative.py index 21a7503c..db5ac7c3 100644 --- a/python/load_indicative.py +++ b/python/load_indicative.py @@ -5,22 +5,12 @@ from datetime import date import csv import pdb import sys -from common import root +from common import root, sanitize_float from db import conn, query_db, with_connection def convertToNone(s): return None if s in ["", "-", "NR"] else s -def sanitize_float(intex_float): - try: - intex_float = intex_float.replace(",", "") - if "(" in intex_float: - intex_float = - float(intex_float[1:-1]) - else: - intex_float = float(intex_float) - except (AttributeError, ValueError): - return intex_float - @with_connection def upload_cusip_data(conn, filename): dealupdate = {} @@ -118,7 +108,6 @@ def upload_deal_data(conn, filename): line[field] = datetime.datetime.strptime(line[field], '%b %d, %Y').date() except ValueError: pdb.set_trace() - for key in ["Collection Account Principal Balance", "Collection Account Interest Balance", "Orig Deal Bal", "Curr Deal Bal", "Tranche Curr Bal", "Tranche Orig Bal", "CDO Pct of Assets that are Structured Finance Obligations", |