回答編集履歴
1
タイポを修正
answer
CHANGED
|
@@ -1,6 +1,11 @@
|
|
|
1
|
+
``pandas.DataFrame.pivot()``をお使いください
|
|
2
|
+
|
|
3
|
+
[https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.pivot.html
|
|
4
|
+
](https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.pivot.html)
|
|
5
|
+
|
|
1
6
|
```Python
|
|
2
7
|
import pandas as pd
|
|
3
|
-
|
|
8
|
+
df = pd.DataFrame(
|
|
4
9
|
[['A001','S001','●'],
|
|
5
10
|
['A002','S001','×'],
|
|
6
11
|
['A003','S001','●'],
|
|
@@ -9,7 +14,7 @@
|
|
|
9
14
|
['A003','S002','●']],
|
|
10
15
|
columns=['col1','col2','col3'])
|
|
11
16
|
|
|
12
|
-
print(
|
|
17
|
+
print(df.pivot(index='col2', columns='col1', values='col3'))
|
|
13
18
|
#col1 A001 A002 A003
|
|
14
19
|
#col2
|
|
15
20
|
#S001 ● × ●
|