{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "c2ed359a", "metadata": {}, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 2, "id": "2d441603", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
| \n", " | textID | \n", "text | \n", "selected_text | \n", "sentiment | \n", "Time of Tweet | \n", "Age of User | \n", "Country | \n", "Population -2020 | \n", "Land Area (Km²) | \n", "Density (P/Km²) | \n", "
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "cb774db0d1 | \n", "I`d have responded, if I were going | \n", "I`d have responded, if I were going | \n", "neutral | \n", "morning | \n", "0-20 | \n", "Afghanistan | \n", "38928346 | \n", "652860.0 | \n", "60 | \n", "
| 1 | \n", "549e992a42 | \n", "Sooo SAD I will miss you here in San Diego!!! | \n", "Sooo SAD | \n", "negative | \n", "noon | \n", "21-30 | \n", "Albania | \n", "2877797 | \n", "27400.0 | \n", "105 | \n", "
| 2 | \n", "088c60f138 | \n", "my boss is bullying me... | \n", "bullying me | \n", "negative | \n", "night | \n", "31-45 | \n", "Algeria | \n", "43851044 | \n", "2381740.0 | \n", "18 | \n", "
| 3 | \n", "9642c003ef | \n", "what interview! leave me alone | \n", "leave me alone | \n", "negative | \n", "morning | \n", "46-60 | \n", "Andorra | \n", "77265 | \n", "470.0 | \n", "164 | \n", "
| 4 | \n", "358bd9e861 | \n", "Sons of ****, why couldn`t they put them on t... | \n", "Sons of ****, | \n", "negative | \n", "noon | \n", "60-70 | \n", "Angola | \n", "32866272 | \n", "1246700.0 | \n", "26 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 27476 | \n", "4eac33d1c0 | \n", "wish we could come see u on Denver husband l... | \n", "d lost | \n", "negative | \n", "night | \n", "31-45 | \n", "Ghana | \n", "31072940 | \n", "227540.0 | \n", "137 | \n", "
| 27477 | \n", "4f4c4fc327 | \n", "I`ve wondered about rake to. The client has ... | \n", ", don`t force | \n", "negative | \n", "morning | \n", "46-60 | \n", "Greece | \n", "10423054 | \n", "128900.0 | \n", "81 | \n", "
| 27478 | \n", "f67aae2310 | \n", "Yay good for both of you. Enjoy the break - y... | \n", "Yay good for both of you. | \n", "positive | \n", "noon | \n", "60-70 | \n", "Grenada | \n", "112523 | \n", "340.0 | \n", "331 | \n", "
| 27479 | \n", "ed167662a5 | \n", "But it was worth it ****. | \n", "But it was worth it ****. | \n", "positive | \n", "night | \n", "70-100 | \n", "Guatemala | \n", "17915568 | \n", "107160.0 | \n", "167 | \n", "
| 27480 | \n", "6f7127d9d7 | \n", "All this flirting going on - The ATG smiles... | \n", "All this flirting going on - The ATG smiles. Y... | \n", "neutral | \n", "morning | \n", "0-20 | \n", "Guinea | \n", "13132795 | \n", "246000.0 | \n", "53 | \n", "
27481 rows × 10 columns
\n", "| \n", " | text | \n", "sentiment | \n", "
|---|---|---|
| 0 | \n", "I`d have responded, if I were going | \n", "neutral | \n", "
| 1 | \n", "Sooo SAD I will miss you here in San Diego!!! | \n", "negative | \n", "
| 2 | \n", "my boss is bullying me... | \n", "negative | \n", "
| 3 | \n", "what interview! leave me alone | \n", "negative | \n", "
| 4 | \n", "Sons of ****, why couldn`t they put them on t... | \n", "negative | \n", "
| ... | \n", "... | \n", "... | \n", "
| 27476 | \n", "wish we could come see u on Denver husband l... | \n", "negative | \n", "
| 27477 | \n", "I`ve wondered about rake to. The client has ... | \n", "negative | \n", "
| 27478 | \n", "Yay good for both of you. Enjoy the break - y... | \n", "positive | \n", "
| 27479 | \n", "But it was worth it ****. | \n", "positive | \n", "
| 27480 | \n", "All this flirting going on - The ATG smiles... | \n", "neutral | \n", "
27481 rows × 2 columns
\n", "| \n", " | text | \n", "sentiment | \n", "label | \n", "
|---|---|---|---|
| 0 | \n", "I`d have responded, if I were going | \n", "neutral | \n", "0 | \n", "
| 1 | \n", "Sooo SAD I will miss you here in San Diego!!! | \n", "negative | \n", "1 | \n", "
| 2 | \n", "my boss is bullying me... | \n", "negative | \n", "1 | \n", "
| 3 | \n", "what interview! leave me alone | \n", "negative | \n", "1 | \n", "
| 4 | \n", "Sons of ****, why couldn`t they put them on t... | \n", "negative | \n", "1 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "
| 27476 | \n", "wish we could come see u on Denver husband l... | \n", "negative | \n", "1 | \n", "
| 27477 | \n", "I`ve wondered about rake to. The client has ... | \n", "negative | \n", "1 | \n", "
| 27478 | \n", "Yay good for both of you. Enjoy the break - y... | \n", "positive | \n", "2 | \n", "
| 27479 | \n", "But it was worth it ****. | \n", "positive | \n", "2 | \n", "
| 27480 | \n", "All this flirting going on - The ATG smiles... | \n", "neutral | \n", "0 | \n", "
27481 rows × 3 columns
\n", "| \n", " | text | \n", "sentiment | \n", "label | \n", "data_type | \n", "
|---|---|---|---|---|
| 0 | \n", "I`d have responded, if I were going | \n", "neutral | \n", "0 | \n", "train | \n", "
| 1 | \n", "Sooo SAD I will miss you here in San Diego!!! | \n", "negative | \n", "1 | \n", "train | \n", "
| 2 | \n", "my boss is bullying me... | \n", "negative | \n", "1 | \n", "train | \n", "
| 3 | \n", "what interview! leave me alone | \n", "negative | \n", "1 | \n", "train | \n", "
| 4 | \n", "Sons of ****, why couldn`t they put them on t... | \n", "negative | \n", "1 | \n", "val | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 27476 | \n", "wish we could come see u on Denver husband l... | \n", "negative | \n", "1 | \n", "train | \n", "
| 27477 | \n", "I`ve wondered about rake to. The client has ... | \n", "negative | \n", "1 | \n", "train | \n", "
| 27478 | \n", "Yay good for both of you. Enjoy the break - y... | \n", "positive | \n", "2 | \n", "val | \n", "
| 27479 | \n", "But it was worth it ****. | \n", "positive | \n", "2 | \n", "val | \n", "
| 27480 | \n", "All this flirting going on - The ATG smiles... | \n", "neutral | \n", "0 | \n", "val | \n", "
27481 rows × 4 columns
\n", "