Beefy Boxes and Bandwidth Generously Provided by pair Networks Cowboy Neal with Hat
Welcome to the Monastery
 
PerlMonks  

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

by ZWcarp (Beadle)
on Aug 07, 2013 at 19:37 UTC ( #1048423=note: print w/ replies, xml ) Need Help??


in reply to Re: Best way to read in an XbyX table into a Hash{Key}{Key2}[value] structure
in thread 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
Re^3: Best way to read in an XbyX table into a Hash{Key}{Key2}[value] structure
by rjt (Chaplain) 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. :-)

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1048423]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (16)
As of 2014-04-16 16:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (433 votes), past polls