Question

[More challenging (still required :)] In this step, we want to find the top five albums by the number of tracks. Note that albums by two artists can have the same title (e.g. "Greatest Hits"). Use the cat, awk, sort and uniq -c command to get the title of all the albums (along with the artist name) with a count of the number of tracks in it. The album title is in the 2nd column and the artist's name is in the 1st column of the csv file. Then we can pipe the output to sort -rn and sed command to get the top five albums by the number of tracks. Format the output so each field is separated by a colon (this can be done with the print command in awk; for example '{print ":" $1 ":"}' would print the first field surrounded by colons). The expected output from this step is shown below. 96 : Bootlegs (live) : Rush 43 : Bootlegs (studio) : Rush 27 : 1 : Beatles 23 : The Best of 1990-2000 : U2 17 : The Beatles (Disc 1) : Beatles

          [More challenging (still required :)] In this step, we want to find the top five albums by the number of
tracks. Note that albums by two artists can have the same title (e.g. "Greatest Hits"). Use the cat, awk,
sort and uniq -c command to get the title of all the albums (along with the artist name) with a count of
the number of tracks in it. The album title is in the 2nd column and the artist's name is in the 1st
column of the csv file. Then we can pipe the output to sort -rn and sed command to get the top five
albums by the number of tracks. Format the output so each field is separated by a colon (this can be
done with the print command in awk; for example '{print ":" $1 ":"}' would print the first
field surrounded by colons). The expected output from this step is shown below.

 96 : Bootlegs (live) : Rush
 43 : Bootlegs (studio) : Rush
 27 : 1 : Beatles
 23 : The Best of 1990-2000 : U2
 17 : The Beatles (Disc 1) : Beatles

[More challenging (still required :)] In this step, we want to find the top five albums by the number of
tracks. Note that albums by two artists can have the same title (e.g. "Greatest Hits"). Use the cat, awk,
sort and uniq -c command to get the title of all the albums (along with the artist name) with a count of
the number of tracks in it. The album title is in the 2nd column and the artist's name is in the 1st
column of the csv file. Then we can pipe the output to sort -rn and sed command to get the top five
albums by the number of tracks. Format the output so each field is separated by a colon (this can be
done with the print command in awk; for example 'print ":" 1 ":"' would print the first
field surrounded by colons). The expected output from this step is shown below.

96 : Bootlegs (live) : Rush
43 : Bootlegs (studio) : Rush
27 : 1 : Beatles
23 : The Best of 1990-2000 : U2
17 : The Beatles (Disc 1) : Beatles

Added by Laura H.

Question

Please give Ace some feedback