求助，判断相邻两行相等合并问题

kwunkau

文本A:
123,A,2:28
123,B,2:28
123,B,2:29
123,C,2:34
123,D,2:35
123,C,3:49
123,C,3:50
123,E,3:55
123,C,3:55
123,F,18:26
123,F,19:12
456,G,8:06
456,G,8:07
456,H,10:33
456,I,10:56
456,J,14:43
456,K,19:37


问题描述：判断本行和下一行的$1和$2的值是否相同，相同就进行合并，不相同就补0，格式为：用户，位置，最小时间，最大时间

输出文本B:
123,A,2:28,0
123,B,2:28,2:29
123,C,2:34,0
123,D,2:35,0
123,C,3:49,3:50
123,E,3:55,0
123,C,3:55,0
123,F,18:26,19:12
456,G,8:06,8:07
456,H,10:33,0
456,I,10:56,0
456,J,14:43,0
456,K,19:37,0


请教下各位，这个应该怎么弄的

reyleon

1. awk -F, '{while(getline N){split(N,a,",");if($1$2==a[1]a[2]){$0=$0","a[3];t=1;continue}print t?$0:$0","0;t=0;$0=N}}END{print t?$0:$0","0}' file

复制代码

moperyblue

1. sed -r '$ba;N;/(([^,]+,[^,]+)\b.*)\n\2\b/!{:a;s/$/,0/M;P;D};s//\1/' A

复制代码

kwunkau

回复 2# reyleon

感谢六哥，mark下学习

kwunkau

回复 3# moperyblue

感谢，虽然sed不是好熟练，先学习

jason680

回复 1# kwunkau

$ awk -F, 'function k(){S1=$1;S2=$2;S=$0;t=",0"}NR==1{k();next}{if(S1==$1&&S2==$2){S=S","$3;t="";next}print S t;k()}END{print S t}' file
123,A,2:28,0
123,B,2:28,2:29
123,C,2:34,0
123,D,2:35,0
123,C,3:49,3:50
123,E,3:55,0
123,C,3:55,0
123,F,18:26,19:12
456,G,8:06,8:07
456,H,10:33,0
456,I,10:56,0
456,J,14:43,0
456,K,19:37,0

jcdiy0601

1. #!/usr/bin/env python
   
2. #_*_ coding:utf-8 _*_
   
3. # Author: jiachen
   
4. 
   
5. FileName = "file"
   
6. 
   
7. with open(FileName,"r") as read_f:
   
8.     while True:
   
9.         line1 = read_f.readline().strip().split(",")
   
10.         num = read_f.tell()
    
11.         line2 = read_f.readline().strip().split(",")
    
12.         if line1 != [""]:
    
13.             if line1[0] == line2[0] and line1[1] == line2[1]:
    
14.                 print ("%s,%s,%s,%s" % (line1[0],line1[1],line1[2],line2[2]))
    
15.             else:
    
16.                 print ("%s,%s,%s,%d" % (line1[0], line1[1], line1[2],0))
    
17.                 read_f.seek(num)
    
18.         else:
    
19.             break

复制代码

moperyblue

1. awk 's{f=0;if($1==a&&$2==b){print s,$3;getline}else{print s,0;f=1}}{s=$0;a=$1;b=$2}END{if(f)print s,0}' FS=, OFS=, A

复制代码