tweet_id,airline_sentiment,airline_sentiment_confidence,negativereason,negativereason_confidence,airline,airline_sentiment_gold,name,negativereason_gold,retweet_count,text,tweet_coord,tweet_created,tw...

1 answer below »
I want 4 questions to be done question 2-4 there should be zero plagarsim. I want the (i.pynb files for the same).


tweet_id,airline_sentiment,airline_sentiment_confidence,negativereason,negativereason_confidence,airline,airline_sentiment_gold,name,negativereason_gold,retweet_count,text,tweet_coord,tweet_created,tweet_location,user_timezone 570306133677760513,neutral,1.0,,,Virgin America,,cairdin,,0,@VirginAmerica What @dhepburn said.,,2015-02-24 11:35:52 -0800,,Eastern Time (US & Canada) 570301130888122368,positive,0.3486,,0.0,Virgin America,,jnardino,,0,@VirginAmerica plus you've added commercials to the experience... tacky.,,2015-02-24 11:15:59 -0800,,Pacific Time (US & Canada) 570301083672813571,neutral,0.6837,,,Virgin America,,yvonnalynn,,0,@VirginAmerica I didn't today... Must mean I need to take another trip!,,2015-02-24 11:15:48 -0800,Lets Play,Central Time (US & Canada) 570301031407624196,negative,1.0,Bad Flight,0.7033,Virgin America,,jnardino,,0,"@VirginAmerica it's really aggressive to blast obnoxious ""entertainment"" in your guests' faces & they have little recourse",,2015-02-24 11:15:36 -0800,,Pacific Time (US & Canada) 570300817074462722,negative,1.0,Can't Tell,1.0,Virgin America,,jnardino,,0,@VirginAmerica and it's a really big bad thing about it,,2015-02-24 11:14:45 -0800,,Pacific Time (US & Canada) 570300767074181121,negative,1.0,Can't Tell,0.6842,Virgin America,,jnardino,,0,"@VirginAmerica seriously would pay $30 a flight for seats that didn't have this playing. it's really the only bad thing about flying VA",,2015-02-24 11:14:33 -0800,,Pacific Time (US & Canada) 570300616901320704,positive,0.6745,,0.0,Virgin America,,cjmcginnis,,0,"@VirginAmerica yes, nearly every time I fly VX this “ear worm” won’t go away :)",,2015-02-24 11:13:57 -0800,San Francisco CA,Pacific Time (US & Canada) 570300248553349120,neutral,0.634,,,Virgin America,,pilot,,0,"@VirginAmerica Really missed a prime opportunity for Men Without Hats parody, there. https://t.co/mWpG7grEZP",,2015-02-24 11:12:29 -0800,Los Angeles,Pacific Time (US & Canada) 570299953286942721,positive,0.6559,,,Virgin America,,dhepburn,,0,"@virginamerica Well, I didn't
but NOW I DO! :-D",,2015-02-24 11:11:19 -0800,San Diego,Pacific Time (US & Canada) 570295459631263746,positive,1.0,,,Virgin America,,YupitsTate,,0,"@VirginAmerica it was amazing, and arrived an hour early. You're too good to me.",,2015-02-24 10:53:27 -0800,Los Angeles,Eastern Time (US & Canada) 570294189143031808,neutral,0.6769,,0.0,Virgin America,,idk_but_youtube,,0,@VirginAmerica did you know that suicide is the second leading cause of death among teens 10-24,,2015-02-24 10:48:24 -0800,1/1 loner squad,Eastern Time (US & Canada) 570289724453216256,positive,1.0,,,Virgin America,,HyperCamiLax,,0,@VirginAmerica I <3 pretty="" graphics.="" so="" much="" better="" than="" minimal="" iconography.="" :d,,2015-02-24="" 10:30:40="" -0800,nyc,america/new_york="" 570289584061480960,positive,1.0,,,virgin="" america,,hypercamilax,,0,@virginamerica="" this="" is="" such="" a="" great="" deal!="" already="" thinking="" about="" my="" 2nd="" trip="" to="" @australia="" &="" i="" haven't="" even="" gone="" on="" my="" 1st="" trip="" yet!="" ;p,,2015-02-24="" 10:30:06="" -0800,nyc,america/new_york="" 570287408438120448,positive,0.6451,,,virgin="" america,,mollanderson,,0,@virginamerica="" @virginmedia="" i'm="" flying="" your="" #fabulous="" #seductive="" skies="" again!="" u="" take="" all="" the="" #stress="" away="" from="" travel="" http://t.co/ahlxhhkiyn,,2015-02-24="" 10:21:28="" -0800,,eastern="" time="" (us="" &="" canada)="" 570285904809598977,positive,1.0,,,virgin="" america,,sjespers,,0,@virginamerica="" thanks!,,2015-02-24="" 10:15:29="" -0800,"san="" francisco,="" ca",pacific="" time="" (us="" &="" canada)="" 570282469121007616,negative,0.6842,late="" flight,0.3684,virgin="" america,,smartwatermelon,,0,@virginamerica="" sfo-pdx="" schedule="" is="" still="" mia.,,2015-02-24="" 10:01:50="" -0800,"palo="" alto,="" ca",pacific="" time="" (us="" &="" canada)="" 570277724385734656,positive,1.0,,,virgin="" america,,itzbrianhunty,,0,@virginamerica="" so="" excited="" for="" my="" first="" cross="" country="" flight="" lax="" to="" mco="" i've="" heard="" nothing="" but="" great="" things="" about="" virgin="" america.="" #29daystogo,,2015-02-24="" 09:42:59="" -0800,west="" covina,pacific="" time="" (us="" &="" canada)="" 570276917301137409,negative,1.0,bad="" flight,1.0,virgin="" america,,heatherovieda,,0,@virginamerica="" i="" flew="" from="" nyc="" to="" sfo="" last="" week="" and="" couldn't="" fully="" sit="" in="" my="" seat="" due="" to="" two="" large="" gentleman="" on="" either="" side="" of="" me.="" help!,,2015-02-24="" 09:39:46="" -0800,this="" place="" called="" nyc,eastern="" time="" (us="" &="" canada)="" 570270684619923457,positive,1.0,,,virgin="" america,,thebrandiray,,0,i="" ❀="" flying="" @virginamerica.="" ☺👍,,2015-02-24="" 09:15:00="" -0800,somewhere="" celebrating="" life.="" ,atlantic="" time="" (canada)="" 570267956648792064,positive,1.0,,,virgin="" america,,jnlpierce,,0,@virginamerica="" you="" know="" what="" would="" be="" amazingly="" awesome?="" bos-fll="" please!!!!!!!="" i="" want="" to="" fly="" with="" only="" you.,,2015-02-24="" 09:04:10="" -0800,boston="" |="" waltham,quito="" 570265883513384960,negative,0.6705,can't="" tell,0.3614,virgin="" america,,missgj,,0,@virginamerica="" why="" are="" your="" first="" fares="" in="" may="" over="" three="" times="" more="" than="" other="" carriers="" when="" all="" seats="" are="" available="" to="" select???,,2015-02-24="" 08:55:56="" -0800,,="" 570264145116819457,positive,1.0,,,virgin="" america,,dt_les,,0,@virginamerica="" i="" love="" this="" graphic.="" http://t.co/ut5grrwaaa,"[40.74804263,="" -73.99295302]",2015-02-24="" 08:49:01="" -0800,,="" 570259420287868928,positive,1.0,,,virgin="" america,,elvinabeck,,0,@virginamerica="" i="" love="" the="" hipster="" innovation.="" you="" are="" a="" feel="" good="" brand.,,2015-02-24="" 08:30:15="" -0800,los="" angeles,pacific="" time="" (us="" &="" canada)="" 570258822297579520,neutral,1.0,,,virgin="" america,,rjlynch21086,,0,@virginamerica="" will="" you="" be="" making="" bos="">LAS non stop permanently anytime soon?,,2015-02-24 08:27:52 -0800,"Boston, MA ",Eastern Time (US & Canada) 570256553502068736,negative,1.0,Customer Service Issue,0.3557,Virgin America,,ayeevickiee,,0,@VirginAmerica you guys messed up my seating.. I reserved seating with my friends and you guys gave my seat away ... 😡 I want free internet,,2015-02-24 08:18:51 -0800,714,Mountain Time (US & Canada) 570249102404923392,negative,1.0,Customer Service Issue,1.0,Virgin America,,Leora13,,0,@VirginAmerica status match program. I applied and it's been three weeks. Called and emailed with no response.,,2015-02-24 07:49:15 -0800,, 570239632807370753,negative,1.0,Can't Tell,0.6614,Virgin America,,meredithjlynn,,0,@VirginAmerica What happened 2 ur vegan food options?! At least say on ur site so i know I won't be able 2 eat anything for next 6 hrs #fail,,2015-02-24 07:11:37 -0800,, 570217831557677057,neutral,0.6854,,,Virgin America,,AdamSinger,,0,@VirginAmerica do you miss me? Don't worry we'll be together very soon.,,2015-02-24 05:44:59 -0800,"San Francisco, CA",Central Time (US & Canada) 570207886493782019,negative,1.0,Bad Flight,1.0,Virgin America,,blackjackpro911,,0,@VirginAmerica amazing to me that we can't get any cold air from the vents. #VX358 #noair #worstflightever #roasted #SFOtoBOS,"[42.361016, -71.02000488]",2015-02-24 05:05:28 -0800,"San Mateo, CA & Las Vegas, NV", 570124596180955136,neutral,0.615,,0.0,Virgin America,,TenantsUpstairs,,0,@VirginAmerica LAX to EWR - Middle seat on a red eye. Such a noob maneuver. #sendambien #andchexmix,"[33.94540417, -118.4062472]",2015-02-23 23:34:30 -0800,Brooklyn,Atlantic Time (Canada) 570114021854212096,negative,1.0,Flight Booking Problems,1.0,Virgin America,,jordanpichler,,0,"@VirginAmerica hi! I just bked a cool birthday trip with you, but i can't add my elevate no. cause i entered my middle name during Flight Booking Problems 😢",,2015-02-23 22:52:29 -0800,,Vienna 570094701371469825,neutral,1.0,,,Virgin America,,JCervantezzz,,0,@VirginAmerica Are the hours of operation for the Club at SFO that are posted online current?,,2015-02-23 21:35:43 -0800,"California, San Francisco",Pacific Time (US & Canada) 570088404156698625,negative,1.0,Customer Service Issue,1.0,Virgin America,,Cuschoolie1,,0,"@VirginAmerica help, left expensive headphones on flight 89 IAD to LAX today. Seat 2A. No one answering L&F number at LAX!","[33.94209449, -118.40410103]",2015-02-23 21:10:41 -0800,Washington DC,Quito 570084582780899328,negative,1.0,Customer Service Issue,1.0,Virgin America,,amanduhmccarty,,0,"@VirginAmerica awaiting my return phone call, just would prefer to use your online self-service option :(",,2015-02-23 20:55:30 -0800,,Pacific Time (US & Canada) 570076792993611776,positive,1.0,,,Virgin America,,NorthTxHomeTeam,,0,@VirginAmerica this is great news! America could start flights to Hawaii by end of year http://t.co/r8p2Zy3fe4 via @Pacificbiznews,"[33.2145038, -96.9321504]",2015-02-23 20:24:33 -0800,Texas,Central Time (US & Canada) 570051991277342720,neutral,0.6207,,,Virgin America,,miaerolinea,,0,Nice RT @VirginAmerica: Vibe with the moodlight from takeoff to touchdown. #MoodlitMonday #ScienceBehindTheExperience http://t.co/Y7O0uNxTQP,,2015-02-23 18:46:00 -0800,Worldwide,Caracas 570051381534396416,positive,1.0,,,Virgin America,,Nicsplace,,0,@VirginAmerica Moodlighting is the only way to fly! Best experience EVER! Cool and calming. 💜✈ #MoodlitMonday,,2015-02-23 18:43:35 -0800,Central Texas, 570045393565691904,positive,1.0,,,Virgin America,,Nicsplace,,0,"@VirginAmerica @freddieawards Done and done! Best airline around, hands down!",,2015-02-23 18:19:47 -0800,Central Texas, 570038941497192448,neutral,0.6791,,0.0,Virgin America,,elisha_malulani,,0,@VirginAmerica when can I book my flight to Hawaii??,,2015-02-23 17:54:09 -0800,i'm creating a monster ,Pacific Time (US & Canada) 570035876845084672,negative,1.0,Customer Service Issue,1.0,Virgin America,,DannyDouglass,,0,@VirginAmerica Your chat support is not working on your site: http://t.co/vhp2GtDWPk,,2015-02-23 17:41:58 -0800,"San Francisco, CA",Pacific Time (US & Canada) 570033593394667521,positive,0.6639,,,Virgin America,,jamesferrandini,,0,"@VirginAmerica View of downtown Los Angeles, the Hollywood Sign, and beyond that rain in the mountains! http://t.co/Dw5nf0ibtr",,2015-02-23 17:32:54 -0800,, 570025482344898560,negative,0.6688,Flight Booking Problems,0.6688,Virgin America,,will_lenzenjr,,0,"@VirginAmerica Hey, first time flyer next week - excited! But I'm having a hard time getting my flights added to my Elevate account. Help?",,2015-02-23 17:00:40 -0800,Iowa City,Central Time (US & Canada) 570016304284901379,neutral,1.0,,,Virgin America,,GottAmanda,,0,@VirginAmerica plz help me win my bid upgrade for my flight 2/27 LAX--->SEA!!! 🍷👍💺✈,"[34.0219817, -118.38591198]",2015-02-23 16:24:11 -0800,Los Angeles, 570015408788414464,neutral,0.6578,,0.0,Virgin America,,KGervaise,,0,@VirginAmerica I have an unused ticket but moved to a new city where you don't fly. How can I fly with you before it expires? #travelhelp,,2015-02-23 16:20:38 -0800,Georgia,Pacific Time (US & Canada) 570013523650048002,neutral,1.0,,,Virgin America,,papamurat,,0,@VirginAmerica are flights leaving Dallas for Seattle on time Feb 24?,,2015-02-23 16:13:09 -0800,, 570012257549070337,positive,1.0,,,Virgin America,,arieldaie,,0,@VirginAmerica I'm #elevategold for a good reason: you rock!!,,2015-02-23 16:08:07 -0800,Los Angeles, 570011341483843584,neutral,0.6799,,,Virgin America,,vacations7,,0,@VirginAmerica DREAM http://t.co/oA2dRfAoQ2 http://t.co/lWWdAc2kHx,,2015-02-23 16:04:28 -0800,Turks and caicos, 570010571707256832,positive,1.0,,,Virgin America,,ChelseaPoe666,,0,@VirginAmerica wow this just blew my mind,,2015-02-23 16:01:25 -0800,Oakland via Midwest ,Atlantic Time (Canada) 570010539499393025,neutral,1.0,,,Virgin America,,BobGlavinVO,,0,@VirginAmerica @ladygaga @carrieunderwood After last night #tribute #SoundOfMusic #Oscars2015 @ladygaga! I think @carrieunderwood agree,,2015-02-23 16:01:17 -0800,"New York, NY",Eastern Time (US & Canada) 570009713447825408,neutral,0.6436,,,Virgin America,,lisaaiko,,0,@VirginAmerica @ladygaga @carrieunderwood All were entertaining,,2015-02-23 15:58:00 -0800,, 570009035455344640,neutral,0.6764,,0.0,Virgin America,,grantbrowne,,0,"@VirginAmerica Is flight 769 on it's way? Was supposed to take off 30 minutes ago. Website still
Answered Same DayNov 27, 2021

Answer To: tweet_id,airline_sentiment,airline_sentiment_confidence,negativereason,negativereason_confidence,air...

Ayush answered on Nov 27 2021
153 Votes
{
"cells": [
{
"cell_type": "raw",
"metadata": {},
"source": [
"2>What are the most common causes of dissatisfaction in each company?\n",
"Negative reasons for negat
ive sentiments of airlines are bad Flight, cancelled Flight, late flights and Customer service issues. type of chart can use here is bar chart. coloumn of negative sentiment is categorical variable so bar chart will suit proper here.following code will extract negative reasons from data\n"
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"MAIN REASON BEHIND NEGATIVE SENTIMENTS\n",
"0 Bad Flight\n",
"1 Can't Tell\n",
"2 Can't Tell\n",
"3 Late Flight\n",
"4 Bad Flight\n",
" ... \n",
"9173 Bad Flight\n",
"9174 Cancelled Flight\n",
"9175 Late Flight\n",
"9176 Customer Service Issue\n",
"9177 Customer Service Issue\n",
"Name: negativereason, Length: 9178, dtype: object\n"
]
}
],
"source": [
"import pandas as pd\n",
"df=pd.read_csv(\"tweets-qywzymrw.csv\")\n",
"df.head()\n",
"print(\"MAIN REASON BEHIND NEGATIVE SENTIMENTS\")\n",
"print(df[\"negativereason\"])\n",
"\n"
]
},
{
"cell_type": "raw",
"metadata": {},
"source": [
"3>- For each airline company, what are the most frequent words in negative sentiments\n",
"By creating word cloud we can find out which words are often used in negative sentiments"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {},
"outputs": [
{
"data": {
"image/png":...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here