Series that won't plot!

[dhirschfeld]

https://www.dropbox.com/s/rgy9iqt9o8pvfdl/wontplot.pandas

In [3]: s = pd.load('wontplot.pandas')

In [5]: s.plot()
Traceback (most recent call last):

  File "<ipython-input-5-d3eb09d34df4>", line 1, in <module>
    s.plot()

  File "C:\dev\bin\Python27\lib\site-packages\pandas\tools\plotting.py", line 1727, in plot_series
    plot_obj.generate()

  File "C:\dev\bin\Python27\lib\site-packages\pandas\tools\plotting.py", line 853, in generate
    self._make_plot()

  File "C:\dev\bin\Python27\lib\site-packages\pandas\tools\plotting.py", line 1241, in _make_plot
    x = self._get_xticks(convert_period=True)

  File "C:\dev\bin\Python27\lib\site-packages\pandas\tools\plotting.py", line 1031, in _get_xticks
    self.data = self.data.reindex(index=index.order())

  File "C:\dev\bin\Python27\lib\site-packages\pandas\core\series.py", line 2638, in reindex
    return Series(new_values, index=new_index, name=self.name)

  File "C:\dev\bin\Python27\lib\site-packages\pandas\core\series.py", line 489, in __new__
    subarr.index = index

  File "properties.pyx", line 74, in pandas.lib.SeriesIndex.__set__ (pandas\lib.c:29092)

AssertionError: Index length did not match values


In [6]: s.index.shape
Out[6]: (480,)

In [7]: s.values.shape
Out[7]: (480,)

[jorisvandenbossche]

See #4486 and #4492.

[dhirschfeld]

Apologies - should've looked harder! Closing as a duplicate...

[jorisvandenbossche]

Maybe you closed it a little bit too early, because I am not sure it fixed it as you would like.

At the moment with master, the series is ordered before plotting, so resulting in a quite different plot (oscillating between the first and second part of your series) than what you would get with just ax.plot(s.index, s.values).

But I cannot really say this can be considered as a bug, or just a restriction on the timeseries implementation (that the timeseries has to be ordered)

[jorisvandenbossche]

And something else, I tried to load you file with pd.read_pickle, and with 0.12 everything went fine, but with master I got the following error:

In [3]:  s = pd.read_pickle('wontplot.pandas')

---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
<ipython-input-3-9680da22ca6c> in <module>()
----> 1 s = pd.read_pickle('wontplot.pandas')

c:\users\vdbosscj\scipy\pandas-joris\pandas\io\pickle.pyc in read_pickle(path)
     34     try:
     35         with open(path, 'rb') as fh:
---> 36             return pkl.load(fh)
     37     except:
     38         if PY3:

TypeError: ('_reconstruct: First argument must be a sub-type of ndarray', <built-in function _reconstruct>, (<class 'pandas.core.series.Series'>, (0,), 'b'))

[dhirschfeld]

It would be a bit painful if the next release of pandas couldn't read pickles created by older versions but I guess that's a separate issue from the index length did not match values error.

[jreback]

@jorisvandenbossche @dhirschfeld the pickle issue is separate and will be fixed shortly

[jtratner]

Hmm... Well Series is no longer a subclass of ndarray, which may be causing
the issue. I'll take a look later.

[jorisvandenbossche]

Pickle issue is indeed something else (and good it already will be fixed), but about the plotting:

s.plot() gives (due to reordening):

while ax.plot(s.index, s.values gives:

This is intentional?