plt.errorbar for X string value

Question

I have a dataframe as below

import pandas as pd
import matplotlib.pylab as plt
df = pd.DataFrame({'name':['one', 'two', 'three'], 'assess':[100,200,300]})

I want to build errorbar like this

c = 30
plt.errorbar(df['name'], df['assess'], yerr=c, fmt='o')

and of course i get

ValueError: could not convert string to float

I can convert string to float, but I'm losing value signatures and maybe there's a more elegant way?

possible dublicate of stackoverflow.com/questions/40266187/… or stackoverflow.com/questions/40510070/… or stackoverflow.com/questions/31029560/… or stackoverflow.com/questions/32294586/… or stackoverflow.com/questions/33958068/… — ImportanceOfBeingErnest
– ImportanceOfBeingErnest, Commented Nov 15, 2016 at 18:38

ImportanceOfBeingErnest · Accepted Answer · 2016-11-15 18:37:08Z

4

Matplotlib can indeed only work with numerical data. There is an example in the matplotlib collection showing how to handle cases where you have categorical data. The solution is to plot a range of values and set the labels afterwards using plt.xticks(ticks, labels) or a combination of ax.set_xticks(ticks) and ax.set_xticklabels(labels).

In your case the former works fine:

import pandas as pd
import matplotlib.pylab as plt
df = pd.DataFrame({'name':['one', 'two', 'three'], 'assess':[100,200,300]})

c = 30
plt.errorbar(range(len(df['name'])), df['assess'], yerr=c, fmt='o')
plt.xticks(range(len(df['name'])), df['name'])

plt.show()

answered Nov 15, 2016 at 18:37

ImportanceOfBeingErnest

342k61 gold badges737 silver badges771 bronze badges

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

1 Comment

Edward Over a year ago

thanx! I tried to use df.index but in ticks got an error

Collectives™ on Stack Overflow

plt.errorbar for X string value

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related