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
// Credit Christian Boutin | |
function exportSheetAsJSON() { | |
var sheet = SpreadsheetApp.getActiveSheet(); | |
var rows = sheet.getDataRange(); | |
var numRows = rows.getNumRows(); | |
var numCols = rows.getNumColumns(); | |
var values = rows.getValues(); | |
var output = ""; | |
output += "{\""+sheet.getName()+"\" : {\n"; |
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
function pullJSON() { | |
var ss = SpreadsheetApp.getActiveSpreadsheet(); | |
var sheets = ss.getSheets(); | |
var sheet = ss.getActiveSheet(); | |
var url="http://example.com/feeds?type=json"; // Paste your JSON URL here | |
var response = UrlFetchApp.fetch(url); // get feed | |
var dataAll = JSON.parse(response.getContentText()); // |
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
function connect_to_DB() { | |
// make the connection | |
var connection = Jdbc.getConnection("jdbc:mysql://[database URL or IP]:[port number]/[database name]", "[user name]", "[password]"); | |
// perform the query | |
var SQLstatement = connection.createStatement(); | |
var result = SQLstatement.executeQuery("SELECT * FROM users"); | |
// choose a range in sheet | |
var ss = SpreadsheetApp.getActiveSpreadsheet(); |
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
# http://learnr.wordpress.com/2009/05/18/ggplot2-three-variable-time-series-panel-chart/ | |
# http://www.talkstats.com/showthread.php/21228-time-series-in-ggplot2 | |
# http://had.co.nz/ggplot2/ | |
# http://stats.stackexchange.com/questions/14513/align-multiple-ggplot2-plots-with-grid | |
# http://wiki.stdout.org/rcookbook/Graphs/Facets%20(ggplot2) | |
# colors: red: "730202", lightyellow: D5D95B, lightgreen: 4F7302 midgreed=274001 darkgreen=092601 | |
setwd('~/repositories/uni/thesis-repos/Opad4lsssExperiments/r_scripts/') | |
library(ggplot2) | |
library(gridExtra) |
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
library(ggplot2) | |
library(ggmap) | |
library(plyr) | |
library(grid) | |
library(gridExtra) | |
# read in cleaned up data | |
dat <- read.table("quakes.dat", header=TRUE, stringsAsFactors=FALSE) | |
# map decimal magnitudes into an integer range |
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
library(RCurl) | |
library(XML) | |
library(plyr) | |
#' get the Qualys SSL Labs rating for a domain+cert | |
#' | |
#' @param site domain to test SSL configuration of | |
#' @param ip address of \code{site} (will resolve it and take\cr | |
#' first response if not specified, but that may not always work as you expect) | |
#' @param pause timeout between tries (default 5s) |
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
require(redshift) | |
conn <- redshift.connect("jdbc:postgresql://mycluster.redshift.amazonaws.com:5439/data", "user", "pass") | |
# we can retrieve a list of tables | |
tables <- redshift.tables(conn) | |
# and get some info about the columns in one of those tables | |
cols <- redshift.columns(conn, "weblog") |
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
/** | |
* A script to automate requesting data from Google Analytics. | |
* | |
* @author nickski15@gmail.com (Nick Mihailovski) | |
*/ | |
/** | |
* The name of the configration sheet. | |
* And various parameters. |
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
function onOpen(){ | |
// example send for Sheets | |
sendGAMP("UA-XXXX-1", SpreadsheetApp.getActiveSpreadsheet().getUrl()); | |
// example send for Documents | |
//sendGAMP("UA-XXXX-1", DocumentApp.getActiveDocument().getUrl()); | |
// example send for Forms *NOTE* getUrl not implemented yet in New Sheets | |
//sendGAMP("UA-XXXX-1", FormApp.getActiveForm().getUrl()); | |
} |
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
Table_1: | |
Load * | |
From C:\Users\m.parzakonis\Google Drive\MyCodeRants\QlikView repository\Applications\LivePricing\Data\*.csv | |
(txt, codepage is 1253, embedded labels, delimiter is ',', msq); |