Part 4 (21 points in total, 3 points for each) Assume a file named "tiobelndex" containing the ratings of programming languages as follows. There are six fields in each line separated by comma. The first filed is the ranking in September this year. The second filed is the ranking in September last year. The first row shows the meaning for each field, the remained rows show the rating information for the top 10 programming languages. Write commands to finish following tasks Programming Language. Java, Sep 2017, Sep 2016. Change, 1. 1 2, 2 3. 3. 4. 4. 5, 6. 7. 6 8. 9 9. 10 10. 12, Srima viso CH CH Python, PHP. JavaScript, Visual Basic NET. Perl Ruby Ratings Change 12.687%, -5559 7.382%, -3.57 5.56596, -1.0996 477996, -0,71% 2.98396 1.329 2.210, -0.619 2017, -0.91% 1.9829 -0.36 1.952. -0,3896 1.93396 -0.039 Question 29 (3 points) Count the number of programming languages which ranked higher than September last year using we and grep or egrep (Hint: A plus sign in the third field shows that the rank is increased compared to September last year) Question 30 (3 points Remove the lines for PHP and vascripsised Question 30 (3 points) Remove the lines for PHP and JavaScript using sed. Question 31 (3 points) Remove the change rate in the last field and a comma before it for each programming language using sed E.g. The info for Java should be changed 12 Java 1.2.6878 Question 32 (3 points) Output only the two fields: ranking in September this year and name of programming language using awk. Note add text "Ranked before the rank and put a colon between the rank and the name. Eg. The info for Java should be displayed as Ranked Java Question 33 (3 points) Change the plus sign in the third field to text "increase" (you can use is to matc space character E.g. Info for PHP should be changed to 6, 7, increase. PHP 2.210%, -0.64% Question 34 (3 points) Remove the first line using sed and save output to file 'newindex": Question 35 (3 points) Sort the file "newindex by the name of the programming language in ascending order Part 4 (21 points in total, 3 points for each) Assume a file named "tiobelndex" containing the ratings of programming languages as follows. There are six fields in each line separated by comma. The first filed is the ranking in September this year. The second filed is the ranking in September last year. The first row shows the meaning for each field, the remained rows show the rating information for the top 10 programming languages. Write commands to finish following tasks Programming Language. Java, Sep 2017, Sep 2016. Change, 1. 1 2, 2 3. 3. 4. 4. 5, 6. 7. 6 8. 9 9. 10 10. 12, Srima viso CH CH Python, PHP. JavaScript, Visual Basic NET. Perl Ruby Ratings Change 12.687%, -5559 7.382%, -3.57 5.56596, -1.0996 477996, -0,71% 2.98396 1.329 2.210, -0.619 2017, -0.91% 1.9829 -0.36 1.952. -0,3896 1.93396 -0.039 Question 29 (3 points) Count the number of programming languages which ranked higher than September last year using we and grep or egrep (Hint: A plus sign in the third field shows that the rank is increased compared to September last year) Question 30 (3 points Remove the lines for PHP and vascripsised Question 30 (3 points) Remove the lines for PHP and JavaScript using sed. Question 31 (3 points) Remove the change rate in the last field and a comma before it for each programming language using sed E.g. The info for Java should be changed 12 Java 1.2.6878 Question 32 (3 points) Output only the two fields: ranking in September this year and name of programming language using awk. Note add text "Ranked before the rank and put a colon between the rank and the name. Eg. The info for Java should be displayed as Ranked Java Question 33 (3 points) Change the plus sign in the third field to text "increase" (you can use is to matc space character E.g. Info for PHP should be changed to 6, 7, increase. PHP 2.210%, -0.64% Question 34 (3 points) Remove the first line using sed and save output to file 'newindex": Question 35 (3 points) Sort the file "newindex by the name of the programming language in ascending order
