Skip to content

Instantly share code, notes, and snippets.

@MoGaber

MoGaber/gist:fe3e7e4c8c973d65197de51a718d2439

Created December 14, 2020 05:04
Show Gist options
  • Save MoGaber/fe3e7e4c8c973d65197de51a718d2439 to your computer and use it in GitHub Desktop.
Save MoGaber/fe3e7e4c8c973d65197de51a718d2439 to your computer and use it in GitHub Desktop.
Download ZIP
get_number_groups
Raw
gistfile1.txt
# get the number of groups that each professional is following
prof_grp = group_members["group_memberships_user_id"].value_counts().reset_index().rename(columns = {"index":"professional_id", "group_memberships_user_id":"num_groups"})
professionals_dataset = pd.merge(professionals_dataset,prof_grp,how='left', on=["professional_id" ])
# get the number of schools that each professional is following
prof_schl = schools_members["school_memberships_user_id"].value_counts().reset_index().rename(columns = {"index":"professional_id", "school_memberships_user_id":"num_schools"})
professionals_dataset = pd.merge(professionals_dataset,prof_schl,how='left', on=["professional_id" ])
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment