Using Panda


In [2]:
import pandas as pd
pd.set_option('display.mpl_style', 'default') # matplotlib.pyplot.style.use

In [7]:
broken_df = pd.read_csv('../data/test.csv')

broken_df


Out[7]:
Date Unnamed: 1 Berri1 Maisonneuve_1 Maisonneuve_2 Brbeuf
0 01/01/2009 00:00 29 20 35 NaN
1 02/01/2009 00:00 19 3 22 NaN
2 03/01/2009 00:00 24 12 22 NaN
3 04/01/2009 00:00 24 8 15 NaN
4 05/01/2009 00:00 120 111 141 NaN
5 06/01/2009 00:00 261 146 236 NaN
6 07/01/2009 00:00 60 33 80 NaN
7 08/01/2009 00:00 24 14 14 NaN
8 09/01/2009 00:00 35 20 32 NaN
9 10/01/2009 00:00 81 45 79 NaN
10 11/01/2009 00:00 318 160 306 NaN
11 12/01/2009 00:00 105 99 170 NaN
12 13/01/2009 00:00 168 94 172 NaN
13 14/01/2009 00:00 145 87 175 NaN
14 15/01/2009 00:00 131 90 172 NaN
15 16/01/2009 00:00 93 49 97 NaN
16 17/01/2009 00:00 25 13 20 NaN
17 18/01/2009 00:00 52 22 55 NaN
18 19/01/2009 00:00 136 127 202 NaN
19 20/01/2009 00:00 147 85 176 NaN
20 21/01/2009 00:00 109 63 137 NaN
21 22/01/2009 00:00 172 125 205 NaN
22 23/01/2009 00:00 148 81 153 NaN
23 24/01/2009 00:00 15 1 10 NaN
24 25/01/2009 00:00 35 14 28 NaN
25 26/01/2009 00:00 93 85 136 NaN
26 27/01/2009 00:00 209 119 221 NaN
27 28/01/2009 00:00 92 52 113 NaN
28 29/01/2009 00:00 110 80 117 NaN
29 30/01/2009 00:00 105 60 106 NaN
... ... ... ... ... ... ...
335 02/12/2009 00:00 1377 711 1867 0.0
336 03/12/2009 00:00 606 367 921 0.0
337 04/12/2009 00:00 1108 595 1472 0.0
338 05/12/2009 00:00 594 301 746 0.0
339 06/12/2009 00:00 501 276 679 0.0
340 07/12/2009 00:00 669 358 1039 0.0
341 08/12/2009 00:00 570 318 807 0.0
342 09/12/2009 00:00 185 64 274 0.0
343 10/12/2009 00:00 219 110 363 0.0
344 11/12/2009 00:00 194 77 378 0.0
345 12/12/2009 00:00 106 84 210 0.0
346 13/12/2009 00:00 130 49 113 0.0
347 14/12/2009 00:00 271 123 433 0.0
348 15/12/2009 00:00 308 143 395 0.0
349 16/12/2009 00:00 296 155 350 0.0
350 17/12/2009 00:00 239 118 304 0.0
351 18/12/2009 00:00 214 119 373 0.0
352 19/12/2009 00:00 133 73 162 0.0
353 20/12/2009 00:00 135 62 125 0.0
354 21/12/2009 00:00 239 125 383 0.0
355 22/12/2009 00:00 207 107 353 0.0
356 23/12/2009 00:00 158 84 204 0.0
357 24/12/2009 00:00 74 59 129 0.0
358 25/12/2009 00:00 34 21 36 0.0
359 26/12/2009 00:00 40 21 59 0.0
360 27/12/2009 00:00 66 29 52 0.0
361 28/12/2009 00:00 61 41 99 0.0
362 29/12/2009 00:00 89 52 115 0.0
363 30/12/2009 00:00 76 43 115 0.0
364 31/12/2009 00:00 53 46 112 0.0

365 rows × 6 columns


In [ ]:


In [10]:
broken_df['Berri1'].plot() # plot easier


Out[10]:
<matplotlib.axes._subplots.AxesSubplot at 0x110fff0d0>

In [ ]: