Jeopardy!

A web-application built on Jeopardy!, a popular American game show.
The project presents a web-interface to search questions based on the game-show.

Website : http://saab.ischool.utexas.edu/jeopardy/

Project Poster: Poster

There are 3 questions we focus on:

1. Which jeopardy questions were asked during a final round?
2. Which jeopardy questions were answered by Ken Jennings?
3. Which jeopardy questions were answered by Brad Rutter?

NOTE: Ken Jennings is a contestant with a longest winning streak and Brad Rutter is a contestant with a highest earning.

Dataset

Dataset presents Jeopardy! games from 18 different seasons starting from Season 16 to Season 33.
There are around ~ 230 games in each season.

No. of contestants: 7,855

No. of questions: 225,347

No. of question categories: 32,061

The dataset consists of 5 CSV files available at here.
Path: jeopardy/dataset

Entity Relationship Diagram is avalable here.

System Architecture

Usage

requirements.txt specify the Python libraries required for the execution of the Python parser to collect data from CSV files.

The code for data parsing/configuration is present in jeopardy/src/data_parsing_reconfiguration
The code for the web-page is present in jeopardy/public_html

python3 jeopardy/src/data_parsing_reconfiguration/generate_jeopardy_sql_files.py -h

usage: generate_jeopardy_sql_files.py -i=INPUT_CONFIG_FILE -o=
                                      OUTPUT_CONFIG_FILE [-h]

optional arguments:
  -h, --help            This Python script reads CSV files and creates .sql
                        files to insert in database. The project is meant to
                        be used for creating a Jeopardy database.

required named arguments:
  -i INPUT_CONFIG_FILE, --input_config INPUT_CONFIG_FILE
                        Input Configuration file provides details of the
                        locations of the required CSV files.                        

  -o OUTPUT_CONFIG_FILE, --output_config OUTPUT_CONFIG_FILE
                        Output Configuration file provides details of the
                        locations of the generated .sql files containing
                        insert statements for the Jeopardy database tables.

Sample INPUT_CONFIG_FILE available here.
Sample OUTPUT_CONFIG_FILE available here.