Shell Programming and Scripting

awk '
        NR == FNR {
                A[$1","$2] = $3
                next
        }
        {
                for ( k in A )
                {
                        n = split ( k, V, "," )
                        if ( $1 == V[1] )
                        {
                                if ( $2 >= V[2] && $2 <= A[$1","V[2]] )
                                        R[$1 OFS V[2] OFS A[$1","V[2]]]++
                        }
                }
        }
        END {
                for ( k in R )
                        print k, R[k]
        }
' file2 file1

awk '
  NR==FNR {
    j=++Ranges[$1]
    Low[$1,j]=$2
    High[$1,j]=$3
    next
  }
  $1 in Ranges {
    for(j=1; j<=Ranges[$1]; j++) if (Low[$1,j]<=$2 && $2<=High[$1,j]) Number[$1,j]++
  }
  END {
    for(i in Ranges) for(j=1; j<=Ranges[i]; j++) print i, Low[i,j], High[i,j], Number[i,j]
  }
' OFS='\t' file2 file1

gawk '{
        n=split($0,arr," ")
        if(NR==FNR){
         min[arr[1]]=arr[2]
         max[arr[1]]=arr[3]
         cnt[arr[1]]=0
        }
        else{
         if(arr[2] >= min[arr[1]] && arr[2] <= max[arr[1]])
           cnt[arr[1]]++
        }
}
END{
 for (i in cnt)
  print i" "min[i]" "max[i]" "cnt[i]
}' b a

dic={}
cnt=0
with open("b.txt") as f:
 for line in f:
  line=line.replace("\n","")
  words = line.split(" ")
  dic[words[0]]={'MIN':words[1],'MAX':words[2],'CNT':0}
print(dic)
with open("a.txt") as f:
 for line in f:
  line=line.replace("\n","")
  words = line.split(" ")
  if words[1]>=dic[words[0]]['MIN'] and words[1]<=dic[words[0]]['MAX']:
   dic[words[0]]['CNT']+=1
for i in dic:
 print(i,dic[i]['MIN'],dic[i]['MAX'],dic[i]['CNT'])

line 7, in <module>
    dic[words[0]]={'MIN':words[1],'MAX':words[2],'CNT':0}
IndexError: list index out of range