Join Log in
Score:0
iwantcaketoo avatar Ubuntu

playing with awk command trying to remove first line in input

kg flag
iwantcaketoo

below is my input file, results keep returning "Breed has Votes votes"

    Breed, Votes
    Black Lab, 30
    Chihuahua, 2
    Pug, 1
    Corgi, 45
    Shar Pei, 21
    Shih Tzu, 5
    Maltese, 7

#!/bin/sh/awk
##comment The below awk script runs on the file dog_breed.txt, FS refers to field separator which is a comma in this case. We initialize our max variable to 0 and max_breed to the first breed, then iterate over the rows to find the max voted breed.
    
    BEGIN{
            FS=", "
            max=0;
            max_breed=$1
    }
    {
            if(max<($2)){
                    max=$2;
                    max_breed=$1;
            }
    }
    END{
            print max_breed " has " max " votes"
    }
40
0 + 0
awk
Score:1
avatar Ubuntu
hr flag
steeldriver

You can skip the first record (line) by adding a rule to the block:

NR > 1 {
        if(max<($2)){
                max=$2;
                max_breed=$1;
        }
}

However it's worth trying to understand why you get the result that you do when you don't exclude the first line - that's because:

  • when NR==1, the value of max is 0 (numeric - assigned in the BEGIN block) but the value of $2 is Votes (which is a string). So the expression max<($2) converts max to a string and performs a lexicographical comparison. If 0 is less than V in your locale, then the result is TRUE, and max is assigned the string value Votes

  • for subsequent lines, $2 is numeric, but max is now a string so $2 gets converted to a string and again the comparison is lexicographical. Assuming V has a greater lexicographical weight than any of the digits 0 thru 9, V always wins.

As an aside, your shebang looks invalid - it likely should be

#!/usr/bin/awk -f

or

#!/bin/awk -f

depending on your Ubuntu version. Also, assignments like max_breed=$1 aren't really meaningful in a BEGIN block, since it is executed before any records have been processed.

0 + 0
Score:0
elmclose avatar Ubuntu
cn flag
elmclose

To remove the first line with awk:

awk 'NR>1' input_file

Or use tail:

tail -n+2 input-file
0 + 0
iwantcaketoo avatar
kg flag
iwantcaketoo
how would i implement into the code, when I added it it gave me an incorrect value
0
Reply
iwantcaketoo avatar
kg flag
iwantcaketoo
i know i can always do cat dogbreed.csv | tail -n+2 | awk -F',' 'BEGIN{breed="";votes=0;}{if($2>votes){votes=$2;breed=$1;}}END{print breed " has " votes " votes";}'
0
Reply
iwantcaketoo avatar
kg flag
iwantcaketoo
but instructions state Unless otherwise specified, your script file will be tested on our system with the following command: awk -f
0
Reply
ธงชาติไทย
Elon Musk
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.