I'm new to shell commands. I'm kinda struggling with this question based on a CSV dataset fbnews.csv.
The CSV dataset looks like this:
D,E,F, message, score, A,B,C, ID d,e,f, Let's read a book, 24, a,b,c, 1 j,k,l, Read this book, 39, d,e,f, 2 m,n,o, Have you read this book?, 15, g,h,i, 3
This is just a sample. The original dataset contains 20,000 thousand rows and 20 columns.
From this dataset,
- Find the rows that have the word 'read' in them and have score more than 20. 2. From these rows, print only the score and ID columns, sorted based on score value.
- Store these sorted columns in a text file.
The expected output is:
Score ID 24 1 39 2
How can I do this using shell commands?