diff options
Diffstat (limited to 'python/externalmarksbackfill.py')
| -rw-r--r-- | python/externalmarksbackfill.py | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/python/externalmarksbackfill.py b/python/externalmarksbackfill.py index f6e4fbec..7fd6b14c 100644 --- a/python/externalmarksbackfill.py +++ b/python/externalmarksbackfill.py @@ -17,8 +17,7 @@ def runAllFill(): def runSingleFill(f): range_name, sheet_name, done = settings[os.path.basename(f)] - dirstructure = os.path.dirname(f).split(os.path.sep) - markdate = (pd.Timestamp(dirstructure[5].replace("_","-"))+MonthEnd()).date() + markdate = pd.Timestamp(os.path.dirname(f).rsplit(os.path.sep, 1)[-1]) + MonthEnd() marks = pd.read_excel(f, sheet_name, skiprows=13, parse_cols=range_name) df = pd.DataFrame() |