On Tuesday 10 April 2007 00:14, Karsten Hilbert wrote: > On Tue, Apr 10, 2007 at 07:28:22AM +1000, syan tan wrote: > > ON another discussion group, there was mention of inadequate statistical > > functions in sql ( the example given was the difficulty of doing > > a time series analysis ), > > Not sure if it is true. > > It is. > > > Is there a library interface to something like 'R' (which I know very > > little about), that could be gradually exposed in gnumed ? > > You can load R right in PostgreSQL as a procedural language > and use it within the GNUmed report generator. How about > that ? ;-) > > > e.g. something like " select symptoms, temperature, blood pressure, > > respiratory_rate, age, duration_of_symptoms, location from > > patient_records group by location ", and then do some statistical > > analysis function on the result. > > For that we'd have to add post-processing to query results > and import an R binding. Which can be done but needs work to > get done.
That's not too hard. I did this for my thesis. Just use rpy bindings and you can manipulate data all you want. Just have a script run the queries and work with the data. used it to calculate some statistics and plot the data with gnuplot. > > Karsten -- Sebastian Hilbert Leipzig / Germany [www.gnumed.de] -> PGP welcome, HTML ->/dev/null _______________________________________________ Gnumed-devel mailing list [email protected] http://lists.gnu.org/mailman/listinfo/gnumed-devel
