hkyplyr/nfl_rushing

theScore "the Rush" Interview Challenge

At theScore, we are always looking for intelligent, resourceful, full-stack developers to join our growing team. To help us evaluate new talent, we have created this take-home interview question. This question should take you no more than a few hours.

All candidates must complete this before the possibility of an in-person interview. During the in-person interview, your submitted project will be used as the base for further extensions.

Why a take-home challenge?

In-person coding interviews can be stressful and can hide some people's full potential. A take-home gives you a chance work in a less stressful environment and showcase your talent.

We want you to be at your best and most comfortable.

A bit about our tech stack

As outlined in our job description, you will come across technologies which include a server-side web framework (like Elixir/Phoenix, Ruby on Rails or a modern Javascript framework) and a front-end Javascript framework (like ReactJS)

Challenge Background

We have sets of records representing football players' rushing statistics. All records have the following attributes:

• Player (Player's name)
• Team (Player's team abbreviation)
• Pos (Player's postion)
• Att/G (Rushing Attempts Per Game Average)
• Att (Rushing Attempts)
• Yds (Total Rushing Yards)
• Avg (Rushing Average Yards Per Attempt)
• Yds/G (Rushing Yards Per Game)
• TD (Total Rushing Touchdowns)
• Lng (Longest Rush -- a T represents a touchdown occurred)
• 1st (Rushing First Downs)
• 1st% (Rushing First Down Percentage)
• 20+ (Rushing 20+ Yards Each)
• 40+ (Rushing 40+ Yards Each)
• FUM (Rushing Fumbles)

In this repo is a sample data file rushing.json.

Challenge Requirements

1. Create a web app. This must be able to do the following steps

   1. Create a webpage which displays a table with the contents of rushing.json
   2. The user should be able to sort the players by Total Rushing Yards, Longest Rush and Total Rushing Touchdowns
   3. The user should be able to filter by the player's name
   4. The user should be able to download the sorted data as a CSV, as well as a filtered subset

2. The system should be able to potentially support larger sets of data on the order of 10k records.

3. Update the section Installation and running this solution in the README file explaining how to run your code

Submitting a solution

1. Download this repo
2. Complete the problem outlined in the Requirements section
3. In your personal public GitHub repo, create a new public repo with this implementation
4. Provide this link to your contact at theScore

We will evaluate you on your ability to solve the problem defined in the requirements section as well as your choice of frameworks, and general coding style.

Help

If you have any questions regarding requirements, do not hesitate to email your contact at theScore for clarification.

Installation and running this solution

Running the service (using docker)

1. Clone and navigate into the repository

git clone [email protected]:hkyplyr/nfl_rushing.git
cd nfl_rushing

2. Run the application

docker compose up

3. Open the application in your browser (Works best with Chrome or Safari): http://127.0.0.1:5000

Running the service (from source)

1. Clone and navigate into the repository

git clone [email protected]:hkyplyr/nfl_rushing.git
cd nfl_rushing

2. (Optional) Create a virtual environment (using virtualenvwrapper)

mkvirtualenv nfl_rushing

3. Install dependencies

pip install -r requirements.txt

4. Set required environment variables

# Ensures the modules in this repo can be found when running python
export PYTHONPATH=$(pwd)

# Flask specific variable that indicates which file contains the application logic
export FLASK_APP=nfl_rushing.app.py

# Flask specific variable that enables development mode which includes auto-reloading when files change
export FLASK_ENV=development

5. (Optional) Run tests w/ or w/o coverage

# Without coverage
pytest .

# With coverage
pytest --cov=nfl_rushing .

6. Run the application

flask run

7. Open the application in your browser (Works best with Chrome or Safari): http://127.0.0.1:5000

Notes

• Works best with Chrome due to a weird UI glitch on Firefox where the top and bottom borders don't appear for the cells in the first column of the table.
  • This seems to be because the CSS used to make the first column sticky (for horizontal scrolling) is overriding the style from the bootstrap CSS.