Rádiójáték adatbázis on the GPT Store

GPT Description

GPT Prompt Starters

• Make a diagram the top 10 authors. Please analyze the ‘Rádiójáték szerzők’ column for author names excluding any name that contains 'szerző' or 'szerzők'. Multiple names are separated with the bar | symbol. Normalize the names by removing any content before and including the '>' symbol. In the normalization, make it case-insensitive, and remove accents (keep unaccented letters). Exclude "Összeállítás", "Antológia". To find the year, use 'Bemutató éve (Kereséshez)', and if it’s missing, use 'Hangfelvétel gyártási dátuma'. Convert each date into numeric data format in "Hangfelvétel gyártási dátuma" and "Bemutató éve ( Kereséshez )". Scan all lines in the database for data. I’d like a table of all valid entries and a count of how many were excluded due to each specific reason. Instead of count, display their averaged value per year.
• Nationalities: Make a diagram the orosz+szovjet, német, angol, francia nationalities per time period. Please analyze the ‘Rádiójáték szerzők’ column for nationality names. Multiple names are separated with the bar | symbol. Nationality is the word that precedes the word "nemzetiségu". Valid entries follow the pattern "Nationality nemzetiségu szerzok>Author Name". Where no ">" follows the "Nationality nemzetiségu szerzok" pattern, ignore those nationalities. Normalize, make it case-insensitive, and remove accents (keep unaccented letters). In my examples, I used unaccented forms. To find years, use 'Bemutató éve (Kereséshez)', and if it’s missing, use 'Hangfelvétel gyártási dátuma'. Convert each date into numeric data format in "Hangfelvétel gyártási dátuma" and "Bemutató éve ( Kereséshez )". Scan all lines in the database for data. I’d like a table of all valid entries and a count of how many were excluded due to each specific reason. Instead of count, display their averaged value per year.
• "Please generate the proportional timeline graph for the 10 most active dramaturgs based on their yearly output, using enhanced visibility settings."
• Genders:Please extract the first names from the authors' list, considering 'Lastname Firstname' or 'Lastname Middlename Firstname'format for Hungarian authors and 'Firstname Lastname' or 'Firstname middlename Lastname' for other nationalities. Use the provided name-gender index to determine the gender of each author. For names not found in the index, label them as 'Unknown'. Output the results as a list of authors with their determined genders, and handle any discrepancies or anomalies by reviewing the name extraction logic. Please create a grid visualization of radio play authors' gender distribution for the year 1945. Use a square marker for each day a play is recorded. Arrange the squares in rows with 20 squares per line, and start a new line directly below after 20 squares. Color the squares yellow for male, blue for female, grey for unknown genders. Ensure each square is uniform in size, touching each other without visible frames. The overall aspect should be clean with the axis turned off. Adjust the layout so that each square maintains a perfect square shape. Identify the start of each month within the data, and the first entry of the year. Annotate these points directly in the visualization.