Pandas - Plotting series

Question

I have a dataframe that is indexed by a datetime column and I get value_count() for various time ranges. For example,

data['leadsource_ch_disp_name'].ix[rng[0]].value_counts()

returns

Unknown        223
Sponsorship    889
Reseller       145
Referral        52
dtype: int64

which is a series. I want to do this with 5 different time ranges (rng[i] for i=[0,..,4]). So then I am left with 5 series. What I want to do is plot these 5 series (on the same plot) such that the x-axis is the series name and the y-axis is the values. And I want it to be a line graph with 4 lines (for unknown, sponsorship, reseller, and referral).

I have tried the following

rng0=data['leadsource_ch_disp_name'].ix[rng[0]].value_counts()
rng1=data['leadsource_ch_disp_name'].ix[rng[1]].value_counts()
rng2=data['leadsource_ch_disp_name'].ix[rng[2]].value_counts()
rng3=data['leadsource_ch_disp_name'].ix[rng[3]].value_counts()
rng4=data['leadsource_ch_disp_name'].ix[rng[4]].value_counts()
rng5=data['leadsource_ch_disp_name'].ix[rng[5]].value_counts()
pd.concat([rng0,rng1,rng2,rng3,rng4,rng5],axis=1).plot()

however, this does not return what I want. This creates a plot where the x-axis is Referral,reseller,sponsorship,unknown and there are 5 lines for the 5 different series.

Garrett · Accepted Answer · 2013-12-16 21:26:48Z

3

Since plot() draws a line for each column, try transposing the frame first..

pd.concat([rng0,rng1,rng2,rng3,rng4,rng5],axis=1).T.plot()

answered Dec 16, 2013 at 21:26

Garrett

50.3k6 gold badges64 silver badges51 bronze badges

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

1 Comment

user1893354 Over a year ago

Wow. I thought it would be more complicated than that :) Thanks!

Collectives™ on Stack Overflow

Pandas - Plotting series

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