Skip to content

Instantly share code, notes, and snippets.

@ianschuler
Created June 18, 2014 21:21
Show Gist options
  • Save ianschuler/d6b777426ea494155103 to your computer and use it in GitHub Desktop.
Save ianschuler/d6b777426ea494155103 to your computer and use it in GitHub Desktop.
[
{
"op": "core/text-transform",
"description": "Text transform on cells in column zip using expression grel:\"00000\"[0,5-value.length()] + value",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "zip",
"expression": "grel:\"00000\"[0,5-value.length()] + value",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/column-addition-by-fetching-urls",
"description": "Create column district at index 1 by fetching URLs based on column zip using expression grel:\"https://congress.api.sunlightfoundation.com//districts/locate?zip=\" + escape(value,'url') + \"&apikey=adada097e41645b4a2e7c4dab5917848\"",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "district",
"columnInsertIndex": 1,
"baseColumnName": "zip",
"urlExpression": "grel:\"https://congress.api.sunlightfoundation.com//districts/locate?zip=\" + escape(value,'url') + \"&apikey=adada097e41645b4a2e7c4dab5917848\"",
"onError": "set-to-blank",
"delay": 0
},
{
"op": "core/column-split",
"description": "Split column district by separator",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "district",
"guessCellType": true,
"removeOriginalColumn": true,
"mode": "separator",
"separator": "\"count\":",
"regex": false,
"maxColumns": 2
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column district 2 using expression grel:value[0]",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "district 2",
"expression": "grel:value[0]",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/column-rename",
"description": "Rename column district 2 to dictrict_options",
"oldColumnName": "district 2",
"newColumnName": "dictrict_options"
},
{
"op": "core/column-split",
"description": "Split column district 1 by separator",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "district 1",
"guessCellType": true,
"removeOriginalColumn": true,
"mode": "separator",
"separator": "\",\"district\":",
"regex": false,
"maxColumns": 0
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column district 1 1 using expression grel:value.substring(-2)",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "district 1 1",
"expression": "grel:value.substring(-2)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/column-split",
"description": "Split column district 1 2 by separator",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "district 1 2",
"guessCellType": true,
"removeOriginalColumn": true,
"mode": "separator",
"separator": "}",
"regex": false,
"maxColumns": 2
},
{
"op": "core/column-removal",
"description": "Remove column district 1 2 2",
"columnName": "district 1 2 2"
},
{
"op": "core/column-rename",
"description": "Rename column district 1 1 to State",
"oldColumnName": "district 1 1",
"newColumnName": "State"
},
{
"op": "core/column-rename",
"description": "Rename column district 1 2 1 to District 1",
"oldColumnName": "district 1 2 1",
"newColumnName": "District 1"
},
{
"op": "core/column-split",
"description": "Split column district 1 3 by separator",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "district 1 3",
"guessCellType": true,
"removeOriginalColumn": true,
"mode": "separator",
"separator": "}",
"regex": false,
"maxColumns": 2
},
{
"op": "core/column-rename",
"description": "Rename column district 1 3 1 to District 2",
"oldColumnName": "district 1 3 1",
"newColumnName": "District 2"
},
{
"op": "core/column-removal",
"description": "Remove column district 1 3 2",
"columnName": "district 1 3 2"
},
{
"op": "core/column-split",
"description": "Split column district 1 4 by separator",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "district 1 4",
"guessCellType": true,
"removeOriginalColumn": true,
"mode": "separator",
"separator": "}",
"regex": false,
"maxColumns": 2
},
{
"op": "core/column-rename",
"description": "Rename column district 1 4 1 to District 3",
"oldColumnName": "district 1 4 1",
"newColumnName": "District 3"
},
{
"op": "core/column-removal",
"description": "Remove column district 1 4 2",
"columnName": "district 1 4 2"
},
{
"op": "core/column-split",
"description": "Split column district 1 5 by separator",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "district 1 5",
"guessCellType": true,
"removeOriginalColumn": true,
"mode": "separator",
"separator": "}",
"regex": false,
"maxColumns": 2
},
{
"op": "core/column-rename",
"description": "Rename column district 1 5 1 to District 4",
"oldColumnName": "district 1 5 1",
"newColumnName": "District 4"
},
{
"op": "core/column-removal",
"description": "Remove column district 1 5 2",
"columnName": "district 1 5 2"
},
{
"op": "core/mass-edit",
"description": "Mass edit cells in column district 1 6",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "district 1 6",
"expression": "value",
"edits": [
{
"fromBlank": false,
"fromError": false,
"from": [
"31}],"
],
"to": "31"
}
]
},
{
"op": "core/column-addition",
"description": "Create column District_1st option at index 2 based on column State using expression grel:value + \"-\" + cells[\"District 1\"].value",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "District_1st option",
"columnInsertIndex": 2,
"baseColumnName": "State",
"expression": "grel:value + \"-\" + cells[\"District 1\"].value",
"onError": "set-to-blank"
},
{
"op": "core/column-rename",
"description": "Rename column district 1 6 to District 5",
"oldColumnName": "district 1 6",
"newColumnName": "District 5"
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column time using expression value.toDate()",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "time",
"expression": "value.toDate()",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment