{ "cells": [ { "cell_type": "code", "execution_count": 53, "id": "867f5cec", "metadata": {}, "outputs": [], "source": [ "import numpy as np\n", "import pandas as pd\n", "import seaborn as sns" ] }, { "cell_type": "code", "execution_count": 54, "id": "48a62224", "metadata": {}, "outputs": [], "source": [ "import tweepy \n", "from textblob import TextBlob" ] }, { "cell_type": "code", "execution_count": 55, "id": "916433f4", "metadata": {}, "outputs": [], "source": [ "import re" ] }, { "cell_type": "code", "execution_count": 56, "id": "111f1db9", "metadata": {}, "outputs": [], "source": [ "import matplotlib.pyplot as plt" ] }, { "cell_type": "code", "execution_count": 57, "id": "ec3a351f", "metadata": {}, "outputs": [], "source": [ "df=pd.read_csv('Twitter.csv')" ] }, { "cell_type": "code", "execution_count": 58, "id": "d3e8d2a7", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | twitterApiKey | \n", "twitterApiSecret | \n", "twitterApiAccessToken | \n", "twitterApiAccessTokenSecret | \n", "
---|---|---|---|---|
0 | \n", "hsoBg1jyydpIYLQb40E9hj1N9 | \n", "cVCzel2FEKv8hyhu7Qxei0dozF1v1n1tfd32JpcVOIAkG3... | \n", "1459167848513765382-RFf6qpbaxLSILLLTQVTkRx8qgA... | \n", "9uXrghABgomgWYKznz7CU6GfBFgL4xqxxgIIc2uGPep8i | \n", "
\n", " | Tweet | \n", "
---|---|
0 | \n", "Be at your best, and the first to get my Elect... | \n", "
1 | \n", "When in the tube 🤷🏻♂️ https://t.co/poEzsCpnTm | \n", "
2 | \n", "O’cean Fruit Water is my favourite hydration b... | \n", "
3 | \n", "12 years in test cricket today. Forever gratef... | \n", "
4 | \n", "It's time to be better with #Batwrap \\n \\nI’m ... | \n", "
\n", " | Tweet | \n", "
---|---|
0 | \n", "be at your best and the first to get my electr... | \n", "
1 | \n", "when in the tube httpstcopoezscpntm | \n", "
2 | \n", "ocean fruit water is my favourite hydration bo... | \n", "
3 | \n", "years in test cricket today forever grateful h... | \n", "
4 | \n", "its time to be better with batwrap im proud to... | \n", "
5 | \n", "look for excuses or look to get better httpstc... | \n", "
6 | \n", "congratulations amp on sealing citys seventh f... | \n", "
7 | \n", "my records my awards my wins amp losses wipemy... | \n", "
8 | \n", "saddened to hear about the tragic train accide... | \n", "
9 | \n", "unlock the unexpected wrogn treasures with the... | \n", "
10 | \n", "prep httpstcouyculkogj | \n", "
11 | \n", "rt hey cricket fans put your cricketing wisdom... | \n", "
12 | \n", "this bat is an extension of me on the field it... | \n", "
13 | \n", "all day everyday x httpstcoobashm | \n", "
14 | \n", "after many challenges amp tests in these past ... | \n", "
15 | \n", "httpstcopgcgoi | \n", "
16 | \n", "the whites httpstcoddysdxyt | \n", "
17 | \n", "the sustainable edition of our energy drink ma... | \n", "
18 | \n", "lighting up the pitch with cop the allnew puma... | \n", "
19 | \n", "forever pushing to be faster in my foreverrun ... | \n", "
20 | \n", "a season which had its moments but unfortunate... | \n", "
21 | \n", "unleash the madness the wrogn throwaway festiv... | \n", "
22 | \n", "job well done in hyderabad httpstcopjhkvupnc | \n", "
23 | \n", "httpstcosbnvddws | \n", "
24 | \n", "make a team with your favourite players amp wi... | \n", "
25 | \n", "trainer test basu sir do you want a cheese poc... | \n", "
26 | \n", "we are thrilled to announce the launch of the ... | \n", "
27 | \n", "important win great character shown by the boy... | \n", "
28 | \n", "happy mothers day httpstcooxtbkkweie | \n", "
29 | \n", "httpstcoianoolxx | \n", "
30 | \n", "we got a challenge ahead of us httpstcojamdmyycei | \n", "
31 | \n", "its a long road to the top but the greatest le... | \n", "
32 | \n", "the competition is all in your head in reality... | \n", "
33 | \n", "are you ready to fuel your passion and take yo... | \n", "
34 | \n", "everyday is a chance to be better httpstcovsmq... | \n", "
35 | \n", "httpstcoidsnxgu | \n", "
36 | \n", "indias safest gaming platform pe no fraud no c... | \n", "
37 | \n", "out and about in delhi httpstcodrhifnntq | \n", "
38 | \n", "httpstcoqsadhhzrj | \n", "
39 | \n", "addweighttoyourcv with management programs fro... | \n", "
40 | \n", "amazing win tonight love the massive support f... | \n", "
41 | \n", "love you through thick thin and all your cute ... | \n", "
42 | \n", "partner on the crease partner in cringy jokes ... | \n", "
43 | \n", "a bold new contest is now live take a screensh... | \n", "
44 | \n", "special win for a special cause httpstconcgrcxrdq | \n", "
45 | \n", "httpstcozowoyiehc | \n", "
46 | \n", "fixing your teeth is now as easypeasy as order... | \n", "
47 | \n", "brilliant spell by miyan and a solid win today... | \n", "
48 | \n", "hello mohali httpstcomzfcbpds | \n", "
49 | \n", "as puzzling as the furrowed brow click here fo... | \n", "
\n", " | Tweet | \n", "Subjectivity | \n", "
---|---|---|
0 | \n", "be at your best and the first to get my electr... | \n", "0.317576 | \n", "
1 | \n", "when in the tube httpstcopoezscpntm | \n", "0.000000 | \n", "
2 | \n", "ocean fruit water is my favourite hydration bo... | \n", "1.000000 | \n", "
3 | \n", "years in test cricket today forever grateful h... | \n", "0.000000 | \n", "
4 | \n", "its time to be better with batwrap im proud to... | \n", "0.533333 | \n", "
5 | \n", "look for excuses or look to get better httpstc... | \n", "0.500000 | \n", "
6 | \n", "congratulations amp on sealing citys seventh f... | \n", "0.450000 | \n", "
7 | \n", "my records my awards my wins amp losses wipemy... | \n", "0.200000 | \n", "
8 | \n", "saddened to hear about the tragic train accide... | \n", "0.750000 | \n", "
9 | \n", "unlock the unexpected wrogn treasures with the... | \n", "1.000000 | \n", "
10 | \n", "prep httpstcouyculkogj | \n", "0.000000 | \n", "
11 | \n", "rt hey cricket fans put your cricketing wisdom... | \n", "0.400000 | \n", "
12 | \n", "this bat is an extension of me on the field it... | \n", "0.750000 | \n", "
13 | \n", "all day everyday x httpstcoobashm | \n", "0.600000 | \n", "
14 | \n", "after many challenges amp tests in these past ... | \n", "0.437500 | \n", "
15 | \n", "httpstcopgcgoi | \n", "0.000000 | \n", "
16 | \n", "the whites httpstcoddysdxyt | \n", "0.000000 | \n", "
17 | \n", "the sustainable edition of our energy drink ma... | \n", "0.300000 | \n", "
18 | \n", "lighting up the pitch with cop the allnew puma... | \n", "0.000000 | \n", "
19 | \n", "forever pushing to be faster in my foreverrun ... | \n", "0.000000 | \n", "
20 | \n", "a season which had its moments but unfortunate... | \n", "0.683333 | \n", "
21 | \n", "unleash the madness the wrogn throwaway festiv... | \n", "0.000000 | \n", "
22 | \n", "job well done in hyderabad httpstcopjhkvupnc | \n", "0.000000 | \n", "
23 | \n", "httpstcosbnvddws | \n", "0.000000 | \n", "
24 | \n", "make a team with your favourite players amp wi... | \n", "0.250000 | \n", "
25 | \n", "trainer test basu sir do you want a cheese poc... | \n", "0.000000 | \n", "
26 | \n", "we are thrilled to announce the launch of the ... | \n", "0.516667 | \n", "
27 | \n", "important win great character shown by the boy... | \n", "0.537500 | \n", "
28 | \n", "happy mothers day httpstcooxtbkkweie | \n", "1.000000 | \n", "
29 | \n", "httpstcoianoolxx | \n", "0.000000 | \n", "
30 | \n", "we got a challenge ahead of us httpstcojamdmyycei | \n", "0.000000 | \n", "
31 | \n", "its a long road to the top but the greatest le... | \n", "0.437778 | \n", "
32 | \n", "the competition is all in your head in reality... | \n", "0.000000 | \n", "
33 | \n", "are you ready to fuel your passion and take yo... | \n", "0.357143 | \n", "
34 | \n", "everyday is a chance to be better httpstcovsmq... | \n", "0.550000 | \n", "
35 | \n", "httpstcoidsnxgu | \n", "0.000000 | \n", "
36 | \n", "indias safest gaming platform pe no fraud no c... | \n", "0.500000 | \n", "
37 | \n", "out and about in delhi httpstcodrhifnntq | \n", "0.000000 | \n", "
38 | \n", "httpstcoqsadhhzrj | \n", "0.000000 | \n", "
39 | \n", "addweighttoyourcv with management programs fro... | \n", "0.500000 | \n", "
40 | \n", "amazing win tonight love the massive support f... | \n", "0.630000 | \n", "
41 | \n", "love you through thick thin and all your cute ... | \n", "0.785000 | \n", "
42 | \n", "partner on the crease partner in cringy jokes ... | \n", "0.000000 | \n", "
43 | \n", "a bold new contest is now live take a screensh... | \n", "0.540404 | \n", "
44 | \n", "special win for a special cause httpstconcgrcxrdq | \n", "0.514286 | \n", "
45 | \n", "httpstcozowoyiehc | \n", "0.000000 | \n", "
46 | \n", "fixing your teeth is now as easypeasy as order... | \n", "0.000000 | \n", "
47 | \n", "brilliant spell by miyan and a solid win today... | \n", "0.500000 | \n", "
48 | \n", "hello mohali httpstcomzfcbpds | \n", "0.000000 | \n", "
49 | \n", "as puzzling as the furrowed brow click here fo... | \n", "0.500000 | \n", "
\n", " | Tweet | \n", "Subjectivity | \n", "Polarity | \n", "
---|---|---|---|
0 | \n", "be at your best and the first to get my electr... | \n", "0.317576 | \n", "0.197273 | \n", "
1 | \n", "when in the tube httpstcopoezscpntm | \n", "0.000000 | \n", "0.000000 | \n", "
2 | \n", "ocean fruit water is my favourite hydration bo... | \n", "1.000000 | \n", "1.000000 | \n", "
3 | \n", "years in test cricket today forever grateful h... | \n", "0.000000 | \n", "0.000000 | \n", "
4 | \n", "its time to be better with batwrap im proud to... | \n", "0.533333 | \n", "0.433333 | \n", "
5 | \n", "look for excuses or look to get better httpstc... | \n", "0.500000 | \n", "0.500000 | \n", "
6 | \n", "congratulations amp on sealing citys seventh f... | \n", "0.450000 | \n", "-0.200000 | \n", "
7 | \n", "my records my awards my wins amp losses wipemy... | \n", "0.200000 | \n", "0.300000 | \n", "
8 | \n", "saddened to hear about the tragic train accide... | \n", "0.750000 | \n", "-0.750000 | \n", "
9 | \n", "unlock the unexpected wrogn treasures with the... | \n", "1.000000 | \n", "0.100000 | \n", "
10 | \n", "prep httpstcouyculkogj | \n", "0.000000 | \n", "0.000000 | \n", "
11 | \n", "rt hey cricket fans put your cricketing wisdom... | \n", "0.400000 | \n", "0.800000 | \n", "
12 | \n", "this bat is an extension of me on the field it... | \n", "0.750000 | \n", "0.800000 | \n", "
13 | \n", "all day everyday x httpstcoobashm | \n", "0.600000 | \n", "-0.200000 | \n", "
14 | \n", "after many challenges amp tests in these past ... | \n", "0.437500 | \n", "0.162500 | \n", "
15 | \n", "httpstcopgcgoi | \n", "0.000000 | \n", "0.000000 | \n", "
16 | \n", "the whites httpstcoddysdxyt | \n", "0.000000 | \n", "0.000000 | \n", "
17 | \n", "the sustainable edition of our energy drink ma... | \n", "0.300000 | \n", "0.200000 | \n", "
18 | \n", "lighting up the pitch with cop the allnew puma... | \n", "0.000000 | \n", "0.000000 | \n", "
19 | \n", "forever pushing to be faster in my foreverrun ... | \n", "0.000000 | \n", "0.000000 | \n", "
20 | \n", "a season which had its moments but unfortunate... | \n", "0.683333 | \n", "-0.416667 | \n", "
21 | \n", "unleash the madness the wrogn throwaway festiv... | \n", "0.000000 | \n", "0.000000 | \n", "
22 | \n", "job well done in hyderabad httpstcopjhkvupnc | \n", "0.000000 | \n", "0.000000 | \n", "
23 | \n", "httpstcosbnvddws | \n", "0.000000 | \n", "0.000000 | \n", "
24 | \n", "make a team with your favourite players amp wi... | \n", "0.250000 | \n", "0.400000 | \n", "
25 | \n", "trainer test basu sir do you want a cheese poc... | \n", "0.000000 | \n", "0.000000 | \n", "
26 | \n", "we are thrilled to announce the launch of the ... | \n", "0.516667 | \n", "0.425000 | \n", "
27 | \n", "important win great character shown by the boy... | \n", "0.537500 | \n", "0.500000 | \n", "
28 | \n", "happy mothers day httpstcooxtbkkweie | \n", "1.000000 | \n", "0.800000 | \n", "
29 | \n", "httpstcoianoolxx | \n", "0.000000 | \n", "0.000000 | \n", "
30 | \n", "we got a challenge ahead of us httpstcojamdmyycei | \n", "0.000000 | \n", "0.000000 | \n", "
31 | \n", "its a long road to the top but the greatest le... | \n", "0.437778 | \n", "0.258889 | \n", "
32 | \n", "the competition is all in your head in reality... | \n", "0.000000 | \n", "0.000000 | \n", "
33 | \n", "are you ready to fuel your passion and take yo... | \n", "0.357143 | \n", "0.138095 | \n", "
34 | \n", "everyday is a chance to be better httpstcovsmq... | \n", "0.550000 | \n", "0.150000 | \n", "
35 | \n", "httpstcoidsnxgu | \n", "0.000000 | \n", "0.000000 | \n", "
36 | \n", "indias safest gaming platform pe no fraud no c... | \n", "0.500000 | \n", "-0.500000 | \n", "
37 | \n", "out and about in delhi httpstcodrhifnntq | \n", "0.000000 | \n", "0.000000 | \n", "
38 | \n", "httpstcoqsadhhzrj | \n", "0.000000 | \n", "0.000000 | \n", "
39 | \n", "addweighttoyourcv with management programs fro... | \n", "0.500000 | \n", "0.516667 | \n", "
40 | \n", "amazing win tonight love the massive support f... | \n", "0.630000 | \n", "0.430000 | \n", "
41 | \n", "love you through thick thin and all your cute ... | \n", "0.785000 | \n", "0.220000 | \n", "
42 | \n", "partner on the crease partner in cringy jokes ... | \n", "0.000000 | \n", "0.000000 | \n", "
43 | \n", "a bold new contest is now live take a screensh... | \n", "0.540404 | \n", "0.202020 | \n", "
44 | \n", "special win for a special cause httpstconcgrcxrdq | \n", "0.514286 | \n", "0.504762 | \n", "
45 | \n", "httpstcozowoyiehc | \n", "0.000000 | \n", "0.000000 | \n", "
46 | \n", "fixing your teeth is now as easypeasy as order... | \n", "0.000000 | \n", "0.000000 | \n", "
47 | \n", "brilliant spell by miyan and a solid win today... | \n", "0.500000 | \n", "0.566667 | \n", "
48 | \n", "hello mohali httpstcomzfcbpds | \n", "0.000000 | \n", "0.000000 | \n", "
49 | \n", "as puzzling as the furrowed brow click here fo... | \n", "0.500000 | \n", "0.500000 | \n", "
\n", " | Tweet | \n", "Subjectivity | \n", "Polarity | \n", "Score | \n", "Sentiments | \n", "
---|---|---|---|---|---|
0 | \n", "be at your best and the first to get my electr... | \n", "0.317576 | \n", "0.197273 | \n", "Positive | \n", "Positive | \n", "
1 | \n", "when in the tube httpstcopoezscpntm | \n", "0.000000 | \n", "0.000000 | \n", "Neutral | \n", "Neutral | \n", "
2 | \n", "ocean fruit water is my favourite hydration bo... | \n", "1.000000 | \n", "1.000000 | \n", "Positive | \n", "Positive | \n", "
3 | \n", "years in test cricket today forever grateful h... | \n", "0.000000 | \n", "0.000000 | \n", "Neutral | \n", "Neutral | \n", "
4 | \n", "its time to be better with batwrap im proud to... | \n", "0.533333 | \n", "0.433333 | \n", "Positive | \n", "Positive | \n", "
5 | \n", "look for excuses or look to get better httpstc... | \n", "0.500000 | \n", "0.500000 | \n", "Positive | \n", "Positive | \n", "
6 | \n", "congratulations amp on sealing citys seventh f... | \n", "0.450000 | \n", "-0.200000 | \n", "Negative | \n", "Negative | \n", "
7 | \n", "my records my awards my wins amp losses wipemy... | \n", "0.200000 | \n", "0.300000 | \n", "Positive | \n", "Positive | \n", "
8 | \n", "saddened to hear about the tragic train accide... | \n", "0.750000 | \n", "-0.750000 | \n", "Negative | \n", "Negative | \n", "
9 | \n", "unlock the unexpected wrogn treasures with the... | \n", "1.000000 | \n", "0.100000 | \n", "Positive | \n", "Positive | \n", "
10 | \n", "prep httpstcouyculkogj | \n", "0.000000 | \n", "0.000000 | \n", "Neutral | \n", "Neutral | \n", "
11 | \n", "rt hey cricket fans put your cricketing wisdom... | \n", "0.400000 | \n", "0.800000 | \n", "Positive | \n", "Positive | \n", "
12 | \n", "this bat is an extension of me on the field it... | \n", "0.750000 | \n", "0.800000 | \n", "Positive | \n", "Positive | \n", "
13 | \n", "all day everyday x httpstcoobashm | \n", "0.600000 | \n", "-0.200000 | \n", "Negative | \n", "Negative | \n", "
14 | \n", "after many challenges amp tests in these past ... | \n", "0.437500 | \n", "0.162500 | \n", "Positive | \n", "Positive | \n", "
15 | \n", "httpstcopgcgoi | \n", "0.000000 | \n", "0.000000 | \n", "Neutral | \n", "Neutral | \n", "
16 | \n", "the whites httpstcoddysdxyt | \n", "0.000000 | \n", "0.000000 | \n", "Neutral | \n", "Neutral | \n", "
17 | \n", "the sustainable edition of our energy drink ma... | \n", "0.300000 | \n", "0.200000 | \n", "Positive | \n", "Positive | \n", "
18 | \n", "lighting up the pitch with cop the allnew puma... | \n", "0.000000 | \n", "0.000000 | \n", "Neutral | \n", "Neutral | \n", "
19 | \n", "forever pushing to be faster in my foreverrun ... | \n", "0.000000 | \n", "0.000000 | \n", "Neutral | \n", "Neutral | \n", "
20 | \n", "a season which had its moments but unfortunate... | \n", "0.683333 | \n", "-0.416667 | \n", "Negative | \n", "Negative | \n", "
21 | \n", "unleash the madness the wrogn throwaway festiv... | \n", "0.000000 | \n", "0.000000 | \n", "Neutral | \n", "Neutral | \n", "
22 | \n", "job well done in hyderabad httpstcopjhkvupnc | \n", "0.000000 | \n", "0.000000 | \n", "Neutral | \n", "Neutral | \n", "
23 | \n", "httpstcosbnvddws | \n", "0.000000 | \n", "0.000000 | \n", "Neutral | \n", "Neutral | \n", "
24 | \n", "make a team with your favourite players amp wi... | \n", "0.250000 | \n", "0.400000 | \n", "Positive | \n", "Positive | \n", "
25 | \n", "trainer test basu sir do you want a cheese poc... | \n", "0.000000 | \n", "0.000000 | \n", "Neutral | \n", "Neutral | \n", "
26 | \n", "we are thrilled to announce the launch of the ... | \n", "0.516667 | \n", "0.425000 | \n", "Positive | \n", "Positive | \n", "
27 | \n", "important win great character shown by the boy... | \n", "0.537500 | \n", "0.500000 | \n", "Positive | \n", "Positive | \n", "
28 | \n", "happy mothers day httpstcooxtbkkweie | \n", "1.000000 | \n", "0.800000 | \n", "Positive | \n", "Positive | \n", "
29 | \n", "httpstcoianoolxx | \n", "0.000000 | \n", "0.000000 | \n", "Neutral | \n", "Neutral | \n", "
30 | \n", "we got a challenge ahead of us httpstcojamdmyycei | \n", "0.000000 | \n", "0.000000 | \n", "Neutral | \n", "Neutral | \n", "
31 | \n", "its a long road to the top but the greatest le... | \n", "0.437778 | \n", "0.258889 | \n", "Positive | \n", "Positive | \n", "
32 | \n", "the competition is all in your head in reality... | \n", "0.000000 | \n", "0.000000 | \n", "Neutral | \n", "Neutral | \n", "
33 | \n", "are you ready to fuel your passion and take yo... | \n", "0.357143 | \n", "0.138095 | \n", "Positive | \n", "Positive | \n", "
34 | \n", "everyday is a chance to be better httpstcovsmq... | \n", "0.550000 | \n", "0.150000 | \n", "Positive | \n", "Positive | \n", "
35 | \n", "httpstcoidsnxgu | \n", "0.000000 | \n", "0.000000 | \n", "Neutral | \n", "Neutral | \n", "
36 | \n", "indias safest gaming platform pe no fraud no c... | \n", "0.500000 | \n", "-0.500000 | \n", "Negative | \n", "Negative | \n", "
37 | \n", "out and about in delhi httpstcodrhifnntq | \n", "0.000000 | \n", "0.000000 | \n", "Neutral | \n", "Neutral | \n", "
38 | \n", "httpstcoqsadhhzrj | \n", "0.000000 | \n", "0.000000 | \n", "Neutral | \n", "Neutral | \n", "
39 | \n", "addweighttoyourcv with management programs fro... | \n", "0.500000 | \n", "0.516667 | \n", "Positive | \n", "Positive | \n", "
40 | \n", "amazing win tonight love the massive support f... | \n", "0.630000 | \n", "0.430000 | \n", "Positive | \n", "Positive | \n", "
41 | \n", "love you through thick thin and all your cute ... | \n", "0.785000 | \n", "0.220000 | \n", "Positive | \n", "Positive | \n", "
42 | \n", "partner on the crease partner in cringy jokes ... | \n", "0.000000 | \n", "0.000000 | \n", "Neutral | \n", "Neutral | \n", "
43 | \n", "a bold new contest is now live take a screensh... | \n", "0.540404 | \n", "0.202020 | \n", "Positive | \n", "Positive | \n", "
44 | \n", "special win for a special cause httpstconcgrcxrdq | \n", "0.514286 | \n", "0.504762 | \n", "Positive | \n", "Positive | \n", "
45 | \n", "httpstcozowoyiehc | \n", "0.000000 | \n", "0.000000 | \n", "Neutral | \n", "Neutral | \n", "
46 | \n", "fixing your teeth is now as easypeasy as order... | \n", "0.000000 | \n", "0.000000 | \n", "Neutral | \n", "Neutral | \n", "
47 | \n", "brilliant spell by miyan and a solid win today... | \n", "0.500000 | \n", "0.566667 | \n", "Positive | \n", "Positive | \n", "
48 | \n", "hello mohali httpstcomzfcbpds | \n", "0.000000 | \n", "0.000000 | \n", "Neutral | \n", "Neutral | \n", "
49 | \n", "as puzzling as the furrowed brow click here fo... | \n", "0.500000 | \n", "0.500000 | \n", "Positive | \n", "Positive | \n", "