Skip to content

Instantly share code, notes, and snippets.

@onpillow
Created May 10, 2018 11:19
Show Gist options
  • Save onpillow/0268a3a66b59605e48dfbaf52416d9bd to your computer and use it in GitHub Desktop.
Save onpillow/0268a3a66b59605e48dfbaf52416d9bd to your computer and use it in GitHub Desktop.
for medium 01_03
Display the source blob
Display the rendered blob
Raw
{
"cells": [
{
"cell_type": "code",
"execution_count": 4,
"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>id</th>\n",
" <th>popularity</th>\n",
" <th>budget</th>\n",
" <th>revenue</th>\n",
" <th>runtime</th>\n",
" <th>vote_count</th>\n",
" <th>vote_average</th>\n",
" <th>release_year</th>\n",
" <th>budget_adj</th>\n",
" <th>revenue_adj</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>count</th>\n",
" <td>10866.000000</td>\n",
" <td>10866.000000</td>\n",
" <td>1.086600e+04</td>\n",
" <td>1.086600e+04</td>\n",
" <td>10866.000000</td>\n",
" <td>10866.000000</td>\n",
" <td>10866.000000</td>\n",
" <td>10866.000000</td>\n",
" <td>1.086600e+04</td>\n",
" <td>1.086600e+04</td>\n",
" </tr>\n",
" <tr>\n",
" <th>mean</th>\n",
" <td>66064.177434</td>\n",
" <td>0.646441</td>\n",
" <td>1.462570e+07</td>\n",
" <td>3.982332e+07</td>\n",
" <td>102.070863</td>\n",
" <td>217.389748</td>\n",
" <td>5.974922</td>\n",
" <td>2001.322658</td>\n",
" <td>1.755104e+07</td>\n",
" <td>5.136436e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>std</th>\n",
" <td>92130.136561</td>\n",
" <td>1.000185</td>\n",
" <td>3.091321e+07</td>\n",
" <td>1.170035e+08</td>\n",
" <td>31.381405</td>\n",
" <td>575.619058</td>\n",
" <td>0.935142</td>\n",
" <td>12.812941</td>\n",
" <td>3.430616e+07</td>\n",
" <td>1.446325e+08</td>\n",
" </tr>\n",
" <tr>\n",
" <th>min</th>\n",
" <td>5.000000</td>\n",
" <td>0.000065</td>\n",
" <td>0.000000e+00</td>\n",
" <td>0.000000e+00</td>\n",
" <td>0.000000</td>\n",
" <td>10.000000</td>\n",
" <td>1.500000</td>\n",
" <td>1960.000000</td>\n",
" <td>0.000000e+00</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25%</th>\n",
" <td>10596.250000</td>\n",
" <td>0.207583</td>\n",
" <td>0.000000e+00</td>\n",
" <td>0.000000e+00</td>\n",
" <td>90.000000</td>\n",
" <td>17.000000</td>\n",
" <td>5.400000</td>\n",
" <td>1995.000000</td>\n",
" <td>0.000000e+00</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>50%</th>\n",
" <td>20669.000000</td>\n",
" <td>0.383856</td>\n",
" <td>0.000000e+00</td>\n",
" <td>0.000000e+00</td>\n",
" <td>99.000000</td>\n",
" <td>38.000000</td>\n",
" <td>6.000000</td>\n",
" <td>2006.000000</td>\n",
" <td>0.000000e+00</td>\n",
" <td>0.000000e+00</td>\n",
" </tr>\n",
" <tr>\n",
" <th>75%</th>\n",
" <td>75610.000000</td>\n",
" <td>0.713817</td>\n",
" <td>1.500000e+07</td>\n",
" <td>2.400000e+07</td>\n",
" <td>111.000000</td>\n",
" <td>145.750000</td>\n",
" <td>6.600000</td>\n",
" <td>2011.000000</td>\n",
" <td>2.085325e+07</td>\n",
" <td>3.369710e+07</td>\n",
" </tr>\n",
" <tr>\n",
" <th>max</th>\n",
" <td>417859.000000</td>\n",
" <td>32.985763</td>\n",
" <td>4.250000e+08</td>\n",
" <td>2.781506e+09</td>\n",
" <td>900.000000</td>\n",
" <td>9767.000000</td>\n",
" <td>9.200000</td>\n",
" <td>2015.000000</td>\n",
" <td>4.250000e+08</td>\n",
" <td>2.827124e+09</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" id popularity budget revenue runtime \\\n",
"count 10866.000000 10866.000000 1.086600e+04 1.086600e+04 10866.000000 \n",
"mean 66064.177434 0.646441 1.462570e+07 3.982332e+07 102.070863 \n",
"std 92130.136561 1.000185 3.091321e+07 1.170035e+08 31.381405 \n",
"min 5.000000 0.000065 0.000000e+00 0.000000e+00 0.000000 \n",
"25% 10596.250000 0.207583 0.000000e+00 0.000000e+00 90.000000 \n",
"50% 20669.000000 0.383856 0.000000e+00 0.000000e+00 99.000000 \n",
"75% 75610.000000 0.713817 1.500000e+07 2.400000e+07 111.000000 \n",
"max 417859.000000 32.985763 4.250000e+08 2.781506e+09 900.000000 \n",
"\n",
" vote_count vote_average release_year budget_adj revenue_adj \n",
"count 10866.000000 10866.000000 10866.000000 1.086600e+04 1.086600e+04 \n",
"mean 217.389748 5.974922 2001.322658 1.755104e+07 5.136436e+07 \n",
"std 575.619058 0.935142 12.812941 3.430616e+07 1.446325e+08 \n",
"min 10.000000 1.500000 1960.000000 0.000000e+00 0.000000e+00 \n",
"25% 17.000000 5.400000 1995.000000 0.000000e+00 0.000000e+00 \n",
"50% 38.000000 6.000000 2006.000000 0.000000e+00 0.000000e+00 \n",
"75% 145.750000 6.600000 2011.000000 2.085325e+07 3.369710e+07 \n",
"max 9767.000000 9.200000 2015.000000 4.250000e+08 2.827124e+09 "
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.describe()"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python [conda env:py3]",
"language": "python",
"name": "conda-env-py3-py"
},
"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.3"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment