diff options
| -rw-r--r-- | python/externalmarksbackfill.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/python/externalmarksbackfill.py b/python/externalmarksbackfill.py index c0939e2f..cbcf57c5 100644 --- a/python/externalmarksbackfill.py +++ b/python/externalmarksbackfill.py @@ -25,7 +25,7 @@ def runSingleFill(f): (range_name, sheet_name, done) = settings[os.path.basename(f)] dirstructure = os.path.dirname(f).split('/') - markdate = (pd.Timestamp(dirstructure[5].split("_")[0]+"-"+dirstructure[5].split("_")[1])+MonthEnd()).date() + markdate = (pd.Timestamp(dirstructure[5].replace("_","-"))+MonthEnd()).date() marks = pd.read_excel(f, sheet_name, skiprows=13, parse_cols=range_name) for s in ['1st', '2nd', '3rd'] +[str(i)+'th' for i in range(4, 12)]: @@ -113,4 +113,4 @@ settings = { 'Serenitas_Month-end_book--06_30_2013.xlsx': ("II:IZ", "All Securities", "Y"), 'Serenitas_Month-end_book--05 31 2013.xlsx': ("II:IZ", "All Securities", "Y"), 'Serenitas_Month-end_book--04 30 2013.xlsx': ("II:IZ", "All Securities", "Y") -}
\ No newline at end of file +} |