{ "nbformat": 4, "nbformat_minor": 0, "metadata": { "colab": { "name": "Employee.ipynb", "provenance": [], "collapsed_sections": [] }, "kernelspec": { "name": "python3", "display_name": "Python 3" } }, "cells": [ { "cell_type": "code", "metadata": { "id": "pCNyopPPqhYl" }, "source": [ "" ], "execution_count": null, "outputs": [] }, { "cell_type": "code", "metadata": { "id": "sohdybpH-qIe" }, "source": [ "" ], "execution_count": null, "outputs": [] }, { "cell_type": "code", "metadata": { "id": "qMycr31tBgRE" }, "source": [ "import pandas as pd\n", "import matplotlib.pyplot as plt\n", "import numpy as np\n", "import seaborn as sns" ], "execution_count": null, "outputs": [] }, { "cell_type": "markdown", "metadata": { "id": "KnLIYhusGRWO" }, "source": [ "**Mounting Google Drive**\n" ] }, { "cell_type": "code", "metadata": { "id": "nKqyCo9_xCEC", "colab": { "base_uri": "https://localhost:8080/" }, "outputId": "a1c050e1-306f-426a-b30d-44aaa3953979" }, "source": [ "from google.colab import drive\n", "drive.mount('/content/drive')\n" ], "execution_count": null, "outputs": [ { "output_type": "stream", "text": [ "Drive already mounted at /content/drive; to attempt to forcibly remount, call drive.mount(\"/content/drive\", force_remount=True).\n" ], "name": "stdout" } ] }, { "cell_type": "code", "metadata": { "id": "C-K07Bx8jHwK" }, "source": [ "dataF = pd.read_csv('/content/drive/MyDrive/sentiments - sentiments.csv')\n" ], "execution_count": null, "outputs": [] }, { "cell_type": "code", "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 341 }, "id": "A6pLuAnHjQNG", "outputId": "ed13af40-9af3-4fdd-fc32-8f64c7340a80" }, "source": [ "dataF[:2]" ], "execution_count": null, "outputs": [ { "output_type": "execute_result", "data": { "text/html": [ "
\n", " | Unnamed: 0 | \n", "Unnamed: 0.1 | \n", "company | \n", "location | \n", "dates | \n", "job-title | \n", "summary | \n", "pros | \n", "cons | \n", "advice-to-mgmt | \n", "overall-ratings | \n", "work-balance-stars | \n", "culture-values-stars | \n", "carrer-opportunities-stars | \n", "comp-benefit-stars | \n", "senior-mangemnet-stars | \n", "helpful-count | \n", "link | \n", "text | \n", "cleanText | \n", "Polarity Score | \n", "sentiment | \n", "sentiments | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "0 | \n", "35 | \n", "Dearborn, MI | \n", "Nov 20, 2018 | \n", "Current Employee - Google Specialist | \n", "Google is one of the beast Company in the world | \n", "You have to work hard | \n", "none | \n", "5 | \n", "3 | \n", "4 | \n", "4 | \n", "5 | \n", "4 | \n", "1 | \n", "https://www.glassdoor.com/Reviews/Google-Revie... | \n", "Google Google is one of the beast Company in t... | \n", "google google one beast company world work har... | \n", "-0.291667 | \n", "-1 | \n", "-1 | \n", "||
1 | \n", "1 | \n", "68 | \n", "none | \n", "Nov 19, 2018 | \n", "Former Employee - Anonymous Employee | \n", "Engineer | \n", "salary was fine but in line with other companies | \n", "work was boring. I disliked it. | \n", "none | \n", "3 | \n", "3 | \n", "3 | \n", "2 | \n", "3 | \n", "2 | \n", "0 | \n", "https://www.glassdoor.com/Reviews/Google-Revie... | \n", "Engineer salary was fine but in line with othe... | \n", "engineer salary fine line companies work borin... | \n", "-0.261111 | \n", "-1 | \n", "-1 | \n", "