ODHack: Analyze user behavior across different lending protocols.

[lukaspetrasek]

"Analyze user behavior across different lending protocols.

Steps: 1) Load the data on loans for all lending protocols from the Google Storage. For example, https://storage.googleapis.com/derisk-persistent-state/zklend_data/loans.parquet is the file with loans for zkLend. It contains the information about the user, protocol, the user's collateral and debt (tokens and amounts). Write the loading part in a way that the source can be easily changed from the Google Storage to a local database. 2) Visualize the behavior of a single user across the lending protocols in a Jupyter notebook. Use the following tokens: ""ETH"", ""wBTC"", ""USDC"", ""DAI"", ""USDT"", ""wstETH"", ""LORDS"", ""STRK"", ""UNO"" and ""ZEND"". You should be able to use the visualizations to answer the following questions:

• How many users provide liquidity on just 1 protocol? How many users use 2, or more protocols?
• How many users borrow on just 1 protocol? How many users use 2, or more protocols?
• Created a Venn diagram to visualize the above.
• Visualize the above taking into account the staked/borrowed capital. I.e. if a user has e.g. 10k USD (parameter) worth of capital deposited in the pools, how is it distributed across lending protocols?
• Visualize the above on a per token basis.
• Feel free to come up with your own questions, metrics, hypotheses and visualizations."

Definition of Done The code functions well and is documented, the analysis provides meaningful outputs and answers the questions from the setup.

[vibenedict]

Hi, can i jump on this issue

[NueloSE]

Hi @lukaspetrasek can I work on this

[lukaspetrasek]

Hi, can you guys please tell me something about you, what skills/experience do you have and how do you plan to tackle this issue? This task is not simple, so I have to learn more information before I assign anyone 🙏🏼

[NueloSE]

Hi, can you guys please tell me something about you, what skills/experience do you have and how do you plan to tackle this issue? This task is not simple, so I have to learn more information before I assign anyone 🙏🏼

I have worked on something similar to this before the difference was the dataset was stored in a csvfile not on a Google storage.

This project basically involves data visualization for informed decision making.

For this project i will be using python.

Steps to tackle task

1. Install required libraries like pandas, matplotlib, seaborn etc
2. Load the data from google storage using the google cloud sdk
3. Analyze and visualize user behavior

• using a jupyter notebook
• visualize user behavior across protocols
• create the venn diagram
• visualize staked capital using the appropriate chart
• perform token analysis
  4. Documentation of the codes

[lukaspetrasek]

Okay, assigning you @NueloSE 👍🏼

@NueloSE Let me know if everything is clear. If you have any questions, please ask here. What is you TG handler please? 🙏🏼

Consider joining our TG group. See also our contributor guidelines.

[lukaspetrasek]

Hi @NueloSE , I assume the PR is ready for review, right?

[NueloSE]

@lukaspetrasek, i have implemented all requested changes. It is ready for review : a676ecc