Excel或其他数据库格式的危险问题？ [英] Jeopardy questions in Excel or other database format?

问题描述

许多站点都发布了危险问题。但是，有人知道计算机应用程序可消耗格式（例如数据库，Excel或CSV文件）中是否存在危险的问题（以及答案，类别）？假设此数据将被输入到危险的在线游戏中。

A lot of sites post Jeopardy questions. But does anyone know if there are Jeopardy questions (and answers, categories) available in an computer application consumable format like in a database or Excel or CSV file? Assume this data will be fed into a Jeopardy online game.

推荐答案

我进行了一些搜索，但在其中找不到任何内容。消耗格式。我建议做的是从此站点以编程方式创建一个列表： http：//www.j- archive.com/listseasons.php

I did some searching, and I can't find any in a consumable format. What I would suggest doing is programatically creating a list from this site: http://www.j-archive.com/listseasons.php

您可以执行以下操作，并且应该不会太困难：

You can do something like this, and it shouldn't be too difficult:

// Pseudocode for compiling a list of Jeopardy questions/answers
questions = array();
answers = array();
for (i = first_game_id; i <= last_game_id; i++) {
  if (gameIdExistsOnSite(i)) {
    html = retrievePageHTMLForGameId(i);
    divs = getQuestionDivsFromHTML(html);
    foreach (divs as div) {
      questions[] = getQuestionFromDiv(div);
      answers[] = getAnswerFromDiv(div);
    }
  }
}

csv = convertToCSV(questions, answers);

这篇关于Excel或其他数据库格式的危险问题？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！