diff options
Diffstat (limited to 'python/task_server/globeop.py')
| -rw-r--r-- | python/task_server/globeop.py | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/python/task_server/globeop.py b/python/task_server/globeop.py index 2b8282f2..ae763b4f 100644 --- a/python/task_server/globeop.py +++ b/python/task_server/globeop.py @@ -65,8 +65,10 @@ def get_gpg(): def convert_to_csv(f):
if os.path.exists(f + ".xls"):
- df = pd.read_excel(f + ".xls", sheet_name=0, skiprows=[0, 1, 2, 3])
- df.to_csv(f + ".csv", index=False)
+ for sheet in ["Credit Default Swap", "Swaption"]:
+ df = pd.read_excel(f + ".xls", sheet_name=sheet,
+ skiprows=[0, 1, 2, 3])
+ df.to_csv(f"{sheet}.csv", index=False)
os.remove(f + ".xls")
def download_data(workdate):
|