# Preparing Data For Statistical Analysis and Reporting

**URL:** <https://www.ruby-forum.com/t/preparing-data-for-statistical-analysis-and-reporting/110290>\
**Category:** Ruby\
**Created:** [July 24, 2007, 11:12pm UTC](https://www.ruby-forum.com/t/preparing-data-for-statistical-analysis-and-reporting/110290 "2007-07-24T23:12:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![robert](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/e95f7d/32.png) [@robert](https://www.ruby-forum.com/u/robert)\
**Post date:** [July 24, 2007, 11:12pm UTC](https://www.ruby-forum.com/t/preparing-data-for-statistical-analysis-and-reporting/110290/1 "2007-07-24T23:12:25Z")

</div>

How much data munging is done by Ruby-ists?

If you need some tools for preparing data for analysis, transforming  
data, and cleaning data up, there are some tools to check out at:

[http://directory.fsf.org/math/stats](http://directory.fsf.org/math/stats)

including:

Vilno  
DAP  
PSPP

DAP is an open-source version of SAS  
PSPP is an open-source version of SPSS  
Vilno uses it’s own language for data transformation, similar to SQL  
SELECT, SAS, and SPSS.

For statistics itself, I am rather curious about Apophenia  
( apparently a C library for statistics that can be called by any  
statistics package).

Robert

---

<div class="post-metadata">

**Author:** ![robert](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/e95f7d/32.png) [@robert](https://www.ruby-forum.com/u/robert)\
**Post date:** [July 25, 2007, 3:51am UTC](https://www.ruby-forum.com/t/preparing-data-for-statistical-analysis-and-reporting/110290/2 "2007-07-25T03:51:58Z")

</div>

Robert wrote:

> DAP
> 
> Robert

Thanks for the pointers! This is actually something I do a lot in my day  
job. Most of the data extraction is done in Perl, mostly because Ruby  
didn’t exist when I wrote most of the code. If there were a couple other  
Ruby programmers around, I’d port it to Ruby/Rails/Ruport.

Nearly all of the statistics I do is in R, also an open source project.  
There is an R-Ruby bridge called “RSRuby”, so that would be another way  
to get into this.

Nearly everything I do these days is large enough that I use either SQL  
Server or PostgreSQL to manage the datasets. By the end of the year I  
expect it will all be in PostgreSQL – the SQL Server licenses are too  
expensive.