Data

Tools

Indexes

Applications

Experiments

Open Source Science

bis_371_class_project

https://github.com/benb-01/bis_371_class_project

Science Score: 31.0%

This score indicates how likely this project is to be science-related based on various indicators:

  • ✓
    CITATION.cff file
    Found CITATION.cff file
  • ✓
    codemeta.json file
    Found codemeta.json file
  • ○
    .zenodo.json file
  • ○
    DOI references
  • ○
    Academic publication links
  • ○
    Academic email domains
  • ○
    Institutional organization owner
  • ○
    JOSS paper metadata
  • ○
    Scientific vocabulary similarity
    Low similarity (8.7%) to scientific vocabulary
Last synced: 10 months ago · JSON representation ·

Repository

Basic Info
  • Host: GitHub
  • Owner: BenB-01
  • License: mit
  • Language: Python
  • Default Branch: master
  • Size: 34.2 KB
Statistics
  • Stars: 0
  • Watchers: 1
  • Forks: 0
  • Open Issues: 0
  • Releases: 0
Created over 3 years ago · Last pushed over 1 year ago
Metadata Files
Readme Changelog Contributing License Code of conduct Citation

README.md

Business Information Systems 371 - Class Project

A tool created for the Business Information Systems 371 class at Oregon State University during Fall Term 2023.

  • Automacically access folder with Excel files containing data regarding research papers from OSU
  • Exctract data from Excel sheets
  • Scripts to create MySQL database with correct schema
  • Store data in one single MySQL database

🔨 Installation & Setup

  1. Install Python 3.11
  2. Install poetry
  3. Install dependencies using poetry
  4. Select Poetry environment as Python environment for the project

💡 Usage

  1. Create a MySQL database using the table creation script
  2. Add the values of the nontransaction tables
  3. Run the ETL Pipeline to extract the information from the folder with Excel files
  4. When the pipeline is done, run the Frontend to view the data in the database

Owner

  • Login: BenB-01
  • Kind: user

Citation (CITATION.md) 

<!--
SPDX-FileCopyrightText: 2024 Ben Burkert

SPDX-License-Identifier: MIT
-->

# Citation

If you use **BIS 371 Class Project** in your research, publications, or presentations, please cite it as follows:

## Citation Information

**BIS 371 Class Project**  
Version: 0.2.0  
Authors: Ben Burkert
Year: 2023  
Repository: [https://github.com/BenB-01/BIS_371_Class_Project](https://github.com/BenB-01/BIS_371_Class_Project)

GitHub Events

Total
  • Push event: 1
  • Public event: 1
Last Year
  • Push event: 1
  • Public event: 1

Dependencies

poetry.lock pypi
  • attrs 24.2.0
  • binaryornot 0.4.4
  • boolean-py 4.0
  • chardet 5.2.0
  • et-xmlfile 2.0.0
  • jinja2 3.1.4
  • license-expression 30.4.0
  • markupsafe 3.0.2
  • mysql-connector-python 9.1.0
  • openpyxl 3.1.5
  • python-debian 0.1.49
  • reuse 4.0.3
  • tomlkit 0.13.2
pyproject.toml pypi
  • mysql-connector-python ^9.1.0
  • openpyxl ^3.1.5
  • python ^3.11
  • reuse ^4.0.3