How to transpose rows into columns in python?

Question

I want to transform/transpose this DF into an other DF with one row containing all the columns: for exemple i will have columns GearLeverPosition_v2_count, GearLeverPosition_v2_mean ... with the index 0 having the values for each one.

could you add in the question an example of the desired result. looks like you want a vector containing metrics (count, mean) for each column. Is that right? — user2261062
– user2261062, Commented Jun 1, 2022 at 8:49
then you don't want to transpose it. you are getting several answers that tell you how to transpose, since it's what you asked in the title. — user2261062
– user2261062, Commented Jun 1, 2022 at 10:20

Piotr · Accepted Answer · 2022-06-01 08:50:32Z

4

Same as in numpy, to transpose a DataFrame in pandas you can:

df.T

or equivalently:

df.transpose()

answered Jun 1, 2022 at 8:50

Piotr

7727 silver badges9 bronze badges

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

4 Comments

Jahd Jabre Over a year ago

df.transpose() doesnt make it, i've already tried, i want to transform the whole data frame with one line and severals columns. my final df should have 8 columns having GearLeverPosition_v2 + prefix, same for other columns.

Jahd Jabre Over a year ago

for now i have 226 columns, i want one line with 226 x 8 columns

Piotr Over a year ago

Right, then you mean a pivot table

Jahd Jabre Over a year ago

i tried with valueError : no groupe keys passed –

Harshil Anuwadia · Accepted Answer · 2022-06-01 08:50:35Z

1

You can use transpose() function to transpose index and columns. Reflect the DataFrame over its main diagonal by writing rows as columns and vice-versa.

answered Jun 1, 2022 at 8:50

Harshil Anuwadia

116 bronze badges

Comments

Shivaditya kr · Accepted Answer · 2022-12-26 13:44:41Z

0

array([[1, 2, 3],
       [4, 5, 6],
       [1, 2, 3],
       [1, 2, 3],
       [1, 2, 3]])

# insert col in array
newCol = [0,0,0,0,0]
arrNew = (np.vstack([arr.transpose(), newCol])).transpose()

array([[1, 2, 3, 0],
       [4, 5, 6, 0],
       [1, 2, 3, 0],
       [1, 2, 3, 0],
       [1, 2, 3, 0]])

answered Dec 26, 2022 at 13:44

Shivaditya kr

931 silver badge8 bronze badges

Comments

Xascoria Dung · Accepted Answer · 2022-06-01 08:48:58Z

-1

There's a transpose function in pandas

https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.transpose.html?highlight=transpose#pandas.DataFrame.transpose

answered Jun 1, 2022 at 8:48

Xascoria Dung

731 silver badge9 bronze badges

2 Comments

Tyler2P Over a year ago

While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes.

Nick Vence Jan 28 at 16:28

Posts should answer the question directly (in writing) rather than indirectly (in a link). Would you consider removing this post so it doesn't separate the actual answer (below) away from the question?

Collectives™ on Stack Overflow

How to transpose rows into columns in python?

4 Answers 4

4 Comments

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related