Skip to content

Instantly share code, notes, and snippets.

View edson-github's full-sized avatar
🏠
Working from home

Edson Andrade edson-github

🏠
Working from home
View GitHub Profile
@edson-github
edson-github / importJSON.gs
Created August 18, 2021 20:35 — forked from stefanjudis/importJSON.gs
API data in google sheets
/**
* Retrieves all the rows in the active spreadsheet that contain data and logs the
* values for each row.
* For more information on using the Spreadsheet API, see
* https://developers.google.com/apps-script/service_spreadsheet
*/
function readRows() {
var sheet = SpreadsheetApp.getActiveSheet();
var rows = sheet.getDataRange();
var numRows = rows.getNumRows();
@edson-github
edson-github / pydata_denver_demo.py
Created March 15, 2021 02:32 — forked from lauralorenz/pydata_denver_demo.py
Pydata Denver basic ETL flow
import requests
import json
from collections import namedtuple
from contextlib import closing
import sqlite3
from prefect import task, Flow
## extract
@task
mpg cylinders displacement horsepower weight acceleration model_year origin name
18 8 307 130 3504 12 70 1 chevrolet chevelle malibu
15 8 350 165 3693 11.5 70 1 buick skylark 320
18 8 318 150 3436 11 70 1 plymouth satellite
16 8 304 150 3433 12 70 1 amc rebel sst
17 8 302 140 3449 10.5 70 1 ford torino
15 8 429 198 4341 10 70 1 ford galaxie 500
14 8 454 220 4354 9 70 1 chevrolet impala
14 8 440 215 4312 8.5 70 1 plymouth fury iii
14 8 455 225 4425 10 70 1 pontiac catalina