Find duplicates in 2 & 3rd column and their ID

with below given format,

I have been trying to find out all IDs for those entries with duplicate names in 2nd and 3rd columns and their count like how many time duplication happened for any name if any,

0.237788 Aaban Aahva
0.291066 Aabheer Aahlaad
0.845814 Aabid Aahan
0.152208 Aadam Aagneya
0.585537 Aadan Aagney
0.193475 Aadarsh Aagam
0.810623 Aadavan Aadvik
0.173531 Aadesh Aadrian
0.484983 Aadhan Aaditya
0.151863 Aadhira Aaditeya
0.366957 Aadi Aadit
0.491736 Aadidev Aadir
0.910094 Aadil Aadinath
0.265257 Aadinath Aadil
0.893188 Aadir Aadidev
0.220351 Aadit Aadi
0.631798 Aaditeya Aadhira
0.571077 Aaditya Aadhan
0.332158 Aadrian Aadesh
0.104455 Aadvik Aadavan
0.502931 Aagam Aadarsh
0.567394 Aagney Aadan
0.854165 Aagneya Aadam
0.0401409 Aahan Aabid
0.108022 Aahlaad Aabheer
0.639396 Aahva Aaban
0.291066  Aadil Aadinath
0.845814  Aadinath Aadil
0.152208  Aadir Aadidev
0.585537  Aadit Aadi
0.193475  Aaditeya Aadhira
0.810623  Aaditya Aadhan
0.173531  Aadrian Aadesh
0.484983  Aadvik Aadavan
0.151863  Aagam Aadarsh
0.366957  Aagney Aadan
0.491736  Aagneya Aadam
0.910094   Aahan Aabid
0.265257  Aahlaad Aabheer
0.893155  Aahva Aaban
0.193443  Aaditeya Aadhira
0.810667  Aaditya Aadhan
0.173545  Aadrian Aadesh
0.484934  Aadvik Aadavan
0.151862  Aagam Aadarsh
0.366954  Aagney Aadan
0.491736  Aagneya Aadam
0.910094   Aahan Aabid
0.265232  Aahlaad Aabheer
0.893134  Aahva Aaban

REgards,
Nasir

Please use code tags.

Can you show your tries?

Thnks

I tried with below given code. but it turns out that only the ID of last match is returned...some logical error

 awk '{ a[$3$4]++; y[$3$4]=$1 }END{ for(x in y){ for (j in a) { if(a[j]>1) { if(x == j){ print j,y[x]} }   }}}' filter.data

You are building a key with $3 and $4 where there exists only fields $1 $2 $3 with an unaltered field separator.

If I understood it correct, you might want something like this?

$ awk '{a[$2 FS $3]++; b[$2 FS $3]=$1} END{for(e in a){if(a[e] > 1){print a[e], b[e], e}}}' infile| sort -r
3 0.910094 Aahan Aabid
3 0.893134 Aahva Aaban
3 0.810667 Aaditya Aadhan
3 0.491736 Aagneya Aadam
3 0.484934 Aadvik Aadavan
3 0.366954 Aagney Aadan
3 0.265232 Aahlaad Aabheer
3 0.193443 Aaditeya Aadhira
3 0.173545 Aadrian Aadesh
3 0.151862 Aagam Aadarsh
2 0.845814 Aadinath Aadil
2 0.585537 Aadit Aadi
2 0.291066 Aadil Aadinath
2 0.152208 Aadir Aadidev

I am not sure if it makes sense to process $1 this way, since for example "Aahan Aabid" has 3 entries with 2 different numbers in front. If $1 makes a difference and needs to be printed, you might include $1 into the key instead of using it in a second array.

the question is to find all KEY ( $1) for a given name ( if $2 and $3 are more than once )

You could try yourself, altering your code with what I explained already...

$ awk '{a[$1 FS $2 FS $3]++} END{for(e in a) if(a[e] > 1){print a[e], e}}' infile| sort -r
2 0.910094 Aahan Aabid
2 0.491736 Aagneya Aadam

Or maybe just this:

$ sort -rn infile | uniq -d
0.910094   Aahan Aabid
0.491736  Aagneya Aadam

If Perl is an option, then you could do something like this for a descriptive answer:

$
$ perl -lne 'm/^(\S+)\s+(.*)$/;
             $x{$2}->[0] += 1;
             push(@{$x{$2}->[1]}, $1) }{
             while (($k, $v) = each %x) {
                 printf("%-20s occurred %5d times with keys [%s]\n", $k, $v->[0], join(",",@{$v->[1]}))
                 if $v->[0] > 1
             }' data.txt
Aadrian Aadesh       occurred     3 times with keys [0.332158,0.173531,0.173545]
Aagneya Aadam        occurred     3 times with keys [0.854165,0.491736,0.491736]
Aahan Aabid          occurred     3 times with keys [0.0401409,0.910094,0.910094]
Aaditeya Aadhira     occurred     3 times with keys [0.631798,0.193475,0.193443]
Aahlaad Aabheer      occurred     3 times with keys [0.108022,0.265257,0.265232]
Aadir Aadidev        occurred     2 times with keys [0.893188,0.152208]
Aadinath Aadil       occurred     2 times with keys [0.265257,0.845814]
Aadit Aadi           occurred     2 times with keys [0.220351,0.585537]
Aaditya Aadhan       occurred     3 times with keys [0.571077,0.810623,0.810667]
Aagney Aadan         occurred     3 times with keys [0.567394,0.366957,0.366954]
Aadvik Aadavan       occurred     3 times with keys [0.104455,0.484983,0.484934]
Aahva Aaban          occurred     3 times with keys [0.639396,0.893155,0.893134]
Aadil Aadinath       occurred     2 times with keys [0.910094,0.291066]
Aagam Aadarsh        occurred     3 times with keys [0.502931,0.151863,0.151862]
$
$

From the output above, if you wanted to see only the key (1st column in your data file) and nothing else, then maybe something like this could work:

$
$ perl -lne 'm/^(\S+)\s+(.*)$/;
             $x{$2}->[0] += 1;
             push(@{$x{$2}->[1]}, $1) }{
             while (($k, $v) = each %x) {
                 print join("\n",@{$v->[1]}) if $v->[0] > 1
             }' data.txt
0.332158
0.173531
0.173545
0.854165
0.491736
0.491736
0.0401409
0.910094
0.910094
0.631798
0.193475
0.193443
0.108022
0.265257
0.265232
0.893188
0.152208
0.265257
0.845814
0.220351
0.585537
0.571077
0.810623
0.810667
0.567394
0.366957
0.366954
0.104455
0.484983
0.484934
0.639396
0.893155
0.893134
0.910094
0.291066
0.502931
0.151863
0.151862
$
$

If you post the output you want to see, then it should be helpful.