Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Please provide the queries using mongoDB. The sample object in database is shown in the attached picture. 1. How many tweets are not retweets or replies? (hint the field retweeted_status contains an object when the tweet is a retweeet) 2. Return the top 10 screen_names by their number of followers. 3. Who is the person that got the most tweets?

Please provide the queries using mongoDB. The sample object in database is shown in the attached picture. 1. How many tweets are not retweets or replies? (hint the field retweeted_status contains an object when the tweet is a retweeet) 2. Return the top 10 screen_names by their number of followers. 3. Who is the person that got the most tweets?

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

Please provide the queries using mongoDB. The sample object in database is shown in the attached picture.

1. How many tweets are not retweets or replies? (hint the field retweeted_status contains an object when the tweet is a retweeet)

2. Return the top 10 screen_names by their number of followers.

3. Who is the person that got the most tweets?

4. Who are the top 10 people that got more retweets in average, after tweeting more than 3 times. (Clarification: List the top 10 users with the most average number of retweets per tweet, but that have tweeted at least three times. Sorted by average retweets per tweet in descending order)

### Educational Resource: Understanding JSON Data Structure #### Transcription of JSON Data The image displays a JSON object that represents a structured data set, typically used in web applications to store and exchange information. Below is a detailed breakdown of the JSON fields and their purpose: - **_id**: This is a unique identifier for the database record, with the value `"61983df248dd6732c6aa07ec"`. - **created_at**: Indicates the date and time when the entry was created. In this instance, it is `"Sun Oct 25 19:58:26 +0000 2020"`. - **id**: Represents the unique ID of the Twitter post as a number: `1320454693668212736`. - **id_str**: The same as the `id` but represented as a string: `"1320454693668212736"`. - **text**: Contains the actual content of the tweet: `"That BELIV workshop, Provocations session really kicked me into being ..."`. - **truncated**: A boolean value (`true`) indicating whether the tweet is truncated. - **entities**: An object, which typically contains metadata related to hashtags, user mentions, URLs, etc. Here, it is empty. - **metadata**: A nested object with the following field: - **source**: HTML link indicating the source of the tweet, in this case, `<a href="https://mobile.twitter.com" rel="nofollow">Twitter Web App</a>`. - **in_reply_to_status_id**: Null, indicating this tweet is not a reply to another tweet. - **in_reply_to_status_id_str**: Null for the same reason as above. - **in_reply_to_user_id**: Null, indicating no specific user is being replied to. - **in_reply_to_user_id_str**: Null as above. - **in_reply_to_screen_name**: Null, as the tweet is not in reply to a specific username. - **user**: An object likely to contain information about the user who posted the tweet, which is not expanded in this snippet. - **geo**: Null, indicating no geolocation data is attached. - **coordinates**: Null, as no specific coordinates are provided. - **place**: Null, indicating no specific place is associated with the tweet. - **contributors**: Null, indicating no contributors are noted. - **
Transcribed Image Text:### Educational Resource: Understanding JSON Data Structure #### Transcription of JSON Data The image displays a JSON object that represents a structured data set, typically used in web applications to store and exchange information. Below is a detailed breakdown of the JSON fields and their purpose: - **_id**: This is a unique identifier for the database record, with the value `"61983df248dd6732c6aa07ec"`. - **created_at**: Indicates the date and time when the entry was created. In this instance, it is `"Sun Oct 25 19:58:26 +0000 2020"`. - **id**: Represents the unique ID of the Twitter post as a number: `1320454693668212736`. - **id_str**: The same as the `id` but represented as a string: `"1320454693668212736"`. - **text**: Contains the actual content of the tweet: `"That BELIV workshop, Provocations session really kicked me into being ..."`. - **truncated**: A boolean value (`true`) indicating whether the tweet is truncated. - **entities**: An object, which typically contains metadata related to hashtags, user mentions, URLs, etc. Here, it is empty. - **metadata**: A nested object with the following field: - **source**: HTML link indicating the source of the tweet, in this case, `<a href="https://mobile.twitter.com" rel="nofollow">Twitter Web App</a>`. - **in_reply_to_status_id**: Null, indicating this tweet is not a reply to another tweet. - **in_reply_to_status_id_str**: Null for the same reason as above. - **in_reply_to_user_id**: Null, indicating no specific user is being replied to. - **in_reply_to_user_id_str**: Null as above. - **in_reply_to_screen_name**: Null, as the tweet is not in reply to a specific username. - **user**: An object likely to contain information about the user who posted the tweet, which is not expanded in this snippet. - **geo**: Null, indicating no geolocation data is attached. - **coordinates**: Null, as no specific coordinates are provided. - **place**: Null, indicating no specific place is associated with the tweet. - **contributors**: Null, indicating no contributors are noted. - **
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS