Final Project for IDS 706: Data Engineering Systems
Streamlit Page: https://nick-carroll1-hackduke-welcome-page-streamlit-onpq1t.streamlit.app
We are inspired by a cup of hot chocolate. One Saturday afternoon, when we were brainstorming about the project for this hackathon at McDonald's, Jenny ordered a hot chocolate. However, we disposed of the coffee cup after using it, which is not environmentally friendly. In addition, we notice students mainly use plastic or paper cups when dining on the campus. Therefore, we decided to build an app that helps to recycle the cups when we order drinks at the cafe.
"Cups Adventure" program is designed to encourage students to reduce the amount of disposable cups and promote a more sustainable campus. Reusable cups would be circulated around the campus through borrowing and returning, and sustainability credits could be earned with rewards redeemable after each circulation.
Activities when you embark on a Cup Adventure:
- Borrow : Borrow a cup from your favorite vendor!
- Return: Return the cup before embarking on a new adventure.
- Save the earth: Every time you use a reusable cup, mother earth hugs you very tight to show her thanks
- Create the SQL Database and generate fake data
- Connect Amazon AWS to with SQL Database, store data in AWS database
build code with pip environment (ensure that streamlit has all the dependencies that we need)
Frontend: Streamlit
________________________Hackathon
To introduce people to the idea of using a reusable cup, we use an HTML and CSS webpage, combined with data visualization and insights from the Python library using JavaScript. To engage people with the actual act of using a reusable cup, we create the front end of CupAdventure app, which can be previewed on the link provided.
None of us are proficient in front-end programming. So, learning JavaScript, html5 and CSS overnight is a super big challenge for us. We also have no experience in mobile app programming, but we manage to finish creating the front end of our mobile app.
We are making advancements in front-end knowledge, html5, CSS, javascript, we also manage to embed an interactive graph from an important dataset in the website.
We learned that in making front-end, there are more than one language to combine. We actually learn new languages such as html5, css, and javascript.
- Back-end polishes for the app, implementing cloud storage to make sure the app runs 24/7
- Trial implementation in Fuqua Friday (so many plasticware)
- West campus dining implementation
https://www.earthday.org/fact-sheet-how-much-disposable-plastic-we-use/