1

I have a Dataframe as below.

data = {'Year':["2012", "2013", "2014", "2015","2016"], 
       'Matthew':[80,83,85,90,91], 
       'Aakash':[85,75,95,92,93], 
       'Jill': [90,70,100,80,85]} 
  
df = pd.DataFrame(data) 
   Year  Matthew  Aakash  Jill
0  2012       80      85    90
1  2013       83      75    70
2  2014       85      95   100
3  2015       90      92    80
4  2016       91      93    85

How do I transform it to below?

Expected Result:

data2 = {'Year':["2012","2012","2012", "2013","2013","2013","2014","2014","2014","2015","2015","2015","2016","2016","2016"], 
        'Name':['Matthew','Aakash','Jill','Matthew','Aakash','Jill','Matthew','Aakash','Jill','Matthew','Aakash','Jill','Matthew','Aakash','Jill'],
        'Results':[80,85,90,83,75,70,85,95,100,90,92,80,91,93,85]
        }  

df2 = pd.DataFrame(data2) 
    Year     Name  Results
0   2012  Matthew       80
1   2012   Aakash       85
2   2012     Jill       90
3   2013  Matthew       83
4   2013   Aakash       75
5   2013     Jill       70
6   2014  Matthew       85
7   2014   Aakash       95
8   2014     Jill      100
9   2015  Matthew       90
10  2015   Aakash       92
11  2015     Jill       80
12  2016  Matthew       91
13  2016   Aakash       93
14  2016     Jill       85
Cainã Max Couto-Silva
  • 4,839
  • 1
  • 11
  • 35
Ashish
  • 11
  • 1

0 Answers0