{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(271116, 15)" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import pandas as pd\n", "import seaborn as sns\n", "\n", "df = pd.read_csv('athlete_events.csv')\n", "df.shape" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "male_df = df[df.Sex=='M']\n", "sport_weight_height_metrics = male_df.groupby(['Sport'])['Weight','Height'].agg(['min','max','mean'])" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | min | \n", "max | \n", "mean | \n", "
---|---|---|---|
Sport | \n", "\n", " | \n", " | \n", " |
Tug-Of-War | \n", "75.0 | \n", "118.0 | \n", "95.615385 | \n", "
Basketball | \n", "59.0 | \n", "156.0 | \n", "91.683529 | \n", "
Rugby Sevens | \n", "65.0 | \n", "113.0 | \n", "91.006623 | \n", "
Bobsleigh | \n", "55.0 | \n", "145.0 | \n", "90.387385 | \n", "
Beach Volleyball | \n", "62.0 | \n", "110.0 | \n", "89.512821 | \n", "
Handball | \n", "62.0 | \n", "132.0 | \n", "89.387914 | \n", "
Water Polo | \n", "61.0 | \n", "125.0 | \n", "87.706172 | \n", "
Volleyball | \n", "56.0 | \n", "120.0 | \n", "86.925926 | \n", "
Baseball | \n", "38.0 | \n", "120.0 | \n", "85.707792 | \n", "
Ice Hockey | \n", "52.0 | \n", "116.0 | \n", "83.775593 | \n", "
Rowing | \n", "37.0 | \n", "137.0 | \n", "83.665663 | \n", "
Judo | \n", "52.0 | \n", "214.0 | \n", "83.573945 | \n", "
Skeleton | \n", "65.0 | \n", "127.0 | \n", "82.018349 | \n", "
Curling | \n", "61.0 | \n", "105.0 | \n", "81.465686 | \n", "
Luge | \n", "52.0 | \n", "112.0 | \n", "80.803311 | \n", "
Weightlifting | \n", "50.0 | \n", "176.5 | \n", "80.251796 | \n", "
Canoeing | \n", "53.0 | \n", "115.0 | \n", "79.972378 | \n", "
Golf | \n", "63.0 | \n", "104.0 | \n", "79.245283 | \n", "
Sailing | \n", "50.0 | \n", "130.0 | \n", "78.849712 | \n", "
Tennis | \n", "59.0 | \n", "111.0 | \n", "78.842912 | \n", "
Alpine Skiing | \n", "50.0 | \n", "107.0 | \n", "78.626035 | \n", "
Swimming | \n", "45.0 | \n", "114.0 | \n", "78.040567 | \n", "
Shooting | \n", "41.0 | \n", "140.0 | \n", "77.834960 | \n", "
Rugby | \n", "68.0 | \n", "99.0 | \n", "77.533333 | \n", "
Archery | \n", "46.0 | \n", "130.0 | \n", "77.066866 | \n", "
Motorboating | \n", "77.0 | \n", "77.0 | \n", "77.000000 | \n", "
Snowboarding | \n", "50.0 | \n", "102.0 | \n", "76.861598 | \n", "
Lacrosse | \n", "60.0 | \n", "98.0 | \n", "76.714286 | \n", "
Wrestling | \n", "47.0 | \n", "190.0 | \n", "76.400640 | \n", "
Speed Skating | \n", "50.0 | \n", "100.0 | \n", "76.300403 | \n", "
Fencing | \n", "48.0 | \n", "108.0 | \n", "75.381977 | \n", "
Art Competitions | \n", "59.0 | \n", "93.0 | \n", "75.290909 | \n", "
Taekwondo | \n", "54.0 | \n", "110.0 | \n", "74.653595 | \n", "
Freestyle Skiing | \n", "47.0 | \n", "108.0 | \n", "74.648148 | \n", "
Badminton | \n", "55.0 | \n", "97.0 | \n", "74.362536 | \n", "
Athletics | \n", "42.0 | \n", "165.0 | \n", "73.839129 | \n", "
Hockey | \n", "48.0 | \n", "105.0 | \n", "73.343761 | \n", "
Football | \n", "28.0 | \n", "100.0 | \n", "73.086644 | \n", "
Biathlon | \n", "51.0 | \n", "95.0 | \n", "72.632123 | \n", "
Cycling | \n", "48.0 | \n", "104.0 | \n", "72.190234 | \n", "
Modern Pentathlon | \n", "56.0 | \n", "91.0 | \n", "72.068824 | \n", "
Cross Country Skiing | \n", "53.0 | \n", "100.0 | \n", "71.700832 | \n", "
Table Tennis | \n", "50.0 | \n", "99.0 | \n", "71.414239 | \n", "
Short Track Speed Skating | \n", "51.0 | \n", "86.0 | \n", "71.401869 | \n", "
Equestrianism | \n", "50.0 | \n", "100.0 | \n", "70.924559 | \n", "
Figure Skating | \n", "47.0 | \n", "90.0 | \n", "69.591644 | \n", "
Triathlon | \n", "54.0 | \n", "82.0 | \n", "68.803774 | \n", "
Diving | \n", "37.0 | \n", "91.0 | \n", "67.069378 | \n", "
Nordic Combined | \n", "53.0 | \n", "86.0 | \n", "66.909560 | \n", "
Trampolining | \n", "57.0 | \n", "84.0 | \n", "65.837838 | \n", "
Boxing | \n", "46.0 | \n", "140.0 | \n", "65.296280 | \n", "
Ski Jumping | \n", "50.0 | \n", "85.0 | \n", "65.245881 | \n", "
Gymnastics | \n", "46.0 | \n", "102.0 | \n", "63.343605 | \n", "