For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
3 0 0 2

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

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
6.7k 8 6 7

@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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
6.7k 8 6 7

@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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
3 0 0 2
@jason.ramchandani The excel is saved in /CodeCreator Notebooks/ instead of the path I set on the PC.
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
6.7k 8 6 7

@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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
3 0 0 2

@jason.ramchandani Thanks will do it on Jupyter instead

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea