Visit Our UNIX and Linux User Community


compare 2 arrays in perl


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting compare 2 arrays in perl
# 1  
Old 08-05-2009
compare 2 arrays in perl

Hi Im supposed to compare lines in a file :
KB0005 1019 T IFVATVPVI 0.691 PKC YES
KB0005 1036 T YFLQTSQQL 0.785 PKC YES
KB0005 1037 S FLQTSQQLK 0.585 DNAPK YES
KB0005 1045 S KQLESEGRS 0.669 PKC YES
KB0005 1045 S KQLESEGRS 0.880 unsp YES
KB204320 1019 T IFVATVPVI 0.699 PKC YES
KB204320 1036 T YFLQTSQQL 0.789 PKC YES
KB204320 1037 S FLQTSQQLK 0.589 DNAPK YES
KB204320 1045 S KQLESEGRS 0.880 unsp YES



and print the lines that differs or dont repeat, which i managed to do by first putting lines into 2 arrays (the lines differ in names KB0005 and KB204320) and then by writing a perl script:
Code:
foreach $item (@a1, @a2) { $count{$item}++;}

foreach $item (keys %count) {
    if ($count{$item} == 2) {
        next;
    } else {
        push @diff, $item;
    }
}

my @sorted =sort @diff;
#print "\nIntersect Array = @isect\n";
foreach my $el(@sorted){
print "$el\n";
}

OUTPUT:
1019 T IFVATVPVI 0.691 PKC
1019 T IFVATVPVI 0.699 PKC
1036 T YFLQTSQQL 0.785 PKC
1036 T YFLQTSQQL 0.789 PKC
1037 S FLQTSQQLK 0.585 DNAPK
1037 S FLQTSQQLK 0.589 DNAPK
1045 S KQLESEGRS 0.669 PKC
This works good, I just want to print from which line (KB005 or the other) a given line comes from..
Anybody's willing to help? Smilie
Thx

Last edited by karla; 08-05-2009 at 10:01 AM..
# 2  
Old 08-05-2009
To keep the forums high quality for all users, please take the time to format your posts correctly.

First of all, use Code Tags when you post any code or data samples so others can easily read your code. You can easily do this by highlighting your code and then clicking on the # in the editing menu. (You can also type code tags [code] and [/code] by hand.)

Second, avoid adding color or different fonts and font size to your posts. Selective use of color to highlight a single word or phrase can be useful at times, but using color, in general, makes the forums harder to read, especially bright colors like red.

Third, be careful when you cut-and-paste, edit any odd characters and make sure all links are working property.

Thank You.

The UNIX and Linux Forums
# 3  
Old 08-05-2009
Quote:
and print the lines that differs or dont repeat,
Code:
open( my $lfh, '<', 'file' ) 
or die "Unable to open file - 'file' <$!>\n";

my %uniqHash;
while ( my $data = <$lfh> ) {
    chomp($data);
    $uniqHash{$data}++;
}

close($lfh);

# 4  
Old 08-05-2009
Quote:
Originally Posted by karla
...
This works good, I just want to print from which line (KB005 or the other) a given line comes from..
...
Code:
$
$ cat data.txt
KB0005 1019 T IFVATVPVI 0.691 PKC YES
KB0005 1036 T YFLQTSQQL 0.785 PKC YES
KB0005 1037 S FLQTSQQLK 0.585 DNAPK YES
KB0005 1045 S KQLESEGRS 0.669 PKC YES
KB0005 1045 S KQLESEGRS 0.880 unsp YES
KB204320 1019 T IFVATVPVI 0.699 PKC YES
KB204320 1036 T YFLQTSQQL 0.789 PKC YES
KB204320 1037 S FLQTSQQLK 0.589 DNAPK YES
KB204320 1045 S KQLESEGRS 0.880 unsp YES
$
$ cat testscr.pl
#!/usr/bin/perl -w
$prevname = "";
open (F,"data.txt") or die "Can't open data.txt: $!";
while (<F>) {
  chomp;
  ($name = $_) =~ s/(\w+) .*/$1/;
  ($elem = $_) =~ s/\w+ (.*)/$1/;
  if ($prevname eq "") {
    $arrnum = 1;
  } elsif ($name ne $prevname) {
    $arrnum = 2;
  }
  # assuming there are only 2 distinct names, hence 2 arrays
  if ($arrnum == 1) {
    push @a1, "$name:$elem";
  } elsif ($arrnum == 2) {
    push @a2, "$name:$elem";
  }
  $prevname = $name;
}
close (F) or die "Can't close data.txt: $!";
# the value is a tilde-delimited string of names for which the
# line occurs
foreach $item (@a1, @a2) {
  ($key = $item) =~ s/\w+:(.*)/$1/;
  ($val = $item) =~ s/(\w+):.*/$1/;
  $count{$key} .= "~".$val
}
foreach $item (keys %count) {
  ($x = $count{$item}) =~ s/[^~]//g;
  if ( $x eq "~~") {  # line occurred for both names
    next;
  } else {            # array element has the line followed by "~name"
    push @diff, "$item$count{$item}";
  }
}
@sorted = sort @diff;
foreach $el (@sorted) {
  ($name = $el) =~ s/.*~(\w+)/$1/;
  ($elem = $el) =~ s/(.*)~\w+/$1/;
  printf("%-10s => %s\n",$name,$elem);
}
$
$ perl testscr.pl
KB0005     => 1019 T IFVATVPVI 0.691 PKC YES
KB204320   => 1019 T IFVATVPVI 0.699 PKC YES
KB0005     => 1036 T YFLQTSQQL 0.785 PKC YES
KB204320   => 1036 T YFLQTSQQL 0.789 PKC YES
KB0005     => 1037 S FLQTSQQLK 0.585 DNAPK YES
KB204320   => 1037 S FLQTSQQLK 0.589 DNAPK YES
KB0005     => 1045 S KQLESEGRS 0.669 PKC YES
$
$

HTH,
tyler_durden
# 5  
Old 08-05-2009
one more thing: how can i access the value in 5th column and compare it to the corresponding line, printing the difference, or, warning that this line exists only in one file
# 6  
Old 08-05-2009
Quote:
Originally Posted by karla
one more thing: how can i access the value in 5th column and compare it to the corresponding line, printing the difference, or, warning that this line exists only in one file
(1) For two similar lines of data, is the 5th column the only one that can be different ?

(2) What exactly is that difference ?

(a) KB0005_value minus KB204320_value, or
(b) KB204320_value minus KB0005_value, or
(c) absolute difference ?

tyler_durden
# 7  
Old 08-06-2009
except for 1st column, yes, only 5th is different unless the whole line doesnt exist.. and im looking for KB0005-KB204320 diff

Previous Thread | Next Thread
Test Your Knowledge in Computers #606
Difficulty: Easy
MySQL 7.0 added the JSON utility function JSON_PRETTY(), which outputs an existing JSON value in an easy-to-read format.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Compare bash arrays issue

Hello everyone, I need help comparing 2 arrays. the first array is static; the second array is not .. array1=( "macOS Mojave" "iTunes" ) cd /Volumes array2=( * ) # output of array2 macOS Mojave iTunes Mac me The problem occurs when I compare the arrays with the following code - ... (6 Replies)
Discussion started by: trexthurman
6 Replies

2. Shell Programming and Scripting

Using Diff to compare 2 arrays

I have two arrays and they look like this: array=(`cat /local/mnt/*sys/*includes|grep -v NEW`) array2=(`cat /tmp/*sys.z |grep -v NEW`) I am trying to compare them but I need to use the diff -u command. I am not sure how to do this. I cannot just do diff -u ${array} ${array2} I cannot... (4 Replies)
Discussion started by: newbie2010
4 Replies

3. Shell Programming and Scripting

Compare two arrays

Hi, I am trying to compare two lists that are held in two variables so I believe I need to access the array elements to compare these. I am using ksh 88 and the code I have tried is below: for file in ${origfilelist} do if ]] then print -- "File ${file}... (3 Replies)
Discussion started by: frodo61
3 Replies

4. Shell Programming and Scripting

perl: compare two arrays

Hi friends, I want to compare two arrays and find matched one using perl? Also, I want to delete unmatched one. Plz suggest me solution (1 Reply)
Discussion started by: Renesh
1 Replies

5. Shell Programming and Scripting

Perl Compare 2 Arrays

Hello, Consider the following 2 arrays: Array1 = qw(Fa0/0 Fa0/1 Fa0/2 Fa0/3); Array1 = qw(Fa0/1 Fa0/2 Fa0/3 Fa0/4); I want to compare the following 2 arrays as follows: Take specific action when elements of Array1 that doesn't exist in Array2 (in my example: Fa0/0). Take another... (4 Replies)
Discussion started by: ahmed_zaher
4 Replies

6. Shell Programming and Scripting

Compare arrays (perl)

Hi, my first post here! Description of my problem: I have one txt-file with six rows and each row contains seven numbers seperated with whitespaces. I want to: Compare one array with seven numbers with each row of numbers in the txt-file. I have managed to compare one array with... (6 Replies)
Discussion started by: mjoh
6 Replies

7. Shell Programming and Scripting

Compare arrays in perl

Hello, Let's say that we have the two following arrays @array1= @array2= Is there any easy way to compare these two arrays and print the values that exist in array1 and not in array2 and the values that exist in array2 and not in array1? Regards, Chriss_58 (3 Replies)
Discussion started by: chriss_58
3 Replies

8. Shell Programming and Scripting

compare/match arrays

Hi there all, I am having a question. Is it posible to compare elements of 2 different arrays? For example I got Array 1 | Array 2 123_abc | 123_bcd 123_bcd | 234_bcd 234_abc | 567_abc 234_bcd | 123_abc than the match is 123_abc & 234_bcd and non of the others. So... (3 Replies)
Discussion started by: draco
3 Replies

9. Shell Programming and Scripting

Perl - Compare 2 Arrays

Hi all, I have the following script where the contents of file1 and file2 would be something like this: file1: 56790,0,0,100998765 89756,0,0,100567876 867645,1,3,678777654 file2: 56790,0,0,100998765 65776,0,0,4766457890 +5896,0,0,675489876 What I then want to do is check if... (4 Replies)
Discussion started by: Donkey25
4 Replies

10. Shell Programming and Scripting

Compare two arrays in sh or compare two fields

I want a soultion to compare two arrays in sh with an easy way.I want a solution to synchrose users between different AIX servers where no NIS is available. All users are meant to be same on all 10 servers. So the approach is to consider first server as master user repository and whatever the users... (0 Replies)
Discussion started by: rijeshpp
0 Replies

Featured Tech Videos