In [1]:
import pandas as pd

In [2]:
url='https://en.wikipedia.org/wiki/List_of_International_Space_Station_expeditions'

In [3]:
#!pip install beautifulsoup4

In [4]:
import bs4
import requests
r=requests.get(url)
soup = bs4.BeautifulSoup(r.content)
tables=soup.findAll("table")

In [75]:
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:
            aas=tr.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']


Expedition 1


William M. Shepherd

Sergei Krikalev

Yuri Gidzenko
Soyuz TM-31
STS-102
Expedition 2


Yuri Usachev

James S. Voss

Susan J. Helms
STS-102
STS-105
Expedition 3


Frank L. Culbertson

Mikhail Tyurin

Vladimir Dezhurov
STS-105
STS-108
Expedition 4


Yury Onufrienko

Carl E. Walz

Daniel W. Bursch
STS-108
STS-111
Expedition 5


Valery Korzun

Sergei Treshchev

Peggy A. Whitson
STS-111
STS-113
Expedition 6


Kenneth D. Bowersox

Donald R. Pettit

Nikolai Budarin
STS-113
Soyuz TMA-1
Expedition 7


Yuri Malenchenko

Edward T. Lu
Soyuz TMA-2
Soyuz TMA-2
Expedition 8


C. Michael Foale

Alexander Kaleri
Soyuz TMA-3
Soyuz TMA-3
Expedition 9


Gennady Padalka

E. Michael Fincke
Soyuz TMA-4
Soyuz TMA-4
Expedition 10


Leroy Chiao

Salizhan Sharipov
Soyuz TMA-5
Soyuz TMA-5
Expedition 11


Sergei Krikalev

John L. Phillips
Soyuz TMA-6
Soyuz TMA-6
Expedition 12


William S. McArthur

Valeri Tokarev
Soyuz TMA-7
Soyuz TMA-7
Expedition 13


Pavel Vinogradov

Jeffrey N. Williams
Soyuz TMA-8
Soyuz TMA-8

Thomas Reiter
STS-121
Expedition 14


Michael E. Lopez-Alegria

Mikhail Tyurin
Soyuz TMA-9
Soyuz TMA-9

Thomas Reiter
STS-116

Sunita L. Williams
STS-116
Expedition 15


Fyodor Yurchikhin

Oleg Kotov
Soyuz TMA-10
Soyuz TMA-10

Sunita L. Williams
STS-117

Clayton C. Anderson
STS-117
Expedition 16


Peggy A. Whitson

Yuri Malenchenko
Soyuz TMA-11
Soyuz TMA-11

Clayton C. Anderson
STS-120

Daniel M. Tani
STS-120
STS-122

Léopold Eyharts
STS-122
STS-123

Garrett E. Reisman
STS-123
Expedition 17


Sergey Volkov

Oleg Kononenko
Soyuz TMA-12
Soyuz TMA-12

Garrett E. Reisman
STS-124

Gregory E. Chamitoff
STS-124
Expedition 18


E. Michael Fincke

Yuri Lonchakov
Soyuz TMA-13
Soyuz TMA-13

Gregory E. Chamitoff
STS-126

Sandra H. Magnus
STS-126
STS-119

Koichi Wakata
STS-119
Expedition 19


Gennady Padalka

Michael R. Barratt
Soyuz TMA-14

Koichi Wakata
Expedition 20


Gennady Padalka

Michael R. Barratt
Soyuz TMA-14

Koichi Wakata
STS-127

Timothy L. Kopra
STS-127
STS-128

Frank De Winne

Roman Romanenko

Robert B. Thirsk
Soyuz TMA-15

Nicole P. Stott
STS-128
Expedition 21


Frank De Winne

Roman Romanenko

Robert B. Thirsk
Soyuz TMA-15

Nicole P. Stott
STS-129

Jeffrey N. Williams

Maksim Surayev
Soyuz TMA-16
Expedition 22


Jeffrey N. Williams

Maksim Surayev
Soyuz TMA-16

Oleg Kotov

Timothy J. Creamer

Soichi Noguchi
Soyuz TMA-17
Expedition 23


Oleg Kotov

Timothy J. Creamer

Soichi Noguchi
Soyuz TMA-17

Aleksandr Skvortsov

Mikhail Korniyenko

Tracy E. Caldwell Dyson
Soyuz TMA-18
Expedition 24


Aleksandr Skvortsov

Mikhail Korniyenko

Tracy E. Caldwell Dyson
Soyuz TMA-18

Douglas H. Wheelock

Shannon Walker

Fyodor Yurchikhin
Soyuz TMA-19
Expedition 25


Douglas H. Wheelock

Shannon Walker

Fyodor Yurchikhin
Soyuz TMA-19

Scott J. Kelly

Aleksandr Kaleri

Oleg Skripochka
Soyuz TMA-01M
Expedition 26


Scott J. Kelly

Aleksandr Kaleri

Oleg Skripochka
Soyuz TMA-01M

Dimitri Kondratyev

Catherine G. Coleman

Paolo Nespoli
Soyuz TMA-20
Expedition 27


Dimitri Kondratyev

Catherine G. Coleman

Paolo Nespoli
Soyuz TMA-20

Andrei Borisenko

Aleksandr Samokutyayev

Ronald J. Garan
Soyuz TMA-21
Expedition 28


Andrei Borisenko

Aleksandr Samokutyayev

Ronald J. Garan
Soyuz TMA-21

Michael E. Fossum

Sergey Volkov

Satoshi Furukawa
Soyuz TMA-02M
Expedition 29


Michael E. Fossum

Sergey Volkov

Satoshi Furukawa
Soyuz TMA-02M

Daniel C. Burbank

Anton Shkaplerov

Anatoli Ivanishin
Soyuz TMA-22
Expedition 30


Daniel C. Burbank

Anton Shkaplerov

Anatoli Ivanishin
Soyuz TMA-22

Oleg Kononenko

Donald R. Pettit

André Kuipers
Soyuz TMA-03M
Expedition 31


Oleg Kononenko

Donald R. Pettit

André Kuipers
Soyuz TMA-03M

Gennady Padalka

Sergei Revin

Joseph M. Acaba
Soyuz TMA-04M
Expedition 32


Gennady Padalka

Sergei Revin

Joseph M. Acaba
Soyuz TMA-04M

Sunita L. Williams

Yuri Malenchenko

Akihiko Hoshide
Soyuz TMA-05M
Expedition 33


Sunita L. Williams

Yuri Malenchenko

Akihiko Hoshide
Soyuz TMA-05M

Kevin A. Ford

Oleg Novitskiy

Evgeny Tarelkin
Soyuz TMA-06M
Expedition 34


Kevin A. Ford

Oleg Novitskiy

Evgeny Tarelkin
Soyuz TMA-06M

Chris Hadfield

Roman Romanenko

Thomas H. Marshburn
Soyuz TMA-07M
Expedition 35


Chris Hadfield

Roman Romanenko

Thomas H. Marshburn
Soyuz TMA-07M

Pavel Vinogradov

Aleksandr Misurkin

Christopher J. Cassidy
Soyuz TMA-08M
Expedition 36


Pavel Vinogradov

Aleksandr Misurkin

Christopher J. Cassidy
Soyuz TMA-08M

Fyodor Yurchikhin

Karen L. Nyberg

Luca Parmitano
Soyuz TMA-09M
Expedition 37


Fyodor Yurchikhin

Karen L. Nyberg

Luca Parmitano
Soyuz TMA-09M

Oleg Kotov

Sergey Ryazansky

Michael S. Hopkins
Soyuz TMA-10M
Expedition 38


Oleg Kotov

Sergey Ryazansky

Michael S. Hopkins
Soyuz TMA-10M

Koichi Wakata

Mikhail Tyurin

Richard A. Mastracchio
Soyuz TMA-11M
Expedition 39


Koichi Wakata

Mikhail Tyurin

Richard A. Mastracchio
Soyuz TMA-11M

Aleksandr Skvortsov

Oleg Artemyev

Steven R. Swanson
Soyuz TMA-12M
Expedition 40


Steven R. Swanson

Aleksandr Skvortsov

Oleg Artemyev
Soyuz TMA-12M

Gregory R. Wiseman

Maksim Surayev

Alexander Gerst
Soyuz TMA-13M
Expedition 41


Maksim Surayev

Gregory R. Wiseman

Alexander Gerst
Soyuz TMA-13M

Aleksandr Samokutyayev

Yelena Serova

Barry E. Wilmore
Soyuz TMA-14M
Expedition 42


Barry E. Wilmore

Aleksandr Samokutyayev

Yelena Serova
Soyuz TMA-14M

Anton Shkaplerov

Samantha Cristoforetti

Terry W. Virts
Soyuz TMA-15M
Expedition 43


Terry W. Virts

Anton Shkaplerov

Samantha Cristoforetti
[1]
[2]
Soyuz TMA-15M

Gennady Padalka
Soyuz TMA-16M

Mikhail Korniyenko

Scott J. Kelly
one year mission

Expedition 44


Gennady Padalka
[3]
Soyuz TMA-16M

Mikhail Korniyenko

Scott J. Kelly
one year mission


Oleg Kononenko

Kimiya Yui

Kjell N. Lindgren
[4]
Soyuz TMA-17M
Expedition 45


Scott J. Kelly

Mikhail Korniyenko

Oleg Kononenko

Kimiya Yui

Kjell N. Lindgren
Soyuz TMA-17M

Sergey Volkov
Soyuz TMA-18M
Expedition 46


Scott J. Kelly

Mikhail Korniyenko
Soyuz TMA-18M
[n 1]
[5]

Sergey Volkov
[n 2]

Yuri Malenchenko

Timothy Peake

Timothy Kopra
Soyuz TMA-19M
Expedition 47


Timothy Kopra

Tim Peake

Yuri Malenchenko
[6]
Soyuz TMA-19M

Aleksey Ovchinin

Oleg Skripochka

Jeffrey Williams
Soyuz TMA-20M
Expedition 48


Jeffrey Williams

Oleg Skripochka

Aleksey Ovchinin
[7]
Soyuz TMA-20M
[8]

Anatoli Ivanishin

Takuya Onishi

Kathleen Rubins
[9]
Soyuz MS-01
Expedition 49


Anatoli Ivanishin

Takuya Onishi

Kathleen Rubins
[10]
Soyuz MS-01

Shane Kimbrough

Andrei Borisenko

Sergey Ryzhikov
[11]
Soyuz MS-02
Expedition 50


Shane Kimbrough

Andrei Borisenko

Sergey Ryzhikov
Soyuz MS-02

Peggy Whitson

Oleg Novitskiy

Thomas Pesquet
Soyuz MS-03
Expedition 51


Peggy Whitson

Oleg Novitskiy

Thomas Pesquet
Soyuz MS-03

Fyodor Yurchikhin

Jack D. Fischer
Soyuz MS-04
Expedition 52


Fyodor Yurchikhin

Jack D. Fischer
Soyuz MS-04
[12]

Peggy Whitson
[n 3]
[13]

Randolph Bresnik

Paolo Nespoli

Sergey Ryazansky
Soyuz MS-05
Expedition 53


Randolph Bresnik

Paolo Nespoli

Sergey Ryazansky
[14]
Soyuz MS-05

Alexander Misurkin

Mark Vande Hei

Joseph Acaba
Soyuz MS-06
Expedition 54


Alexander Misurkin

Mark Vande Hei

Joseph Acaba
Soyuz MS-06

Anton Shkaplerov

Scott Tingle

Norishige Kanai
Soyuz MS-07
Expedition 55


Anton Shkaplerov

Scott Tingle

Norishige Kanai
Soyuz MS-07

Andrew Feustel

Oleg Artemyev

Richard Arnold
[15]
Soyuz MS-08
Expedition 56


Andrew Feustel

Oleg Artemyev

Richard Arnold
[16]
Soyuz MS-08

Alexander Gerst

Sergey Prokopyev

Serena Auñón-Chancellor
Soyuz MS-09
Expedition 57


Alexander Gerst

Sergey Prokopyev

Serena Auñón-Chancellor
Soyuz MS-09

Oleg Kononenko

David Saint-Jacques

Anne McClain
Soyuz MS-11
Expedition 58


Oleg Kononenko

David Saint-Jacques

Anne McClain
Expedition 59


Oleg Kononenko

David Saint-Jacques

Anne McClain
Soyuz MS-11

Aleksey Ovchinin

Christina Koch

Nick Hague
Soyuz MS-12

In [76]:
df=pd.read_html(url)
df=pd.concat(df[:2]).reset_index()

In [77]:
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

In [78]:
ppls


Out[78]:
{'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'}

In [72]:
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']

In [359]:
df.loc[[i]][['Expedition','Launch date','Duration(days)']]


Out[359]:
Expedition Launch date Duration(days)
122 Expedition 59 14 March 2019 Will transfer to Expedition 60