Question

Hi guys i have a question??I want to move column in another file and match with rows and column and put in exact position.

投入文件1是:

COURSE NAME: Java
CREDITS: 4
200345    88
300126    78
287136    68
200138    71
COURSE NAME: Operating System
CREDITS: 4
287136    86
200138    72
200345    77
300056    78

投入文件2是:

STUDENT ID        Java        Operating System      GPA
200138
200345
287136
300056
300126

需要产出:

STUDENT ID        Java        Operating System      GPA
200138             71                 72
200345             88                 77
287136             68                 86
300056             -                  78
300126             78                 -

我在谈到这一法典:

awk NR==FNR{a[$1]=$2;next} {print $0 FS a [$1];next} file1 file2

其产出如下:

STUDENT ID       JAVA       Operating Systems       GPA
200138 72
200345 77
287136 86
300056 78
300126 78

I tried alot:( Can you please help me?

Answer 1

您可以使用<代码>awk,但并非微不足道。与此类似:

# We will save every course name in an array for the report, but first remove the 
# the unwanted space from it s name. This line only works on the COURSE NAME lines
/^COURSE NAME/ {cn=gensub(" ","_","g",gensub(".*: ","","g",$0)); crss[cn]+=1 }

# On lines which starts with a number (student id), we are saving the student ids 
# in an array (stdnts) and the students score with a "semi" multideminsional array/hash
# where the indecies are "student_id-course_name" 
/^[0-9]/ {stdnts[$1]+=1 ; v[$1 "-" cn]=$2}

# after the above processing (e.g. the last line of the input file)
END {
      # print the header, it s dynamic and uses the course names it saved earlier
      printf("%-20s","STUDENT ID");
      for (e in crss) {printf("%-20s",e)}
      printf("%-20s
","GPA")

      # print the report
      for (s in stdnts)
          # we need to print every student id
          { printf("%-20s",s)
            for (cs in crss) {
                # then check if she had any score for every score, and print it
                if (v[s "-" cs] > 0) {
                    printf("%-20s",v[s "-" cs])
                }
                else {
                    printf("%-20s","-")
            }
          }
        printf("%-20s
"," ")
      }
  }

见以下行动:。

。

the script is not optimized;
it replaces the original course names with a spaceless one
the output of the students table is not sorted by student id
it need only the first file as input! Put the above in a file like report.awk, then do awk -f report.awk INPUT_FILE.

HTH

Answer 2

i 撰写了快速和 d脏的解决办法,为你提供实例。

指挥:

 sed  /CREDIT/d  file1|awk  FNR==NR{ if($0~/Java/){j++;o=0;next;}
        if($0~/Operating/){o++;j=0;next;}
        if(j){java[$1]=$2}
        if(o){os[$1]=$2}
}NR>FNR{OFS=" ";
        if(FNR==1){sub(/ /,"");print;}
        else{$2=" "
        $3=($1 in java)?java[$1]:"-";
        $4=($1 in os)?os[$1]:"-";
        print $0;
        }

}  - file2|column -t|sed -e  s/ID/ ID/  -e  2,${s/ /    /}

• 测试我的 con子:

kent$  sed  /CREDIT/d  file1|awk  FNR==NR{ if($0~/Java/){j++;o=0;next;}
        if($0~/Operating/){o++;j=0;next;}
        if(j){java[$1]=$2}
        if(o){os[$1]=$2}
}NR>FNR{OFS=" ";
        if(FNR==1){sub(/ /,"");print;}
        else{$2=" "
        $3=($1 in java)?java[$1]:"-";
        $4=($1 in os)?os[$1]:"-";
        print $0;
        }

}  - file2|column -t|sed -e  s/ID/ ID/  -e  2,${s/ /    /} 
STUDENT ID  Java  Operating  System  GPA
200138        71    72
200345        88    77
287136        68    86
300056        -     78
300126        78    -

事实上,逻辑部分相对容易,许多守则只是以你为例,以同样的格式编制产出。

友情链接