Homework answers / question archive / Use a Unix shell to manipulate the file and answer the following questions: 1

Use a Unix shell to manipulate the file and answer the following questions: 1

Computer Science

Share With

---

Use a Unix shell to manipulate the file and answer the following questions:

1. Decompress the file. How big is it?

2. What delimiter is used to separate the columns in the file? The 2nd column is the unique identifier for a Facebook post. Print out the names of other columns in the output?

3. How many unique pages are there?

4. What is the date range for Facebook posts in this file? (Assume that the data is in order)

5. How many times has the term "Donald Trump" (ignore the case) appeared in the content of post names? When was the first mention of "Donald Trump" (ignore the case) in the post names and what was the post name? Considering different columns which you have for this post, excluding the message and post name, can you say whether people's reactions were positive/ negative to this post? How many reactions can you see against this post?

6. Select the post id and number of likes of posts in which the term "Trump" (Ignore the case) is mentioned in the post content and the number of likes is greater than 100. Then, sort the data based on the like_count (descending sort) and save it in a file named as "trump.txt". (You need to add a screenshot of the output, including the first 5 rows and the column headers in your report).

The link file(Facebook Data) is https://drive.google.com/file/d/14J5nGYFpvENDJJAaCSuvvJiHTe4V31JS/view?usp=sharing

Need to explain what each part of command does for all your answers in this question