Skip to content

Instantly share code, notes, and snippets.

@vinaykudari

vinaykudari/groupby_func.ipynb

Created August 7, 2018 20:02
Show Gist options
  • Save vinaykudari/124e84129a8ba373deedf4ac2b36fd17 to your computer and use it in GitHub Desktop.
Save vinaykudari/124e84129a8ba373deedf4ac2b36fd17 to your computer and use it in GitHub Desktop.
Download ZIP
Group By Functions
Display the source blob
Display the rendered blob
Raw
groupby_func.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 14,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead tr th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe thead tr:last-of-type th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr>\n",
" <th></th>\n",
" <th colspan=\"2\" halign=\"left\">bread</th>\n",
" <th colspan=\"2\" halign=\"left\">butter</th>\n",
" </tr>\n",
" <tr>\n",
" <th></th>\n",
" <th>sum</th>\n",
" <th>mean</th>\n",
" <th>sum</th>\n",
" <th>mean</th>\n",
" </tr>\n",
" <tr>\n",
" <th>weekday</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>Mon</th>\n",
" <td>334</td>\n",
" <td>167.0</td>\n",
" <td>114</td>\n",
" <td>57.000000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Sun</th>\n",
" <td>603</td>\n",
" <td>201.0</td>\n",
" <td>169</td>\n",
" <td>56.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Tue</th>\n",
" <td>743</td>\n",
" <td>371.5</td>\n",
" <td>129</td>\n",
" <td>64.500000</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" bread butter \n",
" sum mean sum mean\n",
"weekday \n",
"Mon 334 167.0 114 57.000000\n",
"Sun 603 201.0 169 56.333333\n",
"Tue 743 371.5 129 64.500000"
]
},
"execution_count": 14,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df_grouped.agg(['sum', 'mean'])"
]
},
{
"cell_type": "code",
"execution_count": 15,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>bread</th>\n",
" <th>butter</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>603</td>\n",
" <td>169</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>334</td>\n",
" <td>114</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>334</td>\n",
" <td>114</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>603</td>\n",
" <td>169</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>743</td>\n",
" <td>129</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>603</td>\n",
" <td>169</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>743</td>\n",
" <td>129</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" bread butter\n",
"0 603 169\n",
"1 334 114\n",
"2 334 114\n",
"3 603 169\n",
"4 743 129\n",
"5 603 169\n",
"6 743 129"
]
},
"execution_count": 15,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df_grouped.transform('sum')"
]
},
{
"cell_type": "code",
"execution_count": 20,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>bread</th>\n",
" <th>butter</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>120</td>\n",
" <td>20</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>260</td>\n",
" <td>60</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>421</td>\n",
" <td>53</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>223</td>\n",
" <td>89</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>322</td>\n",
" <td>76</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" bread butter\n",
"0 120 20\n",
"3 260 60\n",
"4 421 53\n",
"5 223 89\n",
"6 322 76"
]
},
"execution_count": 20,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df_grouped.filter(lambda g:g['bread'].sum() > 350)"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.6.5"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment