Pandas: create plot

Question

I have dataframe

         bank_card  used_at  unique_users  all_time
0         Credit  2015-01           513    2368.0
1         Credit  2015-02           352    1375.0
2         mortgage  2015-01           355    1235.0
3         mortgage  2015-02           394    2147.0
4         mortgage  2015-03           298    1401.0
5         mortgage  2015-04           350    1890.0

And I need to build graph. I try to do it and get But I need to get used_at values at x axis. all_time at y axis to every type of bank_card.

It establish only name of axis ax.set_xlabel("used_at", fontsize=12) How can I do that?

mechanical_meat · Accepted Answer · 2017-03-24 16:22:52Z

1

You can do this by setting the index to 'used_at'

idf = df.set_index('used_at')

Result:

>>> idf.plot(y='all_time')
<matplotlib.axes._subplots.AxesSubplot object at 0x0000000011D0FDA0>
>>> plt.show()

Edit: you want both Credit and Mortgage on one plot here you go:

>>> idf.groupby('bank_card')['all_time'].plot()
bank_card
Credit      Axes(0.125,0.1;0.775x0.8)
mortgage    Axes(0.125,0.1;0.775x0.8)
Name: all_time, dtype: object
>>> plt.legend(loc='best')
<matplotlib.legend.Legend object at 0x0000000011924588>
>>> plt.show()

Result:

edited Mar 24, 2017 at 16:22

answered Mar 24, 2017 at 16:17

mechanical_meat

170k25 gold badges237 silver badges231 bronze badges

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

1 Comment

Petr Petrov Over a year ago

But how can I get 2 curves to Credit and mortgage on the one plot?

Collectives™ on Stack Overflow

Pandas: create plot

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related