pandas - how to make two rows to single row based on index in python

Question

I am trying to convert data frame with two rows as single row. here i am placing tables for better understanding.

This is my actual output

how to convert above table to single row (see below table)

question from:https://stackoverflow.com/questions/65936142/how-to-make-two-rows-to-single-row-based-on-index-in-python

Answer 1

Use DataFrame.set_index with DataFrame.stack for MultiIndex Series, convert to one column DataFrame by Series.to_frame and transpose for one row DataFrame, last flatten MultiIndex by join:

df1 = s.set_index('Gender').stack().to_frame().T
df1.columns = df1.columns.map(lambda x: f'{x[0]} {x[1]}')