回答編集履歴
2
修正
answer
CHANGED
|
@@ -6,6 +6,9 @@
|
|
|
6
6
|
import numpy as np
|
|
7
7
|
import matplotlib.pyplot as plt
|
|
8
8
|
|
|
9
|
+
areas = ['関東', '関西', '大阪']
|
|
10
|
+
df_test['エリア'] = areas
|
|
11
|
+
|
|
9
12
|
df_test = pd.DataFrame({
|
|
10
13
|
'ID': [1111, 2222, 3333],
|
|
11
14
|
'日付': ['2022/1/1', '2022/1/1', '2022/1/2'],
|
|
@@ -15,15 +18,12 @@
|
|
|
15
18
|
|
|
16
19
|
|
|
17
20
|
pivot = df_test.pivot_table(
|
|
18
|
-
values = 'ID',
|
|
21
|
+
values = ['ID'],
|
|
19
|
-
index = '日付',
|
|
22
|
+
index = ['日付'],
|
|
20
|
-
columns = '種別',
|
|
23
|
+
columns = ['種別'],
|
|
21
24
|
aggfunc = 'sum',
|
|
22
25
|
).reset_index()
|
|
23
26
|
|
|
24
|
-
areas = ['関東', '関西', '大阪']
|
|
25
|
-
df_test['エリア'] = areas
|
|
26
|
-
|
|
27
27
|
print(df_test)
|
|
28
28
|
|
|
29
29
|
```
|
1
修正
answer
CHANGED
|
@@ -1,4 +1,5 @@
|
|
|
1
1
|
pandasは使ったことがないのですが、このような感じでしょうか
|
|
2
|
+
グラフ化はしていませんが
|
|
2
3
|
|
|
3
4
|
```python
|
|
4
5
|
import pandas as pd
|