In [1]:
import pandas as pd
import numpy as np
import itertools
In [2]:
data = pd.read_csv('data/inspiration_filtered.csv')
In [3]:
data.sort_values(by='wmd')
Out[3]:
Unnamed: 0
id
core_id
name
description
core_name
core_description
wmd
wmd_name
batch_number
type
created_at
updated_at
valuable_score
150
332348
dff333f8-a96b-42da-aed9-7e47562a99b0
36b17e7a-5d9f-4c7c-8161-a807a0a2ac50
Lyft PeopleDev
https://sites.google.com/lyft.com/peopledev
Share Learnings with Other Organizations
Share stories about your internal approaches t...
0.180664
0.105090
4
cust_ins
2018-05-31 19:53:24.849510
2018-05-31 20:06:55.939990
0.002920
246
277279
c8668e2c-8d9d-4fb9-b067-bc72fb4393cf
0a64418d-5fef-4676-afc5-19d2981ba4d2
Lyft PeopleDev
https://sites.google.com/lyft.com/peopledev/ma...
Amp your inclusion training
Hosting unconscious bias, LGBTQ and gender inc...
0.206421
0.191761
4
cust_ins
2018-05-31 20:07:43.726350
2018-05-31 20:16:11.975016
0.002920
136
277173
e2bac286-2111-4475-9872-64bc9a342808
0a64418d-5fef-4676-afc5-19d2981ba4d2
Lyft PeopleDev
https://sites.google.com/lyft.com/peopledev/ma...
Amp your inclusion training
Hosting unconscious bias, LGBTQ and gender inc...
0.206421
0.191761
4
cust_ins
2018-05-31 20:06:55.927448
2018-05-31 20:12:59.490761
0.002920
299
277136
b87f9dfd-68a3-41f3-ab82-18d13f9c063f
0a64418d-5fef-4676-afc5-19d2981ba4d2
Lyft PeopleDev
https://sites.google.com/lyft.com/peopledev/ma...
Amp your inclusion training
Hosting unconscious bias, LGBTQ and gender inc...
0.206421
0.191761
4
cust_ins
2018-05-31 19:52:01.585750
2018-05-31 20:03:26.655391
0.002920
35
147453
f95d3cd1-fdfa-4483-a9ae-6286be8438eb
e21c4fd3-11a9-4421-b6fc-a993f30e7ec6
Trail: Salesforce Buyers Introduction
[Salesforce Buyers Introduction Trail](https:/...
Create an experimentation metric
Track the volume of experiments and their outc...
0.210052
0.142608
4
cust_ins
2018-05-29 00:12:12.600933
2018-05-29 00:12:12.677161
0.000000
1007
259832
04a17439-2baf-4758-bafe-65b1c049e45a
f5a27e7f-fc10-4feb-9a27-1fa03e7f2bdb
Lyft PeopleDev
COMING SOON! https://sites.google.com/lyft.com...
Improvisation classes
Attend improvisation classes. Most causes of s...
0.211164
0.145992
4
cust_ins
2018-05-31 20:03:26.640226
2018-05-31 20:07:43.736957
0.011276
162
259602
dc9c3dd1-8d03-46c9-8413-0829c1c03cf4
f5a27e7f-fc10-4feb-9a27-1fa03e7f2bdb
Lyft PeopleDev
COMING SOON! https://sites.google.com/lyft.com...
Improvisation classes
Attend improvisation classes. Most causes of s...
0.211164
0.145992
4
cust_ins
2018-05-31 20:16:11.968704
2018-05-31 20:17:29.717270
0.011276
603
180718
6bcb70b8-4cc6-457e-8385-2d28ed992332
824d523f-8813-4af1-b0d0-b7b032e4ab58
Trail: Customer-Centric Discovery Basics
[Customer-Centric Discovery Basics Trail](http...
Track customer requests
Keep a public log of customer requests. One or...
0.213914
0.348472
4
cust_ins
2018-05-29 00:12:12.557070
2018-05-29 00:12:12.630604
0.000000
398
259521
a1158c9d-14d7-4c54-bd52-55870a90bc90
f5a27e7f-fc10-4feb-9a27-1fa03e7f2bdb
Trail: Becoming Salesforce
[Our Becoming Salesforce Adventure Trail](http...
Improvisation classes
Attend improvisation classes. Most causes of s...
0.215031
0.084022
4
cust_ins
2018-05-29 00:12:12.575624
2018-05-29 00:12:12.651060
0.000000
341
259357
ad19b3c0-3b5c-43cf-8bc9-11742d6ffab2
f5a27e7f-fc10-4feb-9a27-1fa03e7f2bdb
Trail: Becoming Salesforce
[Our Becoming Salesforce Adventure Trail](http...
Improvisation classes
Attend improvisation classes. Most causes of s...
0.215031
0.084022
4
cust_ins
2018-05-29 00:12:09.157144
2018-05-29 00:12:09.209579
0.000000
295
259562
b97156e3-fe35-489c-afaa-e6e363a94e91
f5a27e7f-fc10-4feb-9a27-1fa03e7f2bdb
Trail: Becoming Salesforce
[Our Becoming Salesforce Adventure Trail](http...
Improvisation classes
Attend improvisation classes. Most causes of s...
0.215031
0.084022
4
cust_ins
2018-05-29 00:12:13.171543
2018-05-29 00:12:13.225649
0.000000
442
97267
95bcf8f6-8ddf-4ff5-b162-79fb0dd44fd2
1f766426-738e-4b8c-a486-1dfbc8ff5430
Stretch roles
Support learning through stretch roles
Stretch roles
Support learning by providing stretch roles. P...
0.243200
1.000000
4
cust_ins
2018-05-22 03:37:39.641562
2018-05-22 03:38:03.687830
0.034357
656
97568
608f6979-d558-43d1-b500-babdc4e64d21
1f766426-738e-4b8c-a486-1dfbc8ff5430
Stretch roles
Support learning through stretch roles
Stretch roles
Support learning by providing stretch roles. P...
0.243200
1.000000
4
cust_ins
2018-05-04 14:20:35.081063
2018-05-04 14:20:35.094105
0.034357
422
13636
9b1121e9-3419-44b3-b8a9-5ed6f999a572
cd6c7724-5da6-4a10-aff2-7f0e29a3ba73
link testing
blah blah blah\n\nhttps://cultureamp.cultuream...
Team growth exercise
To facilitate team alignment on goals, one com...
0.263894
0.165394
4
cust_ins
2018-05-23 01:22:43.601553
2018-05-23 01:23:36.312059
0.015341
851
340086
2fd8d42a-8137-4a28-b96c-d8f626daae51
8e4eeaa5-21fd-4488-8ac1-f8fd7ae295e2
Hold leader-led sessions, townhalls, etc
Hold frequent leader-facilitated ask-me-anythi...
AMA session
Schedule an Ask-me-anything (AMA) session wher...
0.265721
0.194220
4
cust_ins
2018-05-04 17:34:48.356227
2018-05-04 17:34:48.374813
0.002920
709
37381
5378e2de-9357-43db-a10d-f4a4022129a3
2110915a-35aa-4f18-9efc-e18e8a814f89
Safety Briefing
Start every meeting with a safety briefing
Meeting Manifesto
Improve meeting effectiveness using clear guid...
0.268131
0.179262
4
cust_ins
2018-05-21 18:18:57.115000
2018-05-21 18:19:55.814596
0.000000
118
77168
e690072e-62dd-4885-ac26-13f55b239b73
36f86eea-f614-4ef6-8abf-5b277eb76b2f
Promote employee skills-sharing
Promote employee skills sharing sessions.
Skills sessions
Hold brown-bag employee skill sharing sessions...
0.272505
0.339092
4
cust_ins
2018-05-04 17:41:21.624915
2018-05-04 17:41:21.638752
0.006263
550
14856
77d985c5-3aba-48a3-b00c-cd3feb2db11e
905e2ce6-cfae-4be0-aaf0-55b914abfcde
Google Alert
Set Google Alerts to receive news about our co...
Vacation discounts
Make special vacations a reality for employees...
0.281480
0.082437
4
cust_ins
2018-05-21 18:40:13.319867
2018-05-21 18:41:29.563794
0.000000
17
151860
fb274083-528c-488f-994e-603ffa71cbc3
931d7762-9fa4-4a3f-85e3-f8bf75f8f903
Talking Customer
Add a customer update in your meetings\n
Celebrate New Learning
Acknowledge team members who share the most le...
0.281890
0.108444
4
cust_ins
2018-05-21 18:44:14.101198
2018-05-21 18:45:22.681595
0.031900
149
65218
e06c0d18-ba72-460b-8553-f5c491cc9bba
e83552a4-1093-49c7-9d4b-d85852036b8e
Video: Why We Do What We Do
[Daniel Pink's keynote at the 2013 REACH confe...
Team question for all hands
Asking questions at an all hands meeting can b...
0.284410
0.153545
4
cust_ins
2018-05-29 00:12:14.646808
2018-05-29 00:12:14.695130
0.000000
414
65324
9d2ad42b-6c23-4f61-bc9a-fd91db8f9eec
e83552a4-1093-49c7-9d4b-d85852036b8e
The Art of Crucial Conversations
[Joseph Grenny's keynote speech at the 2015 Vi...
Team question for all hands
Asking questions at an all hands meeting can b...
0.291460
0.178977
4
cust_ins
2018-05-29 00:12:15.667546
2018-05-29 00:12:15.715928
0.004871
404
34246
9f85771f-1109-49ce-a7e7-9970abbd23e6
a4ad8230-e1e5-41d8-a5ca-88851c032190
Model good feedback behaviors
Model and encourage providing frequent candid ...
More frequent feedback
Increase the cadence of feedback for employees...
0.293837
0.333144
4
cust_ins
2018-05-04 17:14:49.429317
2018-05-04 17:14:49.443041
0.048122
117
301469
e6951227-6f6e-40c6-ac1f-61dc291d2dbf
af2e387e-8b2b-4617-8996-dd715ef710ae
Video: Fireside Chat with Marc Benioff
[An interview with Marc, discussing Salesforce...
Pronouns and names
Create a pronoun and name field (in addition t...
0.294153
0.134742
4
cust_ins
2018-05-29 00:12:12.629620
2018-05-29 00:12:12.704302
0.000000
107
321483
e829c849-ab18-40a7-b098-237549f332a0
56d9dd9f-e712-4b19-b7cf-fb24f7fd7c79
Video: Why We Do What We Do
[Tony Robbins discusses the "invisible forces"...
Evaluate Decision Criteria
Decide on the criteria you’ll use to make a de...
0.297611
0.106834
4
cust_ins
2018-05-29 00:12:14.581941
2018-05-29 00:12:14.634903
0.017752
828
266397
35af4f3a-369d-43cb-8e2f-ca72dec357ec
fb4c7961-c446-4caa-b61d-ad72c125aace
Talk about information flows with team
Regularly address how information flows about ...
Strategy field trip
Take your team to speak with other teams that ...
0.298560
0.162683
4
cust_ins
2018-05-04 17:15:06.633487
2018-05-04 17:15:06.639994
0.008680
867
167051
2a16fd6a-815d-4393-bf0e-2d3ec1bff499
ca553da7-d295-4b17-a4d4-3766f0e8a27d
Open Program: Performance Improvement
Complete the Driving Performance Improvement o...
Living our values
Help employees live company values. One compan...
0.299733
0.120088
4
cust_ins
2018-05-29 00:12:09.791771
2018-05-29 00:12:09.851101
0.036787
40
167673
f894ed3e-7d48-4cfc-b851-b7463969fbfb
ca553da7-d295-4b17-a4d4-3766f0e8a27d
Open Program: Performance Improvement
Complete the Driving Performance Improvement o...
Living our values
Help employees live company values. One compan...
0.299733
0.120088
4
cust_ins
2018-05-29 00:12:18.398263
2018-05-29 00:12:18.447435
0.036787
477
302567
8d0df274-a2fa-4b28-aff7-a2dfded99356
6f14c27e-cc98-4bdb-8846-00f0e18cc369
Trail: Organizational Change
[Organisational Change Leadership] (https://tr...
Spotlight on Leadership Team Diversity
Share the success (and failure) stories of peo...
0.299956
0.143967
4
cust_ins
2018-05-29 00:12:17.647498
2018-05-29 00:12:17.694708
0.000000
366
51590
a71a5ebe-4ae5-4b4f-9001-a579a3746962
6008dc8e-fc71-4731-9b27-f6036b0cea20
Seek leader sponsorship
Seek visible and engaged leader sponsorship fo...
Project-based recognition norms
Establish reward and recognition programs at a...
0.305815
0.141347
4
cust_ins
2018-05-04 17:34:30.193565
2018-05-04 17:34:30.200449
0.000000
924
140499
1aa2be02-8290-4f87-9834-144f947d12a3
dee6e4e7-a969-495e-93f8-0069e3f958f8
Work on stretch goals
Identify stretch goals to work on.
One day hackathon
Enable teams to work on passion projects that ...
0.312604
0.100212
4
cust_ins
2018-05-04 17:13:47.505525
2018-05-04 17:13:47.512933
0.009668
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
531
143859
7cb7dd92-dd78-4d30-81bf-5cf9d5768594
94a79e2b-effb-496d-8b1d-ea7550aa8448
Gold card
Find creative ways to empower your team to foc...
Gold card
Find creative ways to empower your team to foc...
1.000000
1.000000
4
cust_ins
2018-05-29 00:12:11.176625
2018-05-29 00:12:11.226098
0.000000
530
80938
7d11b548-0148-437a-bd2d-232c72ef55d4
9ab28f2f-428b-4340-9aed-aba370107d02
Internal job board
Ensure all employees are given a fair chance t...
Internal job board
Ensure all employees are given a fair chance t...
1.000000
1.000000
4
cust_ins
2018-05-28 06:07:27.393598
2018-05-28 06:07:27.407968
0.000000
597
156860
6d81a9e4-59ab-4da1-8ba8-a9cbe76c5da1
f8ede102-eeae-4272-8f5d-ae2b111fa26b
Monthly webinar
Keep employees connected and involved with the...
Monthly webinar
Keep employees connected and involved with the...
1.000000
1.000000
4
cust_ins
2018-05-18 03:17:39.127993
2018-05-18 03:17:39.133705
0.000000
599
161900
6d30005f-a395-4125-83eb-2c624924ae07
90ea3054-c962-401e-abcc-d2697f14d0ad
Storytelling
Help leaders communicate your organization's v...
Storytelling
Help leaders communicate your organization's v...
1.000000
1.000000
4
cust_ins
2018-05-29 00:12:09.588586
2018-05-29 00:12:09.636103
0.000000
86
16129
ee2bc2bd-0fb2-4947-a092-e2cf65cd3a1f
1a1ac666-87a8-46bc-8511-04157a9c9a72
Onboarding at headquarters
To get employees onboarded and contributing qu...
Onboarding at headquarters
To get employees onboarded and contributing qu...
1.000000
1.000000
4
cust_ins
2018-05-29 00:12:12.812613
2018-05-29 00:12:12.884138
0.000000
608
101494
6ab13c2e-6184-4e4f-bd24-e6c45bc6b19f
ee56489b-1a43-4028-9c8f-9bbd80dfe5b8
What's in the tool-shed?
Take inventory of the tools and resources peop...
What's in the toolshed?
Take inventory of the tools and resources peop...
1.000000
0.771765
4
cust_ins
2018-05-28 06:51:47.161399
2018-05-28 06:53:56.036347
0.000000
660
34059
602cb6bf-2955-4b75-b68e-4de9213641a4
a4ad8230-e1e5-41d8-a5ca-88851c032190
More frequent feedback
Increase the cadence of feedback for employees...
More frequent feedback
Increase the cadence of feedback for employees...
1.000000
1.000000
4
cust_ins
2018-05-22 03:36:37.564939
2018-05-22 03:36:59.208467
0.000000
70
100874
f0fd4127-ba6d-43b0-bcd3-c263c985b791
c02e3dfc-85f6-4d51-b209-4f0876ee61bd
Publicizing aspirations
Make career goals public within the company. A...
Publicizing aspirations
Make career goals public within the company. A...
1.000000
1.000000
4
cust_ins
2018-05-29 00:12:10.817767
2018-05-29 00:12:10.866097
0.000000
657
39690
60633305-6383-4841-a244-348dcff93ffd
5c241e78-50fd-43bc-a509-49f6dbd6d557
Insight days
Enabling employees to experience a different r...
Insight days
Enabling employees to experience a different r...
1.000000
1.000000
4
cust_ins
2018-05-29 00:12:12.929123
2018-05-29 00:12:12.996803
0.000000
650
130328
61d7651c-eb90-4d0e-a520-592365fc4683
3378d375-5f2a-4e63-a0b9-b049942d8545
Remote week
Enable autonomy and build trust by scheduling ...
Remote week
Enable autonomy and build trust by scheduling ...
1.000000
1.000000
4
cust_ins
2018-05-04 13:46:00.320338
2018-05-04 13:46:00.334146
0.000000
646
149964
632d8dc7-026c-4e69-9a7a-b3ec5abdeb15
c4bd3c52-a215-487b-b53e-d0eda1c76e32
Exploration Day
Learn something new and different to provide a...
Exploration day
Learn something new and different to provide a...
1.000000
1.000000
4
cust_ins
2018-05-29 00:12:09.939394
2018-05-29 00:12:09.990928
0.000000
73
57559
f09c174d-9a33-4c2b-b83a-420a95df64e6
77889ada-36c8-4727-8f8a-500d1a9ef1ca
Customer wins
Share the value that customers experience with...
Customer wins
Share the value that customers experience with...
1.000000
1.000000
4
cust_ins
2018-05-18 02:43:30.397978
2018-05-18 02:43:30.410873
0.000000
639
228961
64846142-7703-4950-b678-23ab03d2fa02
2495daeb-c1ba-443d-9e57-24bd271ad45f
Flex-time
Allow employees to use flex schedules around a...
Flex-time
Allow employees to use flex schedules around a...
1.000000
1.000000
4
cust_ins
2018-05-29 00:12:16.121068
2018-05-29 00:12:16.178785
0.000000
638
52457
649f3097-df36-48e4-8976-42ee54c85cb6
cd28e17d-935e-4856-b120-ecb02928d52b
Team scorecard
One team created a team scorecard to monitor h...
Team scorecard
One team created a team scorecard to monitor h...
1.000000
1.000000
4
cust_ins
2018-05-18 02:43:46.748532
2018-05-18 02:43:46.762758
0.000000
77
146830
f0364e4d-0b39-415c-a8ac-29554cdd38e7
01e379dc-7aa4-42b9-ac1b-25b19442ae3f
Shift for a day/week
Shift roles temporarily to create better under...
Shift for a day/week
Shift roles temporarily to create better under...
1.000000
1.000000
4
cust_ins
2018-05-29 00:12:09.220112
2018-05-29 00:12:09.279608
0.000000
633
34161
660cf556-b3db-4837-a254-ec46d90c80db
a4ad8230-e1e5-41d8-a5ca-88851c032190
More Frequent Feedback
Increase the cadence of feedback for employees...
More frequent feedback
Increase the cadence of feedback for employees...
1.000000
1.000000
4
cust_ins
2018-05-29 00:12:09.813773
2018-05-29 00:12:09.875431
0.000000
67
178057
f1cddd5e-d726-4a2a-82a2-b796c537f779
a6dd18cc-5dc4-4e07-9f89-f90f1ce343c7
Shared leader updates
Share department updates on the state of the b...
Shared leader updates
Share department updates on the state of the b...
1.000000
1.000000
4
cust_ins
2018-05-18 06:36:48.176160
2018-05-18 06:36:57.324862
0.000000
632
120946
666458f2-3e49-4807-85f8-da45bac8722a
8967feca-5e3f-4239-9c55-91abb8a1e9e5
Process hackathon
Bring together diverse perspectives to improve...
Process hackathon
Bring together diverse perspectives to improve...
1.000000
1.000000
4
cust_ins
2018-05-18 02:50:02.489236
2018-05-18 02:50:02.496197
0.000000
630
139354
66f4f309-bfd9-4052-a7cd-a9b4c8a0bc52
5980ce2c-a789-4ce5-a55c-d92a5d1ab9c7
Wow! Wall
Develop a physical space where you can recogni...
Wow! Wall
Develop a physical space where you can recogni...
1.000000
1.000000
4
cust_ins
2018-05-18 03:03:21.417610
2018-05-18 03:03:21.423753
0.000000
78
190296
f009152b-99e5-482b-a6d2-619b4f97077f
58ee75e9-7d0c-443e-87ca-91d17ae50ff0
4D's Model
Help managers compile and communicate the most...
The four Ds
Help managers compile and communicate the most...
1.000000
0.077563
4
cust_ins
2018-05-29 18:40:19.493073
2018-05-29 18:40:28.521284
0.000000
628
204032
672a40e0-5c3b-441a-9b35-bb8bf6537482
5144fe0a-7425-442b-8692-86078a977be2
Team competitions
Develop ways for internal teams to connect via...
Team competitions
Develop ways for internal teams to connect via...
1.000000
1.000000
4
cust_ins
2018-05-18 05:55:07.685067
2018-05-18 05:55:07.690981
0.000000
627
160940
677ae849-f4be-4810-b5ba-ecaf492f3ea6
9f62a6ce-8b86-4741-b977-f83773627a2c
Captivate and connect
Highlight how people live the company values. ...
Captivate and connect
Highlight how people live the company values. ...
1.000000
1.000000
4
cust_ins
2018-05-18 03:16:28.903070
2018-05-18 03:16:28.916936
0.000000
624
129269
684808b8-322f-4ab7-92c3-f4e0d1117176
01b60e18-6da6-4740-9718-657907e7e16f
Lapel pins
Institute a program of visible recognition for...
Lapel pins
Institute a program of visible recognition for...
1.000000
0.000000
4
cust_ins
2018-05-04 13:50:02.633013
2018-05-04 13:50:02.640233
0.000000
80
158796
efdfe997-4eff-4c75-9a1c-8726910147f7
1c3b2531-8a92-4037-a00e-d1ab4f751b42
Lunch drop-ins
Increase visibility and accessibility of leade...
Lunch drop-ins
Increase visibility and accessibility of leade...
1.000000
1.000000
4
cust_ins
2018-05-18 03:17:01.209399
2018-05-18 03:17:01.223286
0.000000
614
18757
6a0c3110-0d7d-497e-8185-fa5d880a7385
5e60d313-dc64-4d30-a7d0-16401f4863f9
Customized career templates
Providing customized career conversation templ...
Customized career templates
Providing customized career conversation templ...
1.000000
1.000000
4
cust_ins
2018-05-02 18:39:46.609191
2018-05-02 18:39:46.615461
0.000000
613
186599
6a0e5e5e-cfb8-453d-ace1-592c5bc9e33a
f4ae5a98-5280-496b-a1a6-009cf12d0119
One-on-one meeting games
Use facilitated games in your one-on-one meeti...
One-on-one meeting games
Use facilitated games in your one-on-one meeti...
1.000000
1.000000
4
cust_ins
2018-05-04 14:19:27.411237
2018-05-04 14:19:27.423837
0.000000
83
30923
ef394de6-c5cd-482e-a42b-84c1fa597f45
2f240d47-981a-4bfa-8c2c-69e9fe60fbaf
Universal Storytelling
Encourage opportunities for team members to sh...
Universal Storytelling
Encourage opportunities for team members to sh...
1.000000
1.000000
4
cust_ins
2018-05-15 20:25:37.404635
2018-05-15 20:25:37.410839
0.000000
85
89638
ee7ad821-38bd-4108-abcb-850f4c7d3000
0fe32d08-24c4-46a9-b2df-5987c6ca947f
Internal Transfers Program
Define the process for internal transfers. One...
Internal transfers program
Define the process for internal transfers. One...
1.000000
1.000000
4
cust_ins
2018-05-29 00:12:10.419473
2018-05-29 00:12:10.474162
0.000000
631
183534
6693cb42-ed12-403d-bf54-85dd52c1866d
bdefedd9-787e-4111-8b53-8b9423d87a65
Throw things at me
Create open forums for managers to answer ques...
Throw things at me
Create open forums for managers to answer ques...
1.000000
1.000000
4
cust_ins
2018-05-18 05:37:59.500253
2018-05-18 05:37:59.506725
0.000000
604
126670
6b7b8440-8377-4d90-a629-199bfe60fc6f
2d7030d8-89ad-4c91-acda-798a866186da
Recognizing progress
Recognize support in achieving key business ob...
Recognizing progress
Recognize support in achieving key business ob...
1.000000
1.000000
4
cust_ins
2018-05-29 00:12:16.171593
2018-05-29 00:12:16.226637
0.000000
1023 rows × 14 columns
In [4]:
data.shape
Out[4]:
(1023, 14)
In [5]:
grouped = data[['id','core_id','name']].groupby(['id', 'core_id']).agg('count')
In [6]:
len(data['id'].unique())
Out[6]:
1023
In [7]:
len(data.query('wmd > 0.7'))
Out[7]:
498
In [8]:
MIN_SIMILARITY = 0.5
MIN_VALUABLE_SCORE = 0.7
filter_condition = (
(data['wmd'] >= MIN_SIMILARITY),
(data['wmd'] < MIN_SIMILARITY) &
(data['wmd_name'] < MIN_SIMILARITY) &
(data['valuable_score'] > MIN_VALUABLE_SCORE)
)
filter_choices = ['Incore', 'Yes']
In [9]:
data['accept'] = np.select(
condlist=filter_condition, choicelist=filter_choices, default="No")
data.loc[(data['description'].duplicated()) & (
data['accept'] == 'Yes'), 'accept'] = "No"
In [10]:
data.head(10)
Out[10]:
Unnamed: 0
id
core_id
name
description
core_name
core_description
wmd
wmd_name
batch_number
type
created_at
updated_at
valuable_score
accept
0
277240
ff69326d-d40c-4fa3-bc33-8ca5dec1727e
0a64418d-5fef-4676-afc5-19d2981ba4d2
Creating a Culture of Staff Wellbeing
• Present this data point to your people manag...
Amp your inclusion training
Hosting unconscious bias, LGBTQ and gender inc...
0.473241
0.215156
4
cust_ins
2018-05-29 03:01:08.332514
2018-05-29 03:02:08.239827
0.917734
Yes
1
17040
ff591fd1-4b8c-4dc3-bc92-b98a638c64a6
3d82ef92-0ffa-4d3d-81e4-b950c1d4ae37
Talent Development Team Kits
[Check out the relevant manager team Kits on t...
In-person project kickoff
Bring every team member to a central location ...
0.361291
0.182916
4
cust_ins
2018-05-29 00:12:10.055371
2018-05-29 00:12:10.111206
0.001138
No
2
168425
ff2f1753-9e64-4459-8ddc-8db25c515aca
9ca78a29-5580-40ce-bf73-407ffd947085
The how sandwich
Guide managers to help employees communicate i...
The how sandwich
Guide managers to help employees communicate i...
1.000000
1.000000
4
cust_ins
2018-05-29 00:12:13.965206
2018-05-29 00:12:14.025883
0.000000
Incore
3
181633
fefca44a-16b5-4a57-b7b2-752d32a45e26
7fa5b733-0cbf-4d2b-833b-b7d30ecf2487
Enable Others To Act
Research The Leadership Challenge (Jim Kouzes ...
On leading with authenticity and style
Support new leaders with training focused on l...
0.391482
0.164383
4
cust_ins
2018-05-29 00:12:09.771358
2018-05-29 00:12:09.822160
0.012521
No
4
149021
fe8ea4e2-09c0-48cc-8286-bcd4c04ce092
e0a2e6a5-31b4-4991-b45e-4620f8ab9988
Celebrating failure
Share learning across the organization, even i...
Celebrating failure
Share learning across the organization, even i...
0.970195
1.000000
4
cust_ins
2018-05-29 00:12:13.060507
2018-05-29 00:12:13.105910
0.000000
Incore
5
169676
fe665fc6-b01c-4003-94fd-6881b67da1e5
4c4d757e-1178-497f-9af2-f7188914bbbb
Book: Crucial Conversations
This book provides tools for talking when the ...
The Power of Reiteration
Communicate your company and team vision multi...
0.435977
0.155532
4
cust_ins
2018-05-29 00:12:18.516657
2018-05-29 00:12:18.577651
0.819361
Yes
6
178777
fe5fccbb-f2c6-492a-9435-068dc040a429
aa7c8219-3a35-4a1c-b929-3cf1cee48f09
Help me cards
Provide people with a clear and easy way to ge...
Help me cards
Provide people with a clear and easy way to ge...
1.000000
1.000000
4
cust_ins
2018-05-29 00:12:17.304592
2018-05-29 00:12:17.357555
0.000000
Incore
7
70158
fe554057-e40e-4c46-a840-4cf600bd2f81
c395efe3-cf3f-406f-99f9-99644b1bb7c0
Open Program: Influencing Skills
[Being successful in today's organizations req...
Influencing Skills Workshop
Hold a workshop for employees looking to devel...
0.669828
0.618182
4
cust_ins
2018-05-29 00:12:08.307488
2018-05-29 00:12:08.369646
0.000000
Incore
8
101818
fdb8c0b1-774d-4732-a28f-48e12f2a7d21
ee56489b-1a43-4028-9c8f-9bbd80dfe5b8
What's in the toolshed?
Take inventory of the tools and resources peop...
What's in the toolshed?
Take inventory of the tools and resources peop...
0.973450
1.000000
4
cust_ins
2018-05-10 19:19:42.352881
2018-05-10 19:19:42.370391
0.000000
Incore
9
163866
fda2b399-9e00-41e6-8e7e-2d9d91e34bd3
8a20141e-feb8-4bc4-9b56-d47894f1d7c4
In-person open forums
Hold open forum meetings with senior leaders w...
In-person open forums
Hold open forum meetings with senior leaders w...
0.978561
1.000000
4
cust_ins
2018-05-15 20:16:14.704005
2018-05-15 20:16:14.712968
0.000000
Incore
In [11]:
potential_inspiration = data.query("accept == 'Yes'")
potential_inspiration.head()
Out[11]:
Unnamed: 0
id
core_id
name
description
core_name
core_description
wmd
wmd_name
batch_number
type
created_at
updated_at
valuable_score
accept
0
277240
ff69326d-d40c-4fa3-bc33-8ca5dec1727e
0a64418d-5fef-4676-afc5-19d2981ba4d2
Creating a Culture of Staff Wellbeing
• Present this data point to your people manag...
Amp your inclusion training
Hosting unconscious bias, LGBTQ and gender inc...
0.473241
0.215156
4
cust_ins
2018-05-29 03:01:08.332514
2018-05-29 03:02:08.239827
0.917734
Yes
5
169676
fe665fc6-b01c-4003-94fd-6881b67da1e5
4c4d757e-1178-497f-9af2-f7188914bbbb
Book: Crucial Conversations
This book provides tools for talking when the ...
The Power of Reiteration
Communicate your company and team vision multi...
0.435977
0.155532
4
cust_ins
2018-05-29 00:12:18.516657
2018-05-29 00:12:18.577651
0.819361
Yes
10
276750
fd60c432-10c2-4952-ab1c-038f12003750
0a64418d-5fef-4676-afc5-19d2981ba4d2
Generate Solutions Using Team Input
• Generate Ideas for Action using the followin...
Amp your inclusion training
Hosting unconscious bias, LGBTQ and gender inc...
0.441456
0.157894
4
cust_ins
2018-05-28 18:30:30.357124
2018-05-28 18:31:50.304411
0.924573
Yes
14
193511
fb7cab2d-e2b2-4726-9d4b-cdf045d72a20
26195e1f-4113-4f9e-aa35-96a108c1dad3
Reward mensches
Reward employees who go out of their way to he...
Team volunteering
Provide employees with funding to volunteer at...
0.479517
0.088410
4
cust_ins
2018-05-16 17:52:14.734255
2018-05-16 17:52:14.740028
0.963557
Yes
18
38385
fb093b91-b9cc-4999-a342-5ded9e6774e9
0826f61d-c88d-4842-b6c2-5ed20fd172d1
Feedback enables insight and growth
People only grow through feedback. The gift of...
Who's who in the zoo
Growing quickly can result in newcomers findin...
0.464982
0.117488
4
cust_ins
2018-05-28 12:08:27.625697
2018-05-28 12:09:08.066297
0.979972
Yes
In [12]:
len(potential_inspiration)
Out[12]:
187
In [14]:
unique_id = potential_inspiration['id'].unique()
unique_id
Out[14]:
array(['ff69326d-d40c-4fa3-bc33-8ca5dec1727e',
'fe665fc6-b01c-4003-94fd-6881b67da1e5',
'fd60c432-10c2-4952-ab1c-038f12003750',
'fb7cab2d-e2b2-4726-9d4b-cdf045d72a20',
'fb093b91-b9cc-4999-a342-5ded9e6774e9',
'faf74a0a-a51d-49e4-89ef-418f17b2207c',
'fae44f0d-334a-49da-af11-c16648033d77',
'faa31a7b-86d7-4f80-b979-5fcfa0366176',
'fa18aa1d-9e3c-4eaa-9244-5ac78d49829c',
'f6e3f4a6-3be8-42bc-8ada-bd90275bdd72',
'f4cd6806-f41a-4167-ae85-259fb0177f39',
'f4502b95-adca-4228-8e3c-e09c235bd09c',
'f124c98d-78a7-46bb-ab77-49dff2730ee3',
'f10ce007-b07e-4807-82df-bb9dc7971df5',
'ed3679f5-df3b-476b-af3b-5fa36307791a',
'ecbf6c79-0a77-4585-b94c-f7f2f6800c44',
'ebc5c29d-33b5-4149-b9a0-7ae28c30cab1',
'eb306957-bf12-4e8e-8b20-8942f20faede',
'eb05cb9b-ec10-4b82-a780-824bc7a0d745',
'e9a6f94b-e21f-4391-a654-716556f3c1b2',
'e95c112a-b53b-4385-8032-92f45d2492f3',
'e5a90ea1-028f-4a30-a46d-4c4ae68bb726',
'e39b8ce9-2e36-480b-858f-ff4a4a5dbd07',
'e37525b0-2aa1-4620-a21d-5d0af4c1e7b1',
'e322d554-e390-4369-8571-6776a7e2a5df',
'e1f83db3-9627-422c-ab5a-89ccbc3ab90d',
'e18bdda1-b32c-42b6-8500-7406a61c85ac',
'e112b501-3f51-4087-a3f6-13d8e6838bd6',
'df719a4d-0e66-4b25-be58-2ba974099d8a',
'df2319e9-465a-4ba1-b7c7-d346dc79efbc',
'defbc920-7202-49f6-9f6a-92a420d07702',
'db5e1509-7f61-48bd-8cfc-dd6e3ba73cda',
'd663e5b9-403d-4857-8cb8-0d398238a2db',
'd3fb79d9-528b-47ce-a5c3-7111fe527ab3',
'd3aceb92-1ff9-497b-bd53-a0e74f3fea43',
'd2bbab4d-9eb4-455b-b75c-48d0f1ea5713',
'd0ed672b-f8be-464b-b1ea-e11133fd9c73',
'cfec342a-c175-4688-a2d4-9663b0a104ea',
'ce4b3449-0c29-4183-9829-998947645312',
'ce48f16f-60b1-4cbb-90e1-e726bcc7d54b',
'ce25b001-084e-49c2-9a61-81e0eac9f01b',
'cb7b327e-553a-442e-9253-eb18e99545d0',
'cb740c3f-296d-4272-a7e6-cd8c09cedd61',
'ca23224c-ecde-4ec8-bba1-36ed596d2782',
'c86891b9-012b-439e-9498-d6846d1fa816',
'c7bb64db-94d7-48d1-bc7d-6cf092873ad6',
'c55fbedf-ad6e-4196-8edf-ef55de80ebcf',
'c3c68898-58d1-4cf1-bf6a-dd9b48ba126e',
'c1546170-fb98-4836-842a-2cb9af194630',
'bedc0ed6-a6a2-4098-b363-0538f07a6b2f',
'bbe586d5-2bc8-4017-9cdd-160dd4d1759c',
'b8b52c65-337c-4994-b513-c31e5750d352',
'b7bd8130-9147-4793-9dde-9ccaa952c122',
'b6e509a2-1caf-4dcf-bab6-9203c5a938bc',
'b5eb635c-53e0-4336-9bb4-b26e425d823d',
'b3ddc83d-2da9-4eb4-be1e-e44324ab6455',
'b2993d82-6f74-4929-9e33-0aa35ba388fa',
'b256bbcc-94c1-44f3-9658-0a43371fa951',
'b1ede0ba-3cd0-4dd4-b528-8def995c133a',
'b1e435ea-31dc-40f1-bc3d-84635a4d7aa3',
'b1a90dff-8014-44b1-9441-96741db99deb',
'b1642308-df8f-428b-87b7-64c5c3f91f7d',
'b0b64826-170d-4eb2-a8e5-cd751ca4d45a',
'aff2efc1-003a-4d85-9840-164e5b73ea40',
'aeb81876-3189-4e14-a2d3-e76839d2e6fa',
'a96181b9-6895-4aa1-9be7-b90a5e558408',
'a8c44d90-be10-4915-8675-f415762ca7c5',
'a7e78156-1a39-40c5-859d-90bb1f621b55',
'a7d9d5dd-0cb2-44fd-87d8-83290b8aa77d',
'a79bf8b6-671a-4350-881a-a61a8d33583d',
'a6d5cade-d0e7-44e0-9bb5-5a49d4bf6b5f',
'a6199bb8-0b5a-492a-a987-46f33708d3ad',
'a5299945-1cde-4eb9-9772-f89964525c63',
'a4c86f36-2506-4279-967f-e2132a3d4c5c',
'a4b3df98-5e40-464f-8574-9b800048fc58',
'a4a8a563-a804-4db2-b966-4deef97cea1d',
'a3195178-0e6b-429f-9c65-2a62dc018195',
'a2532e69-6a66-4d03-9da9-89503147c0cb',
'a23bb24e-f0f6-49a6-b9fd-2194aae99819',
'a1ccebba-d467-4bf7-b3e4-cf916bbc71db',
'9f8c7596-4a99-4da1-be01-95480cdedf1a',
'9bbcd697-4e95-4c69-8bfa-21690aad7938',
'99ac03d2-a361-401b-84b1-78ec66d3b53f',
'976d17b8-dbf3-496d-b4aa-ff23107f72fb',
'9637fd87-934c-421d-ac9b-b26961b1fce7',
'95f3684a-cd5d-4104-a31d-7ebbd4be40cf',
'93eca024-0f4f-4433-8bbc-36a13420a93d',
'930930da-11b4-44bc-9555-06b0a5b67736',
'926ff200-2c70-43c7-ab2e-260417b2a3b6',
'901480d4-516d-4add-a674-343272dfa78f',
'8edce9ce-6aa7-40b5-a753-4d3071c5c1a3',
'8c558fa4-5f87-4e7c-9400-40dc59ac288d',
'8b750470-71c9-4189-bb59-af15690f7e31',
'887fc337-a475-4356-8c1d-dc3dd3a5ce94',
'86cbe946-6191-4eca-878f-3f66506a086c',
'85086fa6-8084-4531-b74d-8a7c40c338b7',
'8458f31e-46c2-4918-83c7-ea44866f6012',
'834527c6-37ae-4cb7-9fa1-f12f80a4a798',
'82b00f82-bc55-4446-833b-854b43a0aa18',
'822785c6-8484-4890-ba04-e98f2fb4c9f6',
'7f6e6f29-2675-4853-b3b3-89b222027b1e',
'7d924ab9-a199-41f7-a5d0-7df04886a04a',
'7b9e8670-0490-4a54-839a-8b021779d865',
'7a9e6d91-75ce-4af2-b703-8e8b31c2d694',
'7a30f473-54b2-4dd6-9032-ff3ebd6b0731',
'78b803ac-5002-46ff-9df3-6ec8b3f438b6',
'778feb2e-e6f7-4861-a3ad-7354b833caab',
'774b957e-00ff-4370-83da-f0c93587c9fd',
'77105bba-9939-40a0-a44a-b73161051586',
'76885393-6677-492d-9d3f-8892844f4240',
'76352116-cba8-47a1-ac70-742e7689acd5',
'75353400-1832-41a4-b68e-15adac2cc881',
'728af340-40ac-459b-917d-d7617c7b7123',
'727d6169-db8d-4d79-a7d9-efb6d5ce3cfa',
'72026949-9814-4926-83fc-c1ba984de439',
'70d278ff-4cc6-4277-a822-00ddc00e89a3',
'6ed81722-b455-4db0-8945-c407d698e817',
'6ed36735-8f27-4373-8fc8-9213ac28101a',
'6a547f21-4ec9-4df3-95ea-3b7dd0068764',
'6a09d9fd-00eb-4b52-abb2-467bd8682385',
'670f79a8-99c5-4473-a4ea-9afd95b403b2',
'65ba0d6a-68c1-4fb5-b1cb-c11599a621c4',
'6540c551-7209-4829-b676-324f8a40bfae',
'643453d9-8109-4d83-bc86-abb428122f14',
'623fcd74-9128-47b5-9c16-88f8e550a6e5',
'61453dec-3284-4462-a73d-c23f64387ffe',
'60e54dd0-972b-4192-a8a9-18e9e918ebae',
'6039ec71-ced5-4086-8324-574ec5193ea2',
'5fc062b4-6a2d-4845-8709-d52369f513b3',
'5e509ba2-7a8c-47c9-a5fc-4e3fee7eb35e',
'5d2b96a2-7956-46e5-8960-e2f2f469215c',
'5bb02875-a3a6-4835-8e24-86dfae1b657c',
'55d02dc8-5a66-4dec-8c13-f75aea7686d9',
'5599e48f-c643-4a1b-b499-fb11061ef034',
'54a43daa-2eae-4cb2-8dd6-54282c8e2100',
'5453e1e1-81f4-4237-b896-3fe1b3d3c51e',
'540d9cc2-f222-4569-8bf7-aa3057091c9c',
'53af8c09-da0a-4d0d-bef5-4b9bd4a37565',
'533281a9-114c-45b6-8a80-5536586a5b59',
'523a6edf-55d9-4c89-811d-d72a6a458a57',
'4f4e0b3d-139d-4456-a6e7-0dc7e78428f0',
'4f16cdde-61e8-43a0-af16-f195608252ac',
'4d22d82c-e81b-486a-9592-d7025961c3cc',
'4ccd985b-a1df-4495-8dec-aaa5ad12267a',
'4ba9c07f-7c0e-42cd-9c32-7252d6ccee3d',
'4acf15f7-2f9f-4a07-8cd6-8fb53d463bfc',
'48129f3a-bcbc-4c9d-96ab-8f894f34d77f',
'47ef0e1c-a0d9-4834-8ed4-18a6b57f03d2',
'45e70810-7aec-4071-917e-ad26a7767350',
'43a5dd85-eb60-48fb-8bc4-a73cd394fcbc',
'3daa07d7-c0a0-4c0e-81dc-e2200c6a7dcc',
'3d7ead0f-d1dc-4468-9a2e-1a2d4d241caf',
'3977f481-323e-4bb8-83db-44123f134e08',
'38c8d97f-aabb-4650-9adc-5d7a6debaa36',
'35a7efb8-1ba6-4b34-acd5-7889fec30f64',
'34a11adc-3bbb-43c2-88e4-c316c018a6b4',
'3348ec84-a41b-4342-b6f1-1e4e6da3dfd4',
'32749b26-15c8-43ac-b3a4-ddcca0ecba34',
'3056a30e-fc8b-49b0-983d-b3ff2b1d4a6b',
'2e4eb386-03ab-43eb-b9a8-45c304cbb4fb',
'2c2de957-8ec5-4d64-a71a-e1fa8f17375a',
'2aaabb28-c411-4968-8efa-14bad8f3cea7',
'26d5f450-b4ac-4364-864f-a59b231da060',
'24ebe4d9-527f-43f6-8ab2-13ba87565e3f',
'245ac157-4639-4450-ab31-3827ef568f56',
'22a6c297-05e4-499e-84cb-06c428423166',
'20ec269c-f43c-4e5b-b0f2-ad0876e9c7e1',
'1f5e7268-4608-45f6-8355-7ebc9e692fc2',
'1ede337e-bf86-4f6b-b075-c1e727d703c6',
'1d93726d-c2c0-4145-a321-a085eca648e7',
'1d594fd1-a92e-4938-8c2e-95468e49580e',
'1bdcdc5b-def2-4327-9fbf-8aa9e9fc5d89',
'1bcb4b40-ee3f-4d8b-b95f-8b05d396286e',
'1b989938-5f68-4138-99ab-8ee3ea520951',
'1b40f6c5-0562-42f0-a286-90de564e8389',
'19d936b7-64e0-46eb-bb2c-50468f3ab4e4',
'19720a10-d8df-46ca-b5dd-784448d9273c',
'16d751b3-e1aa-42f4-b36f-d73e1dce961f',
'15e85ad6-7c1b-43a8-9e8f-857eeaa17618',
'1382d374-489e-4b0c-86f4-772fcfd62ad5',
'0ff3d3f9-bdf2-4cd8-82c7-58f5c6bed730',
'0f6de3cf-223b-490b-b6d1-0a700cebaf3d',
'0973c480-5e18-465a-a7a8-6a3eb0e5ea1b',
'06c84be4-9914-4dc1-8470-3eed8fb4c2eb',
'055c132d-17fc-4ad0-8b74-30ccfcc2c756',
'05013e92-c7f5-4f56-adef-3383defbb96e',
'039a14c4-fd33-4837-b4cc-b84037bcc6a2'], dtype=object)
In [15]:
type(unique_id)
Out[15]:
numpy.ndarray
In [117]:
pairs = pd.DataFrame(list(itertools.product(potential_inspiration['id'].unique(), potential_inspiration['id'].unique())), columns=['id_1', 'id_2'])
pairs.head()
Out[117]:
id_1
id_2
0
ff69326d-d40c-4fa3-bc33-8ca5dec1727e
ff69326d-d40c-4fa3-bc33-8ca5dec1727e
1
ff69326d-d40c-4fa3-bc33-8ca5dec1727e
fe665fc6-b01c-4003-94fd-6881b67da1e5
2
ff69326d-d40c-4fa3-bc33-8ca5dec1727e
fd60c432-10c2-4952-ab1c-038f12003750
3
ff69326d-d40c-4fa3-bc33-8ca5dec1727e
fb7cab2d-e2b2-4726-9d4b-cdf045d72a20
4
ff69326d-d40c-4fa3-bc33-8ca5dec1727e
fb093b91-b9cc-4999-a342-5ded9e6774e9
In [118]:
len(pairs)
Out[118]:
34969
In [ ]:
Content source: martindavid/code-sandbox
Similar notebooks: