Created
May 10, 2018 11:19
-
-
Save onpillow/0268a3a66b59605e48dfbaf52416d9bd to your computer and use it in GitHub Desktop.
for medium 01_03
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"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