- 论坛徽章:
- 0
|
- #!/usr/bin/perl
- use warnings;
- use strict;
- my %tar_output;
- my %univ;
- my %dis;
- open SOUR_FILE, "/home/oracle/data.txt";
- while (<SOUR_FILE>)
- {
- my $line = $_;
- my @input_line;
- if($line=~/^[0-9]/)
- {
- @input_line = split(/\s/, $line);
- #print $input_line[0],$input_line[1],$input_line[2],$input_line[4],"\n";
- $tar_output{$input_line[1]}{$input_line[2]} += $input_line[4];
- $univ{$input_line[1]} += 1;
- $dis{$input_line[2]} += 1;
- }
- }
- print " "x15,join " "x5, keys %dis,"\n";
- foreach my $univ (sort keys %univ)
- {
- printf("%10s", $univ);
- foreach my $dis (sort keys %dis)
- {
- if(defined $tar_output{$univ}{$dis})
- {
- printf("%15d",$tar_output{$univ}{$dis});
- }
- else
- {
- printf("%15d", 0);
- }
- }
- print "\n";
- }
复制代码 如果真要打印出一模一样的表格的话,可以用 excel 或在 xml模块 |
|