pandas melt() function, change the DataFrame format from wide to long

Impossible Impala answered on March 25, 2022 Popularity 5/10 Helpfulness 4/10

answer pandas melt() function, change the DataFrame format from wide to long

pandas melt() function, change the DataFrame format from wide to long

Comment

# pandas melt() function, change the DataFrame format from wide to long
import pandas as pd
df = pd.DataFrame({'Name': ['Bob', 'John', 'Foo', 'Bar', 'Alex', 'Tom'], 
                   'Math': ['A+', 'B', 'A', 'F', 'D', 'C'], 
                   'English': ['C', 'B', 'B', 'A+', 'F', 'A'],
                   'Age': [13, 16, 16, 15, 15, 13]})
df
  
#Use Melt
df1 = df.melt(id_vars=['Name', 'Age'], var_name='Subject', value_name='Grades')
df1
print(df1)

Popularity 5/10 Helpfulness 4/10 Language python

Source: Grepper

Tags: dataframe format python

Link to this answer
Share Copy Link

Contributed on Mar 25 2022

Impossible Impala

0 Answers Avg Quality 2/10

pandas melt() function, change the DataFrame format from wide to long

Contents

More Related Answers

pandas melt() function, change the DataFrame format from wide to long

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.