Python pandas how to write data from an array in excel

Question

I can not write data from an array in excel.

What parameters you need to specify functions in DataFrame()?

import pandas as pd

table = pd.read_excel("file1.xlsx", sheetname="file1")
lastval = table['lastval'].values.tolist()
newval = table['newval'].values.tolist()
rm = table['rm'].values.tolist()
itog = [0, 0, 0]

for i in range(3):
    itog[i] = (newval[i]-lastval[i]) * rm[i]
    pd.DataFrame(?????)

Bonifacio2 · Accepted Answer · 2017-07-31 18:44:41Z

1

The function you are looking for is to_excel. Take a look at the docs here.

answered Jul 31, 2017 at 18:44

Bonifacio2

3,9357 gold badges40 silver badges57 bronze badges

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

Collectives™ on Stack Overflow

Python pandas how to write data from an array in excel

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related