GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — GitHub - OpenCourseAPI/data-analysis: Graphs and charts that will be cool, one day

BranchesTags
Open more actions menu

Latest commit

 

History

15 Commits
15 Commits

Folders and files

NameName
Last commit message
Last commit date
.streamlit
.streamlit
 
 
db
db
 
 
.gitignore
.gitignore
 
 
LICENSE
LICENSE
 
 
Pipfile
Pipfile
 
 
Pipfile.lock
Pipfile.lock
 
 
README.md
README.md
 
 
app.py
app.py
 
 
cli.py
cli.py
 
 
generate_db.py
generate_db.py
 
 
settings.py
settings.py
 
 

Repository files navigation

Data Analysis

By Open Course API

Prerequisites

  • Python 3.7, pip, and pipenv
  • Energy to start hacking 🚀

Get Started

Install pipenv if you haven't already:

pip install pipenv
# OR
pip3 install pipenv

Clone live-fhda-class-data and this repo, and install its dependencies:

mkdir opencourse
cd opencourse

git clone https://github.com/OpenCourseAPI/live-fhda-class-data.git
git clone https://github.com/OpenCourseAPI/data-analysis.git

cd data-analysis
pipenv install # this may take some time

Note: it is recommended to create a folder such as opencourse and clone these repos in that folder, for better organization and usability of the repos.

Launch

Run the following in your terminal:

pipenv run cli start

You should see something like:

You can now view your Streamlit app in your browser.

  Local URL: http://localhost:8501
  Network URL: http://192.168.1.XX:8501

Navigate to the specified URL in your browser and enjoy!

Advanced

Manually creating SQLite DBs

To manually generate db/<term>.sqlite3 files, run the following:

pipenv run cli generate [--term Fall2020] [--interval-time 60] [OPTIONS]

For more information, use:

pipenv run cli generate --help

Dump SQLite DB to CSV

To convert an SQLite DB file into CSV format, run the following:

pipenv run cli to_csv SRC_FILE [DEST_FILE]

# Examples:
pipenv run cli to_csv db/temp_202131.sqlite3 # will generate db/temp_202131.csv
pipenv run cli to_csv db/temp_202131.sqlite3 dump.csv # specify custom file

For more information, use:

pipenv run cli to_csv --help

Contributing

We welcome all contributions! Have an idea or found a bug? Feel free to open an issue or a PR.

License

The MIT license

About

Graphs and charts that will be cool, one day

Resources

Readme
MIT license
Activity
Custom properties

Stars

2 stars

Watchers

2 watching

Forks

0 forks
Report repository

Releases

Packages

Contributors

Languages

You are visitor 01402503 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.