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)]

	Name	company	Company	Payment Status	GSheet	Hugo

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)]

	Name	company	Company	Payment Status	GSheet	Hugo

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()
    

	Name	company	Company	Payment Status	GSheet	Hugo
55	Adrian Taylor		Photobox	Paid	True	True
100	Adrian Winckles	Anglia Ruskin University			True	True
73	Alicia Barnes		Photobox	Paid	True	True
102	Andra Lezza				True	True
57	Andre Rainho				True	True
41	Andy Cleveland				True	True
30	Artem Vasiuk	Scalepoint	Scalepoint Technologies Denmark A/S	Paid	True	True
27	Ashleigh Eastway			Paid	True	True
7	Ashraf Aboukass		Schroders	Paid	True	True
92	Azzeddine Ramrami				True	True
93	Bart De Win		PWC		True	True
94	Ben Scofield			Paid	True	True
106	Bjoern Kimminich	KUEHNE + NAGEL (AG & Co.) KG	Kühne + Nagel (AG & Co.) KG	Paid	True	True
0	Brett Crawley		Mimecast Ltd	Paid	True	True
14	Brian Johnson			Paid	True	True
101	Carlos Holguera	ESCRYPT GmbH	escrypt		True	True
122	Chris Allen				True	True
85	Chris Cooper		Sure Cloud	Paid	True	True
112	Christoph Jung	Photobox GS	Photobox	Paid	True	True
42	Christopher Dobson		Mimecast Ltd	Paid	True	True
15	Claudio Camerino	The Workshop	Now Training Ltd	Paid	True	True
64	Colin Domoney		Createk Design		True	True
36	Colin Lobley			Paid	True	True
62	Cybil Colaco			Paid	True	True
31	DSC-5			Paid	True	True
69	DSC-6			Paid	True	True
71	Dan Ashby		Photobox	Paid	True	True
79	Daniel Kefer		United Internet	Paid	True	True
35	Dave Snowden			Paid	True	True
98	David Cervigni				True	True
65	David English			Paid	True	True
121	David James-Roll			Paid	True	True
45	David Jensen		Photobox	Paid	True	True
83	Deepak Subramanian		All Set For	Paid	True	True
104	Didar Gelici			Paid	True	True
114	Dinis Cruz	PhotoBox Group	Photobox	Paid	True	True
82	Dominik de Smit	Araido		Paid	True	True
1	EJ Quinn			Paid	True	True
81	Emily Berman		OWASP		True	True
66	Emma Fang		dunnhumby	Paid	True	True
39	Fahad Ahmed		Worth Systems	Paid	True	True
103	Felipe Zipitria				True	True
54	Felix Kariuki			Paid	True	True
43	Florian Buetow		Mimecast Ltd	Paid	True	True
44	Foteini Karantoni		Mimecast Ltd	Paid	True	True
13	Francisco Novo	The Workshop	Now Training Ltd	Paid	True	True
9	Gabor Pek		Avatao	Paid	True	True
68	Geoff Hill	Tutamantic Ltd.	Tutamantic	Paid	True	True
25	George Glass		Photobox	Paid	True	True
48	Goher Mohammad				True	True
3	Hardik Parekh	Splunk	OWASP		True	True
12	Harold Blankenship		OWASP		True	True
47	Hwee Ching Neo			Paid	True	True
88	Irene Michlin			Paid	True	True
119	James Wharton	Photobox GS	Photobox	Paid	True	True
96	Jannik Hollenbach	iteratec GmbH			True	True
86	Jay Mbolda Yamdjeu		United Internet	Paid	True	True
59	Jean-Jacques Moiroux	Mimecast	Mimecast Ltd	Paid	True	True
116	Jemma Davis	JeMarketing Services Ltd	JeMarketing Services Ltd	Paid	True	True
18	Jeroen Beckers		NVISO CVBA	Paid	True	True
110	Jeroen Willemsen	Xebia	Xebia	Paid	True	True
32	Jill McDonald			Paid	True	True
99	Jim Manico				True	True
63	Jim Newman	Jaja Finance		Paid	True	True
37	John Dileo	Orion Health		Paid	True	True
5	John Ellingsworth				True	True
111	Jon Hawes	PhotoBox Group	Photobox	Paid	True	True
60	Karen Navas			Paid	True	True
109	Khaled Fattal	MLi Group			True	True
6	Kim Wuyts		KU Leuven	Paid	True	True
19	Lars Svensson		Sonar Source	Paid	True	True
2	Lauren Chiesa			Paid	True	True
46	Luis Saiz	BBVA		Paid	True	True
117	Maeve Scarry	PhotoBox Group	Photobox	Paid	True	True
29	Marco Mancini			Paid	True	True
123	Mario Platt			Paid	True	True
75	Martin Rock-Evans	UK Hydrographic Office	UKHO	Paid	True	True
38	Michael Duff			Paid	True	True
8	Michael Madsen	Scalepoint Technologies	Scalepoint Technologies Denmark A/S	Paid	True	True
28	Mike McCamon		OWASP		True	True
52	Mustafa Kasmani				True	True
72	Nessim Kisserli			Paid	True	True
61	Nick Drage	Path Dependence Limited		Paid	True	True
91	Patricia Duarte				True	True
124	Paul Davies	Harrods			True	True
23	Paulino Calderon	Websec			True	True
67	Pedro Dantas		Ministry of External Relations of Brazil	Paid	True	True
78	Peter Hicks			Paid	True	True
125	Phil Huggins		CISO Mentor Ltd	Paid	True	True
56	Phil Winstanley	AWS	Amazon Data Services Ireland Ltd	Paid	True	True
4	Philippe De Ryck		Pragmatic Web Security	Paid	True	True
70	Pravinder Arora			Paid	True	True
50	Rafael Jimenez		Now Training Ltd	Paid	True	True
40	Rebecca Ditchburn			Paid	True	True
77	Robert Grace		JeMarketing Services Ltd	Paid	True	True
26	Roberto Pérez			Paid	True	True
58	Roger Comastorres				True	True
105	Sam Stepanyan				True	True
20	Sara Davis	Centerprise International		Paid	True	True
51	Sarah Clark			Paid	True	True
22	Scott Hayward			Paid	True	True
74	Sean Siford	UK Hydrographic Office	UKHO	Paid	True	True
80	Sean Turner		Crypto Facilities	Paid	True	True
33	Sebastian Arriada	Globant	Globant	Paid	True	True
107	Sebastien Deleersnyder	Toreon	Toreon		True	True
97	Sherif Mansour				True	True
95	Simon Bennetts		OWASP	Paid	True	True
120	Simon Pavillon	Photobox GS	Photobox	Paid	True	True
89	Simon Wardley		Photobox	Paid	True	True
118	Sonya Moisset	PhotoBox Group	Photobox	Paid	True	True
108	Steven Wierckx	Toreon	Toreon		True	True
21	Steven van der Baan			Paid	True	True
17	Sven Schleier			Paid	True	True
53	Tanja Peeters		Accelerate IT	Paid	True	True
113	Tash Norris	PhotoBox Group	Photobox	Paid	True	True
10	Tom Ling		UKHO	Paid	True	True
84	Tony Richards	TYR Industries Ltd		Paid	True	True
49	William Devos				True	True
76	Wouter de Meijer		Worth Internet Systems	Paid	True	True
87	Xavier Delgado		Interpartner Assistance Servicios SA	Paid	True	True
34	Yan Kravchenko		OWASP		True	True
115	Yasmin Martin	Photobox	Photobox	Paid	True	True
90	Zsolt Kalman		Avatao	Paid	True	True
16	Zuhal Vargun		Mimecast Ltd	Paid	True	True

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()

|