How to change rows name to column name in dataframe using python?

Question

i have two dataframe:

  df1:
     colname   value
     gender     M
     status     business
     age        60

  df2:
     colname   value
     name       Susan
     Place      Africa
     gender     F

Is there a way i can concatenate these two dataframe in a way as the expected output? I tried outer join but it doesnot work, Thank you in advance.

Note: No dataframes have always the same common attribute, and also I am trying to remove the colname and value column.

Expected output:

    gender status     age  name  Place 
0    M     business   60   0      0
1    F     0           0   Susan Africa

mozway · Accepted Answer · 2022-09-28 07:03:29Z

1

You can convert to Series with colname as index and concat:

dfs = [df1, df2]

out = pd.concat([d.set_index('colname')['value'] for d in dfs],
                axis=1, ignore_index=True).T

output:

colname gender    status  age   name   Place
0            M  business   60    NaN     NaN
1            F       NaN  NaN  Susan  Africa

answered Sep 28, 2022 at 7:03

mozway

267k13 gold badges56 silver badges106 bronze badges

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

Comments

alina · Accepted Answer · 2022-09-28 07:12:14Z

0

Try this:

pd.concat([df1, df2], axis=0).fillna(0).reset_index(drop=True)

    gender    status   age   name   place
0      M    business   60      0       0
1      F           0    0  Susan  Africa

The fillna will replace the NaN values with 0.

answered Sep 28, 2022 at 7:12

alina

586 bronze badges

Comments

cottontail · Accepted Answer · 2022-09-28 16:37:47Z

0

Below line will resolves your issue , you can use the pandas transpose function to solve this problem.

df_new = pd.concat([df1,df2])
df_new.set_index("colname").T

edited Sep 28, 2022 at 16:37

cottontail

25.6k25 gold badges184 silver badges176 bronze badges

answered Sep 28, 2022 at 7:16

sujith kumar

193 bronze badges

Collectives™ on Stack Overflow

How to change rows name to column name in dataframe using python?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related