participants-oss2019.ipynb

Kernel: Python 3

participants-oss2019

Cells related to loading and parsing participant data (using Hugo_Pages API)

%load_ext autoreload
%autoreload
from oss_hugo.API_Hugo_OSS import API_Hugo_OSS
hugo = API_Hugo_OSS()

The autoreload extension is already loaded. To reload it, use:
  %reload_ext autoreload

hugo.qgrid_merged_gsheet_and_hugo_data()

QgridWidget(grid_options={'fullWidthRows': True, 'syncColumnCellResize': True, 'forceFitColumns': True, 'defau…

df_both.groupby('Payment Status').count()['Name'].plot.pie(table=True)

<matplotlib.axes._subplots.AxesSubplot at 0x7fda149835f8>

df_gsheet = hugo.gsheet_data().df_participants_onsite().set_index('Name')
df_gsheet['source'] = 'gsheet'
df_gsheet

"{0} - {1}".format(len(df_hugo), len(df_gsheet))

'82 - 114'

participants = hugo.participants()
mappings = [
    {  'title': value.get('metadata').get('title'),
       'file' : key } 
        for key,value in participants.items()]

df = pd.DataFrame(mappings).set_index('file')
df.tail()
#qgrid.show_grid(df)

df_columns = pd.DataFrame(api.participants_metadatas()).columns
df_columns

Index(['chapter-leader', 'chapter_leader', 'company', 'email', 'eventbrite_id',
       'facebook', 'featured', 'funded_who', 'image', 'job-title', 'job_title',
       'layout', 'linkedin', 'linkedin-company-beta', 'night_day',
       'night_room', 'night_where', 'notes', 'post-summit', 'pre-summit',
       'pre_summit', 'project-leader', 'project_leader', 'regonline', 'role',
       'sessions', 'slack_id', 'sponsored_by', 'status', 'ticket', 'title',
       'tracks', 'travel-from', 'travel_from', 'twitter', 'type', 'venue',
       'villa', 'website', 'working-sessions'],
      dtype='object')

pd.DataFrame(df_columns)