Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
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

Replies are listed 'Best First'.
Re^3: Best way to read in an XbyX table into a Hash{Key}{Key2}[value] structure
by rjt (Deacon) 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?
[Eily]: LanX pretty much everywhere except in 8MB ?
[Eily]: s/by/bye/ someone hacked my keyboard I'm sure
[LanX]: good point! :)
[Eily]: LanX I don't understand the question though, you want to know what is taking so much space?
[Tanktalus]: Probably the swapfile :)

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (12)
As of 2017-09-20 16:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    During the recent solar eclipse, I:









    Results (237 votes). Check out past polls.

    Notices?