# Global Variables
all_geos_str = str((
    'US', 'MX', 'BR', 'DE', 'IN', 'GB', 'ES', 'FR', 'AR', 'CA', 
    'AU', 'PH', 'IT', 'CO', 'CL', 'ID', 'PE', 'PL', 'NL', 'SE', 
    'ZA', 'CH', 'IE', 'NZ', 'PT', 'TW', 'JM', 'CR', 'BS', 'HN', 
    'GD', 'EC', 'DO', 'SV', 'UY', 'PA', 'HT', 'MS', 'BO', 'BM', 
    'PY', 'DM', 'VE', 'GT', 'DK', 'NO', 'SA', 'BE', 'EG', 'TH', 
    'MY', 'SG', 'VN', 'HK', 'AT'
    ))

small_geos = ['CA', 'ES', 'IT', 'AR', 'AU', 'CL', 'CO', 'NL', 'PE', 'CH', 
              'ZA', 'IE', 'NZ', 'PT', 'TW', 'JM', 'CR', 'BS', 'HN', 
              'GD', 'EC', 'DO', 'SV', 'UY', 'PA', 'HT', 'MS', 'BO', 'BM', 
              'PY', 'DM', 'VE', 'GT', 'SE', 'SA', 'PL', 'BE', 'EG',
              'ID', 'TH', 'MY', 'SG', 'VN', 'HK', 'AT']
smaller_geos = ['CH', 'ZA', 'IE', 'NZ', 'PT', 'TW', 'JM', 'CR', 'BS', 'HN', 
                'GD', 'EC', 'DO', 'SV', 'UY', 'PA', 'HT', 'MS', 'BO', 'BM', 
                'PY', 'DM', 'VE', 'GT', 'DK', 'NO', 'SA', 'BE', 'EG',
                'TH', 'MY', 'SG', 'VN', 'HK', 'AT']

x_cols_no_amazon = ['TOTAL_STREAMS', 'TOTAL_SKIPS', 'TOTAL_SAVES', 'TOTAL_STREAMS_PASSIVE', 'TOTAL_STREAMS_ACTIVE', 'TOTAL_COLLECTION_STREAMS', 'TOTAL_PAID_STREAMS', 
 'TOTAL_FREE_STREAMS', 
'SPOTIFY_COLLECTION_STREAMS', 'SPOTIFY_PLAYQUEUE_STREAMS', 'SPOTIFY_ALBUM_PAGE_STREAMS', 'SPOTIFY_ARTIST_PAGE_STREAMS', 
 'SPOTIFY_SEARCH_STREAMS', 'SPOTIFY_PLAYLIST_STREAMS', 'SPOTIFY_RELEASE_RADAR_STREAMS', 'SPOTIFY_DISCOVER_WEEKLY_STREAMS', 'SPOTIFY_RADIO_STREAMS', 
 'SPOTIFY_DAILYMIX_STREAMS', 'SPOTIFY_CHART_STREAMS', 'SPOTIFY_OTHER_STREAMS', 
'APPLE_LIBRARY_STREAMS', 'APPLE_EXTERNAL_STREAMS', 'APPLE_VOICE_STREAMS', 'APPLE_SEARCH_STREAMS', 
 'APPLE_MUSICKIT_STREAMS', 'APPLE_NOWPLAYING_STREAMS', 'APPLE_DISCOVERY_STREAMS', 'APPLE_OTHER_STREAMS', 'YEST_TOTAL_STREAMS', 'YEST_TOTAL_SKIPS', 'YEST_TOTAL_SAVES', 'YEST_TOTAL_STREAMS_PASSIVE', 
 'YEST_TOTAL_STREAMS_ACTIVE', 'YEST_TOTAL_COLLECTION_STREAMS', 'YEST_TOTAL_PAID_STREAMS', 'YEST_TOTAL_FREE_STREAMS', 'YEST_SPOTIFY_COLLECTION_STREAMS', 
 'YEST_SPOTIFY_PLAYQUEUE_STREAMS', 'YEST_SPOTIFY_ALBUM_PAGE_STREAMS', 'YEST_SPOTIFY_ARTIST_PAGE_STREAMS', 'YEST_SPOTIFY_SEARCH_STREAMS', 'YEST_SPOTIFY_PLAYLIST_STREAMS', 
 'YEST_SPOTIFY_RELEASE_RADAR_STREAMS', 'YEST_SPOTIFY_DISCOVER_WEEKLY_STREAMS', 'YEST_SPOTIFY_RADIO_STREAMS', 'YEST_SPOTIFY_DAILYMIX_STREAMS', 'YEST_SPOTIFY_CHART_STREAMS', 
 'YEST_SPOTIFY_OTHER_STREAMS', 'YEST_APPLE_LIBRARY_STREAMS', 'YEST_APPLE_EXTERNAL_STREAMS', 'YEST_APPLE_VOICE_STREAMS', 'YEST_APPLE_SEARCH_STREAMS', 'YEST_APPLE_MUSICKIT_STREAMS', 
 'YEST_APPLE_NOWPLAYING_STREAMS', 'YEST_APPLE_DISCOVERY_STREAMS', 'YEST_APPLE_OTHER_STREAMS', 'SEVEN_TOTAL_STREAMS', 'SEVEN_TOTAL_SKIPS', 'SEVEN_TOTAL_SAVES', 
 'SEVEN_TOTAL_STREAMS_PASSIVE', 'SEVEN_TOTAL_STREAMS_ACTIVE', 'SEVEN_TOTAL_COLLECTION_STREAMS', 'SEVEN_TOTAL_PAID_STREAMS', 'SEVEN_TOTAL_FREE_STREAMS', 'SEVEN_SPOTIFY_COLLECTION_STREAMS', 
 'SEVEN_SPOTIFY_PLAYQUEUE_STREAMS', 'SEVEN_SPOTIFY_ALBUM_PAGE_STREAMS', 'SEVEN_SPOTIFY_ARTIST_PAGE_STREAMS', 'SEVEN_SPOTIFY_SEARCH_STREAMS', 'SEVEN_SPOTIFY_PLAYLIST_STREAMS', 
 'SEVEN_SPOTIFY_RELEASE_RADAR_STREAMS', 'SEVEN_SPOTIFY_DISCOVER_WEEKLY_STREAMS', 'SEVEN_SPOTIFY_RADIO_STREAMS', 'SEVEN_SPOTIFY_DAILYMIX_STREAMS', 'SEVEN_SPOTIFY_CHART_STREAMS', 
 'SEVEN_SPOTIFY_OTHER_STREAMS', 'SEVEN_APPLE_LIBRARY_STREAMS', 'SEVEN_APPLE_EXTERNAL_STREAMS', 'SEVEN_APPLE_VOICE_STREAMS', 'SEVEN_APPLE_SEARCH_STREAMS', 'SEVEN_APPLE_MUSICKIT_STREAMS', 
 'SEVEN_APPLE_NOWPLAYING_STREAMS', 'SEVEN_APPLE_DISCOVERY_STREAMS', 'SEVEN_APPLE_OTHER_STREAMS', 'TT_CREATIONS', 'TT_FAVORITES', 'TT_LIKES', 'TT_SHARES', 'TT_VIEWS', 
 'YEST_TT_CREATIONS', 'YEST_TT_FAVORITES', 'YEST_TT_LIKES', 'YEST_TT_SHARES', 'YEST_TT_VIEWS', 'SEVEN_TT_CREATIONS', 'SEVEN_TT_FAVORITES', 'SEVEN_TT_LIKES', 'SEVEN_TT_SHARES', 'SEVEN_TT_VIEWS', 
 'CONSECUTIVE_TREND', 'WOW_TOTAL_STREAMS', 'DOD_TOTAL_STREAMS', 'WOW_TOTAL_SKIPS', 'DOD_TOTAL_SKIPS', 'WOW_TOTAL_SAVES', 'DOD_TOTAL_SAVES', 'WOW_TOTAL_STREAMS_PASSIVE', 'DOD_TOTAL_STREAMS_PASSIVE', 
 'WOW_TOTAL_STREAMS_ACTIVE', 'DOD_TOTAL_STREAMS_ACTIVE', 'WOW_TOTAL_COLLECTION_STREAMS', 'DOD_TOTAL_COLLECTION_STREAMS', 'WOW_TOTAL_PAID_STREAMS', 'DOD_TOTAL_PAID_STREAMS', 'WOW_TOTAL_FREE_STREAMS', 
 'DOD_TOTAL_FREE_STREAMS', 'WOW_SPOTIFY_COLLECTION_STREAMS', 'DOD_SPOTIFY_COLLECTION_STREAMS', 'WOW_SPOTIFY_PLAYQUEUE_STREAMS', 'DOD_SPOTIFY_PLAYQUEUE_STREAMS', 'WOW_SPOTIFY_ALBUM_PAGE_STREAMS', 
 'DOD_SPOTIFY_ALBUM_PAGE_STREAMS', 'WOW_SPOTIFY_ARTIST_PAGE_STREAMS', 'DOD_SPOTIFY_ARTIST_PAGE_STREAMS', 'WOW_SPOTIFY_SEARCH_STREAMS', 'DOD_SPOTIFY_SEARCH_STREAMS', 'WOW_SPOTIFY_PLAYLIST_STREAMS', 
 'DOD_SPOTIFY_PLAYLIST_STREAMS', 'WOW_SPOTIFY_RELEASE_RADAR_STREAMS', 'DOD_SPOTIFY_RELEASE_RADAR_STREAMS', 'WOW_SPOTIFY_DISCOVER_WEEKLY_STREAMS', 'DOD_SPOTIFY_DISCOVER_WEEKLY_STREAMS', 
 'WOW_SPOTIFY_RADIO_STREAMS', 'DOD_SPOTIFY_RADIO_STREAMS', 'WOW_SPOTIFY_DAILYMIX_STREAMS', 'DOD_SPOTIFY_DAILYMIX_STREAMS', 'WOW_SPOTIFY_CHART_STREAMS', 'DOD_SPOTIFY_CHART_STREAMS', 
 'WOW_SPOTIFY_OTHER_STREAMS', 'DOD_SPOTIFY_OTHER_STREAMS', 'WOW_APPLE_LIBRARY_STREAMS', 'DOD_APPLE_LIBRARY_STREAMS', 'WOW_APPLE_EXTERNAL_STREAMS', 'DOD_APPLE_EXTERNAL_STREAMS', 
 'WOW_APPLE_VOICE_STREAMS', 'DOD_APPLE_VOICE_STREAMS', 'WOW_APPLE_SEARCH_STREAMS', 'DOD_APPLE_SEARCH_STREAMS', 'WOW_APPLE_MUSICKIT_STREAMS', 'DOD_APPLE_MUSICKIT_STREAMS', 'WOW_APPLE_NOWPLAYING_STREAMS', 
 'DOD_APPLE_NOWPLAYING_STREAMS', 'WOW_APPLE_DISCOVERY_STREAMS', 'DOD_APPLE_DISCOVERY_STREAMS', 'WOW_APPLE_OTHER_STREAMS', 'DOD_APPLE_OTHER_STREAMS', 'WOW_TT_CREATIONS', 
 'DOD_TT_CREATIONS', 'WOW_TT_FAVORITES', 'DOD_TT_FAVORITES', 'WOW_TT_LIKES', 'DOD_TT_LIKES', 'WOW_TT_SHARES', 'DOD_TT_SHARES', 'WOW_TT_VIEWS', 'DOD_TT_VIEWS', 
 'PCT_CHANGE_VS_PREV', 'ADJ_DOD_TOTAL_STREAMS', 'ADJ_DOD_TOTAL_SKIPS', 'ADJ_DOD_TOTAL_SAVES', 'ADJ_DOD_TOTAL_STREAMS_PASSIVE', 'ADJ_DOD_TOTAL_STREAMS_ACTIVE', 'ADJ_DOD_TOTAL_COLLECTION_STREAMS', 
 'ADJ_DOD_TOTAL_PAID_STREAMS', 'ADJ_DOD_TOTAL_FREE_STREAMS', 'ADJ_DOD_SPOTIFY_COLLECTION_STREAMS', 'ADJ_DOD_SPOTIFY_PLAYQUEUE_STREAMS', 'ADJ_DOD_SPOTIFY_ALBUM_PAGE_STREAMS', 
 'ADJ_DOD_SPOTIFY_ARTIST_PAGE_STREAMS', 'ADJ_DOD_SPOTIFY_SEARCH_STREAMS', 'ADJ_DOD_SPOTIFY_PLAYLIST_STREAMS', 'ADJ_DOD_SPOTIFY_RELEASE_RADAR_STREAMS', 'ADJ_DOD_SPOTIFY_DISCOVER_WEEKLY_STREAMS', 
 'ADJ_DOD_SPOTIFY_RADIO_STREAMS', 'ADJ_DOD_SPOTIFY_DAILYMIX_STREAMS', 'ADJ_DOD_SPOTIFY_CHART_STREAMS', 'ADJ_DOD_SPOTIFY_OTHER_STREAMS', 'ADJ_DOD_APPLE_LIBRARY_STREAMS', 'ADJ_DOD_APPLE_EXTERNAL_STREAMS', 
 'ADJ_DOD_APPLE_VOICE_STREAMS', 'ADJ_DOD_APPLE_SEARCH_STREAMS', 'ADJ_DOD_APPLE_MUSICKIT_STREAMS', 'ADJ_DOD_APPLE_NOWPLAYING_STREAMS', 'ADJ_DOD_APPLE_DISCOVERY_STREAMS', 'ADJ_DOD_APPLE_OTHER_STREAMS',
 'ADJ_DOD_TT_CREATIONS', 'ADJ_DOD_TT_FAVORITES', 'ADJ_DOD_TT_LIKES', 'ADJ_DOD_TT_SHARES', 'ADJ_DOD_TT_VIEWS']


list_of_cols = ['TOTAL_STREAMS', 'TOTAL_SKIPS', 'TOTAL_SAVES', 'TOTAL_STREAMS_PASSIVE', 
    'TOTAL_STREAMS_ACTIVE', 'TOTAL_COLLECTION_STREAMS', 'TOTAL_PAID_STREAMS', 
    'TOTAL_FREE_STREAMS', 'SPOTIFY_COLLECTION_STREAMS', 'SPOTIFY_PLAYQUEUE_STREAMS', 
    'SPOTIFY_ALBUM_PAGE_STREAMS', 'SPOTIFY_ARTIST_PAGE_STREAMS', 'SPOTIFY_SEARCH_STREAMS', 
    'SPOTIFY_PLAYLIST_STREAMS', 'SPOTIFY_RELEASE_RADAR_STREAMS', 'SPOTIFY_DISCOVER_WEEKLY_STREAMS', 
    'SPOTIFY_RADIO_STREAMS', 'SPOTIFY_DAILYMIX_STREAMS', 'SPOTIFY_CHART_STREAMS', 
    'SPOTIFY_OTHER_STREAMS', 'APPLE_LIBRARY_STREAMS', 'APPLE_EXTERNAL_STREAMS', 
    'APPLE_VOICE_STREAMS', 'APPLE_SEARCH_STREAMS', 'APPLE_MUSICKIT_STREAMS', 
    'APPLE_NOWPLAYING_STREAMS', 'APPLE_DISCOVERY_STREAMS', 'APPLE_OTHER_STREAMS', 
   'TT_CREATIONS', 'TT_FAVORITES', 'TT_LIKES', 'TT_SHARES', 'TT_VIEWS']