DistributedDoge

## sankey_twitter.ipynb

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                DistributedDoge
                / sankey_twitter.ipynb
            
            
              Created
              February 2, 2024 19:21
            
          
      Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## sankey_draft.ipynb

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                DistributedDoge
                / sankey_draft.ipynb
            
            
              Created
              January 30, 2024 21:54
            
              
                Sankey diagram for all Gitcoin rounds (on Allo v1 protocol)
              
          
      Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## sankey.py
import pandas as pd
import plotly.offline as pyo

data = pd.read_parquet('http://grant-data.xyz/rounds.parquet')
data = data[data['amount_usd'] > 100]
dat = data
dat['donations'] = 'Community'

sankey_fig = make_sankey_graph(
    df=dat,

## markdown_fu.py
import bs4
import markdown
import pandas
import requests
import lxml

chains = requests.get('https://raw.githubusercontent.com/allo-protocol/allo-contracts/main/docs/CHAINS.md').text
html = markdown.markdown(text=chains, extensions=['tables'])

soup = bs4.BeautifulSoup(html, 'html.parser')

## get_donation_events.sql
-- Google Big Query... query(?) to catch all Events emitted by successful donations to old Gitcoin grant round. No matter what contract/round is emitting them.
-- In post-processing might be prudent to check that only official Gitcoin grant rounds are emitting such events.

-- Event ABI corresponds to `Voted` event emitted by QuadraticFundingVotingStrategyImplementation
-- https://etherscan.io/tx/0x02d062a8605c518b07343230b35d9aa23c3781a65e58d45a71ffb607a8b00ced#eventlog

-- NOTE: Won't work for recent Gicoin rounds as ABI has changed.

-- Voted (address token, uint256 amount, index_topic_1 address voter, address grantAddress, index_topic_2 bytes32 projectId, uint256 applicationIndex, index_topic_3 address roundAddress)
	import pandas as pd
	import plotly.offline as pyo

	data = pd.read_parquet('http://grant-data.xyz/rounds.parquet')
	data = data[data['amount_usd'] > 100]
	dat = data
	dat['donations'] = 'Community'

	sankey_fig = make_sankey_graph(
	df=dat,
	import bs4
	import markdown
	import pandas
	import requests
	import lxml

	chains = requests.get('https://raw.githubusercontent.com/allo-protocol/allo-contracts/main/docs/CHAINS.md').text
	html = markdown.markdown(text=chains, extensions=['tables'])

	soup = bs4.BeautifulSoup(html, 'html.parser')
	-- Google Big Query... query(?) to catch all Events emitted by successful donations to old Gitcoin grant round. No matter what contract/round is emitting them.
	-- In post-processing might be prudent to check that only official Gitcoin grant rounds are emitting such events.

	-- Event ABI corresponds to `Voted` event emitted by QuadraticFundingVotingStrategyImplementation
	-- https://etherscan.io/tx/0x02d062a8605c518b07343230b35d9aa23c3781a65e58d45a71ffb607a8b00ced#eventlog

	-- NOTE: Won't work for recent Gicoin rounds as ABI has changed.

	-- Voted (address token, uint256 amount, index_topic_1 address voter, address grantAddress, index_topic_2 bytes32 projectId, uint256 applicationIndex, index_topic_3 address roundAddress)