act_report.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Report: act_report"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## WeRateDogs\n",
    "\n",
    "![](dog-rates-social.jpg)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Introduction\n",
    "\n",
    "This project involved the wrangling, analyzing, and visualizing of datasets associated with the tweet archive of Twitter user [@dog_rates](https://twitter.com/dog_rates), also known as [WeRateDogs](https://en.wikipedia.org/wiki/WeRateDogs). From the documentation given, WeRateDogs is a Twitter account that rates people's dogs with a humorous comment about the dog. These ratings almost always have a denominator of 10 with over 4 million followers and ample international media coverage. The datasets used in this project was gathered from various sources, assessed, cleaned, and insights was drawn from them."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The insights gotten from the data assessed, gathered and cleaned were in three folds viz:"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "1. No relationship was found between ratings and likes or retweet counts which gives a strong cause for further investigation as one would have expected an agreement with the given rating resulting in likes."
   ]
  },
  {
   "attachments": {
    "image.png": {
     "image/png": "iVBORw0KGgoAAAANSUhEUgAAAQgAAABcCAIAAAAd/Lz9AAAWnUlEQVR4Ae1da1RTVxY+ECBiI1FeykPARlqB8rBda6YiVAqiC5GHlZaltlJEpC1UrYOmGmUx1kcdl1hHOlSrokWQ0bEDlQqtClZEBcSCYqUoUB4Jj4SHJEfAIGfW8qweMyHQtCTXpJ7zw7Xvvvvsvc+395d77o25AEQHRYAiMAwBMExDFRQBigBSJob40LbG1cEUGIrAM46AMjFatrxTE2D1jINCl08RUCYGrPih59sMigtF4BlHQJkYzzgcdPkUAYwAJQbtBIqACgSUiSHvbB9oqVdhSFUUgWcJAWVi0JvvZ6n6dK0jIkCJMSI09MSzjIAyMZ5lLOjaKQIEAUoMAgUVKAJPEKDEeIIFlSgCBAFKDAIFFSgCTxCgxHiCBZUoAgQBSgwCBRUoAk8QoMR4ggWVKAIEAUoMAgUVKAJPEKDEeIIFlSgCBAFKDALFWAWpVNrQ0CCTycbq6GnMl8vlDQ0NEokEIdTc3NzS0oIQ0usVjRFFSowxAohqa2tFIhFCKD09HQCQkaGXv2ZpaGgAAMTExCCEHB0deTyevq9ojHWlxBgTgENDQ05OTrt370YI9fb23r17VyqVjsnjU5qsSIxffvmlsbGREuMplULnw547dy4yMrKoqCgiIuLUqVMIoZMnT4aFhfn7+/P5/Pv37/f09ISGhgIAvLy8du7cefHixcjIyOLiYoRQXFxccnJyUVHRggULwsPDy8vL8XKvX7/+1ltvzZs375tvvtmwYcPf/vY3rE9PTw8NDfXz80tISGhubmYeG0ViJCQkrFmzRokYGRkZkZGRN27cQAi1trZ++OGHAQEBMTExdXV1ONtLly4tXbp0zpw5S5cuvXr1KvNL0GxEesUYEc/Dhw8DAKZPnx4YGPif//wnLy8PAPDmm2+mpKQYGhpGRUVJpdK3334bABAQEHDs2DHFrZSDg4O9vf3s2bNXrVrFYrHs7e0HBwd7enrMzMwmTZq0ffv2wMBADofj4eGBEMrOzgYAJCYmpqWl8Xi8GTNmDA0NjZiWdk4oEmP4Vio/P9/IyAjT+MGDBw4ODs7Ozl999VVAQIC1tbVUKm1sbGSz2aGhoQcPHpw3bx6bzW5oaNBOpgx5pcQYEWjc6LGxsdiisbGxqKhIIpE8fPjQ2dnZyckJIVRUVAQAwFspRWI4OjqamJjge9k33ngDANDU1JSZmQkA2LFjB0Koo6PD0NDQ09MTIZScnAwA2LVrV3Nzs0QiEYvFI+aktROjEGP9+vUTJkxYtmwZpmtWVhYAICUlRSwWX7x4EQBw5MgRLCxduvTWrVsymUwoFD569EhryTLhmBJjRJRxox8+fBhbVFVVvfrqq+PGjZs4cSKLxZo8efLoxJg2bRqeuGbNGgDAnTt3du/eDQA4efIk1ltZWWFiCIXCV155BTweLi4umZmZI+aktROjEAMnFhcXh4Nv374da8i/mzZtksvly5YtMzAwAABYW1sLBAJKDK3V6mk7VrwCIIT8/PxYLBa+K7Wzs/tNYuAHOwghQoxDhw4BAFJTUxFCEEJjY2NMDLzQ6urqL774wtPT08DAQCgUMrz6UYixYcOG2NhYAwMDfOdw4MABAMBXX301PMOWlpbs7OywsDAAwIkTJ4Yb6JGGXjFGLJYSMTw9PQ0NDa9evZqSkmJsbPzcc8/JZLKSkhJ84yESiRTtyTZdkRj19fUsFuuFF17Iz89ftWqVkZERJsa2bdt8fHzq6+shhHw+HwBQX8/0z+5HIUZGRoZYLJ40aZKHh4dcLq+rqzMxMXn99ddbW1tTU1O9vb0rKiry8vI8PDwKCwv7+vrOnDmD91cjIqsPJygxRqySYqMjhDIyMthsNgAgKCjo0KFDBgYGXl5eUqmUx+MBAHx8fBTtVRIDIXTw4EF7e3srK6tdu3ZNnjzZy8sLIVRTUzNz5ky8M+FyuXv27BkxJ62dGJ0YCKH9+/eTu6msrCwrKysAAJvNTkxMHBoakkqlb7zxBovFAgAYGRktX758YGBAa8ky4ZgS43eg3NfXR+6MIYRyuRwhNDg42NnZqY6XgYGBsrKyyspKspUKCQkhE+/fv9/W1qZHW/OOjo7+/n6SP0Kor69PKBTqOyXwiigxFCurXbm/v9/R0ZHL5SYmJgYEBAAAcnNztRuSev+jCFBi/FHk/tA8kUiUnJy8bNmyNWvWlJSU/CEfdBITCFBiMIEyjaF3CFBi6F3JaMJMIECJwQTKNIbeIUCJoXclowkzgQAlBhMo0xh6hwAlht6VjCbMBAIaIAb5z2RUoAiMjgATHa2hGBogBqSDIqAeAhpqWibcUGKoV1JqpQkEmOhoDcWgxNBEwakP9RDQUNMy4YYSQ72SUitNIMBER2soBiWGJgpOfaiHgIaalgk3lBjqlZRaaQIBJjpaQzEoMTRRcOpDPQQ01LRMuNEVYrS3t//0008dHR3qIUyt9BIBJjpaQzGeMjEuX76MyYB/Yn/48GGGC97S0hIXF3fkyBGVcc+dOxcSEjJr1qzExESJRIJtGFOqTElJ2dnZyefzvb29g4ODv/vuO6Wz+DA7O3vRokU9PT34cN++feH/PxobG8nEysrK8PDwn3/+mWiUpkMIr1+/vmTJEm9v7yVLlpSXl2PL7u7uzZs3e3t7h4eHFxcXk+mKgoaalgk3T5MYt2/fBgBgENvb22/evNne3q6Io7blCxcuuLi4eHp6rlu3bnisW7duTZo0KT09vbS0NCgoaMWKFRBCxpTD81GpiY6ODgoKunbt2tGjRydOnFhdXa1oJpVK33nnnTlz5gAAOjs78anr16/n/Dr27dtnY2MjFovxqd7e3r/+9a+mpqa43VVOb2trs7S0zMjIwO9/sLCwwFWLjY2dP3/+tWvXjhw5Ym5urrKUTHS0hmJoixh5eXkREREFBQWLFi06fvx4T0/P1q1b586dGxgYmJKSIpPJCgsL//KXv+DX+J08ebKgoCAiIuLcuXMQwpiYGIFAUFBQMH/+/JCQEPLxc/ny5cWLFwcEBJw6deqjjz5avXo1hLCjo0MgEMydO9ff3z8pKamrq0uxM0aXs7Kyampq4uLiVBKDz+dHR0djD7W1tePGjZNIJIwpR88cnxWLxWw2+969e/gwKirq448/VpzY3d29d+/epqYmRWIoGsybNy8jI4NokpOT33//fQcHB0wMldMvXbpkaWlJpnA4nCtXrohEIlNTU3LlaW5uJgaKgoaalgk32iJGWloaAIDH4/n7+2dmZuJ3K23atGnFihUAgAMHDpSVlc2ePRsAsHz58u+//15xKzV16lQ7O7tZs2atWLGCxWLZ2dn19va2trZOmDBh4sSJycnJ/v7+HA7npZdeghCuXLmSw+F8+umnO3fuZLPZ+HNdsRi/KY9EjAULFqSkpJDpFhYWV69eZUxJ4o4ilJSUWFhYEIOUlJSFCxeSQyKMRIysrCxfX19iVlpaOmPGDLFYTIiBTylNF4vFtra2X3/9tVQqzcnJsbW1lUgkZ8+edXV1LSwsjI+P37x5c11dHXGrKDDR0RqKoS1i4EYnn7hlZWVnz57t7e29c+cOAODtt9+GEG7atIlspRSJ4eDgYGJigj918Nu7fv75Z/xymr///e8QwsbGRkNDQ3d3dwihr68vh8PJzs5ubW29d++eyiu4Ym2GyyMRw8fH58svvyT2jo6OBQUFjClJ3FGE/Px8JycnYnDw4EHFRid6pc4mend39wsXLuDDnp4eLy+v8+fPQwhHJwaE8N///jeHw7Gzs+NwOFlZWRDCY8eOWVpaRkVFff3116tXr7axsWlrayOBiKChpmXCjXaJkZaWhkHJyMjg8XhsNpvL5QIAIiIiRicGqXd8fDwA4Mcff9yxYwf+6xPYoaWlJSbGd999h99xxGKxfH19L1++TMqgpjASMQICAvbu3UucmJubl5aWMqYkcUcRCgsLFXc1e/bsCQ0NHW6vkhh5eXmenp7EeMOGDWvXrsWHoxPjxo0b1tbWN2/ehBBWV1dbW1tfv3799OnT5ubmUqkUe/D09ExPTyfOicBER2sohnaJgZ8ydXV1sdnsl156qbOz8+bNm+oQ4/nnn8doEmL861//wu8ShhCKxWJjY2NMDAhhT0/P+fPnt27damFh4ezsTMqgpjASMeLi4vBtDIRQKBQaGxuLRCLGlOok39jYyGKxRCIRNk5ISCAJK05XSYyVK1cmJSURs/Hjxzs7O7s8HsbGxjweD18KIIRK0z/77LOAgAAy0d/f/7PPPisrK1Pc1AUGBqamphIbImioaZlwwwQxRCIRAMDZ2fnGjRuRkZHGxsZz5syRSqX4Ld+ffvqpUChU2koNJ8bt27dZLJazs3NOTs6KFSuMjIzc3d1lMllYWNjSpUuFj4evr+/UqVNJGdQUlIhR/HhACPPz8+3s7PANZVJS0oIFC5hUqpm8j4/P1q1bIYS//PKLjY1NSUkJhJAsATtR6mysfPHFF3Nzc0mUrq6uzl/H1KlTS0pKent7VU4/e/bs5MmT8U6pvb19ypQpBQUFEEJXV1d8laitreVyueQxLgkBIWSiozUUgwliQAhXrVqFX97I5/NjYmIAAAkJCcXFxc899xwAYMOGDb9JDAhhamqqnZ2dpaXltm3brK2tPTw8IIQnTpywsbHBv49xcnLKy8tTrMTosq+vr5mZmYmJCZvNNjMzwzfuMY8Hnrhx40Zzc/Pnn3/ezc2NPAllTDl68vhsVVWVi4sLj8czNzcnVwCyhNzcXDMzswkTJgAAzB6P27dv44kcDufatWsqQ5Ct1EjT+Xy+g4ODn5+fo6Mjn8/HTi5evDht2jQ3Nzdra+vdu3er9KyhpmXCjbaIMRyX1tZWcmfc1tYmk8kghJ2dnUQ5fIqipru7+9KlS7iWeCuFP8IhhDKZrKmpqaWlRdFeU7JYLG5oaFDyxphSKe5Ih/X19eT7x5FsNKvv7e2tr68nVxXsXCaTDVcqxmWiozUUgzliKAL0B+Suri4HBwczM7M1a9b4+fnhPzTxB/zQKU8RAQ01LRNu9IYYEMK6ujqBQBAZGRkfH0+eMz7FMtPQvxcBJjpaQzH0iRi/twzUXtcQ0FDTMuGGEkPXmufPnA8THa2hGJQYf+ZG1LW1aahpmXBDiaFrzfNnzoeJjtZQDEqMP3Mj6traNNS0TLihxNC15vkz58NER2sohgaIoaFMqBuKgA4hQImhQ8WgqegOApQYulMLmokOIUCJoUPFoKnoDgKUGLpTC5qJDiFAiaFDxaCp6A4ClBi6UwuaiQ4hQImhQ8WgqegOAk+fGFKptKGhQSaTyeXyhoYGiUSCEMK/BBocHNQdpGgmzxQCT58Y+L04GRkZDQ0NAICYmBiEUFRUFACgublZq8Xo6+vbvHmzj49PaGjoDz/8oDLWf//734iIiIcPH+KzaWlpi/9/dHR0kIk1NTWLFy9uamoiGqXpCKEzZ86EhYXNmTNn3bp1+FMAIdTa2rpy5crZs2fHxsa2tbWR6eoInZ2d8fHxx48fV2lcXFwcHh4+e/bsjRs3PnjwANuMUdnU1BQdHe3t7R0VFdXY2Ih9qlSqTEkvlDpEDLlcfvfuXdxnzBAjNjZ24cKFlZWVJ06cmDRpUl1dnWLNHj16FB0d7e/vDwDo6+vDp6qrq/N/HWlpaba2tuQ3/oODg7NmzTI1Nb116xZCSOX04uJiW1vbGzduSCSS1atXz58/HyE0ODjo7u6+cePGO3furF27du7cuYppjC6XlJS4ubnNnDmTz+cPt7x37565uXlmZmZVVdXChQtXrVqFEBqjUi6Xu7i4CASC6upqgUDg6uo6ODioUjk8Hz3S6BAxOjo6IiMjDxw4oHjFGBoa2rRp07vvvtvd3Y0QKisrW758+dy5cz/++GOZTIaBTk9PDw0N9fPzS0hIUP8iAyFks9lCoRA7iYmJ2bJli2LlBgYGPv/8c7FYrEgMRYOgoKCTJ08Szfbt2z/88ENHR0dMDJXT//GPf7z55pt4SkVFhZmZGUIoLy/Pw8MDKx8+fNjb20t8/qZw+vTpxsbG+Ph4lcTYvHlzbGwsdtLc3Dxu3LgHDx6MUXn+/HlnZ2eS2PTp0y9cuKBSSWz0UdAhYqjcSgkEAhaLlZOTgxCqrKw0MjIKDg4+evSoo6PjggULEELZ2dkAgMTExLS0NB6PN2PGjKGhIXUqUVFRYWlpSSxTU1PDwsLIIRFGIsbp06f9/PyIWVVVlaurK4SQEAOfUppeXl7u4OBw9+5duVwuEAgWLVqEENqyZUt8fHxWVlZCQsL+/fv7+/uJWzWFkYgREhKSmppKnFhaWv74449jVO7ZsyciIoL4jIiI2Lt3r0olsdFHQaeJsXXrVgDAwYMHMbL4HTylpaVisXj79u0AgLq6Ovxyql27djU3N0skErFYrGYZCgsLp02bRoyPHj2q2OhEr9TZRO/p6VlSUoIPHz58+PLLL1++fBkhNDoxEEIbN240NTW1tbWdOnVqTU0NQui9996zt7ffuXPnmTNngoKCgoODSRQ1hZGI8dprrx07dow4cXJyunjx4hiVSUlJ0dHRxOe7776bnJysUkls9FHQaWLgt0WdOHECIxsYGKj099W///57oVD4yiuvYL2Li0tmZqaaZbhy5YqVlRUx3r9/P/78JhosqCTGuXPnZs6cSSwFAsH69evx4ejEOHTokLe3N94s5eTkODk5DQwMJCYmktDd3d0GBgYikYg4V0cYiRjz5s37/PPPiQcLC4uqqqoxKnfs2EF2gwihxYsX79u3T6WSxNVHQaeJkZub6+rqOmXKlJ6eHoTQkiVLAACKz3wI4tXV1V988YWnp6eBgQG5bSBnVQodHR0sFgvfuiCE1q5du27duuGWKonx3nvvffLJJ8R4/PjxL7zwgtvjYWxsPH369NOnT+OzStPfeuutHTt2kIkmJiY//fTTP//5T8XNiampaW1tLbFRRxiJGPHx8WRRXV1dxsbG3d3dY1SeOnXq5ZdfJll5eXl98803KpXERh8FnSZGc3Pz+fPnAQAffPABQuj48eP4tYVtbW3x8fHz58+XyWTbtm3z8fGpr6+HEPL5fABAfX29mpV47bXXdu7ciRBqb2+3tbWtqKhACJU/HsSDUmdjvYuLS0FBAbHp7+/v+3U4ODhUVFSQb2CUpm/ZsiU4OBjfBZWXl48fP14mk4lEookTJ969exchlJuba2trK5fLiXN1BCVikCUUFhba29vjB32ffPJJSEgIQmiMyp6eHi6Xe+XKFYTQpUuXrKys+vv7VSrVyVxnbXSdGPhibWhoWFpaOjQ0tH79+nHjxgEArKys8K6ppqZm5syZeCvF5XL37NmjPta1tbVubm7Tp0+3sLAgV4C4xwMhVFBQwOVyzczMAADcx4NQjsPhVFZWqgxEtlIqp0ul0rCwsBdffPH111+fNm0aubB8+eWXkydP9vDwcHJyKioqUulZpdLPz4/L5eK3jHK5XPxAliwBIZSUlGRhYcHj8dzd3cnz6DEqc3Nzp0yZMmPGDBsbm2+//RYnplKpMme9UD59YvxemAYHB9va2h49eqQ48f79+8OVigajyK2treSbr1HMNHiqr69P8WtB7HlgYKC9vV2DUYgrCOHwLw3HqJTL5SKRSOnKplJJ0tAvQf+IoV/40mz1FAFKDD0tHE1buwhQYmgXX+pdTxGgxNDTwtG0tYsAJYZ28aXe9RQBSgw9LRxNW7sIUGJoF1/qXU8RoMTQ08LRtLWLwP8AsgCUbuDg7BYAAAAASUVORK5CYII="
    }
   },
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "![image.png](attachment:image.png)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "![alt text](image_3.png \"Title\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "2. There was also a strong relationship between tweet likes and retweet counts indicating a likelihood of tweets liked being retweeted."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "![alt text](image_4.png \"Title\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "3. An overwhelming 96% of dogs in this version of cleaned dataset were not having categories, however, the greater percentage(66.88%), of those categorized were \"puppers\"."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "![alt text](image_1.png \"Title\")\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "![alt text](image_2.png \"Title\")\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "On the overall, more processes need to be carried out to bring definitive insights out of the available data."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Conclusion"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The data wrangling process was carried out successfully for the relevant data. Different quality and tidiness issues were highlighted, cleaned, and tested using the relevant framework.\n",
    "Insights were then drawn from the cleaned data which coupled with some drawn up visualizations showed some pretty interesting details. However, it should be noted that the datasets in uestion still had some issues to be corrected, which coupled with appropriate domain knowledge should result in even more impressive and accurate insights."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}