misc-executions.ipynb

Kernel: Python 3

remove emails

#%load_ext autoreload
#%autoreload
from oss_hugo.OSS_GSheet_Data import OSS_GSheet_Data
from oss_hugo.API_Hugo_OSS import API_Hugo_OSS
from oss_hugo.OSS_Participant import OSS_Participant

%autoreload
data = OSS_GSheet_Data()
hugo = API_Hugo_OSS()

#grid = hugo.qgrid_participants(['title','email'])
df_gsheet = data.df_participants_onsite(['Name','Chapter Leader'])
df_chapters = df_gsheet[df_gsheet['Chapter Leader'] != '']#[['Name','Chapter Leader']].reset_index(drop=True)
df_chapters

%autoreload

gsheet = OSS_GSheet_Data()
hugo   = API_Hugo_OSS()

df = hugo.df_field('chapter_leader').set_index('title')

'Belgium'

#hugo.df_participants().columns.to_list()

%autoreload
hugo = API_Hugo_OSS()
#participants = hugo.participants_oss()
participants = hugo.participants(return_oss_participants=True)
for name in names:
    print(name, participants.get(name).field('project_leader'))

print('-----')
    
    

Lauren Chiesa 
Sebastien Deleersnyder None
Bart De Win 
Felipe Zipitria 
Azzeddine Ramrami 
Andra Lezza 
Adrian Winckles Web Honeypot & Application Security Curriculum Project
Paulino Calderon IoT Goat
Sam Stepanyan None
-----

hugo.df_participants()[['title','chapter_leader']]
#hugo.qgrid_participants()