Find the most popular status entry (awk, sort, cat, csvcut, head)

To do this analysis efficiently, we’ll use the command line language called awk , a tool that allows you to filter, extract and transform data files. awk is a very useful tool to put in your bag of tricks. But let’s watch the following video lecture first!

To start, let’s look at a very simple awk program to output every line of our facebook.csv file, where we specify the delimiter of the file (comma) using the -F option: