#!/usr/bin/perl use strict; use warnings; use Data::Table; my $t = Data::Table::fromCSV("ravi.csv"); # Read a csv file into + a table object print $t->csv; # Display a 'portrait' HTML TABLE + on web.

I am trying some programs on csv files. By searching I saw this "Data::Table". I copied the example in the page given. but its showing an error.

Later I came to know that it need column names. Without column names how can I use this. Because the csv file I am using is auto-generated and does not contains any names in the top of the file. I have permissions only to read the files.

So as per module page

table Data::Table::fromCSV ($name, $includeHeader = 1, $header = ["col +1", ... ]) create a table from a CSV file. return a table object. $name: the CSV +file name. $includeHeader: 0 or 1 to ignore/interpret the first line +in the file as column names, If it is set to 0, the array in $header +is used. If $header is not supplied, the default column names are "co +l1", "col2", ...
#!/usr/bin/perl #!/usr/bin/perl # use strict; use warnings; use Data::Table; my $t = Data::Table::fromCSV("/root/prac/Telenor_CDR/SMSCDR_POSTPAID_1 +51013000000_10.84.0.29_AS.log",0); #print $t->csv; #t2 = $t->group(["Department","Sex"],["Name", "Salary"], [sub {scalar +@_}, \&average], ["Nof Employee", "Average Salary"]); my $t2 = $t->group(["col1","col9"]); print $t2->csv;
Still its not working

Invalid column col9Unknown column col9 at /root/perl5/lib/perl5/Data/T +able.pm line 1794. Data::Table::group('Data::Table=HASH(0x15e84c0)', 'ARRAY(0xff0 +300)') called at test_table.pl line 13

In reply to Data::Table showing error by ravi45722

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.