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屋!