converting columns into rows in pd. dataframe

Question

How can I convert columns to rows in a pd.dataframe, currently my code is as below in, instead of having my values returned in columns I want them to be displayed in rows, I have tried using iterrows:

            df = pd.DataFrame (columns = cleaned_array)
            output = df.to_csv ( index=False, mode='a', encoding = "utf-8")
            print(output)

You can use this link, it may helps you : https://stackoverflow.com/questions/28654047/pandas-convert-some-columns-into-rows — Ayoub Bouz, Aug 03 '21 at 21:47

score 0 · Answer 1 · answered Aug 03 '21 at 21:47

0

You want to use the tranpose function.

df.T or df.transpose()

answered Aug 03 '21 at 21:47

Gus Beringer

172
9

score 0 · Accepted Answer · answered Aug 03 '21 at 23:04

0

Try this:

df = pd.DataFrame (columns = cleaned_array)

df.T

This will interchange your rows and columns

answered Aug 03 '21 at 23:04

Shieldbreaker

79
6

converting columns into rows in pd. dataframe

2 Answers2