回答編集履歴
1
Update
answer
CHANGED
|
@@ -7,7 +7,8 @@
|
|
|
7
7
|
print(dfx)
|
|
8
8
|
|
|
9
9
|
# pivot
|
|
10
|
-
dfy = df.pivot_table(index='name', columns='subject', values='score')
|
|
10
|
+
dfy = df.pivot_table(index='name', columns='subject', values='score', sort=False)
|
|
11
|
+
dfy = dfy[['math','english','physics']] # columns order
|
|
11
12
|
print(dfy)
|
|
12
13
|
|
|
13
14
|
#
|
|
@@ -16,9 +17,9 @@
|
|
|
16
17
|
1 Jiro [92, 97, 90]
|
|
17
18
|
2 Ken [100, 70, 92]
|
|
18
19
|
|
|
19
|
-
subject
|
|
20
|
+
subject math english physics
|
|
20
21
|
name
|
|
22
|
+
Taro 86 92 80
|
|
21
|
-
Jiro
|
|
23
|
+
Jiro 92 97 90
|
|
22
|
-
Ken
|
|
24
|
+
Ken 100 70 92
|
|
23
|
-
Taro 92 86 80
|
|
24
25
|
```
|