回答編集履歴
1
CSV版を追加
test
CHANGED
@@ -98,6 +98,106 @@
|
|
98
98
|
|
99
99
|
```
|
100
100
|
|
101
|
+
**### CSV版 ###**
|
102
|
+
|
103
|
+
```Python
|
104
|
+
|
105
|
+
import pandas as pd
|
106
|
+
|
107
|
+
import matplotlib.pyplot as plt
|
108
|
+
|
109
|
+
import matplotlib.dates as mdates
|
110
|
+
|
111
|
+
import io
|
112
|
+
|
113
|
+
|
114
|
+
|
115
|
+
dummy_csv = """
|
116
|
+
|
117
|
+
,from,to,value,datetime
|
118
|
+
|
119
|
+
0,0x4e6f10ed3b919cbbd872807f866ded9acdf7eede,,0.0,2019-01-08 10:28:22
|
120
|
+
|
121
|
+
1,0x5a4d185c590c5815a070ed62c278e665d137a0d9,0x6cb4ad504816bd3021ae48286f018ac725239b89,0.024,2019-01-11 02:00:23
|
122
|
+
|
123
|
+
2,0x5a4d185c590c5815a070ed62c278e665d137a0d9,0x6cb4ad504816bd3021ae48286f018ac725239b89,0.024,2019-01-11 07:12:22
|
124
|
+
|
125
|
+
3,0x5a4d185c590c5815a070ed62c278e665d137a0d9,0x6cb4ad504816bd3021ae48286f018ac725239b89,0.024,2019-01-11 07:13:43
|
126
|
+
|
127
|
+
4,0x5a4d185c590c5815a070ed62c278e665d137a0d9,0x6cb4ad504816bd3021ae48286f018ac725239b89,0.024,2019-01-11 07:39:11
|
128
|
+
|
129
|
+
5,0x7efee171ed6e9fd40dff6d7beaeba006d05ba559,0x6cb4ad504816bd3021ae48286f018ac725239b89,0.024,2019-01-11 08:12:38
|
130
|
+
|
131
|
+
6,0x31cdabb1a0b18dd9326f150f352ab2b4597d2bab,0x6cb4ad504816bd3021ae48286f018ac725239b89,0.024,2019-01-11 08:14:46
|
132
|
+
|
133
|
+
7,0x6d603b234a927af2226c0688ad5f8ee7399e984c,0x6cb4ad504816bd3021ae48286f018ac725239b89,0.024,2019-01-11 08:16:14
|
134
|
+
|
135
|
+
8,0x6d603b234a927af2226c0688ad5f8ee7399e984c,0x6cb4ad504816bd3021ae48286f018ac725239b89,0.024,2019-01-11 08:16:58
|
136
|
+
|
137
|
+
9,0xcecddbe88359f6ecebe90b42643b002543f27fe9,0x6cb4ad504816bd3021ae48286f018ac725239b89,0.024,2019-01-11 08:19:33
|
138
|
+
|
139
|
+
10,0x3cd673f4b8e7815f4862222ef0786241f952aeae,0x6cb4ad504816bd3021ae48286f018ac725239b89,0.024,2019-01-11 08:21:24
|
140
|
+
|
141
|
+
11,0x3cd673f4b8e7815f4862222ef0786241f952aeae,0x6cb4ad504816bd3021ae48286f018ac725239b89,0.024,2019-01-11 08:21:32
|
142
|
+
|
143
|
+
12,0x3cd673f4b8e7815f4862222ef0786241f952aeae,0x6cb4ad504816bd3021ae48286f018ac725239b89,0.024,2019-01-11 08:22:05
|
144
|
+
|
145
|
+
13,0x02632569d858370906ac6116b0ae25059fb34a82,0x6cb4ad504816bd3021ae48286f018ac725239b89,0.216,2019-01-11 08:22:05
|
146
|
+
|
147
|
+
14,0x3cd673f4b8e7815f4862222ef0786241f952aeae,0x6cb4ad504816bd3021ae48286f018ac725239b89,0.024,2019-01-11 08:22:22
|
148
|
+
|
149
|
+
15,0x3c5f0629535c755453ad88ef1fd433022f9d306a,0x6cb4ad504816bd3021ae48286f018ac725239b89,0.024,2019-01-11 08:23:32
|
150
|
+
|
151
|
+
16,0xbae25a69a6eb7341ee834be7635e247e22a1e57a,0x6cb4ad504816bd3021ae48286f018ac725239b89,0.024,2019-01-11 08:25:05
|
152
|
+
|
153
|
+
17,0xde9fcd2c2d0f20699b6f08cc4d449499271d8f18,0x6cb4ad504816bd3021ae48286f018ac725239b89,0.024,2019-01-11 08:25:09
|
154
|
+
|
155
|
+
18,0x862244eeca0c73925b5a4daa14815fb81f499c93,0x6cb4ad504816bd3021ae48286f018ac725239b89,0.024,2019-01-11 08:26:08
|
156
|
+
|
157
|
+
19,0xc35a5fec6be6957899e15559be252db882220b37,0x6cb4ad504816bd3021ae48286f018ac725239b89,0.024,2019-01-11 08:27:17
|
158
|
+
|
159
|
+
20,0xcc55a426d4221d299a4586aaa0cef6e5c12783a4,0x6cb4ad504816bd3021ae48286f018ac725239b89,0.024,2019-01-11 08:27:17
|
160
|
+
|
161
|
+
"""
|
162
|
+
|
163
|
+
|
164
|
+
|
165
|
+
df = pd.read_csv(io.StringIO(dummy_csv), parse_dates=['datetime'], index_col='datetime')
|
166
|
+
|
167
|
+
print(df)
|
168
|
+
|
169
|
+
|
170
|
+
|
171
|
+
conv_df = df.resample('1d').agg({
|
172
|
+
|
173
|
+
'from': lambda d:d.drop_duplicates().count(),
|
174
|
+
|
175
|
+
'value': 'sum'})
|
176
|
+
|
177
|
+
print(conv_df)
|
178
|
+
|
179
|
+
# value from
|
180
|
+
|
181
|
+
#datetime
|
182
|
+
|
183
|
+
#2019-01-08 0.000, 1
|
184
|
+
|
185
|
+
#2019-01-09 0.000, 0
|
186
|
+
|
187
|
+
#2019-01-10 0.000, 0
|
188
|
+
|
189
|
+
#2019-01-11 0.672,13
|
190
|
+
|
191
|
+
|
192
|
+
|
193
|
+
conv_df.plot() #グラフを書く
|
194
|
+
|
195
|
+
plt.show() #表示
|
196
|
+
|
197
|
+
```
|
198
|
+
|
199
|
+
|
200
|
+
|
101
201
|
|
102
202
|
|
103
203
|
![イメージ説明](8775dd7335136c0c99fd0f912ab5359a.png)
|