DisGraph

A sample bar graph
A sample scatter graph
A sample gold medals distributions between countries during a tournament
A sample double line graph
Spatial line representation of all airports and flights which connect them
A plotting of the cities of Nigeria

Inspiration

As executives for a startup called ReFill, two of the four members take convenience very seriously. They wanted to create another product, fast, which can allow for the general public to interpret scary-looking data at their fingertips.

What it does

It is a Discord Bot that takes .csv files and returns a visual representation after it has gone through Dropbase's system and its api.

How I built it

We built it around Dropbase's API using python, along with the necessary libraries, including but not limited to, matplotlib and geoplotlib.

Challenges I ran into

None of us had worked with APIs before; hence it was the first time anyone was working with APIs. At first we had trouble figuring out how to work it but we finally made it work. Another problem we had was that we weren't familiar with any of the libraries we were dealing with. This made it slower for us to progress as it meant that we had to learn the libraries as we went on. We also had a lot of tiny problems, ranging from spaces and bad indents causing problems to the bot not accepting files at one point.

Accomplishments that I'm proud of

Using the Dropbase API to quickly validate data schema, and upload them to a centralized database, from our view was a huge success as we didn't have any idea on how to execute before we started to having a fully functional one in less than 36 hours. Using the PostgREST API we were able to query the data for what we needed to make the graph. Once the endpoint is expanded upon we could support any file schema and the user could simply select which columns they’d like to use for the scales. We are also proud that we were able to create the different map graphs, as it is a step which took us a while to figure out, but we managed it at the end.

What I learned

We learned how to use the Dropbase API and how to use the different plotting libraries which were available in python.

What's next for DisGraph

We think DisGraph will benefit from the generalization of the plotting functions so that it can take .csv files of any number of columns, which will give the bot more functionality to work with.

Built With

dropbase-api
python

Submitted to

Hack the North 2020++

Created by

Helped team creatively think about subjects and created final submission video, along with any graphics which were created non-programmatically.

Joonseo Lee
Created the graphical representations of data from CSV files with Python and Matplotlib/Geoplotlib libraries. Learned the how to create and manage discord bots with Python.

Jerome Philip
Worked with python libraries such as Matplotlib and Geoplotlib to create graphical representations of user-input data files. Created various functions for the discord bot to have commands for.

Farzad Rahman
UW CE 26' btw site's ssl certificate not working but trust me im not stealing ur data
Worked on the backend, implementing our system with the Dropbase API, and connecting them with the bot commands. Learned a lot about web requests and REST API's.

Brandon Ly