practical2,3(feature,ngram).ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"practical2,3(feature,ngram).ipynb","provenance":[],"collapsed_sections":[],"authorship_tag":"ABX9TyNAgvcZ3Fyu8iQEyAiIiesW"},"kernelspec":{"name":"python3","display_name":"Python 3"}},"cells":[{"cell_type":"code","metadata":{"id":"GdkQagBw2xQp","executionInfo":{"status":"ok","timestamp":1601483614283,"user_tz":-330,"elapsed":67128,"user":{"displayName":"Muskaan Balwani","photoUrl":"","userId":"03272924802870714003"}},"outputId":"9574bf48-dbdc-4a44-ef91-43e9c66f10d9","colab":{"base_uri":"https://localhost:8080/","height":34}},"source":["from google.colab import drive\n","drive.mount(\"/content/drive\")"],"execution_count":1,"outputs":[{"output_type":"stream","text":["Mounted at /content/drive\n"],"name":"stdout"}]},{"cell_type":"code","metadata":{"id":"M-a9_TEr3MSb","executionInfo":{"status":"ok","timestamp":1601483787968,"user_tz":-330,"elapsed":1514,"user":{"displayName":"Muskaan Balwani","photoUrl":"","userId":"03272924802870714003"}}},"source":["import pandas as pd\n","data = pd.read_csv(\"/content/drive/My Drive/instacomments.csv\",nrows=10)"],"execution_count":3,"outputs":[]},{"cell_type":"code","metadata":{"id":"3mJg1264317j","executionInfo":{"status":"ok","timestamp":1601483850250,"user_tz":-330,"elapsed":1254,"user":{"displayName":"Muskaan Balwani","photoUrl":"","userId":"03272924802870714003"}},"outputId":"350496cf-d68d-4591-d26f-d9f8198bd951","colab":{"base_uri":"https://localhost:8080/","height":202}},"source":["pd.set_option('max_colwidth',100)\n","data[\"comments\"]"],"execution_count":5,"outputs":[{"output_type":"execute_result","data":{"text/plain":["0                                                                        Can’t wait for season 2!!!\n","1                                                                                          Verified\n","2                                                 @harshita1210 Miss Sanyukta.. wat abt Sadda Haq??\n","3                                                                             Kab aayegi मिर्ज़ापुर\n","4                                                                                         Yayyy 🤗🤗🤗\n","5                                                                                        @divyenndu\n","6                                                                   I am Big Fan of Mirzapur Series\n","7    Aur kitna wait karaoge yrr tum log abhi bhabhi or raja ka Scene dekh ke kaam chalana padta hai\n","8                                                                                                 💞\n","9                                                                                               👌👌👌\n","Name: comments, dtype: object"]},"metadata":{"tags":[]},"execution_count":5}]},{"cell_type":"code","metadata":{"id":"i9iRYeex4Fs1","executionInfo":{"status":"ok","timestamp":1601483986626,"user_tz":-330,"elapsed":1346,"user":{"displayName":"Muskaan Balwani","photoUrl":"","userId":"03272924802870714003"}},"outputId":"544ebdc0-9bd4-46e5-cf38-eed83df3c6ff","colab":{"base_uri":"https://localhost:8080/","height":34}},"source":["#Convert the 'Review' Column to list for applying CountVectorizer \n","Comment_list = data['comments'].values.tolist()\n","len('Comment_list')"],"execution_count":6,"outputs":[{"output_type":"execute_result","data":{"text/plain":["12"]},"metadata":{"tags":[]},"execution_count":6}]},{"cell_type":"code","metadata":{"id":"AqeXyzhY4muI","executionInfo":{"status":"ok","timestamp":1601484038173,"user_tz":-330,"elapsed":1202,"user":{"displayName":"Muskaan Balwani","photoUrl":"","userId":"03272924802870714003"}},"outputId":"3e632ffa-44d0-4a21-9dfa-c70d75a60d58","colab":{"base_uri":"https://localhost:8080/","height":195}},"source":["#Number of Words\n","data['word_count'] = data['comments'].apply(lambda x: len(str(x).split(\" \")))\n","data[['comments','word_count']].head()"],"execution_count":7,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>comments</th>\n","      <th>word_count</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>Can’t wait for season 2!!!</td>\n","      <td>5</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Verified</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>@harshita1210 Miss Sanyukta.. wat abt Sadda Haq??</td>\n","      <td>7</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Kab aayegi मिर्ज़ापुर</td>\n","      <td>3</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>Yayyy 🤗🤗🤗</td>\n","      <td>2</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                                            comments  word_count\n","0                         Can’t wait for season 2!!!           5\n","1                                           Verified           1\n","2  @harshita1210 Miss Sanyukta.. wat abt Sadda Haq??           7\n","3                              Kab aayegi मिर्ज़ापुर           3\n","4                                          Yayyy 🤗🤗🤗           2"]},"metadata":{"tags":[]},"execution_count":7}]},{"cell_type":"code","metadata":{"id":"6DOLSmJ344DI","executionInfo":{"status":"ok","timestamp":1601484096881,"user_tz":-330,"elapsed":1363,"user":{"displayName":"Muskaan Balwani","photoUrl":"","userId":"03272924802870714003"}},"outputId":"60e69708-840d-4c1a-d231-501c52cc3283","colab":{"base_uri":"https://localhost:8080/","height":195}},"source":["#Number of characters\n","data['char_count'] = data['comments'].str.len() ## this also includes spaces\n","data[['comments','char_count']].head()"],"execution_count":9,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>comments</th>\n","      <th>char_count</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>Can’t wait for season 2!!!</td>\n","      <td>26</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Verified</td>\n","      <td>8</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>@harshita1210 Miss Sanyukta.. wat abt Sadda Haq??</td>\n","      <td>49</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Kab aayegi मिर्ज़ापुर</td>\n","      <td>21</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>Yayyy 🤗🤗🤗</td>\n","      <td>9</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                                            comments  char_count\n","0                         Can’t wait for season 2!!!          26\n","1                                           Verified           8\n","2  @harshita1210 Miss Sanyukta.. wat abt Sadda Haq??          49\n","3                              Kab aayegi मिर्ज़ापुर          21\n","4                                          Yayyy 🤗🤗🤗           9"]},"metadata":{"tags":[]},"execution_count":9}]},{"cell_type":"code","metadata":{"id":"Z87PcnCO5CEj","executionInfo":{"status":"ok","timestamp":1601484145514,"user_tz":-330,"elapsed":1582,"user":{"displayName":"Muskaan Balwani","photoUrl":"","userId":"03272924802870714003"}},"outputId":"c8dda145-f660-46b6-e6e8-34ae3d6976f0","colab":{"base_uri":"https://localhost:8080/","height":699}},"source":["#Average Word Length\n","#Number of characters(without space count)/Total number of words\n","def avg_word(sentence):\n","  words = sentence.split()\n","  print(words)\n","  print(len(words))\n","  print(sum(len(word) for word in words))\n","  return (sum(len(word) for word in words)/len(words))\n","\n","data['avg_word'] = data['comments'].apply(lambda x: avg_word(x))\n","data[['comments','avg_word']].head()"],"execution_count":10,"outputs":[{"output_type":"stream","text":["['Can’t', 'wait', 'for', 'season', '2!!!']\n","5\n","22\n","['Verified']\n","1\n","8\n","['@harshita1210', 'Miss', 'Sanyukta..', 'wat', 'abt', 'Sadda', 'Haq??']\n","7\n","43\n","['Kab', 'aayegi', 'मिर्ज़ापुर']\n","3\n","19\n","['Yayyy', '🤗🤗🤗']\n","2\n","8\n","['@divyenndu']\n","1\n","10\n","['I', 'am', 'Big', 'Fan', 'of', 'Mirzapur', 'Series']\n","7\n","25\n","['Aur', 'kitna', 'wait', 'karaoge', 'yrr', 'tum', 'log', 'abhi', 'bhabhi', 'or', 'raja', 'ka', 'Scene', 'dekh', 'ke', 'kaam', 'chalana', 'padta', 'hai']\n","19\n","76\n","['💞']\n","1\n","1\n","['👌👌👌']\n","1\n","3\n"],"name":"stdout"},{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>comments</th>\n","      <th>avg_word</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>Can’t wait for season 2!!!</td>\n","      <td>4.400000</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Verified</td>\n","      <td>8.000000</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>@harshita1210 Miss Sanyukta.. wat abt Sadda Haq??</td>\n","      <td>6.142857</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Kab aayegi मिर्ज़ापुर</td>\n","      <td>6.333333</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>Yayyy 🤗🤗🤗</td>\n","      <td>4.000000</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                                            comments  avg_word\n","0                         Can’t wait for season 2!!!  4.400000\n","1                                           Verified  8.000000\n","2  @harshita1210 Miss Sanyukta.. wat abt Sadda Haq??  6.142857\n","3                              Kab aayegi मिर्ज़ापुर  6.333333\n","4                                          Yayyy 🤗🤗🤗  4.000000"]},"metadata":{"tags":[]},"execution_count":10}]},{"cell_type":"code","metadata":{"id":"reqAvLgz5Z3s","executionInfo":{"status":"ok","timestamp":1601484263066,"user_tz":-330,"elapsed":2742,"user":{"displayName":"Muskaan Balwani","photoUrl":"","userId":"03272924802870714003"}},"outputId":"93b44f09-d75e-4cd2-9134-536b2b17fdb1","colab":{"base_uri":"https://localhost:8080/","height":229}},"source":["import nltk\n","nltk.download('stopwords')\n","from nltk.corpus import stopwords\n","stop = stopwords.words('english')\n","\n","data['stopwords'] = data['comments'].apply(lambda x: len([x for x in x.split() if x in stop]))\n","data[['comments','stopwords']].head()"],"execution_count":11,"outputs":[{"output_type":"stream","text":["[nltk_data] Downloading package stopwords to /root/nltk_data...\n","[nltk_data]   Unzipping corpora/stopwords.zip.\n"],"name":"stdout"},{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>comments</th>\n","      <th>stopwords</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>Can’t wait for season 2!!!</td>\n","      <td>1</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Verified</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>@harshita1210 Miss Sanyukta.. wat abt Sadda Haq??</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Kab aayegi मिर्ज़ापुर</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>Yayyy 🤗🤗🤗</td>\n","      <td>0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                                            comments  stopwords\n","0                         Can’t wait for season 2!!!          1\n","1                                           Verified          0\n","2  @harshita1210 Miss Sanyukta.. wat abt Sadda Haq??          0\n","3                              Kab aayegi मिर्ज़ापुर          0\n","4                                          Yayyy 🤗🤗🤗          0"]},"metadata":{"tags":[]},"execution_count":11}]},{"cell_type":"code","metadata":{"id":"IsUJmk8F53jm","executionInfo":{"status":"ok","timestamp":1601484365354,"user_tz":-330,"elapsed":1352,"user":{"displayName":"Muskaan Balwani","photoUrl":"","userId":"03272924802870714003"}},"outputId":"a4385a75-da07-433a-98b3-cf0268a34ba6","colab":{"base_uri":"https://localhost:8080/","height":195}},"source":["#Number of special characters\n","data['hastags'] = data['comments'].apply(lambda x: len([x for x in x.split() if x.startswith('#')]))\n","data[['comments','hastags']].head()"],"execution_count":14,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>comments</th>\n","      <th>hastags</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>Can’t wait for season 2!!!</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Verified</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>@harshita1210 Miss Sanyukta.. wat abt Sadda Haq??</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Kab aayegi मिर्ज़ापुर</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>Yayyy 🤗🤗🤗</td>\n","      <td>0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                                            comments  hastags\n","0                         Can’t wait for season 2!!!        0\n","1                                           Verified        0\n","2  @harshita1210 Miss Sanyukta.. wat abt Sadda Haq??        0\n","3                              Kab aayegi मिर्ज़ापुर        0\n","4                                          Yayyy 🤗🤗🤗        0"]},"metadata":{"tags":[]},"execution_count":14}]},{"cell_type":"code","metadata":{"id":"VpmOT0WI6DBn","executionInfo":{"status":"ok","timestamp":1601484419974,"user_tz":-330,"elapsed":1211,"user":{"displayName":"Muskaan Balwani","photoUrl":"","userId":"03272924802870714003"}},"outputId":"9639080b-c7c9-4bb2-aed6-e9a477e5446f","colab":{"base_uri":"https://localhost:8080/","height":195}},"source":["#Number of numerics\n","data['numerics'] = data['comments'].apply(lambda x: len([x for x in x.split() if x.isdigit()]))\n","data[['comments','numerics']].head()"],"execution_count":15,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>comments</th>\n","      <th>numerics</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>Can’t wait for season 2!!!</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Verified</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>@harshita1210 Miss Sanyukta.. wat abt Sadda Haq??</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Kab aayegi मिर्ज़ापुर</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>Yayyy 🤗🤗🤗</td>\n","      <td>0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                                            comments  numerics\n","0                         Can’t wait for season 2!!!         0\n","1                                           Verified         0\n","2  @harshita1210 Miss Sanyukta.. wat abt Sadda Haq??         0\n","3                              Kab aayegi मिर्ज़ापुर         0\n","4                                          Yayyy 🤗🤗🤗         0"]},"metadata":{"tags":[]},"execution_count":15}]},{"cell_type":"code","metadata":{"id":"nmSTMw256UdA","executionInfo":{"status":"ok","timestamp":1601484461065,"user_tz":-330,"elapsed":1714,"user":{"displayName":"Muskaan Balwani","photoUrl":"","userId":"03272924802870714003"}},"outputId":"0d8f7dbe-ab9a-46af-fc0f-5d3da83fc9e7","colab":{"base_uri":"https://localhost:8080/","height":195}},"source":["#Number of Uppercase words\n","data['upper'] = data['comments'].apply(lambda x: len([x for x in x.split() if x.isupper()]))\n","data[['comments','upper']].head()"],"execution_count":16,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>comments</th>\n","      <th>upper</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>Can’t wait for season 2!!!</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Verified</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>@harshita1210 Miss Sanyukta.. wat abt Sadda Haq??</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Kab aayegi मिर्ज़ापुर</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>Yayyy 🤗🤗🤗</td>\n","      <td>0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                                            comments  upper\n","0                         Can’t wait for season 2!!!      0\n","1                                           Verified      0\n","2  @harshita1210 Miss Sanyukta.. wat abt Sadda Haq??      0\n","3                              Kab aayegi मिर्ज़ापुर      0\n","4                                          Yayyy 🤗🤗🤗      0"]},"metadata":{"tags":[]},"execution_count":16}]},{"cell_type":"code","metadata":{"id":"x01fbzRA6n7D","executionInfo":{"status":"ok","timestamp":1601484581985,"user_tz":-330,"elapsed":2239,"user":{"displayName":"Muskaan Balwani","photoUrl":"","userId":"03272924802870714003"}},"outputId":"3819610e-3e06-4b96-c2a7-9ebb56f995fc","colab":{"base_uri":"https://localhost:8080/","height":1000}},"source":["pos_family = {\n","    'noun' : ['NN','NNS','NNP','NNPS'],\n","    'pron' : ['PRP','PRP$','WP','WP$'],\n","    'verb' : ['VB','VBD','VBG','VBN','VBP','VBZ'],\n","    'adj' :  ['JJ','JJR','JJS'],\n","    'adv' : ['RB','RBR','RBS','WRB']\n","}\n","\n","# function to check and get the part of speech tag count of a words in a given sentence\n","from textblob import TextBlob, Word, Blobber\n","import nltk\n","nltk.download('punkt')\n","nltk.download('averaged_perceptron_tagger')\n","def check_pos_tag(x, flag):\n","    cnt = 0\n","    try:\n","        wiki = TextBlob(x)\n","        for tup in wiki.tags:\n","            ppo = list(tup)[1]\n","            if ppo in pos_family[flag]:\n","                cnt += 1\n","                print(ppo, tup)\n","    except:\n","        pass\n","    return cnt\n","\n","data['noun_count'] = data['comments'].apply(lambda x: check_pos_tag(x, 'noun'))\n","data['verb_count'] = data['comments'].apply(lambda x: check_pos_tag(x, 'verb'))\n","data['adj_count'] = data['comments'].apply(lambda x: check_pos_tag(x, 'adj'))\n","data['adv_count'] = data['comments'].apply(lambda x: check_pos_tag(x, 'adv'))\n","data['pron_count'] = data['comments'].apply(lambda x: check_pos_tag(x, 'pron'))\n","data[['comments','noun_count','verb_count','adj_count', 'adv_count', 'pron_count' ]].head()"],"execution_count":17,"outputs":[{"output_type":"stream","text":["[nltk_data] Downloading package punkt to /root/nltk_data...\n","[nltk_data]   Unzipping tokenizers/punkt.zip.\n","[nltk_data] Downloading package averaged_perceptron_tagger to\n","[nltk_data]     /root/nltk_data...\n","[nltk_data]   Unzipping taggers/averaged_perceptron_tagger.zip.\n","NN ('wait', 'NN')\n","NN ('season', 'NN')\n","NN ('harshita1210', 'NN')\n","NNP ('Miss', 'NNP')\n","NNP ('Sanyukta..', 'NNP')\n","NNP ('Sadda', 'NNP')\n","NNP ('Haq', 'NNP')\n","NNP ('Kab', 'NNP')\n","NN ('aayegi', 'NN')\n","NN ('मिर्ज़ापुर', 'NN')\n","NNP ('Yayyy', 'NNP')\n","NN ('🤗🤗🤗', 'NN')\n","NN ('@', 'NN')\n","NN ('divyenndu', 'NN')\n","NN ('Fan', 'NN')\n","NNP ('Mirzapur', 'NNP')\n","NNP ('Series', 'NNP')\n","NNP ('Aur', 'NNP')\n","NNP ('kitna', 'NNP')\n","NN ('wait', 'NN')\n","NN ('karaoge', 'NN')\n","NN ('yrr', 'NN')\n","NN ('tum', 'NN')\n","NN ('log', 'NN')\n","NN ('bhabhi', 'NN')\n","NN ('raja', 'NN')\n","NNS ('ka', 'NNS')\n","NNP ('Scene', 'NNP')\n","NN ('ke', 'NN')\n","NN ('kaam', 'NN')\n","NN ('chalana', 'NN')\n","NN ('padta', 'NN')\n","NN ('hai', 'NN')\n","NN ('💞', 'NN')\n","NN ('👌👌👌', 'NN')\n","VB ('’', 'VB')\n","VBN ('Verified', 'VBN')\n","VBD ('wat', 'VBD')\n","VBP ('am', 'VBP')\n","VBP ('dekh', 'VBP')\n","JJ ('t', 'JJ')\n","JJ ('@', 'JJ')\n","JJ ('abt', 'JJ')\n","JJ ('Big', 'JJ')\n","JJ ('abhi', 'JJ')\n","PRP ('I', 'PRP')\n"],"name":"stdout"},{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>comments</th>\n","      <th>noun_count</th>\n","      <th>verb_count</th>\n","      <th>adj_count</th>\n","      <th>adv_count</th>\n","      <th>pron_count</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>Can’t wait for season 2!!!</td>\n","      <td>2</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Verified</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>@harshita1210 Miss Sanyukta.. wat abt Sadda Haq??</td>\n","      <td>5</td>\n","      <td>1</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Kab aayegi मिर्ज़ापुर</td>\n","      <td>3</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>Yayyy 🤗🤗🤗</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                                            comments  ...  pron_count\n","0                         Can’t wait for season 2!!!  ...           0\n","1                                           Verified  ...           0\n","2  @harshita1210 Miss Sanyukta.. wat abt Sadda Haq??  ...           0\n","3                              Kab aayegi मिर्ज़ापुर  ...           0\n","4                                          Yayyy 🤗🤗🤗  ...           0\n","\n","[5 rows x 6 columns]"]},"metadata":{"tags":[]},"execution_count":17}]},{"cell_type":"code","metadata":{"id":"8DY6I8Uy644F","executionInfo":{"status":"ok","timestamp":1601484637595,"user_tz":-330,"elapsed":1711,"user":{"displayName":"Muskaan Balwani","photoUrl":"","userId":"03272924802870714003"}},"outputId":"14c724b0-0161-4446-a199-dcc78983c56c","colab":{"base_uri":"https://localhost:8080/","height":212}},"source":["data.head()"],"execution_count":18,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>user name</th>\n","      <th>comments</th>\n","      <th>word_count</th>\n","      <th>char_count</th>\n","      <th>avg_word</th>\n","      <th>stopwords</th>\n","      <th>hastags</th>\n","      <th>numerics</th>\n","      <th>upper</th>\n","      <th>noun_count</th>\n","      <th>verb_count</th>\n","      <th>adj_count</th>\n","      <th>adv_count</th>\n","      <th>pron_count</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>madhura_makeupnhair</td>\n","      <td>Can’t wait for season 2!!!</td>\n","      <td>5</td>\n","      <td>26</td>\n","      <td>4.400000</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>2</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>battatawada\\nVerified</td>\n","      <td>Verified</td>\n","      <td>1</td>\n","      <td>8</td>\n","      <td>8.000000</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>abby_racer20</td>\n","      <td>@harshita1210 Miss Sanyukta.. wat abt Sadda Haq??</td>\n","      <td>7</td>\n","      <td>49</td>\n","      <td>6.142857</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>5</td>\n","      <td>1</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>mirahul03</td>\n","      <td>Kab aayegi मिर्ज़ापुर</td>\n","      <td>3</td>\n","      <td>21</td>\n","      <td>6.333333</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>3</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>harshitasinha122</td>\n","      <td>Yayyy 🤗🤗🤗</td>\n","      <td>2</td>\n","      <td>9</td>\n","      <td>4.000000</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["               user name  ... pron_count\n","0    madhura_makeupnhair  ...          0\n","1  battatawada\\nVerified  ...          0\n","2           abby_racer20  ...          0\n","3              mirahul03  ...          0\n","4       harshitasinha122  ...          0\n","\n","[5 rows x 14 columns]"]},"metadata":{"tags":[]},"execution_count":18}]},{"cell_type":"code","metadata":{"id":"rOQ8TKi27FvX","executionInfo":{"status":"ok","timestamp":1601484730071,"user_tz":-330,"elapsed":1348,"user":{"displayName":"Muskaan Balwani","photoUrl":"","userId":"03272924802870714003"}},"outputId":"c4424be1-e6ef-438f-c3a2-a86eebd39db0","colab":{"base_uri":"https://localhost:8080/","height":185}},"source":["from sklearn.feature_extraction.text import CountVectorizer\n","from sklearn.feature_extraction.text import TfidfVectorizer\n","\n","cv=CountVectorizer(ngram_range = (2,2), stop_words='english')\n","Comment_list_vec = cv.fit_transform(Comment_list)\n","print(Comment_list_vec.toarray())"],"execution_count":20,"outputs":[{"output_type":"stream","text":["[[0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0]\n"," [0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0]\n"," [0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 1 1 0 0 0 0 1 0]\n"," [0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0]\n"," [0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0]\n"," [0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0]\n"," [0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0]\n"," [1 0 1 1 0 1 1 0 0 1 1 0 1 1 1 1 0 0 1 1 0 0 1 1 1 0 0 1]\n"," [0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0]\n"," [0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0]]\n"],"name":"stdout"}]},{"cell_type":"code","metadata":{"id":"oEiIhK067b_8","executionInfo":{"status":"ok","timestamp":1601484771636,"user_tz":-330,"elapsed":1287,"user":{"displayName":"Muskaan Balwani","photoUrl":"","userId":"03272924802870714003"}},"outputId":"42f0ba69-7466-42eb-9a1e-11117866ec1d","colab":{"base_uri":"https://localhost:8080/","height":857}},"source":["# ngram range= (2,2) means only select bigrams, if we wnat both list of unigrams and bigrams we can write ngram_range=(1,2),\n","# token_pattern - can be changed to only use non-digit words\n","tv=TfidfVectorizer(ngram_range = (2,2), stop_words='english',token_pattern= r'\\w+\\w')\n","t_vec = tv.fit_transform(Comment_list)\n","print(t_vec.toarray())"],"execution_count":21,"outputs":[{"output_type":"stream","text":["[[0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.         0.         0.\n","  0.         1.         0.         0.        ]\n"," [0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.        ]\n"," [0.         0.40824829 0.         0.         0.         0.\n","  0.         0.         0.40824829 0.         0.         0.\n","  0.         0.         0.         0.         0.         0.40824829\n","  0.         0.         0.40824829 0.40824829 0.         0.\n","  0.         0.         0.40824829 0.        ]\n"," [0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.         0.         1.\n","  0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.        ]\n"," [0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.        ]\n"," [0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.        ]\n"," [0.         0.         0.         0.         0.57735027 0.\n","  0.         0.57735027 0.         0.         0.         0.\n","  0.         0.         0.         0.         0.57735027 0.\n","  0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.        ]\n"," [0.24253563 0.         0.24253563 0.24253563 0.         0.24253563\n","  0.24253563 0.         0.         0.24253563 0.24253563 0.\n","  0.24253563 0.24253563 0.24253563 0.24253563 0.         0.\n","  0.24253563 0.24253563 0.         0.         0.24253563 0.24253563\n","  0.24253563 0.         0.         0.24253563]\n"," [0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.        ]\n"," [0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.         0.         0.\n","  0.         0.         0.         0.        ]]\n"],"name":"stdout"}]},{"cell_type":"code","metadata":{"id":"1xzEMb_S7ne4","executionInfo":{"status":"ok","timestamp":1601484865579,"user_tz":-330,"elapsed":1669,"user":{"displayName":"Muskaan Balwani","photoUrl":"","userId":"03272924802870714003"}},"outputId":"3d46c19a-001f-4367-93d6-c0a98fb91b35","colab":{"base_uri":"https://localhost:8080/","height":504}},"source":["feature_names = tv.get_feature_names()\n","\n","dense = t_vec.todense()\n","denselist = dense.tolist()\n","df = pd.DataFrame(denselist, columns=feature_names)\n","print(len(feature_names))\n","feature_names"],"execution_count":22,"outputs":[{"output_type":"stream","text":["28\n"],"name":"stdout"},{"output_type":"execute_result","data":{"text/plain":["['abhi bhabhi',\n"," 'abt sadda',\n"," 'aur kitna',\n"," 'bhabhi raja',\n"," 'big fan',\n"," 'chalana padta',\n"," 'dekh ke',\n"," 'fan mirzapur',\n"," 'harshita1210 miss',\n"," 'ka scene',\n"," 'kaam chalana',\n"," 'kab aayegi',\n"," 'karaoge yrr',\n"," 'ke kaam',\n"," 'kitna wait',\n"," 'log abhi',\n"," 'mirzapur series',\n"," 'miss sanyukta',\n"," 'padta hai',\n"," 'raja ka',\n"," 'sadda haq',\n"," 'sanyukta wat',\n"," 'scene dekh',\n"," 'tum log',\n"," 'wait karaoge',\n"," 'wait season',\n"," 'wat abt',\n"," 'yrr tum']"]},"metadata":{"tags":[]},"execution_count":22}]},{"cell_type":"code","metadata":{"id":"ALbx_lRn7-Xn","executionInfo":{"status":"ok","timestamp":1601484902196,"user_tz":-330,"elapsed":1766,"user":{"displayName":"Muskaan Balwani","photoUrl":"","userId":"03272924802870714003"}},"outputId":"645ca4f1-b249-45e9-b852-42569e959fe9","colab":{"base_uri":"https://localhost:8080/","height":350}},"source":["df_c =pd.concat([df,data], axis=1)\n","df_c.head()"],"execution_count":23,"outputs":[{"output_type":"execute_result","data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>abhi bhabhi</th>\n","      <th>abt sadda</th>\n","      <th>aur kitna</th>\n","      <th>bhabhi raja</th>\n","      <th>big fan</th>\n","      <th>chalana padta</th>\n","      <th>dekh ke</th>\n","      <th>fan mirzapur</th>\n","      <th>harshita1210 miss</th>\n","      <th>ka scene</th>\n","      <th>kaam chalana</th>\n","      <th>kab aayegi</th>\n","      <th>karaoge yrr</th>\n","      <th>ke kaam</th>\n","      <th>kitna wait</th>\n","      <th>log abhi</th>\n","      <th>mirzapur series</th>\n","      <th>miss sanyukta</th>\n","      <th>padta hai</th>\n","      <th>raja ka</th>\n","      <th>sadda haq</th>\n","      <th>sanyukta wat</th>\n","      <th>scene dekh</th>\n","      <th>tum log</th>\n","      <th>wait karaoge</th>\n","      <th>wait season</th>\n","      <th>wat abt</th>\n","      <th>yrr tum</th>\n","      <th>user name</th>\n","      <th>comments</th>\n","      <th>word_count</th>\n","      <th>char_count</th>\n","      <th>avg_word</th>\n","      <th>stopwords</th>\n","      <th>hastags</th>\n","      <th>numerics</th>\n","      <th>upper</th>\n","      <th>noun_count</th>\n","      <th>verb_count</th>\n","      <th>adj_count</th>\n","      <th>adv_count</th>\n","      <th>pron_count</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>1.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>madhura_makeupnhair</td>\n","      <td>Can’t wait for season 2!!!</td>\n","      <td>5</td>\n","      <td>26</td>\n","      <td>4.400000</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>2</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>battatawada\\nVerified</td>\n","      <td>Verified</td>\n","      <td>1</td>\n","      <td>8</td>\n","      <td>8.000000</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>0.0</td>\n","      <td>0.408248</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.408248</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.408248</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.408248</td>\n","      <td>0.408248</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.408248</td>\n","      <td>0.0</td>\n","      <td>abby_racer20</td>\n","      <td>@harshita1210 Miss Sanyukta.. wat abt Sadda Haq??</td>\n","      <td>7</td>\n","      <td>49</td>\n","      <td>6.142857</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>5</td>\n","      <td>1</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>1.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>mirahul03</td>\n","      <td>Kab aayegi मिर्ज़ापुर</td>\n","      <td>3</td>\n","      <td>21</td>\n","      <td>6.333333</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>3</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.0</td>\n","      <td>0.000000</td>\n","      <td>0.0</td>\n","      <td>harshitasinha122</td>\n","      <td>Yayyy 🤗🤗🤗</td>\n","      <td>2</td>\n","      <td>9</td>\n","      <td>4.000000</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>2</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["   abhi bhabhi  abt sadda  aur kitna  ...  adj_count  adv_count  pron_count\n","0          0.0   0.000000        0.0  ...          1          0           0\n","1          0.0   0.000000        0.0  ...          0          0           0\n","2          0.0   0.408248        0.0  ...          2          0           0\n","3          0.0   0.000000        0.0  ...          0          0           0\n","4          0.0   0.000000        0.0  ...          0          0           0\n","\n","[5 rows x 42 columns]"]},"metadata":{"tags":[]},"execution_count":23}]}]}