Edson Andrade edson-github

## importJSON.gs
/**
 * 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();

## pydata_denver_demo.py
import requests
import json
from collections import namedtuple
from contextlib import closing
import sqlite3

from prefect import task, Flow

## extract
@task

## mpg.csv

          
            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
	/**
	* 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();
	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