Hi john.tm,
While others have pointed out what you could do to get desired output, I think it wouldn't be out of place to also note a few things:

  1. ..I have to run a report from 2 csv files..
    Use tested modules, instead of hand-picking commas. In this case for CSV files use Text::CSV_XS or Text::CSV
  2. Use lexical variable name instead of barewords for file handle. Also use 3 augments open function like open my $file, '<', $filename or die '...: $!';

    Why use this
    while(<DATA>){ ... my $line = $_; ... }
    when you can do it once:
    while(my $line = <DATA>){ ... }
  3. Why loop through the file(s) twice, once to get the total and then to get the number of occurrence? When you can actually do it once like so:
    use warnings; use strict; use Data::Dumper; use List::Util qw(sum); my %seen; while (<DATA>) { chomp; $seen{$_}++; } print Dumper \%seen; my $total = 0; $total += $_ for values %seen; print $total; print sum( values %seen ); # sum from List::Util __DATA__ james dave mike ken jon jon ken jon mike james dave mike ken jon jon

If you tell me, I'll forget.
If you show me, I'll remember.
if you involve me, I'll understand.
--- Author unknown to me

In reply to Re: keep only unique elements in an array displaying number of duplcates. by 2teez
in thread keep only unique elements in an array displaying number of duplcates. by john.tm

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.