ChatGPT Meets Jeopardy

As a developer passionate about trivia and data analysis, I've been exploring ways to blend my interests in a single, engaging project. My journey led me to a unique intersection: incorporating a vast dataset of Jeopardy questions into my existing applications, TriviaSpark and the Data Analysis Demo, using C# and .NET.

TriviaSpark, my trivia application, has been a playground for trivia enthusiasts, offering a wide range of quizzes across various domains. Designed with C#, it's been a testament to the versatility and power of .NET in creating interactive, user-friendly applications.

The TriviaSpark application represents the entertainment side of C#, offering a web-based trivia platform that's both engaging and informative. Through the integration of Jeopardy questions, TriviaSpark becomes more than just a game; it's a journey through a myriad of topics, challenging the intellect of trivia aficionados and casual players alike.

In my Data Analysis Demo, I delve into CSV files to unearth patterns, insights, and stories hidden within the data. This C#-powered project showcases the potential of .NET in processing and visualizing complex datasets, making data analysis accessible and insightful.

On the flip side, the Data Analysis Demo showcases the analytical prowess of C# and .NET, focusing on the dissection and visualization of CSV file data. This demo illuminates the process of turning raw data into meaningful insights, exemplifying how complex datasets can be made accessible and interpretable.

On a quest for intriguing CSV datasets, I stumbled upon a goldmine: a comprehensive CSV file of Jeopardy questions. This serendipitous find seemed like the perfect bridge between TriviaSpark and the analytical depth of the Data Analysis Demo, promising a fusion of trivia and data analytics.

This find represented the perfect fusion of TriviaSpark's engaging gameplay and the Data Analysis Demo's insightful exploration, bringing together the best of both worlds in a C# application that entertains as much as it informs.

With the Jeopardy dataset in hand, I embarked on integrating it into a C# application. This endeavor was not just about importing data; it was about breathing life into the numbers and texts, turning them into an interactive trivia experience enriched with the analytical prowess of C# and .NET.

public class JeopardyQuestion
{
  public required string Category { get; set; }
  [JsonPropertyName("air_date")]
  public required string AirDate { get; set; }
  public required string Question { get; set; }
  public required string Value { get; set; }
  public required string Answer { get; set; }
  public required string Round { get; set; }
  [JsonPropertyName("show_number")] // Maps "show_number" in JSON to this property
  public required string ShowNumber { get; set; }
}

public class JeopardyQuestions : List<JeopardyQuestion>
{

}

string jsonFilePath = "JEOPARDY_QUESTIONS.json";
string json = File.ReadAllText(jsonFilePath);
var options = new JsonSerializerOptions
{
  PropertyNameCaseInsensitive = true
};
var questions = JsonSerializer.Deserialize<JeopardyQuestions>(json, options);

// Group questions by category, air date, and round, then select a random group
var random = new Random();
var groupedQuestions = this
  .GroupBy(q => new { q.Category, q.AirDate, q.Round })
  .ToList();
if (groupedQuestions.Count == 0)
{
  Console.WriteLine("No groups of questions available.");
  return;
}

var randomGroup = groupedQuestions[random.Next(groupedQuestions.Count)];

var randomGroup = groupedQuestions[random.Next(groupedQuestions.Count)];
var selectedQuestions = randomGroup.Take(5).ToList(); // Take up to 5 questions from the selected group

// Displaying the details of the questions from the selected group
if (selectedQuestions.Any())
{
  Console.WriteLine($"Selected Category: {selectedQuestions.First().Category}");
  Console.WriteLine($"Air Date: {selectedQuestions.First().AirDate}");
  Console.WriteLine($"Round: {selectedQuestions.First().Round}");

  foreach (var question in selectedQuestions)
  {
    Console.WriteLine($"----------");
    Console.WriteLine($"Question: {question.Question}");
    Console.WriteLine($"Answer: {question.Answer}");
  }
}
else
{
  Console.WriteLine("No questions found in the selected group.");
}

Selected Category: ALL A DREAM
Air Date: 2011-04-19
Round: Double Jeopardy!
Answer: fever