{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "319833e7-508d-4a02-b44c-01ffd055ca6e", "metadata": {}, "outputs": [], "source": [ "#필요한 모듈 불러오기\n", "#!pip install bar_chart_race as bcr\n", "import pandas as pd\n", "import numpy as np\n", "import bar_chart_race as bcr" ] }, { "cell_type": "code", "execution_count": 2, "id": "c5717fd1-5582-4d9f-b979-3310d7a0044a", "metadata": {}, "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", " \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", "
SeasonPosTeamPldWDLGFGAGDPtsQualification or relegation
02010-111Manchester United382311478374180Qualification for the Champions League group s...
12010-112Chelsea38218969333671Qualification for the Champions League group s...
22010-113Manchester City38218960332771Qualification for the Champions League group s...
32010-114Arsenal381911872432968Qualification for the Champions League play-of...
42010-115Tottenham Hotspur38161485546962Qualification for the Europa League play-off r...
\n", "
" ], "text/plain": [ " Season Pos Team Pld W D L GF GA GD Pts \\\n", "0 2010-11 1 Manchester United 38 23 11 4 78 37 41 80 \n", "1 2010-11 2 Chelsea 38 21 8 9 69 33 36 71 \n", "2 2010-11 3 Manchester City 38 21 8 9 60 33 27 71 \n", "3 2010-11 4 Arsenal 38 19 11 8 72 43 29 68 \n", "4 2010-11 5 Tottenham Hotspur 38 16 14 8 55 46 9 62 \n", "\n", " Qualification or relegation \n", "0 Qualification for the Champions League group s... \n", "1 Qualification for the Champions League group s... \n", "2 Qualification for the Champions League group s... \n", "3 Qualification for the Champions League play-of... \n", "4 Qualification for the Europa League play-off r... " ] }, "execution_count": 2, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#필요한 데이터 셋 불러오기\n", "# 주의할 점: 주소에 \\를 //로 바꿔줄 것!\n", "path = \"C://Users//user//Desktop//blog//code//EPL_Standings_2010_2021.csv\"\n", "EPL = pd.read_csv(path)\n", "\n", "# 요약출력\n", "EPL.head()" ] }, { "cell_type": "code", "execution_count": 3, "id": "9403306e-87d3-4d1f-86dd-c7129f6599bc", "metadata": {}, "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", "
SeasonTeamPts
02010-11Manchester United80
12010-11Chelsea71
22010-11Manchester City71
32010-11Arsenal68
42010-11Tottenham Hotspur62
\n", "
" ], "text/plain": [ " Season Team Pts\n", "0 2010-11 Manchester United 80\n", "1 2010-11 Chelsea 71\n", "2 2010-11 Manchester City 71\n", "3 2010-11 Arsenal 68\n", "4 2010-11 Tottenham Hotspur 62" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# 필요한 데이터만 남기고 지우기\n", "EPL = EPL[['Season','Team','Pts']]\n", "EPL.head()" ] }, { "cell_type": "code", "execution_count": 4, "id": "662a4d96-bdf3-4a14-ad12-9ee47922347e", "metadata": {}, "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", " \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", " \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", "
TeamArsenalAston VillaBirmingham CityBlackburn RoversBlackpoolBolton WanderersBournemouthBrighton & Hove AlbionBurnleyCardiff City...SouthamptonStoke CitySunderlandSwansea CityTottenham HotspurWatfordWest Bromwich AlbionWest Ham UnitedWigan AthleticWolverhampton Wanderers
Season
2010-1168.048.039.043.039.046.0NaNNaNNaNNaN...NaN46.047.0NaN62.0NaN47.033.042.040.0
2011-1270.038.0NaN31.0NaN36.0NaNNaNNaNNaN...NaN45.045.047.069.0NaN47.0NaN43.025.0
2012-1373.041.0NaNNaNNaNNaNNaNNaNNaNNaN...41.042.039.046.072.0NaN49.046.036.0NaN
2013-1479.038.0NaNNaNNaNNaNNaNNaNNaN30.0...56.050.038.042.069.0NaN36.040.0NaNNaN
2014-1575.038.0NaNNaNNaNNaNNaNNaN33.0NaN...60.054.038.056.064.0NaN44.047.0NaNNaN
\n", "

5 rows × 37 columns

\n", "
" ], "text/plain": [ "Team Arsenal Aston Villa Birmingham City Blackburn Rovers Blackpool \\\n", "Season \n", "2010-11 68.0 48.0 39.0 43.0 39.0 \n", "2011-12 70.0 38.0 NaN 31.0 NaN \n", "2012-13 73.0 41.0 NaN NaN NaN \n", "2013-14 79.0 38.0 NaN NaN NaN \n", "2014-15 75.0 38.0 NaN NaN NaN \n", "\n", "Team Bolton Wanderers Bournemouth Brighton & Hove Albion Burnley \\\n", "Season \n", "2010-11 46.0 NaN NaN NaN \n", "2011-12 36.0 NaN NaN NaN \n", "2012-13 NaN NaN NaN NaN \n", "2013-14 NaN NaN NaN NaN \n", "2014-15 NaN NaN NaN 33.0 \n", "\n", "Team Cardiff City ... Southampton Stoke City Sunderland Swansea City \\\n", "Season ... \n", "2010-11 NaN ... NaN 46.0 47.0 NaN \n", "2011-12 NaN ... NaN 45.0 45.0 47.0 \n", "2012-13 NaN ... 41.0 42.0 39.0 46.0 \n", "2013-14 30.0 ... 56.0 50.0 38.0 42.0 \n", "2014-15 NaN ... 60.0 54.0 38.0 56.0 \n", "\n", "Team Tottenham Hotspur Watford West Bromwich Albion West Ham United \\\n", "Season \n", "2010-11 62.0 NaN 47.0 33.0 \n", "2011-12 69.0 NaN 47.0 NaN \n", "2012-13 72.0 NaN 49.0 46.0 \n", "2013-14 69.0 NaN 36.0 40.0 \n", "2014-15 64.0 NaN 44.0 47.0 \n", "\n", "Team Wigan Athletic Wolverhampton Wanderers \n", "Season \n", "2010-11 42.0 40.0 \n", "2011-12 43.0 25.0 \n", "2012-13 36.0 NaN \n", "2013-14 NaN NaN \n", "2014-15 NaN NaN \n", "\n", "[5 rows x 37 columns]" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#데이터를 알맞은 포맷으로 변형하기 - 피봇팅\n", "df = EPL.pivot_table(values='Pts', index = ['Season'],columns='Team')\n", "df.head()" ] }, { "cell_type": "code", "execution_count": 5, "id": "acbd531f-aa9f-4096-b2fa-65ee3af8a483", "metadata": {}, "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", " \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", " \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", "
TeamArsenalAston VillaBirmingham CityBlackburn RoversBlackpoolBolton WanderersBournemouthBrighton & Hove AlbionBurnleyCardiff City...SouthamptonStoke CitySunderlandSwansea CityTottenham HotspurWatfordWest Bromwich AlbionWest Ham UnitedWigan AthleticWolverhampton Wanderers
Season
2010-1168.048.039.043.039.046.00.00.00.00.0...0.046.047.00.062.00.047.033.042.040.0
2011-1270.038.00.031.00.036.00.00.00.00.0...0.045.045.047.069.00.047.00.043.025.0
2012-1373.041.00.00.00.00.00.00.00.00.0...41.042.039.046.072.00.049.046.036.00.0
2013-1479.038.00.00.00.00.00.00.00.030.0...56.050.038.042.069.00.036.040.00.00.0
2014-1575.038.00.00.00.00.00.00.033.00.0...60.054.038.056.064.00.044.047.00.00.0
\n", "

5 rows × 37 columns

\n", "
" ], "text/plain": [ "Team Arsenal Aston Villa Birmingham City Blackburn Rovers Blackpool \\\n", "Season \n", "2010-11 68.0 48.0 39.0 43.0 39.0 \n", "2011-12 70.0 38.0 0.0 31.0 0.0 \n", "2012-13 73.0 41.0 0.0 0.0 0.0 \n", "2013-14 79.0 38.0 0.0 0.0 0.0 \n", "2014-15 75.0 38.0 0.0 0.0 0.0 \n", "\n", "Team Bolton Wanderers Bournemouth Brighton & Hove Albion Burnley \\\n", "Season \n", "2010-11 46.0 0.0 0.0 0.0 \n", "2011-12 36.0 0.0 0.0 0.0 \n", "2012-13 0.0 0.0 0.0 0.0 \n", "2013-14 0.0 0.0 0.0 0.0 \n", "2014-15 0.0 0.0 0.0 33.0 \n", "\n", "Team Cardiff City ... Southampton Stoke City Sunderland Swansea City \\\n", "Season ... \n", "2010-11 0.0 ... 0.0 46.0 47.0 0.0 \n", "2011-12 0.0 ... 0.0 45.0 45.0 47.0 \n", "2012-13 0.0 ... 41.0 42.0 39.0 46.0 \n", "2013-14 30.0 ... 56.0 50.0 38.0 42.0 \n", "2014-15 0.0 ... 60.0 54.0 38.0 56.0 \n", "\n", "Team Tottenham Hotspur Watford West Bromwich Albion West Ham United \\\n", "Season \n", "2010-11 62.0 0.0 47.0 33.0 \n", "2011-12 69.0 0.0 47.0 0.0 \n", "2012-13 72.0 0.0 49.0 46.0 \n", "2013-14 69.0 0.0 36.0 40.0 \n", "2014-15 64.0 0.0 44.0 47.0 \n", "\n", "Team Wigan Athletic Wolverhampton Wanderers \n", "Season \n", "2010-11 42.0 40.0 \n", "2011-12 43.0 25.0 \n", "2012-13 36.0 0.0 \n", "2013-14 0.0 0.0 \n", "2014-15 0.0 0.0 \n", "\n", "[5 rows x 37 columns]" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# NaN값 0으로 바꾸어 주기\n", "df.fillna(0,inplace=True)\n", "df.sort_values(list(df.columns), inplace=True)\n", "df = df.sort_index()\n", "df.head()" ] }, { "cell_type": "code", "execution_count": 6, "id": "9f1b4da5-3bcd-4ac5-84be-0c037e28742d", "metadata": {}, "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", " \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", " \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", "
TeamArsenalAston VillaBirmingham CityBlackburn RoversBlackpoolBolton WanderersBournemouthBrighton & Hove AlbionBurnleyCardiff City...SouthamptonStoke CitySunderlandSwansea CityTottenham HotspurWatfordWest Bromwich AlbionWest Ham UnitedWigan AthleticWolverhampton Wanderers
Season
2010-1168.048.039.043.039.046.00.00.00.00.0...0.046.047.00.062.00.047.033.042.040.0
2011-12138.086.039.074.039.082.00.00.00.00.0...0.091.092.047.0131.00.094.033.085.025.0
2012-13211.0127.039.074.039.082.00.00.00.00.0...41.0133.0131.093.0203.00.0143.079.0121.00.0
2013-14290.0165.039.074.039.082.00.00.00.030.0...97.0183.0169.0135.0272.00.0179.0119.0121.00.0
2014-15365.0203.039.074.039.082.00.00.033.030.0...157.0237.0207.0191.0336.00.0223.0166.0121.00.0
\n", "

5 rows × 37 columns

\n", "
" ], "text/plain": [ "Team Arsenal Aston Villa Birmingham City Blackburn Rovers Blackpool \\\n", "Season \n", "2010-11 68.0 48.0 39.0 43.0 39.0 \n", "2011-12 138.0 86.0 39.0 74.0 39.0 \n", "2012-13 211.0 127.0 39.0 74.0 39.0 \n", "2013-14 290.0 165.0 39.0 74.0 39.0 \n", "2014-15 365.0 203.0 39.0 74.0 39.0 \n", "\n", "Team Bolton Wanderers Bournemouth Brighton & Hove Albion Burnley \\\n", "Season \n", "2010-11 46.0 0.0 0.0 0.0 \n", "2011-12 82.0 0.0 0.0 0.0 \n", "2012-13 82.0 0.0 0.0 0.0 \n", "2013-14 82.0 0.0 0.0 0.0 \n", "2014-15 82.0 0.0 0.0 33.0 \n", "\n", "Team Cardiff City ... Southampton Stoke City Sunderland Swansea City \\\n", "Season ... \n", "2010-11 0.0 ... 0.0 46.0 47.0 0.0 \n", "2011-12 0.0 ... 0.0 91.0 92.0 47.0 \n", "2012-13 0.0 ... 41.0 133.0 131.0 93.0 \n", "2013-14 30.0 ... 97.0 183.0 169.0 135.0 \n", "2014-15 30.0 ... 157.0 237.0 207.0 191.0 \n", "\n", "Team Tottenham Hotspur Watford West Bromwich Albion West Ham United \\\n", "Season \n", "2010-11 62.0 0.0 47.0 33.0 \n", "2011-12 131.0 0.0 94.0 33.0 \n", "2012-13 203.0 0.0 143.0 79.0 \n", "2013-14 272.0 0.0 179.0 119.0 \n", "2014-15 336.0 0.0 223.0 166.0 \n", "\n", "Team Wigan Athletic Wolverhampton Wanderers \n", "Season \n", "2010-11 42.0 40.0 \n", "2011-12 85.0 25.0 \n", "2012-13 121.0 0.0 \n", "2013-14 121.0 0.0 \n", "2014-15 121.0 0.0 \n", "\n", "[5 rows x 37 columns]" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# 누적데이터로 각 축구팀의 데이터 값 바꾸기\n", "df.iloc[:,0:-1] = df.iloc[:, 0:-1].cumsum()\n", "df.head()" ] }, { "cell_type": "code", "execution_count": 8, "id": "edaa43c9-5b03-4b45-b80e-644b8688e2b7", "metadata": {}, "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", " \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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
TeamChelseaSwansea CityAston VillaLiverpoolSunderlandFulhamWest Ham UnitedNewcastle UnitedEvertonSouthamptonStoke CityWest Bromwich AlbionArsenalManchester UnitedManchester CityTottenham Hotspur
Season
2010-1171.00.048.058.047.049.033.046.054.00.046.047.068.080.071.062.0
2011-12135.047.086.0110.092.0101.033.0111.0110.00.091.094.0138.0169.0160.0131.0
2012-13210.093.0127.0171.0131.0144.079.0152.0173.041.0133.0143.0211.0258.0238.0203.0
2013-14292.0135.0165.0255.0169.0176.0119.0201.0245.097.0183.0179.0290.0322.0324.0272.0
2014-15379.0191.0203.0317.0207.0176.0166.0240.0292.0157.0237.0223.0365.0392.0403.0336.0
\n", "
" ], "text/plain": [ "Team Chelsea Swansea City Aston Villa Liverpool Sunderland Fulham \\\n", "Season \n", "2010-11 71.0 0.0 48.0 58.0 47.0 49.0 \n", "2011-12 135.0 47.0 86.0 110.0 92.0 101.0 \n", "2012-13 210.0 93.0 127.0 171.0 131.0 144.0 \n", "2013-14 292.0 135.0 165.0 255.0 169.0 176.0 \n", "2014-15 379.0 191.0 203.0 317.0 207.0 176.0 \n", "\n", "Team West Ham United Newcastle United Everton Southampton Stoke City \\\n", "Season \n", "2010-11 33.0 46.0 54.0 0.0 46.0 \n", "2011-12 33.0 111.0 110.0 0.0 91.0 \n", "2012-13 79.0 152.0 173.0 41.0 133.0 \n", "2013-14 119.0 201.0 245.0 97.0 183.0 \n", "2014-15 166.0 240.0 292.0 157.0 237.0 \n", "\n", "Team West Bromwich Albion Arsenal Manchester United Manchester City \\\n", "Season \n", "2010-11 47.0 68.0 80.0 71.0 \n", "2011-12 94.0 138.0 169.0 160.0 \n", "2012-13 143.0 211.0 258.0 238.0 \n", "2013-14 179.0 290.0 322.0 324.0 \n", "2014-15 223.0 365.0 392.0 403.0 \n", "\n", "Team Tottenham Hotspur \n", "Season \n", "2010-11 62.0 \n", "2011-12 131.0 \n", "2012-13 203.0 \n", "2013-14 272.0 \n", "2014-15 336.0 " ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# 37개의 클럽 중 시즌 별 top 10 클럽만 남기고 다른 데이터는 지우기\n", "top_10_clubs= set()\n", "for index, row in df.iterrows():\n", " top_10_clubs |= set(row[row>0].sort_values(ascending=False).head(10).index)\n", "\n", "df = df[top_10_clubs]\n", "df.head()" ] }, { "cell_type": "code", "execution_count": 23, "id": "e322fc03-20f1-44f8-a8dc-9fb0e42cdf52", "metadata": {}, "outputs": [ { "data": { "text/html": [ "" ], "text/plain": [ "" ] }, "execution_count": 23, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#bar chart race 그리기\n", "bcr.bar_chart_race(df = df,\n", " n_bars = 10,\n", " sort='desc',\n", " img_label_folder=\"bar_image_labels\",\n", " steps_per_period = 50,\n", " title = 'TOP 10 EPL clubs(2010-2021)') #)#'TOP 6 TEAM in PL(1992-2017)'\n", " #,filename = 'epl_10_clubs.mp4') #차트 레이스를 동영상으로 저장하고 싶을 때 사용" ] } ], "metadata": { "kernelspec": { "display_name": "Python 3 (ipykernel)", "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.8.8" } }, "nbformat": 4, "nbformat_minor": 5 }