In [2]:

    

import pandas as pd

coauthors = pd.read_csv('coauthors.csv')
coauthors.head()


    

    
Out[2]:






  

    

      

      
name
      
status
      
citation
    
  
  

    

      
0
      
Yan Song
      
submitted
      
Yan Song, Olga B Botvinnik, Michael T Lovci, B...
    
    

      
1
      
Michael T Lovci
      
submitted
      
Yan Song, Olga B Botvinnik, Michael T Lovci, B...
    
    

      
2
      
Boyko Kakaradov
      
submitted
      
Yan Song, Olga B Botvinnik, Michael T Lovci, B...
    
    

      
3
      
Patrick Liu
      
submitted
      
Yan Song, Olga B Botvinnik, Michael T Lovci, B...
    
    

      
4
      
Jia L Xu
      
submitted
      
Yan Song, Olga B Botvinnik, Michael T Lovci, B...
    
  

In [ ]:

    

myfirst, mylast = 'Olga Borisvona', 'Botvinnik'

texts = {'published': '{myfirst} {mylast} has my permission to include the following paper,'
         ' of which I was a co-author, in her doctoral dissertation.',
        'submitted': '{myfirst} {mylast} has my permission to include the following paper '
         'which was submitted for publication, of which I was a co-author, in her doctoral dissertation.',
        'in preparation': '{myfirst} {mylast} has my permission to include material, currently '
         'being prepared for submission for publication, of which I was a co-author, in her doctoral dissertation'}

for coauthor, df in coauthors.groupby('name'):
    for status, i, paper in df.iterrows():