I have a csv file with this:
I need to write a script using awk that prints the max, min, avg of height and weight and the sum of the column gold and silver for group by each country and gender indicated in the parameters
gawk -f script3_4.awk -v sport=football sex=male athletes.csv
the output should be something like this:
I know how to calculate min max and average, however I am very new using awk and I don't know how to group the data by gender and country.
Can someone help me?