/D3-Lab

Website built on Flask back end with a focus on displaying information using javascript's D3 package to create interactive graphs and charts.

Primary LanguageCSS

DB to D3 Lab

  1. Setup DB

    • psql: CREATE DATABASE homework_users;
    • psql: \c homework_users
    • psql: CREATE TABLE homework_users(uid SERIAL PRIMARY KEY, username VARCHAR(100) NOT NULL, first_name VARCHAR(100) NOT NULL, last_name VARCHAR(100) NOT NULL, prog_lang VARCHAR(100) NOT NULL, experience_yr FLOAT NOT NULL, age INT NOT NULL, hw1_hrs FLOAT NOT NULL);

  2. Load csv file to DB

  3. Setup project

    • For psycopg2 on Mac, set PATH="/Applications/Postgres.app/Contents/Versions/latest/bin:$PATH"
    • pip install psycopg2
    • pip install pandas
    • pip install flask
    • pip install SQLAlchemy
    • pip install flask_sqlalchemy
    • pip install flask_wtf
    • For .env setup, pip install python-dotenv

  4. Seed DB

    • python static/data/db.py
    • psql: SELECT * FROM homework_users

  5. Steps:

    • load users page

This project was created in Harvard's S14A course. This includes three graphs created in javascript's D3 library that are all interactive. Flask was used as the backend for this project.