Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re: hash and array mismatch

by BrowserUk (Patriarch)
on May 08, 2007 at 02:05 UTC ( #614080=note: print w/replies, xml ) Need Help??


in reply to hash and array mismatch

A hash cannot have duplicate keys, whereas an array can. Hence, the key POSITION NAME is given a value of 9. but then 6 lines later on, the value associated with that key gets overwritten with the value 15. And the key RESULT is initially set to the value 10, but the later overwritten with the value 16. And so on for all the other missing values.

What you can do about it depends upon what you want to do with the hash afterwards. It maybe as simple as reversing the keys and values. The line number (position) will always be unique, so you could use that as the key and the text as the value, but that makes it little more useful than the array.

Perhaps what you want is

foreach my $i ( 0..$#data ) { push @{ $dataPos{ $data[$i] } }, $i; print "$data[$i] -- > $i\n"; }

Which will accumulate an array of positions associated with each value. It would dump something like

$VAR1 = { ' TOTAL QUALITY' => [ 8, 14 ], 'RESULT' => [ 10, 16 ], 'CREATOR' => [ 3 ], ' ' => [ 13, 19, 20 ], 'TOTAL QUALITY' => [ 8 ], 'WELL' => [ 0 ], 'SAMPLE ID' => [ 5 ], 'DISPENSATION ORDER' => [ 2 ], 'POSITION NAME' => [ 9, 15 ], 'QUALITY' => [ 11, 17 ], 'DESCRIPTION' => [ 6 ], 'ENTRY ID' => [ 1 ], 'CREATION DATE' => [ 4 ], 'EDITED' => [ 12, 18 ], 'RUN ID AND DATE' => [ 7 ] };

Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.

Replies are listed 'Best First'.
Re^2: hash and array mismatch
by dana (Monk) on May 08, 2007 at 02:10 UTC

    Thank you so very much.

    As said, I am parsing a data file and was taking it for granted that the headers were unique, but apparently there are multiple columns with the same name.

    Thank you again.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (4)
As of 2023-09-30 21:42 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?