DATALAND

data analysis with graphistry (Devices source, countries, events, device categories, etc.)
data analysis with graphistry (interactions, data tables, node tables, histograms)
Data mapping to graph (tigerGraph)
Data schemas in tgcloud (tigerGraph)
devices by source
Graphistry account
Germany and its supply of hospital equipment
(graphistry)

Inspiration

In fact, since the beginning of the Covid19 and before, the repartition of medical devices in the world is unequal. In this project, I analysed the repartition of those equipment in all the counties to show those that are the most in need, which are the providers providing the most devices, so that it can help to propose new country tags that can be help.

What it does

The project is analysing the "International Medical Devices Database" I got from https://medicaldevices.icij.org. It analyses the database and link the the devices providers to devices, the devices to device categories and sources, and the devices to the countries where they are provided. This analyse is shows in tables, then plotted in space using GRAPHISTRY and then give the ability to show exactly the amount of devices provided by a particular provider, moreover, it shows the exact number of devices provided to countries though years, using histograms and data table.

How we built it

-->First I created TigerGraph Cloud account and got familiar with the environment, and I followed some tutorials. -->I Downloaded the databe from https://medicaldevices.icij.org --> I created the project in tgcloud.com, created design schemas, uploaded the database table and mapped them to the graph, I made tests and wrote the queries. --> I created and account on graphistry.com, created my project and got my credentials --> The, I created the streamlit application in my computer using the python virtual machine --> I installed some libraries ("pyTigerGraphBeta", "graphistry", ...) --> I connected my application to the tgcloud project using the credentials, the graphname that I got from my tgcloud project and the token I generated. Same, I connected the application to my graphistry project using the credentials. --> Then I wrote the code. connecting to tgcloud, querying data and using graphs and graphistry to show the analysis --> While doing all this I was testing continuously and reading documents (GSQL...)

Challenges we ran into

The main challenge that I faced Lack of knowledge. In fact, it was my first experience with almost all the technologies I used (GSql, TigerGraph, Streamlit, Graphistry The other challenge I faced was the difficulties while making the video. Because the application was taking too long to retrieve data, so knowing that the video should be only 3 minutes, it was kind of difficult to mage that situation

Accomplishments that we're proud of

I'm proud to the Accomplishments of: --> creating a completed streamlit application, --> Creating a completed Tigergraph project --> Making beautiful graphs and cleaning a huge amount of data --> Learning new technologies

What we learned

I learned a lot through the completion of this project: --> I leaned a lot on TigerGraph (Creating Project, loading data, generating credential, access the project remotely), I learned to visualize the interaction between database entities directly in the tgCloud platform --> I learned a wonderful technology (GSql): Is a great query language that offers great possibility in queries. It's the favourite thing I did. I fell in love with this language --> I learned Graphistry (It was also my first experience with it) --> I learned how to associate all those technologies in a single project.

What's next for DATALAND

The next step is to make add functionalities and make the project available to the public and organizations. I think it can help, because some countries are more in need but are not provide in equipment mostly in this pandemic period