edit-or-delete-fields.ipynb

Kernel: Python 3

Edit or detete participant fields

Notebook used to do batch edits or deletions of participant's fields

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

fields_to_delete = ['night_day','eventbrite_id','funded_who','night_room','regonline','pre-summit',
                     'sponsored_by','venue','villa']
hugo.df_participants()[fields_to_delete].tail()

#Deleting multiple fields
%autoreload
fields_to_delete = ['night_day','eventbrite_id','funded_who','night_room','regonline','pre-summit',
                     'sponsored_by','venue','villa']

md_participants = hugo.md_files_participants()
for md_participant in md_participants:
    participant     = OSS_Participant(md_participant)
    for field_to_delete in fields_to_delete:
        participant.delete_field(field_to_delete)
    participant.save()    
    

"removed {0} fields from {1} files".format(len(fields_to_delete), len(md_participants))

'removed 9 fields from 126 files'

#deleting email field
from oss_hugo.OSS_Participant import OSS_Participant
md_participants = hugo.md_files_participants()
for md_participant in md_participants:
    participant     = OSS_Participant(md_participant)
    participant.delete_field('email', auto_save=True)
    
"all done"  #check change in git   

'all done'

hugo.df_participants().columns

Index(['chapter_leader', 'company', 'email', 'facebook', 'featured', 'image',
       'job_title', 'layout', 'linkedin', 'night_where', 'notes', 'pre_summit',
       'project_leader', 'role', 'sessions', 'status', 'title', 'tracks',
       'travel-from', 'travel_from', 'twitter', 'type', 'website',
       'working_sessions'],
      dtype='object')

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

gsheet=OSS_GSheet_Data()

df_gsheet = gsheet.df_participants_onsite()

#df_gsheet[df_gsheet['Chapter Leader'] != '']

#df_gsheet[df_gsheet['Project Leader'] != '']