select
p.web_name,
t.name as club,
r.singular_name_short as position,
max(p.total_points) as total_points
from players p left join teams t on p.team = t.id
left join roles r on p.element_type = r.id
group by p.team;
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import string | |
import random | |
import time | |
chars = string.digits + string.ascii_letters + string.punctuation + ' ' | |
iterations_per_character_revealed = 2 | |
update_delay = 0.05 | |
choices = ['Edmond To', 'Tu Yong Tan', 'Clement Chua', 'Wei Quan Ng'] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import random | |
import re | |
def parse_text(text): | |
"""Returns a list of sentence chains extracted from text.""" | |
text = text.strip() | |
sentences = [] | |
for line in text.splitlines(): |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import praw | |
CLIENT_ID = 'YOUR_CLIENT_ID' | |
CLIENT_SECRET = 'YOUR_CLIENT_SECRET' | |
REDDIT_USERNAME = 'your reddit username' | |
# https://www.reddit.com/r/singapore/comments/8eoesx/rsingapore_random_discussion_and_small_questions/ | |
submission_id = '8eoesx' | |
reddit = praw.Reddit(client_id=CLIENT_ID, client_secret=CLIENT_SECRET, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import argparse | |
import re | |
import sys | |
import time | |
import praw | |
CLIENT_ID = 'YOUR_CLIENT_ID' | |
CLIENT_SECRET = 'YOUR_CLIENT_SECRET' | |
REDDIT_USERNAME = 'your Reddit username' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import argparse | |
import sys | |
import markovify | |
def main(files, n): | |
text = '' | |
for f in files: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
tab | subreddit | id | score | num_comments | |
---|---|---|---|---|---|
hot | gaming | 8ks3o4 | 15084 | 213 | |
hot | aww | 8krvk4 | 13202 | 203 | |
hot | NatureIsFuckingLit | 8ks1sn | 6366 | 172 | |
hot | worldnews | 8krdwg | 17227 | 1940 | |
hot | PrequelMemes | 8krmxy | 10996 | 74 | |
hot | gifs | 8kr91u | 28793 | 597 | |
hot | FortNiteBR | 8krn5p | 10476 | 202 | |
hot | MadeMeSmile | 8krwsu | 4905 | 55 | |
hot | technology | 8krbip | 10103 | 772 |
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.