{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": { "ExecuteTime": { "end_time": "2019-04-17T01:57:39.034370Z", "start_time": "2019-04-17T01:57:38.345371Z" } }, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "ExecuteTime": { "end_time": "2019-04-17T01:57:39.041375Z", "start_time": "2019-04-17T01:57:39.037371Z" } }, "outputs": [], "source": [ "url='https://en.wikipedia.org/wiki/List_of_International_Space_Station_expeditions'" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "ExecuteTime": { "end_time": "2019-04-17T01:57:39.056373Z", "start_time": "2019-04-17T01:57:39.046371Z" } }, "outputs": [], "source": [ "#!pip install beautifulsoup4" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "ExecuteTime": { "end_time": "2019-04-17T22:17:32.585397Z", "start_time": "2019-04-17T22:17:27.913454Z" } }, "outputs": [ { "ename": "NameError", "evalue": "name 'url' is not defined", "output_type": "error", "traceback": [ "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m", "\u001b[1;31mNameError\u001b[0m Traceback (most recent call last)", "\u001b[1;32m\u001b[0m in \u001b[0;36m\u001b[1;34m()\u001b[0m\n\u001b[0;32m 1\u001b[0m \u001b[1;32mimport\u001b[0m \u001b[0mbs4\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 2\u001b[0m \u001b[1;32mimport\u001b[0m \u001b[0mrequests\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 3\u001b[1;33m \u001b[0mr\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mrequests\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0murl\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m 4\u001b[0m \u001b[0msoup\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mbs4\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mBeautifulSoup\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcontent\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 5\u001b[0m \u001b[0mtables\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0msoup\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mfindAll\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"table\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n", "\u001b[1;31mNameError\u001b[0m: name 'url' is not defined" ] } ], "source": [ "import bs4\n", "import requests\n", "r=requests.get(url)\n", "soup = bs4.BeautifulSoup(r.content)\n", "tables=soup.findAll(\"table\")" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "ExecuteTime": { "end_time": "2019-04-17T22:17:32.587397Z", "start_time": "2019-04-17T22:17:28.742Z" } }, "outputs": [], "source": [ "exps={}\n", "ppls={}\n", "ppcs={}\n", "msns={}\n", "cnts={}\n", "for trs in [tables[0].findAll(\"tr\"),tables[1].findAll(\"tr\")]:\n", " for i,tr in enumerate(trs):\n", " if i>0:\n", " tds=tr.findAll(\"td\")\n", " for j,td in enumerate(tds):\n", " aas=td.findAll(\"a\")\n", " for a in aas:\n", " if a:\n", " txt=a.text\n", " if j==0:\n", " if exp not in exps: exps[exp]=a['href']\n", " elif j==1:\n", " print(txt)\n", " if not txt:\n", " img=a.find('img')\n", " cnt=img['alt']\n", " if 'ISS' not in cnt:\n", " if cnt not in cnts: cnts[cnt]=img['src']\n", " else:\n", " if '[' not in txt:\n", " if txt not in ppcs: \n", " ppcs[txt]=cnt\n", " if txt not in ppls: \n", " ppls[txt]=a['href']\n", " else:\n", " if txt:\n", " if '[' not in txt:\n", " if txt not in msns: msns[txt]=a['href']" ] }, { "cell_type": "code", "execution_count": 76, "metadata": { "ExecuteTime": { "end_time": "2019-04-17T02:18:51.368903Z", "start_time": "2019-04-17T02:18:50.943171Z" } }, "outputs": [], "source": [ "df=pd.read_html(url)\n", "df=pd.concat(df[:2]).reset_index()" ] }, { "cell_type": "code", "execution_count": 77, "metadata": { "ExecuteTime": { "end_time": "2019-04-17T02:18:52.167840Z", "start_time": "2019-04-17T02:18:52.162842Z" } }, "outputs": [], "source": [ "def find_names(s,ppls,z):\n", " nms=s.split(' ')\n", " l=2\n", " while l<4:\n", " ppl=' '.join(nms[:l])\n", " if ppl in ppls:\n", " print(ppl)\n", " z.append(ppl)\n", " rest=' '.join(nms[l:])\n", " find_names(rest,ppls,z)\n", " l=4\n", " l+=1\n", " return z" ] }, { "cell_type": "code", "execution_count": 78, "metadata": { "ExecuteTime": { "end_time": "2019-04-17T02:18:52.877171Z", "start_time": "2019-04-17T02:18:52.862173Z" } }, "outputs": [ { "data": { "text/plain": [ "{'Expedition 1': '/wiki/Expedition_1',\n", " 'William M. Shepherd': '/wiki/William_M._Shepherd',\n", " 'Sergei Krikalev': '/wiki/Sergei_Krikalev',\n", " 'Yuri Gidzenko': '/wiki/Yuri_Gidzenko',\n", " 'Soyuz TM-31': '/wiki/Soyuz_TM-31',\n", " 'STS-102': '/wiki/STS-102',\n", " 'Expedition 2': '/wiki/Expedition_2',\n", " 'Yuri Usachev': '/wiki/Yuri_Usachev',\n", " 'James S. Voss': '/wiki/James_S._Voss',\n", " 'Susan J. Helms': '/wiki/Susan_J._Helms',\n", " 'STS-105': '/wiki/STS-105',\n", " 'Expedition 3': '/wiki/Expedition_3',\n", " 'Frank L. Culbertson': '/wiki/Frank_L._Culbertson',\n", " 'Mikhail Tyurin': '/wiki/Mikhail_Tyurin',\n", " 'Vladimir Dezhurov': '/wiki/Vladimir_Dezhurov',\n", " 'STS-108': '/wiki/STS-108',\n", " 'Expedition 4': '/wiki/Expedition_4',\n", " 'Yury Onufrienko': '/wiki/Yury_Onufrienko',\n", " 'Carl E. Walz': '/wiki/Carl_E._Walz',\n", " 'Daniel W. Bursch': '/wiki/Daniel_W._Bursch',\n", " 'STS-111': '/wiki/STS-111',\n", " 'Expedition 5': '/wiki/Expedition_5',\n", " 'Valery Korzun': '/wiki/Valery_Korzun',\n", " 'Sergei Treshchev': '/wiki/Sergei_Treshchev',\n", " 'Peggy A. Whitson': '/wiki/Peggy_A._Whitson',\n", " 'STS-113': '/wiki/STS-113',\n", " 'Expedition 6': '/wiki/Expedition_6',\n", " 'Kenneth D. Bowersox': '/wiki/Kenneth_D._Bowersox',\n", " 'Donald R. Pettit': '/wiki/Donald_R._Pettit',\n", " 'Nikolai Budarin': '/wiki/Nikolai_Budarin',\n", " 'Soyuz TMA-1': '/wiki/Soyuz_TMA-1',\n", " 'Expedition 7': '/wiki/Expedition_7',\n", " 'Yuri Malenchenko': '/wiki/Yuri_Malenchenko',\n", " 'Edward T. Lu': '/wiki/Edward_T._Lu',\n", " 'Soyuz TMA-2': '/wiki/Soyuz_TMA-2',\n", " 'Expedition 8': '/wiki/Expedition_8',\n", " 'C. Michael Foale': '/wiki/C._Michael_Foale',\n", " 'Alexander Kaleri': '/wiki/Alexander_Kaleri',\n", " 'Soyuz TMA-3': '/wiki/Soyuz_TMA-3',\n", " 'Expedition 9': '/wiki/Expedition_9',\n", " 'Gennady Padalka': '/wiki/Gennady_Padalka',\n", " 'E. Michael Fincke': '/wiki/Michael_Fincke',\n", " 'Soyuz TMA-4': '/wiki/Soyuz_TMA-4',\n", " 'Expedition 10': '/wiki/Expedition_10',\n", " 'Leroy Chiao': '/wiki/Leroy_Chiao',\n", " 'Salizhan Sharipov': '/wiki/Salizhan_Sharipov',\n", " 'Soyuz TMA-5': '/wiki/Soyuz_TMA-5',\n", " 'Expedition 11': '/wiki/Expedition_11',\n", " 'John L. Phillips': '/wiki/John_L._Phillips',\n", " 'Soyuz TMA-6': '/wiki/Soyuz_TMA-6',\n", " 'Expedition 12': '/wiki/Expedition_12',\n", " 'William S. McArthur': '/wiki/William_S._McArthur',\n", " 'Valeri Tokarev': '/wiki/Valeri_Tokarev',\n", " 'Soyuz TMA-7': '/wiki/Soyuz_TMA-7',\n", " 'Expedition 13': '/wiki/Expedition_13',\n", " 'Pavel Vinogradov': '/wiki/Pavel_Vinogradov',\n", " 'Jeffrey N. Williams': '/wiki/Jeffrey_N._Williams',\n", " 'Soyuz TMA-8': '/wiki/Soyuz_TMA-8',\n", " 'Thomas Reiter': '/wiki/Thomas_Reiter',\n", " 'STS-121': '/wiki/STS-121',\n", " 'Expedition 14': '/wiki/Expedition_14',\n", " 'Michael E. Lopez-Alegria': '/wiki/Michael_E._Lopez-Alegria',\n", " 'Soyuz TMA-9': '/wiki/Soyuz_TMA-9',\n", " 'STS-116': '/wiki/STS-116',\n", " 'Sunita L. Williams': '/wiki/Sunita_L._Williams',\n", " 'Expedition 15': '/wiki/Expedition_15',\n", " 'Fyodor Yurchikhin': '/wiki/Fyodor_Yurchikhin',\n", " 'Oleg Kotov': '/wiki/Oleg_Kotov',\n", " 'Soyuz TMA-10': '/wiki/Soyuz_TMA-10',\n", " 'STS-117': '/wiki/STS-117',\n", " 'Clayton C. Anderson': '/wiki/Clayton_Anderson',\n", " 'Expedition 16': '/wiki/Expedition_16',\n", " 'Soyuz TMA-11': '/wiki/Soyuz_TMA-11',\n", " 'STS-120': '/wiki/STS-120',\n", " 'Daniel M. Tani': '/wiki/Daniel_M._Tani',\n", " 'STS-122': '/wiki/STS-122',\n", " 'Léopold Eyharts': '/wiki/L%C3%A9opold_Eyharts',\n", " 'STS-123': '/wiki/STS-123',\n", " 'Garrett E. Reisman': '/wiki/Garrett_Reisman',\n", " 'Expedition 17': '/wiki/Expedition_17',\n", " 'Sergey Volkov': '/wiki/Sergey_Aleksandrovich_Volkov',\n", " 'Oleg Kononenko': '/wiki/Oleg_Kononenko',\n", " 'Soyuz TMA-12': '/wiki/Soyuz_TMA-12',\n", " 'STS-124': '/wiki/STS-124',\n", " 'Gregory E. Chamitoff': '/wiki/Gregory_E._Chamitoff',\n", " 'Expedition 18': '/wiki/Expedition_18',\n", " 'Yuri Lonchakov': '/wiki/Yuri_Lonchakov',\n", " 'Soyuz TMA-13': '/wiki/Soyuz_TMA-13',\n", " 'STS-126': '/wiki/STS-126',\n", " 'Sandra H. Magnus': '/wiki/Sandra_H._Magnus',\n", " 'STS-119': '/wiki/STS-119',\n", " 'Koichi Wakata': '/wiki/Koichi_Wakata',\n", " 'Expedition 19': '/wiki/Expedition_19',\n", " 'Michael R. Barratt': '/wiki/Michael_R._Barratt',\n", " 'Soyuz TMA-14': '/wiki/Soyuz_TMA-14',\n", " 'Expedition 20': '/wiki/Expedition_20',\n", " 'STS-127': '/wiki/STS-127',\n", " 'Timothy L. Kopra': '/wiki/Timothy_L._Kopra',\n", " 'STS-128': '/wiki/STS-128',\n", " 'Frank De Winne': '/wiki/Frank_De_Winne',\n", " 'Roman Romanenko': '/wiki/Roman_Romanenko',\n", " 'Robert B. Thirsk': '/wiki/Robert_Thirsk',\n", " 'Soyuz TMA-15': '/wiki/Soyuz_TMA-15',\n", " 'Nicole P. Stott': '/wiki/Nicole_P._Stott',\n", " 'Expedition 21': '/wiki/Expedition_21',\n", " 'STS-129': '/wiki/STS-129',\n", " 'Maksim Surayev': '/wiki/Maksim_Surayev',\n", " 'Soyuz TMA-16': '/wiki/Soyuz_TMA-16',\n", " 'Expedition 22': '/wiki/Expedition_22',\n", " 'Timothy J. Creamer': '/wiki/Timothy_Creamer',\n", " 'Soichi Noguchi': '/wiki/Soichi_Noguchi',\n", " 'Soyuz TMA-17': '/wiki/Soyuz_TMA-17',\n", " 'Expedition 23': '/wiki/Expedition_23',\n", " 'Aleksandr Skvortsov': '/wiki/Aleksandr_Skvortsov_(cosmonaut)',\n", " 'Mikhail Korniyenko': '/wiki/Mikhail_Korniyenko',\n", " 'Tracy E. Caldwell Dyson': '/wiki/Tracy_Caldwell_Dyson',\n", " 'Soyuz TMA-18': '/wiki/Soyuz_TMA-18',\n", " 'Expedition 24': '/wiki/Expedition_24',\n", " 'Douglas H. Wheelock': '/wiki/Douglas_H._Wheelock',\n", " 'Shannon Walker': '/wiki/Shannon_Walker',\n", " 'Soyuz TMA-19': '/wiki/Soyuz_TMA-19',\n", " 'Expedition 25': '/wiki/Expedition_25',\n", " 'Scott J. Kelly': '/wiki/Scott_Kelly_(astronaut)',\n", " 'Aleksandr Kaleri': '/wiki/Aleksandr_Kaleri',\n", " 'Oleg Skripochka': '/wiki/Oleg_Skripochka',\n", " 'Soyuz TMA-01M': '/wiki/Soyuz_TMA-01M',\n", " 'Expedition 26': '/wiki/Expedition_26',\n", " 'Dimitri Kondratyev': '/wiki/Dimitri_Kondratyev',\n", " 'Catherine G. Coleman': '/wiki/Catherine_G._Coleman',\n", " 'Paolo Nespoli': '/wiki/Paolo_Nespoli',\n", " 'Soyuz TMA-20': '/wiki/Soyuz_TMA-20',\n", " 'Expedition 27': '/wiki/Expedition_27',\n", " 'Andrei Borisenko': '/wiki/Andrei_Borisenko',\n", " 'Aleksandr Samokutyayev': '/wiki/Aleksandr_Samokutyayev',\n", " 'Ronald J. Garan': '/wiki/Ronald_J._Garan',\n", " 'Soyuz TMA-21': '/wiki/Soyuz_TMA-21',\n", " 'Expedition 28': '/wiki/Expedition_28',\n", " 'Michael E. Fossum': '/wiki/Michael_E._Fossum',\n", " 'Satoshi Furukawa': '/wiki/Satoshi_Furukawa',\n", " 'Soyuz TMA-02M': '/wiki/Soyuz_TMA-02M',\n", " 'Expedition 29': '/wiki/Expedition_29',\n", " 'Daniel C. Burbank': '/wiki/Daniel_C._Burbank',\n", " 'Anton Shkaplerov': '/wiki/Anton_Shkaplerov',\n", " 'Anatoli Ivanishin': '/wiki/Anatoli_Ivanishin',\n", " 'Soyuz TMA-22': '/wiki/Soyuz_TMA-22',\n", " 'Expedition 30': '/wiki/Expedition_30',\n", " 'André Kuipers': '/wiki/Andr%C3%A9_Kuipers',\n", " 'Soyuz TMA-03M': '/wiki/Soyuz_TMA-03M',\n", " 'Expedition 31': '/wiki/Expedition_31',\n", " 'Sergei Revin': '/wiki/Sergei_Revin',\n", " 'Joseph M. Acaba': '/wiki/Joseph_M._Acaba',\n", " 'Soyuz TMA-04M': '/wiki/Soyuz_TMA-04M',\n", " 'Expedition 32': '/wiki/Expedition_32',\n", " 'Akihiko Hoshide': '/wiki/Akihiko_Hoshide',\n", " 'Soyuz TMA-05M': '/wiki/Soyuz_TMA-05M',\n", " 'Expedition 33': '/wiki/Expedition_33',\n", " 'Kevin A. Ford': '/wiki/Kevin_A._Ford',\n", " 'Oleg Novitskiy': '/wiki/Oleg_Novitskiy',\n", " 'Evgeny Tarelkin': '/wiki/Evgeny_Tarelkin',\n", " 'Soyuz TMA-06M': '/wiki/Soyuz_TMA-06M',\n", " 'Expedition 34': '/wiki/Expedition_34',\n", " 'Chris Hadfield': '/wiki/Chris_Hadfield',\n", " 'Thomas H. Marshburn': '/wiki/Thomas_H._Marshburn',\n", " 'Soyuz TMA-07M': '/wiki/Soyuz_TMA-07M',\n", " 'Expedition 35': '/wiki/Expedition_35',\n", " 'Aleksandr Misurkin': '/wiki/Aleksandr_Misurkin',\n", " 'Christopher J. Cassidy': '/wiki/Christopher_J._Cassidy',\n", " 'Soyuz TMA-08M': '/wiki/Soyuz_TMA-08M',\n", " 'Expedition 36': '/wiki/Expedition_36',\n", " 'Karen L. Nyberg': '/wiki/Karen_L._Nyberg',\n", " 'Luca Parmitano': '/wiki/Luca_Parmitano',\n", " 'Soyuz TMA-09M': '/wiki/Soyuz_TMA-09M',\n", " 'Expedition 37': '/wiki/Expedition_37',\n", " 'Sergey Ryazansky': '/wiki/Sergey_Ryazansky',\n", " 'Michael S. Hopkins': '/wiki/Michael_S._Hopkins',\n", " 'Soyuz TMA-10M': '/wiki/Soyuz_TMA-10M',\n", " 'Expedition 38': '/wiki/Expedition_38',\n", " 'Richard A. Mastracchio': '/wiki/Richard_A._Mastracchio',\n", " 'Soyuz TMA-11M': '/wiki/Soyuz_TMA-11M',\n", " 'Expedition 39': '/wiki/Expedition_39',\n", " 'Oleg Artemyev': '/wiki/Oleg_Artemyev',\n", " 'Steven R. Swanson': '/wiki/Steven_R._Swanson',\n", " 'Soyuz TMA-12M': '/wiki/Soyuz_TMA-12M',\n", " 'Expedition 40': '/wiki/Expedition_40',\n", " 'Gregory R. Wiseman': '/wiki/Gregory_R._Wiseman',\n", " 'Alexander Gerst': '/wiki/Alexander_Gerst',\n", " 'Soyuz TMA-13M': '/wiki/Soyuz_TMA-13M',\n", " 'Expedition 41': '/wiki/Expedition_41',\n", " 'Yelena Serova': '/wiki/Yelena_Serova',\n", " 'Barry E. Wilmore': '/wiki/Barry_E._Wilmore',\n", " 'Soyuz TMA-14M': '/wiki/Soyuz_TMA-14M',\n", " 'Expedition 42': '/wiki/Expedition_42',\n", " 'Samantha Cristoforetti': '/wiki/Samantha_Cristoforetti',\n", " 'Terry W. Virts': '/wiki/Terry_W._Virts',\n", " 'Soyuz TMA-15M': '/wiki/Soyuz_TMA-15M',\n", " 'Expedition 43': '/wiki/Expedition_43',\n", " 'Soyuz TMA-16M': '/wiki/Soyuz_TMA-16M',\n", " 'one year mission': '/wiki/ISS_year_long_mission',\n", " 'Expedition 44': '/wiki/Expedition_44',\n", " 'Kimiya Yui': '/wiki/Kimiya_Yui',\n", " 'Kjell N. Lindgren': '/wiki/Kjell_N._Lindgren',\n", " 'Soyuz TMA-17M': '/wiki/Soyuz_TMA-17M',\n", " 'Expedition 45': '/wiki/Expedition_45',\n", " 'Soyuz TMA-18M': '/wiki/Soyuz_TMA-18M',\n", " 'Expedition 46': '/wiki/Expedition_46',\n", " 'Timothy Peake': '/wiki/Timothy_Peake',\n", " 'Timothy Kopra': '/wiki/Timothy_Kopra',\n", " 'Soyuz TMA-19M': '/wiki/Soyuz_TMA-19M',\n", " 'Expedition 47': '/wiki/Expedition_47',\n", " 'Tim Peake': '/wiki/Tim_Peake',\n", " 'Aleksey Ovchinin': '/wiki/Aleksey_Ovchinin',\n", " 'Jeffrey Williams': '/wiki/Jeffrey_Williams_(astronaut)',\n", " 'Soyuz TMA-20M': '/wiki/Soyuz_TMA-20M',\n", " 'Expedition 48': '/wiki/Expedition_48',\n", " 'Takuya Onishi': '/wiki/Takuya_Onishi',\n", " 'Kathleen Rubins': '/wiki/Kathleen_Rubins',\n", " 'Soyuz MS-01': '/wiki/Soyuz_MS-01',\n", " 'Expedition 49': '/wiki/Expedition_49',\n", " 'Shane Kimbrough': '/wiki/Shane_Kimbrough',\n", " 'Sergey Ryzhikov': '/wiki/Sergey_Nikolayevich_Ryzhikov',\n", " 'Soyuz MS-02': '/wiki/Soyuz_MS-02',\n", " 'Expedition 50': '/wiki/Expedition_50',\n", " 'Peggy Whitson': '/wiki/Peggy_Whitson',\n", " 'Thomas Pesquet': '/wiki/Thomas_Pesquet',\n", " 'Soyuz MS-03': '/wiki/Soyuz_MS-03',\n", " 'Expedition 51': '/wiki/Expedition_51',\n", " 'Jack D. Fischer': '/wiki/Jack_D._Fischer',\n", " 'Soyuz MS-04': '/wiki/Soyuz_MS-04',\n", " 'Expedition 52': '/wiki/Expedition_52',\n", " 'Randolph Bresnik': '/wiki/Randolph_Bresnik',\n", " 'Soyuz MS-05': '/wiki/Soyuz_MS-05',\n", " 'Expedition 53': '/wiki/Expedition_53',\n", " 'Alexander Misurkin': '/wiki/Alexander_Misurkin',\n", " 'Mark Vande Hei': '/wiki/Mark_Vande_Hei',\n", " 'Joseph Acaba': '/wiki/Joseph_Acaba',\n", " 'Soyuz MS-06': '/wiki/Soyuz_MS-06',\n", " 'Expedition 54': '/wiki/Expedition_54',\n", " 'Scott Tingle': '/wiki/Scott_Tingle',\n", " 'Norishige Kanai': '/wiki/Norishige_Kanai',\n", " 'Soyuz MS-07': '/wiki/Soyuz_MS-07',\n", " 'Expedition 55': '/wiki/Expedition_55',\n", " 'Andrew Feustel': '/wiki/Andrew_Feustel',\n", " 'Richard Arnold': '/wiki/Richard_R._Arnold',\n", " 'Soyuz MS-08': '/wiki/Soyuz_MS-08',\n", " 'Expedition 56': '/wiki/Expedition_56',\n", " 'Sergey Prokopyev': '/wiki/Sergey_Prokopyev_(cosmonaut)',\n", " 'Serena Auñón-Chancellor': '/wiki/Serena_M._Au%C3%B1%C3%B3n-Chancellor',\n", " 'Soyuz MS-09': '/wiki/Soyuz_MS-09',\n", " 'Expedition 57': '/wiki/Expedition_57',\n", " 'David Saint-Jacques': '/wiki/David_Saint-Jacques',\n", " 'Anne McClain': '/wiki/Anne_McClain',\n", " 'Soyuz MS-11': '/wiki/Soyuz_MS-11',\n", " 'Expedition 58': '/wiki/Expedition_58',\n", " 'Expedition 59': '/wiki/Expedition_59',\n", " 'Christina Koch': '/wiki/Christina_Koch',\n", " 'Nick Hague': '/wiki/Nick_Hague',\n", " 'Soyuz MS-12': '/wiki/Soyuz_MS-12'}" ] }, "execution_count": 78, "metadata": {}, "output_type": "execute_result" } ], "source": [ "ppls" ] }, { "cell_type": "code", "execution_count": 72, "metadata": { "ExecuteTime": { "end_time": "2019-04-17T02:14:46.941408Z", "start_time": "2019-04-17T02:14:46.848406Z" } }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "William M. Shepherd\n", "Sergei Krikalev\n", "Yuri Gidzenko\n", "William M. Shepherd Sergei Krikalev Yuri Gidzenko ['William M. Shepherd', 'Sergei Krikalev', 'Yuri Gidzenko']\n", "Yuri Usachev\n", "James S. Voss\n", "Susan J. Helms\n", "Yuri Usachev James S. Voss Susan J. Helms ['Yuri Usachev', 'James S. Voss', 'Susan J. Helms']\n", "Frank L. Culbertson\n", "Mikhail Tyurin\n", "Vladimir Dezhurov\n", "Frank L. Culbertson Mikhail Tyurin Vladimir Dezhurov ['Frank L. Culbertson', 'Mikhail Tyurin', 'Vladimir Dezhurov']\n", "Yury Onufrienko\n", "Carl E. Walz\n", "Daniel W. Bursch\n", "Yury Onufrienko Carl E. Walz Daniel W. Bursch ['Yury Onufrienko', 'Carl E. Walz', 'Daniel W. Bursch']\n", "Valery Korzun\n", "Sergei Treshchev\n", "Peggy A. Whitson\n", "Valery Korzun Sergei Treshchev Peggy A. Whitson ['Valery Korzun', 'Sergei Treshchev', 'Peggy A. Whitson']\n", "Kenneth D. Bowersox\n", "Donald R. Pettit\n", "Nikolai Budarin\n", "Kenneth D. Bowersox Donald R. Pettit Nikolai Budarin ['Kenneth D. Bowersox', 'Donald R. Pettit', 'Nikolai Budarin']\n", "Yuri Malenchenko\n", "Edward T. Lu\n", "Yuri Malenchenko Edward T. Lu ['Yuri Malenchenko', 'Edward T. Lu']\n", "C. Michael Foale\n", "Alexander Kaleri\n", "C. Michael Foale Alexander Kaleri ['C. Michael Foale', 'Alexander Kaleri']\n", "Gennady Padalka\n", "E. Michael Fincke\n", "Gennady Padalka E. Michael Fincke ['Gennady Padalka', 'E. Michael Fincke']\n", "Leroy Chiao\n", "Salizhan Sharipov\n", "Leroy Chiao Salizhan Sharipov ['Leroy Chiao', 'Salizhan Sharipov']\n", "Sergei Krikalev\n", "John L. Phillips\n", "Sergei Krikalev John L. Phillips ['Sergei Krikalev', 'John L. Phillips']\n", "William S. McArthur\n", "Valeri Tokarev\n", "William S. McArthur Valeri Tokarev ['William S. McArthur', 'Valeri Tokarev']\n", "Pavel Vinogradov\n", "Jeffrey N. Williams\n", "Pavel Vinogradov Jeffrey N. Williams ['Pavel Vinogradov', 'Jeffrey N. Williams']\n", "Thomas Reiter []\n", "Michael E. Lopez-Alegria\n", "Mikhail Tyurin\n", "Michael E. Lopez-Alegria Mikhail Tyurin ['Michael E. Lopez-Alegria', 'Mikhail Tyurin']\n", "Thomas Reiter []\n", "Sunita L. Williams\n", "Sunita L. Williams ['Sunita L. Williams', 'Sunita L. Williams']\n", "Fyodor Yurchikhin\n", "Oleg Kotov\n", "Fyodor Yurchikhin Oleg Kotov ['Fyodor Yurchikhin', 'Oleg Kotov']\n", "Sunita L. Williams\n", "Sunita L. Williams ['Sunita L. Williams', 'Sunita L. Williams']\n", "Clayton C. Anderson []\n", "Peggy A. Whitson\n", "Yuri Malenchenko\n", "Peggy A. Whitson Yuri Malenchenko ['Peggy A. Whitson', 'Yuri Malenchenko']\n", "Clayton C. Anderson []\n", "Daniel M. Tani []\n", "Léopold Eyharts []\n", "Garrett E. Reisman []\n", "Sergey Volkov\n", "Oleg Kononenko\n", "Sergey Volkov Oleg Kononenko ['Sergey Volkov', 'Oleg Kononenko']\n", "Garrett E. Reisman []\n", "Gregory E. Chamitoff []\n", "E. Michael Fincke\n", "Yuri Lonchakov\n", "E. Michael Fincke Yuri Lonchakov ['E. Michael Fincke', 'Yuri Lonchakov']\n", "Gregory E. Chamitoff []\n", "Sandra H. Magnus []\n", "Koichi Wakata\n", "Koichi Wakata ['Koichi Wakata', 'Koichi Wakata']\n", "Gennady Padalka\n", "Michael R. Barratt\n", "Gennady Padalka Michael R. Barratt ['Gennady Padalka', 'Michael R. Barratt']\n", "Koichi Wakata\n", "Koichi Wakata ['Koichi Wakata', 'Koichi Wakata']\n", "Gennady Padalka\n", "Michael R. Barratt\n", "Gennady Padalka Michael R. Barratt ['Gennady Padalka', 'Michael R. Barratt']\n", "Koichi Wakata\n", "Koichi Wakata ['Koichi Wakata', 'Koichi Wakata']\n", "Timothy L. Kopra []\n", "Frank De Winne\n", "Roman Romanenko\n", "Robert B. Thirsk\n", "Frank De Winne Roman Romanenko Robert B. Thirsk ['Frank De Winne', 'Roman Romanenko', 'Robert B. Thirsk']\n", "Nicole P. Stott []\n", "Frank De Winne\n", "Roman Romanenko\n", "Robert B. Thirsk\n", "Frank De Winne Roman Romanenko Robert B. Thirsk ['Frank De Winne', 'Roman Romanenko', 'Robert B. Thirsk']\n", "Nicole P. Stott []\n", "Jeffrey N. Williams\n", "Maksim Surayev\n", "Jeffrey N. Williams Maksim Surayev ['Jeffrey N. Williams', 'Maksim Surayev']\n", "Jeffrey N. Williams\n", "Maksim Surayev\n", "Jeffrey N. Williams Maksim Surayev ['Jeffrey N. Williams', 'Maksim Surayev']\n", "Oleg Kotov\n", "Timothy J. Creamer\n", "Soichi Noguchi\n", "Oleg Kotov Timothy J. Creamer Soichi Noguchi ['Oleg Kotov', 'Timothy J. Creamer', 'Soichi Noguchi']\n", "Oleg Kotov\n", "Timothy J. Creamer\n", "Soichi Noguchi\n", "Oleg Kotov Timothy J. Creamer Soichi Noguchi ['Oleg Kotov', 'Timothy J. Creamer', 'Soichi Noguchi']\n", "Aleksandr Skvortsov\n", "Mikhail Korniyenko\n", "Aleksandr Skvortsov Mikhail Korniyenko Tracy E. Caldwell Dyson ['Aleksandr Skvortsov', 'Mikhail Korniyenko']\n", "Aleksandr Skvortsov\n", "Mikhail Korniyenko\n", "Aleksandr Skvortsov Mikhail Korniyenko Tracy E. Caldwell Dyson ['Aleksandr Skvortsov', 'Mikhail Korniyenko']\n", "Douglas H. Wheelock\n", "Shannon Walker\n", "Fyodor Yurchikhin\n", "Douglas H. Wheelock Shannon Walker Fyodor Yurchikhin ['Douglas H. Wheelock', 'Shannon Walker', 'Fyodor Yurchikhin']\n", "Douglas H. Wheelock\n", "Shannon Walker\n", "Fyodor Yurchikhin\n", "Douglas H. Wheelock Shannon Walker Fyodor Yurchikhin ['Douglas H. Wheelock', 'Shannon Walker', 'Fyodor Yurchikhin']\n", "Scott J. Kelly\n", "Aleksandr Kaleri\n", "Oleg Skripochka\n", "Scott J. Kelly Aleksandr Kaleri Oleg Skripochka ['Scott J. Kelly', 'Aleksandr Kaleri', 'Oleg Skripochka']\n", "Scott J. Kelly\n", "Aleksandr Kaleri\n", "Oleg Skripochka\n", "Scott J. Kelly Aleksandr Kaleri Oleg Skripochka ['Scott J. Kelly', 'Aleksandr Kaleri', 'Oleg Skripochka']\n", "Dimitri Kondratyev\n", "Catherine G. Coleman\n", "Paolo Nespoli\n", "Dimitri Kondratyev Catherine G. Coleman Paolo Nespoli ['Dimitri Kondratyev', 'Catherine G. Coleman', 'Paolo Nespoli']\n", "Dimitri Kondratyev\n", "Catherine G. Coleman\n", "Paolo Nespoli\n", "Dimitri Kondratyev Catherine G. Coleman Paolo Nespoli ['Dimitri Kondratyev', 'Catherine G. Coleman', 'Paolo Nespoli']\n", "Andrei Borisenko\n", "Aleksandr Samokutyayev\n", "Ronald J. Garan\n", "Andrei Borisenko Aleksandr Samokutyayev Ronald J. Garan ['Andrei Borisenko', 'Aleksandr Samokutyayev', 'Ronald J. Garan']\n", "Andrei Borisenko\n", "Aleksandr Samokutyayev\n", "Ronald J. Garan\n", "Andrei Borisenko Aleksandr Samokutyayev Ronald J. Garan ['Andrei Borisenko', 'Aleksandr Samokutyayev', 'Ronald J. Garan']\n", "Michael E. Fossum\n", "Sergey Volkov\n", "Satoshi Furukawa\n", "Michael E. Fossum Sergey Volkov Satoshi Furukawa ['Michael E. Fossum', 'Sergey Volkov', 'Satoshi Furukawa']\n", "Michael E. Fossum\n", "Sergey Volkov\n", "Satoshi Furukawa\n", "Michael E. Fossum Sergey Volkov Satoshi Furukawa ['Michael E. Fossum', 'Sergey Volkov', 'Satoshi Furukawa']\n", "Daniel C. Burbank\n", "Anton Shkaplerov\n", "Anatoli Ivanishin\n", "Daniel C. Burbank Anton Shkaplerov Anatoli Ivanishin ['Daniel C. Burbank', 'Anton Shkaplerov', 'Anatoli Ivanishin']\n", "Daniel C. Burbank\n", "Anton Shkaplerov\n", "Anatoli Ivanishin\n", "Daniel C. Burbank Anton Shkaplerov Anatoli Ivanishin ['Daniel C. Burbank', 'Anton Shkaplerov', 'Anatoli Ivanishin']\n", "Oleg Kononenko\n", "Donald R. Pettit\n", "André Kuipers\n", "Oleg Kononenko Donald R. Pettit André Kuipers ['Oleg Kononenko', 'Donald R. Pettit', 'André Kuipers']\n", "Oleg Kononenko\n", "Donald R. Pettit\n", "André Kuipers\n", "Oleg Kononenko Donald R. Pettit André Kuipers ['Oleg Kononenko', 'Donald R. Pettit', 'André Kuipers']\n", "Gennady Padalka\n", "Sergei Revin\n", "Joseph M. Acaba\n", "Gennady Padalka Sergei Revin Joseph M. Acaba ['Gennady Padalka', 'Sergei Revin', 'Joseph M. Acaba']\n", "Gennady Padalka\n", "Sergei Revin\n", "Joseph M. Acaba\n", "Gennady Padalka Sergei Revin Joseph M. Acaba ['Gennady Padalka', 'Sergei Revin', 'Joseph M. Acaba']\n", "Sunita L. Williams\n", "Yuri Malenchenko\n", "Akihiko Hoshide\n", "Sunita L. Williams Yuri Malenchenko Akihiko Hoshide ['Sunita L. Williams', 'Yuri Malenchenko', 'Akihiko Hoshide']\n", "Sunita L. Williams\n", "Yuri Malenchenko\n", "Akihiko Hoshide\n", "Sunita L. Williams Yuri Malenchenko Akihiko Hoshide ['Sunita L. Williams', 'Yuri Malenchenko', 'Akihiko Hoshide']\n", "Kevin A. Ford\n", "Oleg Novitskiy\n", "Evgeny Tarelkin\n", "Kevin A. Ford Oleg Novitskiy Evgeny Tarelkin ['Kevin A. Ford', 'Oleg Novitskiy', 'Evgeny Tarelkin']\n", "Kevin A. Ford\n", "Oleg Novitskiy\n", "Evgeny Tarelkin\n", "Kevin A. Ford Oleg Novitskiy Evgeny Tarelkin ['Kevin A. Ford', 'Oleg Novitskiy', 'Evgeny Tarelkin']\n", "Chris Hadfield\n", "Roman Romanenko\n", "Thomas H. Marshburn\n", "Chris Hadfield Roman Romanenko Thomas H. Marshburn ['Chris Hadfield', 'Roman Romanenko', 'Thomas H. Marshburn']\n", "Chris Hadfield\n", "Roman Romanenko\n", "Thomas H. Marshburn\n", "Chris Hadfield Roman Romanenko Thomas H. Marshburn ['Chris Hadfield', 'Roman Romanenko', 'Thomas H. Marshburn']\n", "Pavel Vinogradov\n", "Aleksandr Misurkin\n", "Christopher J. Cassidy\n", "Pavel Vinogradov Aleksandr Misurkin Christopher J. Cassidy ['Pavel Vinogradov', 'Aleksandr Misurkin', 'Christopher J. Cassidy']\n", "Pavel Vinogradov\n", "Aleksandr Misurkin\n", "Christopher J. Cassidy\n", "Pavel Vinogradov Aleksandr Misurkin Christopher J. Cassidy ['Pavel Vinogradov', 'Aleksandr Misurkin', 'Christopher J. Cassidy']\n", "Fyodor Yurchikhin\n", "Karen L. Nyberg\n", "Luca Parmitano\n", "Fyodor Yurchikhin Karen L. Nyberg Luca Parmitano ['Fyodor Yurchikhin', 'Karen L. Nyberg', 'Luca Parmitano']\n", "Fyodor Yurchikhin\n", "Karen L. Nyberg\n", "Luca Parmitano\n", "Fyodor Yurchikhin Karen L. Nyberg Luca Parmitano ['Fyodor Yurchikhin', 'Karen L. Nyberg', 'Luca Parmitano']\n", "Oleg Kotov\n", "Sergey Ryazansky\n", "Michael S. Hopkins\n", "Oleg Kotov Sergey Ryazansky Michael S. Hopkins ['Oleg Kotov', 'Sergey Ryazansky', 'Michael S. Hopkins']\n", "Oleg Kotov\n", "Sergey Ryazansky\n", "Michael S. Hopkins\n", "Oleg Kotov Sergey Ryazansky Michael S. Hopkins ['Oleg Kotov', 'Sergey Ryazansky', 'Michael S. Hopkins']\n", "Koichi Wakata\n", "Mikhail Tyurin\n", "Richard A. Mastracchio\n", "Koichi Wakata Mikhail Tyurin Richard A. Mastracchio ['Koichi Wakata', 'Mikhail Tyurin', 'Richard A. Mastracchio']\n", "Koichi Wakata\n", "Mikhail Tyurin\n", "Richard A. Mastracchio\n", "Koichi Wakata Mikhail Tyurin Richard A. Mastracchio ['Koichi Wakata', 'Mikhail Tyurin', 'Richard A. Mastracchio']\n", "Aleksandr Skvortsov\n", "Oleg Artemyev\n", "Steven R. Swanson\n", "Aleksandr Skvortsov Oleg Artemyev Steven R. Swanson ['Aleksandr Skvortsov', 'Oleg Artemyev', 'Steven R. Swanson']\n", "Steven R. Swanson\n", "Aleksandr Skvortsov\n", "Oleg Artemyev\n", "Steven R. Swanson Aleksandr Skvortsov Oleg Artemyev ['Steven R. Swanson', 'Aleksandr Skvortsov', 'Oleg Artemyev']\n", "Gregory R. Wiseman\n", "Maksim Surayev\n", "Alexander Gerst\n", "Gregory R. Wiseman Maksim Surayev Alexander Gerst ['Gregory R. Wiseman', 'Maksim Surayev', 'Alexander Gerst']\n", "Maksim Surayev\n", "Gregory R. Wiseman\n", "Alexander Gerst\n", "Maksim Surayev Gregory R. Wiseman Alexander Gerst ['Maksim Surayev', 'Gregory R. Wiseman', 'Alexander Gerst']\n", "Aleksandr Samokutyayev\n", "Yelena Serova\n", "Barry E. Wilmore\n", "Aleksandr Samokutyayev Yelena Serova Barry E. Wilmore ['Aleksandr Samokutyayev', 'Yelena Serova', 'Barry E. Wilmore']\n", "Barry E. Wilmore\n", "Aleksandr Samokutyayev\n", "Yelena Serova\n", "Barry E. Wilmore Aleksandr Samokutyayev Yelena Serova ['Barry E. Wilmore', 'Aleksandr Samokutyayev', 'Yelena Serova']\n", "Anton Shkaplerov\n", "Samantha Cristoforetti\n", "Terry W. Virts\n", "Anton Shkaplerov Samantha Cristoforetti Terry W. Virts ['Anton Shkaplerov', 'Samantha Cristoforetti', 'Terry W. Virts']\n", "Terry W. Virts\n", "Anton Shkaplerov\n", "Samantha Cristoforetti\n", "Terry W. Virts Anton Shkaplerov Samantha Cristoforetti ['Terry W. Virts', 'Anton Shkaplerov', 'Samantha Cristoforetti']\n", "Gennady Padalka\n", "Gennady Padalka ['Gennady Padalka', 'Gennady Padalka']\n", "Mikhail Korniyenko\n", "Scott J. Kelly\n", "Mikhail Korniyenko Scott J. Kelly ['Mikhail Korniyenko', 'Scott J. Kelly']\n", "Gennady Padalka\n", "Gennady Padalka ['Gennady Padalka', 'Gennady Padalka']\n", "Mikhail Korniyenko\n", "Scott J. Kelly\n", "Mikhail Korniyenko Scott J. Kelly ['Mikhail Korniyenko', 'Scott J. Kelly']\n", "Oleg Kononenko\n", "Oleg Kononenko Kimiya Yui Kjell N. Lindgren ['Oleg Kononenko']\n", "Scott J. Kelly\n", "Mikhail Korniyenko\n", "Scott J. Kelly Mikhail Korniyenko ['Scott J. Kelly', 'Mikhail Korniyenko']\n", "Oleg Kononenko\n", "Oleg Kononenko Kimiya Yui Kjell N. Lindgren ['Oleg Kononenko']\n", "Sergey Volkov\n", "Sergey Volkov ['Sergey Volkov', 'Sergey Volkov']\n", "Scott J. Kelly\n", "Mikhail Korniyenko\n", "Scott J. Kelly Mikhail Korniyenko ['Scott J. Kelly', 'Mikhail Korniyenko']\n", "Sergey Volkov\n", "Sergey Volkov ['Sergey Volkov', 'Sergey Volkov']\n", "Yuri Malenchenko\n", "Yuri Malenchenko Timothy Peake Timothy Kopra ['Yuri Malenchenko']\n", "Timothy Kopra\n", "Tim Peake\n", "Yuri Malenchenko\n", "Timothy Kopra Tim Peake Yuri Malenchenko ['Timothy Kopra', 'Tim Peake', 'Yuri Malenchenko']\n", "Aleksey Ovchinin\n", "Oleg Skripochka\n", "Jeffrey Williams\n", "Aleksey Ovchinin Oleg Skripochka Jeffrey Williams ['Aleksey Ovchinin', 'Oleg Skripochka', 'Jeffrey Williams']\n", "Jeffrey Williams\n", "Oleg Skripochka\n", "Aleksey Ovchinin\n", "Jeffrey Williams Oleg Skripochka Aleksey Ovchinin ['Jeffrey Williams', 'Oleg Skripochka', 'Aleksey Ovchinin']\n", "Anatoli Ivanishin\n", "Takuya Onishi\n", "Kathleen Rubins\n", "Anatoli Ivanishin Takuya Onishi Kathleen Rubins ['Anatoli Ivanishin', 'Takuya Onishi', 'Kathleen Rubins']\n", "Anatoli Ivanishin\n", "Takuya Onishi\n", "Kathleen Rubins\n", "Anatoli Ivanishin Takuya Onishi Kathleen Rubins ['Anatoli Ivanishin', 'Takuya Onishi', 'Kathleen Rubins']\n", "Shane Kimbrough\n", "Andrei Borisenko\n", "Sergey Ryzhikov\n", "Shane Kimbrough Andrei Borisenko Sergey Ryzhikov ['Shane Kimbrough', 'Andrei Borisenko', 'Sergey Ryzhikov']\n", "Shane Kimbrough\n", "Andrei Borisenko\n", "Sergey Ryzhikov\n", "Shane Kimbrough Andrei Borisenko Sergey Ryzhikov ['Shane Kimbrough', 'Andrei Borisenko', 'Sergey Ryzhikov']\n", "Peggy Whitson\n", "Oleg Novitskiy\n", "Peggy Whitson Oleg Novitskiy Thomas Pesquet ['Peggy Whitson', 'Oleg Novitskiy']\n", "Peggy Whitson\n", "Peggy Whitson ['Peggy Whitson', 'Peggy Whitson']\n", "Oleg Novitskiy\n", "Oleg Novitskiy Thomas Pesquet ['Oleg Novitskiy']\n", "Fyodor Yurchikhin\n", "Jack D. Fischer\n", "Fyodor Yurchikhin Jack D. Fischer ['Fyodor Yurchikhin', 'Jack D. Fischer']\n", "Fyodor Yurchikhin\n", "Jack D. Fischer\n", "Fyodor Yurchikhin Jack D. Fischer ['Fyodor Yurchikhin', 'Jack D. Fischer']\n", "Peggy Whitson\n", "Peggy Whitson ['Peggy Whitson', 'Peggy Whitson']\n", "Randolph Bresnik\n", "Paolo Nespoli\n", "Sergey Ryazansky\n", "Randolph Bresnik Paolo Nespoli Sergey Ryazansky ['Randolph Bresnik', 'Paolo Nespoli', 'Sergey Ryazansky']\n", "Randolph Bresnik\n", "Paolo Nespoli\n", "Sergey Ryazansky\n", "Randolph Bresnik Paolo Nespoli Sergey Ryazansky ['Randolph Bresnik', 'Paolo Nespoli', 'Sergey Ryazansky']\n", "Alexander Misurkin\n", "Mark Vande Hei\n", "Joseph Acaba\n", "Alexander Misurkin Mark Vande Hei Joseph Acaba ['Alexander Misurkin', 'Mark Vande Hei', 'Joseph Acaba']\n", "Alexander Misurkin\n", "Mark Vande Hei\n", "Joseph Acaba\n", "Alexander Misurkin Mark Vande Hei Joseph Acaba ['Alexander Misurkin', 'Mark Vande Hei', 'Joseph Acaba']\n", "Anton Shkaplerov\n", "Scott Tingle\n", "Norishige Kanai\n", "Anton Shkaplerov Scott Tingle Norishige Kanai ['Anton Shkaplerov', 'Scott Tingle', 'Norishige Kanai']\n", "Anton Shkaplerov\n", "Scott Tingle\n", "Norishige Kanai\n", "Anton Shkaplerov Scott Tingle Norishige Kanai ['Anton Shkaplerov', 'Scott Tingle', 'Norishige Kanai']\n", "Andrew Feustel\n", "Oleg Artemyev\n", "Richard Arnold\n", "Andrew Feustel Oleg Artemyev Richard Arnold ['Andrew Feustel', 'Oleg Artemyev', 'Richard Arnold']\n", "Andrew Feustel\n", "Oleg Artemyev\n", "Richard Arnold\n", "Andrew Feustel Oleg Artemyev Richard Arnold ['Andrew Feustel', 'Oleg Artemyev', 'Richard Arnold']\n", "Alexander Gerst\n", "Sergey Prokopyev\n", "Serena Auñón-Chancellor\n", "Alexander Gerst Sergey Prokopyev Serena Auñón-Chancellor ['Alexander Gerst', 'Sergey Prokopyev', 'Serena Auñón-Chancellor']\n", "Alexander Gerst\n", "Sergey Prokopyev\n", "Serena Auñón-Chancellor\n", "Alexander Gerst Sergey Prokopyev Serena Auñón-Chancellor ['Alexander Gerst', 'Sergey Prokopyev', 'Serena Auñón-Chancellor']\n", "Oleg Kononenko\n", "David Saint-Jacques\n", "Anne McClain\n", "Oleg Kononenko David Saint-Jacques Anne McClain ['Oleg Kononenko', 'David Saint-Jacques', 'Anne McClain']\n", "Oleg Kononenko\n", "David Saint-Jacques\n", "Anne McClain\n", "Oleg Kononenko David Saint-Jacques Anne McClain ['Oleg Kononenko', 'David Saint-Jacques', 'Anne McClain']\n", "Oleg Kononenko\n", "David Saint-Jacques\n", "Anne McClain\n", "Oleg Kononenko David Saint-Jacques Anne McClain ['Oleg Kononenko', 'David Saint-Jacques', 'Anne McClain']\n", "Aleksey Ovchinin\n", "Aleksey Ovchinin Christina Koch Nick Hague ['Aleksey Ovchinin']\n" ] } ], "source": [ "for i in df.index:\n", " crew=df.loc[i]['Crew'].replace('\\n','')\n", " crews=find_names(crew,ppls,[])\n", " if crew in ppls:\n", " crews.append(crew)\n", " print(crew,crews)" ] }, { "cell_type": "code", "execution_count": 359, "metadata": { "ExecuteTime": { "end_time": "2019-04-17T01:41:24.552121Z", "start_time": "2019-04-17T01:41:24.535123Z" } }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
ExpeditionLaunch dateDuration(days)
122Expedition 5914 March 2019Will transfer to Expedition 60
\n", "
" ], "text/plain": [ " Expedition Launch date Duration(days)\n", "122 Expedition 59 14 March 2019 Will transfer to Expedition 60" ] }, "execution_count": 359, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.loc[[i]][['Expedition','Launch date','Duration(days)']]" ] } ], "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.7.0" }, "toc": { "base_numbering": 1, "nav_menu": {}, "number_sections": true, "sideBar": true, "skip_h1_title": false, "title_cell": "Table of Contents", "title_sidebar": "Contents", "toc_cell": false, "toc_position": {}, "toc_section_display": true, "toc_window_display": false } }, "nbformat": 4, "nbformat_minor": 2 }