In [1]:

    

import io
import pandas as pd


    

In [2]:

    

epsmembers_csv = 'EuroPython Society Membership Applications - EPS Members.csv'
epsmembers_txt = 'epsmembers.txt'


    

In [3]:

    

df = pd.read_csv(epsmembers_csv, skiprows=6)
df = df[~ df['Member since'].isnull()]


    

In [7]:

    

field   = lambda row, field: row[field].strip()
contact = lambda row: '{}, {} <{}>'.format(field(row, 'First Name'), 
                                           field(row, 'Last Name'), 
                                           field(row, 'EMail')) 
lines = [contact(row) for idx, row in df.iterrows()]


    

In [8]:

    

with io.open(epsmembers_txt, 'w') as f:
    f.write('\n'.join(lines))