a= [1,2,3,4,5]
df=DataFrame(a)
.... #setup excelwriter and dataframe
df.to_excel(writer, sheet_name=sheetname,startrow=1, startcol=1, header=False, index=False)
Output:
1\n
2\n
3\n
4\n
5
How can I get output as:
1 2 3 4 5
Add a comment
|
3 Answers
You could transpose first, and then save to excel:
df
0
0 1
1 2
2 3
3 4
4 5
df.T.to_excel(writer,
sheet_name=sheetname,
startrow=1,
startcol=1,
header=False,
index=False)
1 2 3 4 5
Comments
To output in a line use this:
df = df.transpose()
Full code:
#!/usr/bin/python
import pandas as pd
import xlsxwriter as xlsw
a = [1,2,3,4,5]
df = pd.DataFrame(a)
df = df.transpose()
xlsfile = 'pandas_simple.xlsx'
writer = pd.ExcelWriter(xlsfile, engine='xlsxwriter')
df.to_excel(writer, sheet_name="Sheet1Name",startrow=1, startcol=1, header=False, index=False)
Comments
Use transpose() on dataframe to convert columns into rows.
import pandas as pd
a= [1,2,3,4,5]
df=pd.DataFrame(a)
df = df.transpose()
print(df)
result:
0 1 2 3 4
0 1 2 3 4 5
3 Comments
cs95
T and
transpose are exactly the same. Mentioned here: stackoverflow.com/a/48613193/4909087
TigerTV.ru
Use transfpose() - typo
cs95
There was a point to my comment. Please look at the other answers before posting your own. Cheers.