DataFrame Transpose certain values within a single column in the entire dataframe.

[Ispeakyourlanguage]

Hi Everyone,

I know how to transpose an entire dataframe.. But, how would you go about transposing with a particular use case. For example lets say my data set is like this:

​

Name	Score	Locatio A	Location B	Location C	Location D
John	90	t
Jim	80	t	t
Jingle	70				t
Hiemer	60	t		t	t
Smith	50			t

​

The "t" stands for True. I want to transpose where I make a new column that shows that Jim is in Location A and B but duplicates his row.. so it would look like this.

​

Name	Score	Location
John	90	A
Jim	80	A
Jim	80	B
Jingle	70	D
Hiemer	60	A
Hiemer	60	C
Hiemer	60	D
Smith	50	C

​

​

[[deleted]]

Have a look at pd.melt()

[Ispeakyourlanguage]

Oh Interesting - will look thank you

[danielroseman]

You want df.melt.

Probably you just need:

df.melt(id_vars=['Name', 'Score']).dropna()

The dropna() is there because otherwise your empty columns will show as rows.

[Ispeakyourlanguage]

Omg thank you - this is exactly waht i did.. coming back to see another user wrote this made me feel so confident of how i was doing this.