how to insert data from list into excel in python

Question

how to insert data from list into excel in python for example i exported this data from log file :

data= ["101","am1","123450","2015-01-01 11:19:00","test1 test1".....]
      ["102","am2","123451","2015-01-01 11:20:00","test2 test3".....]
      ["103","am3","123452","2015-01-01 11:21:00","test3 test3".....]

Output result: [1]: https://i.sstatic.net/7uTOE.png

.

You can use Pandas module to export data as .xlsx

EL-AJI Oussama
– EL-AJI Oussama

2022-05-14 22:15:42 +00:00
Commented May 14, 2022 at 22:15 — EL-AJI Oussama
– EL-AJI Oussama, Commented May 14, 2022 at 22:15

Ignatius Reilly · Accepted Answer · 2022-05-14 22:53:35Z

1

The module pandas has a DataFrame.to_excel() function that would do that.

import pandas as pd

data= [["101","am1","123450","2015-01-01 11:19:00","test1 test1"],
      ["102","am2","123451","2015-01-01 11:20:00","test2 test3"],
      ["103","am3","123452","2015-01-01 11:21:00","test3 test3"]]

df = pd.DataFrame(data)

df.to_excel('my_data.xmls')

That should do it.

edited May 14, 2022 at 22:53

answered May 14, 2022 at 22:22

Ignatius Reilly

1,7524 gold badges9 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to insert data from list into excel in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related