How can i download eikon data using pandas to local PC instead of notebook path

avishen.bablee

How can i download eikon data using pandas to local PC instead of notebook path

jason.ramchandani01

@avishen.bablee apologies are you using codebook? If you are then some OS functionality is restricted for security reasons. Obviously the local machine is a cloud VM. You are able to download them manually I believe to you local drive but this OS functionality is currently limited programatically. If you need to do this programatically- you can do this outside codebook - in say a standalone jupyter instance using the above process. I hope this can help.

jason.ramchandani01

@avishen.bablee So once you have a dataframe of data - you can easily export that as csv or excel file or database using built-in pandas to_csv, to_excel or to_sql functions. Please see this reference for to_excel. You can specify a filepath/name for the output.

df.to_excel('filepath/filename.xlsx')

I hope this can help.

avishen.bablee

@jason.ramchandani The excel is saved in /CodeCreator Notebooks/ instead of the path I set on the PC.

jason.ramchandani01

@avishen.bablee ah ok so you can discover and change the working directory to where you want to save the files to then change back again after - using os package and os.getcwd() and os.chdir() - please see example here. I hope this can help.

avishen.bablee

@jason.ramchandani Thanks will do it on Jupyter instead