Skip to content

Instantly share code, notes, and snippets.

View ana0's full-sized avatar

ana0

235 followers · 36 following
View GitHub Profile
@ana0
ana0 / gist:1eda8d9e44a3eae5ffa704897bf4c27e
Created April 25, 2019 13:15
CREATE OR REPLACE VIEW accounts.address_token_balances AS (
SELECT
address_hash,
token_contract_address_hash,
block_number,
SUM(amount) OVER (
PARTITION BY address_hash, token_contract_address_hash
ORDER BY block_number ASC
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
) AS amount
@ana0
ana0 / keybase.md
Created January 2, 2019 03:13

Keybase proof

I hereby claim:

  • I am ana0 on github.
  • I am isthisa (https://keybase.io/isthisa) on keybase.
  • I have a public key whose fingerprint is EEF7 E570 982B 119B 3386 0F2C 387B 49FC 57FE 5D83

To claim this, I am signing this object:

@ana0
ana0 / tictactoe_refactored.py
Created April 11, 2016 02:15
import random
class Board(object):
def __init__(self):
self.board = [[" "," "," "], [" "," "," "], [" "," "," "]]
def print_board(self):
topstr = " a b c"
linestr = " +-----+-----+-----+"
rowstr = "%s | %s | %s | %s |"
@ana0
ana0 / tictactoe.py
Created April 9, 2016 02:49
import random
class Board(object):
def __init__(self):
self.board = [[" "," "," "], [" "," "," "], [" "," "," "]]
def print_board(self):
topstr = " a b c"
linestr = " +-----+-----+-----+"
@ana0
ana0 / tictactoe.py
Created April 8, 2016 01:58
import random
class Board(object):
def __init__(self):
self.board = [[" "," "," "], [" "," "," "], [" "," "," "]]
def print_board(self):
topstr = " a b c"
linestr = " +-----+-----+-----+"
@ana0
ana0 / gist:602151bc88d930ef2793
Created March 13, 2016 19:27
def probabilities_matrix(text):
bigrams = {}
for i in range(len(text)):
try:
if (text[i], text[i+1]) in bigrams:
bigrams[(text[i], text[i+1])].append(text[i+2])
else:
bigrams[(text[i], text[i+1])] = [text[i+2]]
except IndexError:
return bigrams
@ana0
ana0 / gist:352cd80472afe699faec
Created July 16, 2014 17:06
def clockwise_rotation(grid):
#returns a representation of the grid rotated clockwise
rotated = [["" for i in grid] for i in grid]
l = len(grid)
for r in range(l):
x = l - r
for c in range(l):
rotated[r][c] = grid[x-1][r]
return rotated
@ana0
ana0 / gist:a2dca0394f154a09956e
Created July 11, 2014 15:55
def create_grid(x):
#creates nested set of lists that represent a grid matrix
gridarray = [[i for i in range(x)] for i in range(x)]
return gridarray
def rotate_grid_counterclockwise(grid):
#returns a representation of what you'd get if you rotated the matrix 90 degress counterclockwise
rotated = [["" for i in grid] for i in grid]
x = len(grid)
r = 0
@ana0
ana0 / gist:0d267b5057d7d6bd0689
Created June 30, 2014 17:24
class Sequence(object):
def __init__(self, query, answers):
self.query = query
self.answers = answers
def text_wrapping(self, text):
#simple textwrapper, check how much space is left on the x-axis of the screen
#if a word's length is longer than the remaining space, adds a newline
maxx = stdscr.getmaxyx()[1] - stdscr.getyx()[1]