ttomasz
/ google_sheets_example.py
Created
May 24, 2023 19:16
Query Google Spreadsheet directly using Duckdb and Fabduckdb extension
This file contains hidden or 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 duckdb | |
| import fabduckdb | |
| import gspread | |
| import pandas as pd | |
| def read_gsheet(service_account_json_path: str, gsheets_url: str, worksheet_name: str) -> pd.DataFrame: | |
| gc = gspread.service_account(filename=service_account_json_path, scopes=gspread.auth.READONLY_SCOPES) | |
| gsheet = gc.open_by_url(gsheets_url) | |
| data = gsheet.worksheet(worksheet_name).get_all_records() |
mx-moth
/ chunksof.py
Last active
August 12, 2021 21:56
Split a generator up in to chunks of size `n`, without walking the list or keeping items in memory needlessly
This file contains hidden or 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
| from itertools import chain, islice | |
| class splitter: | |
| """Helper class for splitat.""" | |
| def __init__(self, iterable, count): | |
| self.iterator = iter(iterable) | |
| self.count = count | |
| self.queue = [] |
giuseppebonaccorso
/ twitter_sentiment_analysis_convnet.py
Last active
March 16, 2020 19:26
Twitter Sentiment Analysis with Gensim Word2Vec and Keras Convolutional Networks
This file contains hidden or 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 keras.backend as K | |
| import multiprocessing | |
| import tensorflow as tf | |
| from gensim.models.word2vec import Word2Vec | |
| from keras.callbacks import EarlyStopping | |
| from keras.models import Sequential | |
| from keras.layers.core import Dense, Dropout, Flatten | |
| from keras.layers.convolutional import Conv1D |
cazepeda-zz
/ window.location.href
Created
October 28, 2012 02:02
Bookmarklet to append a string to the end of a URL
This file contains hidden or 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
| window.location.href | |
| ==================== | |
| Bookmarklet to append a string to the end of the URL. | |
| 1. Create bookmark. | |
| 2. Edit bookmark URL(Chrome) / Location(Firefox) to include this code: javascript:window.location.href=window.location.href+'REPLACETHIS'; | |
| 3. Now make use of that bookmarklet. |