Breaking News: Grepper is joining You.com. Read the official announcement!

using awk and cat and grep

Mero answered on July 23, 2022 Popularity 1/10 Helpfulness 1/10

answer using awk and cat and grep

using awk and cat and grep

Comment

# get cities as unique form 
uniq=$( cat $1 |awk -F "," '{print $2}' | sort -u)

## loop in the list of uniq cities 
for UniqCity in $uniq ; do

          # grep all field where city appears 
                                ## sort according to temporary from bigger to smaller 
                                           #take the 3rd column{temporary} 
                                                          # take the larger temporary which appears and the first line
  maxTemp=$(grep $UniqCity $1 | sort -nr | cut -f3 -d"," | head -n1  )
  # count number of lines 
  lines=$(cat $1 | wc -l)

  # sum of temporary according to city 
  Total=$(grep $UniqCity $1| awk -F "," '{print $3}'  | awk '{s+=$1} END {print  s}')

  avg=$(expr $Total / $lines) 
  echo "City:$UniqCity"
  echo "max: $maxTemp"
  echo "avg: $avg"

Popularity 1/10 Helpfulness 1/10 Language shell

Source: Grepper

Tags: awk cat grep shell using

Link to this answer
Share Copy Link

Contributed on Jul 23 2022

Mero

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

using awk and cat and grep

Contents

More Related Answers

using awk and cat and grep

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.