UNIX for Beginners Questions & Answers

01001 63.9
01003 66.8
01005 64.8
01007 62.8

01001 02  1900 65.6
01001 02  1901 60.6
01001 02  1902 62.6
....
01003  02  1900 65.1
01003  02  1901 65.3
01003  02  1902 67.3
....
01005  02  1900 64.7
01005  02  1901 65.2
01005  02  1902 65.2
...
01007  02  1900 64.8
01007  02  1901 63.8
01007  02  1902 62.7
....

county=$(awk '{ print $1 }' variables.txt)
val=$(awk '{ print $2 }' variables.txt)

for id in $county
do
grep "$id" file-to-search.txt | awk '$4 < $val { print $0 }' | tail -1 | awk '{print $1" " $3" " $4}'
done

01001 1902 62.6
01003 1901 65.3
01005 1900 64.7
01007 1902 62.7

awk '
FNR==NR { f1[$1]=$2; next}
$1 in f1 && $4 < f1[$1]' variables.txt file-to-search.txt

sort -k1,1 -k4,4r file2 |
awk '
FNR==NR         {T[$1] = $2
                 next
                }
($1 in T) &&
($4 <= T[$1])   {print $1, $3, $4
                 delete T[$1]
                }
' file1 -
01001 1902 62.6
01003 1901 65.3
01005 1900 64.7
01007 1902 62.7

cat p.py
#!/usr/bin/env python3

data = {}
with open("file-to-search.txt") as f2s:
    for line in f2s:
        fields = line.split()
        fields.pop(1)

        if fields[0] in data:
            data[fields[0]].update({fields[2]: " ".join(fields)})
        else:
            data[fields[0]] = {fields[2]: " ".join(fields)}

points = {}
for entry in data:
    scores = []
    for s in data[entry]:
        scores.append(s)
    scores.sort(reverse=True)
    points[entry] = scores

with open("variable.txt") as s2f:
    for line in s2f:
        target, score = line.split()
        for s in points[target]:
            if score > s:
                print(data[target][s])
                break

python3 p.py
01001 1902 62.6
01003 1901 65.3
01005 1900 64.7
01007 1902 62.7

for id in {`cat counties.txt`}; do grep $id county-annual-average.txt > $id.txt; val=$(grep $id avgs.txt | awk '{print $2 }'); awk -v val="$val" '$4 < val' ${id}.txt | tail -1 | awk '{print $1" " $3" "$4}'; done