Data Analytics on FB Metric Dataset.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## <center> Part B 1. DATA ANALYTICS with Python </center>\n",
    "### Perform the following operations using R/Python on the Amazon book review and facebook metrics data sets\n",
    "##### As per SPPU, Pune Syllabus\n",
    "\n",
    "1. Create data subsets\n",
    "* Merge Data\n",
    "* Sort Data\n",
    "* Transposing Data\n",
    "* Melting Data to long format\n",
    "* Casting data to wide format\n",
    "\n",
    "<right> Designed by, ![Logo mini](http://mitu.co.in/wp-content/uploads/2015/11/logo11.png)</right>"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Initially we will be using 2 Major Libraries \n",
    "* **Pandas** which is **Pan**el **Da**ta – an Econometrics from Multidimensional data.  \n",
    "Pandas will help us bring more precision on handling the Dataset, having each and every cell in control for performing feasible operation on it\n",
    "\n",
    "* **Numpy** which is **Num**erical **Py**thon used as Advanced Mathematical Utility Tool.  \n",
    "Numpy will help in adjunct with Pandas, providing support of random data generation, creating series data and like-wise"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "dataset = pd.read_csv(\"dataset_Facebook.csv\", delimiter=';')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Here, we have imported Pandas with nick name to it as **pd** and Numpy as **np**  \n",
    "The `dataset` here is an Object of Pandas and Variable type as Dataframe.  \n",
    "Notice that Dataset used `dataset_Facebook.csv` is a _Semi-colon_ seperated dataset rather than a _Comma Separated_ values, and for same reason the `delimiter` we have set is **semi-colon**  \n",
    "Altough you can experiment what happens if you do not give any delimiter and print it.\n",
    "\n",
    "#### Let us make the 2<sup>nd</sup> Line more clearer to us:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "TYPE OF dataset VARIABLE IS: <class 'pandas.core.frame.DataFrame'>\n",
      "DATA CONTAINED IN dataset IS:\n",
      "    Page total likes    Type  Category  Post Month  Post Weekday  Post Hour  \\\n",
      "0            139441   Photo         2          12             4          3   \n",
      "1            139441  Status         2          12             3         10   \n",
      "2            139441   Photo         3          12             3          3   \n",
      "3            139441   Photo         2          12             2         10   \n",
      "4            139441   Photo         2          12             2          3   \n",
      "\n",
      "   Paid  Lifetime Post Total Reach  Lifetime Post Total Impressions  \\\n",
      "0   0.0                       2752                             5091   \n",
      "1   0.0                      10460                            19057   \n",
      "2   0.0                       2413                             4373   \n",
      "3   1.0                      50128                            87991   \n",
      "4   0.0                       7244                            13594   \n",
      "\n",
      "   Lifetime Engaged Users  Lifetime Post Consumers  \\\n",
      "0                     178                      109   \n",
      "1                    1457                     1361   \n",
      "2                     177                      113   \n",
      "3                    2211                      790   \n",
      "4                     671                      410   \n",
      "\n",
      "   Lifetime Post Consumptions  \\\n",
      "0                         159   \n",
      "1                        1674   \n",
      "2                         154   \n",
      "3                        1119   \n",
      "4                         580   \n",
      "\n",
      "   Lifetime Post Impressions by people who have liked your Page  \\\n",
      "0                                               3078              \n",
      "1                                              11710              \n",
      "2                                               2812              \n",
      "3                                              61027              \n",
      "4                                               6228              \n",
      "\n",
      "   Lifetime Post reach by people who like your Page  \\\n",
      "0                                              1640   \n",
      "1                                              6112   \n",
      "2                                              1503   \n",
      "3                                             32048   \n",
      "4                                              3200   \n",
      "\n",
      "   Lifetime People who have liked your Page and engaged with your post  \\\n",
      "0                                                119                     \n",
      "1                                               1108                     \n",
      "2                                                132                     \n",
      "3                                               1386                     \n",
      "4                                                396                     \n",
      "\n",
      "   comment    like  share  Total Interactions  \n",
      "0        4    79.0   17.0                 100  \n",
      "1        5   130.0   29.0                 164  \n",
      "2        0    66.0   14.0                  80  \n",
      "3       58  1572.0  147.0                1777  \n",
      "4       19   325.0   49.0                 393  \n"
     ]
    }
   ],
   "source": [
    "print(\"TYPE OF dataset VARIABLE IS:\", type(dataset))\n",
    "print(\"DATA CONTAINED IN dataset IS:\\n\", dataset.head())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Pre - Data Analysis Study\n",
    "#### I recommend you first check this dataset into a Spreadsheet / Equivalent software  \n",
    "\n",
    "<font size=3>From this now you understand that this Dataset has many columns to view it in one simple table. Let us try something that tells us more about this dataset. We'll learn this inbuilt attribute and function called as `shape` and `info()`, that'll help us know our dataset.</font>"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Dataset is represented here in Tuple as (ROWS, COLUMNS)\n",
      " (500, 19)\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 500 entries, 0 to 499\n",
      "Data columns (total 19 columns):\n",
      "Page total likes                                                       500 non-null int64\n",
      "Type                                                                   500 non-null object\n",
      "Category                                                               500 non-null int64\n",
      "Post Month                                                             500 non-null int64\n",
      "Post Weekday                                                           500 non-null int64\n",
      "Post Hour                                                              500 non-null int64\n",
      "Paid                                                                   499 non-null float64\n",
      "Lifetime Post Total Reach                                              500 non-null int64\n",
      "Lifetime Post Total Impressions                                        500 non-null int64\n",
      "Lifetime Engaged Users                                                 500 non-null int64\n",
      "Lifetime Post Consumers                                                500 non-null int64\n",
      "Lifetime Post Consumptions                                             500 non-null int64\n",
      "Lifetime Post Impressions by people who have liked your Page           500 non-null int64\n",
      "Lifetime Post reach by people who like your Page                       500 non-null int64\n",
      "Lifetime People who have liked your Page and engaged with your post    500 non-null int64\n",
      "comment                                                                500 non-null int64\n",
      "like                                                                   499 non-null float64\n",
      "share                                                                  496 non-null float64\n",
      "Total Interactions                                                     500 non-null int64\n",
      "dtypes: float64(3), int64(15), object(1)\n",
      "memory usage: 74.3+ KB\n",
      "Dataset's Detailed Info is as Follows: None\n"
     ]
    }
   ],
   "source": [
    "print(\"Dataset is represented here in Tuple as (ROWS, COLUMNS)\\n\", dataset.shape)\n",
    "print(\"Dataset's Detailed Info is as Follows:\", dataset.info())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### #1  Creating Sub-Datasets\n",
    "#### Remember:  \n",
    "* In Python the Upper Bound is Always neglected\n",
    "* Attributes that are Compulsory, should never be left blank\n",
    "* Appropriate Range must be given wherever applicable"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "     Page total likes    Type  Category  Post Month\n",
      "0              139441   Photo         2          12\n",
      "1              139441  Status         2          12\n",
      "2              139441   Photo         3          12\n",
      "3              139441   Photo         2          12\n",
      "4              139441   Photo         2          12\n",
      "5              139441  Status         2          12\n",
      "6              139441   Photo         3          12\n",
      "7              139441   Photo         3          12\n",
      "8              139441  Status         2          12\n",
      "9              139441   Photo         3          12\n",
      "10             139441  Status         2          12\n",
      "11             139441   Photo         2          12\n",
      "12             139441   Photo         2          12\n",
      "13             139441   Photo         2          12\n",
      "14             138414   Photo         2          12\n",
      "15             138414  Status         2          12\n",
      "16             138414   Photo         3          12\n",
      "17             138414   Photo         1          12\n",
      "18             138414  Status         3          12\n",
      "19             138414   Photo         3          12\n",
      "20             138414   Photo         2          12\n",
      "21             138414   Photo         1          12\n",
      "22             138414    Link         1          12\n",
      "23             138414   Photo         3          12\n",
      "24             138414  Status         2          12\n",
      "25             138458  Status         2          12\n",
      "26             138458  Status         2          12\n",
      "27             138458   Photo         3          12\n",
      "28             138895   Photo         2          12\n",
      "29             138895   Video         1          12\n",
      "..                ...     ...       ...         ...\n",
      "470             91437    Link         1           2\n",
      "471             91330   Photo         3           2\n",
      "472             91223   Photo         1           2\n",
      "473             91116   Photo         3           2\n",
      "474             91009   Photo         1           2\n",
      "475             86909   Photo         3           1\n",
      "476             86909   Photo         1           1\n",
      "477             86909    Link         1           1\n",
      "478             86909   Photo         3           1\n",
      "479             86909   Photo         3           1\n",
      "480             86909   Photo         2           1\n",
      "481             86491    Link         1           1\n",
      "482             86491   Photo         3           1\n",
      "483             86491   Photo         2           1\n",
      "484             86491   Photo         3           1\n",
      "485             86491    Link         1           1\n",
      "486             85979   Photo         3           1\n",
      "487             85979   Photo         3           1\n",
      "488             85979   Photo         3           1\n",
      "489             85979   Photo         3           1\n",
      "490             85979   Photo         3           1\n",
      "491             85979   Photo         3           1\n",
      "492             85979    Link         1           1\n",
      "493             85093   Photo         3           1\n",
      "494             85093   Photo         3           1\n",
      "495             85093   Photo         3           1\n",
      "496             81370   Photo         2           1\n",
      "497             81370   Photo         1           1\n",
      "498             81370   Photo         3           1\n",
      "499             81370   Photo         2           1\n",
      "\n",
      "[500 rows x 4 columns]\n",
      "   Page total likes    Type  Category  Post Month  Post Weekday  Post Hour  \\\n",
      "0            139441   Photo         2          12             4          3   \n",
      "1            139441  Status         2          12             3         10   \n",
      "2            139441   Photo         3          12             3          3   \n",
      "3            139441   Photo         2          12             2         10   \n",
      "\n",
      "   Paid  Lifetime Post Total Reach  Lifetime Post Total Impressions  \\\n",
      "0   0.0                       2752                             5091   \n",
      "1   0.0                      10460                            19057   \n",
      "2   0.0                       2413                             4373   \n",
      "3   1.0                      50128                            87991   \n",
      "\n",
      "   Lifetime Engaged Users  Lifetime Post Consumers  \\\n",
      "0                     178                      109   \n",
      "1                    1457                     1361   \n",
      "2                     177                      113   \n",
      "3                    2211                      790   \n",
      "\n",
      "   Lifetime Post Consumptions  \\\n",
      "0                         159   \n",
      "1                        1674   \n",
      "2                         154   \n",
      "3                        1119   \n",
      "\n",
      "   Lifetime Post Impressions by people who have liked your Page  \\\n",
      "0                                               3078              \n",
      "1                                              11710              \n",
      "2                                               2812              \n",
      "3                                              61027              \n",
      "\n",
      "   Lifetime Post reach by people who like your Page  \\\n",
      "0                                              1640   \n",
      "1                                              6112   \n",
      "2                                              1503   \n",
      "3                                             32048   \n",
      "\n",
      "   Lifetime People who have liked your Page and engaged with your post  \\\n",
      "0                                                119                     \n",
      "1                                               1108                     \n",
      "2                                                132                     \n",
      "3                                               1386                     \n",
      "\n",
      "   comment    like  share  Total Interactions  \n",
      "0        4    79.0   17.0                 100  \n",
      "1        5   130.0   29.0                 164  \n",
      "2        0    66.0   14.0                  80  \n",
      "3       58  1572.0  147.0                1777  \n",
      "     Type  Category  Post Month  Post Weekday  Post Hour  Paid\n",
      "1  Status         2          12             3         10   0.0\n",
      "2   Photo         3          12             3          3   0.0\n",
      "3   Photo         2          12             2         10   1.0\n",
      "4   Photo         2          12             2          3   0.0\n",
      "0       Photo\n",
      "1      Status\n",
      "2       Photo\n",
      "3       Photo\n",
      "4       Photo\n",
      "5      Status\n",
      "6       Photo\n",
      "7       Photo\n",
      "8      Status\n",
      "9       Photo\n",
      "10     Status\n",
      "11      Photo\n",
      "12      Photo\n",
      "13      Photo\n",
      "14      Photo\n",
      "15     Status\n",
      "16      Photo\n",
      "17      Photo\n",
      "18     Status\n",
      "19      Photo\n",
      "20      Photo\n",
      "21      Photo\n",
      "22       Link\n",
      "23      Photo\n",
      "24     Status\n",
      "25     Status\n",
      "26     Status\n",
      "27      Photo\n",
      "28      Photo\n",
      "29      Video\n",
      "        ...  \n",
      "470      Link\n",
      "471     Photo\n",
      "472     Photo\n",
      "473     Photo\n",
      "474     Photo\n",
      "475     Photo\n",
      "476     Photo\n",
      "477      Link\n",
      "478     Photo\n",
      "479     Photo\n",
      "480     Photo\n",
      "481      Link\n",
      "482     Photo\n",
      "483     Photo\n",
      "484     Photo\n",
      "485      Link\n",
      "486     Photo\n",
      "487     Photo\n",
      "488     Photo\n",
      "489     Photo\n",
      "490     Photo\n",
      "491     Photo\n",
      "492      Link\n",
      "493     Photo\n",
      "494     Photo\n",
      "495     Photo\n",
      "496     Photo\n",
      "497     Photo\n",
      "498     Photo\n",
      "499     Photo\n",
      "Name: Type, Length: 500, dtype: object\n"
     ]
    }
   ],
   "source": [
    "ds1 = dataset.iloc[:, 0:4]  # All Rows and Columns from 0 to 3\n",
    "print (ds1)\n",
    "ds2 = dataset.iloc[0:4, :]  # Rows from 0 to 3 and All Columns\n",
    "print (ds2)\n",
    "ds3 = dataset.iloc[1:5, 1:7]  # Rows from 1 to 4 and 1 to 6 Columns\n",
    "print (ds3)\n",
    "typ = dataset.iloc[:, 1]  # All Rows and Column no. 1\n",
    "print (typ)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### The above statements would've been slightly difficult to identify the outputs. The better way is you try it out one at a time.\n",
    "\n",
    "You saw how at every stage the columns and rows are written to extract and create sub-datasets from major dataset.\n",
    "\n",
    "😃 Congratulations! Now you are ready for next lesson!"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### #2 Merge Data\n",
    "\n",
    "The first line of code below is slightly off-beat to understand, (take a look at it, and return) so let me brief it. In there I'm asking S1 to collect all data from dataset where Status is set to 'Status' (and not 'Posts'). For same I'm asking the help of a Column that I've already created above, that is `typ`\n",
    "\n",
    "#### What are we learning new?\n",
    "* pd.concat - Using which we will be concatenating 2 dataframes in different ways\n",
    "* pd.Series - One of the Datatype besides Dataframe available in Pandas (We are using this just to create Index numbers)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "S1:\n",
      "      Page total likes    Type  Category  Post Month  Post Weekday  Post Hour  \\\n",
      "1              139441  Status         2          12             3         10   \n",
      "5              139441  Status         2          12             1          9   \n",
      "8              139441  Status         2          12             7          3   \n",
      "10             139441  Status         2          12             5         10   \n",
      "15             138414  Status         2          12             3         10   \n",
      "18             138414  Status         3          12             2          3   \n",
      "24             138414  Status         2          12             6         10   \n",
      "25             138458  Status         2          12             6          3   \n",
      "26             138458  Status         2          12             5         11   \n",
      "38             138895  Status         2          12             7          9   \n",
      "40             138895  Status         2          12             6         11   \n",
      "46             138353  Status         1          12             3         11   \n",
      "72             137893  Status         3          11             4         11   \n",
      "80             137177  Status         2          11             7          3   \n",
      "84             137177  Status         3          11             5          2   \n",
      "98             137020  Status         2          10             5          3   \n",
      "107            136736  Status         2          10             1          4   \n",
      "109            136736  Status         2          10             7          3   \n",
      "121            136393  Status         2          10             7          9   \n",
      "138            136013  Status         2          10             5          3   \n",
      "141            136013  Status         3          10             3         10   \n",
      "142            136013  Status         2          10             3          2   \n",
      "148            135713  Status         2          10             7          4   \n",
      "163            135617  Status         2           9             6          4   \n",
      "172            135195  Status         2           9             1         10   \n",
      "175            135195  Status         2           9             6         10   \n",
      "180            134879  Status         2           9             4          4   \n",
      "202            132817  Status         2           8             3          2   \n",
      "217            131956  Status         2           8             2         12   \n",
      "222            131808  Status         2           8             7          4   \n",
      "223            131808  Status         2           8             6         10   \n",
      "225            131808  Status         2           7             5         14   \n",
      "232            131630  Status         2           7             2          6   \n",
      "235            131300  Status         2           7             7         10   \n",
      "242            130791  Status         2           7             4          6   \n",
      "253            129600  Status         2           7             5         12   \n",
      "267            128032  Status         2           7             5         10   \n",
      "275            126424  Status         2           7             3         13   \n",
      "282            126345  Status         2           6             7         11   \n",
      "285            126141  Status         2           6             6          4   \n",
      "334            119198  Status         2           5             1          2   \n",
      "352            116435  Status         1           5             4          3   \n",
      "362            116091  Status         2           5             5          7   \n",
      "371            113028  Status         2           4             6          3   \n",
      "416            104070  Status         1           3             3         15   \n",
      "\n",
      "     Paid  Lifetime Post Total Reach  Lifetime Post Total Impressions  \\\n",
      "1     0.0                      10460                            19057   \n",
      "5     0.0                      10472                            20849   \n",
      "8     0.0                      11844                            22538   \n",
      "10    0.0                      21744                            42334   \n",
      "15    0.0                      10060                            19680   \n",
      "18    0.0                       3930                             7509   \n",
      "24    0.0                       8488                            15294   \n",
      "25    0.0                       8284                            15104   \n",
      "26    0.0                      19552                            34143   \n",
      "38    0.0                      17576                            33058   \n",
      "40    0.0                      13280                            24198   \n",
      "46    0.0                      16576                            30612   \n",
      "72    0.0                       9056                            16362   \n",
      "80    0.0                       8728                            17827   \n",
      "84    0.0                       6692                            13092   \n",
      "98    1.0                      12468                            24917   \n",
      "107   0.0                       9504                            19556   \n",
      "109   0.0                      13872                            27468   \n",
      "121   0.0                      15816                            30514   \n",
      "138   0.0                       8896                            17202   \n",
      "141   0.0                      13152                            25666   \n",
      "142   1.0                      31136                            59964   \n",
      "148   0.0                      10744                            20691   \n",
      "163   0.0                      11096                            21080   \n",
      "172   0.0                      21256                            41906   \n",
      "175   1.0                      13216                            24738   \n",
      "180   1.0                       9124                            17776   \n",
      "202   1.0                       9236                            16054   \n",
      "217   0.0                      14424                            26000   \n",
      "222   0.0                       8260                            14305   \n",
      "223   1.0                      20168                            35904   \n",
      "225   0.0                      15296                            25269   \n",
      "232   1.0                      10824                            20573   \n",
      "235   0.0                      10956                            19279   \n",
      "242   0.0                      17360                            33613   \n",
      "253   1.0                      15576                            27513   \n",
      "267   0.0                      10188                            16978   \n",
      "275   0.0                      18320                            31448   \n",
      "282   0.0                      12044                            20327   \n",
      "285   0.0                       8628                            14847   \n",
      "334   0.0                      10152                            17099   \n",
      "352   1.0                      23832                            42313   \n",
      "362   0.0                       9232                            16811   \n",
      "371   1.0                      17912                            34774   \n",
      "416   0.0                       9120                            14759   \n",
      "\n",
      "     Lifetime Engaged Users  Lifetime Post Consumers  \\\n",
      "1                      1457                     1361   \n",
      "5                      1191                     1073   \n",
      "8                      1530                     1407   \n",
      "10                     4258                     4100   \n",
      "15                     1264                     1209   \n",
      "18                      130                       86   \n",
      "24                     1341                     1270   \n",
      "25                     1521                     1462   \n",
      "26                     2806                     2531   \n",
      "38                     5352                     5202   \n",
      "40                     2055                     1912   \n",
      "46                     3572                     3464   \n",
      "72                     1006                      847   \n",
      "80                     2295                     2235   \n",
      "84                      199                      108   \n",
      "98                     2143                     1966   \n",
      "107                    1132                     1032   \n",
      "109                    2664                     2570   \n",
      "121                    2733                     2654   \n",
      "138                    1480                     1426   \n",
      "141                    2543                     2438   \n",
      "142                    6164                     5934   \n",
      "148                    1967                     1877   \n",
      "163                    1843                     1724   \n",
      "172                    4840                     4754   \n",
      "175                    2675                     2584   \n",
      "180                    1476                     1397   \n",
      "202                    1151                     1130   \n",
      "217                     304                      286   \n",
      "222                     997                      953   \n",
      "223                    3370                     3244   \n",
      "225                    2827                     2781   \n",
      "232                     135                      126   \n",
      "235                     128                      119   \n",
      "242                    2573                     2448   \n",
      "253                    2417                     2327   \n",
      "267                    1473                     1441   \n",
      "275                    3742                     3682   \n",
      "282                    2240                     2193   \n",
      "285                     870                      843   \n",
      "334                    1636                     1599   \n",
      "352                    1701                     1570   \n",
      "362                     908                      861   \n",
      "371                    2750                     2567   \n",
      "416                     951                      937   \n",
      "\n",
      "     Lifetime Post Consumptions  \\\n",
      "1                          1674   \n",
      "5                          1389   \n",
      "8                          1692   \n",
      "10                         4540   \n",
      "15                         1425   \n",
      "18                          112   \n",
      "24                         1489   \n",
      "25                         1711   \n",
      "26                         3420   \n",
      "38                         6547   \n",
      "40                         2720   \n",
      "46                         4802   \n",
      "72                         1153   \n",
      "80                         2828   \n",
      "84                          141   \n",
      "98                         2576   \n",
      "107                        1512   \n",
      "109                        3395   \n",
      "121                        3289   \n",
      "138                        1932   \n",
      "141                        3179   \n",
      "142                        9237   \n",
      "148                        2201   \n",
      "163                        2106   \n",
      "172                        5906   \n",
      "175                        2969   \n",
      "180                        1797   \n",
      "202                        1560   \n",
      "217                         383   \n",
      "222                        1211   \n",
      "223                        5106   \n",
      "225                        3627   \n",
      "232                         153   \n",
      "235                         130   \n",
      "242                        6017   \n",
      "253                        3098   \n",
      "267                        2136   \n",
      "275                        7854   \n",
      "282                        3599   \n",
      "285                        1692   \n",
      "334                        2755   \n",
      "352                        2838   \n",
      "362                        1967   \n",
      "371                        6591   \n",
      "416                        1290   \n",
      "\n",
      "     Lifetime Post Impressions by people who have liked your Page  \\\n",
      "1                                                11710              \n",
      "5                                                16034              \n",
      "8                                                15220              \n",
      "10                                               37849              \n",
      "15                                               17272              \n",
      "18                                                5009              \n",
      "24                                                9684              \n",
      "25                                               10266              \n",
      "26                                               17748              \n",
      "38                                               23135              \n",
      "40                                               17627              \n",
      "46                                               24363              \n",
      "72                                                9562              \n",
      "80                                               15418              \n",
      "84                                                7549              \n",
      "98                                               15850              \n",
      "107                                              16018              \n",
      "109                                              20198              \n",
      "121                                              23584              \n",
      "138                                              13838              \n",
      "141                                              20547              \n",
      "142                                              35977              \n",
      "148                                              17502              \n",
      "163                                              16095              \n",
      "172                                              35455              \n",
      "175                                              19599              \n",
      "180                                              13887              \n",
      "202                                              14014              \n",
      "217                                              25539              \n",
      "222                                              12905              \n",
      "223                                              26881              \n",
      "225                                              22103              \n",
      "232                                              20030              \n",
      "235                                              18838              \n",
      "242                                              23338              \n",
      "253                                              19078              \n",
      "267                                              14450              \n",
      "275                                              25584              \n",
      "282                                              17717              \n",
      "285                                              11970              \n",
      "334                                              15382              \n",
      "352                                              37816              \n",
      "362                                              12996              \n",
      "371                                              21009              \n",
      "416                                              13246              \n",
      "\n",
      "     Lifetime Post reach by people who like your Page  \\\n",
      "1                                                6112   \n",
      "5                                                7852   \n",
      "8                                                7912   \n",
      "10                                              18952   \n",
      "15                                               8548   \n",
      "18                                               2410   \n",
      "24                                               5244   \n",
      "25                                               5372   \n",
      "26                                               9824   \n",
      "38                                              11792   \n",
      "40                                               9344   \n",
      "46                                              12888   \n",
      "72                                               5180   \n",
      "80                                               7344   \n",
      "84                                               3336   \n",
      "98                                               7636   \n",
      "107                                              7616   \n",
      "109                                             10432   \n",
      "121                                             11912   \n",
      "138                                              7020   \n",
      "141                                             10280   \n",
      "142                                             18048   \n",
      "148                                              8964   \n",
      "163                                              8120   \n",
      "172                                             17592   \n",
      "175                                             10232   \n",
      "180                                              7092   \n",
      "202                                              7880   \n",
      "217                                             14056   \n",
      "222                                              7360   \n",
      "223                                             15056   \n",
      "225                                             13296   \n",
      "232                                             10384   \n",
      "235                                             10564   \n",
      "242                                             11800   \n",
      "253                                             10840   \n",
      "267                                              8536   \n",
      "275                                             14920   \n",
      "282                                             10400   \n",
      "285                                              6796   \n",
      "334                                              8980   \n",
      "352                                             21352   \n",
      "362                                              7200   \n",
      "371                                             11408   \n",
      "416                                              8004   \n",
      "\n",
      "     Lifetime People who have liked your Page and engaged with your post  \\\n",
      "1                                                 1108                     \n",
      "5                                                 1016                     \n",
      "8                                                 1250                     \n",
      "10                                                3798                     \n",
      "15                                                1162                     \n",
      "18                                                 101                     \n",
      "24                                                 995                     \n",
      "25                                                1200                     \n",
      "26                                                1779                     \n",
      "38                                                4104                     \n",
      "40                                                1716                     \n",
      "46                                                3014                     \n",
      "72                                                 740                     \n",
      "80                                                2099                     \n",
      "84                                                 156                     \n",
      "98                                                1661                     \n",
      "107                                                981                     \n",
      "109                                               2252                     \n",
      "121                                               2361                     \n",
      "138                                               1292                     \n",
      "141                                               2278                     \n",
      "142                                               4376                     \n",
      "148                                               1834                     \n",
      "163                                               1604                     \n",
      "172                                               4318                     \n",
      "175                                               2342                     \n",
      "180                                               1331                     \n",
      "202                                               1075                     \n",
      "217                                                291                     \n",
      "222                                                956                     \n",
      "223                                               2806                     \n",
      "225                                               2602                     \n",
      "232                                                126                     \n",
      "235                                                123                     \n",
      "242                                               1905                     \n",
      "253                                               1839                     \n",
      "267                                               1395                     \n",
      "275                                               3300                     \n",
      "282                                               2119                     \n",
      "285                                                774                     \n",
      "334                                               1613                     \n",
      "352                                               1578                     \n",
      "362                                                843                     \n",
      "371                                               2256                     \n",
      "416                                                924                     \n",
      "\n",
      "     comment   like  share  Total Interactions  \n",
      "1          5  130.0   29.0                 164  \n",
      "5          1  152.0   33.0                 186  \n",
      "8          0  161.0   31.0                 192  \n",
      "10         0  233.0   19.0                 252  \n",
      "15         4   86.0   18.0                 108  \n",
      "18         4   54.0   17.0                  75  \n",
      "24         3   99.0   19.0                 121  \n",
      "25         0   88.0   18.0                 106  \n",
      "26        10  412.0   72.0                 494  \n",
      "38        11  227.0   31.0                 269  \n",
      "40         7  216.0   39.0                 262  \n",
      "46         4  174.0   36.0                 214  \n",
      "72         3  226.0   44.0                 273  \n",
      "80         2   86.0   13.0                 101  \n",
      "84         2   99.0   16.0                 117  \n",
      "98         7  310.0   61.0                 378  \n",
      "107       17  193.0   28.0                 238  \n",
      "109        4  217.0   50.0                 271  \n",
      "121        6  186.0   40.0                 232  \n",
      "138        0  129.0   25.0                 154  \n",
      "141        2  227.0   36.0                 265  \n",
      "142       60  859.0   90.0                1009  \n",
      "148        3  148.0   28.0                 179  \n",
      "163        4  243.0   41.0                 288  \n",
      "172       38  163.0   27.0                 228  \n",
      "175        2  165.0   22.0                 189  \n",
      "180       20  150.0   29.0                 199  \n",
      "202        2   53.0   15.0                  70  \n",
      "217       41   15.0    1.0                  57  \n",
      "222        1   74.0   11.0                  86  \n",
      "223       18  332.0   54.0                 404  \n",
      "225        9   95.0   17.0                 121  \n",
      "232        6   14.0    1.0                  21  \n",
      "235        3   13.0    1.0                  17  \n",
      "242        9  484.0   79.0                 572  \n",
      "253       11  238.0   51.0                 300  \n",
      "267       13   61.0   13.0                  87  \n",
      "275       36   98.0   14.0                 148  \n",
      "282        0  104.0   13.0                 117  \n",
      "285        4   72.0   18.0                  94  \n",
      "334        2   55.0   10.0                  67  \n",
      "352        6  210.0   39.0                 255  \n",
      "362        1  129.0   36.0                 166  \n",
      "371       17  447.0  123.0                 587  \n",
      "416        3   25.0    6.0                  34  \n",
      "\n",
      " DS4:\n",
      "      Post Month  Post Weekday  Post Hour  Lifetime Post Total Reach\n",
      "0            12             4          3                       2752\n",
      "1            12             3         10                      10460\n",
      "2            12             3          3                       2413\n",
      "3            12             2         10                      50128\n",
      "4            12             2          3                       7244\n",
      "5            12             1          9                      10472\n",
      "6            12             1          3                      11692\n",
      "7            12             7          9                      13720\n",
      "8            12             7          3                      11844\n",
      "9            12             6         10                       4694\n",
      "10           12             5         10                      21744\n",
      "11           12             5         10                       3112\n",
      "12           12             5         10                       2847\n",
      "13           12             5          3                       2549\n",
      "14           12             4          5                      22784\n",
      "15           12             3         10                      10060\n",
      "16           12             3          3                       1722\n",
      "17           12             2         12                      53264\n",
      "18           12             2          3                       3930\n",
      "19           12             1         11                       1591\n",
      "20           12             1          3                       2848\n",
      "21           12             7         10                       1384\n",
      "22           12             7         10                       3454\n",
      "23           12             7          3                       2723\n",
      "24           12             6         10                       8488\n",
      "25           12             6          3                       8284\n",
      "26           12             5         11                      19552\n",
      "27           12             5          3                       2478\n",
      "28           12             5          3                       9560\n",
      "29           12             4         11                      36208\n",
      "..          ...           ...        ...                        ...\n",
      "470           2             3         13                       9356\n",
      "471           2             3          3                       7732\n",
      "472           2             2         13                       5240\n",
      "473           2             2          4                       7132\n",
      "474           2             1         12                      21928\n",
      "475           1             6         16                       5754\n",
      "476           1             6         10                      37088\n",
      "477           1             6          4                      39600\n",
      "478           1             5         13                       5536\n",
      "479           1             5          4                       6056\n",
      "480           1             4         11                      11484\n",
      "481           1             4          4                       4938\n",
      "482           1             3         10                      66784\n",
      "483           1             3          3                       5526\n",
      "484           1             2          7                       5040\n",
      "485           1             2          2                       5168\n",
      "486           1             1         12                       5034\n",
      "487           1             1          2                       4908\n",
      "488           1             7         10                       9700\n",
      "489           1             7          2                       4800\n",
      "490           1             6         11                       5280\n",
      "491           1             6          3                       6184\n",
      "492           1             5         11                      45920\n",
      "493           1             1          2                       8412\n",
      "494           1             7         10                       5400\n",
      "495           1             7          2                       4684\n",
      "496           1             5          8                       3480\n",
      "497           1             5          2                       3778\n",
      "498           1             4         11                       4156\n",
      "499           1             4          4                       4188\n",
      "\n",
      "[500 rows x 4 columns]\n",
      "This data is not well arranged and has NaN values in it\n",
      "      Category  Lifetime Engaged Users  \\\n",
      "1         2.0                  1457.0   \n",
      "5         2.0                  1191.0   \n",
      "8         2.0                  1530.0   \n",
      "10        2.0                  4258.0   \n",
      "15        2.0                  1264.0   \n",
      "18        3.0                   130.0   \n",
      "24        2.0                  1341.0   \n",
      "25        2.0                  1521.0   \n",
      "26        2.0                  2806.0   \n",
      "38        2.0                  5352.0   \n",
      "40        2.0                  2055.0   \n",
      "46        1.0                  3572.0   \n",
      "72        3.0                  1006.0   \n",
      "80        2.0                  2295.0   \n",
      "84        3.0                   199.0   \n",
      "98        2.0                  2143.0   \n",
      "107       2.0                  1132.0   \n",
      "109       2.0                  2664.0   \n",
      "121       2.0                  2733.0   \n",
      "138       2.0                  1480.0   \n",
      "141       3.0                  2543.0   \n",
      "142       2.0                  6164.0   \n",
      "148       2.0                  1967.0   \n",
      "163       2.0                  1843.0   \n",
      "172       2.0                  4840.0   \n",
      "175       2.0                  2675.0   \n",
      "180       2.0                  1476.0   \n",
      "202       2.0                  1151.0   \n",
      "217       2.0                   304.0   \n",
      "222       2.0                   997.0   \n",
      "223       2.0                  3370.0   \n",
      "225       2.0                  2827.0   \n",
      "232       2.0                   135.0   \n",
      "235       2.0                   128.0   \n",
      "242       2.0                  2573.0   \n",
      "253       2.0                  2417.0   \n",
      "267       2.0                  1473.0   \n",
      "275       2.0                  3742.0   \n",
      "282       2.0                  2240.0   \n",
      "285       2.0                   870.0   \n",
      "334       2.0                  1636.0   \n",
      "352       1.0                  1701.0   \n",
      "362       2.0                   908.0   \n",
      "371       2.0                  2750.0   \n",
      "416       1.0                   951.0   \n",
      "0         NaN                     NaN   \n",
      "1         NaN                     NaN   \n",
      "2         NaN                     NaN   \n",
      "3         NaN                     NaN   \n",
      "4         NaN                     NaN   \n",
      "\n",
      "     Lifetime People who have liked your Page and engaged with your post  \\\n",
      "1                                               1108.0                     \n",
      "5                                               1016.0                     \n",
      "8                                               1250.0                     \n",
      "10                                              3798.0                     \n",
      "15                                              1162.0                     \n",
      "18                                               101.0                     \n",
      "24                                               995.0                     \n",
      "25                                              1200.0                     \n",
      "26                                              1779.0                     \n",
      "38                                              4104.0                     \n",
      "40                                              1716.0                     \n",
      "46                                              3014.0                     \n",
      "72                                               740.0                     \n",
      "80                                              2099.0                     \n",
      "84                                               156.0                     \n",
      "98                                              1661.0                     \n",
      "107                                              981.0                     \n",
      "109                                             2252.0                     \n",
      "121                                             2361.0                     \n",
      "138                                             1292.0                     \n",
      "141                                             2278.0                     \n",
      "142                                             4376.0                     \n",
      "148                                             1834.0                     \n",
      "163                                             1604.0                     \n",
      "172                                             4318.0                     \n",
      "175                                             2342.0                     \n",
      "180                                             1331.0                     \n",
      "202                                             1075.0                     \n",
      "217                                              291.0                     \n",
      "222                                              956.0                     \n",
      "223                                             2806.0                     \n",
      "225                                             2602.0                     \n",
      "232                                              126.0                     \n",
      "235                                              123.0                     \n",
      "242                                             1905.0                     \n",
      "253                                             1839.0                     \n",
      "267                                             1395.0                     \n",
      "275                                             3300.0                     \n",
      "282                                             2119.0                     \n",
      "285                                              774.0                     \n",
      "334                                             1613.0                     \n",
      "352                                             1578.0                     \n",
      "362                                              843.0                     \n",
      "371                                             2256.0                     \n",
      "416                                              924.0                     \n",
      "0                                                  NaN                     \n",
      "1                                                  NaN                     \n",
      "2                                                  NaN                     \n",
      "3                                                  NaN                     \n",
      "4                                                  NaN                     \n",
      "\n",
      "     Lifetime Post Consumers  Lifetime Post Consumptions  \\\n",
      "1                     1361.0                      1674.0   \n",
      "5                     1073.0                      1389.0   \n",
      "8                     1407.0                      1692.0   \n",
      "10                    4100.0                      4540.0   \n",
      "15                    1209.0                      1425.0   \n",
      "18                      86.0                       112.0   \n",
      "24                    1270.0                      1489.0   \n",
      "25                    1462.0                      1711.0   \n",
      "26                    2531.0                      3420.0   \n",
      "38                    5202.0                      6547.0   \n",
      "40                    1912.0                      2720.0   \n",
      "46                    3464.0                      4802.0   \n",
      "72                     847.0                      1153.0   \n",
      "80                    2235.0                      2828.0   \n",
      "84                     108.0                       141.0   \n",
      "98                    1966.0                      2576.0   \n",
      "107                   1032.0                      1512.0   \n",
      "109                   2570.0                      3395.0   \n",
      "121                   2654.0                      3289.0   \n",
      "138                   1426.0                      1932.0   \n",
      "141                   2438.0                      3179.0   \n",
      "142                   5934.0                      9237.0   \n",
      "148                   1877.0                      2201.0   \n",
      "163                   1724.0                      2106.0   \n",
      "172                   4754.0                      5906.0   \n",
      "175                   2584.0                      2969.0   \n",
      "180                   1397.0                      1797.0   \n",
      "202                   1130.0                      1560.0   \n",
      "217                    286.0                       383.0   \n",
      "222                    953.0                      1211.0   \n",
      "223                   3244.0                      5106.0   \n",
      "225                   2781.0                      3627.0   \n",
      "232                    126.0                       153.0   \n",
      "235                    119.0                       130.0   \n",
      "242                   2448.0                      6017.0   \n",
      "253                   2327.0                      3098.0   \n",
      "267                   1441.0                      2136.0   \n",
      "275                   3682.0                      7854.0   \n",
      "282                   2193.0                      3599.0   \n",
      "285                    843.0                      1692.0   \n",
      "334                   1599.0                      2755.0   \n",
      "352                   1570.0                      2838.0   \n",
      "362                    861.0                      1967.0   \n",
      "371                   2567.0                      6591.0   \n",
      "416                    937.0                      1290.0   \n",
      "0                        NaN                         NaN   \n",
      "1                        NaN                         NaN   \n",
      "2                        NaN                         NaN   \n",
      "3                        NaN                         NaN   \n",
      "4                        NaN                         NaN   \n",
      "\n",
      "     Lifetime Post Impressions by people who have liked your Page  \\\n",
      "1                                              11710.0              \n",
      "5                                              16034.0              \n",
      "8                                              15220.0              \n",
      "10                                             37849.0              \n",
      "15                                             17272.0              \n",
      "18                                              5009.0              \n",
      "24                                              9684.0              \n",
      "25                                             10266.0              \n",
      "26                                             17748.0              \n",
      "38                                             23135.0              \n",
      "40                                             17627.0              \n",
      "46                                             24363.0              \n",
      "72                                              9562.0              \n",
      "80                                             15418.0              \n",
      "84                                              7549.0              \n",
      "98                                             15850.0              \n",
      "107                                            16018.0              \n",
      "109                                            20198.0              \n",
      "121                                            23584.0              \n",
      "138                                            13838.0              \n",
      "141                                            20547.0              \n",
      "142                                            35977.0              \n",
      "148                                            17502.0              \n",
      "163                                            16095.0              \n",
      "172                                            35455.0              \n",
      "175                                            19599.0              \n",
      "180                                            13887.0              \n",
      "202                                            14014.0              \n",
      "217                                            25539.0              \n",
      "222                                            12905.0              \n",
      "223                                            26881.0              \n",
      "225                                            22103.0              \n",
      "232                                            20030.0              \n",
      "235                                            18838.0              \n",
      "242                                            23338.0              \n",
      "253                                            19078.0              \n",
      "267                                            14450.0              \n",
      "275                                            25584.0              \n",
      "282                                            17717.0              \n",
      "285                                            11970.0              \n",
      "334                                            15382.0              \n",
      "352                                            37816.0              \n",
      "362                                            12996.0              \n",
      "371                                            21009.0              \n",
      "416                                            13246.0              \n",
      "0                                                  NaN              \n",
      "1                                                  NaN              \n",
      "2                                                  NaN              \n",
      "3                                                  NaN              \n",
      "4                                                  NaN              \n",
      "\n",
      "     Lifetime Post Total Impressions  Lifetime Post Total Reach  \\\n",
      "1                            19057.0                      10460   \n",
      "5                            20849.0                      10472   \n",
      "8                            22538.0                      11844   \n",
      "10                           42334.0                      21744   \n",
      "15                           19680.0                      10060   \n",
      "18                            7509.0                       3930   \n",
      "24                           15294.0                       8488   \n",
      "25                           15104.0                       8284   \n",
      "26                           34143.0                      19552   \n",
      "38                           33058.0                      17576   \n",
      "40                           24198.0                      13280   \n",
      "46                           30612.0                      16576   \n",
      "72                           16362.0                       9056   \n",
      "80                           17827.0                       8728   \n",
      "84                           13092.0                       6692   \n",
      "98                           24917.0                      12468   \n",
      "107                          19556.0                       9504   \n",
      "109                          27468.0                      13872   \n",
      "121                          30514.0                      15816   \n",
      "138                          17202.0                       8896   \n",
      "141                          25666.0                      13152   \n",
      "142                          59964.0                      31136   \n",
      "148                          20691.0                      10744   \n",
      "163                          21080.0                      11096   \n",
      "172                          41906.0                      21256   \n",
      "175                          24738.0                      13216   \n",
      "180                          17776.0                       9124   \n",
      "202                          16054.0                       9236   \n",
      "217                          26000.0                      14424   \n",
      "222                          14305.0                       8260   \n",
      "223                          35904.0                      20168   \n",
      "225                          25269.0                      15296   \n",
      "232                          20573.0                      10824   \n",
      "235                          19279.0                      10956   \n",
      "242                          33613.0                      17360   \n",
      "253                          27513.0                      15576   \n",
      "267                          16978.0                      10188   \n",
      "275                          31448.0                      18320   \n",
      "282                          20327.0                      12044   \n",
      "285                          14847.0                       8628   \n",
      "334                          17099.0                      10152   \n",
      "352                          42313.0                      23832   \n",
      "362                          16811.0                       9232   \n",
      "371                          34774.0                      17912   \n",
      "416                          14759.0                       9120   \n",
      "0                                NaN                       2752   \n",
      "1                                NaN                      10460   \n",
      "2                                NaN                       2413   \n",
      "3                                NaN                      50128   \n",
      "4                                NaN                       7244   \n",
      "\n",
      "     Lifetime Post reach by people who like your Page  Page total likes  Paid  \\\n",
      "1                                              6112.0          139441.0   0.0   \n",
      "5                                              7852.0          139441.0   0.0   \n",
      "8                                              7912.0          139441.0   0.0   \n",
      "10                                            18952.0          139441.0   0.0   \n",
      "15                                             8548.0          138414.0   0.0   \n",
      "18                                             2410.0          138414.0   0.0   \n",
      "24                                             5244.0          138414.0   0.0   \n",
      "25                                             5372.0          138458.0   0.0   \n",
      "26                                             9824.0          138458.0   0.0   \n",
      "38                                            11792.0          138895.0   0.0   \n",
      "40                                             9344.0          138895.0   0.0   \n",
      "46                                            12888.0          138353.0   0.0   \n",
      "72                                             5180.0          137893.0   0.0   \n",
      "80                                             7344.0          137177.0   0.0   \n",
      "84                                             3336.0          137177.0   0.0   \n",
      "98                                             7636.0          137020.0   1.0   \n",
      "107                                            7616.0          136736.0   0.0   \n",
      "109                                           10432.0          136736.0   0.0   \n",
      "121                                           11912.0          136393.0   0.0   \n",
      "138                                            7020.0          136013.0   0.0   \n",
      "141                                           10280.0          136013.0   0.0   \n",
      "142                                           18048.0          136013.0   1.0   \n",
      "148                                            8964.0          135713.0   0.0   \n",
      "163                                            8120.0          135617.0   0.0   \n",
      "172                                           17592.0          135195.0   0.0   \n",
      "175                                           10232.0          135195.0   1.0   \n",
      "180                                            7092.0          134879.0   1.0   \n",
      "202                                            7880.0          132817.0   1.0   \n",
      "217                                           14056.0          131956.0   0.0   \n",
      "222                                            7360.0          131808.0   0.0   \n",
      "223                                           15056.0          131808.0   1.0   \n",
      "225                                           13296.0          131808.0   0.0   \n",
      "232                                           10384.0          131630.0   1.0   \n",
      "235                                           10564.0          131300.0   0.0   \n",
      "242                                           11800.0          130791.0   0.0   \n",
      "253                                           10840.0          129600.0   1.0   \n",
      "267                                            8536.0          128032.0   0.0   \n",
      "275                                           14920.0          126424.0   0.0   \n",
      "282                                           10400.0          126345.0   0.0   \n",
      "285                                            6796.0          126141.0   0.0   \n",
      "334                                            8980.0          119198.0   0.0   \n",
      "352                                           21352.0          116435.0   1.0   \n",
      "362                                            7200.0          116091.0   0.0   \n",
      "371                                           11408.0          113028.0   1.0   \n",
      "416                                            8004.0          104070.0   0.0   \n",
      "0                                                 NaN               NaN   NaN   \n",
      "1                                                 NaN               NaN   NaN   \n",
      "2                                                 NaN               NaN   NaN   \n",
      "3                                                 NaN               NaN   NaN   \n",
      "4                                                 NaN               NaN   NaN   \n",
      "\n",
      "     Post Hour  Post Month  Post Weekday  Total Interactions    Type  comment  \\\n",
      "1           10          12             3               164.0  Status      5.0   \n",
      "5            9          12             1               186.0  Status      1.0   \n",
      "8            3          12             7               192.0  Status      0.0   \n",
      "10          10          12             5               252.0  Status      0.0   \n",
      "15          10          12             3               108.0  Status      4.0   \n",
      "18           3          12             2                75.0  Status      4.0   \n",
      "24          10          12             6               121.0  Status      3.0   \n",
      "25           3          12             6               106.0  Status      0.0   \n",
      "26          11          12             5               494.0  Status     10.0   \n",
      "38           9          12             7               269.0  Status     11.0   \n",
      "40          11          12             6               262.0  Status      7.0   \n",
      "46          11          12             3               214.0  Status      4.0   \n",
      "72          11          11             4               273.0  Status      3.0   \n",
      "80           3          11             7               101.0  Status      2.0   \n",
      "84           2          11             5               117.0  Status      2.0   \n",
      "98           3          10             5               378.0  Status      7.0   \n",
      "107          4          10             1               238.0  Status     17.0   \n",
      "109          3          10             7               271.0  Status      4.0   \n",
      "121          9          10             7               232.0  Status      6.0   \n",
      "138          3          10             5               154.0  Status      0.0   \n",
      "141         10          10             3               265.0  Status      2.0   \n",
      "142          2          10             3              1009.0  Status     60.0   \n",
      "148          4          10             7               179.0  Status      3.0   \n",
      "163          4           9             6               288.0  Status      4.0   \n",
      "172         10           9             1               228.0  Status     38.0   \n",
      "175         10           9             6               189.0  Status      2.0   \n",
      "180          4           9             4               199.0  Status     20.0   \n",
      "202          2           8             3                70.0  Status      2.0   \n",
      "217         12           8             2                57.0  Status     41.0   \n",
      "222          4           8             7                86.0  Status      1.0   \n",
      "223         10           8             6               404.0  Status     18.0   \n",
      "225         14           7             5               121.0  Status      9.0   \n",
      "232          6           7             2                21.0  Status      6.0   \n",
      "235         10           7             7                17.0  Status      3.0   \n",
      "242          6           7             4               572.0  Status      9.0   \n",
      "253         12           7             5               300.0  Status     11.0   \n",
      "267         10           7             5                87.0  Status     13.0   \n",
      "275         13           7             3               148.0  Status     36.0   \n",
      "282         11           6             7               117.0  Status      0.0   \n",
      "285          4           6             6                94.0  Status      4.0   \n",
      "334          2           5             1                67.0  Status      2.0   \n",
      "352          3           5             4               255.0  Status      6.0   \n",
      "362          7           5             5               166.0  Status      1.0   \n",
      "371          3           4             6               587.0  Status     17.0   \n",
      "416         15           3             3                34.0  Status      3.0   \n",
      "0            3          12             4                 NaN     NaN      NaN   \n",
      "1           10          12             3                 NaN     NaN      NaN   \n",
      "2            3          12             3                 NaN     NaN      NaN   \n",
      "3           10          12             2                 NaN     NaN      NaN   \n",
      "4            3          12             2                 NaN     NaN      NaN   \n",
      "\n",
      "      like  share  \n",
      "1    130.0   29.0  \n",
      "5    152.0   33.0  \n",
      "8    161.0   31.0  \n",
      "10   233.0   19.0  \n",
      "15    86.0   18.0  \n",
      "18    54.0   17.0  \n",
      "24    99.0   19.0  \n",
      "25    88.0   18.0  \n",
      "26   412.0   72.0  \n",
      "38   227.0   31.0  \n",
      "40   216.0   39.0  \n",
      "46   174.0   36.0  \n",
      "72   226.0   44.0  \n",
      "80    86.0   13.0  \n",
      "84    99.0   16.0  \n",
      "98   310.0   61.0  \n",
      "107  193.0   28.0  \n",
      "109  217.0   50.0  \n",
      "121  186.0   40.0  \n",
      "138  129.0   25.0  \n",
      "141  227.0   36.0  \n",
      "142  859.0   90.0  \n",
      "148  148.0   28.0  \n",
      "163  243.0   41.0  \n",
      "172  163.0   27.0  \n",
      "175  165.0   22.0  \n",
      "180  150.0   29.0  \n",
      "202   53.0   15.0  \n",
      "217   15.0    1.0  \n",
      "222   74.0   11.0  \n",
      "223  332.0   54.0  \n",
      "225   95.0   17.0  \n",
      "232   14.0    1.0  \n",
      "235   13.0    1.0  \n",
      "242  484.0   79.0  \n",
      "253  238.0   51.0  \n",
      "267   61.0   13.0  \n",
      "275   98.0   14.0  \n",
      "282  104.0   13.0  \n",
      "285   72.0   18.0  \n",
      "334   55.0   10.0  \n",
      "352  210.0   39.0  \n",
      "362  129.0   36.0  \n",
      "371  447.0  123.0  \n",
      "416   25.0    6.0  \n",
      "0      NaN    NaN  \n",
      "1      NaN    NaN  \n",
      "2      NaN    NaN  \n",
      "3      NaN    NaN  \n",
      "4      NaN    NaN  \n",
      "These are just Index numbers:\n",
      " 0      1\n",
      "1      2\n",
      "2      3\n",
      "3      4\n",
      "4      5\n",
      "5      6\n",
      "6      7\n",
      "7      8\n",
      "8      9\n",
      "9     10\n",
      "10    11\n",
      "11    12\n",
      "12    13\n",
      "13    14\n",
      "14    15\n",
      "15    16\n",
      "16    17\n",
      "17    18\n",
      "18    19\n",
      "19    20\n",
      "20    21\n",
      "21    22\n",
      "22    23\n",
      "23    24\n",
      "24    25\n",
      "25    26\n",
      "26    27\n",
      "27    28\n",
      "28    29\n",
      "29    30\n",
      "30    31\n",
      "31    32\n",
      "32    33\n",
      "33    34\n",
      "34    35\n",
      "35    36\n",
      "36    37\n",
      "37    38\n",
      "38    39\n",
      "39    40\n",
      "40    41\n",
      "41    42\n",
      "42    43\n",
      "43    44\n",
      "44    45\n",
      "45    46\n",
      "46    47\n",
      "47    48\n",
      "48    49\n",
      "49    50\n",
      "dtype: int64\n",
      "The dataset now has Index numbers combined that we just created!\n",
      "        0  Page total likes    Type  Category  Post Month  Post Weekday  \\\n",
      "0      1            139441   Photo         2          12             4   \n",
      "1      2            139441  Status         2          12             3   \n",
      "2      3            139441   Photo         3          12             3   \n",
      "3      4            139441   Photo         2          12             2   \n",
      "4      5            139441   Photo         2          12             2   \n",
      "5      6            139441  Status         2          12             1   \n",
      "6      7            139441   Photo         3          12             1   \n",
      "7      8            139441   Photo         3          12             7   \n",
      "8      9            139441  Status         2          12             7   \n",
      "9     10            139441   Photo         3          12             6   \n",
      "10    11            139441  Status         2          12             5   \n",
      "11    12            139441   Photo         2          12             5   \n",
      "12    13            139441   Photo         2          12             5   \n",
      "13    14            139441   Photo         2          12             5   \n",
      "14    15            138414   Photo         2          12             4   \n",
      "15    16            138414  Status         2          12             3   \n",
      "16    17            138414   Photo         3          12             3   \n",
      "17    18            138414   Photo         1          12             2   \n",
      "18    19            138414  Status         3          12             2   \n",
      "19    20            138414   Photo         3          12             1   \n",
      "20    21            138414   Photo         2          12             1   \n",
      "21    22            138414   Photo         1          12             7   \n",
      "22    23            138414    Link         1          12             7   \n",
      "23    24            138414   Photo         3          12             7   \n",
      "24    25            138414  Status         2          12             6   \n",
      "25    26            138458  Status         2          12             6   \n",
      "26    27            138458  Status         2          12             5   \n",
      "27    28            138458   Photo         3          12             5   \n",
      "28    29            138895   Photo         2          12             5   \n",
      "29    30            138895   Video         1          12             4   \n",
      "..   ...               ...     ...       ...         ...           ...   \n",
      "470  471             91437    Link         1           2             3   \n",
      "471  472             91330   Photo         3           2             3   \n",
      "472  473             91223   Photo         1           2             2   \n",
      "473  474             91116   Photo         3           2             2   \n",
      "474  475             91009   Photo         1           2             1   \n",
      "475  476             86909   Photo         3           1             6   \n",
      "476  477             86909   Photo         1           1             6   \n",
      "477  478             86909    Link         1           1             6   \n",
      "478  479             86909   Photo         3           1             5   \n",
      "479  480             86909   Photo         3           1             5   \n",
      "480  481             86909   Photo         2           1             4   \n",
      "481  482             86491    Link         1           1             4   \n",
      "482  483             86491   Photo         3           1             3   \n",
      "483  484             86491   Photo         2           1             3   \n",
      "484  485             86491   Photo         3           1             2   \n",
      "485  486             86491    Link         1           1             2   \n",
      "486  487             85979   Photo         3           1             1   \n",
      "487  488             85979   Photo         3           1             1   \n",
      "488  489             85979   Photo         3           1             7   \n",
      "489  490             85979   Photo         3           1             7   \n",
      "490  491             85979   Photo         3           1             6   \n",
      "491  492             85979   Photo         3           1             6   \n",
      "492  493             85979    Link         1           1             5   \n",
      "493  494             85093   Photo         3           1             1   \n",
      "494  495             85093   Photo         3           1             7   \n",
      "495  496             85093   Photo         3           1             7   \n",
      "496  497             81370   Photo         2           1             5   \n",
      "497  498             81370   Photo         1           1             5   \n",
      "498  499             81370   Photo         3           1             4   \n",
      "499  500             81370   Photo         2           1             4   \n",
      "\n",
      "     Post Hour  Paid  Lifetime Post Total Reach  \\\n",
      "0            3   0.0                       2752   \n",
      "1           10   0.0                      10460   \n",
      "2            3   0.0                       2413   \n",
      "3           10   1.0                      50128   \n",
      "4            3   0.0                       7244   \n",
      "5            9   0.0                      10472   \n",
      "6            3   1.0                      11692   \n",
      "7            9   1.0                      13720   \n",
      "8            3   0.0                      11844   \n",
      "9           10   0.0                       4694   \n",
      "10          10   0.0                      21744   \n",
      "11          10   0.0                       3112   \n",
      "12          10   0.0                       2847   \n",
      "13           3   0.0                       2549   \n",
      "14           5   1.0                      22784   \n",
      "15          10   0.0                      10060   \n",
      "16           3   0.0                       1722   \n",
      "17          12   1.0                      53264   \n",
      "18           3   0.0                       3930   \n",
      "19          11   0.0                       1591   \n",
      "20           3   0.0                       2848   \n",
      "21          10   0.0                       1384   \n",
      "22          10   0.0                       3454   \n",
      "23           3   0.0                       2723   \n",
      "24          10   0.0                       8488   \n",
      "25           3   0.0                       8284   \n",
      "26          11   0.0                      19552   \n",
      "27           3   0.0                       2478   \n",
      "28           3   0.0                       9560   \n",
      "29          11   1.0                      36208   \n",
      "..         ...   ...                        ...   \n",
      "470         13   0.0                       9356   \n",
      "471          3   0.0                       7732   \n",
      "472         13   0.0                       5240   \n",
      "473          4   1.0                       7132   \n",
      "474         12   0.0                      21928   \n",
      "475         16   1.0                       5754   \n",
      "476         10   1.0                      37088   \n",
      "477          4   0.0                      39600   \n",
      "478         13   0.0                       5536   \n",
      "479          4   0.0                       6056   \n",
      "480         11   0.0                      11484   \n",
      "481          4   1.0                       4938   \n",
      "482         10   0.0                      66784   \n",
      "483          3   0.0                       5526   \n",
      "484          7   0.0                       5040   \n",
      "485          2   0.0                       5168   \n",
      "486         12   0.0                       5034   \n",
      "487          2   0.0                       4908   \n",
      "488         10   0.0                       9700   \n",
      "489          2   0.0                       4800   \n",
      "490         11   0.0                       5280   \n",
      "491          3   1.0                       6184   \n",
      "492         11   0.0                      45920   \n",
      "493          2   0.0                       8412   \n",
      "494         10   0.0                       5400   \n",
      "495          2   0.0                       4684   \n",
      "496          8   0.0                       3480   \n",
      "497          2   0.0                       3778   \n",
      "498         11   0.0                       4156   \n",
      "499          4   NaN                       4188   \n",
      "\n",
      "     Lifetime Post Total Impressions  Lifetime Engaged Users  \\\n",
      "0                               5091                     178   \n",
      "1                              19057                    1457   \n",
      "2                               4373                     177   \n",
      "3                              87991                    2211   \n",
      "4                              13594                     671   \n",
      "5                              20849                    1191   \n",
      "6                              19479                     481   \n",
      "7                              24137                     537   \n",
      "8                              22538                    1530   \n",
      "9                               8668                     280   \n",
      "10                             42334                    4258   \n",
      "11                              5590                     208   \n",
      "12                              5133                     193   \n",
      "13                              4896                     249   \n",
      "14                             39941                     887   \n",
      "15                             19680                    1264   \n",
      "16                              2981                     163   \n",
      "17                            111785                    1706   \n",
      "18                              7509                     130   \n",
      "19                              2825                     121   \n",
      "20                              5066                     200   \n",
      "21                              2467                      15   \n",
      "22                              6853                     118   \n",
      "23                              4888                     176   \n",
      "24                             15294                    1341   \n",
      "25                             15104                    1521   \n",
      "26                             34143                    2806   \n",
      "27                              4306                     212   \n",
      "28                             18264                     973   \n",
      "29                             61262                    1141   \n",
      "..                               ...                     ...   \n",
      "470                            14986                     448   \n",
      "471                            13264                    1066   \n",
      "472                             8893                     857   \n",
      "473                            12060                    1004   \n",
      "474                            39641                    1512   \n",
      "475                             9238                    1179   \n",
      "476                            10966                    2728   \n",
      "477                             7927                     572   \n",
      "478                             8745                    1141   \n",
      "479                            10325                    1117   \n",
      "480                            20696                    1762   \n",
      "481                             7910                      66   \n",
      "482                             9456                    2969   \n",
      "483                             8779                    1096   \n",
      "484                             8367                    1062   \n",
      "485                             8371                      66   \n",
      "486                             8030                    1020   \n",
      "487                             7491                     957   \n",
      "488                            17442                    1407   \n",
      "489                             7754                     975   \n",
      "490                             8703                     951   \n",
      "491                            10228                     956   \n",
      "492                             5808                     753   \n",
      "493                            13960                    1179   \n",
      "494                             9218                     810   \n",
      "495                             7536                     733   \n",
      "496                             6229                     537   \n",
      "497                             7216                     625   \n",
      "498                             7564                     626   \n",
      "499                             7292                     564   \n",
      "\n",
      "     Lifetime Post Consumers  Lifetime Post Consumptions  \\\n",
      "0                        109                         159   \n",
      "1                       1361                        1674   \n",
      "2                        113                         154   \n",
      "3                        790                        1119   \n",
      "4                        410                         580   \n",
      "5                       1073                        1389   \n",
      "6                        265                         364   \n",
      "7                        232                         305   \n",
      "8                       1407                        1692   \n",
      "9                        183                         250   \n",
      "10                      4100                        4540   \n",
      "11                       127                         145   \n",
      "12                       115                         133   \n",
      "13                       134                         168   \n",
      "14                       337                         417   \n",
      "15                      1209                        1425   \n",
      "16                       123                         148   \n",
      "17                      1103                        1655   \n",
      "18                        86                         112   \n",
      "19                        88                         111   \n",
      "20                       142                         184   \n",
      "21                        15                          20   \n",
      "22                       104                         130   \n",
      "23                       118                         143   \n",
      "24                      1270                        1489   \n",
      "25                      1462                        1711   \n",
      "26                      2531                        3420   \n",
      "27                       124                         149   \n",
      "28                       559                         885   \n",
      "29                      1068                        1728   \n",
      "..                       ...                         ...   \n",
      "470                      381                         505   \n",
      "471                     1002                        1336   \n",
      "472                      837                        1020   \n",
      "473                      944                        1226   \n",
      "474                     1479                        1837   \n",
      "475                     1143                        1452   \n",
      "476                     2288                        3183   \n",
      "477                      496                         581   \n",
      "478                     1099                        1461   \n",
      "479                     1078                        1427   \n",
      "480                     1635                        2741   \n",
      "481                       63                          70   \n",
      "482                     2833                        3645   \n",
      "483                     1058                        1399   \n",
      "484                     1023                        1348   \n",
      "485                       59                          71   \n",
      "486                      993                        1243   \n",
      "487                      937                        1153   \n",
      "488                     1271                        2007   \n",
      "489                      938                        1278   \n",
      "490                      911                        1237   \n",
      "491                      901                        1140   \n",
      "492                      655                         763   \n",
      "493                     1111                        1632   \n",
      "494                      756                        1003   \n",
      "495                      708                         985   \n",
      "496                      508                         687   \n",
      "497                      572                         795   \n",
      "498                      574                         832   \n",
      "499                      524                         743   \n",
      "\n",
      "     Lifetime Post Impressions by people who have liked your Page  \\\n",
      "0                                                 3078              \n",
      "1                                                11710              \n",
      "2                                                 2812              \n",
      "3                                                61027              \n",
      "4                                                 6228              \n",
      "5                                                16034              \n",
      "6                                                15432              \n",
      "7                                                19728              \n",
      "8                                                15220              \n",
      "9                                                 4309              \n",
      "10                                               37849              \n",
      "11                                                3887              \n",
      "12                                                3779              \n",
      "13                                                3631              \n",
      "14                                               34415              \n",
      "15                                               17272              \n",
      "16                                                1868              \n",
      "17                                               92512              \n",
      "18                                                5009              \n",
      "19                                                2116              \n",
      "20                                                3561              \n",
      "21                                                2196              \n",
      "22                                                6282              \n",
      "23                                                2964              \n",
      "24                                                9684              \n",
      "25                                               10266              \n",
      "26                                               17748              \n",
      "27                                                2612              \n",
      "28                                                9217              \n",
      "29                                               30131              \n",
      "..                                                 ...              \n",
      "470                                              13919              \n",
      "471                                               8753              \n",
      "472                                               7420              \n",
      "473                                               8294              \n",
      "474                                               6338              \n",
      "475                                               6101              \n",
      "476                                              66311              \n",
      "477                                              12522              \n",
      "478                                               5225              \n",
      "479                                               6823              \n",
      "480                                               8774              \n",
      "481                                               6625              \n",
      "482                                              17809              \n",
      "483                                               5732              \n",
      "484                                               5485              \n",
      "485                                               7041              \n",
      "486                                               5340              \n",
      "487                                               4642              \n",
      "488                                               8872              \n",
      "489                                               4932              \n",
      "490                                               5757              \n",
      "491                                               6085              \n",
      "492                                              15766              \n",
      "493                                               8632              \n",
      "494                                               5654              \n",
      "495                                               4750              \n",
      "496                                               3961              \n",
      "497                                               4742              \n",
      "498                                               4534              \n",
      "499                                               3861              \n",
      "\n",
      "     Lifetime Post reach by people who like your Page  \\\n",
      "0                                                1640   \n",
      "1                                                6112   \n",
      "2                                                1503   \n",
      "3                                               32048   \n",
      "4                                                3200   \n",
      "5                                                7852   \n",
      "6                                                9328   \n",
      "7                                               11056   \n",
      "8                                                7912   \n",
      "9                                                2324   \n",
      "10                                              18952   \n",
      "11                                               2174   \n",
      "12                                               2072   \n",
      "13                                               1917   \n",
      "14                                              19312   \n",
      "15                                               8548   \n",
      "16                                               1050   \n",
      "17                                              39776   \n",
      "18                                               2410   \n",
      "19                                               1161   \n",
      "20                                               1963   \n",
      "21                                               1172   \n",
      "22                                               3100   \n",
      "23                                               1621   \n",
      "24                                               5244   \n",
      "25                                               5372   \n",
      "26                                               9824   \n",
      "27                                               1443   \n",
      "28                                               4748   \n",
      "29                                              14112   \n",
      "..                                                ...   \n",
      "470                                              8460   \n",
      "471                                              4880   \n",
      "472                                              4232   \n",
      "473                                              4736   \n",
      "474                                              3672   \n",
      "475                                              3546   \n",
      "476                                             34352   \n",
      "477                                              8176   \n",
      "478                                              3098   \n",
      "479                                              3788   \n",
      "480                                              5124   \n",
      "481                                              3804   \n",
      "482                                             11328   \n",
      "483                                              3412   \n",
      "484                                              3068   \n",
      "485                                              3996   \n",
      "486                                              3094   \n",
      "487                                              2842   \n",
      "488                                              4876   \n",
      "489                                              2820   \n",
      "490                                              3300   \n",
      "491                                              3502   \n",
      "492                                             10720   \n",
      "493                                              5348   \n",
      "494                                              3230   \n",
      "495                                              2876   \n",
      "496                                              2104   \n",
      "497                                              2388   \n",
      "498                                              2452   \n",
      "499                                              2200   \n",
      "\n",
      "     Lifetime People who have liked your Page and engaged with your post  \\\n",
      "0                                                  119                     \n",
      "1                                                 1108                     \n",
      "2                                                  132                     \n",
      "3                                                 1386                     \n",
      "4                                                  396                     \n",
      "5                                                 1016                     \n",
      "6                                                  379                     \n",
      "7                                                  422                     \n",
      "8                                                 1250                     \n",
      "9                                                  199                     \n",
      "10                                                3798                     \n",
      "11                                                 165                     \n",
      "12                                                 152                     \n",
      "13                                                 183                     \n",
      "14                                                 684                     \n",
      "15                                                1162                     \n",
      "16                                                 123                     \n",
      "17                                                1307                     \n",
      "18                                                 101                     \n",
      "19                                                 100                     \n",
      "20                                                 157                     \n",
      "21                                                  15                     \n",
      "22                                                 106                     \n",
      "23                                                 143                     \n",
      "24                                                 995                     \n",
      "25                                                1200                     \n",
      "26                                                1779                     \n",
      "27                                                 166                     \n",
      "28                                                 621                     \n",
      "29                                                 559                     \n",
      "..                                                 ...                     \n",
      "470                                                392                     \n",
      "471                                                570                     \n",
      "472                                                466                     \n",
      "473                                                576                     \n",
      "474                                                497                     \n",
      "475                                                420                     \n",
      "476                                               2021                     \n",
      "477                                                167                     \n",
      "478                                                483                     \n",
      "479                                                487                     \n",
      "480                                                722                     \n",
      "481                                                 59                     \n",
      "482                                                801                     \n",
      "483                                                453                     \n",
      "484                                                437                     \n",
      "485                                                 58                     \n",
      "486                                                440                     \n",
      "487                                                393                     \n",
      "488                                                660                     \n",
      "489                                                432                     \n",
      "490                                                431                     \n",
      "491                                                437                     \n",
      "492                                                220                     \n",
      "493                                                699                     \n",
      "494                                                422                     \n",
      "495                                                392                     \n",
      "496                                                301                     \n",
      "497                                                363                     \n",
      "498                                                370                     \n",
      "499                                                316                     \n",
      "\n",
      "     comment    like  share  Total Interactions  \n",
      "0          4    79.0   17.0                 100  \n",
      "1          5   130.0   29.0                 164  \n",
      "2          0    66.0   14.0                  80  \n",
      "3         58  1572.0  147.0                1777  \n",
      "4         19   325.0   49.0                 393  \n",
      "5          1   152.0   33.0                 186  \n",
      "6          3   249.0   27.0                 279  \n",
      "7          0   325.0   14.0                 339  \n",
      "8          0   161.0   31.0                 192  \n",
      "9          3   113.0   26.0                 142  \n",
      "10         0   233.0   19.0                 252  \n",
      "11         0    88.0   18.0                 106  \n",
      "12         0    90.0   14.0                 104  \n",
      "13         5   137.0   10.0                 152  \n",
      "14         2   577.0   20.0                 599  \n",
      "15         4    86.0   18.0                 108  \n",
      "16         2    40.0   12.0                  54  \n",
      "17        15   678.0   20.0                 713  \n",
      "18         4    54.0   17.0                  75  \n",
      "19         0    34.0    8.0                  42  \n",
      "20         3    66.0   12.0                  81  \n",
      "21         0     0.0    0.0                   0  \n",
      "22         0    16.0    2.0                  18  \n",
      "23         0    72.0   24.0                  96  \n",
      "24         3    99.0   19.0                 121  \n",
      "25         0    88.0   18.0                 106  \n",
      "26        10   412.0   72.0                 494  \n",
      "27         0   100.0   17.0                 117  \n",
      "28        36   523.0   63.0                 622  \n",
      "29        18   143.0   13.0                 174  \n",
      "..       ...     ...    ...                 ...  \n",
      "470        4   114.0   13.0                 131  \n",
      "471        7   160.0   57.0                 224  \n",
      "472        0    46.0   15.0                  61  \n",
      "473        4   136.0   42.0                 182  \n",
      "474        0    73.0   13.0                  86  \n",
      "475        0    65.0   19.0                  84  \n",
      "476        7   579.0   47.0                 633  \n",
      "477        1   101.0    5.0                 107  \n",
      "478        1    74.0   31.0                 106  \n",
      "479        7    84.0   36.0                 127  \n",
      "480       56   360.0   99.0                 515  \n",
      "481        0     5.0    2.0                   7  \n",
      "482        3   187.0   36.0                 226  \n",
      "483        2    69.0   26.0                  97  \n",
      "484        2    82.0   24.0                 108  \n",
      "485        0    12.0    2.0                  14  \n",
      "486        2    56.0   25.0                  83  \n",
      "487        1    44.0   21.0                  66  \n",
      "488       21   277.0   80.0                 378  \n",
      "489        1    74.0   28.0                 103  \n",
      "490        1    79.0   30.0                 110  \n",
      "491        1   105.0   46.0                 152  \n",
      "492        0   128.0    9.0                 137  \n",
      "493       17   185.0   55.0                 257  \n",
      "494       10   125.0   41.0                 176  \n",
      "495        5    53.0   26.0                  84  \n",
      "496        0    53.0   22.0                  75  \n",
      "497        4    93.0   18.0                 115  \n",
      "498        7    91.0   38.0                 136  \n",
      "499        0    91.0   28.0                 119  \n",
      "\n",
      "[500 rows x 20 columns]\n"
     ]
    }
   ],
   "source": [
    "S1 = dataset[typ == 'Status']\n",
    "print(\"S1:\\n\", S1)\n",
    "\n",
    "ds4 = dataset.iloc[:, [3, 4, 5, 7]]\n",
    "print(\"\\n DS4:\\n\", ds4)\n",
    "\n",
    "StatusDetails = pd.concat([S1, ds4])  # This DF will contain all details of Status and NaN values from Posts\n",
    "print(\"This data is not well arranged and has NaN values in it\\n\", StatusDetails.head(50))\n",
    "\n",
    "indexSeries = pd.Series(range(1, dataset.__len__()+1))  # Creating a Series of Index numbers\n",
    "print(\"These are just Index numbers:\\n\", indexSeries.head(50))\n",
    "\n",
    "dataIdx = pd.concat([indexSeries, dataset], axis=1)  # Merging data of Indexes to Dataset\n",
    "print(\"The dataset now has Index numbers combined that we just created!\\n\", dataIdx)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "😅 The output is much verbose, it's always better to use an IDE for visualisations of such data\n",
    "However, the outputs are appropriate as we reqiuired.\n",
    "\n",
    "### #3 Sort Data\n",
    "Time to sort the available data. Sorting is again very simple. You don't have to worry about any sorting methods, you just need to call the sorting upon parameters you wish. For this we'll create a simple dataset where dataset is simple to understand in context of Dataset."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Dataset created:        col2      col1\n",
      "1 -1.617129 -0.634916\n",
      "4  0.390151  1.822808\n",
      "6 -0.461518 -0.939711\n",
      "2  0.053447 -2.211013\n",
      "3 -0.587890 -0.668350\n",
      "5 -0.341912 -0.258671\n",
      "9 -0.406709 -0.791790\n",
      "8 -0.081216  0.701410\n",
      "0 -0.106304 -2.033681\n",
      "7 -1.729511 -0.028630\n",
      "Simple Sorting: Default Ascending\n",
      "        col2      col1\n",
      "0 -0.106304 -2.033681\n",
      "1 -1.617129 -0.634916\n",
      "2  0.053447 -2.211013\n",
      "3 -0.587890 -0.668350\n",
      "4  0.390151  1.822808\n",
      "5 -0.341912 -0.258671\n",
      "6 -0.461518 -0.939711\n",
      "7 -1.729511 -0.028630\n",
      "8 -0.081216  0.701410\n",
      "9 -0.406709 -0.791790\n",
      "Simple Sorting: Descending\n",
      "        col2      col1\n",
      "9 -0.406709 -0.791790\n",
      "8 -0.081216  0.701410\n",
      "7 -1.729511 -0.028630\n",
      "6 -0.461518 -0.939711\n",
      "5 -0.341912 -0.258671\n",
      "4  0.390151  1.822808\n",
      "3 -0.587890 -0.668350\n",
      "2  0.053447 -2.211013\n",
      "1 -1.617129 -0.634916\n",
      "0 -0.106304 -2.033681\n",
      "Simple Sorting: Column wise\n",
      "        col1      col2\n",
      "1 -0.634916 -1.617129\n",
      "4  1.822808  0.390151\n",
      "6 -0.939711 -0.461518\n",
      "2 -2.211013  0.053447\n",
      "3 -0.668350 -0.587890\n",
      "5 -0.258671 -0.341912\n",
      "9 -0.791790 -0.406709\n",
      "8  0.701410 -0.081216\n",
      "0 -2.033681 -0.106304\n",
      "7 -0.028630 -1.729511\n"
     ]
    }
   ],
   "source": [
    "unsortedDF = pd.DataFrame(np.random.randn(10, 2), index=[1, 4, 6, 2, 3, 5, 9, 8, 0, 7], columns=['col2', 'col1'])\n",
    "print(\"Dataset created:\", unsortedDF)\n",
    "\n",
    "sortedAscDF = unsortedDF.sort_index()  # Ascending Arrangement by default\n",
    "print(\"Simple Sorting: Default Ascending\\n\", sortedAscDF)\n",
    "\n",
    "sortedDecDF = unsortedDF.sort_index(ascending=False)  # Descending by default\n",
    "print(\"Simple Sorting: Descending\\n\", sortedDecDF)\n",
    "\n",
    "sortedColDF = unsortedDF.sort_index(axis=1)  # Column Sortprint | Axis 1 is Column and 0 is row\n",
    "print(\"Simple Sorting: Column wise\\n\", sortedColDF)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "😃 Well Done!\n",
    "Now that you understand that Sorting and Data is not a big deal to handle, here's a bonus sorting method. If you are still struggling with above, you can improve with bit of practice. If you are ready for bonus and scroll and learn it Junior Data Scientist!\n",
    "\n",
    "#### Bonus Method of Sorting!\n",
    "This will enable you to sort on multiple values. The trick is simple that you need to pass on List. Let's see how:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "       col2      col1\n",
      "2  0.053447 -2.211013\n",
      "0 -0.106304 -2.033681\n",
      "6 -0.461518 -0.939711\n",
      "9 -0.406709 -0.791790\n",
      "3 -0.587890 -0.668350\n",
      "1 -1.617129 -0.634916\n",
      "5 -0.341912 -0.258671\n",
      "7 -1.729511 -0.028630\n",
      "8 -0.081216  0.701410\n",
      "4  0.390151  1.822808\n"
     ]
    }
   ],
   "source": [
    "# Selective Sort\n",
    "sortedByValue = unsortedDF.sort_values(by=['col1', 'col2'])\n",
    "print(sortedByValue)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Alright Jr. Data Scientist! Good work!  \n",
    "Time to Level UP!\n",
    "\n",
    "### #4 Transposing Data | Rows to Cols and Cols to Rows\n",
    "As the name goes, the objective is to\n",
    "* To convert Rows to Columns\n",
    "* To convert Columns to Rows\n",
    "* Data to be consistent\n",
    "\n",
    "All you need to do is call an inbuilt attribute called **T**\n",
    "Let's see how to do that!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Trying this on Sorted by Value Dataset:\n",
      "              2         0         6         9        3         1         5  \\\n",
      "col2  0.053447 -0.106304 -0.461518 -0.406709 -0.58789 -1.617129 -0.341912   \n",
      "col1 -2.211013 -2.033681 -0.939711 -0.791790 -0.66835 -0.634916 -0.258671   \n",
      "\n",
      "             7         8         4  \n",
      "col2 -1.729511 -0.081216  0.390151  \n",
      "col1 -0.028630  0.701410  1.822808  \n",
      "\n",
      " Trying this on Un-Sorted Dataset:\n",
      "              1         4         6         2        3         5         9  \\\n",
      "col2 -1.617129  0.390151 -0.461518  0.053447 -0.58789 -0.341912 -0.406709   \n",
      "col1 -0.634916  1.822808 -0.939711 -2.211013 -0.66835 -0.258671 -0.791790   \n",
      "\n",
      "             8         0         7  \n",
      "col2 -0.081216 -0.106304 -1.729511  \n",
      "col1  0.701410 -2.033681 -0.028630  \n"
     ]
    }
   ],
   "source": [
    "TSportedByValue = sortedByValue.T\n",
    "print(\"Trying this on Sorted by Value Dataset:\\n\", TSportedByValue)\n",
    "\n",
    "TunsortedDF = unsortedDF.T\n",
    "print(\"\\n Trying this on Un-Sorted Dataset:\\n\", TunsortedDF)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "😎 Congratulations! You've made it to the end now!\n",
    "\n",
    "Let us proceed to the End game.🛠\n",
    "\n",
    "### #5 Reshaping Data\n",
    "The images below will provide a better insight, on what they really mean!\n",
    "\n",
    "* **Meting Data to Long format**  \n",
    "![Melt](http://www.datasciencemadesimple.com/wp-content/uploads/2017/11/Reshape-wide-to-long-in-pandas-python-with-melt-function-0.png)  \n",
    "\n",
    "\n",
    "* **Casting data to wide format**\n",
    "![Wide](http://www.datasciencemadesimple.com/wp-content/uploads/2017/11/Reshape-long-to-wide-in-pandas-python-with-pivot-function-0.png)\n",
    "\n",
    "__[Image Source: datasciencemadesimple.com]__\n",
    "\n",
    "Dataset that we will be using is:\n",
    "\n",
    "`In    0     Type  Category\n",
    "0    1     Photo         2\n",
    "1    2    Status         2\n",
    "2    3     Photo         3\n",
    "3    4     Photo         2\n",
    "4    5     Photo         2\n",
    "5    6    Status         2\n",
    "6    7     Photo         3\n",
    "7    8     Photo         3\n",
    "8    9    Status         2\n",
    "9   10     Photo         3`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "    0    Type  Category\n",
      "0   1   Photo         2\n",
      "1   2  Status         2\n",
      "2   3   Photo         3\n",
      "3   4   Photo         2\n",
      "4   5   Photo         2\n",
      "5   6  Status         2\n",
      "6   7   Photo         3\n",
      "7   8   Photo         3\n",
      "8   9  Status         2\n",
      "9  10   Photo         3 \n",
      "\n",
      "\n",
      " MELTED TO LONG FORMAT \n",
      "      0 Attribute  Values\n",
      "0    1      Type   Photo\n",
      "1    2      Type  Status\n",
      "2    3      Type   Photo\n",
      "3    4      Type   Photo\n",
      "4    5      Type   Photo\n",
      "5    6      Type  Status\n",
      "6    7      Type   Photo\n",
      "7    8      Type   Photo\n",
      "8    9      Type  Status\n",
      "9   10      Type   Photo\n",
      "10   1  Category       2\n",
      "11   2  Category       2\n",
      "12   3  Category       3\n",
      "13   4  Category       2\n",
      "14   5  Category       2\n",
      "15   6  Category       2\n",
      "16   7  Category       3\n",
      "17   8  Category       3\n",
      "18   9  Category       2\n",
      "19  10  Category       3\n",
      "\n",
      " CASTING TO WIDE FORMAT \n",
      " Attribute Category    Type\n",
      "0                         \n",
      "1                2   Photo\n",
      "2                2  Status\n",
      "3                3   Photo\n",
      "4                2   Photo\n",
      "5                2   Photo\n",
      "6                2  Status\n",
      "7                3   Photo\n",
      "8                3   Photo\n",
      "9                2  Status\n",
      "10               3   Photo\n"
     ]
    }
   ],
   "source": [
    "newDataSet = dataIdx.iloc[0:10, [0, 2, 3]]\n",
    "print(newDataSet,\"\\n\")\n",
    "\n",
    "meltDS = pd.melt(newDataSet, id_vars=[0], var_name='Attribute', value_name='Values')\n",
    "print(\"\\n MELTED TO LONG FORMAT \\n\", meltDS)\n",
    "\n",
    "wideDS = meltDS.pivot(index=0, columns='Attribute', values='Values')\n",
    "print(\"\\n CASTING TO WIDE FORMAT \\n\", wideDS)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### WELL DONE! 🜲\n",
    "\n",
    "## Few tips for completing this Tutorial!\n",
    "### 🞸 Remember the Basics\n",
    "### 🞸 Apply the right Attributes and Functions\n",
    "### 🞸 Make use of IDE\n",
    "### 🞸 Better visualisations! \n",
    "\n",
    "### Remember you learnt it first from\n",
    "![logo](http://mitu.co.in/wp-content/uploads/2015/11/logo11.png)\n",
    "#### For Doubts / Suggestions / Feedback / More Explanation you may **contact** us at: contact@mitu.co.in"
   ]
  }
 ],
 "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.5.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}