回答編集履歴
1
コードを説明に合わせて修正
answer
CHANGED
|
@@ -36,11 +36,11 @@
|
|
|
36
36
|
"""
|
|
37
37
|
|
|
38
38
|
df = pd.read_csv(io.StringIO(txt), dtype={'time': str})
|
|
39
|
-
# df = pd.read_csv('File.csv', dtype={'
|
|
39
|
+
# df = pd.read_csv('File.csv', dtype={'time': str})
|
|
40
40
|
# print(df)
|
|
41
41
|
|
|
42
42
|
matrix = df.pivot(index=['date', 'item'], columns='time', values=['num', 'fav'])
|
|
43
|
-
print(matrix)
|
|
43
|
+
# print(matrix)
|
|
44
44
|
|
|
45
45
|
# favの列をひとつにする
|
|
46
46
|
matrix['tmp'] = matrix.iloc[:, 2]
|