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