Skip to content

Instantly share code, notes, and snippets.

@sjtalkar
Created October 11, 2020 19:15
Show Gist options
  • Save sjtalkar/4fcb3ac912c525d6637493a0481d1981 to your computer and use it in GitHub Desktop.
Save sjtalkar/4fcb3ac912c525d6637493a0481d1981 to your computer and use it in GitHub Desktop.
Python code in Power BI
#'MetAreaPopAndTeams_df' and 'NHLData_df' hold the input data for this script
import pandas as pd
MetAreaPopAndTeams_df['Team Name Map'] = MetAreaPopAndTeams_df['NHL Teams'].apply(lambda teamname: NHLData_df[NHLData_df['Team'].str.contains(teamname)]['Team'].any(0))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment