test.py

from youtube_transcript_api import YouTubeTranscriptApi
import pandas as pd


# def get_youtube_transcript(video_url: str) -> list:
#     """Fetches the transcript of a YouTube video."""
#     ytt_api = YouTubeTranscriptApi()
#     fetched_transcript = ytt_api.fetch(video_url)
#     return fetched_transcript.to_raw_data()

# url = '1htKBjuUWec'
# transcript = get_youtube_transcript(url)
# print(transcript)

# Leggi un file xlsx con pandas
file_path = 'results/7bd855d8-463d-4ed5-93ca-5fe35145f733.xlsx'
df = pd.read_excel(file_path)
print(df)