SocrataOpenDataAnalysis

No algorithm description given

Summary The goal here is to combine my first two algorithms:  /marksskram/SocrataOpenDataQuery   which queries data given a dataset ID, domain, and query (an empty string is equivalent to a SELECT *) and /marksskram/SomeStats   which calculates mean, variance, median, and more.  See  https://gist.github.com/marks/5c1c41df93b9cfa0f681 for a pretty version of the JSON output for the sample below Feedback is always welcome. You can tweet me at @Skram or email me at mark.silverberg@socrata.com Example Inputs to Try The top 100 White House salaries ("salary" column) ["open.whitehouse.gov","rcp4-3y7g","select * order by salary desc limit 100"] City of Chicago owned property ("sq_ft" column) ["data.cityofchicago.org","aksk-kvfp","select * where ward = 20"] Known Issues - Will probably break if you do not do a "select *" - Need to document what happens with null and non-numeric values

Tags
(no tags)

Cost Breakdown

0 cr
royalty per call
1 cr
usage per second
avg duration
This algorithm has permission to call other algorithms which may incur separate royalty and usage costs.

Cost Calculator

API call duration (sec)
×
API calls
=
Estimated cost
per calls
for large volume discounts
For additional details on how pricing works, see Algorithmia pricing.

Internet access

This algorithm has Internet access. This is necessary for algorithms that rely on external services, however it also implies that this algorithm is able to send your input data outside of the Algorithmia platform.


Calls other algorithms

This algorithm has permission to call other algorithms. This allows an algorithm to compose sophisticated functionality using other algorithms as building blocks, however it also carries the potential of incurring additional royalty and usage costs from any algorithm that it calls.


To understand more about how algorithm permissions work, see the permissions documentation.

1. Type your input

2. See the result

Running algorithm...

3. Use this algorithm

curl -X POST -d '{{input | formatInput:"curl"}}' -H 'Content-Type: application/json' -H 'Authorization: Simple YOUR_API_KEY' https://api.algorithmia.com/v1/algo/marksskram/SocrataOpenDataAnalysis/0.1.6
View cURL Docs
algo auth
# Enter API Key: YOUR_API_KEY
algo run algo://marksskram/SocrataOpenDataAnalysis/0.1.6 -d '{{input | formatInput:"cli"}}'
View CLI Docs
import com.algorithmia.*;
import com.algorithmia.algo.*;

String input = "{{input | formatInput:"java"}}";
AlgorithmiaClient client = Algorithmia.client("YOUR_API_KEY");
Algorithm algo = client.algo("algo://marksskram/SocrataOpenDataAnalysis/0.1.6");
AlgoResponse result = algo.pipeJson(input);
System.out.println(result.asJsonString());
View Java Docs
import com.algorithmia._
import com.algorithmia.algo._

val input = {{input | formatInput:"scala"}}
val client = Algorithmia.client("YOUR_API_KEY")
val algo = client.algo("algo://marksskram/SocrataOpenDataAnalysis/0.1.6")
val result = algo.pipeJson(input)
System.out.println(result.asJsonString)
View Scala Docs
var input = {{input | formatInput:"javascript"}};
Algorithmia.client("YOUR_API_KEY")
           .algo("algo://marksskram/SocrataOpenDataAnalysis/0.1.6")
           .pipe(input)
           .then(function(output) {
             console.log(output);
           });
View Javascript Docs
var input = {{input | formatInput:"javascript"}};
Algorithmia.client("YOUR_API_KEY")
           .algo("algo://marksskram/SocrataOpenDataAnalysis/0.1.6")
           .pipe(input)
           .then(function(response) {
             console.log(response.get());
           });
View NodeJS Docs
import Algorithmia

input = {{input | formatInput:"python"}}
client = Algorithmia.client('YOUR_API_KEY')
algo = client.algo('marksskram/SocrataOpenDataAnalysis/0.1.6')
print algo.pipe(input)
View Python Docs
library(algorithmia)

input <- {{input | formatInput:"r"}}
client <- getAlgorithmiaClient("YOUR_API_KEY")
algo <- client$algo("marksskram/SocrataOpenDataAnalysis/0.1.6")
result <- algo$pipe(input)$result
print(result)
View R Docs
require 'algorithmia'

input = {{input | formatInput:"ruby"}}
client = Algorithmia.client('YOUR_API_KEY')
algo = client.algo('marksskram/SocrataOpenDataAnalysis/0.1.6')
puts algo.pipe(input).result
View Ruby Docs
use algorithmia::*;

let input = {{input | formatInput:"rust"}};
let client = Algorithmia::client("YOUR_API_KEY");
let algo = client.algo('marksskram/SocrataOpenDataAnalysis/0.1.6');
let response = algo.pipe(input);
View Rust Docs
Discussion
  • {{comment.username}}