We're going to look at some data in Postgresql. To get started, you might want to get some useful tools first.
https://macpostgresclient.com/
brew install postgresql
We're going to look at some data in Postgresql. To get started, you might want to get some useful tools first.
https://macpostgresclient.com/
brew install postgresql
> sessionInfo() | |
R version 3.3.3 (2017-03-06) | |
Platform: x86_64-apple-darwin15.6.0 (64-bit) | |
Running under: OS X El Capitan 10.11.6 | |
locale: | |
[1] en_US.UTF-8/en_US.UTF-8/en_US.UTF-8/C/en_US.UTF-8/en_US.UTF-8 | |
attached base packages: | |
[1] stats graphics grDevices utils datasets methods base |
Year,Period,Area,Adjusted,Preliminary,Rate | |
"2016","Annual","Alameda County","Not Adj","Not Prelim","4.2" | |
"2015","Annual","Alameda County","Not Adj","Not Prelim","4.7" | |
"2014","Annual","Alameda County","Not Adj","Not Prelim","5.8" | |
"2013","Annual","Alameda County","Not Adj","Not Prelim","7.2" | |
"2012","Annual","Alameda County","Not Adj","Not Prelim","8.7" | |
"2011","Annual","Alameda County","Not Adj","Not Prelim","10.1" | |
"2011","Annual","Alameda County","Not Adj","Not Prelim","10.1" | |
"2010","Annual","Alameda County","Not Adj","Not Prelim","10.9" | |
"2010","Annual","Alameda County","Not Adj","Not Prelim","10.9" |
[ | |
{ | |
"elementType": "labels", | |
"stylers": [ | |
{ | |
"visibility": "off" | |
} | |
] | |
}, | |
{ |
//! moment.js | |
//! version : 2.14.1 | |
//! authors : Tim Wood, Iskren Chernev, Moment.js contributors | |
//! license : MIT | |
//! momentjs.com | |
;(function (global, factory) { | |
typeof exports === 'object' && typeof module !== 'undefined' ? module.exports = factory() : | |
typeof define === 'function' && define.amd ? define(factory) : | |
global.moment = factory() |
//! moment.js | |
//! version : 2.14.1 | |
//! authors : Tim Wood, Iskren Chernev, Moment.js contributors | |
//! license : MIT | |
//! momentjs.com | |
;(function (global, factory) { | |
typeof exports === 'object' && typeof module !== 'undefined' ? module.exports = factory() : | |
typeof define === 'function' && define.amd ? define(factory) : | |
global.moment = factory() |
// shorter | |
color = details.leftToPurchase < 0 ? 'red' : '#534F4E'; | |
// more clear | |
if(details.leftToPurchase < 0){ | |
color = 'red'; | |
} else { | |
color = '#534F4E'; | |
} |
?> | |
<li class="one-third first single-item create-board" data-price="000000" data-category="!000000" data-source="000000" data-purchased="100000000000"> | |
<a onClick='iframe_open("/popups/popup-add-item.php?name=<?php echo rawurlencode($project) . '&pnumber=' . $pnumber; ?>", "480", "200", "no")'> | |
<img src="images/plus-sign-large.png" alt="Add New Sum Board"> | |
<p>Add New Item</p> | |
</a> | |
</li> | |
<?php |
def self.high_outliers(column) | |
values = pluck(column) | |
q1 = DescriptiveStatistics::Stats.new(select{|d| d.send(column)<values.median }.map{ |d| d.send(column)}).median | |
q3 = DescriptiveStatistics::Stats.new(select{|d| d.send(column)>values.median }.map{ |d| d.send(column)}).median | |
iqr = q3-q1 | |
select { |d| d.send(column)>(q3 + 1.5 * iqr) } | |
end |
var http = require('http'), | |
fs = require('fs'), | |
loadDomains, getTheTimeFromServerList, formatDateHeader; | |
loadDomains = new Promise(function (resolve, reject) { | |
var servers; | |
fs.readFile('hostnames.txt', 'utf8', function (err, data) { | |
if (err) { | |
reject('Unable to read hostnames.txt'); | |
} |