Format: application/octet-stream
1 {
2 "cells": [
3 {
4 "cell_type": "code",
5 "execution_count": 37,
6 "id": "b727536f",
7 "metadata": {},
8 "outputs": [],
9 "source": [
10 "import pandas as pd"
11 ]
12 },
13 {
14 "cell_type": "code",
15 "execution_count": 38,
16 "id": "5e9aaf4c",
17 "metadata": {},
18 "outputs": [],
19 "source": [
20 "nhl= pd.read_csv('nhl.csv')"
21 ]
22 },
23 {
24 "cell_type": "code",
25 "execution_count": 39,
26 "id": "7cb21c8e",
27 "metadata": {},
28 "outputs": [],
29 "source": [
30 "wiki= pd.read_csv('cities.csv', skiprows=1)"
31 ]
32 },
33 {
34 "cell_type": "code",
35 "execution_count": 40,
36 "id": "0a27c236",
37 "metadata": {},
38 "outputs": [],
39 "source": [
40 "wiki=wiki[['Population\\n(2016 est.)[8]', 'Metropolitan area','NHL']]"
41 ]
42 },
43 {
44 "cell_type": "code",
45 "execution_count": 41,
46 "id": "b14b101d",
47 "metadata": {},
48 "outputs": [
49 {
50 "data": {
51 "text/plain": [
52 "0"
53 ]
54 },
55 "execution_count": 41,
56 "metadata": {},
57 "output_type": "execute_result"
58 }
59 ],
60 "source": [
61 "nhl.team.isna().sum()"
62 ]
63 },
64 {
65 "cell_type": "code",
66 "execution_count": 42,
67 "id": "79d3ef0e",
68 "metadata": {},
69 "outputs": [],
70 "source": [
71 "import re\n",
72 "import math\n",
73 "import numpy as np"
74 ]
75 },
76 {
77 "cell_type": "code",
78 "execution_count": 45,
79 "id": "20db5958",
80 "metadata": {},
81 "outputs": [],
82 "source": [
83 "for i, nhl in enumerate(wiki.NHL):\n",
84 " w=nhl\n",
85 " if '\\n' in nhl:\n",
86 " w=(re.sub( \"\\n\", ' ', nhl))\n",
87 " elif \"ā\" in nhl:\n",
88 " w=(re.sub( \"ā\", 'NaN', nhl))\n",
89 " wiki.NHL[i]=w\n"
90 ]
91 },
92 {
93 "cell_type": "code",
94 "execution_count": 46,
95 "id": "c4a2ae07",
96 "metadata": {},
97 "outputs": [
98 {
99 "data": {
100 "text/plain": [
101 "0"
102 ]
103 },
104 "execution_count": 46,
105 "metadata": {},
106 "output_type": "execute_result"
107 }
108 ],
109 "source": [
110 "wiki.NHL.isna().sum()"
111 ]
112 },
113 {
114 "cell_type": "code",
115 "execution_count": 47,
116 "id": "4c25c0f5",
117 "metadata": {},
118 "outputs": [
119 {
120 "data": {
121 "text/html": [
122 "<div>\n",
123 "<style scoped>\n",
124 " .dataframe tbody tr th:only-of-type {\n",
125 " vertical-align: middle;\n",
126 " }\n",
127 "\n",
128 " .dataframe tbody tr th {\n",
129 " vertical-align: top;\n",
130 " }\n",
131 "\n",
132 " .dataframe thead th {\n",
133 " text-align: right;\n",
134 " }\n",
135 "</style>\n",
136 "<table border=\"1\" class=\"dataframe\">\n",
137 " <thead>\n",
138 " <tr style=\"text-align: right;\">\n",
139 " <th></th>\n",
140 " <th>Population\\n(2016 est.)[8]</th>\n",
141 " <th>Metropolitan area</th>\n",
142 " <th>NHL</th>\n",
143 " </tr>\n",
144 " </thead>\n",
145 " <tbody>\n",
146 " <tr>\n",
147 " <th>0</th>\n",
148 " <td>20,153,634</td>\n",
149 " <td>New York City</td>\n",
150 " <td>Rangers Islanders Devils[note 3]</td>\n",
151 " </tr>\n",
152 " <tr>\n",
153 " <th>1</th>\n",
154 " <td>13,310,447</td>\n",
155 " <td>Los Angeles</td>\n",
156 " <td>Kings Ducks</td>\n",
157 " </tr>\n",
158 " <tr>\n",
159 " <th>2</th>\n",
160 " <td>6,657,982</td>\n",
161 " <td>San Francisco Bay Area</td>\n",
162 " <td>Sharks[note 7]</td>\n",
163 " </tr>\n",
164 " <tr>\n",
165 " <th>3</th>\n",
166 " <td>9,512,999</td>\n",
167 " <td>Chicago</td>\n",
168 " <td>Blackhawks</td>\n",
169 " </tr>\n",
170 " <tr>\n",
171 " <th>4</th>\n",
172 " <td>7,233,323</td>\n",
173 " <td>DallasāFort Worth</td>\n",
174 " <td>Stars</td>\n",
175 " </tr>\n",
176 " <tr>\n",
177 " <th>5</th>\n",
178 " <td>6,131,977</td>\n",
179 " <td>Washington, D.C.</td>\n",
180 " <td>Capitals</td>\n",
181 " </tr>\n",
182 " <tr>\n",
183 " <th>6</th>\n",
184 " <td>6,070,500</td>\n",
185 " <td>Philadelphia</td>\n",
186 " <td>Flyers[note 13]</td>\n",
187 " </tr>\n",
188 " <tr>\n",
189 " <th>7</th>\n",
190 " <td>4,794,447</td>\n",
191 " <td>Boston</td>\n",
192 " <td>Bruins</td>\n",
193 " </tr>\n",
194 " <tr>\n",
195 " <th>8</th>\n",
196 " <td>3,551,036</td>\n",
197 " <td>MinneapolisāSaint Paul</td>\n",
198 " <td>Wild[note 16]</td>\n",
199 " </tr>\n",
200 " <tr>\n",
201 " <th>9</th>\n",
202 " <td>2,853,077</td>\n",
203 " <td>Denver</td>\n",
204 " <td>Avalanche[note 18]</td>\n",
205 " </tr>\n",
206 " <tr>\n",
207 " <th>10</th>\n",
208 " <td>6,066,387</td>\n",
209 " <td>MiamiāFort Lauderdale</td>\n",
210 " <td>Panthers</td>\n",
211 " </tr>\n",
212 " <tr>\n",
213 " <th>11</th>\n",
214 " <td>4,661,537</td>\n",
215 " <td>Phoenix</td>\n",
216 " <td>Coyotes</td>\n",
217 " </tr>\n",
218 " <tr>\n",
219 " <th>12</th>\n",
220 " <td>4,297,617</td>\n",
221 " <td>Detroit</td>\n",
222 " <td>Red Wings</td>\n",
223 " </tr>\n",
224 " <tr>\n",
225 " <th>13</th>\n",
226 " <td>5,928,040</td>\n",
227 " <td>Toronto</td>\n",
228 " <td>Maple Leafs</td>\n",
229 " </tr>\n",
230 " <tr>\n",
231 " <th>14</th>\n",
232 " <td>6,772,470</td>\n",
233 " <td>Houston</td>\n",
234 " <td>NaN</td>\n",
235 " </tr>\n",
236 " <tr>\n",
237 " <th>15</th>\n",
238 " <td>5,789,700</td>\n",
239 " <td>Atlanta</td>\n",
240 " <td>[note 25]</td>\n",
241 " </tr>\n",
242 " <tr>\n",
243 " <th>16</th>\n",
244 " <td>3,032,171</td>\n",
245 " <td>Tampa Bay Area</td>\n",
246 " <td>Lightning</td>\n",
247 " </tr>\n",
248 " <tr>\n",
249 " <th>17</th>\n",
250 " <td>2,342,299</td>\n",
251 " <td>Pittsburgh</td>\n",
252 " <td>Penguins[note 28]</td>\n",
253 " </tr>\n",
254 " <tr>\n",
255 " <th>18</th>\n",
256 " <td>2,055,612</td>\n",
257 " <td>Cleveland</td>\n",
258 " <td>[note 32]</td>\n",
259 " </tr>\n",
260 " <tr>\n",
261 " <th>19</th>\n",
262 " <td>3,798,902</td>\n",
263 " <td>Seattle</td>\n",
264 " <td>[note 34]</td>\n",
265 " </tr>\n",
266 " <tr>\n",
267 " <th>20</th>\n",
268 " <td>2,165,139</td>\n",
269 " <td>Cincinnati</td>\n",
270 " <td>NaN</td>\n",
271 " </tr>\n",
272 " <tr>\n",
273 " <th>21</th>\n",
274 " <td>2,104,509</td>\n",
275 " <td>Kansas City</td>\n",
276 " <td>[note 39]</td>\n",
277 " </tr>\n",
278 " <tr>\n",
279 " <th>22</th>\n",
280 " <td>2,807,002</td>\n",
281 " <td>St. Louis</td>\n",
282 " <td>Blues[note 43]</td>\n",
283 " </tr>\n",
284 " <tr>\n",
285 " <th>23</th>\n",
286 " <td>2,798,886</td>\n",
287 " <td>Baltimore</td>\n",
288 " <td>NaN</td>\n",
289 " </tr>\n",
290 " <tr>\n",
291 " <th>24</th>\n",
292 " <td>2,474,314</td>\n",
293 " <td>Charlotte</td>\n",
294 " <td>NaN</td>\n",
295 " </tr>\n",
296 " <tr>\n",
297 " <th>25</th>\n",
298 " <td>2,004,230</td>\n",
299 " <td>Indianapolis</td>\n",
300 " <td>NaN</td>\n",
301 " </tr>\n",
302 " <tr>\n",
303 " <th>26</th>\n",
304 " <td>1,865,298</td>\n",
305 " <td>Nashville</td>\n",
306 " <td>Predators</td>\n",
307 " </tr>\n",
308 " <tr>\n",
309 " <th>27</th>\n",
310 " <td>1,572,482</td>\n",
311 " <td>Milwaukee</td>\n",
312 " <td>NaN</td>\n",
313 " </tr>\n",
314 " <tr>\n",
315 " <th>28</th>\n",
316 " <td>1,268,883</td>\n",
317 " <td>New Orleans</td>\n",
318 " <td>NaN</td>\n",
319 " </tr>\n",
320 " <tr>\n",
321 " <th>29</th>\n",
322 " <td>1,132,804</td>\n",
323 " <td>Buffalo</td>\n",
324 " <td>Sabres</td>\n",
325 " </tr>\n",
326 " <tr>\n",
327 " <th>30</th>\n",
328 " <td>4,098,927</td>\n",
329 " <td>Montreal</td>\n",
330 " <td>Canadiens</td>\n",
331 " </tr>\n",
332 " <tr>\n",
333 " <th>31</th>\n",
334 " <td>2,463,431</td>\n",
335 " <td>Vancouver</td>\n",
336 " <td>Canucks</td>\n",
337 " </tr>\n",
338 " <tr>\n",
339 " <th>32</th>\n",
340 " <td>2,441,257</td>\n",
341 " <td>Orlando</td>\n",
342 " <td>NaN</td>\n",
343 " </tr>\n",
344 " <tr>\n",
345 " <th>33</th>\n",
346 " <td>2,424,955</td>\n",
347 " <td>Portland</td>\n",
348 " <td>NaN</td>\n",
349 " </tr>\n",
350 " <tr>\n",
351 " <th>34</th>\n",
352 " <td>2,041,520</td>\n",
353 " <td>Columbus</td>\n",
354 " <td>Blue Jackets</td>\n",
355 " </tr>\n",
356 " <tr>\n",
357 " <th>35</th>\n",
358 " <td>1,392,609</td>\n",
359 " <td>Calgary</td>\n",
360 " <td>Flames</td>\n",
361 " </tr>\n",
362 " <tr>\n",
363 " <th>36</th>\n",
364 " <td>1,323,783</td>\n",
365 " <td>Ottawa</td>\n",
366 " <td>Senators</td>\n",
367 " </tr>\n",
368 " <tr>\n",
369 " <th>37</th>\n",
370 " <td>1,321,426</td>\n",
371 " <td>Edmonton</td>\n",
372 " <td>Oilers</td>\n",
373 " </tr>\n",
374 " <tr>\n",
375 " <th>38</th>\n",
376 " <td>1,186,187</td>\n",
377 " <td>Salt Lake City</td>\n",
378 " <td>NaN</td>\n",
379 " </tr>\n",
380 " <tr>\n",
381 " <th>39</th>\n",
382 " <td>778,489</td>\n",
383 " <td>Winnipeg</td>\n",
384 " <td>Jets[note 61]</td>\n",
385 " </tr>\n",
386 " <tr>\n",
387 " <th>40</th>\n",
388 " <td>3,317,749</td>\n",
389 " <td>San Diego</td>\n",
390 " <td>NaN</td>\n",
391 " </tr>\n",
392 " <tr>\n",
393 " <th>41</th>\n",
394 " <td>2,429,609</td>\n",
395 " <td>San Antonio</td>\n",
396 " <td>NaN</td>\n",
397 " </tr>\n",
398 " <tr>\n",
399 " <th>42</th>\n",
400 " <td>2,296,418</td>\n",
401 " <td>Sacramento</td>\n",
402 " <td>NaN</td>\n",
403 " </tr>\n",
404 " <tr>\n",
405 " <th>43</th>\n",
406 " <td>2,155,664</td>\n",
407 " <td>Las Vegas</td>\n",
408 " <td>Golden Knights</td>\n",
409 " </tr>\n",
410 " <tr>\n",
411 " <th>44</th>\n",
412 " <td>1,478,212</td>\n",
413 " <td>Jacksonville</td>\n",
414 " <td>NaN</td>\n",
415 " </tr>\n",
416 " <tr>\n",
417 " <th>45</th>\n",
418 " <td>1,373,211</td>\n",
419 " <td>Oklahoma City</td>\n",
420 " <td>NaN</td>\n",
421 " </tr>\n",
422 " <tr>\n",
423 " <th>46</th>\n",
424 " <td>1,342,842</td>\n",
425 " <td>Memphis</td>\n",
426 " <td>NaN</td>\n",
427 " </tr>\n",
428 " <tr>\n",
429 " <th>47</th>\n",
430 " <td>1,302,946</td>\n",
431 " <td>Raleigh</td>\n",
432 " <td>Hurricanes</td>\n",
433 " </tr>\n",
434 " <tr>\n",
435 " <th>48</th>\n",
436 " <td>318,236</td>\n",
437 " <td>Green Bay</td>\n",
438 " <td>NaN</td>\n",
439 " </tr>\n",
440 " <tr>\n",
441 " <th>49</th>\n",
442 " <td>747,545</td>\n",
443 " <td>Hamilton</td>\n",
444 " <td>[note 71]</td>\n",
445 " </tr>\n",
446 " <tr>\n",
447 " <th>50</th>\n",
448 " <td>236,481</td>\n",
449 " <td>Regina</td>\n",
450 " <td>NaN</td>\n",
451 " </tr>\n",
452 " <tr>\n",
453 " <th>51</th>\n",
454 " <td>ā</td>\n",
455 " <td>Totals</td>\n",
456 " <td>31</td>\n",
457 " </tr>\n",
458 " </tbody>\n",
459 "</table>\n",
460 "</div>"
461 ],
462 "text/plain": [
463 " Population\\n(2016 est.)[8] Metropolitan area \\\n",
464 "0 20,153,634 New York City \n",
465 "1 13,310,447 Los Angeles \n",
466 "2 6,657,982 San Francisco Bay Area \n",
467 "3 9,512,999 Chicago \n",
468 "4 7,233,323 DallasāFort Worth \n",
469 "5 6,131,977 Washington, D.C. \n",
470 "6 6,070,500 Philadelphia \n",
471 "7 4,794,447 Boston \n",
472 "8 3,551,036 MinneapolisāSaint Paul \n",
473 "9 2,853,077 Denver \n",
474 "10 6,066,387 MiamiāFort Lauderdale \n",
475 "11 4,661,537 Phoenix \n",
476 "12 4,297,617 Detroit \n",
477 "13 5,928,040 Toronto \n",
478 "14 6,772,470 Houston \n",
479 "15 5,789,700 Atlanta \n",
480 "16 3,032,171 Tampa Bay Area \n",
481 "17 2,342,299 Pittsburgh \n",
482 "18 2,055,612 Cleveland \n",
483 "19 3,798,902 Seattle \n",
484 "20 2,165,139 Cincinnati \n",
485 "21 2,104,509 Kansas City \n",
486 "22 2,807,002 St. Louis \n",
487 "23 2,798,886 Baltimore \n",
488 "24 2,474,314 Charlotte \n",
489 "25 2,004,230 Indianapolis \n",
490 "26 1,865,298 Nashville \n",
491 "27 1,572,482 Milwaukee \n",
492 "28 1,268,883 New Orleans \n",
493 "29 1,132,804 Buffalo \n",
494 "30 4,098,927 Montreal \n",
495 "31 2,463,431 Vancouver \n",
496 "32 2,441,257 Orlando \n",
497 "33 2,424,955 Portland \n",
498 "34 2,041,520 Columbus \n",
499 "35 1,392,609 Calgary \n",
500 "36 1,323,783 Ottawa \n",
501 "37 1,321,426 Edmonton \n",
502 "38 1,186,187 Salt Lake City \n",
503 "39 778,489 Winnipeg \n",
504 "40 3,317,749 San Diego \n",
505 "41 2,429,609 San Antonio \n",
506 "42 2,296,418 Sacramento \n",
507 "43 2,155,664 Las Vegas \n",
508 "44 1,478,212 Jacksonville \n",
509 "45 1,373,211 Oklahoma City \n",
510 "46 1,342,842 Memphis \n",
511 "47 1,302,946 Raleigh \n",
512 "48 318,236 Green Bay \n",
513 "49 747,545 Hamilton \n",
514 "50 236,481 Regina \n",
515 "51 ā Totals \n",
516 "\n",
517 " NHL \n",
518 "0 Rangers Islanders Devils[note 3] \n",
519 "1 Kings Ducks \n",
520 "2 Sharks[note 7] \n",
521 "3 Blackhawks \n",
522 "4 Stars \n",
523 "5 Capitals \n",
524 "6 Flyers[note 13] \n",
525 "7 Bruins \n",
526 "8 Wild[note 16] \n",
527 "9 Avalanche[note 18] \n",
528 "10 Panthers \n",
529 "11 Coyotes \n",
530 "12 Red Wings \n",
531 "13 Maple Leafs \n",
532 "14 NaN \n",
533 "15 [note 25] \n",
534 "16 Lightning \n",
535 "17 Penguins[note 28] \n",
536 "18 [note 32] \n",
537 "19 [note 34] \n",
538 "20 NaN \n",
539 "21 [note 39] \n",
540 "22 Blues[note 43] \n",
541 "23 NaN \n",
542 "24 NaN \n",
543 "25 NaN \n",
544 "26 Predators \n",
545 "27 NaN \n",
546 "28 NaN \n",
547 "29 Sabres \n",
548 "30 Canadiens \n",
549 "31 Canucks \n",
550 "32 NaN \n",
551 "33 NaN \n",
552 "34 Blue Jackets \n",
553 "35 Flames \n",
554 "36 Senators \n",
555 "37 Oilers \n",
556 "38 NaN \n",
557 "39 Jets[note 61] \n",
558 "40 NaN \n",
559 "41 NaN \n",
560 "42 NaN \n",
561 "43 Golden Knights \n",
562 "44 NaN \n",
563 "45 NaN \n",
564 "46 NaN \n",
565 "47 Hurricanes \n",
566 "48 NaN \n",
567 "49 [note 71] \n",
568 "50 NaN \n",
569 "51 31 "
570 ]
571 },
572 "execution_count": 47,
573 "metadata": {},
574 "output_type": "execute_result"
575 }
576 ],
577 "source": [
578 "wiki"
579 ]
580 },
581 {
582 "cell_type": "code",
583 "execution_count": null,
584 "id": "c140f59c",
585 "metadata": {},
586 "outputs": [],
587 "source": []
588 },
589 {
590 "cell_type": "code",
591 "execution_count": null,
592 "id": "9eb2f4d7",
593 "metadata": {},
594 "outputs": [],
595 "source": []
596 },
597 {
598 "cell_type": "code",
599 "execution_count": null,
600 "id": "a9cd21e8",
601 "metadata": {},
602 "outputs": [],
603 "source": []
604 },
605 {
606 "cell_type": "code",
607 "execution_count": null,
608 "id": "6760383a",
609 "metadata": {},
610 "outputs": [],
611 "source": []
612 },
613 {
614 "cell_type": "code",
615 "execution_count": null,
616 "id": "58f5013b",
617 "metadata": {},
618 "outputs": [],
619 "source": []
620 },
621 {
622 "cell_type": "code",
623 "execution_count": null,
624 "id": "adc69220",
625 "metadata": {},
626 "outputs": [],
627 "source": []
628 },
629 {
630 "cell_type": "code",
631 "execution_count": null,
632 "id": "d3e634fb",
633 "metadata": {},
634 "outputs": [],
635 "source": []
636 },
637 {
638 "cell_type": "code",
639 "execution_count": null,
640 "id": "ac515498",
641 "metadata": {},
642 "outputs": [],
643 "source": []
644 },
645 {
646 "cell_type": "code",
647 "execution_count": null,
648 "id": "38ee3b29",
649 "metadata": {},
650 "outputs": [],
651 "source": []
652 },
653 {
654 "cell_type": "code",
655 "execution_count": null,
656 "id": "d230e386",
657 "metadata": {},
658 "outputs": [],
659 "source": []
660 },
661 {
662 "cell_type": "code",
663 "execution_count": null,
664 "id": "e1d5631b",
665 "metadata": {},
666 "outputs": [],
667 "source": []
668 },
669 {
670 "cell_type": "code",
671 "execution_count": null,
672 "id": "c22fc171",
673 "metadata": {},
674 "outputs": [],
675 "source": []
676 },
677 {
678 "cell_type": "code",
679 "execution_count": null,
680 "id": "7361f1a7",
681 "metadata": {},
682 "outputs": [],
683 "source": []
684 },
685 {
686 "cell_type": "code",
687 "execution_count": null,
688 "id": "705ce2d4",
689 "metadata": {},
690 "outputs": [],
691 "source": []
692 },
693 {
694 "cell_type": "code",
695 "execution_count": null,
696 "id": "41ae0bd0",
697 "metadata": {},
698 "outputs": [],
699 "source": []
700 },
701 {
702 "cell_type": "code",
703 "execution_count": null,
704 "id": "c5dc9fb3",
705 "metadata": {},
706 "outputs": [],
707 "source": []
708 },
709 {
710 "cell_type": "code",
711 "execution_count": null,
712 "id": "a6ff2df7",
713 "metadata": {},
714 "outputs": [],
715 "source": []
716 },
717 {
718 "cell_type": "code",
719 "execution_count": null,
720 "id": "2bdb9b59",
721 "metadata": {},
722 "outputs": [],
723 "source": []
724 },
725 {
726 "cell_type": "code",
727 "execution_count": null,
728 "id": "efa933f4",
729 "metadata": {},
730 "outputs": [],
731 "source": []
732 },
733 {
734 "cell_type": "code",
735 "execution_count": null,
736 "id": "f5e4455c",
737 "metadata": {},
738 "outputs": [],
739 "source": []
740 },
741 {
742 "cell_type": "code",
743 "execution_count": null,
744 "id": "93647b7d",
745 "metadata": {},
746 "outputs": [],
747 "source": []
748 },
749 {
750 "cell_type": "code",
751 "execution_count": null,
752 "id": "4b26e4ff",
753 "metadata": {},
754 "outputs": [],
755 "source": []
756 }
757 ],
758 "metadata": {
759 "kernelspec": {
760 "display_name": "Python 3",
761 "language": "python",
762 "name": "python3"
763 },
764 "language_info": {
765 "codemirror_mode": {
766 "name": "ipython",
767 "version": 3
768 },
769 "file_extension": ".py",
770 "mimetype": "text/x-python",
771 "name": "python",
772 "nbconvert_exporter": "python",
773 "pygments_lexer": "ipython3",
774 "version": "3.8.8"
775 }
776 },
777 "nbformat": 4,
778 "nbformat_minor": 5
779 }
780