GitHub - Get reactions from comment

import requests
import pandas as pd
import naas_python

github_token = naas_python.secret.get("GITHUB_TOKEN").value
reactions_url = "https://api.github.com/repos/pola-rs/polars/issues/comments/2144455441/reactions"

def get_comment_reactions(reactions_url):
    headers = {
        'Authorization': f'token {github_token}',
        'Accept': 'application/vnd.github.squirrel-girl-preview+json'  # Required for reactions API
    }

    response = requests.get(reactions_url, headers=headers)
    print(f"Requesting: {reactions_url}")

    if response.status_code == 200:
        return response.json()
    else:
        print(f"Failed to fetch reactions: {response.status_code} - {response.text}")
        return []
    
reactions = get_comment_reactions(reactions_url)

def print_reaction_types_table(reactions):
    if reactions:
        reaction_types = {
            '+1': 0,
            '-1': 0,
            'laugh': 0,
            'hooray': 0,
            'confused': 0,
            'heart': 0,
            'rocket': 0,
            'eyes': 0
        }
        
        for reaction in reactions:
            reaction_content = reaction['content']
            if reaction_content in reaction_types:
                reaction_types[reaction_content] += 1

        # Convert the reaction types to a DataFrame
        reaction_data = pd.DataFrame(list(reaction_types.items()), columns=['Reaction Type', 'Count'])
        
        # Filter out reactions with a count of 0
        filtered_reaction_data = reaction_data[reaction_data['Count'] > 0]
        
        print(filtered_reaction_data)
    else:
        print("No reactions found or failed to fetch reactions.")
        
print_reaction_types_table(reactions)