Re^2: Best way to read in an XbyX table into a Hash{Key}{Key2}[value] structure

Thank you for your help!

So its not usually from excel sheets, I just listed that in case there was excel markup leftover ..like \r returns or something.

Question though....I don't understand how I then access the information following your method. For example, if I wanted the probability of a AAC to AAA (.0011) how do I get to that value? You've created an array where each cell has the ref to a hash....which in turn holds the key value pairs of each row with respect to that column... correct? How do I access the info for individual cases?

Comment on Re^2: Best way to read in an XbyX table into a Hash{Key}{Key2}[value] structure

Replies are listed 'Best First'.
Re^3: Best way to read in an XbyX table into a Hash{Key}{Key2}[value] structure by rjt (Curate) on Aug 07, 2013 at 20:01 UTC
Thanks for the follow-up. I believe I now understand your requirements. Since my original solution was almost certainly not what you were after, I added a better one to my original node, which will make it possible to do the from/to lookups you need. Mea culpa; it's been a while since I looked at a probability table. :-)	[reply]