Top Streams for a game Twitch
| # I am getting only the top 25 streamers for the first game | |
| headers = { | |
| 'Authorization' : 'Bearer '+str(access_token), | |
| } | |
| topstreamsforgame_response = requests.get('https://api.twitch.tv/helix/streams?game_id='+str(topgames_df['id'][0])+'&first=25', headers=headers) | |
| # Load the JSON | |
| topstreamsforgame_response_json = json.loads(topstreamsforgame_response.text) | |
| # Extracting data from the JSON | |
| topstreamsforgame_data = topstreamsforgame_response_json['data'] | |
| # Converting into a DataFrame | |
| topstreamsforgame_df = pd.DataFrame.from_dict(json_normalize(topstreamsforgame_data), orient='columns') | |
| # FOR loop to get top 25 streamers for rest of the games in our list | |
| # To keep the dashboard lightweight and relevant, I am using only the Top 20 Games and Top 25 Streamers per game | |
| for i in range(1,19) : | |
| headers = { | |
| 'Authorization' : 'Bearer '+str(access_token), | |
| } | |
| topstreamsforgame_response = requests.get('https://api.twitch.tv/helix/streams?game_id='+str(topgames_df['id'][i])+'&first=25', headers=headers) | |
| topstreamsforgame_response_json = json.loads(topstreamsforgame_response.text) | |
| topstreamsforgame_data = topstreamsforgame_response_json['data'] | |
| topstreamsforgame_df_temp = pd.DataFrame.from_dict(json_normalize(topstreamsforgame_data), orient='columns') | |
| frames = [topstreamsforgame_df, topstreamsforgame_df_temp] | |
| topstreamsforgame_df = pd.concat(frames, ignore_index=True) | |
| # Look at the data we retrieved | |
| topstreamsforgame_df.info() |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment