Visit Our UNIX and Linux User Community


Compare arrays (perl)


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Compare arrays (perl)
# 1  
Old 12-19-2009
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 another with seven numbers (fairly easy), the problem is that i can't figure out how to create six different arrays with the numbers with the rows in the txt-file and then compare them with a single array. I've used qw() to create the array so the values are in fact strings. Smilie

Code:
open(FILE, "numfile.txt") || die $!;
my @rows = <FILE>;

I understand that the array @rows now contains six elements and each element is a string with seven numbers seperated with whitespaces.
Is there a way to loop through the @rows array and split the strings into seven different values, populate six arrays with these values and then compare them with an independent array?

Thanks!
# 2  
Old 12-19-2009
What do you mean by compare? Could you give an example?
You may use array of arrays to hold your input file.

For example:

1. Generate some data (this is zsh):

Code:
[11:50][dimitre@ubuntu][/home/dimitre/t]$ for j ({1..6}) {
  for i ({1..7}) {
    printf "%d " $((RANDOM%100))
    }
  print
  }
84 90 86 48 19 94 38 
69 64 65 23 81 57 6 
25 72 6 62 72 94 97 
21 97 20 36 10 34 14 
25 27 91 41 49 77 90 
0 3 60 1 68 26 24

Use AoA to hold your arrays (the numbers do not match, because I'm using the RANDOM variable):

Code:
[11:51][dimitre@ubuntu][/home/dimitre/t]$ for j ({1..6}) {
  for i ({1..7}) {
    printf "%d " $((RANDOM%100))
    }
  print
  } | perl -MData::Dumper -lane'
  push @arrays, [@F];
  print Dumper \@arrays if eof
  ' infile
$VAR1 = [
          [
            '39',
            '76',
            '75',
            '11',
            '37',
            '0',
            '6'
          ],
          [
            '19',
            '23',
            '8',
            '66',
            '84',
            '24',
            '53'
          ],
          [
            '35',
            '79',
            '23',
            '27',
            '82',
            '90',
            '2'
          ],
          [
            '80',
            '27',
            '24',
            '59',
            '10',
            '25',
            '12'
          ],
          [
            '79',
            '91',
            '54',
            '19',
            '99',
            '61',
            '62'
          ],
          [
            '36',
            '62',
            '68',
            '87',
            '17',
            '9',
            '53'
          ]
        ];

# 3  
Old 12-19-2009
Quote:
Originally Posted by mjoh
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 another with seven numbers (fairly easy), the problem is that i can't figure out how to create six different arrays with the numbers with the rows in the txt-file and then compare them with a single array. I've used qw() to create the array so the values are in fact strings. Smilie

Code:
open(FILE, "numfile.txt") || die $!;
my @rows = <FILE>;

I understand that the array @rows now contains six elements and each element is a string with seven numbers seperated with whitespaces.
Is there a way to loop through the @rows array and split the strings into seven different values, populate six arrays with these values and then compare them with an independent array?

Thanks!
hello ,
so you have one array of numbers to compare with all the rows if I am not mistaken.
So here is a start
Code:
#/usr/local/bin/perl -w 
open(FILE,"<your_file.txt") or die($!);
while(<FILE>){
split(/\s+/);
##not compare your arrary with @_ by using accessing members $_[0],$_[1]..... .. etc. ###

# 4  
Old 12-20-2009
radulov:

I want to compare the 12 rows with one independent row, to see how many numbers that match in each row with the independent row.
I've actually tried to use AoA but i couldn't figure out the code how to access each array and compare the values with the values in the independent array. I'm going to try using AoA again, guess i didn't take the time to actually learn it. Smilie

gaurav1086:

Quote:
so you have one array of numbers to compare with all the rows if I am not mistaken.
Yes, that is correct. Never tried the split-function with strings, im going to check that one out!
# 5  
Old 12-20-2009
Thinking on similar lines... i think the following code works:
Code:
open(SRC,"file location");
@sample = (23,32,45,54,56,65);

while(<SRC>){
chomp(@_);

@new = split(/\s+/);

$count = 0;$y=0;
foreach $x (@sample){


foreach $y (@new){

if($x eq $y){
$count++;

}#if ends
}#foreach $y ends


}#foreach ends
print "\n\n $count matches.\n";

}


close SRC;

file contents are as follows:

21 12 29 92 28 82
23 32 45 54 65 56

Last edited by Scott; 12-20-2009 at 01:33 PM.. Reason: Please use code tags
# 6  
Old 12-20-2009
Quote:
Originally Posted by mjoh
radulov:

I want to compare the 12 rows with one independent row, to see how many numbers that match in each row with the independent row.
[...]

You can use something like this:


Code:
#!/usr/bin/perl

use warnings;
use strict;

my @indi_numbers = ( 16, 35, 11, 30, 8, 9 );

open my $infile, '<', shift or die "open: $!\n";

while (<$infile>) {
    my %uniq;
    $uniq{$_} = 1 for split;
    my @matching = grep $uniq{$_}, @indi_numbers;
    print @matching ? ( ~~@matching, " matches : @matching " ) : "no matches ",
      "on line $.\n";
}

For example:


input data (infile)

Code:
16 6 21 4 45 13 30 
10 41 15 47 48 37 9 
19 16 5 33 29 14 8 
0 11 35 28 17 2 27 
39 17 39 22 12 48 23 
40 20 19 44 5 43 11

Output:

Code:
$ ./s infile
2 matches : 16 30 on line 1
1 matches : 9 on line 2
2 matches : 16 8 on line 3
2 matches : 35 11 on line 4
no matches on line 5
1 matches : 11 on line 6

# 7  
Old 12-20-2009
Quote:
Originally Posted by radoulov
You can use something like this:


Code:
#!/usr/bin/perl

use warnings;
use strict;

my @indi_numbers = ( 16, 35, 11, 30, 8, 9 );

open my $infile, '<', shift or die "open: $!\n";

while (<$infile>) {
    my %uniq;
    $uniq{$_} = 1 for split;
    my @matching = grep $uniq{$_}, @indi_numbers;
    print @matching ? ( ~~@matching, " matches : @matching " ) : "no matches ",
      "on line $.\n";
}

...

Thanks man, that was exactly what i was trying to do! Smilie

Previous Thread | Next Thread
Test Your Knowledge in Computers #154
Difficulty: Easy
Inspur K-UX is a Linux distribution certified as UNIX 03 compliant.
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 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 ... (7 Replies)
Discussion started by: karla
7 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