{ "cells": [ { "cell_type": "code", "execution_count": 37, "id": "b727536f", "metadata": {}, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 38, "id": "5e9aaf4c", "metadata": {}, "outputs": [], "source": [ "nhl= pd.read_csv('nhl.csv')" ] }, { "cell_type": "code", "execution_count": 39, "id": "7cb21c8e", "metadata": {}, "outputs": [], "source": [ "wiki= pd.read_csv('cities.csv', skiprows=1)" ] }, { "cell_type": "code", "execution_count": 40, "id": "0a27c236", "metadata": {}, "outputs": [], "source": [ "wiki=wiki[['Population\\n(2016 est.)[8]', 'Metropolitan area','NHL']]" ] }, { "cell_type": "code", "execution_count": 41, "id": "b14b101d", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "0" ] }, "execution_count": 41, "metadata": {}, "output_type": "execute_result" } ], "source": [ "nhl.team.isna().sum()" ] }, { "cell_type": "code", "execution_count": 42, "id": "79d3ef0e", "metadata": {}, "outputs": [], "source": [ "import re\n", "import math\n", "import numpy as np" ] }, { "cell_type": "code", "execution_count": 45, "id": "20db5958", "metadata": {}, "outputs": [], "source": [ "for i, nhl in enumerate(wiki.NHL):\n", " w=nhl\n", " if '\\n' in nhl:\n", " w=(re.sub( \"\\n\", ' ', nhl))\n", " elif \"—\" in nhl:\n", " w=(re.sub( \"—\", 'NaN', nhl))\n", " wiki.NHL[i]=w\n" ] }, { "cell_type": "code", "execution_count": 46, "id": "c4a2ae07", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "0" ] }, "execution_count": 46, "metadata": {}, "output_type": "execute_result" } ], "source": [ "wiki.NHL.isna().sum()" ] }, { "cell_type": "code", "execution_count": 47, "id": "4c25c0f5", "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Population\\n(2016 est.)[8]Metropolitan areaNHL
020,153,634New York CityRangers Islanders Devils[note 3]
113,310,447Los AngelesKings Ducks
26,657,982San Francisco Bay AreaSharks[note 7]
39,512,999ChicagoBlackhawks
47,233,323Dallas–Fort WorthStars
56,131,977Washington, D.C.Capitals
66,070,500PhiladelphiaFlyers[note 13]
74,794,447BostonBruins
83,551,036Minneapolis–Saint PaulWild[note 16]
92,853,077DenverAvalanche[note 18]
106,066,387Miami–Fort LauderdalePanthers
114,661,537PhoenixCoyotes
124,297,617DetroitRed Wings
135,928,040TorontoMaple Leafs
146,772,470HoustonNaN
155,789,700Atlanta[note 25]
163,032,171Tampa Bay AreaLightning
172,342,299PittsburghPenguins[note 28]
182,055,612Cleveland[note 32]
193,798,902Seattle[note 34]
202,165,139CincinnatiNaN
212,104,509Kansas City[note 39]
222,807,002St. LouisBlues[note 43]
232,798,886BaltimoreNaN
242,474,314CharlotteNaN
252,004,230IndianapolisNaN
261,865,298NashvillePredators
271,572,482MilwaukeeNaN
281,268,883New OrleansNaN
291,132,804BuffaloSabres
304,098,927MontrealCanadiens
312,463,431VancouverCanucks
322,441,257OrlandoNaN
332,424,955PortlandNaN
342,041,520ColumbusBlue Jackets
351,392,609CalgaryFlames
361,323,783OttawaSenators
371,321,426EdmontonOilers
381,186,187Salt Lake CityNaN
39778,489WinnipegJets[note 61]
403,317,749San DiegoNaN
412,429,609San AntonioNaN
422,296,418SacramentoNaN
432,155,664Las VegasGolden Knights
441,478,212JacksonvilleNaN
451,373,211Oklahoma CityNaN
461,342,842MemphisNaN
471,302,946RaleighHurricanes
48318,236Green BayNaN
49747,545Hamilton[note 71]
50236,481ReginaNaN
51–Totals31
\n", "
" ], "text/plain": [ " Population\\n(2016 est.)[8] Metropolitan area \\\n", "0 20,153,634 New York City \n", "1 13,310,447 Los Angeles \n", "2 6,657,982 San Francisco Bay Area \n", "3 9,512,999 Chicago \n", "4 7,233,323 Dallas–Fort Worth \n", "5 6,131,977 Washington, D.C. \n", "6 6,070,500 Philadelphia \n", "7 4,794,447 Boston \n", "8 3,551,036 Minneapolis–Saint Paul \n", "9 2,853,077 Denver \n", "10 6,066,387 Miami–Fort Lauderdale \n", "11 4,661,537 Phoenix \n", "12 4,297,617 Detroit \n", "13 5,928,040 Toronto \n", "14 6,772,470 Houston \n", "15 5,789,700 Atlanta \n", "16 3,032,171 Tampa Bay Area \n", "17 2,342,299 Pittsburgh \n", "18 2,055,612 Cleveland \n", "19 3,798,902 Seattle \n", "20 2,165,139 Cincinnati \n", "21 2,104,509 Kansas City \n", "22 2,807,002 St. Louis \n", "23 2,798,886 Baltimore \n", "24 2,474,314 Charlotte \n", "25 2,004,230 Indianapolis \n", "26 1,865,298 Nashville \n", "27 1,572,482 Milwaukee \n", "28 1,268,883 New Orleans \n", "29 1,132,804 Buffalo \n", "30 4,098,927 Montreal \n", "31 2,463,431 Vancouver \n", "32 2,441,257 Orlando \n", "33 2,424,955 Portland \n", "34 2,041,520 Columbus \n", "35 1,392,609 Calgary \n", "36 1,323,783 Ottawa \n", "37 1,321,426 Edmonton \n", "38 1,186,187 Salt Lake City \n", "39 778,489 Winnipeg \n", "40 3,317,749 San Diego \n", "41 2,429,609 San Antonio \n", "42 2,296,418 Sacramento \n", "43 2,155,664 Las Vegas \n", "44 1,478,212 Jacksonville \n", "45 1,373,211 Oklahoma City \n", "46 1,342,842 Memphis \n", "47 1,302,946 Raleigh \n", "48 318,236 Green Bay \n", "49 747,545 Hamilton \n", "50 236,481 Regina \n", "51 – Totals \n", "\n", " NHL \n", "0 Rangers Islanders Devils[note 3] \n", "1 Kings Ducks \n", "2 Sharks[note 7] \n", "3 Blackhawks \n", "4 Stars \n", "5 Capitals \n", "6 Flyers[note 13] \n", "7 Bruins \n", "8 Wild[note 16] \n", "9 Avalanche[note 18] \n", "10 Panthers \n", "11 Coyotes \n", "12 Red Wings \n", "13 Maple Leafs \n", "14 NaN \n", "15 [note 25] \n", "16 Lightning \n", "17 Penguins[note 28] \n", "18 [note 32] \n", "19 [note 34] \n", "20 NaN \n", "21 [note 39] \n", "22 Blues[note 43] \n", "23 NaN \n", "24 NaN \n", "25 NaN \n", "26 Predators \n", "27 NaN \n", "28 NaN \n", "29 Sabres \n", "30 Canadiens \n", "31 Canucks \n", "32 NaN \n", "33 NaN \n", "34 Blue Jackets \n", "35 Flames \n", "36 Senators \n", "37 Oilers \n", "38 NaN \n", "39 Jets[note 61] \n", "40 NaN \n", "41 NaN \n", "42 NaN \n", "43 Golden Knights \n", "44 NaN \n", "45 NaN \n", "46 NaN \n", "47 Hurricanes \n", "48 NaN \n", "49 [note 71] \n", "50 NaN \n", "51 31 " ] }, "execution_count": 47, "metadata": {}, "output_type": "execute_result" } ], "source": [ "wiki" ] }, { "cell_type": "code", "execution_count": null, "id": "c140f59c", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "9eb2f4d7", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "a9cd21e8", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "6760383a", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "58f5013b", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "adc69220", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "d3e634fb", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "ac515498", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "38ee3b29", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "d230e386", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "e1d5631b", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "c22fc171", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "7361f1a7", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "705ce2d4", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "41ae0bd0", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "c5dc9fb3", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "a6ff2df7", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "2bdb9b59", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "efa933f4", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "f5e4455c", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "93647b7d", "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "id": "4b26e4ff", "metadata": {}, "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.8.8" } }, "nbformat": 4, "nbformat_minor": 5 }