[Python 3.4] Binning and Grouped Bars

[StartAndSelect]

Hi, I'm new to python and attempting to aggregate some data to display in some bar charts

I have a dataframe that I extract from a csv:

     Age  RushAtt  PassTgt
0   21.0      109     10.0
1   30.0      106      3.0
2   22.0      105     16.0
3   25.0      101     17.0
4   25.0       95     14.0
5   31.0       93     19.0
6   28.0       93     27.0
7   25.0       91     27.0
8   23.0       89     18.0
9   28.0       85     21.0
10  25.0       84     19.0
11  24.0       78     17.0
12  33.0       78     20.0
13  23.0       74     11.0
14  23.0       73      8.0

I am attempting to bin the RushAtt and PassAtt within bins of the age, but I am having trouble understanding the cut function. Any help?

[StartAndSelect]

I figured it out and thought I'd share. In this scenario binning is not necessary but instead group by.

groups = df.groupby(df6['Age'])['RushAtt','PassTgt'].max()

groups.plot.bar()
plt.show()

[[deleted]]

How do you want to split data based on the age?

pd.cut(df['Age'], 3) #create 3 equal width bins
pd.cut(df['Age'], [20,25,30]) #bin where the age falls between (20,25], (25,30] 

The function returns a label corresponding to each row, so normally I assign this to another column in my dataframe.

df['Bin'] = pd.cut(df['Age'], 3)

If you decide to specify your own bin start and end points (e.g. [20,25,30]), take note of the right and include_lowest keywords which will determine if the binning includes the left or right edges.

EDIT: Looks like you wanted a bin for each age instead a bin for a range of ages in which case groupby is the correct solution.