473,781 Members | 2,718 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Dumping objects into spreadsheet readable text (design question)

_
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.

TIA

Jan 3 '07 #1
0 896

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
6528
by: David Gerstman | last post by:
I've written an application for reading information from a spreadsheet and allowing the user to add and update information in the spreadsheet. One spreadsheet I accessed in this fashion is now unreadable and get an application error when I open it. I also can't delete it. I'm assuming that I didn't properly close it down once. Is there any way I can correct the problem I finally got the application working OK. My remaining problem...
2
3961
by: Patrick | last post by:
I'm using Jakarta-POI to create a huge Excel spreadsheet. I get the error below when the spreadsheet grows to a large size. It seems to have something to do with the number of "cell" objects that I create. If I destroy other objects that I don't need any more, then I can create more "cell" objects. Unfortunately, I cannot destroy any more of my other objects without breaking the program. This does not appear to be a problem that is...
4
4962
by: Howard | last post by:
I am trying to use DoCmd.TranferSpreadsheet to import a spreadsheet into an Access table that's not the CurrentDB. I have the database open, but I don't see how to tell the TransferSpreadsheet command that the table is not in the CurrentDB. Is there a way to specify a filename and table within the table string of the TransferSpreadsheet command? Is there a way of temporarily changing the CurrentDB to be the other database so the...
2
3989
by: Peter | last post by:
I have a Query called "DATA" that contains 60 records with 6 fields of data. I want to dump the query results into a specific xls file. The first worksheet of this xls file has space for the query in the first 6 fields (columns A - F) but the rest of the columns (G - T) has values and formulas based on data needed from the Query. The second worksheet has graphs based on all the data of the first worksheet.
14
14314
by: vince | last post by:
Can I add (append) to an xml file that already contains a serialized object, and be able to deserialize to either or both objects from the same file...??? How is this done...?? thanks, vince
7
8224
by: Jo | last post by:
Hi, How can i differentiate between static and dynamic allocated objects? For example: void SomeFunction1() { CObject *objectp = new CObject; CObject object;
6
2248
by: Tim Hunter | last post by:
I am using Access 2003 under WinXP. I currently support a huge Excel Wokbook that is a maintenance nightmare. There are about 15 worksheets each with lots of formulas...Anyway I am thinking of converting this application to an Access solution and specifically using Class Objects. I am comfortable with Access but I have never worked with creating Classes. Finally my question. I am thinking of creating one Class Form Object to match one...
5
1354
by: news.microsoft.com | last post by:
I'm strongly considering abandoning the one-physical-file-per-page model and going with an arcitecture that simply loads content from classes dynamically. There will be only one page that a user will go to, and all variation from navigation will come from AJAX calls to load and replace content in a main frame. .... so my concern with this is, perhaps the browsers will leak memory or do something obscurely wierd with enough loading and...
55
3993
by: tonytech08 | last post by:
How valuable is it that class objects behave like built-in types? I appears that the whole "constructor doesn't return a value because they are called by the compiler" thing is to enable built-in-like behavior for objects of class type. That leads to the "necessity" for the exception machinery so that errors from constructors can be handled. Is all that complexity worth it just to get built-in-like behavior from class objects? Maybe a...
0
9639
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10308
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10143
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10076
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8964
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6729
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5375
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5507
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
2870
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.