CODEWITHSUNDEEP
pythonpandasheader
dante
dante

Reputation: 97

Header naming using Pandas

I am writing values of some lists in Excel. Each column gets all values, except the header. For each column, I have the header named as "0".

Part of the code which contains the writing in Excel:

writer=pd.ExcelWriter('/media/sf_vboxshared/workbook.xlsx', engine='xlsxwriter')

df0=pd.DataFrame(A)
df1=pd.DataFrame(B)
df2=pd.DataFrame(C)
df3=pd.DataFrame(D)
df4=pd.DataFrame(E)
df5=pd.DataFrame(F)
df6=pd.DataFrame(G)
df7=pd.DataFrame(H)
df8=pd.DataFrame(I)

df0.to_excel(writer, sheet_name="Sheet1", startcol=0, startrow=1,header="A", index=False)
df1.to_excel(writer, sheet_name="Sheet1", startcol=1, startrow=1,header="B", index=False)
df2.to_excel(writer, sheet_name="Sheet1", startcol=2, startrow=1,header="C", index=False)
df3.to_excel(writer, sheet_name="Sheet1", startcol=3, startrow=1,header="D", index=False)
df4.to_excel(writer, sheet_name="Sheet1", startcol=4, startrow=1,header="E", index=False)
df5.to_excel(writer, sheet_name="Sheet1", startcol=5, startrow=1,header="F", index=False)
df6.to_excel(writer, sheet_name="Sheet1", startcol=6, startrow=1,header="G", index=False)
df7.to_excel(writer, sheet_name="Sheet1", startcol=7, startrow=1,header="H", index=False)
df8.to_excel(writer, sheet_name="Sheet1", startcol=8, startrow=1,header="I", index=False)

writer.save()
writer.close()

How this can be fixed with their names of each column?

Best regards, Dan

Upvotes: 2

Views: 149

Answers (2)

AndreyF
AndreyF

Reputation: 1838

Why not to use a single DataFrame?

writer=pd.ExcelWriter('/media/sf_vboxshared/workbook.xlsx', engine='xlsxwriter')
df = pd.DataFrame({'A': A, 'B': B,'C': C, 'D': D, 'E': E, 'F': F, 'G':G, 'H': H, 'I': I})
df = df.to_excel(writer, 'Sheet1', index=False)

Upvotes: 1

Bharath M Shetty
Bharath M Shetty

Reputation: 30605

Use columns=[header] in your pd.Dataframe constructor i.e

df0=pd.DataFrame(A,columns=['A'])
df1=pd.DataFrame(B,columns=['B'])
.
.
.

Upvotes: 1

Related Questions