Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Python > Dumping objects into spreadsheet readable text (design question)

Thread Tools

Dumping objects into spreadsheet readable text (design question)

Posts: n/a
Hi Pythonistas and Pythonistos,

I am doing some fairly complex statistical analyses and trying to
display the output in a form readable to technicians not yet
enlightened by the wonders of python (ie they still use either Excel,
S-PLUS/R, or Matlab only). I need to dump the results into text such
that these users can do further processing, and I am looking for ideas
on good ways to do this.

Note that formatting and displaying simple lists of named coeffecients
or tables would easy; the problem is that these analyses (Lee-Carter
mortality forecasts, for anyone who cares) require at least a single
two-dimensional matrix of rates and ~12 scalar coefficients, and they
generate 4 two-dimensional matrices, several three-dimensional
matrices, and 20 or so scalar coefficients. Each of these pieces of
data also has a canonical name with which they must be labeled in the
output. All of these pieces of data go together. Finally, I would
like to find some way to do this generally, so when my boss comes up
with a new analysis I can re-use this text dump code.

Has anybody done this?

I am thinking of using cheetah, but I am still pondering design, hoping
for list inspiration!

pprint won't work because users will want to import into a spreadsheet,
and it displays lots of "{" etc.

Feel free to cc me on the reply, as I read the list as digest.


Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Hi is there a simple way to turn the value returned byGetLastError() into a readable string thanks Jack Boot C Programming 1 12-22-2010 05:15 PM
How to convert x (elapsed) milliseconds into human-readable format "..d..h..m..s" ? Ulf Meinhardt Java 0 09-13-2009 07:58 AM
How to marshal objects to readable files? nielinjie Python 4 09-16-2008 03:03 AM
Re: Dumping web report data into Excel Mark Rae ASP .Net 2 12-19-2006 12:17 PM
how to make the HTML output from XSL process readable in text form? jaydog XML 2 11-09-2004 05:06 PM