CODEWITHSUNDEEP
pythonpandas
mrichman
mrichman

Reputation: 41

How to convert column values into column headers in python?

Hi i'm trying to pivot a df. I would like to convert column values to row headers. Thanks in advance.

How can I change this:

name
0   countryCode
1   vatNumber
2   requestDate
3   valid
4   name
5   address

to this in python? 

name  countryCode  vatNumber requestDate valid name address
0

Upvotes: 0

Views: 1496

Answers (1)

Mohit Motwani
Mohit Motwani

Reputation: 4792

You can use, df.T as below:

df = pd.DataFrame({'name': ['countryCode', 'vatNumber','requestDate', 'valid', 'name', 'address']})

df = df.T
df

             0        1          2            3          4        5
name    countryCode vatNumber   requestDate valid      name    address

df.columns = df.values[0]
df = df.reset_index(drop = True)
df


    countryCode vatNumber   requestDate valid   name    address
0   countryCode vatNumber   requestDate valid   name    address

Then replace all non null values with np.nan:

df[df.notna()] = np.nan
df
countryCode vatNumber   requestDate valid   name    address
0   NaN        NaN          NaN       NaN   NaN      NaN

Upvotes: 2

Related Questions