Twitter data to DataFrame
Now you have the Twitter data in a list of dictionaries, tweets_data, where each dictionary corresponds to a single tweet. Next, you're going to extract the text and language of each tweet. The text in a tweet, t1, is stored as the value t1['text']; similarly, the language is stored in t1['lang']. Your task is to build a DataFrame in which each row is a tweet and the columns are 'text' and 'lang'.
This exercise is part of the course
Intermediate Importing Data in Python
Exercise instructions
- Use
pd.DataFrame()to construct a DataFrame of tweet texts and languages; to do so, the first argument should betweets_data, a list of dictionaries. The second argument topd.DataFrame()is a list of the keys you wish to have as columns. Assign the result of thepd.DataFrame()call todf. - Print the head of the DataFrame.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Import package
import pandas as pd
# Build DataFrame of tweet texts and languages
df = pd.DataFrame(____, columns=____)
# Print head of DataFrame