Downloading Python List to Excel File

levente.letenyei

Hi Developers! I have a Python List with Time Series Data of 15 Currency Pairs. I would like to download this list into an Excel file. I am working in the Code Book Environment. Is there a solution?

pf

Hi @levente.letenyei ,

To write Python list into Excel file, you can:

1. save in csv file: https://www.geeksforgeeks.org/python-save-list-to-csv/ with csv module
2. or directly in a xlsx file with ExcelWriter function from pandas lib

Once the file was created in your CodeBook environment, then you can download it from CodeBook on your machine:

<br />

levente.letenyei

https://community.developers.refinitiv.com/discussion/comment/97043#Comment_97043

Thank you very much! You saved my life!

nicolas.glasek

Hi, @pf is there a way to create the CSV file, without defining every row? I am trying to create a csv for excel from the codebook. The populated table is 14182 rows x 2 Columns.

pf

https://community.developers.refinitiv.com/discussion/comment/117090#Comment_117090

If you want to create a CSV file based on a Dataframe, the easiest way is Dataframe.to_csv function.

Example : https://www.geeksforgeeks.org/how-to-export-pandas-dataframe-to-a-csv-file/