{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": false }, "outputs": [], "source": [ "%matplotlib inline\n", "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "" ], "text/plain": [ "" ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "from IPython.core.display import HTML\n", "css = open('style-table.css').read() + open('style-notebook.css').read()\n", "HTML(''.format(css))" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
titleyear
0A Lélek órása1923
1Aizaugusa gravi viegli krist1986
2Agliyorum1988
30_1_02008
497 fung lau mung1994
\n", "
" ], "text/plain": [ " title year\n", "0 A Lélek órása 1923\n", "1 Aizaugusa gravi viegli krist 1986\n", "2 Agliyorum 1988\n", "3 0_1_0 2008\n", "4 97 fung lau mung 1994" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "titles = pd.DataFrame.from_csv('data/titles.csv', index_col=None)\n", "titles.head()" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
titleyearnametypecharactern
0The Core2003Alejandro AbellanactorU.S.S. SoldierNaN
1Il momento di uccidere1968Remo De AngelisactorDago9
2Across the Divide1921Thomas DelmaractorDago4
3Revan2012Diego JamesactorDagoNaN
4Un homme marche dans la ville1950Fabien LorisactorDago12
\n", "
" ], "text/plain": [ " title year name type \\\n", "0 The Core 2003 Alejandro Abellan actor \n", "1 Il momento di uccidere 1968 Remo De Angelis actor \n", "2 Across the Divide 1921 Thomas Delmar actor \n", "3 Revan 2012 Diego James actor \n", "4 Un homme marche dans la ville 1950 Fabien Loris actor \n", "\n", " character n \n", "0 U.S.S. Soldier NaN \n", "1 Dago 9 \n", "2 Dago 4 \n", "3 Dago NaN \n", "4 Dago 12 " ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "cast = pd.DataFrame.from_csv('data/cast.csv', index_col=None)\n", "cast.head()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": false }, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": [ "iVBORw0KGgoAAAANSUhEUgAAAX8AAAEnCAYAAABBmUP9AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\n", "AAALEgAACxIB0t1+/AAAIABJREFUeJztnX20HGWd5z9fiLyILDGjk/AOs4SFOLhINHFeuYpi/pgF\n", "POuSOKsrmuM6k3XBcXVJPHtG3DODgDvD4uySM7MDE0AFcmRwxkMMBMydF0cSQSKRGAmMF5MAAQMB\n", "303gt3/Uc3M7d7pz7+2uutVP9fdzTp2ueqrqU0/37fvr6m+9tCICY4wxg8UhdXfAGGPM9OPib4wx\n", "A4iLvzHGDCAu/sYYM4C4+BtjzADi4m+MMQPIpIq/pJmSvijpO5K2SFooaZakdZIelXSPpJkty6+Q\n", "tE3SVknnt7TPl7Q5zbuupf1wSben9vslnVzu0zTGGNPKZPf8rwPWRMSZwOuBrcByYF1EnA7cl6aR\n", "NA9YDMwDFgHXS1LyrASWRsRcYK6kRal9KbA7tV8LXN3zMzPGGNORCYu/pGOA34qIGwEiYl9EvABc\n", "ANyUFrsJuCiNXwjcGhF7I2IEeAxYKOlY4OiI2JiWu7llnVbXHcB5PT0rY4wxB2Uye/6nAs9K+itJ\n", "35T0/yQdBcyOiF1pmV3A7DR+HLCjZf0dwPFt2nemdtLjdig+XIAXJM3q5gkZY4yZmMkU/xnAOcD1\n", "EXEO8GNSxDNKFPeI8H0ijDEmE2ZMYpkdwI6I+Eaa/iKwAnha0pyIeDpFOs+k+TuBE1vWPyE5dqbx\n", "8e2j65wEPClpBnBMRDzX2glJ/nAxxpguiAi1a5xwAP4eOD2NXwFck4bLU9ty4Ko0Pg/YBBxGERk9\n", "DijN2wAsBASsARal9mXAyjS+BLitTR9iMn1tWf6KqSw/1cH++vw5991++6fb36l2TmbPH+C/Ap+X\n", "dFgq5u8HDgVWS1oKjAAXp61skbQa2ALsA5ZF6kEq8quAIynOHlqb2m8AbpG0DdidPgB65ZQSHPb3\n", "p79Kt/32D4R/UsU/Ir4FvKnNrLd1WP5K4Mo27Q8CZ7Vp/znpw8MYY0z1NPkK31X2N9Zfpdt++wfC\n", "r7FEpr+RFNHuoIUxxpiOdKqdjd3zlzRkfzP9Offd/ub4JcVUh5K2O1SGp7HF3xhjqifaDOs7tPcX\n", "jn2MMaYLij35qdRPUUcNG7jYxxhjTGcaW/xzyQ3t7y+3/fb3znCldmf+xhhjusaZvzHGdIEzf2OM\n", "MdnR2OKfe25ofz1u++3vneFK7c78jTHGdI0zf2OM6QJn/sYYY7KjscU/99zQ/nrc9tvfO8OV2p35\n", "G2OM6Rpn/sYY0wXO/I0xxmRHY4t/7rmh/fW47be/d4YrtTvzN8YY0zXO/I0xpguc+RtjjMmOxhb/\n", "3HND++tx229/7wxXanfmb4wxpmuc+RtjTBc48zfGGJMdjS3+ueeG9tfjtt/+3hmu1O7M3xhjTNdM\n", "KvOXNAK8CLwE7I2IBZJmAbcDJwMjwMURsSctvwL4QFr+0oi4J7XPB1YBRwBrIuKy1H44cDNwDrAb\n", "WBwRT4zrgzN/Y0zfMCiZfwBDEfGGiFiQ2pYD6yLidOC+NI2kecBiYB6wCLhe0uiGVwJLI2IuMFfS\n", "otS+FNid2q8Frp7yMzTGGDNpphL7jP/kuAC4KY3fBFyUxi8Ebo2IvRExAjwGLJR0LHB0RGxMy93c\n", "sk6r6w7gvCn0q31nM88N7a/Hbb/9vTNcqX26M/8A7pX0gKQPprbZEbErje8CZqfx44AdLevuAI5v\n", "074ztZMetwNExD7ghRQrGWOMqYAZk1zuNyLiKUmvBdZJ2to6MyKiyL/6h4gYtr+Z/pz7bn/z/TBU\n", "qb2s/k+q+EfEU+nxWUl3AguAXZLmRMTTKdJ5Ji2+EzixZfUTKPb4d6bx8e2j65wEPClpBnBMRDw3\n", "vh+SVlEcXAbYA2wafSFGvwp52tOe9vR0TY8xnB6HJpguqLJ/afyStKkROhERBx2AV1Jk9QBHAV8D\n", "zgeuAS5P7cuBq9L4PGATcBhwKvA4Y2cVbQAWUhw/WAMsSu3LgJVpfAlwW5t+xER9Hbf80FSWn+pg\n", "f33+nPtuf3P8QEC0GdZ3aCfq6H+n7U5mz382cGc6YWcG8PmIuEfSA8BqSUvTp8vFaStbJK0GtgD7\n", "gGWRepCK/CrgSIpTPdem9huAWyRtozjVc8kk+mWMMaZLfG8fY4zpgkE5z98YY0yDaGzxz/1cYfvr\n", "cdtvf+8MV2qf7vP8jTHGNAhn/sYY0wXO/I0xxmRHY4t/7rmh/fW47be/d4YrtTvzN8YY0zXO/I0x\n", "pguc+RtjjMmOxhb/3HND++tx229/7wxXai+r/5O9pbMxxmSFDnKbeal9+jJI0bIzf2NMI6k6k3fm\n", "b4wxJjsaW/xzzw3tr8dtf/P9VWfyuWT+jS3+xhhjOuPM3xjTSJz5p6068zfGGDNKY4t/7rmk/fW4\n", "7W++35l/QWOLvzHGmM448zfGNBJn/mmrzvyNMcaM0tjin3suaX89bvub73fmX9DY4m+MMaYzzvyN\n", "MY3EmX/aqjN/Y4wxozS2+OeeS9pfj9v+5vud+Rc0tvgbY4zpjDN/Y0wjceafturM3xhjzCiTKv6S\n", "DpX0kKQvp+lZktZJelTSPZJmtiy7QtI2SVslnd/SPl/S5jTvupb2wyXdntrvl3RyGU8s91zS/nrc\n", "9jff78y/YLJ7/pcBWxj7jrMcWBcRpwP3pWkkzQMWA/OARcD1GvuxzJXA0oiYC8yVtCi1LwV2p/Zr\n", "gat7e0rGGGMmYsLMX9IJwCrgj4GPRsS/k7QVODcidkmaAwxHxBmSVgAvR8TVad21wBXAE8BXI+LM\n", "1L4EGIqI30vLfDIiNkiaATwVEa9t0w9n/saYSePMP221h8z/WuDjwMstbbMjYlca3wXMTuPHATta\n", "ltsBHN+mfWdqJz1uB4iIfcALkmZNol/GGGO6ZMbBZkr6HeCZiHioU84UEVF8AlaPpFXASJrcA2yK\n", "iOE0byj1Z3T6IxPM73Xa/pr8re9F++0/2PQYw+lxiAMz+aFx8wv6xd/N65PGL0mLjNCJiOg4AFdS\n", "7JV/D3gK+DFwC7AVmJOWORbYmsaXA8tb1l8LLATmAN9paX83sLJlmTen8RnAsx36Egfra5vlh6ay\n", "/FQH++vz59x3+6fPDwREm2F9h3ain/xlvT6dtjvp8/wlnQt8LIrM/xqKg7RXS1oOzIyI5emA7xeA\n", "BRRxzr3AaRERkjYAlwIbgbuAz0bEWknLgLMi4vfTsYCLImJJm+1HOPM3xkwSZ/5pqx1q50FjnzaM\n", "PtOrgNWSllJ8rbgYICK2SFpNcWbQPmBZjH26LKM4cHwksCYi1qb2G4BbJG0DdgP/ovAbY4wpl8Ze\n", "4StpKFIeVlF/7K/Jn3Pf7Z8+f+c982HGsvgD1ihpz78c/0G2O6XXp5ezfYwxxjSMxu75G2MGG2f+\n", "aave8zfGGDNKY4t/p+sS7M/fn3Pf7a/f73v7FDS2+BtjjOmMM39jTCNx5p+26szfGGPMKI0t/rnn\n", "kvbX47a/+X5n/gWNLf7GGGM648zfGNNInPmnrTrzN8YYM0pji3/uuaT99bjtb77fmX9BY4u/McaY\n", "zjjzN8Y0Emf+aavO/I0xxozS2OKfey5pfz1u+5vvd+ZfMNVf8jLGmFIoYpOO89q2O/otD2f+xpha\n", "yD2Td+ZvjDEmOxpb/HPPJe2vx21//f7cM/lcMv/GFn9jjDGdceZvjKmF3DN5Z/7GGGOyo7HFP/fc\n", "0/563PbX7889k3fmb4wxpm9x5m+MqYXcM3ln/sYYY7KjscU/99zT/nrc9tfvzz2Tb0TmL+kISRsk\n", "bZK0RdKnU/ssSeskPSrpHkkzW9ZZIWmbpK2Szm9pny9pc5p3XUv74ZJuT+33Szq5jCdmjOkNSdFu\n", "ANYfZJ7JhAkzf0mvjIifSJoB/CPwMeAC4AcRcY2ky4FXR8RySfOALwBvAo4H7gXmRkRI2gh8OCI2\n", "SloDfDYi1kpaBvxqRCyTtBh4Z0QsadMPZ/7GTCO5Z+a5+8ui68w/In6SRg8DDgWepyj+N6X2m4CL\n", "0viFwK0RsTciRoDHgIWSjgWOjoiNabmbW9Zpdd0BnDeF52WMMaYLJiz+kg6RtAnYBayPiEeA2RGx\n", "Ky2yC5idxo8DdrSsvoPiG8D49p2pnfS4HSAi9gEvSJrV3dM5oN9DvTrs709/zn1vgj/3zDx3/7Td\n", "zz8iXgbOlnQMcLekt4yb76zPGGMyY9I/5hIRL0i6C5gP7JI0JyKeTpHOM2mxncCJLaudQLHHvzON\n", "j28fXeck4Ml0XOGYiHiuXR8krQJG0uQeYFNEDKd5Q6mfwy3LD3Wa3+u0/fX5I2K47P7a3356jOH0\n", "OJSG1unW+QX2l+Pv5u+bxi9JmxqhAwc94CvpNcC+iNgj6UjgbuBTwDuA3RFxtaTlwMxxB3wXMHbA\n", "97T07WADcCmwEbiLAw/4nhURvy9pCXCRD/gaMzHdfOPupwOa9k8P3R7wPRb4asr8NwBfjoj7gKuA\n", "t0t6FHhrmiYitgCrgS3AV4BlMfbpsgz4S2Ab8FhErE3tNwC/JGkb8BFgefdPc4zcc1X763Hn5482\n", "w/oO7WUxXKLL/qkyLZl/RGwGzmnT/hzwtg7rXAlc2ab9QeCsNu0/By6eZH+NMcaUgO/tY0ym5B5r\n", "2D89dH2evzHGmObR2OKfV25rf7+4m+DPPdO2/+CU9f5pbPE3xhjTGWf+xmRK7pm2/dODM39jjDH7\n", "aWzxzz23tb8edxP8uWfa9h8cZ/7GGGO6xpm/MZmSe6Zt//TgzN8YY8x+Glv8c89t7a/HXaZfHX7q\n", "8GBDGdvNPdO2/+A48zcmC+q48ZoxE+PM35iKyD1ztr9ef1k48zfGGLOfxhb/XHJh+/vLPR3+3DNn\n", "++v1O/M3xhjTNc78jamI3DNn++v1l4Uzf2OMMftpbPHPPRe2vx73dPhzz5ztr9fvzN8YY0zXOPM3\n", "piJyz5ztr9dfFs78jTHG7KexxT/3XNj+etzT4c89c7a/Xr8zf2OMMV3jzN+Yisg9c7a/Xn9ZOPM3\n", "xhizn8YW/9xzYfvrcU+HP/fM2f56/c78jTHGdM2Emb+kE4GbgV+mCLj+IiI+K2kWcDtwMjACXBwR\n", "e9I6K4APAC8Bl0bEPal9PrAKOAJYExGXpfbD0zbOAXYDiyPiiXH9cOZvsiL3zNn+ev1l0Uvmvxf4\n", "g4h4HfBm4L9IOhNYDqyLiNOB+9I0kuYBi4F5wCLgekmjG14JLI2IucBcSYtS+1Jgd2q/Fri6y+dp\n", "jDFmEkxY/CPi6YjYlMZ/BHwHOB64ALgpLXYTcFEavxC4NSL2RsQI8BiwUNKxwNERsTEtd3PLOq2u\n", "O4DzenlSkH8ubH897unw554521+vv5bMX9IpwBuADcDsiNiVZu0CZqfx44AdLavtoPiwGN++M7WT\n", "HrcDRMQ+4IUUKxljjKmASRd/Sa+i2Cu/LCJ+2DovigMHfXXBQEQM299Mf859LxiqVm9/o/1lvT9n\n", "TGYhSa+gKPy3RMSXUvMuSXMi4ukU6TyT2ncCJ7asfgLFHv/OND6+fXSdk4AnJc0AjomI59r0YxXF\n", "wWWAPcCm0Rdi9KuQpz3dT9NjDKfHoQmmC+y3v9vpNH5J2tQInYiIgw6AKPL5a8e1XwNcnsaXA1el\n", "8XnAJuAw4FTgccbOKtoALEzONcCi1L4MWJnGlwC3telHTNTXccsPTWX5qQ721+cvy03xbXVKw9T9\n", "0WZY36HdfvvLf/932u5k9vx/A3gP8LCkh1LbCuAqYLWkpaRTPdNWtkhaDWwB9gHLIvUgFflVwJEU\n", "p3quTe03ALdI2kZxqueSSfTLmBJol1YO0/6ru880Ns3B9/YxA0vu54Hb32x/WfjePsYYY/bT2OKf\n", "+7ng9tfjLhiuVm+//T3ge/sYY4zpGmf+ZmDJPRO2v9n+suhUOyd1nr/Jl+INOjX8IWtM82ls7JNz\n", "pl2+v90p6+s7tJeDM3/77a8GZ/7GGGO6xpl/w8kll6yD3DNh+5vtLwtn/qYSpnpMYVA+WIzpdxob\n", "++SVyU+/v9xccrLHFMohr9fGfvvLxZm/McaYrnHm33D6K/fsr+MJ/fXa2G9/NfjePsYYY/bT2OKf\n", "eybvXLszfm3sH2S/M39jjDFd48y/4fRX7unM3377p7BCKTjzN8YYs5/GFv/cM3nn2p3xa2P/IPud\n", "+RtjjOkaZ/4Np79yT2f+9ts/hRVKwff2Mdnh3yIwpjoaG/vknsk71x5l+n+LIJ/Xxv5B9DvzN8YY\n", "0zXO/BtOf+We/ZWp2m9/P/vLwpl/n+Jc2xhTB42NffLK5J1r94/bfvv72+/M3xhjTNc486+Z3HNJ\n", "Z/7221+Nvyy6vrePpBsl7ZK0uaVtlqR1kh6VdI+kmS3zVkjaJmmrpPNb2udL2pzmXdfSfrik21P7\n", "/ZJO7u2pGmOMmYjJxD5/BSwa17YcWBcRpwP3pWkkzQMWA/PSOtdLGv3EWQksjYi5wFxJo86lwO7U\n", "fi1wdQ/PZz95Zf7tGK5Wn7W/Srf99ve3f9oy/4j4B+D5cc0XADel8ZuAi9L4hcCtEbE3IkaAx4CF\n", "ko4Fjo6IjWm5m1vWaXXdAZzXxfMwxhgzBbo94Ds7Inal8V3A7DR+HLCjZbkdwPFt2nemdtLjdoCI\n", "2Ae8IGlWl/3aT0QM9+qo0w9D1eqz9lfptt/+/vaXVXt6PtsniiPGeRw1NsYYA3R/kdcuSXMi4ukU\n", "6TyT2ncCJ7YsdwLFHv/OND6+fXSdk4AnJc0AjomI59ptVNIqYCRN7gE2jX4KjuZgLdMfmWB+r9Ol\n", "+McYTo+jzf8bOLtleviApQfb3+qy3/7m+ttNt277IPMvSYuM0ImImHAATgE2t0xfA1yexpcDV6Xx\n", "ecAm4DDgVOBxxk4n3QAsBASsARal9mXAyjS+BLitQx9iMn1tWX5oKstPdSjLDwREm2F9h/Ypvw59\n", "5M+57/bbP73+g2x3aKr9bNc+4Xn+km4FzgVeQ5Hv/yHwN8Bqij32EeDiiNiTlv8E8AFgH3BZRNyd\n", "2ucDq4AjgTURcWlqPxy4BXgDsBtYEsXB4vH9iPB5/vTbucg+z99++6vxl0Wn2umLvGom9zeoi7/9\n", "9lfjL4uuL/LKFZ/n32R/lW777e9v/7Sd52+MMaZ5OPapmdy/mjr2sd/+avxlMXCxjzHGmM40tvg7\n", "82+yv0q3/fb3t9+ZvzHGmK5x5l8zueeSzvztt78af1k48zfGGLOfxhZ/Z/5N9lfptt/+/vY78zfG\n", "GNM1zvxrJvdc0pm//fZX4y8LZ/7GGGP209ji78y/yf4q3fbb399+Z/7GGGO6xpl/zeSeSzrzt9/+\n", "avxl4czfGGPMfhpb/J35N9lfpdt++/vb78zfGGNM1zjzr5ncc0ln/vbbX42/LJz5G2OM2U9ji78z\n", "/yb7q3Tbb39/+535G2OM6Rpn/jWTey7pzN9++6vxl4Uzf2OMMftpbPF35t9kf5Vu++3vb78zf2OM\n", "MV3jzL9mcs8lnfnbb381/rJw5m+MMWY/fVP8JS2StFXSNkmXl+AbKqFbtflzzyWd+dtvfzU0KvOX\n", "dCjwf4BFwDzg3ZLO7FF7ds8dq9W/qVp91v6c+26//T1TSu3pi+IPLAAei4iRiNgL3AZc2KNzZu/d\n", "qtO/p1p91v6c+26//T1TSu3pl+J/PLC9ZXpHajPGGFMBM+ruQKKKU45OKUNSHNHvOO+T7drLOaI/\n", "0ruisf4q3fbb3+/+kmpbP5zqKenNwBURsShNrwBejoirW5apv6PGGJMh7XZI+6X4zwC+C5wHPAls\n", "BN4dEd+ptWPGGNNQ+iL2iYh9kj4M3A0cCtzgwm+MMdXRF3v+xhhjppd+OdvHGGPMNNIXsY8xxlSB\n", "pEMoriM6nuKswp3Axigp8sjZ34jYJ+c/gP31ue1vtl/S+cD1wGMU1w4BnADMBZZFxN0D7c+9+Gf/\n", "B7C/Frf9A+HfCiyKiJFx7acCX4mIMwbZT0RkPQBbgVPatJ8KbLU/X3/Ofbe/L/zbgFe0aT+M4nYy\n", "A+1vQuZ/KMVXxfHspJxjGvbX58+57/bX778R+IakWxn7ZnEisCTNG2h/E4p/1n8A+2tz299wf0R8\n", "WtLfUNwk8s2peSfwuxGxZdD92Wf+AJLmUbxAx6WmncDflvEC2V+vP+e+21+/33SmEcXfGGOmgqRP\n", "RUTbGzMOir/RF3lJ+pT9zfTn3Hf76/cDDwy6v9HFnwz+APb3pdv+hvsj4suD7nfsY4xpLJIWARcx\n", "9uNQO4EvRcTaQfc3ovjn/Aewvz63/c32S7qO4oKxmxk7pfQE4L0U58lfOtD+3It/9n8A+2tx2z8Q\n", "/m0RMbdNu4BtEXHaIPt7ukKsH4b0IrRrFyVdZWd/Pf6c+25/X/g3AwvatC8ENg+6vwkXef1M0oKI\n", "2DiufQHwU/uz9ufcd/vr918CrJR0NAfeO+jFNG+g/U2IfeYDK4F2L9CyiHjQ/jz9Offd/vr9Lds5\n", "lpaLyCLi6TK84/z7j1lExFM5+LMv/qO0vEABPFnRH8BvoMn5d5T5+lTpbuOv8rUJ8n/vVPn6l/6/\n", "m/LxhbT0nxJvSX2Q7Z4REVtLcr0iIvaOa3tNRPygJ2+Div+bKPYaXgIeLeuFT26/gQ7uPjQiXkrj\n", "xwCnUeS5L/bqbrOtZRFxfdne5D6a4gDkP0fEnhJ8hwH7IuLlNP1W4BzgkYj4Sgn+10fEw716JtjG\n", "ScCLEbFHxa2E51PccfPbJW6jkv9dVXzL6Am2vT0iTuzR8RbgFuBI4EHgQxHxvTTvoYh4Qy/+7DN/\n", "SecCfwLsoXhj/hMwU9Je4L0Rsb1Hf8c3UCpElb2BgHUUN7rqmtY3kKQD3kDJ39MbSNJi4P9KegH4\n", "KHAd8DjF6/Ofo4dT9iT9tzbNn5B0BEBE/Gm37uS/PiKWpfHfBL7AWN8/FBF39eKnuFDpXOB5SR8H\n", "3gmsAT4q6dyIWN6j/yFJ3wNuBW6Nku+HI2k58CHgF5I+A3wM+BrwKUk3RsSf9Oiv9H8X+Czwtuhw\n", "P3yg1/vt/9lBZs/sxZ34DPAOYAvw74F1kt4bEV8vwd2Is302Aa9N46dSnCMM8HbgnhL8Vd9z/M8O\n", "MvywBP8DwOsozqB4F8WH2K+leQ+V4H8YmJNej58AZ6T2kym+HfXi/hFwO/DJNFwBPD86XULfH2oZ\n", "HwbOSeO/AjxYgv/bLeMPAkem8RmUczbIQ8CvAlemv+vDwPJ279cu/Vso9jpfk/4Wo/9nR1F8e+nV\n", "X/X/btX32/8hxYfjJcD7WoZLgN0l+B8eN/064LsU10X0/L+b/Z4/cEhEPJvGv09RdIiIdek84l6p\n", "+p7jl1DsUf2cIvMcRcDvluA/LCIeSeNflPQd4K8lXV6CG+ClSBmwpO9F+soeEU9IekWP7nnAn1IU\n", "mysi4ieS3hcRVdz35ZiI+CZARPyzip8X7JUfSjorIjYDz1IU0p8Cr6D4+/ZMFPHLJyi+ES2kuB3y\n", "P0r6fkT8eo/6fRHxU0m/oPhgfy5t88eSXu7RDdX/71Z9S+oHKD7gvzZ+hqQrSvD/QtKc0f+viHhE\n", "0nnAXcC/7lXehOL/oKQbgPXABekRSUdRzr2L/AaaAEmHRJFrv7+lbQZFkeuaiPg+8C5JFwH3Srq2\n", "t57+C86QtDmNnyrp1RHxvKRD6bHviQ8Bn5P0MPAM8ICkvwfOAj5dgv8AImIDsCHFZb9dgvKR9L4/\n", "CrgHWC3pTuCtwLdK8Ff6vxsV3w+fIor5WYdtn1KCfwXFt+r9B9gjYkeKyz7cqzz7A77poNoHgTMp\n", "3pA3RsRLko4EZse4vK/LbVR5v/pZwM8i4ie9ujr43w48GxGbxrXPBD4cEX/Uo38BRYTx03HtpwC/\n", "GRGf68Xf4nsVReyzICLKKGyjfWzlyYj4haTXAL8dEX9dwjZmAOcDp1PsbG0H7o5yDij/x4j4fK+e\n", "g/iPoNjJeSoi7pb0HuDXKaLQP4+In/for/x/13Qm++JvjDHtSDs4yyky8tkUseozwJeAq3r9AM7d\n", "n/0tnSW9SdJ6SZ+TdKKkdZJekPQNST2dyZL8R0v6n5IekfSipB9I2iDpkhK6b//U3ffn0PcG+7N5\n", "/YHVFCcIDAGzImIW8BaKs4tWD7o/+z1/Sd8A/pDi1KrPAH8AfJEil/yjiPi1Hv1/C9wJ3Av8B+BV\n", "wG3A/6C44OUT9lfjz7nv9veF/9GIOH2q8wbF3/PpYHUPHHi63vfHzdtUgn/86VYPpMdDgO/aX50/\n", "577b3xf+dcB/pzh+MNo2B7gcuHfQ/dnHPsBeSe+QdDHFxbjvhP0XkPR0QCrxY0m/lZwXArsBIl21\n", "aX+l/pz7bn/9/sUU1yj8naTnJT1PcT3HLwEXD7y/10+PugeKOwAOU1zleDLFV8gXgW8CbyzB/2+B\n", "b1DkbF8D/k1qfy1wqf3V+XPuu/31+5PrTOBtwNHj2hcNur/nzvXzALy/Yv8H7K/Hn3Pf7Z8eP3Ap\n", "xRWxXwKeAC5qmVfG1e15+6v8A9Y9ANvtb6Y/577bPz1+4NvAq9L4KRS32PhImi6jOGftz/4KX41d\n", "odmO2fbn68+57/bX76c4m/FHABExko4D3iHpZMq5vUbW/uyLP/DLwCKK82HH80/2Z+3Pue/21+9/\n", "RtLZka5uj4gfSfod4Abg9YPub0Lxv4viq9FD42dI+jv7s/bn3Hf76/f/J+CA37CIiL2S3gf8xaD7\n", "s7/IyxhjzNRpwnn+xhhjpoiLvzHGDCAu/sYYM4C4+BtjzADi4m/MNKFyfhrSmFLwm9GYNkj6lKTL\n", "Wqb/WNKlkj4uaaOkb6nlZzYl3SnpAUnflvTBlvYfSfpfkjYx9lOCxtSOi78x7bmR4jzr0T32xRS/\n", "pXpaRCwA3gDMH70rJcW9aN4IvAm4VNKrU/srgfsj4uyIKOPCJWNKoQkXeRlTOhHxhKTdks6muIf6\n", "QxSF/XxJoxclHQWcBvwDcJmKH5oHOBGYC2wEXgLumNbOGzMJXPyN6cxfAu+nuM/MjcB5wKcj4oCr\n", "KyUNpXlvjoifSVoPHJFm/yx8JaXpQxz7GNOZOynuPfNGYC1wN/ABSUcBSDpe0muBfwU8nwr/GTjb\n", "NxngPX+33UR1AAAAgElEQVRjOpDuo/JVisIewDpJZwJflwTwQ+A9FB8MvydpC8X917/eqpnmbhsz\n", "KXxvH2M6kA70Pgi8KyIer7s/xpSJYx9j2iBpHrCN4oeyXfhN4/CevzHGDCDe8zfGmAHExd8YYwYQ\n", "F39jjBlAXPyNMWYAcfE3xpgBxMXfGGMGkP8PT4WlVHuAN5QAAAAASUVORK5CYII=\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Using groupby(), plot the number of films\n", "# that have been released each decade in the history of cinema.\n", "\n", "t = titles\n", "t.groupby(t.year // 10 * 10).size().plot(kind='bar')" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": [ "iVBORw0KGgoAAAANSUhEUgAAAXAAAAEnCAYAAACwkhhwAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\n", "AAALEgAACxIB0t1+/AAAIABJREFUeJzt3X+w5XV93/HnC1bGH5hSa7oqu83aij+YakANbvEHlzRa\n", "3HFWO7UVUzWrM8l2GAYnVqtxmAl0kjFpGkVTNHQSupi0UKuRwghhjPKx4o9Vftx1ETAQvcmCEY2w\n", "KK5GkXf/+H4ve/Zw7j3nnj3f83l/7309Znb2fM/58j3PPefwuWff58cqIjAzs/45pnaAmZlNxwu4\n", "mVlPeQE3M+spL+BmZj3lBdzMrKe8gJuZ9dREC7ikYyXdIunqFS7/gKQ7Je2TdOpsE83MbJRJn4G/\n", "FbgNeNSbxiXtAJ4REScBvwZ8aHZ5Zma2krELuKQtwA7gjwCN2GUncBlAROwFTpC0eZaRZmb2aJM8\n", "A38f8A7g4RUuPxE4MLB9N7DlKLvMzGyMVRdwSa8Cvh0RtzD62fcjuw5t+/P5ZmYd2zTm8tOBne2c\n", "+7HAz0j6cES8aWCfe4CtA9tb2vOOIMmLupnZFCJi9BPoiJjoF3AGcPWI83cA17SntwNfXOG/j0mv\n", "a5WGC472GOuhIUtHhoYsHRkasnRkaJhXBxAQq/z6zTGXE5Ncx0qXjXsG/qj1HkDS7vaol0TENZJ2\n", "SLoL+AHw5jUecy22dXjsSW2rHdDaVjuAHA2Qo2Nb7YDWttoB5GiAFB1LnR594gU8Ij4DfKY9fcnQ\n", "ZefOuMvMzMbo2ycx99QOIEcD5OjYUzugtad2ADkaIEfHntoBrT21A2BXp0dXO2PpnKSIlQbxZmY9\n", "1Lw542jWUDFuXVxt7ezVM3BJC25oZOjI0AA5OjI0QI6ODA2QpaN0evReLeBmZnaYRyhmZlPyCMXM\n", "zKbSqwU8w0wrQwPk6MjQADk6MjRAjo4MDZClo3R69F4t4GZmdphn4GZmU/IM3MzMptKrBTzDTCtD\n", "A+ToyNAAOToyNECOjgwNkKWjdHr0Xi3gZmZ2mGfgZmZT8gzczMym0qsFPMNMK0MD5OjI0AA5OjI0\n", "QI6ODA2QpaN0evReLeBmZnaYZ+BmZlPyDNzMzKbSqwU8w0wrQwPk6MjQADk6MjRAjo4MDZClo3R6\n", "9LELuKTHStoraVHSbZLeM2KfBUkPSLql/XV+N7lmZrZsohm4pMdHxCFJm4AbgLdHxA0Dly8Ab4uI\n", "nascwzNwM1tXejEDj4hD7cnjgGOB+0aWmJnZ3Ey0gEs6RtIicC9wfUTcNrRLAKdL2ifpGkknzzq0\n", "7Vjo4rh9a4AcHRkaIEdHhgbI0ZGhAbJ0lE6PPukz8Icj4hRgC/CyETfMzcDWiPh54A+AK2daaWZm\n", "j7JpLTtHxAOSPgG8kIEfLRHx/YHT10r6oKQnRcQRoxZJe4CldvMgsBgRpb1sof3vV90eONZE+6/X\n", "7eXzavcMttS6PSKi+P7Is53h/pjX4/Ow0v6+sMbtR/e1p3e1Fy2xirEvYkp6MvBQRByU9DjgOuDC\n", "iPjUwD6bgW9HREg6DfhIRGwbOo5fxDSzdaUPL2I+Ffh0OwPfC1wdEZ+StFvS7naf1wL7230uAs6e\n", "/A8wuQwzrQwNkKMjQwPk6MjQADk6MjRAlo7S6dHHjlAiYj/w/BHnXzJw+mLg4tmmmZnZavxdKGZm\n", "U+rDCMXMzBLq1QKeYaaVoQFydGRogBwdGRogR0eGBsjSUTo9eq8WcDMzO8wzcDOzKXkGbmZmU+nV\n", "Ap5hppWhAXJ0ZGiAHB0ZGiBHR4YGyNJROj16rxZwMzM7zDNwM7MpeQZuZmZT6dUCnmGmlaEBcnRk\n", "aIAcHRkaIEdHhgbI0lE6PXqvFnAzMzvMM3Azsyl5Bm5mZlPp1QKeYaaVoQFydGRogBwdGRogR0eG\n", "BsjSUTo9eq8WcDMzO8wzcDOzKXkGbmZmU+nVAp5hppWhAXJ0ZGiAHB0ZGiBHR4YGyNJROj36qgu4\n", "pMdK2itpUdJtkt6zwn4fkHSnpH2STu0m1czMBo2dgUt6fEQckrQJuAF4e0TcMHD5DuDciNgh6UXA\n", "+yNi+4jjeAZuZutK+hl4RBxqTx4HHAvcN7TLTuCydt+9wAmSNo87rpmZHZ2xC7ikYyQtAvcC10fE\n", "bUO7nAgcGNi+G9gyu8QjWha6OG7fGiBHR4YGyNGRoQFydGRogCwdpdOjT/IM/OGIOIVmUX7ZCjfK\n", "8NP7+bw30cxsA9s06Y4R8YCkTwAv5MgfK/cAWwe2t7TnPYqkPcBSu3kQWIyI0l420aIvrT5GX54V\n", "Lf+gGTj+utpePq92z2BLrdsjIorvjzzbGe6PeT0+Dyvt7wtr3H50X3t6V3vREqtY9UVMSU8GHoqI\n", "g5IeB1wHXBgRnxrYZ/BFzO3ARdO8iHn0LwbAJC8ImJnNSvYXMZ8KfLqdge8Fro6IT0naLWk3QERc\n", "A3xd0l3AJcA5a/4zTKx0d+gJ5Zir5ejI0AA5OjI0QI6ODA2QpaN0evRVRygRsR94/ojzLxnaPnfG\n", "XWZmNkaa70LxCMXM+ib7CMXMzJLq2QJeagckmavl6MjQADk6MjRAjo4MDZClo3R69J4t4GZmtswz\n", "cDOzKXkGbmZmU+nZAl5qBySZq+XoyNAAOToyNECOjgwNkKWjdHr0ni3gZma2zDNwM7MpeQZuZmZT\n", "6dkCXmoHJJmr5ejI0AA5OjI0QI6ODA2QpaN0evSeLeBmZrbMM3Azsyl5Bm5mZlPp2QJeagckmavl\n", "6MjQADk6MjRAjo4MDZClo3R69J4t4GZmtswzcDOzKXkGbmZmU+nZAl5qBySZq+XoyNAAOToyNECO\n", "jgwNkKWjdHr0sQu4pK2Srpf0VUm3SjpvxD4Lkh6QdEv76/xucs3MbNnYGbikpwBPiYhFSccDNwGv\n", "iYjbB/ZZAN4WETtXOY5n4Ga2rqSfgUfEtyJisT39IHA78LSRJWZmNjdrmoFL2gacCuwduiiA0yXt\n", "k3SNpJNnkzesdHPYNcgxV8vRkaEBcnRkaIAcHRkaIEtH6fTomybdsR2ffBR4a/tMfNDNwNaIOCTp\n", "lcCVwDNnl2lmZsMmWsAlPQb4GPCnEXHl8OUR8f2B09dK+qCkJ0XEfUPH2QMstZsHgcWIKIf3KMDC\n", "wGlGbDPR5cs/fZePv962l8+r3TPYUuv2iIji+yPPdob7Y16Pz8NK+/vCGrcf3dee3tVetMQqJnkR\n", "U8BlwHcj4tdX2Gcz8O2ICEmnAR+JiG1D+/hFTDNbV9K/iAm8GHgDcObA2wRfKWm3pN3tPq8F9kta\n", "BC4Czl7Dn2ANSjeHXYMcc7UcHRkaIEdHhgbI0ZGhAbJ0lE6PPnaEEhE3MGahj4iLgYtnFWVmZuP5\n", "u1DMzKbUhxGKmZkl1LMFvNQOSDJXy9GRoQFydGRogBwdGRogS0fp9Og9W8DNzGyZZ+BmZlPyDNzM\n", "zKbSswW81A5IMlfL0ZGhAXJ0ZGiAHB0ZGiBLR+n06D1bwM3MbJln4GZmU/IM3MzMptKzBbzUDkgy\n", "V8vRkaEBcnRkaIAcHRkaIEtH6fToPVvAzcxsmWfgZmZT8gzczMym0rMFvNQOSDJXy9GRoQFydGRo\n", "gBwdGRogS0fp9Og9W8DNzGyZZ+BmZlPyDNzMzKbSswW81A5IMlfL0ZGhAXJ0ZGiAHB0ZGiBLR+n0\n", "6GMXcElbJV0v6auSbpV03gr7fUDSnZL2STp19qlmZjZo7Axc0lOAp0TEoqTjgZuA10TE7QP77ADO\n", "jYgdkl4EvD8itg8dxzNwM1tX0s/AI+JbEbHYnn4QuB142tBuO4HL2n32AidI2jxBvZmZTWlNM3BJ\n", "24BTgb1DF50IHBjYvhvYcjRho5XZH3KNcszVcnRkaIAcHRkaIEdHhgbI0lE6PfrEC3g7Pvko8Nb2\n", "mfijdhnans/7E83MNqhNk+wk6THAx4A/jYgrR+xyD7B1YHtLe97wcfYAS+3mQWAxIsrhPQqwMHCa\n", "EdtMdPnyT9/l46+37eXzavcMtnR0/OuZgDT2pY8zj7Jn7BOSCRoemXfWfvwczfaMbovO749JOo72\n", "/jistL8vrHH7kc5Hjt+e3tVetLRa/yQvYopmvv3diPj1FfYZfBFzO3CRX8S0WcjyuMjSkcE8Xrjr\n", "viFLR/cf5Hkx8AbgTEm3tL9eKWm3pN0AEXEN8HVJdwGXAOes7Q8xqdLNYdcgx1wtR0eGhkapHUCO\n", "hiz3Sakd0Cq1A+i6YewIJSJuYLJ3q5w7kyIzM5uIvwvFUsvyuMjSkYFHKLPs8HehmJltSD1bwEvt\n", "gCQzxhwdGRoapXYAORqy3CeldkCr1A4gzfvAzcwsF8/ALbUsj4ssHRl4Bj7LDs/Azcw2pJ4t4KV2\n", "QJIZY46ODA2NUjuAHA1Z7pNSO6BVagfgGbiZmY3kGbilluVxkaUjA8/AZ9nhGbiZ2YbUswW81A5I\n", "MmPM0ZGhoVFqB5CjIct9UmoHtErtADwDNzOzkTwDt9SyPC6ydGTgGfgsOzwDNzPbkHq2gJfaAUlm\n", "jDk6MjQ0Su0AcjRkuU9K7YBWqR2AZ+BmZjaSZ+CWWpbHRZaODDwDn2WHZ+BmZhtSzxbwUjsgyYwx\n", "R0eGhkapHUCOhiz3Sakd0Cq1A6g+A5d0qaR7Je1f4fIFSQ8M/IPH588+08zMho2dgUt6KfAg8OGI\n", "eO6IyxeAt0XEzjHH8Qzc1izL4yJLRwaegc+yo+MZeER8Frh/bIWZmc3VLGbgAZwuaZ+kaySdPINj\n", "rqB0d+gJ5Zgx5ujI0NAotQPI0ZDlPim1A1qldgBdN2yawTFuBrZGxCFJrwSuBJ45akdJe4CldvMg\n", "sBgR5fAeBVgYOM3Q9uKYy4+4rgWA5ePParvr40+6DZwiqdr1t9un0N7wXd/eK9/fk23P4PZm9cfn\n", "4oQ9zKSn9uMz//1RmMd6cWTLysdfy/W3p3e1Fy2xioneBy5pG3D1qBn4iH2/AbwgIu4bOt8zcFuz\n", "LI+LLB0ZeAY+y47K7wOXtFmS2tOn0fxQuG/Mf2ZmZkdpkrcRXg58HniWpAOS3iJpt6Td7S6vBfZL\n", "WgQuAs7uLrd0d+gJ5Zgx5ujI0NAotQPI0ZDlPim1A1qldgDVZ+AR8foxl18MXDyzIjMzm4i/C8VS\n", "y/K4yNKRgWfgs+zwd6GYmW1IPVvAS+2AJDPGHB0ZGhqldgA5GrLcJ6V2QKvUDqD6d6GYmVlOnoFb\n", "alkeF1k6MvAMfJYdnoGbmW1IPVvAS+2AJDPGHB0ZGhqldgA5GrLcJ6V2QKvUDsAzcDMzG8kzcEst\n", "y+MiS0cGnoHPssMzcDOzDalnC3ipHZBkxpijI0NDo9QOIEdDlvuk1A5oldoBeAZuZmYjeQZuqWV5\n", "XGTpyMAz8Fl2eAZuZrYh9WwBL7UDkswYc3RkaGiU2gHkaMhyn5TaAa1SOwDPwM3MbCTPwC21LI+L\n", "LB0ZeAY+yw7PwM3MNqSeLeCldkCSGWOOjgwNjVI7gBwNWe6TUjugVWoHUH0GLulSSfdK2r/KPh+Q\n", "dKekfZJOnW2imZmNMnYGLumlwIPAhyPiuSMu3wGcGxE7JL0IeH9EbB+xn2fgtmZZHhdZOjLwDHyW\n", "HR3PwCPis8D9q+yyE7is3XcvcIKkzeOOa2ZmR2cWM/ATgQMD23cDW2Zw3BFKN4ddgxwzxhwdGRoa\n", "pXYAORqy3CeldkCr1A6g64ZNMzrO8NP7kX+nkLQHWGo3DwKLEVEO71GAhYHTDG0vjrn8iOtaAFg+\n", "/qTbwPWj2oeOPW4XgDOnuf6IKM1fy8aboOPMaa5/YHsmt0VE6Cjuj1Zpf1+Yanva65/88bk4YQ9H\n", "0zP2/mj3XfXyo7k/Dt8ey3+eBabZ7v7+KMxpvZjo+Gu5/vb0rvaiJVYx0fvAJW0Drl5hBv6HQImI\n", "K9rtO4AzIuLeof16MQPP0JGhIUtHhoYsHRkaZtORoSFLR/33gV8FvKm9ou3AweHF28zMZm+StxFe\n", "DnweeJakA5LeImm3pN0AEXEN8HVJdwGXAOd0l1u6O/TESu2AVqkdQI4GyNFRage0Su0AcjRAjo7S\n", "6dHHzsAj4vUT7HPubHLMzGxS/i6UhB0ZGrJ0ZGjI0pGhYTYdGRqydNSfgZuZWQU9W8BL7QByNECO\n", "jlI7oFVqB5CjAXJ0lNoBrVI7gOrfhWJmZjl5Bp6wI0NDlo4MDVk6MjTMpiNDQ5YOz8DNzDakni3g\n", "pXYAORogR0epHdAqtQPI0QA5OkrtgFapHYBn4GZmNpJn4Ak7MjRk6cjQkKUjQ8NsOjI0ZOnwDNzM\n", "bEPq2QJeageQowFydJTaAa1SO4AcDZCjo9QOaJXaAXgGbmZmI3kGnrAjQ0OWjgwNWToyNMymI0ND\n", "lg7PwM3MNqSeLeCldgA5GiBHR6kd0Cq1A8jRADk6Su2AVqkdgGfgZmY2kmfgCTsyNGTpyNCQpSND\n", "w2w6MjRk6fAM3MxsQ+rZAl5qB5CjAXJ0lNoBrVI7gBwNkKOj1A5oldoBpJiBSzpL0h2S7pT0zhGX\n", "L0h6QNIt7a/zZ59qZmaDxs7AJR0LfA34JeAe4MvA6yPi9oF9FoC3RcTOVY7jGXiPGrJ0ZGjI0pGh\n", "YTYdGRqydHQ/Az8NuCsiliLiJ8AVwKtHlpiZ2dxMsoCfCBwY2L67PW9QAKdL2ifpGkknzyrwSKWb\n", "w65JqR3QKrUDyNEAOTpK7YBWqR1AjgbI0VE6PfqmCfaZ5O8HNwNbI+KQpFcCVwLPHN5J0h5gqd08\n", "CCxGRDm8RwEWBk4ztL045vIjrmsBYPn4k24f2bLy8Ve+fOGorv/w7bH68ZvbYrXLm2NOe/2T3R4Z\n", "7o/Jto/+/lg+5krXN+7+GDjMUfQc2bLy8bu6/skfn6tvd39/FHI8Pie7fPD47eld7UVLrGKSGfh2\n", "4IKIOKvd/g3g4Yj43VX+m28AL4iI+wbO8wy8Rw1ZOjI0ZOnI0DCbjgwNWTq6n4HfCJwkaZuk44DX\n", "AVcNXcFmSWpPn0bzg+G+Rx/KzMxmZewCHhEPAecC1wG3Af87Im6XtFvS7na31wL7JS0CFwFnd5Nb\n", "ujnsmpTaAa1SO4AcDZCjo9QOaJXaAeRogBwdpdOjTzIDJyKuBa4dOu+SgdMXAxfPNs3MzFbj70JJ\n", "2JGhIUtHhoYsHRkaZtORoSFLh78LxcxsQ+rZAl5qB5CjAXJ0lNoBrVI7gBwNkKOj1A5oldoBpPgu\n", "FDMzy8cz8IQdGRqydGRoyNKRoWE2HRkasnR4Bm5mtiH1bAEvtQPI0QA5OkrtgFapHUCOBsjRUWoH\n", "tErtADwDNzOzkTwDT9iRoSFLR4aGLB0ZGmbTkaEhS4dn4GZmG1LPFvBSO4AcDZCjo9QOaJXaAeRo\n", "gBwdpXZAq9QOwDNwMzMbyTPwhB0ZGrJ0ZGjI0pGhYTYdGRqydHgGbma2IfVsAS+1A8jRADk6Su2A\n", "VqkdQI4GyNFRage0Su0APAM3M7ORPANP2JGhIUtHhoYsHRkaZtORoSFLh2fgZmYb0tgFXNJZku6Q\n", "dKekd66wzwfay/dJOnX2mctKd4eeWKkd0Cq1A8jRADk6Su2AVqkdQI4GyNFROj36qgu4pGOB/wac\n", "BZwMvF7Sc4b22QE8IyJOAn4N+FBHrcBid4eeWIYGyNGRoQFydGRogBwdGRogR0e3DeOegZ8G3BUR\n", "SxHxE+AK4NVD++wELgOIiL3ACZI2z7wUgIPdHHZNMjRAjo4MDZCjI0MD5OjI0AA5OrptGLeAnwgc\n", "GNi+uz1v3D5bjj7NzMxWM24Bn/Tl1eFXSDt6a8tSN4ddk6XaAa2l2gHkaIAcHUu1A1pLtQPI0QA5\n", "OpY6PfqqbyOUtB24ICLOard/A3g4In53YJ8/BEpEXNFu3wGcERH3Dh1rPu9XNDNbZ1Z6G+GmMf/d\n", "jcBJkrYB3wReB7x+aJ+rgHOBK9oF/+Dw4r1agJmZTWfVBTwiHpJ0LnAdcCzwxxFxu6Td7eWXRMQ1\n", "knZIugv4AfDmzqvNzGx+n8Q0M7PZ8icxzcx6atwM3MwsPUnH0Hxu5USad8HdA3wp5jhiqNGQdoSy\n", "Ue+QrB0ZGrJ0ZGjI0pGk4RXAB4G7aD6HAs1nUU4CzomI69ZrQ8oFfCPfIRk7MjRk6cjQkKUjQ0Pb\n", "cQdwVkQsDZ3/dODaiHj2um2IiHS/gDuAbSPOfzpwx0ZpyNKRoSFLR4aGLB0ZGtrruxN4zIjzj6P5\n", "KpB125B1Bn4szV/Fht3D/Ob2GRqydGRoyNKRoSFLR4YGgEuBL0u6nMN/E9gKnN1etm4bsi7gG/YO\n", "SdqRoSFLR4aGLB0ZGoiI90j6vzRftLe9Pfse4Jcj4rb13JByBg4g6WSaG+Np7Vn3AFfN6w7J0pCl\n", "I0NDlo4MDVk6MjRsZGkXcDOzoyXpwoj4zfXa0LsP8ki60A2NDB0ZGiBHR4YGyNGRoaF1Y+0AOmzo\n", "3QLOOr9D1ihDR4YGyNGRoQFydGRoICKuXs8NHqGYWe9JOgt4DYf/wZl7gCsj4s/Xc0PaBXyj3iFZ\n", "OzI0ZOnI0JClI0nD+2k+PPRhDr+tcQvwRpr3YJ+3XhtSLuAb+Q7J2JGhIUtHhoYsHRka2o47o/lH\n", "1YfPF3BnRDxj3TbM69NSa/1U0wrnizl+sqp2Q5aODA1ZOjI0ZOnI0NBe337gtBHnvwjYv54bsn6Q\n", "50eSTouILw2dfxrwww3UkKUjQ0OWjgwNWToyNADsAj4k6Ykc+Z0s32svW7cNWUcoLwA+BIy6Mc6J\n", "iJs2QkOWjgwNWToyNGTpyNAw1PNUBj5QFBHfmuf1DzQ88npARPxtp9eXcQFfNu8bI2vDiI67N8KD\n", "c4KOYIP8jzphR+3HRQDfrPT/qWjGFY/cFlT4it9RJD07Iu7o5NgJ/nxr0uWNscL1PSYifjJ03pMj\n", "4u/m1TCi6ZyI+GDF638izYtXX4+Ig3O83uOAhyLi4Xb7F4HnA1+NiGvn1PC8iPjKPK5rHEn/BPhe\n", "RBxsv7b0BTTfAnjrnDt+geaZ90+Bv5zn/5/t9af4WtuVSDoQEVs7OXYPF/DOboyh6zkT+BPgccBN\n", "wO6I+EZ72S0RcWrXDe11/ccRZ78b+G2AiHjvHBo+GBHntKdfAvwv4K9o/gfZHRGf6Lqhve6vAGdE\n", "xP2S3gH8a+Aa4Azgpoh41xwafgp8A7gcuDwqfeeHpHcBu4EfA78HvB34HM0XKV0aEb8/h4YzgN8H\n", "DtL88Pg8cALwE+CNEXGg64a2I8P3gf/BKhfviogndnG9KV/EHHNjnDCnjN8D/hVwG/BvgE9KemNE\n", "fGFO17/sQuATbQc0r/AfQzN3nJd/MXD6t4DXRMTNkv4p8H/avnk4JiLub0+fDbwkIn4o6XeAW4DO\n", "F3DgKzRvk/tl4CpJh2h+oF0xvIB07E3AycATgCXg6RHxHUlPAL5Es7B27f3Ay9vrfTrwvoh4saSX\n", "A38MvGIODZDja2130fwQ/XuaUdIy0TxWOpFyAafSjTHkuIj4anv6o5JuB/5M0jvndP3LTgbeS/M/\n", "6gURcUjSr0REre+a+AcRcTNARHxdzT+pNS/fl/TciNgPfIfmb0c/BB5D89iYi3ZE8W7g3ZJeRPPD\n", "5AZJfxMRp88p46H2h9ePgUPAfW3bDyQ9PKeGYyLiO+3pvwF+rm34ZPse8XnJ8LW2NwK3RsTnhi+Q\n", "dEFXV5pyhCLpeuD8FW6MpYjYNoeGG4FXDb4oJGkLzbPNfxYRx3fdMNTzGuA/Ae8D/ktEPH2O1/1D\n", "mvkiNP/aytZ2jHEssC8i/vmcOp5HM9b6Cs0P9pcA/w94LvDeiPifc2gYOT5rf5C9LCJK1w3t9V3e\n", "nnwCzbs+Hgd8HPhFmicfb5hDw/8AHgauB3bSvIj6tvZvATfNY3Qx0FL1a20lPQn4UUQcmsf1PXK9\n", "SRfwKjfGUMPLge9ExOLQ+ScA50bEb1VoOh64gOYDAy+b4/VuGzrrmxHxY0lPplm0/myOLZto/mr+\n", "TJq/QR4ArpvXi6mS/v08flBM0PFYmmeYfxsR10l6A3A6zT9zdklE/P0cGo4DfhV4DrCPZvb+U0mP\n", "AzbPeaS0IaVcwM3MJtU+qXoXzXeybKb529m3gSuB35nHD/daDSm/TlbSEyX9Z0lflfQ9SX8naa+k\n", "XRupYZWOL/q28OPCj4tHfAS4H1gAnhQRTwLOpHl3zEfWc0PKZ+CSrqKZ5/0F8G+B44ErgPNp5mzv\n", "3ggNWToyNGTpyNCQpSNDQ9vxlxHxzLVeti4aYk5fOLOWX8BXhrZvbH8/BvjaRmnI0pGhIUtHhoYs\n", "HRka2uv7JM0L/JsHznsK8E7gL9ZzQ8oRCvADSS8FkPRq4LsA0X4CbwM1ZOnI0JClI0NDlo4MDQCv\n", "A54MfEbS/ZLuBwrwj4B/t64b5vVTco0/zX4e+DLN/OhzwLPa838WOG+jNGTpyNCQpSNDQ5aODA0D\n", "Lc8Bfgl44tD5Z63nhrndwDO8kd7ihjwdGRqydGRoyNIxzwbgPOBrNO/4+GuaTwovX3bLem5I+SLm\n", "ajSn70LJ3pClI0NDlo4MDVk65tkg6VZge0Q82H5m4WPAn0TERSt98Gq9NKT8KL2k/atcvHmjNGTp\n", "yNCQpSNDQ5aODA0tRcSDABGxpOZLtj4m6eeY31csVGlIuYAD/xg4i+Z9lcM+v4EasnRkaMjSkaEh\n", "S0eGBoBvSzol2k9Nt8+CX0XzhVrPW88NWRfwTwDHR8QtwxdI+swGasjSkaEhS0eGhiwdGRqg+WbG\n", "I76zPyJ+IulXgP++nht6NwM3M7NG1veBm5nZGF7Azcx6ygu4mVlPeQE3M+spL+BmE9J8//k4s7H8\n", "gLR1SdKFkt46sP3bks6T9A5JX5K0TwP/VqGkj0u6UdKtkn514PwHJf1XSYs0/+K7WRpewG29upTm\n", "vbnLz5xfB3wLeEZEnAacCrxg+dv0aL6744XALwDnSfqH7fmPB74YEadExDw/nGI2VtYP8pgdlYj4\n", "a0nflXQKzfcy30KzOL9C0vIHT54APAP4LPBWNf9wNDT/ovlJwJeAn9J8r4VZOl7AbT37I+DNNN/L\n", "cSnwL4H3RMQRn4yTtNBetj0ifiTpeuCx7cU/Cn/azZLyCMXWs4/TfFfHC4E/B64D3iLpCQCSTpT0\n", "s8DPAPfh0pzEAAAAh0lEQVS3i/ez8azbesLPwG3dar+L4tM0i3MAn5T0HOALkgC+D7yBZnH/D5Ju\n", "o/lO5y8MHmbO2WYT83eh2LrVvnh5E/DaiPir2j1ms+YRiq1Lkk4G7qT5B2W9eNu65GfgZmY95Wfg\n", "ZmY95QXczKynvICbmfWUF3Azs57yAm5m1lNewM3Meur/A5fE8I+zBuyOAAAAAElFTkSuQmCC\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "# Use groupby() to plot the number of \"Hamlet\" films made each decade.\n", "\n", "t = titles\n", "t = t[t.title == 'Hamlet']\n", "t.groupby(t.year // 10 * 10).size().plot(kind='bar')" ] }, { "cell_type": "code", "execution_count": 7, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "year type \n", "1950 actor 744\n", " actress 351\n", "1951 actor 766\n", " actress 365\n", "1952 actor 751\n", " actress 359\n", "1953 actor 785\n", " actress 377\n", "1954 actor 767\n", " actress 398\n", "1955 actor 764\n", " actress 345\n", "1956 actor 799\n", " actress 401\n", "1957 actor 920\n", " actress 394\n", "1958 actor 872\n", " actress 392\n", "1959 actor 881\n", " actress 383\n", "dtype: int64" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# How many leading (n=1) roles were available to actors,\n", "# and how many to actresses, in each year of the 1950s?\n", "\n", "c = cast\n", "c = c[c.year // 10 == 195]\n", "c = c[c.n == 1]\n", "c.groupby(['year', 'type']).size()" ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "n type \n", "1 actor 8049\n", " actress 3765\n", "2 actor 5632\n", " actress 5543\n", "3 actor 6746\n", " actress 3920\n", "4 actor 6695\n", " actress 3568\n", "5 actor 6661\n", " actress 3199\n", "dtype: int64" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# In the 1950s decade taken as a whole,\n", "# how many total roles were available to actors,\n", "# and how many to actresses, for each \"n\" number 1 through 5?\n", "\n", "c = cast\n", "c = c[c.year // 10 * 10 == 1950]\n", "c = c[c.n < 6]\n", "c.groupby(['n', 'type']).size()" ] }, { "cell_type": "code", "execution_count": 46, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
n
year
196315
200650
\n", "
" ], "text/plain": [ " n\n", "year \n", "1963 15\n", "2006 50" ] }, "execution_count": 46, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Use groupby() to determine how many roles are listed\n", "# for each of the Pink Panther movies.\n", "\n", "c = cast\n", "c = c[c.title == 'The Pink Panther']\n", "c = c.sort('n').groupby(['year'])[['n']].max()\n", "c" ] }, { "cell_type": "code", "execution_count": 32, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "year title \n", "1979 The Muppet Movie 7\n", "1981 An American Werewolf in London 2\n", " The Great Muppet Caper 6\n", "1984 The Muppets Take Manhattan 7\n", "1985 Sesame Street Presents: Follow that Bird 3\n", "1992 The Muppet Christmas Carol 7\n", "1996 Muppet Treasure Island 4\n", "1999 Muppets from Space 4\n", " The Adventures of Elmo in Grouchland 3\n", "dtype: int64" ] }, "execution_count": 32, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# List, in order by year, each of the films\n", "# in which Frank Oz has played more than 1 role.\n", "\n", "c = cast\n", "c = c[c.name == 'Frank Oz']\n", "g = c.groupby(['year', 'title']).size()\n", "g[g > 1]" ] }, { "cell_type": "code", "execution_count": 36, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "character\n", "Grover 2\n", "Bert 3\n", "Cookie Monster 3\n", "Fozzie Bear 4\n", "Sam the Eagle 5\n", "Yoda 5\n", "Animal 6\n", "Miss Piggy 6\n", "dtype: int64" ] }, "execution_count": 36, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# List each of the characters that Frank Oz\n", "# has portrayed at least twice.\n", "\n", "c = cast\n", "c = c[c.name == 'Frank Oz']\n", "g = c.groupby(['character']).size()\n", "g[g > 1].order()" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] } ], "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.4.3" } }, "nbformat": 4, "nbformat_minor": 0 }