Introduction

The simple academic review website was implemented for a test for a job application.

You can see the demo video here

The website implements access to data, basic functions, statistical information. details as follows

• fetch reviews, reviewers, review assignments for all papers across all rolling review cycles (May 2021 to Feb 2022)
• home page - reviewer list: paginate all reviewers, click to visit reviewer page
• reviewer search bar： is in the navigation bar, so we can search reviewer on every page.
• reviewer page: shows 4 parts for a reviewer. reviewer name, statistics(number of reviews and assigned reviews, average word and character length of reviews), unfulfilled review assignments, and reviews.
• stats page: shows overall statistics and plot. The style of the page refers to ARR Statistics
• stats by cycle page: shows cycle statistics and overall assessment distribution plot.

How to run the dashboard

running websete

• install all the required packages and activate virtual env.
• Open terminal, input command
  • For Windows, set FLASK_APP=main.py, for Mac,export FLASK_APP=main.py
  • flask run
• open brower, visit http://127.0.0.1:5000/, then you can see the home page.

fetch data from OpenReview

the database is also in the github, so you can just use the it. If you want to fetch data from nothing, you can follow the following steps.

• set FLASK_APP=main.py
• flask shell
• db.create_all() to create a sqlite database
• run flask fetch command, you can get all the data. This step needs hours.

Architecture

• website: python flask.
• database: sqlite + SQLAlchemy
• plot: Plotly + Echarts + Pandas
• UI: Bootstrap + CSS

The code is structured as followering:

Web Pages

1/4. Home Page(for reviewer list):

2/4. Stats Page:

3/4. Cycle Stats Page:

4/4. Reviewer Page(profile and reviews):