{ "nbformat": 4, "nbformat_minor": 0, "metadata": { "colab": { "provenance": [], "collapsed_sections": [ "Ul9bNs9IfW7Q", "1b082evNHgMZ", "yZsAr5-6EGnR" ], "gpuType": "T4" }, "kernelspec": { "name": "python3", "display_name": "Python 3" }, "language_info": { "name": "python" }, "widgets": { "application/vnd.jupyter.widget-state+json": { "version_major": 2, "version_minor": 0, "state": { "8e01c34adb6b49fe852e321399673573": { "model_module": "@jupyter-widgets/controls", "model_name": "HBoxModel", "model_module_version": "1.5.0", "state": { "_dom_classes": [], "_model_module": "@jupyter-widgets/controls", "_model_module_version": "1.5.0", "_model_name": "HBoxModel", "_view_count": null, "_view_module": "@jupyter-widgets/controls", "_view_module_version": "1.5.0", "_view_name": "HBoxView", "box_style": "", "children": [ "IPY_MODEL_e4a328f2bd1345e5ad9a569ce6c41b65", "IPY_MODEL_06fc985110784eb9a12003bcb090d70f", "IPY_MODEL_f35f5c948f614fdda757b6fe3f25b31c" ], "layout": "IPY_MODEL_f8c9d0affed04fffa2ce4d9525914ebd" } }, "e4a328f2bd1345e5ad9a569ce6c41b65": { "model_module": "@jupyter-widgets/controls", "model_name": "HTMLModel", "model_module_version": "1.5.0", "state": { "_dom_classes": [], "_model_module": "@jupyter-widgets/controls", "_model_module_version": "1.5.0", "_model_name": "HTMLModel", "_view_count": null, "_view_module": "@jupyter-widgets/controls", "_view_module_version": "1.5.0", "_view_name": "HTMLView", "description": "", "description_tooltip": null, "layout": "IPY_MODEL_da422f93033241e892d28a04cb26e234", "placeholder": "", "style": "IPY_MODEL_bd5f4e7b81924a3bb46a05334c4c8887", "value": "100%" } }, "06fc985110784eb9a12003bcb090d70f": { "model_module": "@jupyter-widgets/controls", "model_name": "FloatProgressModel", "model_module_version": "1.5.0", "state": { "_dom_classes": [], "_model_module": "@jupyter-widgets/controls", "_model_module_version": "1.5.0", "_model_name": "FloatProgressModel", "_view_count": null, "_view_module": "@jupyter-widgets/controls", "_view_module_version": "1.5.0", "_view_name": "ProgressView", "bar_style": "success", "description": "", "description_tooltip": null, "layout": "IPY_MODEL_fd41c73ea5294e83893fcad39db03610", "max": 3647, "min": 0, "orientation": "horizontal", "style": "IPY_MODEL_32aaf59a96c84141951875a0197e7e8e", "value": 3647 } }, "f35f5c948f614fdda757b6fe3f25b31c": { "model_module": "@jupyter-widgets/controls", "model_name": "HTMLModel", "model_module_version": "1.5.0", "state": { "_dom_classes": [], "_model_module": "@jupyter-widgets/controls", "_model_module_version": "1.5.0", "_model_name": "HTMLModel", "_view_count": null, "_view_module": "@jupyter-widgets/controls", "_view_module_version": "1.5.0", "_view_name": "HTMLView", "description": "", "description_tooltip": null, "layout": "IPY_MODEL_e14207405a41464382e9ed675fd3d087", "placeholder": "", "style": "IPY_MODEL_a97c7ef357214d7abf9fbb1e7cbbb8c3", "value": " 3647/3647 [03:00<00:00, 22.81it/s]" } }, "f8c9d0affed04fffa2ce4d9525914ebd": { "model_module": "@jupyter-widgets/base", "model_name": "LayoutModel", "model_module_version": "1.2.0", "state": { "_model_module": "@jupyter-widgets/base", "_model_module_version": "1.2.0", "_model_name": "LayoutModel", "_view_count": null, "_view_module": "@jupyter-widgets/base", "_view_module_version": "1.2.0", "_view_name": "LayoutView", "align_content": null, "align_items": null, "align_self": null, "border": null, "bottom": null, "display": null, "flex": null, "flex_flow": null, "grid_area": null, "grid_auto_columns": null, "grid_auto_flow": null, "grid_auto_rows": null, "grid_column": null, "grid_gap": null, "grid_row": null, "grid_template_areas": null, "grid_template_columns": null, "grid_template_rows": null, "height": null, "justify_content": null, "justify_items": null, "left": null, "margin": null, "max_height": null, "max_width": null, "min_height": null, "min_width": null, "object_fit": null, "object_position": null, "order": null, "overflow": null, "overflow_x": null, "overflow_y": null, "padding": null, "right": null, "top": null, "visibility": null, "width": null } }, "da422f93033241e892d28a04cb26e234": { "model_module": "@jupyter-widgets/base", "model_name": "LayoutModel", "model_module_version": "1.2.0", "state": { "_model_module": "@jupyter-widgets/base", "_model_module_version": "1.2.0", "_model_name": "LayoutModel", "_view_count": null, "_view_module": "@jupyter-widgets/base", "_view_module_version": "1.2.0", "_view_name": "LayoutView", "align_content": null, "align_items": null, "align_self": null, "border": null, "bottom": null, "display": null, "flex": null, "flex_flow": null, "grid_area": null, "grid_auto_columns": null, "grid_auto_flow": null, "grid_auto_rows": null, "grid_column": null, "grid_gap": null, "grid_row": null, "grid_template_areas": null, "grid_template_columns": null, "grid_template_rows": null, "height": null, "justify_content": null, "justify_items": null, "left": null, "margin": null, "max_height": null, "max_width": null, "min_height": null, "min_width": null, "object_fit": null, "object_position": null, "order": null, "overflow": null, "overflow_x": null, "overflow_y": null, "padding": null, "right": null, "top": null, "visibility": null, "width": null } }, "bd5f4e7b81924a3bb46a05334c4c8887": { "model_module": "@jupyter-widgets/controls", "model_name": "DescriptionStyleModel", "model_module_version": "1.5.0", "state": { "_model_module": "@jupyter-widgets/controls", "_model_module_version": "1.5.0", "_model_name": "DescriptionStyleModel", "_view_count": null, "_view_module": "@jupyter-widgets/base", "_view_module_version": "1.2.0", "_view_name": "StyleView", "description_width": "" } }, "fd41c73ea5294e83893fcad39db03610": { "model_module": "@jupyter-widgets/base", "model_name": "LayoutModel", "model_module_version": "1.2.0", "state": { "_model_module": "@jupyter-widgets/base", "_model_module_version": "1.2.0", "_model_name": "LayoutModel", "_view_count": null, "_view_module": "@jupyter-widgets/base", "_view_module_version": "1.2.0", "_view_name": "LayoutView", "align_content": null, "align_items": null, "align_self": null, "border": null, "bottom": null, "display": null, "flex": null, "flex_flow": null, "grid_area": null, "grid_auto_columns": null, "grid_auto_flow": null, "grid_auto_rows": null, "grid_column": null, "grid_gap": null, "grid_row": null, "grid_template_areas": null, "grid_template_columns": null, "grid_template_rows": null, "height": null, "justify_content": null, "justify_items": null, "left": null, "margin": null, "max_height": null, "max_width": null, "min_height": null, "min_width": null, "object_fit": null, "object_position": null, "order": null, "overflow": null, "overflow_x": null, "overflow_y": null, "padding": null, "right": null, "top": null, "visibility": null, "width": null } }, "32aaf59a96c84141951875a0197e7e8e": { "model_module": "@jupyter-widgets/controls", "model_name": "ProgressStyleModel", "model_module_version": "1.5.0", "state": { "_model_module": "@jupyter-widgets/controls", "_model_module_version": "1.5.0", "_model_name": "ProgressStyleModel", "_view_count": null, "_view_module": "@jupyter-widgets/base", "_view_module_version": "1.2.0", "_view_name": "StyleView", "bar_color": null, "description_width": "" } }, "e14207405a41464382e9ed675fd3d087": { "model_module": "@jupyter-widgets/base", "model_name": "LayoutModel", "model_module_version": "1.2.0", "state": { "_model_module": "@jupyter-widgets/base", "_model_module_version": "1.2.0", "_model_name": "LayoutModel", "_view_count": null, "_view_module": "@jupyter-widgets/base", "_view_module_version": "1.2.0", "_view_name": "LayoutView", "align_content": null, "align_items": null, "align_self": null, "border": null, "bottom": null, "display": null, "flex": null, "flex_flow": null, "grid_area": null, "grid_auto_columns": null, "grid_auto_flow": null, "grid_auto_rows": null, "grid_column": null, "grid_gap": null, "grid_row": null, "grid_template_areas": null, "grid_template_columns": null, "grid_template_rows": null, "height": null, "justify_content": null, "justify_items": null, "left": null, "margin": null, "max_height": null, "max_width": null, "min_height": null, "min_width": null, "object_fit": null, "object_position": null, "order": null, "overflow": null, "overflow_x": null, "overflow_y": null, "padding": null, "right": null, "top": null, "visibility": null, "width": null } }, "a97c7ef357214d7abf9fbb1e7cbbb8c3": { "model_module": "@jupyter-widgets/controls", "model_name": "DescriptionStyleModel", "model_module_version": "1.5.0", "state": { "_model_module": "@jupyter-widgets/controls", "_model_module_version": "1.5.0", "_model_name": "DescriptionStyleModel", "_view_count": null, "_view_module": "@jupyter-widgets/base", "_view_module_version": "1.2.0", "_view_name": "StyleView", "description_width": "" } } } } }, "accelerator": "GPU" }, "cells": [ { "cell_type": "markdown", "source": [ "# 1. **Tweets** on **climate change** **2019**" ], "metadata": { "id": "uBv44o7vTH3w" } }, { "cell_type": "code", "source": [ "import pandas as pd\n", "import numpy as np\n", "import re\n", "from tqdm.auto import tqdm" ], "metadata": { "id": "opJzNPqUOv0E" }, "execution_count": 1, "outputs": [] }, { "cell_type": "code", "source": [ "# load data\n", "df = pd.read_excel(\"/content/tweets_greta_translated.xlsx\")\n", "df.drop_duplicates(subset=[\"text\"],inplace=True)\n", "df.reset_index(drop=True, inplace=True)\n", "df" ], "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 791 }, "id": "9DtwIh6sOz8V", "outputId": "7c0018d9-9fa1-4f9c-e19a-68ca57aab162" }, "execution_count": 2, "outputs": [ { "output_type": "execute_result", "data": { "text/plain": [ " tweet_id created_at \\\n", "0 1107179362430836736 2019-03-17 07:18:25 \n", "1 1109128620729982977 2019-03-22 16:24:04 \n", "2 1113715238224965633 2019-04-04 08:09:39 \n", "3 1119376821668261890 2019-04-19 23:06:45 \n", "4 1119376819856257025 2019-04-19 23:06:45 \n", "... ... ... \n", "3642 1116926914738802688 2019-04-13 04:51:42 \n", "3643 1112062606561427460 2019-03-30 18:42:41 \n", "3644 1112062629722423297 2019-03-30 18:42:46 \n", "3645 1112062645421641728 2019-03-30 18:42:50 \n", "3646 1107954972094808065 2019-03-19 10:40:24 \n", "\n", " text \\\n", "0 오늘은 심한 사람이 있음에도 켐트레일을 뿌리네! 요점은 #기후변화 가 아니라, #기... \n", "1 පුත්තලම උණුසුම් කළ උද්ඝෝෂණය \\nPuttalam tensed... \n", "2 Zoljargal, is 1 of the few female entrepreneur... \n", "3 Zero Foodprint says: Missionstfood is taking o... \n", "4 Zero Foodprint says: MikkellerBarSF is taking ... \n", "... ... \n", "3642 -SAC, Ahmedabad & ICAR- CMFRI, Kochi sign ... \n", "3643 -hotter temperatures in the world\\n-Rare Hurri... \n", "3644 -Heavy unusual flooding in California,USA, -Pa... \n", "3645 -CycloneIdai wreaks havoc in Mozambique,Madaga... \n", "3646 - and #ClimateChange 🤦🏾♀️🤦🏾♀️🤦🏾♀️ https://t... \n", "\n", " translated anger anticipation \\\n", "0 Today, even though there are severe people, th... 0.6113 0.1662 \n", "1 The protest that heated up Puttalam \\nPuttala... 0.7901 0.0514 \n", "2 Zoljargal, is 1 of the few female entrepreneur... 0.0051 0.2452 \n", "3 Zero Foodprint says: Missionstfood is taking o... 0.0097 0.2002 \n", "4 Zero Foodprint says: MikkellerBarSF is taking ... 0.0089 0.2342 \n", "... ... ... ... \n", "3642 -SAC, Ahmedabad & ICAR- CMFRI, Kochi sign ... 0.0047 0.4811 \n", "3643 -hotter temperatures in the world\\n-Rare Hurri... 0.2144 0.0391 \n", "3644 -Heavy unusual flooding in California,USA, -Pa... 0.0226 0.1482 \n", "3645 -CycloneIdai wreaks havoc in Mozambique,Madaga... 0.4462 0.0306 \n", "3646 - and #ClimateChange 🤦🏾♀️🤦🏾♀️🤦🏾♀️ https://t... 0.8796 0.0648 \n", "\n", " disgust fear joy love optimism pessimism sadness surprise \\\n", "0 0.7243 0.0597 0.0072 0.0014 0.0841 0.0282 0.0352 0.0190 \n", "1 0.4561 0.2133 0.0076 0.0024 0.0128 0.0118 0.2687 0.0075 \n", "2 0.0128 0.2678 0.6775 0.0388 0.9876 0.0181 0.0543 0.0372 \n", "3 0.0117 0.0049 0.9841 0.0956 0.9671 0.0031 0.0058 0.0197 \n", "4 0.0121 0.0050 0.9825 0.0925 0.9633 0.0031 0.0064 0.0200 \n", "... ... ... ... ... ... ... ... ... \n", "3642 0.0174 0.1527 0.1790 0.0071 0.8608 0.0158 0.0575 0.0211 \n", "3643 0.2355 0.9942 0.0095 0.0060 0.0078 0.1769 0.7117 0.0447 \n", "3644 0.0337 0.6617 0.2806 0.0084 0.0469 0.0307 0.3385 0.2909 \n", "3645 0.5352 0.9606 0.0079 0.0025 0.0034 0.1244 0.7937 0.0346 \n", "3646 0.8653 0.4491 0.0249 0.0012 0.0060 0.0579 0.5032 0.0675 \n", "\n", " trust \n", "0 0.0070 \n", "1 0.0031 \n", "2 0.2542 \n", "3 0.0813 \n", "4 0.0830 \n", "... ... \n", "3642 0.0564 \n", "3643 0.0080 \n", "3644 0.0117 \n", "3645 0.0040 \n", "3646 0.0025 \n", "\n", "[3647 rows x 15 columns]" ], "text/html": [ "\n", "
| \n", " | tweet_id | \n", "created_at | \n", "text | \n", "translated | \n", "anger | \n", "anticipation | \n", "disgust | \n", "fear | \n", "joy | \n", "love | \n", "optimism | \n", "pessimism | \n", "sadness | \n", "surprise | \n", "trust | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1107179362430836736 | \n", "2019-03-17 07:18:25 | \n", "오늘은 심한 사람이 있음에도 켐트레일을 뿌리네! 요점은 #기후변화 가 아니라, #기... | \n", "Today, even though there are severe people, th... | \n", "0.6113 | \n", "0.1662 | \n", "0.7243 | \n", "0.0597 | \n", "0.0072 | \n", "0.0014 | \n", "0.0841 | \n", "0.0282 | \n", "0.0352 | \n", "0.0190 | \n", "0.0070 | \n", "
| 1 | \n", "1109128620729982977 | \n", "2019-03-22 16:24:04 | \n", "පුත්තලම උණුසුම් කළ උද්ඝෝෂණය \\nPuttalam tensed... | \n", "The protest that heated up Puttalam \\nPuttala... | \n", "0.7901 | \n", "0.0514 | \n", "0.4561 | \n", "0.2133 | \n", "0.0076 | \n", "0.0024 | \n", "0.0128 | \n", "0.0118 | \n", "0.2687 | \n", "0.0075 | \n", "0.0031 | \n", "
| 2 | \n", "1113715238224965633 | \n", "2019-04-04 08:09:39 | \n", "Zoljargal, is 1 of the few female entrepreneur... | \n", "Zoljargal, is 1 of the few female entrepreneur... | \n", "0.0051 | \n", "0.2452 | \n", "0.0128 | \n", "0.2678 | \n", "0.6775 | \n", "0.0388 | \n", "0.9876 | \n", "0.0181 | \n", "0.0543 | \n", "0.0372 | \n", "0.2542 | \n", "
| 3 | \n", "1119376821668261890 | \n", "2019-04-19 23:06:45 | \n", "Zero Foodprint says: Missionstfood is taking o... | \n", "Zero Foodprint says: Missionstfood is taking o... | \n", "0.0097 | \n", "0.2002 | \n", "0.0117 | \n", "0.0049 | \n", "0.9841 | \n", "0.0956 | \n", "0.9671 | \n", "0.0031 | \n", "0.0058 | \n", "0.0197 | \n", "0.0813 | \n", "
| 4 | \n", "1119376819856257025 | \n", "2019-04-19 23:06:45 | \n", "Zero Foodprint says: MikkellerBarSF is taking ... | \n", "Zero Foodprint says: MikkellerBarSF is taking ... | \n", "0.0089 | \n", "0.2342 | \n", "0.0121 | \n", "0.0050 | \n", "0.9825 | \n", "0.0925 | \n", "0.9633 | \n", "0.0031 | \n", "0.0064 | \n", "0.0200 | \n", "0.0830 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 3642 | \n", "1116926914738802688 | \n", "2019-04-13 04:51:42 | \n", "-SAC, Ahmedabad & ICAR- CMFRI, Kochi sign ... | \n", "-SAC, Ahmedabad & ICAR- CMFRI, Kochi sign ... | \n", "0.0047 | \n", "0.4811 | \n", "0.0174 | \n", "0.1527 | \n", "0.1790 | \n", "0.0071 | \n", "0.8608 | \n", "0.0158 | \n", "0.0575 | \n", "0.0211 | \n", "0.0564 | \n", "
| 3643 | \n", "1112062606561427460 | \n", "2019-03-30 18:42:41 | \n", "-hotter temperatures in the world\\n-Rare Hurri... | \n", "-hotter temperatures in the world\\n-Rare Hurri... | \n", "0.2144 | \n", "0.0391 | \n", "0.2355 | \n", "0.9942 | \n", "0.0095 | \n", "0.0060 | \n", "0.0078 | \n", "0.1769 | \n", "0.7117 | \n", "0.0447 | \n", "0.0080 | \n", "
| 3644 | \n", "1112062629722423297 | \n", "2019-03-30 18:42:46 | \n", "-Heavy unusual flooding in California,USA, -Pa... | \n", "-Heavy unusual flooding in California,USA, -Pa... | \n", "0.0226 | \n", "0.1482 | \n", "0.0337 | \n", "0.6617 | \n", "0.2806 | \n", "0.0084 | \n", "0.0469 | \n", "0.0307 | \n", "0.3385 | \n", "0.2909 | \n", "0.0117 | \n", "
| 3645 | \n", "1112062645421641728 | \n", "2019-03-30 18:42:50 | \n", "-CycloneIdai wreaks havoc in Mozambique,Madaga... | \n", "-CycloneIdai wreaks havoc in Mozambique,Madaga... | \n", "0.4462 | \n", "0.0306 | \n", "0.5352 | \n", "0.9606 | \n", "0.0079 | \n", "0.0025 | \n", "0.0034 | \n", "0.1244 | \n", "0.7937 | \n", "0.0346 | \n", "0.0040 | \n", "
| 3646 | \n", "1107954972094808065 | \n", "2019-03-19 10:40:24 | \n", "- and #ClimateChange 🤦🏾♀️🤦🏾♀️🤦🏾♀️ https://t... | \n", "- and #ClimateChange 🤦🏾♀️🤦🏾♀️🤦🏾♀️ https://t... | \n", "0.8796 | \n", "0.0648 | \n", "0.8653 | \n", "0.4491 | \n", "0.0249 | \n", "0.0012 | \n", "0.0060 | \n", "0.0579 | \n", "0.5032 | \n", "0.0675 | \n", "0.0025 | \n", "
3647 rows × 15 columns
\n", "| \n", " | tweet_id | \n", "created_at | \n", "text | \n", "translated | \n", "anger | \n", "anticipation | \n", "disgust | \n", "fear | \n", "joy | \n", "love | \n", "optimism | \n", "pessimism | \n", "sadness | \n", "surprise | \n", "trust | \n", "clean text | \n", "clean list | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1107179362430836736 | \n", "2019-03-17 07:18:25 | \n", "오늘은 심한 사람이 있음에도 켐트레일을 뿌리네! 요점은 #기후변화 가 아니라, #기... | \n", "Today, even though there are severe people, th... | \n", "0.6113 | \n", "0.1662 | \n", "0.7243 | \n", "0.0597 | \n", "0.0072 | \n", "0.0014 | \n", "0.0841 | \n", "0.0282 | \n", "0.0352 | \n", "0.0190 | \n", "0.0070 | \n", "Todayeven there are severe peoplethey spraying... | \n", "[today, even, there, be, severe, people, they,... | \n", "
| 1 | \n", "1109128620729982977 | \n", "2019-03-22 16:24:04 | \n", "පුත්තලම උණුසුම් කළ උද්ඝෝෂණය \\nPuttalam tensed... | \n", "The protest that heated up Puttalam \\nPuttala... | \n", "0.7901 | \n", "0.0514 | \n", "0.4561 | \n", "0.2133 | \n", "0.0076 | \n", "0.0024 | \n", "0.0128 | \n", "0.0118 | \n", "0.2687 | \n", "0.0075 | \n", "0.0031 | \n", "protest that heated Puttalam Puttalam tensed p... | \n", "[protest, that, heat, puttalam, puttalam, tens... | \n", "
| 2 | \n", "1113715238224965633 | \n", "2019-04-04 08:09:39 | \n", "Zoljargal, is 1 of the few female entrepreneur... | \n", "Zoljargal, is 1 of the few female entrepreneur... | \n", "0.0051 | \n", "0.2452 | \n", "0.0128 | \n", "0.2678 | \n", "0.6775 | \n", "0.0388 | \n", "0.9876 | \n", "0.0181 | \n", "0.0543 | \n", "0.0372 | \n", "0.2542 | \n", "Zoljargalfew female entrepreneurs her region M... | \n", "[zoljargal, few, female, entrepreneur, her, re... | \n", "
| 3 | \n", "1119376821668261890 | \n", "2019-04-19 23:06:45 | \n", "Zero Foodprint says: Missionstfood is taking o... | \n", "Zero Foodprint says: Missionstfood is taking o... | \n", "0.0097 | \n", "0.2002 | \n", "0.0117 | \n", "0.0049 | \n", "0.9841 | \n", "0.0956 | \n", "0.9671 | \n", "0.0031 | \n", "0.0058 | \n", "0.0197 | \n", "0.0813 | \n", "Zero Foodprint saysMissionstfood taking #clima... | \n", "[zero, foodprint, say, missionstfood, take, #c... | \n", "
| 4 | \n", "1119376819856257025 | \n", "2019-04-19 23:06:45 | \n", "Zero Foodprint says: MikkellerBarSF is taking ... | \n", "Zero Foodprint says: MikkellerBarSF is taking ... | \n", "0.0089 | \n", "0.2342 | \n", "0.0121 | \n", "0.0050 | \n", "0.9825 | \n", "0.0925 | \n", "0.9633 | \n", "0.0031 | \n", "0.0064 | \n", "0.0200 | \n", "0.0830 | \n", "Zero Foodprint saysMikkellerBarSF taking #clim... | \n", "[zero, foodprint, say, mikkellerbarsf, take, #... | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 3642 | \n", "1116926914738802688 | \n", "2019-04-13 04:51:42 | \n", "-SAC, Ahmedabad & ICAR- CMFRI, Kochi sign ... | \n", "-SAC, Ahmedabad & ICAR- CMFRI, Kochi sign ... | \n", "0.0047 | \n", "0.4811 | \n", "0.0174 | \n", "0.1527 | \n", "0.1790 | \n", "0.0071 | \n", "0.8608 | \n", "0.0158 | \n", "0.0575 | \n", "0.0211 | \n", "0.0564 | \n", "Ahmedabad ampCMFRIKochi sign MoU mapvalidatepr... | \n", "[ahmedabad, amp, cmfri, kochi, sign, mou, map,... | \n", "
| 3643 | \n", "1112062606561427460 | \n", "2019-03-30 18:42:41 | \n", "-hotter temperatures in the world\\n-Rare Hurri... | \n", "-hotter temperatures in the world\\n-Rare Hurri... | \n", "0.2144 | \n", "0.0391 | \n", "0.2355 | \n", "0.9942 | \n", "0.0095 | \n", "0.0060 | \n", "0.0078 | \n", "0.1769 | \n", "0.7117 | \n", "0.0447 | \n", "0.0080 | \n", "-hotter temperatures world-Rare Hurricane wrea... | \n", "[-hott, temperature, world, -rare, hurricane, ... | \n", "
| 3644 | \n", "1112062629722423297 | \n", "2019-03-30 18:42:46 | \n", "-Heavy unusual flooding in California,USA, -Pa... | \n", "-Heavy unusual flooding in California,USA, -Pa... | \n", "0.0226 | \n", "0.1482 | \n", "0.0337 | \n", "0.6617 | \n", "0.2806 | \n", "0.0084 | \n", "0.0469 | \n", "0.0307 | \n", "0.3385 | \n", "0.2909 | \n", "0.0117 | \n", "-Heavy unusual flooding CaliforniaUSA-Paraguay... | \n", "[-heavy, unusual, flooding, california, usa, -... | \n", "
| 3645 | \n", "1112062645421641728 | \n", "2019-03-30 18:42:50 | \n", "-CycloneIdai wreaks havoc in Mozambique,Madaga... | \n", "-CycloneIdai wreaks havoc in Mozambique,Madaga... | \n", "0.4462 | \n", "0.0306 | \n", "0.5352 | \n", "0.9606 | \n", "0.0079 | \n", "0.0025 | \n", "0.0034 | \n", "0.1244 | \n", "0.7937 | \n", "0.0346 | \n", "0.0040 | \n", "-CycloneIdai wreaks havoc MozambiqueMadagascar... | \n", "[-cycloneidai, wreak, havoc, mozambique, madag... | \n", "
| 3646 | \n", "1107954972094808065 | \n", "2019-03-19 10:40:24 | \n", "- and #ClimateChange 🤦🏾♀️🤦🏾♀️🤦🏾♀️ https://t... | \n", "- and #ClimateChange 🤦🏾♀️🤦🏾♀️🤦🏾♀️ https://t... | \n", "0.8796 | \n", "0.0648 | \n", "0.8653 | \n", "0.4491 | \n", "0.0249 | \n", "0.0012 | \n", "0.0060 | \n", "0.0579 | \n", "0.5032 | \n", "0.0675 | \n", "0.0025 | \n", "#ClimateChange | \n", "[#climatechange] | \n", "
3647 rows × 17 columns
\n", "| \n", " | Source | \n", "Target | \n", "weight | \n", "
|---|---|---|---|
| 0 | \n", "0 | \n", "3576 | \n", "0.010493 | \n", "
| 1 | \n", "0 | \n", "3519 | \n", "0.013991 | \n", "
| 2 | \n", "0 | \n", "3418 | \n", "0.005246 | \n", "
| 3 | \n", "0 | \n", "3245 | \n", "0.004664 | \n", "
| 4 | \n", "0 | \n", "3159 | \n", "0.006995 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "
| 3006276 | \n", "3634 | \n", "571 | \n", "0.015100 | \n", "
| 3006277 | \n", "3634 | \n", "552 | \n", "0.017932 | \n", "
| 3006278 | \n", "3634 | \n", "542 | \n", "0.020493 | \n", "
| 3006279 | \n", "3634 | \n", "498 | \n", "0.040987 | \n", "
| 3006280 | \n", "3634 | \n", "393 | \n", "0.017932 | \n", "
3006281 rows × 3 columns
\n", "| \n", " | anger | \n", "anticipation | \n", "disgust | \n", "fear | \n", "joy | \n", "love | \n", "optimism | \n", "pessimism | \n", "sadness | \n", "surprise | \n", "trust | \n", "Id | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "0.6113 | \n", "0.1662 | \n", "0.7243 | \n", "0.0597 | \n", "0.0072 | \n", "0.0014 | \n", "0.0841 | \n", "0.0282 | \n", "0.0352 | \n", "0.0190 | \n", "0.0070 | \n", "0 | \n", "
| 1 | \n", "0.7901 | \n", "0.0514 | \n", "0.4561 | \n", "0.2133 | \n", "0.0076 | \n", "0.0024 | \n", "0.0128 | \n", "0.0118 | \n", "0.2687 | \n", "0.0075 | \n", "0.0031 | \n", "1 | \n", "
| 2 | \n", "0.0051 | \n", "0.2452 | \n", "0.0128 | \n", "0.2678 | \n", "0.6775 | \n", "0.0388 | \n", "0.9876 | \n", "0.0181 | \n", "0.0543 | \n", "0.0372 | \n", "0.2542 | \n", "2 | \n", "
| 3 | \n", "0.0097 | \n", "0.2002 | \n", "0.0117 | \n", "0.0049 | \n", "0.9841 | \n", "0.0956 | \n", "0.9671 | \n", "0.0031 | \n", "0.0058 | \n", "0.0197 | \n", "0.0813 | \n", "3 | \n", "
| 4 | \n", "0.0089 | \n", "0.2342 | \n", "0.0121 | \n", "0.0050 | \n", "0.9825 | \n", "0.0925 | \n", "0.9633 | \n", "0.0031 | \n", "0.0064 | \n", "0.0200 | \n", "0.0830 | \n", "4 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 3641 | \n", "0.3525 | \n", "0.0423 | \n", "0.2689 | \n", "0.9700 | \n", "0.0245 | \n", "0.0035 | \n", "0.0103 | \n", "0.1069 | \n", "0.6938 | \n", "0.0367 | \n", "0.0042 | \n", "3630 | \n", "
| 3642 | \n", "0.0047 | \n", "0.4811 | \n", "0.0174 | \n", "0.1527 | \n", "0.1790 | \n", "0.0071 | \n", "0.8608 | \n", "0.0158 | \n", "0.0575 | \n", "0.0211 | \n", "0.0564 | \n", "3631 | \n", "
| 3643 | \n", "0.2144 | \n", "0.0391 | \n", "0.2355 | \n", "0.9942 | \n", "0.0095 | \n", "0.0060 | \n", "0.0078 | \n", "0.1769 | \n", "0.7117 | \n", "0.0447 | \n", "0.0080 | \n", "3632 | \n", "
| 3644 | \n", "0.0226 | \n", "0.1482 | \n", "0.0337 | \n", "0.6617 | \n", "0.2806 | \n", "0.0084 | \n", "0.0469 | \n", "0.0307 | \n", "0.3385 | \n", "0.2909 | \n", "0.0117 | \n", "3633 | \n", "
| 3645 | \n", "0.4462 | \n", "0.0306 | \n", "0.5352 | \n", "0.9606 | \n", "0.0079 | \n", "0.0025 | \n", "0.0034 | \n", "0.1244 | \n", "0.7937 | \n", "0.0346 | \n", "0.0040 | \n", "3634 | \n", "
3635 rows × 12 columns
\n", "| \n", " | Source | \n", "Target | \n", "weight | \n", "
|---|---|---|---|
| 0 | \n", "0 | \n", "1601 | \n", "0.002051 | \n", "
| 1 | \n", "0 | \n", "1475 | \n", "0.002051 | \n", "
| 2 | \n", "0 | \n", "1444 | \n", "0.002051 | \n", "
| 3 | \n", "0 | \n", "1386 | \n", "0.002051 | \n", "
| 4 | \n", "0 | \n", "1190 | \n", "0.002051 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "
| 372135 | \n", "2097 | \n", "330 | \n", "0.005037 | \n", "
| 372136 | \n", "2097 | \n", "304 | \n", "0.006222 | \n", "
| 372137 | \n", "2097 | \n", "288 | \n", "0.006222 | \n", "
| 372138 | \n", "2097 | \n", "258 | \n", "0.006567 | \n", "
| 372139 | \n", "2097 | \n", "106 | \n", "0.006567 | \n", "
372140 rows × 3 columns
\n", "| \n", " | Id | \n", "Label | \n", "
|---|---|---|
| 0 | \n", "0 | \n", "#1o5c | \n", "
| 1 | \n", "1 | \n", "#2030agenda | \n", "
| 2 | \n", "2 | \n", "#4ir | \n", "
| 3 | \n", "3 | \n", "#abpoli | \n", "
| 4 | \n", "4 | \n", "#action | \n", "
| ... | \n", "... | \n", "... | \n", "
| 2093 | \n", "2093 | \n", "° | \n", "
| 2094 | \n", "2094 | \n", "’ | \n", "
| 2095 | \n", "2095 | \n", "’re | \n", "
| 2096 | \n", "2096 | \n", "’s | \n", "
| 2097 | \n", "2097 | \n", "#actonclimate | \n", "
2098 rows × 2 columns
\n", "