Able to plot as lists, unable to plot as Pandas Series

Question

The following data is able to be plot using matplotlib but not after converting into a Pandas Series. How can it be plotted using pandas?

Without pandas

scores = [Decimal('3.7989'),
 Decimal('4.7989'),
 Decimal('5.7989'),
 Decimal('6.7989'),
 Decimal('7.7989')]

 timestamps = [datetime.datetime(2013, 11, 12, 21, 21, 52),
 datetime.datetime(2013, 11, 12, 21, 21, 8),
 datetime.datetime(2013, 11, 12, 21, 21, 1),
 datetime.datetime(2013, 11, 12, 21, 20, 1),
 datetime.datetime(2013, 11, 12, 21, 19, 33)]

 plt.plot(timestamps,score)

enter image description here

Using pandas

ts = pd.Series(scores, index=timestamps)
ts.plot()

We get the error: TypeError: Series has object dtype and cannot be converted: no numeric data to plot

Huh. Did you accept the answer without voting for it as useful? — emmagras
– emmagras, Commented Nov 21, 2014 at 19:46

mattexx · Accepted Answer · 2013-11-13 02:54:43Z

1

Try taking away the Decimal type:

ts = pd.Series([float(x) for x in scores], index=timestamps)

or

ts = pd.Series(scores, index=timestamps, dtype='float64')

Pandas only supports float and integer as numeric types, Use anything else, and it becomes an "object."

edited Nov 13, 2013 at 2:54

answered Nov 13, 2013 at 2:37

mattexx

6,6163 gold badges40 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Able to plot as lists, unable to plot as Pandas Series

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related