{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Exercise 08\n", "\n", "## Analyze how travelers expressed their feelings on Twitter\n", "\n", "A sentiment analysis job about the problems of each major U.S. airline. \n", "Twitter data was scraped from February of 2015 and contributors were \n", "asked to first classify positive, negative, and neutral tweets, followed\n", "by categorizing negative reasons (such as \"late flight\" or \"rude service\")." ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | airline_sentiment | \n", "airline_sentiment_confidence | \n", "negativereason | \n", "negativereason_confidence | \n", "airline | \n", "airline_sentiment_gold | \n", "name | \n", "negativereason_gold | \n", "retweet_count | \n", "text | \n", "tweet_coord | \n", "tweet_created | \n", "tweet_location | \n", "user_timezone | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
tweet_id | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
570306133677760513 | \n", "neutral | \n", "1.0000 | \n", "NaN | \n", "NaN | \n", "Virgin America | \n", "NaN | \n", "cairdin | \n", "NaN | \n", "0 | \n", "@VirginAmerica What @dhepburn said. | \n", "NaN | \n", "2015-02-24 11:35:52 -0800 | \n", "NaN | \n", "Eastern Time (US & Canada) | \n", "
570301130888122368 | \n", "positive | \n", "0.3486 | \n", "NaN | \n", "0.0000 | \n", "Virgin America | \n", "NaN | \n", "jnardino | \n", "NaN | \n", "0 | \n", "@VirginAmerica plus you've added commercials t... | \n", "NaN | \n", "2015-02-24 11:15:59 -0800 | \n", "NaN | \n", "Pacific Time (US & Canada) | \n", "
570301083672813571 | \n", "neutral | \n", "0.6837 | \n", "NaN | \n", "NaN | \n", "Virgin America | \n", "NaN | \n", "yvonnalynn | \n", "NaN | \n", "0 | \n", "@VirginAmerica I didn't today... Must mean I n... | \n", "NaN | \n", "2015-02-24 11:15:48 -0800 | \n", "Lets Play | \n", "Central Time (US & Canada) | \n", "
570301031407624196 | \n", "negative | \n", "1.0000 | \n", "Bad Flight | \n", "0.7033 | \n", "Virgin America | \n", "NaN | \n", "jnardino | \n", "NaN | \n", "0 | \n", "@VirginAmerica it's really aggressive to blast... | \n", "NaN | \n", "2015-02-24 11:15:36 -0800 | \n", "NaN | \n", "Pacific Time (US & Canada) | \n", "
570300817074462722 | \n", "negative | \n", "1.0000 | \n", "Can't Tell | \n", "1.0000 | \n", "Virgin America | \n", "NaN | \n", "jnardino | \n", "NaN | \n", "0 | \n", "@VirginAmerica and it's a really big bad thing... | \n", "NaN | \n", "2015-02-24 11:14:45 -0800 | \n", "NaN | \n", "Pacific Time (US & Canada) | \n", "