how do you transform dataframes in python pandas

Question

I have this data frame:

key         value
EXE_PATH     /opt/IBM/ITM/aix526/ux/bin/kuxagent 
EXE_NAME      kuxagent

I need to transform this data frame to be like this. Key values need to be column names and values need to be row entries

EXE_PATH                             EXE_NAME
/opt/IBM/ITM/aix526/ux/bin/kuxagent   kuxagent

In general, you need a third column which relates each pair of records to a single group. — Tim Biegeleisen
– Tim Biegeleisen, Commented Apr 19, 2022 at 4:16

rcshon · Accepted Answer · 2022-04-19 04:38:41Z

1

You can do a transpose, with some additional steps to clean up the key and value:

df.set_index('key').T.reset_index(drop=True)

But perhaps a better question to ask is how did you end up with the first dataframe and if it is possible to work on the input before trying to fight pandas in how it represents your data as a dataframe.

answered Apr 19, 2022 at 4:38

rcshon

9271 gold badge7 silver badges12 bronze badges

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

Comments

Zero · Accepted Answer · 2022-04-19 04:40:23Z

1

If df looks like this.

	key	value
0	EXE_PATH	/opt/IBM/ITM/aix526/ux/bin/kuxagent
1	EXE_NAME	kuxagent

You can make the key's the columns and the values the rows using the code below.

new_df = df.T.iloc[1:, :]
new_df.columns = df["key"]
new_df

answered Apr 19, 2022 at 4:40

Zero

1,9091 gold badge10 silver badges24 bronze badges

Collectives™ on Stack Overflow

how do you transform dataframes in python pandas

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related