From: John Nott <JNott@...>
Date: 2007-10-09T01:18:12+09:00
Subject: Re: MATRIX PROBLEMS (AGAIN!)

Good Points!!! (hope my explanation makes sense!)

1) Start off writing a program that works on a small amount of data, 
e.g. a file with this in it:

10,20,30
40,50,60

2) Always post an example of the format of your data, so we all know 
what you are dealing with.

The format of my data is a .csz file which has been created from an excel sheet. It has 19 columns and 649 rows. The first row is a column title (eg: zone_ID, Population, Population0_16.... etc) the following rows are all integer values. So its pretty much a standard excel sheet.

3)  Clearly state what the results should be.  At this point I still 
don't have any idea whether you want integers in your matrix or strings.

I would like (within OmniTrans) to read the data in and store it in a matrix. As a very green ruby programmer (dropped in at the deep end!), If i was able to achieve this, that would be a major milestone for me. 

4) State what you intend to do with the result, so that people will have 
a better idea of *what you really need* rather that what you say you 
want.

My longer term objective is to do some fixes on this data. For example. I may want to say "look at cell (15,1), if this cell is greater than (15,5) then change this cell to the value of (15,15) - that sort of thing. An even longer term objective is to take the 'fixed' dataset and link it via ODBC to a data warehouse (this is way off as you can imagine)

I hope this helps explain myself and i really appreciate all the help from the listers!!! If i ever get to grips with ruby I will certainly be answering queries!!

Cheers,

- John


-----Original Message-----
From: list-bounce@example.com [mailto:list-bounce@example.com]On Behalf
Of 7stud --
Sent: 08 October 2007 16:17
To: ruby-talk ML
Subject: Re: MATRIX PROBLEMS (AGAIN!)


John Nott wrote:
> Hi!
> This seems to work very well thanks but the results are produced in a 
> long string. Is it possible to create these figures as a matrix? 
> (resembling something like excel)
> Thanks for your help.
> - John

Here are some guidelines:

1) Start off writing a program that works on a small amount of data, 
e.g. a file with this in it:

10,20,30
40,50,60

2) Always post an example of the format of your data, so we all know 
what you are dealing with.

3)  Clearly state what the results should be.  At this point I still 
don't have any idea whether you want integers in your matrix or strings.

4) State what you intend to do with the result, so that people will have 
a better idea of *what you really need* rather that what you say you 
want.




-- 
Posted via http://www.ruby-forum.com/.


#####################################################################################
This e-mail message has been scanned for Viruses and Content and cleared 
by MailMarshal
#####################################################################################