1. Learn
  2. /
  3. Courses
  4. /
  5. Analyzing Social Media Data in Python

Exercise

Tweet Items and Tweet Flattening

There are multiple fields in the Twitter JSON which contains textual data. In a typical tweet, there's the tweet text, the user description, and the user location. In a tweet longer than 140 characters, there's the extended tweet child JSON. And in a quoted tweet, there's the original tweet text and the commentary with the quoted tweet.

For this exercise, you'll extract textual elements from a single quoted tweet in which the original tweet has more than 140 characters. Then, to analyze tweets at scale, we will want to flatten the tweet JSON into a single level. This will allow us to store the tweets in a DataFrame format.

quoted_tweet has been loaded for you.

Instructions 1/2

undefined XP
    1
    2
  • Print the tweet text.
  • Print the quoted tweet text, that is, the text in quoted_status.
  • Print the quoted tweet's extended (140+ character) full_text in extended_tweet.
  • Print the quoted tweet user's location.