Analyzed 27 days ago
A tool which transforms a CSV file into another CSV file using a SQL statement.
Also converts CSV to JSON.
Many tools spit out CSV, or are able to as one of output options. Also, in hudson, you can very simply log any values you get into bash like echo " $val2, $val2" >> data.csv, for each
... [More]
build or part of a build. So it can be kind of integration tool.
Then you can do quite complex queries – from a flat table, you can actually do subselects and then left joins, which gives you very powerful tool to process the data into something what is ready for plotting as-is – that means, data filtered, cleaned, aggregated, converted, aligned, sorted, etc.
Example:
crunch input.csv output.csv "SELECT AVG(duration) AS durAvg FROM (SELECT * FROM indata ORDER BY duration LIMIT 2 OFFSET 6)"` [Less]
4.93K
lines of code
0
current contributors
4 months
since last commit
1
users on Open Hub