diff-of-participants-between-gsheet-and-hugo.ipynb

Kernel: Python 3

Diff of Participants between GSheet and Hugo

This view shows the current diff/gaps between both data sources

Users only in GSheet

df_both = hugo.df_merged_gsheet_and_hugo_data()

def filter(row):
    return row.get('GSheet') is True and row.get('Hugo') is not True

df_both[df_both.apply(filter,axis=1)]

Users only in Hugo

df_both = hugo.df_merged_gsheet_and_hugo_data()

def filter(row):
    return row.get('GSheet') is not True and row.get('Hugo') is True

df_both[df_both.apply(filter,axis=1)]

Color code differences

The DataFrame below marks in Red the cells that need fixing

df_both = hugo.df_merged_gsheet_and_hugo_data(True)
def compare_values(row):
    colors = ['background-color: '] * len(row)
    if not row['GSheet']:
        colors[4] = 'background-color: pink'
    if not row['Hugo']:
        colors[5] = 'background-color: pink'
    return colors

df_both.sort_values('Name').style.apply(compare_values, axis=1)._compute()
    

Explore Data (all Data)

the Data Grid below is a great way to explore and filter the data

hugo.qgrid_merged_gsheet_and_hugo_data()

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

|