Hi, I'm looking for a program that automatically writes simple descriptive, qualitative summaries of quantitative data. That means I want the automatic production of an actual paragraph of written summary that describes the statistical data.
The data are simple trend data on society -- raw numbers and percentages for various indicators (e.g, indicators for people in poverty, average income, college degree attainment, etc), across many years, for each county in California. The data are in over 100 csv (excl) files. They are not all in the exact same format, but typically do have the same basic format -- the name of the file represents the indicator, and each file has counties in the rows, years in the columns, and rates in the cells.
I want the program to be reusable, so new summaries can be produced automatically when new data are added. The descriptive summary would describe the indicator, the location the indicator is measuring (e.g, which state and county), the existing rates, past rates, and changes in the rates over time. For example, the output the program would produce would look like this,
"This indicator is the percentage of people with a college degree. In Fresno County, California, the rate for 2013 is 22 percent. That is a 1% increase from the last measurement in 2012, a 5% increase from 5 years ago in 2008 when the rate was 17 percent, and 8% increase from 10 years ago in 2003 when the rate was 14 percent."
This above paragraph in quotes is an example of the actual output that the program needs to produce.
Obviously the percentages, years, indicator, and county would vary, and the program you build would need to be able to produce the same basic output structure for data that varies by percentage, years, indicator, and county. All output would look the same as above, with changes in the wording (depending on the specific quantitative data) for the county, indicator, years, and percentages.
The budget is negotiable, but thank you for keeping costs low, as this is for an educational nonprofit.
P.S. I am open to nearly any technology you want to use, as long as it successfully completes the job.