{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "pycharm": { "name": "#%%\n" } }, "outputs": [], "source": [ "# -- 将数据集命名为euro12\n", "# -- 只选取 Goals 这一列\n", "# -- 有多少球队参与了2012欧洲杯？\n", "# -- 该数据集中一共有多少列(columns)?\n", "# -- 将数据集中的列Team, Yellow Cards和Red Cards单独存为一个名叫discipline的数据框\n", "# -- 对数据框discipline按照先Red Cards再Yellow Cards进行排序\n", "# -- 计算每个球队拿到的黄牌数的平均值\n", "# -- 找到进球数Goals超过6的球队数据\n", "# -- 选取以字母G开头的球队数据\n", "# -- 选取前7列\n", "# -- 选取除了最后3列之外的全部列\n", "# -- 找到英格兰(England)、意大利(Italy)和俄罗斯(Russia)的射正率(Shooting Accuracy)" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "pycharm": { "name": "#%%\n" } }, "outputs": [], "source": [ "import pandas as pd\n", "#将数据集命名为euro12\n", "euro12 = pd.read_csv('data/Euro2012.csv')" ] }, { "cell_type": "code", "execution_count": 7, "metadata": { "pycharm": { "name": "#%%\n" } }, "outputs": [ { "data": { "text/plain": [ "16" ] }, "execution_count": 7, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#有多少球队参与了2012欧洲杯？\n", "euro12.Team.nunique()" ] }, { "cell_type": "code", "execution_count": 8, "metadata": { "pycharm": { "name": "#%%\n" } }, "outputs": [ { "data": { "text/plain": [ "35" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#该数据集中一共有多少列(columns)?\n", "euro12.shape[1]" ] }, { "cell_type": "code", "execution_count": 13, "metadata": { "pycharm": { "name": "#%%\n" } }, "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", "
TeamYellow CardsRed Cards
0Croatia90
1Czech Republic70
2Denmark40
3England50
4France60
5Germany40
6Greece91
7Italy160
8Netherlands50
9Poland71
10Portugal120
11Republic of Ireland61
12Russia60
13Spain110
14Sweden70
15Ukraine50
\n", "
" ], "text/plain": [ " Team Yellow Cards Red Cards\n", "0 Croatia 9 0\n", "1 Czech Republic 7 0\n", "2 Denmark 4 0\n", "3 England 5 0\n", "4 France 6 0\n", "5 Germany 4 0\n", "6 Greece 9 1\n", "7 Italy 16 0\n", "8 Netherlands 5 0\n", "9 Poland 7 1\n", "10 Portugal 12 0\n", "11 Republic of Ireland 6 1\n", "12 Russia 6 0\n", "13 Spain 11 0\n", "14 Sweden 7 0\n", "15 Ukraine 5 0" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#将数据集中的列Team, Yellow Cards和Red Cards单独存为一个名叫discipline的数据框\n", "discipline = euro12[['Team','Yellow Cards','Red Cards']]\n", "discipline" ] }, { "cell_type": "code", "execution_count": 16, "metadata": { "pycharm": { "name": "#%%\n" } }, "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", "
TeamYellow CardsRed Cards
6Greece91
9Poland71
11Republic of Ireland61
7Italy160
10Portugal120
13Spain110
0Croatia90
1Czech Republic70
14Sweden70
4France60
12Russia60
3England50
8Netherlands50
15Ukraine50
2Denmark40
5Germany40
\n", "
" ], "text/plain": [ " Team Yellow Cards Red Cards\n", "6 Greece 9 1\n", "9 Poland 7 1\n", "11 Republic of Ireland 6 1\n", "7 Italy 16 0\n", "10 Portugal 12 0\n", "13 Spain 11 0\n", "0 Croatia 9 0\n", "1 Czech Republic 7 0\n", "14 Sweden 7 0\n", "4 France 6 0\n", "12 Russia 6 0\n", "3 England 5 0\n", "8 Netherlands 5 0\n", "15 Ukraine 5 0\n", "2 Denmark 4 0\n", "5 Germany 4 0" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#对数据框discipline按照先Red Cards再Yellow Cards进行排序\n", "discipline.sort_values(['Red Cards','Yellow Cards'],ascending=False)" ] }, { "cell_type": "code", "execution_count": 20, "metadata": { "pycharm": { "name": "#%%\n" } }, "outputs": [ { "data": { "text/plain": [ "7.4375" ] }, "execution_count": 20, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#计算拿到的黄牌数的平均值\n", "euro12['Yellow Cards'].mean()" ] }, { "cell_type": "code", "execution_count": 21, "metadata": { "pycharm": { "name": "#%%\n" } }, "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", "
TeamGoalsShots on targetShots off targetShooting Accuracy% Goals-to-shotsTotal shots (inc. Blocked)Hit WoodworkPenalty goalsPenalties not scored...Saves madeSaves-to-shots ratioFouls WonFouls ConcededOffsidesYellow CardsRed CardsSubs onSubs offPlayers Used
5Germany10323247.8%15.6%80210...1062.6%63491240151517
13Spain12423355.9%16.0%100010...1593.8%1028319110171718
\n", "

2 rows × 35 columns

\n", "
" ], "text/plain": [ " Team Goals Shots on target Shots off target Shooting Accuracy \\\n", "5 Germany 10 32 32 47.8% \n", "13 Spain 12 42 33 55.9% \n", "\n", " % Goals-to-shots Total shots (inc. Blocked) Hit Woodwork Penalty goals \\\n", "5 15.6% 80 2 1 \n", "13 16.0% 100 0 1 \n", "\n", " Penalties not scored ... Saves made Saves-to-shots ratio Fouls Won \\\n", "5 0 ... 10 62.6% 63 \n", "13 0 ... 15 93.8% 102 \n", "\n", " Fouls Conceded Offsides Yellow Cards Red Cards Subs on Subs off \\\n", "5 49 12 4 0 15 15 \n", "13 83 19 11 0 17 17 \n", "\n", " Players Used \n", "5 17 \n", "13 18 \n", "\n", "[2 rows x 35 columns]" ] }, "execution_count": 21, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#找到进球数Goals超过6的球队数据\n", "euro12[euro12.Goals>6]" ] }, { "cell_type": "code", "execution_count": 22, "metadata": { "pycharm": { "name": "#%%\n" } }, "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", "
TeamGoalsShots on targetShots off targetShooting Accuracy% Goals-to-shotsTotal shots (inc. Blocked)Hit WoodworkPenalty goalsPenalties not scored...Saves madeSaves-to-shots ratioFouls WonFouls ConcededOffsidesYellow CardsRed CardsSubs onSubs offPlayers Used
5Germany10323247.8%15.6%80210...1062.6%63491240151517
6Greece581830.7%19.2%32111...1365.1%67481291121220
\n", "

2 rows × 35 columns

\n", "
" ], "text/plain": [ " Team Goals Shots on target Shots off target Shooting Accuracy \\\n", "5 Germany 10 32 32 47.8% \n", "6 Greece 5 8 18 30.7% \n", "\n", " % Goals-to-shots Total shots (inc. Blocked) Hit Woodwork Penalty goals \\\n", "5 15.6% 80 2 1 \n", "6 19.2% 32 1 1 \n", "\n", " Penalties not scored ... Saves made Saves-to-shots ratio Fouls Won \\\n", "5 0 ... 10 62.6% 63 \n", "6 1 ... 13 65.1% 67 \n", "\n", " Fouls Conceded Offsides Yellow Cards Red Cards Subs on Subs off \\\n", "5 49 12 4 0 15 15 \n", "6 48 12 9 1 12 12 \n", "\n", " Players Used \n", "5 17 \n", "6 20 \n", "\n", "[2 rows x 35 columns]" ] }, "execution_count": 22, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#选取以字母G开头的球队数据\n", "euro12[euro12.Team.str.startswith('G')]" ] }, { "cell_type": "code", "execution_count": 25, "metadata": { "pycharm": { "name": "#%%\n" } }, "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", " \n", " \n", "
TeamGoalsShots on targetShots off targetShooting Accuracy% Goals-to-shotsTotal shots (inc. Blocked)
0Croatia4131251.9%16.0%32
1Czech Republic4131841.9%12.9%39
2Denmark4101050.0%20.0%27
3England5111850.0%17.2%40
4France3222437.9%6.5%65
5Germany10323247.8%15.6%80
6Greece581830.7%19.2%32
7Italy6344543.0%7.5%110
8Netherlands2123625.0%4.1%60
9Poland2152339.4%5.2%48
10Portugal6224234.3%9.3%82
11Republic of Ireland171236.8%5.2%28
12Russia593122.5%12.5%59
13Spain12423355.9%16.0%100
14Sweden5171947.2%13.8%39
15Ukraine272621.2%6.0%38
\n", "
" ], "text/plain": [ " Team Goals Shots on target Shots off target \\\n", "0 Croatia 4 13 12 \n", "1 Czech Republic 4 13 18 \n", "2 Denmark 4 10 10 \n", "3 England 5 11 18 \n", "4 France 3 22 24 \n", "5 Germany 10 32 32 \n", "6 Greece 5 8 18 \n", "7 Italy 6 34 45 \n", "8 Netherlands 2 12 36 \n", "9 Poland 2 15 23 \n", "10 Portugal 6 22 42 \n", "11 Republic of Ireland 1 7 12 \n", "12 Russia 5 9 31 \n", "13 Spain 12 42 33 \n", "14 Sweden 5 17 19 \n", "15 Ukraine 2 7 26 \n", "\n", " Shooting Accuracy % Goals-to-shots Total shots (inc. Blocked) \n", "0 51.9% 16.0% 32 \n", "1 41.9% 12.9% 39 \n", "2 50.0% 20.0% 27 \n", "3 50.0% 17.2% 40 \n", "4 37.9% 6.5% 65 \n", "5 47.8% 15.6% 80 \n", "6 30.7% 19.2% 32 \n", "7 43.0% 7.5% 110 \n", "8 25.0% 4.1% 60 \n", "9 39.4% 5.2% 48 \n", "10 34.3% 9.3% 82 \n", "11 36.8% 5.2% 28 \n", "12 22.5% 12.5% 59 \n", "13 55.9% 16.0% 100 \n", "14 47.2% 13.8% 39 \n", "15 21.2% 6.0% 38 " ] }, "execution_count": 25, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#选取前7列\n", "euro12.iloc[:,0:7]" ] }, { "cell_type": "code", "execution_count": 26, "metadata": { "pycharm": { "name": "#%%\n" } }, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
TeamGoalsShots on targetShots off targetShooting Accuracy% Goals-to-shotsTotal shots (inc. Blocked)Hit WoodworkPenalty goalsPenalties not scored...Clean SheetsBlocksGoals concededSaves madeSaves-to-shots ratioFouls WonFouls ConcededOffsidesYellow CardsRed Cards
0Croatia4131251.9%16.0%32000...01031381.3%4162290
1Czech Republic4131841.9%12.9%39000...1106960.1%5373870
2Denmark4101050.0%20.0%27100...11051066.7%2538840
3England5111850.0%17.2%40000...22932288.1%4345650
4France3222437.9%6.5%65100...175654.6%3651560
5Germany10323247.8%15.6%80210...11161062.6%63491240
6Greece581830.7%19.2%32111...12371365.1%67481291
7Italy6344543.0%7.5%110200...21872074.1%1018916160
8Netherlands2123625.0%4.1%60200...0951270.6%3530350
9Poland2152339.4%5.2%48000...083666.7%4856371
10Portugal6224234.3%9.3%82600...21141071.5%739010120
11Republic of Ireland171236.8%5.2%28000...02391765.4%43511161
12Russia593122.5%12.5%59200...0831077.0%3443460
13Spain12423355.9%16.0%100010...5811593.8%1028319110
14Sweden5171947.2%13.8%39300...1125861.6%3551770
15Ukraine272621.2%6.0%38000...0441376.5%4831450
\n", "

16 rows × 32 columns

\n", "
" ], "text/plain": [ " Team Goals Shots on target Shots off target \\\n", "0 Croatia 4 13 12 \n", "1 Czech Republic 4 13 18 \n", "2 Denmark 4 10 10 \n", "3 England 5 11 18 \n", "4 France 3 22 24 \n", "5 Germany 10 32 32 \n", "6 Greece 5 8 18 \n", "7 Italy 6 34 45 \n", "8 Netherlands 2 12 36 \n", "9 Poland 2 15 23 \n", "10 Portugal 6 22 42 \n", "11 Republic of Ireland 1 7 12 \n", "12 Russia 5 9 31 \n", "13 Spain 12 42 33 \n", "14 Sweden 5 17 19 \n", "15 Ukraine 2 7 26 \n", "\n", " Shooting Accuracy % Goals-to-shots Total shots (inc. Blocked) \\\n", "0 51.9% 16.0% 32 \n", "1 41.9% 12.9% 39 \n", "2 50.0% 20.0% 27 \n", "3 50.0% 17.2% 40 \n", "4 37.9% 6.5% 65 \n", "5 47.8% 15.6% 80 \n", "6 30.7% 19.2% 32 \n", "7 43.0% 7.5% 110 \n", "8 25.0% 4.1% 60 \n", "9 39.4% 5.2% 48 \n", "10 34.3% 9.3% 82 \n", "11 36.8% 5.2% 28 \n", "12 22.5% 12.5% 59 \n", "13 55.9% 16.0% 100 \n", "14 47.2% 13.8% 39 \n", "15 21.2% 6.0% 38 \n", "\n", " Hit Woodwork Penalty goals Penalties not scored ... Clean Sheets \\\n", "0 0 0 0 ... 0 \n", "1 0 0 0 ... 1 \n", "2 1 0 0 ... 1 \n", "3 0 0 0 ... 2 \n", "4 1 0 0 ... 1 \n", "5 2 1 0 ... 1 \n", "6 1 1 1 ... 1 \n", "7 2 0 0 ... 2 \n", "8 2 0 0 ... 0 \n", "9 0 0 0 ... 0 \n", "10 6 0 0 ... 2 \n", "11 0 0 0 ... 0 \n", "12 2 0 0 ... 0 \n", "13 0 1 0 ... 5 \n", "14 3 0 0 ... 1 \n", "15 0 0 0 ... 0 \n", "\n", " Blocks Goals conceded Saves made Saves-to-shots ratio Fouls Won \\\n", "0 10 3 13 81.3% 41 \n", "1 10 6 9 60.1% 53 \n", "2 10 5 10 66.7% 25 \n", "3 29 3 22 88.1% 43 \n", "4 7 5 6 54.6% 36 \n", "5 11 6 10 62.6% 63 \n", "6 23 7 13 65.1% 67 \n", "7 18 7 20 74.1% 101 \n", "8 9 5 12 70.6% 35 \n", "9 8 3 6 66.7% 48 \n", "10 11 4 10 71.5% 73 \n", "11 23 9 17 65.4% 43 \n", "12 8 3 10 77.0% 34 \n", "13 8 1 15 93.8% 102 \n", "14 12 5 8 61.6% 35 \n", "15 4 4 13 76.5% 48 \n", "\n", " Fouls Conceded Offsides Yellow Cards Red Cards \n", "0 62 2 9 0 \n", "1 73 8 7 0 \n", "2 38 8 4 0 \n", "3 45 6 5 0 \n", "4 51 5 6 0 \n", "5 49 12 4 0 \n", "6 48 12 9 1 \n", "7 89 16 16 0 \n", "8 30 3 5 0 \n", "9 56 3 7 1 \n", "10 90 10 12 0 \n", "11 51 11 6 1 \n", "12 43 4 6 0 \n", "13 83 19 11 0 \n", "14 51 7 7 0 \n", "15 31 4 5 0 \n", "\n", "[16 rows x 32 columns]" ] }, "execution_count": 26, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#选取除了最后3列之外的全部列\n", "euro12.iloc[:,0:-3]" ] }, { "cell_type": "code", "execution_count": 38, "metadata": { "pycharm": { "name": "#%%\n" } }, "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", "
TeamShooting Accuracy
3England50.0%
7Italy43.0%
12Russia22.5%
\n", "
" ], "text/plain": [ " Team Shooting Accuracy\n", "3 England 50.0%\n", "7 Italy 43.0%\n", "12 Russia 22.5%" ] }, "execution_count": 38, "metadata": {}, "output_type": "execute_result" } ], "source": [ "#找到英格兰(England)、意大利(Italy)和俄罗斯(Russia)的射正率(Shooting Accuracy)\n", "euro12.loc[euro12['Team'].isin(['England','Italy','Russia']),['Team','Shooting Accuracy']]\n", "\n", "# euro12.loc[euro12['Team'].isin(['England','Italy','Russia']),'Shooting Accuracy']" ] } ], "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.1" } }, "nbformat": 4, "nbformat_minor": 4 }