Problème datetime avec Matplotlib

**ssskyyy** · 22/08/2019, 11h38

Bonjour à tous,

Je suis en train de me tirer les cheveux pour afficher une série avec matplotlib.

J'ai un Dataframe pandas :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
import pandas as pd
import matplotlib.pyplot as plt
from datetime import datetime, date

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
type(df)
<class 'pandas.core.frame.DataFrame'>

Voici ce qu'il contient :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
AnneeObs  MoisObs  JourObs  NbFluxEntrant
0        2019        8       19            763
1        2019        8        1           1098
..        ...      ...      ...            ...
655      2017       11        1            428
656      2017       11       13           1530
 
[657 rows x 4 columns]

Ensuite, je converti mes dates en Datetime :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
for i in range(0,len(df)):
     df.loc[i,"dateObs"] = date(year=df.iloc[i,0], month=df.iloc[i,1], day=df.iloc[i,2])
 
df['dateObs'] = pd.DatetimeIndex(df['dateObs'])
df = df.sort_values("dateObs", ascending=True)
 
df2 = df[["dateObs", "NbFluxEntrant"]]
 
df2bis = df2.copy()
df2bis = df2bis.set_index('dateObs')
 
df2bis

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
 
                NbFluxEntrant
dateObs                  
2017-11-01            428
2017-11-02            931
...                   ...
2019-08-18            243
2019-08-19            763
 
[657 rows x 1 columns]

J'ai forcé un peu pour le Datetime :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

df2bis.index = pd.to_datetime(df2bis.index)

Je vérifie le format :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
type(df2bis.index)
<class 'pandas.core.indexes.datetimes.DatetimeIndex'>

Je tente de faire un plot :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

df2bis.plot()

Et j'ai un sublime message :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
Fail to execute line 1: df2bis.plot()
Traceback (most recent call last):
  File "/tmp/zeppelin_pyspark-1746195241640848046.py", line 380, in <module>
    exec(code, _zcUserQueryNameSpace)
  File "<stdin>", line 1, in <module>
  File "/usr/local/lib/python2.7/dist-packages/pandas/plotting/_core.py", line 2941, in __call__
    sort_columns=sort_columns, **kwds)
  File "/usr/local/lib/python2.7/dist-packages/pandas/plotting/_core.py", line 1977, in plot_frame
    **kwds)
  File "/usr/local/lib/python2.7/dist-packages/pandas/plotting/_core.py", line 1804, in _plot
    plot_obj.generate()
  File "/usr/local/lib/python2.7/dist-packages/pandas/plotting/_core.py", line 260, in generate
    self._make_plot()
  File "/usr/local/lib/python2.7/dist-packages/pandas/plotting/_core.py", line 985, in _make_plot
    **kwds)
  File "/usr/local/lib/python2.7/dist-packages/pandas/plotting/_core.py", line 1024, in _ts_plot
    lines = cls._plot(ax, data.index, data.values, style=style, **kwds)
  File "/usr/local/lib/python2.7/dist-packages/pandas/plotting/_core.py", line 1001, in _plot
    lines = MPLPlot._plot(ax, x, y_values, style=style, **kwds)
  File "/usr/local/lib/python2.7/dist-packages/pandas/plotting/_core.py", line 615, in _plot
    return ax.plot(*args, **kwds)
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/__init__.py", line 1867, in inner
    return func(ax, *args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/axes/_axes.py", line 1528, in plot
    for line in self._get_lines(*args, **kwargs):
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/axes/_base.py", line 406, in _grab_next_args
    for seg in self._plot_args(this, kwargs):
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/axes/_base.py", line 383, in _plot_args
    x, y = self._xy_from_xy(x, y)
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/axes/_base.py", line 215, in _xy_from_xy
    bx = self.axes.xaxis.update_units(x)
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/axis.py", line 1474, in update_units
    self._update_axisinfo()
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/axis.py", line 1492, in _update_axisinfo
    self.set_major_locator(info.majloc)
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/axis.py", line 1597, in set_major_locator
    self.stale = True
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/artist.py", line 241, in stale
    self.stale_callback(self, val)
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/artist.py", line 68, in _stale_axes_callback
    self.axes.stale = val
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/artist.py", line 241, in stale
    self.stale_callback(self, val)
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/figure.py", line 60, in _stale_figure_callback
    self.figure.stale = val
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/artist.py", line 241, in stale
    self.stale_callback(self, val)
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/pyplot.py", line 577, in _auto_draw_if_interactive
    fig.canvas.draw_idle()
  File "/home/zeppelin/interpreter/lib/python/backend_zinline.py", line 136, in draw_idle
    self.draw(*args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/backends/backend_agg.py", line 437, in draw
    self.figure.draw(self.renderer)
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/artist.py", line 55, in draw_wrapper
    return draw(artist, renderer, *args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/figure.py", line 1493, in draw
    renderer, self, artists, self.suppressComposite)
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/image.py", line 141, in _draw_list_compositing_images
    a.draw(renderer)
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/artist.py", line 55, in draw_wrapper
    return draw(artist, renderer, *args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/axes/_base.py", line 2635, in draw
    mimage._draw_list_compositing_images(renderer, self, artists)
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/image.py", line 141, in _draw_list_compositing_images
    a.draw(renderer)
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/artist.py", line 55, in draw_wrapper
    return draw(artist, renderer, *args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/axis.py", line 1190, in draw
    ticks_to_draw = self._update_ticks(renderer)
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/axis.py", line 1028, in _update_ticks
    tick_tups = list(self.iter_ticks())  # iter_ticks calls the locator
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/axis.py", line 971, in iter_ticks
    majorLocs = self.major.locator()
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/dates.py", line 1249, in __call__
    self.refresh()
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/dates.py", line 1269, in refresh
    dmin, dmax = self.viewlim_to_dt()
  File "/usr/local/lib/python2.7/dist-packages/matplotlib/dates.py", line 1026, in viewlim_to_dt
    .format(vmin))
ValueError: view limit minimum 0.0 is less than 1 and is an invalid Matplotlib date value. This often happens if you pass a non-datetime value to an axis that has datetime units

J'ai tenté d'autres choses :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

df2bis.plot(x="dateObs", y="NbFluxEntrant")

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Fail to execute line 1: df2bis.plot(x="dateObs", y="NbFluxEntrant")
Traceback (most recent call last):
  File "/tmp/zeppelin_pyspark-1746195241640848046.py", line 380, in <module>
    exec(code, _zcUserQueryNameSpace)
  File "<stdin>", line 1, in <module>
  File "/usr/local/lib/python2.7/dist-packages/pandas/plotting/_core.py", line 2941, in __call__
    sort_columns=sort_columns, **kwds)
  File "/usr/local/lib/python2.7/dist-packages/pandas/plotting/_core.py", line 1977, in plot_frame
    **kwds)
  File "/usr/local/lib/python2.7/dist-packages/pandas/plotting/_core.py", line 1766, in _plot
    elif not isinstance(data[x], ABCSeries):
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/frame.py", line 2685, in __getitem__
    return self._getitem_column(key)
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/frame.py", line 2692, in _getitem_column
    return self._get_item_cache(key)
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/generic.py", line 2486, in _get_item_cache
    values = self._data.get(item)
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/internals.py", line 4115, in get
    loc = self.items.get_loc(item)
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/indexes/base.py", line 3065, in get_loc
    return self._engine.get_loc(self._maybe_cast_indexer(key))
  File "pandas/_libs/index.pyx", line 140, in pandas._libs.index.IndexEngine.get_loc
  File "pandas/_libs/index.pyx", line 162, in pandas._libs.index.IndexEngine.get_loc
  File "pandas/_libs/hashtable_class_helper.pxi", line 1492, in pandas._libs.hashtable.PyObjectHashTable.get_item
  File "pandas/_libs/hashtable_class_helper.pxi", line 1500, in pandas._libs.hashtable.PyObjectHashTable.get_item
KeyError: 'dateObs'

Et ça aussi :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

df2bis.plot(x=df2bis.index.values, y="NbFluxEntrant")

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Fail to execute line 1: df2bis.plot(x=df2bis.index.values, y="NbFluxEntrant")
Traceback (most recent call last):
  File "/tmp/zeppelin_pyspark-1746195241640848046.py", line 380, in <module>
    exec(code, _zcUserQueryNameSpace)
  File "<stdin>", line 1, in <module>
  File "/usr/local/lib/python2.7/dist-packages/pandas/plotting/_core.py", line 2941, in __call__
    sort_columns=sort_columns, **kwds)
  File "/usr/local/lib/python2.7/dist-packages/pandas/plotting/_core.py", line 1977, in plot_frame
    **kwds)
  File "/usr/local/lib/python2.7/dist-packages/pandas/plotting/_core.py", line 1766, in _plot
    elif not isinstance(data[x], ABCSeries):
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/frame.py", line 2679, in __getitem__
    return self._getitem_array(key)
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/frame.py", line 2723, in _getitem_array
    indexer = self.loc._convert_to_indexer(key, axis=1)
  File "/usr/local/lib/python2.7/dist-packages/pandas/core/indexing.py", line 1327, in _convert_to_indexer
    .format(mask=objarr[mask]))
KeyError: "['2017-11-01T00:00:00.000000000' '2017-11-02T00:00:00.000000000'\n '2017-11-03T00:00:00.000000000' '2017-11-04T00:00:00.000000000'\n '2017-11-05T00:00:00.000000000' '2017-11-06T00:00:00.000000000'\n '2017-11-07T00:00:00.000000000' '2017-11-08T00:00:00.000000000'\n '2017-11-09T00:00:00.000000000' '2017-11-10T00:00:00.000000000'\n '2017-11-11T00:00:00.000000000' '2017-11-12T00:00:00.000000000'\n '2017-11-13T00:00:00.000000000' '2017-11-14T00:00:00.000000000'\n '2017-11-15T00:00:00.000000000' '2017-11-16T00:00:00.000000000'\n '2017-11-17T00:00:00.000000000' '2017-11-18T00:00:00.000000000'\n '2017-11-19T00:00:00.000000000' '2017-11-20T00:00:00.000000000'\n '2017-11-21T00:00:00.000000000' '2017-11-22T00:00:00.000000000'\n '2017-11-23T00:00:00.000000000' '2017-11-24T00:00:00.000000000'\n '2017-11-25T00:00:00.000000000' '2017-11-26T00:00:00.000000000'\n '2017-11-27T00:00:00.000000000' '2017-11-28T00:00:00.000000000'\n '2017-11-29T00:00:00.000000000' '2017-11-30T00:00:00.000000000'\n '2017-12-01T00:00:00.000000000' '2017-12-02T00:00:00.000000000'\n '2017-12-03T00:00:00.000000000' '2017-12-04T00:00:00.000000000'\n '2017-12-05T00:00:00.000000000' '2017-12-06T00:00:00.000000000'\n '2017-12-07T00:00:00.000000000' '2017-12-08T00:00:00.000000000'\n '2017-12-09T00:00:00.000000000' '2017-12-10T00:00:00.000000000'\n '2017-12-11T00:00:00.000000000' '2017-12-12T00:00:00.000000000'\n '2017-12-13T00:00:00.000000000' '2017-12-14T00:00:00.000000000'\n '2017-12-15T00:00:00.000000000' '2017-12-16T00:00:00.000000000'\n '2017-12-17T00:00:00.000000000' '2017-12-18T00:00:00.000000000'\n '2017-12-19T00:00:00.000000000' '2017-12-20T00:00:00.000000000'\n '2017-12-21T00:00:00.000000000' '2017-12-22T00:00:00.000000000'\n '2017-12-23T00:00:00.000000000' '2017-12-24T00:00:00.000000000'\n '2017-12-25T00:00:00.000000000' '2017-12-26T00:00:00.000000000'\n '2017-12-27T00:00:00.000000000' '2017-12-28T00:00:00.000000000'\n '2017-12-29T00:00:00.000000000' '2017-12-30T00:00:00.000000000'\n '2017-12-31T00:00:00.000000000' '2018-01-01T00:00:00.000000000'\n '2018-01-02T00:00:00.000000000' '2018-01-03T00:00:00.000000000'\n '2018-01-04T00:00:00.000000000' '2018-01-05T00:00:00.000000000'\n '2018-01-06T00:00:00.000000000' '2018-01-07T00:00:00.000000000'\n '2018-01-08T00:00:00.000000000' '2018-01-09T00:00:00.000000000'\n '2018-01-10T00:00:00.000000000' '2018-01-11T00:00:00.000000000'\n '2018-01-12T00:00:00.000000000' '2018-01-13T00:00:00.000000000'\n '2018-01-14T00:00:00.000000000' '2018-01-15T00:00:00.000000000'\n '2018-01-16T00:00:00.000000000' '2018-01-17T00:00:00.000000000'\n '2018-01-18T00:00:00.000000000' '2018-01-19T00:00:00.000000000'\n '2018-01-20T00:00:00.000000000' '2018-01-21T00:00:00.000000000'\n '2018-01-22T00:00:00.000000000' '2018-01-23T00:00:00.000000000'\n '2018-01-24T00:00:00.000000000' '2018-01-25T00:00:00.000000000'\n '2018-01-26T00:00:00.000000000' '2018-01-27T00:00:00.000000000'\n '2018-01-28T00:00:00.000000000' '2018-01-29T00:00:00.000000000'\n '2018-01-30T00:00:00.000000000' '2018-01-31T00:00:00.000000000'\n '2018-02-01T00:00:00.000000000' '2018-02-02T00:00:00.000000000'\n '2018-02-03T00:00:00.000000000' '2018-02-04T00:00:00.000000000'\n '2018-02-05T00:00:00.000000000' '2018-02-06T00:00:00.000000000'\n '2018-02-07T00:00:00.000000000' '2018-02-08T00:00:00.000000000'\n '2018-02-09T00:00:00.000000000' '2018-02-10T00:00:00.000000000'\n '2018-02-11T00:00:00.000000000' '2018-02-12T00:00:00.000000000'\n '2018-02-13T00:00:00.000000000' '2018-02-14T00:00:00.000000000'\n '2018-02-15T00:00:00.000000000' '2018-02-16T00:00:00.000000000'\n '2018-02-17T00:00:00.000000000' '2018-02-18T00:00:00.000000000'\n '2018-02-19T00:00:00.000000000' '2018-02-20T00:00:00.000000000'\n '2018-02-21T00:00:00.000000000' '2018-02-22T00:00:00.000000000'\n '2018-02-23T00:00:00.000000000' '2018-02-24T00:00:00.000000000'\n '2018-02-25T00:00:00.000000000' '2018-02-26T00:00:00.000000000'\n '2018-02-27T00:00:00.000000000' '2018-02-28T00:00:00.000000000'\n '2018-03-01T00:00:00.000000000' '2018-03-02T00:00:00.000000000'\n '2018-03-03T00:00:00.000000000' '2018-03-04T00:00:00.000000000'\n '2018-03-05T00:00:00.000000000' '2018-03-06T00:00:00.000000000'\n '2018-03-07T00:00:00.000000000' '2018-03-08T00:00:00.000000000'\n '2018-03-09T00:00:00.000000000' '2018-03-10T00:00:00.000000000'\n '2018-03-11T00:00:00.000000000' '2018-03-12T00:00:00.000000000'\n '2018-03-13T00:00:00.000000000' '2018-03-14T00:00:00.000000000'\n '2018-03-15T00:00:00.000000000' '2018-03-16T00:00:00.000000000'\n '2018-03-17T00:00:00.000000000' '2018-03-18T00:00:00.000000000'\n '2018-03-19T00:00:00.000000000' '2018-03-20T00:00:00.000000000'\n '2018-03-21T00:00:00.000000000' '2018-03-22T00:00:00.000000000'\n '2018-03-23T00:00:00.000000000' '2018-03-24T00:00:00.000000000'\n '2018-03-25T00:00:00.000000000' '2018-03-26T00:00:00.000000000'\n '2018-03-27T00:00:00.000000000' '2018-03-28T00:00:00.000000000'\n '2018-03-29T00:00:00.000000000' '2018-03-30T00:00:00.000000000'\n '2018-03-31T00:00:00.000000000' '2018-04-01T00:00:00.000000000'\n '2018-04-02T00:00:00.000000000' '2018-04-03T00:00:00.000000000'\n '2018-04-04T00:00:00.000000000' '2018-04-05T00:00:00.000000000'\n '2018-04-06T00:00:00.000000000' '2018-04-07T00:00:00.000000000'\n '2018-04-08T00:00:00.000000000' '2018-04-09T00:00:00.000000000'\n '2018-04-10T00:00:00.000000000' '2018-04-11T00:00:00.000000000'\n '2018-04-12T00:00:00.000000000' '2018-04-13T00:00:00.000000000'\n '2018-04-14T00:00:00.000000000' '2018-04-15T00:00:00.000000000'\n '2018-04-16T00:00:00.000000000' '2018-04-17T00:00:00.000000000'\n '2018-04-18T00:00:00.000000000' '2018-04-19T00:00:00.000000000'\n '2018-04-20T00:00:00.000000000' '2018-04-21T00:00:00.000000000'\n '2018-04-22T00:00:00.000000000' '2018-04-23T00:00:00.000000000'\n '2018-04-24T00:00:00.000000000' '2018-04-25T00:00:00.000000000'\n '2018-04-26T00:00:00.000000000' '2018-04-27T00:00:00.000000000'\n '2018-04-28T00:00:00.000000000' '2018-04-29T00:00:00.000000000'\n '2018-04-30T00:00:00.000000000' '2018-05-01T00:00:00.000000000'\n '2018-05-02T00:00:00.000000000' '2018-05-03T00:00:00.000000000'\n '2018-05-04T00:00:00.000000000' '2018-05-05T00:00:00.000000000'\n '2018-05-06T00:00:00.000000000' '2018-05-07T00:00:00.000000000'\n '2018-05-08T00:00:00.000000000' '2018-05-09T00:00:00.000000000'\n '2018-05-10T00:00:00.000000000' '2018-05-11T00:00:00.000000000'\n '2018-05-12T00:00:00.000000000' '2018-05-13T00:00:00.000000000'\n '2018-05-14T00:00:00.000000000' '2018-05-15T00:00:00.000000000'\n '2018-05-16T00:00:00.000000000' '2018-05-17T00:00:00.000000000'\n '2018-05-18T00:00:00.000000000' '2018-05-19T00:00:00.000000000'\n '2018-05-20T00:00:00.000000000' '2018-05-21T00:00:00.000000000'\n '2018-05-22T00:00:00.000000000' '2018-05-23T00:00:00.000000000'\n '2018-05-24T00:00:00.000000000' '2018-05-25T00:00:00.000000000'\n '2018-05-26T00:00:00.000000000' '2018-05-27T00:00:00.000000000'\n '2018-05-28T00:00:00.000000000' '2018-05-29T00:00:00.000000000'\n '2018-05-30T00:00:00.000000000' '2018-05-31T00:00:00.000000000'\n '2018-06-01T00:00:00.000000000' '2018-06-02T00:00:00.000000000'\n '2018-06-03T00:00:00.000000000' '2018-06-04T00:00:00.000000000'\n '2018-06-05T00:00:00.000000000' '2018-06-06T00:00:00.000000000'\n '2018-06-07T00:00:00.000000000' '2018-06-08T00:00:00.000000000'\n '2018-06-09T00:00:00.000000000' '2018-06-10T00:00:00.000000000'\n '2018-06-11T00:00:00.000000000' '2018-06-12T00:00:00.000000000'\n '2018-06-13T00:00:00.000000000' '2018-06-14T00:00:00.000000000'\n '2018-06-15T00:00:00.000000000' '2018-06-16T00:00:00.000000000'\n '2018-06-17T00:00:00.000000000' '2018-06-18T00:00:00.000000000'\n '2018-06-19T00:00:00.000000000' '2018-06-20T00:00:00.000000000'\n '2018-06-21T00:00:00.000000000' '2018-06-22T00:00:00.000000000'\n '2018-06-23T00:00:00.000000000' '2018-06-24T00:00:00.000000000'\n '2018-06-25T00:00:00.000000000' '2018-06-26T00:00:00.000000000'\n '2018-06-27T00:00:00.000000000' '2018-06-28T00:00:00.000000000'\n '2018-06-29T00:00:00.000000000' '2018-06-30T00:00:00.000000000'\n '2018-07-01T00:00:00.000000000' '2018-07-02T00:00:00.000000000'\n '2018-07-03T00:00:00.000000000' '2018-07-04T00:00:00.000000000'\n '2018-07-05T00:00:00.000000000' '2018-07-06T00:00:00.000000000'\n '2018-07-07T00:00:00.000000000' '2018-07-08T00:00:00.000000000'\n '2018-07-09T00:00:00.000000000' '2018-07-10T00:00:00.000000000'\n '2018-07-11T00:00:00.000000000' '2018-07-12T00:00:00.000000000'\n '2018-07-13T00:00:00.000000000' '2018-07-14T00:00:00.000000000'\n '2018-07-15T00:00:00.000000000' '2018-07-16T00:00:00.000000000'\n '2018-07-17T00:00:00.000000000' '2018-07-18T00:00:00.000000000'\n '2018-07-19T00:00:00.000000000' '2018-07-20T00:00:00.000000000'\n '2018-07-21T00:00:00.000000000' '2018-07-22T00:00:00.000000000'\n '2018-07-23T00:00:00.000000000' '2018-07-24T00:00:00.000000000'\n '2018-07-25T00:00:00.000000000' '2018-07-26T00:00:00.000000000'\n '2018-07-27T00:00:00.000000000' '2018-07-28T00:00:00.000000000'\n '2018-07-29T00:00:00.000000000' '2018-07-30T00:00:00.000000000'\n '2018-07-31T00:00:00.000000000' '2018-08-01T00:00:00.000000000'\n '2018-08-02T00:00:00.000000000' '2018-08-03T00:00:00.000000000'\n '2018-08-04T00:00:00.000000000' '2018-08-05T00:00:00.000000000'\n '2018-08-06T00:00:00.000000000' '2018-08-07T00:00:00.000000000'\n '2018-08-08T00:00:00.000000000' '2018-08-09T00:00:00.000000000'\n '2018-08-10T00:00:00.000000000' '2018-08-11T00:00:00.000000000'\n '2018-08-12T00:00:00.000000000' '2018-08-13T00:00:00.000000000'\n '2018-08-14T00:00:00.000000000' '2018-08-15T00:00:00.000000000'\n '2018-08-16T00:00:00.000000000' '2018-08-17T00:00:00.000000000'\n '2018-08-18T00:00:00.000000000' '2018-08-19T00:00:00.000000000'\n '2018-08-20T00:00:00.000000000' '2018-08-21T00:00:00.000000000'\n '2018-08-22T00:00:00.000000000' '2018-08-23T00:00:00.000000000'\n '2018-08-24T00:00:00.000000000' '2018-08-25T00:00:00.000000000'\n '2018-08-26T00:00:00.000000000' '2018-08-27T00:00:00.000000000'\n '2018-08-28T00:00:00.000000000' '2018-08-29T00:00:00.000000000'\n '2018-08-30T00:00:00.000000000' '2018-08-31T00:00:00.000000000'\n '2018-09-01T00:00:00.000000000' '2018-09-02T00:00:00.000000000'\n '2018-09-03T00:00:00.000000000' '2018-09-04T00:00:00.000000000'\n '2018-09-05T00:00:00.000000000' '2018-09-06T00:00:00.000000000'\n '2018-09-07T00:00:00.000000000' '2018-09-08T00:00:00.000000000'\n '2018-09-09T00:00:00.000000000' '2018-09-10T00:00:00.000000000'\n '2018-09-11T00:00:00.000000000' '2018-09-12T00:00:00.000000000'\n '2018-09-13T00:00:00.000000000' '2018-09-14T00:00:00.000000000'\n '2018-09-15T00:00:00.000000000' '2018-09-16T00:00:00.000000000'\n '2018-09-17T00:00:00.000000000' '2018-09-18T00:00:00.000000000'\n '2018-09-19T00:00:00.000000000' '2018-09-20T00:00:00.000000000'\n '2018-09-21T00:00:00.000000000' '2018-09-22T00:00:00.000000000'\n '2018-09-23T00:00:00.000000000' '2018-09-24T00:00:00.000000000'\n '2018-09-25T00:00:00.000000000' '2018-09-26T00:00:00.000000000'\n '2018-09-27T00:00:00.000000000' '2018-09-28T00:00:00.000000000'\n '2018-09-29T00:00:00.000000000' '2018-09-30T00:00:00.000000000'\n '2018-10-01T00:00:00.000000000' '2018-10-02T00:00:00.000000000'\n '2018-10-03T00:00:00.000000000' '2018-10-04T00:00:00.000000000'\n '2018-10-05T00:00:00.000000000' '2018-10-06T00:00:00.000000000'\n '2018-10-07T00:00:00.000000000' '2018-10-08T00:00:00.000000000'\n '2018-10-09T00:00:00.000000000' '2018-10-10T00:00:00.000000000'\n '2018-10-11T00:00:00.000000000' '2018-10-12T00:00:00.000000000'\n '2018-10-13T00:00:00.000000000' '2018-10-14T00:00:00.000000000'\n '2018-10-15T00:00:00.000000000' '2018-10-16T00:00:00.000000000'\n '2018-10-17T00:00:00.000000000' '2018-10-18T00:00:00.000000000'\n '2018-10-19T00:00:00.000000000' '2018-10-20T00:00:00.000000000'\n '2018-10-21T00:00:00.000000000' '2018-10-22T00:00:00.000000000'\n '2018-10-23T00:00:00.000000000' '2018-10-24T00:00:00.000000000'\n '2018-10-25T00:00:00.000000000' '2018-10-26T00:00:00.000000000'\n '2018-10-27T00:00:00.000000000' '2018-10-28T00:00:00.000000000'\n '2018-10-29T00:00:00.000000000' '2018-10-30T00:00:00.000000000'\n '2018-10-31T00:00:00.000000000' '2018-11-01T00:00:00.000000000'\n '2018-11-02T00:00:00.000000000' '2018-11-03T00:00:00.000000000'\n '2018-11-04T00:00:00.000000000' '2018-11-05T00:00:00.000000000'\n '2018-11-06T00:00:00.000000000' '2018-11-07T00:00:00.000000000'\n '2018-11-08T00:00:00.000000000' '2018-11-09T00:00:00.000000000'\n '2018-11-10T00:00:00.000000000' '2018-11-11T00:00:00.000000000'\n '2018-11-12T00:00:00.000000000' '2018-11-13T00:00:00.000000000'\n '2018-11-14T00:00:00.000000000' '2018-11-15T00:00:00.000000000'\n '2018-11-16T00:00:00.000000000' '2018-11-17T00:00:00.000000000'\n '2018-11-18T00:00:00.000000000' '2018-11-19T00:00:00.000000000'\n '2018-11-20T00:00:00.000000000' '2018-11-21T00:00:00.000000000'\n '2018-11-22T00:00:00.000000000' '2018-11-23T00:00:00.000000000'\n '2018-11-24T00:00:00.000000000' '2018-11-25T00:00:00.000000000'\n '2018-11-26T00:00:00.000000000' '2018-11-27T00:00:00.000000000'\n '2018-11-28T00:00:00.000000000' '2018-11-29T00:00:00.000000000'\n '2018-11-30T00:00:00.000000000' '2018-12-01T00:00:00.000000000'\n '2018-12-02T00:00:00.000000000' '2018-12-03T00:00:00.000000000'\n '2018-12-04T00:00:00.000000000' '2018-12-05T00:00:00.000000000'\n '2018-12-06T00:00:00.000000000' '2018-12-07T00:00:00.000000000'\n '2018-12-08T00:00:00.000000000' '2018-12-09T00:00:00.000000000'\n '2018-12-10T00:00:00.000000000' '2018-12-11T00:00:00.000000000'\n '2018-12-12T00:00:00.000000000' '2018-12-13T00:00:00.000000000'\n '2018-12-14T00:00:00.000000000' '2018-12-15T00:00:00.000000000'\n '2018-12-16T00:00:00.000000000' '2018-12-17T00:00:00.000000000'\n '2018-12-18T00:00:00.000000000' '2018-12-19T00:00:00.000000000'\n '2018-12-20T00:00:00.000000000' '2018-12-21T00:00:00.000000000'\n '2018-12-22T00:00:00.000000000' '2018-12-23T00:00:00.000000000'\n '2018-12-24T00:00:00.000000000' '2018-12-25T00:00:00.000000000'\n '2018-12-26T00:00:00.000000000' '2018-12-27T00:00:00.000000000'\n '2018-12-28T00:00:00.000000000' '2018-12-29T00:00:00.000000000'\n '2018-12-30T00:00:00.000000000' '2018-12-31T00:00:00.000000000'\n '2019-01-01T00:00:00.000000000' '2019-01-02T00:00:00.000000000'\n '2019-01-03T00:00:00.000000000' '2019-01-04T00:00:00.000000000'\n '2019-01-05T00:00:00.000000000' '2019-01-06T00:00:00.000000000'\n '2019-01-07T00:00:00.000000000' '2019-01-08T00:00:00.000000000'\n '2019-01-09T00:00:00.000000000' '2019-01-10T00:00:00.000000000'\n '2019-01-11T00:00:00.000000000' '2019-01-12T00:00:00.000000000'\n '2019-01-13T00:00:00.000000000' '2019-01-14T00:00:00.000000000'\n '2019-01-15T00:00:00.000000000' '2019-01-16T00:00:00.000000000'\n '2019-01-17T00:00:00.000000000' '2019-01-18T00:00:00.000000000'\n '2019-01-19T00:00:00.000000000' '2019-01-20T00:00:00.000000000'\n '2019-01-21T00:00:00.000000000' '2019-01-22T00:00:00.000000000'\n '2019-01-23T00:00:00.000000000' '2019-01-24T00:00:00.000000000'\n '2019-01-25T00:00:00.000000000' '2019-01-26T00:00:00.000000000'\n '2019-01-27T00:00:00.000000000' '2019-01-28T00:00:00.000000000'\n '2019-01-29T00:00:00.000000000' '2019-01-30T00:00:00.000000000'\n '2019-01-31T00:00:00.000000000' '2019-02-01T00:00:00.000000000'\n '2019-02-02T00:00:00.000000000' '2019-02-03T00:00:00.000000000'\n '2019-02-04T00:00:00.000000000' '2019-02-05T00:00:00.000000000'\n '2019-02-06T00:00:00.000000000' '2019-02-07T00:00:00.000000000'\n '2019-02-08T00:00:00.000000000' '2019-02-09T00:00:00.000000000'\n '2019-02-10T00:00:00.000000000' '2019-02-11T00:00:00.000000000'\n '2019-02-12T00:00:00.000000000' '2019-02-13T00:00:00.000000000'\n '2019-02-14T00:00:00.000000000' '2019-02-15T00:00:00.000000000'\n '2019-02-16T00:00:00.000000000' '2019-02-17T00:00:00.000000000'\n '2019-02-18T00:00:00.000000000' '2019-02-19T00:00:00.000000000'\n '2019-02-20T00:00:00.000000000' '2019-02-21T00:00:00.000000000'\n '2019-02-22T00:00:00.000000000' '2019-02-23T00:00:00.000000000'\n '2019-02-24T00:00:00.000000000' '2019-02-25T00:00:00.000000000'\n '2019-02-26T00:00:00.000000000' '2019-02-27T00:00:00.000000000'\n '2019-02-28T00:00:00.000000000' '2019-03-01T00:00:00.000000000'\n '2019-03-02T00:00:00.000000000' '2019-03-03T00:00:00.000000000'\n '2019-03-04T00:00:00.000000000' '2019-03-05T00:00:00.000000000'\n '2019-03-06T00:00:00.000000000' '2019-03-07T00:00:00.000000000'\n '2019-03-08T00:00:00.000000000' '2019-03-09T00:00:00.000000000'\n '2019-03-10T00:00:00.000000000' '2019-03-11T00:00:00.000000000'\n '2019-03-12T00:00:00.000000000' '2019-03-13T00:00:00.000000000'\n '2019-03-14T00:00:00.000000000' '2019-03-15T00:00:00.000000000'\n '2019-03-16T00:00:00.000000000' '2019-03-17T00:00:00.000000000'\n '2019-03-18T00:00:00.000000000' '2019-03-19T00:00:00.000000000'\n '2019-03-20T00:00:00.000000000' '2019-03-21T00:00:00.000000000'\n '2019-03-22T00:00:00.000000000' '2019-03-23T00:00:00.000000000'\n '2019-03-24T00:00:00.000000000' '2019-03-25T00:00:00.000000000'\n '2019-03-26T00:00:00.000000000' '2019-03-27T00:00:00.000000000'\n '2019-03-28T00:00:00.000000000' '2019-03-29T00:00:00.000000000'\n '2019-03-30T00:00:00.000000000' '2019-03-31T00:00:00.000000000'\n '2019-04-01T00:00:00.000000000' '2019-04-02T00:00:00.000000000'\n '2019-04-03T00:00:00.000000000' '2019-04-04T00:00:00.000000000'\n '2019-04-05T00:00:00.000000000' '2019-04-06T00:00:00.000000000'\n '2019-04-07T00:00:00.000000000' '2019-04-08T00:00:00.000000000'\n '2019-04-09T00:00:00.000000000' '2019-04-10T00:00:00.000000000'\n '2019-04-11T00:00:00.000000000' '2019-04-12T00:00:00.000000000'\n '2019-04-13T00:00:00.000000000' '2019-04-14T00:00:00.000000000'\n '2019-04-15T00:00:00.000000000' '2019-04-16T00:00:00.000000000'\n '2019-04-17T00:00:00.000000000' '2019-04-18T00:00:00.000000000'\n '2019-04-19T00:00:00.000000000' '2019-04-20T00:00:00.000000000'\n '2019-04-21T00:00:00.000000000' '2019-04-22T00:00:00.000000000'\n '2019-04-23T00:00:00.000000000' '2019-04-24T00:00:00.000000000'\n '2019-04-25T00:00:00.000000000' '2019-04-26T00:00:00.000000000'\n '2019-04-27T00:00:00.000000000' '2019-04-28T00:00:00.000000000'\n '2019-04-29T00:00:00.000000000' '2019-04-30T00:00:00.000000000'\n '2019-05-01T00:00:00.000000000' '2019-05-02T00:00:00.000000000'\n '2019-05-03T00:00:00.000000000' '2019-05-04T00:00:00.000000000'\n '2019-05-05T00:00:00.000000000' '2019-05-06T00:00:00.000000000'\n '2019-05-07T00:00:00.000000000' '2019-05-08T00:00:00.000000000'\n '2019-05-09T00:00:00.000000000' '2019-05-10T00:00:00.000000000'\n '2019-05-11T00:00:00.000000000' '2019-05-12T00:00:00.000000000'\n '2019-05-13T00:00:00.000000000' '2019-05-14T00:00:00.000000000'\n '2019-05-15T00:00:00.000000000' '2019-05-16T00:00:00.000000000'\n '2019-05-17T00:00:00.000000000' '2019-05-18T00:00:00.000000000'\n '2019-05-19T00:00:00.000000000' '2019-05-20T00:00:00.000000000'\n '2019-05-21T00:00:00.000000000' '2019-05-22T00:00:00.000000000'\n '2019-05-23T00:00:00.000000000' '2019-05-24T00:00:00.000000000'\n '2019-05-25T00:00:00.000000000' '2019-05-26T00:00:00.000000000'\n '2019-05-27T00:00:00.000000000' '2019-05-28T00:00:00.000000000'\n '2019-05-29T00:00:00.000000000' '2019-05-30T00:00:00.000000000'\n '2019-05-31T00:00:00.000000000' '2019-06-01T00:00:00.000000000'\n '2019-06-02T00:00:00.000000000' '2019-06-03T00:00:00.000000000'\n '2019-06-04T00:00:00.000000000' '2019-06-05T00:00:00.000000000'\n '2019-06-06T00:00:00.000000000' '2019-06-07T00:00:00.000000000'\n '2019-06-08T00:00:00.000000000' '2019-06-09T00:00:00.000000000'\n '2019-06-10T00:00:00.000000000' '2019-06-11T00:00:00.000000000'\n '2019-06-12T00:00:00.000000000' '2019-06-13T00:00:00.000000000'\n '2019-06-14T00:00:00.000000000' '2019-06-15T00:00:00.000000000'\n '2019-06-16T00:00:00.000000000' '2019-06-17T00:00:00.000000000'\n '2019-06-18T00:00:00.000000000' '2019-06-19T00:00:00.000000000'\n '2019-06-20T00:00:00.000000000' '2019-06-21T00:00:00.000000000'\n '2019-06-22T00:00:00.000000000' '2019-06-23T00:00:00.000000000'\n '2019-06-24T00:00:00.000000000' '2019-06-25T00:00:00.000000000'\n '2019-06-26T00:00:00.000000000' '2019-06-27T00:00:00.000000000'\n '2019-06-28T00:00:00.000000000' '2019-06-29T00:00:00.000000000'\n '2019-06-30T00:00:00.000000000' '2019-07-01T00:00:00.000000000'\n '2019-07-02T00:00:00.000000000' '2019-07-03T00:00:00.000000000'\n '2019-07-04T00:00:00.000000000' '2019-07-05T00:00:00.000000000'\n '2019-07-06T00:00:00.000000000' '2019-07-07T00:00:00.000000000'\n '2019-07-08T00:00:00.000000000' '2019-07-09T00:00:00.000000000'\n '2019-07-10T00:00:00.000000000' '2019-07-11T00:00:00.000000000'\n '2019-07-12T00:00:00.000000000' '2019-07-13T00:00:00.000000000'\n '2019-07-14T00:00:00.000000000' '2019-07-15T00:00:00.000000000'\n '2019-07-16T00:00:00.000000000' '2019-07-17T00:00:00.000000000'\n '2019-07-18T00:00:00.000000000' '2019-07-19T00:00:00.000000000'\n '2019-07-20T00:00:00.000000000' '2019-07-21T00:00:00.000000000'\n '2019-07-22T00:00:00.000000000' '2019-07-23T00:00:00.000000000'\n '2019-07-24T00:00:00.000000000' '2019-07-25T00:00:00.000000000'\n '2019-07-26T00:00:00.000000000' '2019-07-27T00:00:00.000000000'\n '2019-07-28T00:00:00.000000000' '2019-07-29T00:00:00.000000000'\n '2019-07-30T00:00:00.000000000' '2019-07-31T00:00:00.000000000'\n '2019-08-01T00:00:00.000000000' '2019-08-02T00:00:00.000000000'\n '2019-08-03T00:00:00.000000000' '2019-08-04T00:00:00.000000000'\n '2019-08-05T00:00:00.000000000' '2019-08-06T00:00:00.000000000'\n '2019-08-07T00:00:00.000000000' '2019-08-08T00:00:00.000000000'\n '2019-08-09T00:00:00.000000000' '2019-08-10T00:00:00.000000000'\n '2019-08-11T00:00:00.000000000' '2019-08-12T00:00:00.000000000'\n '2019-08-13T00:00:00.000000000' '2019-08-14T00:00:00.000000000'\n '2019-08-15T00:00:00.000000000' '2019-08-16T00:00:00.000000000'\n '2019-08-17T00:00:00.000000000' '2019-08-18T00:00:00.000000000'\n '2019-08-19T00:00:00.000000000'] not in index"

Je ne vois donc absolument pas quoi faire pour réussir à afficher mon df (je suis passé par un format pandas.Series() mais pareil).

Auriez-vous des suggestions ?

Merci par avance.

EDIT : on m'a suggéré les choses suivantes (qui n'ont pas marché) :

Il est possible que matplotlib n'aime pas le format datime64
Code : Sélectionner tout - Visualiser dans une fenêtre à part
```
plt.plot(df2bis.index.to_pydatetime(), df2bis.NbFluxEntrant)
```
Le format par défaut pouvait ne pas être correct
Code : Sélectionner tout - Visualiser dans une fenêtre à part
```
df2bis.index = pd.to_datetime(df2bis.index, format="%Y-%m-%d")
```
Il fallait supprimer d'éventuelles valeurs NaN. Il n'y en a pas

EDIT2 : un autre essaie infructueux :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
import matplotlib
 
dates = matplotlib.dates.date2num(df2bis.index)
dates

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

array([736634., 736635.,..., 737289., 737290.])

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

matplotlib.pyplot.plot_date(dates, df2bis["NbFluxEntrant"])

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

ValueError: view limit minimum 0.0 is less than 1 and is an invalid Matplotlib date value. This often happens if you pass a non-datetime value to an axis that has datetime units

Un vrai mystère...

**BufferBob** · 22/08/2019, 19h52

salut,

pour la combinaison et conversion des colonnes en dates je ferai plutôt :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

df.apply(lambda x: pd.datetime(year=x.AnneeObs, month=x.MoisObs, day=x.JourObs), axis=1)

exemple :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
>>> import pandas as pd
>>> import matplotlib.pyplot as plt
>>> df = pd.DataFrame({'AnneeObs': pd.np.arange(2010, 2020), 'MoisObs': pd.np.arange(1,11), 'JourObs': pd.np.arange(1,11), 'NbFluxEntrant': pd.np.random.randint(700,2000,10)})
>>> df2 = pd.DataFrame({'DateObs': df.apply(lambda x: pd.datetime(year=x.AnneeObs, month=x.MoisObs, day=x.JourObs), axis=1), 'NbFluxEntrant': df.NbFluxEntrant})
>>> df2.dtypes
DateObs          datetime64[ns]
NbFluxEntrant             int32
dtype: object
>>> df2.plot('DateObs', 'NbFluxEntrant')
<matplotlib.axes._subplots.AxesSubplot object at 0x00000282B8FBC550>
>>> plt.show()

Problème datetime avec Matplotlib

Python

Vue hybride

Discussions similaires

Partager

Partager