#Import pandas module import pandas as pd  # Define the dataframe DF = pd.DataFrame({'y': [1,4], 'female': [2,5], 'male': [3,6]})  # Gather/melt the data frame pd.melt(DF, id_vars='y', value_vars=['female', 'male'],var_name='gender', value_name='value') 

Read more of this post