Skip to content

Instantly share code, notes, and snippets.

@SiddheshKukade

SiddheshKukade/Assignment1.ipynb

Created May 27, 2023 03:06
Show Gist options
  • Save SiddheshKukade/331b87076790308325f3c72716f2a127 to your computer and use it in GitHub Desktop.
Save SiddheshKukade/331b87076790308325f3c72716f2a127 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
Assignment1.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"id": "452e40f2",
"metadata": {
"tags": []
},
"outputs": [],
"source": [
"import pandas as pd\n",
"import matplotlib.pyplot as plt\n",
"import numpy as np"
]
},
{
"cell_type": "code",
"execution_count": 2,
"id": "fc480d48",
"metadata": {
"tags": []
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Page total likes</th>\n",
" <th>Type</th>\n",
" <th>Category</th>\n",
" <th>Post Month</th>\n",
" <th>Post Weekday</th>\n",
" <th>Post Hour</th>\n",
" <th>Paid</th>\n",
" <th>Lifetime Post Total Reach</th>\n",
" <th>Lifetime Post Total Impressions</th>\n",
" <th>Lifetime Engaged Users</th>\n",
" <th>Lifetime Post Consumers</th>\n",
" <th>Lifetime Post Consumptions</th>\n",
" <th>Lifetime Post Impressions by people who have liked your Page</th>\n",
" <th>Lifetime Post reach by people who like your Page</th>\n",
" <th>Lifetime People who have liked your Page and engaged with your post</th>\n",
" <th>comment</th>\n",
" <th>like</th>\n",
" <th>share</th>\n",
" <th>Total Interactions</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>4</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>2752</td>\n",
" <td>5091</td>\n",
" <td>178</td>\n",
" <td>109</td>\n",
" <td>159</td>\n",
" <td>3078</td>\n",
" <td>1640</td>\n",
" <td>119</td>\n",
" <td>4</td>\n",
" <td>79.0</td>\n",
" <td>17.0</td>\n",
" <td>100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>139441</td>\n",
" <td>Status</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>3</td>\n",
" <td>10</td>\n",
" <td>0.0</td>\n",
" <td>10460</td>\n",
" <td>19057</td>\n",
" <td>1457</td>\n",
" <td>1361</td>\n",
" <td>1674</td>\n",
" <td>11710</td>\n",
" <td>6112</td>\n",
" <td>1108</td>\n",
" <td>5</td>\n",
" <td>130.0</td>\n",
" <td>29.0</td>\n",
" <td>164</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>12</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>2413</td>\n",
" <td>4373</td>\n",
" <td>177</td>\n",
" <td>113</td>\n",
" <td>154</td>\n",
" <td>2812</td>\n",
" <td>1503</td>\n",
" <td>132</td>\n",
" <td>0</td>\n",
" <td>66.0</td>\n",
" <td>14.0</td>\n",
" <td>80</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>2</td>\n",
" <td>10</td>\n",
" <td>1.0</td>\n",
" <td>50128</td>\n",
" <td>87991</td>\n",
" <td>2211</td>\n",
" <td>790</td>\n",
" <td>1119</td>\n",
" <td>61027</td>\n",
" <td>32048</td>\n",
" <td>1386</td>\n",
" <td>58</td>\n",
" <td>1572.0</td>\n",
" <td>147.0</td>\n",
" <td>1777</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>7244</td>\n",
" <td>13594</td>\n",
" <td>671</td>\n",
" <td>410</td>\n",
" <td>580</td>\n",
" <td>6228</td>\n",
" <td>3200</td>\n",
" <td>396</td>\n",
" <td>19</td>\n",
" <td>325.0</td>\n",
" <td>49.0</td>\n",
" <td>393</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>495</th>\n",
" <td>85093</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>4684</td>\n",
" <td>7536</td>\n",
" <td>733</td>\n",
" <td>708</td>\n",
" <td>985</td>\n",
" <td>4750</td>\n",
" <td>2876</td>\n",
" <td>392</td>\n",
" <td>5</td>\n",
" <td>53.0</td>\n",
" <td>26.0</td>\n",
" <td>84</td>\n",
" </tr>\n",
" <tr>\n",
" <th>496</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>5</td>\n",
" <td>8</td>\n",
" <td>0.0</td>\n",
" <td>3480</td>\n",
" <td>6229</td>\n",
" <td>537</td>\n",
" <td>508</td>\n",
" <td>687</td>\n",
" <td>3961</td>\n",
" <td>2104</td>\n",
" <td>301</td>\n",
" <td>0</td>\n",
" <td>53.0</td>\n",
" <td>22.0</td>\n",
" <td>75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>497</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>5</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>3778</td>\n",
" <td>7216</td>\n",
" <td>625</td>\n",
" <td>572</td>\n",
" <td>795</td>\n",
" <td>4742</td>\n",
" <td>2388</td>\n",
" <td>363</td>\n",
" <td>4</td>\n",
" <td>93.0</td>\n",
" <td>18.0</td>\n",
" <td>115</td>\n",
" </tr>\n",
" <tr>\n",
" <th>498</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>4</td>\n",
" <td>11</td>\n",
" <td>0.0</td>\n",
" <td>4156</td>\n",
" <td>7564</td>\n",
" <td>626</td>\n",
" <td>574</td>\n",
" <td>832</td>\n",
" <td>4534</td>\n",
" <td>2452</td>\n",
" <td>370</td>\n",
" <td>7</td>\n",
" <td>91.0</td>\n",
" <td>38.0</td>\n",
" <td>136</td>\n",
" </tr>\n",
" <tr>\n",
" <th>499</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>4</td>\n",
" <td>4</td>\n",
" <td>NaN</td>\n",
" <td>4188</td>\n",
" <td>7292</td>\n",
" <td>564</td>\n",
" <td>524</td>\n",
" <td>743</td>\n",
" <td>3861</td>\n",
" <td>2200</td>\n",
" <td>316</td>\n",
" <td>0</td>\n",
" <td>91.0</td>\n",
" <td>28.0</td>\n",
" <td>119</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>500 rows × 19 columns</p>\n",
"</div>"
],
"text/plain": [
" 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",
"495 85093 Photo 3 1 7 2 \n",
"496 81370 Photo 2 1 5 8 \n",
"497 81370 Photo 1 1 5 2 \n",
"498 81370 Photo 3 1 4 11 \n",
"499 81370 Photo 2 1 4 4 \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",
"495 0.0 4684 7536 \n",
"496 0.0 3480 6229 \n",
"497 0.0 3778 7216 \n",
"498 0.0 4156 7564 \n",
"499 NaN 4188 7292 \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",
"495 733 708 \n",
"496 537 508 \n",
"497 625 572 \n",
"498 626 574 \n",
"499 564 524 \n",
"\n",
" Lifetime Post Consumptions \n",
"0 159 \\\n",
"1 1674 \n",
"2 154 \n",
"3 1119 \n",
"4 580 \n",
".. ... \n",
"495 985 \n",
"496 687 \n",
"497 795 \n",
"498 832 \n",
"499 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",
".. ... \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",
".. ... \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",
".. ... \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",
".. ... ... ... ... \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 19 columns]"
]
},
"execution_count": 2,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data = pd.read_csv('dataset_Facebook.csv',delimiter=';')\n",
"data"
]
},
{
"cell_type": "code",
"execution_count": 3,
"id": "53cacea9",
"metadata": {
"tags": []
},
"outputs": [
{
"data": {
"text/plain": [
"(500, 19)"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.shape"
]
},
{
"cell_type": "code",
"execution_count": 4,
"id": "7b159b1d",
"metadata": {
"scrolled": true,
"tags": []
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Page total likes 0\n",
"Type 0\n",
"Category 0\n",
"Post Month 0\n",
"Post Weekday 0\n",
"Post Hour 0\n",
"Paid 1\n",
"Lifetime Post Total Reach 0\n",
"Lifetime Post Total Impressions 0\n",
"Lifetime Engaged Users 0\n",
"Lifetime Post Consumers 0\n",
"Lifetime Post Consumptions 0\n",
"Lifetime Post Impressions by people who have liked your Page 0\n",
"Lifetime Post reach by people who like your Page 0\n",
"Lifetime People who have liked your Page and engaged with your post 0\n",
"comment 0\n",
"like 1\n",
"share 4\n",
"Total Interactions 0\n",
"dtype: int64\n"
]
}
],
"source": [
"print(data.isna().sum())"
]
},
{
"cell_type": "code",
"execution_count": 5,
"id": "f134c6af",
"metadata": {
"tags": []
},
"outputs": [],
"source": [
"data['share'] = data['share'].fillna(value=data['share'].mean())\n",
"data['like'] = data['like'].fillna(value=data['like'].mean())"
]
},
{
"cell_type": "code",
"execution_count": 6,
"id": "b91a8676",
"metadata": {
"tags": []
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"Page total likes 0\n",
"Type 0\n",
"Category 0\n",
"Post Month 0\n",
"Post Weekday 0\n",
"Post Hour 0\n",
"Paid 1\n",
"Lifetime Post Total Reach 0\n",
"Lifetime Post Total Impressions 0\n",
"Lifetime Engaged Users 0\n",
"Lifetime Post Consumers 0\n",
"Lifetime Post Consumptions 0\n",
"Lifetime Post Impressions by people who have liked your Page 0\n",
"Lifetime Post reach by people who like your Page 0\n",
"Lifetime People who have liked your Page and engaged with your post 0\n",
"comment 0\n",
"like 0\n",
"share 0\n",
"Total Interactions 0\n",
"dtype: int64\n"
]
}
],
"source": [
"print(data.isna().sum())"
]
},
{
"cell_type": "code",
"execution_count": 7,
"id": "39a6ad8d",
"metadata": {
"tags": []
},
"outputs": [],
"source": [
"data = data.drop(data.index[499])"
]
},
{
"cell_type": "code",
"execution_count": 8,
"id": "63bfb11a",
"metadata": {
"tags": []
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Page total likes</th>\n",
" <th>Type</th>\n",
" <th>Category</th>\n",
" <th>Post Month</th>\n",
" <th>Post Weekday</th>\n",
" <th>Post Hour</th>\n",
" <th>Paid</th>\n",
" <th>Lifetime Post Total Reach</th>\n",
" <th>Lifetime Post Total Impressions</th>\n",
" <th>Lifetime Engaged Users</th>\n",
" <th>Lifetime Post Consumers</th>\n",
" <th>Lifetime Post Consumptions</th>\n",
" <th>Lifetime Post Impressions by people who have liked your Page</th>\n",
" <th>Lifetime Post reach by people who like your Page</th>\n",
" <th>Lifetime People who have liked your Page and engaged with your post</th>\n",
" <th>comment</th>\n",
" <th>like</th>\n",
" <th>share</th>\n",
" <th>Total Interactions</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>4</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>2752</td>\n",
" <td>5091</td>\n",
" <td>178</td>\n",
" <td>109</td>\n",
" <td>159</td>\n",
" <td>3078</td>\n",
" <td>1640</td>\n",
" <td>119</td>\n",
" <td>4</td>\n",
" <td>79.0</td>\n",
" <td>17.0</td>\n",
" <td>100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>139441</td>\n",
" <td>Status</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>3</td>\n",
" <td>10</td>\n",
" <td>0.0</td>\n",
" <td>10460</td>\n",
" <td>19057</td>\n",
" <td>1457</td>\n",
" <td>1361</td>\n",
" <td>1674</td>\n",
" <td>11710</td>\n",
" <td>6112</td>\n",
" <td>1108</td>\n",
" <td>5</td>\n",
" <td>130.0</td>\n",
" <td>29.0</td>\n",
" <td>164</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>12</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>2413</td>\n",
" <td>4373</td>\n",
" <td>177</td>\n",
" <td>113</td>\n",
" <td>154</td>\n",
" <td>2812</td>\n",
" <td>1503</td>\n",
" <td>132</td>\n",
" <td>0</td>\n",
" <td>66.0</td>\n",
" <td>14.0</td>\n",
" <td>80</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>2</td>\n",
" <td>10</td>\n",
" <td>1.0</td>\n",
" <td>50128</td>\n",
" <td>87991</td>\n",
" <td>2211</td>\n",
" <td>790</td>\n",
" <td>1119</td>\n",
" <td>61027</td>\n",
" <td>32048</td>\n",
" <td>1386</td>\n",
" <td>58</td>\n",
" <td>1572.0</td>\n",
" <td>147.0</td>\n",
" <td>1777</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>7244</td>\n",
" <td>13594</td>\n",
" <td>671</td>\n",
" <td>410</td>\n",
" <td>580</td>\n",
" <td>6228</td>\n",
" <td>3200</td>\n",
" <td>396</td>\n",
" <td>19</td>\n",
" <td>325.0</td>\n",
" <td>49.0</td>\n",
" <td>393</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>494</th>\n",
" <td>85093</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>10</td>\n",
" <td>0.0</td>\n",
" <td>5400</td>\n",
" <td>9218</td>\n",
" <td>810</td>\n",
" <td>756</td>\n",
" <td>1003</td>\n",
" <td>5654</td>\n",
" <td>3230</td>\n",
" <td>422</td>\n",
" <td>10</td>\n",
" <td>125.0</td>\n",
" <td>41.0</td>\n",
" <td>176</td>\n",
" </tr>\n",
" <tr>\n",
" <th>495</th>\n",
" <td>85093</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>4684</td>\n",
" <td>7536</td>\n",
" <td>733</td>\n",
" <td>708</td>\n",
" <td>985</td>\n",
" <td>4750</td>\n",
" <td>2876</td>\n",
" <td>392</td>\n",
" <td>5</td>\n",
" <td>53.0</td>\n",
" <td>26.0</td>\n",
" <td>84</td>\n",
" </tr>\n",
" <tr>\n",
" <th>496</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>5</td>\n",
" <td>8</td>\n",
" <td>0.0</td>\n",
" <td>3480</td>\n",
" <td>6229</td>\n",
" <td>537</td>\n",
" <td>508</td>\n",
" <td>687</td>\n",
" <td>3961</td>\n",
" <td>2104</td>\n",
" <td>301</td>\n",
" <td>0</td>\n",
" <td>53.0</td>\n",
" <td>22.0</td>\n",
" <td>75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>497</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>5</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>3778</td>\n",
" <td>7216</td>\n",
" <td>625</td>\n",
" <td>572</td>\n",
" <td>795</td>\n",
" <td>4742</td>\n",
" <td>2388</td>\n",
" <td>363</td>\n",
" <td>4</td>\n",
" <td>93.0</td>\n",
" <td>18.0</td>\n",
" <td>115</td>\n",
" </tr>\n",
" <tr>\n",
" <th>498</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>4</td>\n",
" <td>11</td>\n",
" <td>0.0</td>\n",
" <td>4156</td>\n",
" <td>7564</td>\n",
" <td>626</td>\n",
" <td>574</td>\n",
" <td>832</td>\n",
" <td>4534</td>\n",
" <td>2452</td>\n",
" <td>370</td>\n",
" <td>7</td>\n",
" <td>91.0</td>\n",
" <td>38.0</td>\n",
" <td>136</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>499 rows × 19 columns</p>\n",
"</div>"
],
"text/plain": [
" 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",
"494 85093 Photo 3 1 7 10 \n",
"495 85093 Photo 3 1 7 2 \n",
"496 81370 Photo 2 1 5 8 \n",
"497 81370 Photo 1 1 5 2 \n",
"498 81370 Photo 3 1 4 11 \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",
"494 0.0 5400 9218 \n",
"495 0.0 4684 7536 \n",
"496 0.0 3480 6229 \n",
"497 0.0 3778 7216 \n",
"498 0.0 4156 7564 \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",
"494 810 756 \n",
"495 733 708 \n",
"496 537 508 \n",
"497 625 572 \n",
"498 626 574 \n",
"\n",
" Lifetime Post Consumptions \n",
"0 159 \\\n",
"1 1674 \n",
"2 154 \n",
"3 1119 \n",
"4 580 \n",
".. ... \n",
"494 1003 \n",
"495 985 \n",
"496 687 \n",
"497 795 \n",
"498 832 \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",
"494 5654 \n",
"495 4750 \n",
"496 3961 \n",
"497 4742 \n",
"498 4534 \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",
"494 3230 \n",
"495 2876 \n",
"496 2104 \n",
"497 2388 \n",
"498 2452 \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",
"494 422 \n",
"495 392 \n",
"496 301 \n",
"497 363 \n",
"498 370 \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",
".. ... ... ... ... \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",
"\n",
"[499 rows x 19 columns]"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data"
]
},
{
"cell_type": "code",
"execution_count": 9,
"id": "0c56722b",
"metadata": {
"tags": []
},
"outputs": [],
"source": [
"from sklearn.model_selection import train_test_split\n",
"data_train,data_test=train_test_split(data,test_size=0.25)"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "8127d060",
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": 10,
"id": "a2858913",
"metadata": {
"tags": []
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Page total likes</th>\n",
" <th>Type</th>\n",
" <th>Category</th>\n",
" <th>Post Month</th>\n",
" <th>Post Weekday</th>\n",
" <th>Post Hour</th>\n",
" <th>Paid</th>\n",
" <th>Lifetime Post Total Reach</th>\n",
" <th>Lifetime Post Total Impressions</th>\n",
" <th>Lifetime Engaged Users</th>\n",
" <th>Lifetime Post Consumers</th>\n",
" <th>Lifetime Post Consumptions</th>\n",
" <th>Lifetime Post Impressions by people who have liked your Page</th>\n",
" <th>Lifetime Post reach by people who like your Page</th>\n",
" <th>Lifetime People who have liked your Page and engaged with your post</th>\n",
" <th>comment</th>\n",
" <th>like</th>\n",
" <th>share</th>\n",
" <th>Total Interactions</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>212</th>\n",
" <td>132201</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>8</td>\n",
" <td>5</td>\n",
" <td>1</td>\n",
" <td>0.0</td>\n",
" <td>1659</td>\n",
" <td>2845</td>\n",
" <td>345</td>\n",
" <td>321</td>\n",
" <td>424</td>\n",
" <td>1604</td>\n",
" <td>915</td>\n",
" <td>239</td>\n",
" <td>3</td>\n",
" <td>36.0</td>\n",
" <td>11.0</td>\n",
" <td>50</td>\n",
" </tr>\n",
" <tr>\n",
" <th>112</th>\n",
" <td>136736</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>10</td>\n",
" <td>6</td>\n",
" <td>4</td>\n",
" <td>0.0</td>\n",
" <td>2428</td>\n",
" <td>4510</td>\n",
" <td>311</td>\n",
" <td>238</td>\n",
" <td>323</td>\n",
" <td>2888</td>\n",
" <td>1560</td>\n",
" <td>236</td>\n",
" <td>4</td>\n",
" <td>117.0</td>\n",
" <td>18.0</td>\n",
" <td>139</td>\n",
" </tr>\n",
" <tr>\n",
" <th>204</th>\n",
" <td>132817</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>8</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>3358</td>\n",
" <td>5682</td>\n",
" <td>394</td>\n",
" <td>323</td>\n",
" <td>523</td>\n",
" <td>4200</td>\n",
" <td>2426</td>\n",
" <td>298</td>\n",
" <td>2</td>\n",
" <td>114.0</td>\n",
" <td>16.0</td>\n",
" <td>132</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td>138353</td>\n",
" <td>Link</td>\n",
" <td>1</td>\n",
" <td>12</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>1925</td>\n",
" <td>3481</td>\n",
" <td>97</td>\n",
" <td>83</td>\n",
" <td>126</td>\n",
" <td>2307</td>\n",
" <td>1180</td>\n",
" <td>77</td>\n",
" <td>6</td>\n",
" <td>18.0</td>\n",
" <td>8.0</td>\n",
" <td>32</td>\n",
" </tr>\n",
" <tr>\n",
" <th>260</th>\n",
" <td>129600</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>7</td>\n",
" <td>2</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>4274</td>\n",
" <td>7948</td>\n",
" <td>701</td>\n",
" <td>638</td>\n",
" <td>1020</td>\n",
" <td>5936</td>\n",
" <td>3164</td>\n",
" <td>460</td>\n",
" <td>0</td>\n",
" <td>128.0</td>\n",
" <td>15.0</td>\n",
" <td>143</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>109</th>\n",
" <td>136736</td>\n",
" <td>Status</td>\n",
" <td>2</td>\n",
" <td>10</td>\n",
" <td>7</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>13872</td>\n",
" <td>27468</td>\n",
" <td>2664</td>\n",
" <td>2570</td>\n",
" <td>3395</td>\n",
" <td>20198</td>\n",
" <td>10432</td>\n",
" <td>2252</td>\n",
" <td>4</td>\n",
" <td>217.0</td>\n",
" <td>50.0</td>\n",
" <td>271</td>\n",
" </tr>\n",
" <tr>\n",
" <th>197</th>\n",
" <td>133594</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>8</td>\n",
" <td>5</td>\n",
" <td>13</td>\n",
" <td>0.0</td>\n",
" <td>1920</td>\n",
" <td>3124</td>\n",
" <td>365</td>\n",
" <td>331</td>\n",
" <td>428</td>\n",
" <td>2541</td>\n",
" <td>1519</td>\n",
" <td>251</td>\n",
" <td>1</td>\n",
" <td>52.0</td>\n",
" <td>7.0</td>\n",
" <td>60</td>\n",
" </tr>\n",
" <tr>\n",
" <th>140</th>\n",
" <td>136013</td>\n",
" <td>Link</td>\n",
" <td>1</td>\n",
" <td>10</td>\n",
" <td>4</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>68992</td>\n",
" <td>229733</td>\n",
" <td>1032</td>\n",
" <td>975</td>\n",
" <td>1345</td>\n",
" <td>17842</td>\n",
" <td>8032</td>\n",
" <td>635</td>\n",
" <td>15</td>\n",
" <td>143.0</td>\n",
" <td>44.0</td>\n",
" <td>202</td>\n",
" </tr>\n",
" <tr>\n",
" <th>395</th>\n",
" <td>107907</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>4</td>\n",
" <td>6</td>\n",
" <td>9</td>\n",
" <td>0.0</td>\n",
" <td>3544</td>\n",
" <td>6156</td>\n",
" <td>509</td>\n",
" <td>482</td>\n",
" <td>701</td>\n",
" <td>5011</td>\n",
" <td>2746</td>\n",
" <td>387</td>\n",
" <td>1</td>\n",
" <td>51.0</td>\n",
" <td>6.0</td>\n",
" <td>58</td>\n",
" </tr>\n",
" <tr>\n",
" <th>51</th>\n",
" <td>138329</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>11</td>\n",
" <td>1</td>\n",
" <td>3</td>\n",
" <td>1.0</td>\n",
" <td>25248</td>\n",
" <td>40125</td>\n",
" <td>726</td>\n",
" <td>467</td>\n",
" <td>863</td>\n",
" <td>16132</td>\n",
" <td>8608</td>\n",
" <td>451</td>\n",
" <td>24</td>\n",
" <td>285.0</td>\n",
" <td>28.0</td>\n",
" <td>337</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>374 rows × 19 columns</p>\n",
"</div>"
],
"text/plain": [
" Page total likes Type Category Post Month Post Weekday Post Hour \n",
"212 132201 Photo 2 8 5 1 \\\n",
"112 136736 Photo 2 10 6 4 \n",
"204 132817 Photo 3 8 2 3 \n",
"47 138353 Link 1 12 3 2 \n",
"260 129600 Photo 2 7 2 7 \n",
".. ... ... ... ... ... ... \n",
"109 136736 Status 2 10 7 3 \n",
"197 133594 Photo 2 8 5 13 \n",
"140 136013 Link 1 10 4 3 \n",
"395 107907 Photo 1 4 6 9 \n",
"51 138329 Photo 1 11 1 3 \n",
"\n",
" Paid Lifetime Post Total Reach Lifetime Post Total Impressions \n",
"212 0.0 1659 2845 \\\n",
"112 0.0 2428 4510 \n",
"204 0.0 3358 5682 \n",
"47 0.0 1925 3481 \n",
"260 1.0 4274 7948 \n",
".. ... ... ... \n",
"109 0.0 13872 27468 \n",
"197 0.0 1920 3124 \n",
"140 0.0 68992 229733 \n",
"395 0.0 3544 6156 \n",
"51 1.0 25248 40125 \n",
"\n",
" Lifetime Engaged Users Lifetime Post Consumers \n",
"212 345 321 \\\n",
"112 311 238 \n",
"204 394 323 \n",
"47 97 83 \n",
"260 701 638 \n",
".. ... ... \n",
"109 2664 2570 \n",
"197 365 331 \n",
"140 1032 975 \n",
"395 509 482 \n",
"51 726 467 \n",
"\n",
" Lifetime Post Consumptions \n",
"212 424 \\\n",
"112 323 \n",
"204 523 \n",
"47 126 \n",
"260 1020 \n",
".. ... \n",
"109 3395 \n",
"197 428 \n",
"140 1345 \n",
"395 701 \n",
"51 863 \n",
"\n",
" Lifetime Post Impressions by people who have liked your Page \n",
"212 1604 \\\n",
"112 2888 \n",
"204 4200 \n",
"47 2307 \n",
"260 5936 \n",
".. ... \n",
"109 20198 \n",
"197 2541 \n",
"140 17842 \n",
"395 5011 \n",
"51 16132 \n",
"\n",
" Lifetime Post reach by people who like your Page \n",
"212 915 \\\n",
"112 1560 \n",
"204 2426 \n",
"47 1180 \n",
"260 3164 \n",
".. ... \n",
"109 10432 \n",
"197 1519 \n",
"140 8032 \n",
"395 2746 \n",
"51 8608 \n",
"\n",
" Lifetime People who have liked your Page and engaged with your post \n",
"212 239 \\\n",
"112 236 \n",
"204 298 \n",
"47 77 \n",
"260 460 \n",
".. ... \n",
"109 2252 \n",
"197 251 \n",
"140 635 \n",
"395 387 \n",
"51 451 \n",
"\n",
" comment like share Total Interactions \n",
"212 3 36.0 11.0 50 \n",
"112 4 117.0 18.0 139 \n",
"204 2 114.0 16.0 132 \n",
"47 6 18.0 8.0 32 \n",
"260 0 128.0 15.0 143 \n",
".. ... ... ... ... \n",
"109 4 217.0 50.0 271 \n",
"197 1 52.0 7.0 60 \n",
"140 15 143.0 44.0 202 \n",
"395 1 51.0 6.0 58 \n",
"51 24 285.0 28.0 337 \n",
"\n",
"[374 rows x 19 columns]"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#train subset\n",
"data_train"
]
},
{
"cell_type": "code",
"execution_count": 11,
"id": "5ddeb1bf",
"metadata": {
"tags": []
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Page total likes</th>\n",
" <th>Type</th>\n",
" <th>Category</th>\n",
" <th>Post Month</th>\n",
" <th>Post Weekday</th>\n",
" <th>Post Hour</th>\n",
" <th>Paid</th>\n",
" <th>Lifetime Post Total Reach</th>\n",
" <th>Lifetime Post Total Impressions</th>\n",
" <th>Lifetime Engaged Users</th>\n",
" <th>Lifetime Post Consumers</th>\n",
" <th>Lifetime Post Consumptions</th>\n",
" <th>Lifetime Post Impressions by people who have liked your Page</th>\n",
" <th>Lifetime Post reach by people who like your Page</th>\n",
" <th>Lifetime People who have liked your Page and engaged with your post</th>\n",
" <th>comment</th>\n",
" <th>like</th>\n",
" <th>share</th>\n",
" <th>Total Interactions</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>125</th>\n",
" <td>136393</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>10</td>\n",
" <td>7</td>\n",
" <td>5</td>\n",
" <td>0.0</td>\n",
" <td>677</td>\n",
" <td>1240</td>\n",
" <td>236</td>\n",
" <td>228</td>\n",
" <td>264</td>\n",
" <td>1098</td>\n",
" <td>580</td>\n",
" <td>196</td>\n",
" <td>0</td>\n",
" <td>7.0</td>\n",
" <td>2.0</td>\n",
" <td>9</td>\n",
" </tr>\n",
" <tr>\n",
" <th>480</th>\n",
" <td>86909</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>4</td>\n",
" <td>11</td>\n",
" <td>0.0</td>\n",
" <td>11484</td>\n",
" <td>20696</td>\n",
" <td>1762</td>\n",
" <td>1635</td>\n",
" <td>2741</td>\n",
" <td>8774</td>\n",
" <td>5124</td>\n",
" <td>722</td>\n",
" <td>56</td>\n",
" <td>360.0</td>\n",
" <td>99.0</td>\n",
" <td>515</td>\n",
" </tr>\n",
" <tr>\n",
" <th>396</th>\n",
" <td>107907</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>4</td>\n",
" <td>6</td>\n",
" <td>3</td>\n",
" <td>1.0</td>\n",
" <td>3286</td>\n",
" <td>6276</td>\n",
" <td>504</td>\n",
" <td>458</td>\n",
" <td>633</td>\n",
" <td>4010</td>\n",
" <td>2162</td>\n",
" <td>376</td>\n",
" <td>1</td>\n",
" <td>87.0</td>\n",
" <td>27.0</td>\n",
" <td>115</td>\n",
" </tr>\n",
" <tr>\n",
" <th>450</th>\n",
" <td>93577</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>6</td>\n",
" <td>6</td>\n",
" <td>0.0</td>\n",
" <td>20528</td>\n",
" <td>33000</td>\n",
" <td>1876</td>\n",
" <td>1800</td>\n",
" <td>2654</td>\n",
" <td>14636</td>\n",
" <td>7632</td>\n",
" <td>656</td>\n",
" <td>3</td>\n",
" <td>148.0</td>\n",
" <td>21.0</td>\n",
" <td>172</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>12</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>2413</td>\n",
" <td>4373</td>\n",
" <td>177</td>\n",
" <td>113</td>\n",
" <td>154</td>\n",
" <td>2812</td>\n",
" <td>1503</td>\n",
" <td>132</td>\n",
" <td>0</td>\n",
" <td>66.0</td>\n",
" <td>14.0</td>\n",
" <td>80</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>394</th>\n",
" <td>107907</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>13</td>\n",
" <td>0.0</td>\n",
" <td>4240</td>\n",
" <td>7057</td>\n",
" <td>601</td>\n",
" <td>542</td>\n",
" <td>730</td>\n",
" <td>5026</td>\n",
" <td>2868</td>\n",
" <td>461</td>\n",
" <td>3</td>\n",
" <td>114.0</td>\n",
" <td>21.0</td>\n",
" <td>138</td>\n",
" </tr>\n",
" <tr>\n",
" <th>171</th>\n",
" <td>135195</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>9</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>1543</td>\n",
" <td>2874</td>\n",
" <td>360</td>\n",
" <td>334</td>\n",
" <td>463</td>\n",
" <td>2373</td>\n",
" <td>1228</td>\n",
" <td>267</td>\n",
" <td>2</td>\n",
" <td>30.0</td>\n",
" <td>6.0</td>\n",
" <td>38</td>\n",
" </tr>\n",
" <tr>\n",
" <th>76</th>\n",
" <td>137893</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>11</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>1228</td>\n",
" <td>2392</td>\n",
" <td>17</td>\n",
" <td>17</td>\n",
" <td>19</td>\n",
" <td>2392</td>\n",
" <td>1228</td>\n",
" <td>17</td>\n",
" <td>0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td>138353</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>12</td>\n",
" <td>4</td>\n",
" <td>11</td>\n",
" <td>0.0</td>\n",
" <td>4284</td>\n",
" <td>8387</td>\n",
" <td>355</td>\n",
" <td>316</td>\n",
" <td>513</td>\n",
" <td>7283</td>\n",
" <td>3634</td>\n",
" <td>291</td>\n",
" <td>0</td>\n",
" <td>47.0</td>\n",
" <td>11.0</td>\n",
" <td>58</td>\n",
" </tr>\n",
" <tr>\n",
" <th>186</th>\n",
" <td>134879</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>9</td>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.0</td>\n",
" <td>4048</td>\n",
" <td>7217</td>\n",
" <td>544</td>\n",
" <td>405</td>\n",
" <td>602</td>\n",
" <td>4046</td>\n",
" <td>2280</td>\n",
" <td>368</td>\n",
" <td>5</td>\n",
" <td>223.0</td>\n",
" <td>35.0</td>\n",
" <td>263</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>125 rows × 19 columns</p>\n",
"</div>"
],
"text/plain": [
" Page total likes Type Category Post Month Post Weekday Post Hour \n",
"125 136393 Photo 1 10 7 5 \\\n",
"480 86909 Photo 2 1 4 11 \n",
"396 107907 Photo 3 4 6 3 \n",
"450 93577 Photo 1 2 6 6 \n",
"2 139441 Photo 3 12 3 3 \n",
".. ... ... ... ... ... ... \n",
"394 107907 Photo 3 4 7 13 \n",
"171 135195 Photo 1 9 2 2 \n",
"76 137893 Photo 1 11 3 2 \n",
"44 138353 Photo 1 12 4 11 \n",
"186 134879 Photo 2 9 1 6 \n",
"\n",
" Paid Lifetime Post Total Reach Lifetime Post Total Impressions \n",
"125 0.0 677 1240 \\\n",
"480 0.0 11484 20696 \n",
"396 1.0 3286 6276 \n",
"450 0.0 20528 33000 \n",
"2 0.0 2413 4373 \n",
".. ... ... ... \n",
"394 0.0 4240 7057 \n",
"171 0.0 1543 2874 \n",
"76 0.0 1228 2392 \n",
"44 0.0 4284 8387 \n",
"186 0.0 4048 7217 \n",
"\n",
" Lifetime Engaged Users Lifetime Post Consumers \n",
"125 236 228 \\\n",
"480 1762 1635 \n",
"396 504 458 \n",
"450 1876 1800 \n",
"2 177 113 \n",
".. ... ... \n",
"394 601 542 \n",
"171 360 334 \n",
"76 17 17 \n",
"44 355 316 \n",
"186 544 405 \n",
"\n",
" Lifetime Post Consumptions \n",
"125 264 \\\n",
"480 2741 \n",
"396 633 \n",
"450 2654 \n",
"2 154 \n",
".. ... \n",
"394 730 \n",
"171 463 \n",
"76 19 \n",
"44 513 \n",
"186 602 \n",
"\n",
" Lifetime Post Impressions by people who have liked your Page \n",
"125 1098 \\\n",
"480 8774 \n",
"396 4010 \n",
"450 14636 \n",
"2 2812 \n",
".. ... \n",
"394 5026 \n",
"171 2373 \n",
"76 2392 \n",
"44 7283 \n",
"186 4046 \n",
"\n",
" Lifetime Post reach by people who like your Page \n",
"125 580 \\\n",
"480 5124 \n",
"396 2162 \n",
"450 7632 \n",
"2 1503 \n",
".. ... \n",
"394 2868 \n",
"171 1228 \n",
"76 1228 \n",
"44 3634 \n",
"186 2280 \n",
"\n",
" Lifetime People who have liked your Page and engaged with your post \n",
"125 196 \\\n",
"480 722 \n",
"396 376 \n",
"450 656 \n",
"2 132 \n",
".. ... \n",
"394 461 \n",
"171 267 \n",
"76 17 \n",
"44 291 \n",
"186 368 \n",
"\n",
" comment like share Total Interactions \n",
"125 0 7.0 2.0 9 \n",
"480 56 360.0 99.0 515 \n",
"396 1 87.0 27.0 115 \n",
"450 3 148.0 21.0 172 \n",
"2 0 66.0 14.0 80 \n",
".. ... ... ... ... \n",
"394 3 114.0 21.0 138 \n",
"171 2 30.0 6.0 38 \n",
"76 0 0.0 0.0 0 \n",
"44 0 47.0 11.0 58 \n",
"186 5 223.0 35.0 263 \n",
"\n",
"[125 rows x 19 columns]"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#test subset\n",
"data_test"
]
},
{
"cell_type": "code",
"execution_count": 12,
"id": "48c4b063",
"metadata": {
"tags": []
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Page total likes</th>\n",
" <th>Type</th>\n",
" <th>Category</th>\n",
" <th>Post Month</th>\n",
" <th>Post Weekday</th>\n",
" <th>Post Hour</th>\n",
" <th>Paid</th>\n",
" <th>Lifetime Post Total Reach</th>\n",
" <th>Lifetime Post Total Impressions</th>\n",
" <th>Lifetime Engaged Users</th>\n",
" <th>Lifetime Post Consumers</th>\n",
" <th>Lifetime Post Consumptions</th>\n",
" <th>Lifetime Post Impressions by people who have liked your Page</th>\n",
" <th>Lifetime Post reach by people who like your Page</th>\n",
" <th>Lifetime People who have liked your Page and engaged with your post</th>\n",
" <th>comment</th>\n",
" <th>like</th>\n",
" <th>share</th>\n",
" <th>Total Interactions</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>212</th>\n",
" <td>132201</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>8</td>\n",
" <td>5</td>\n",
" <td>1</td>\n",
" <td>0.0</td>\n",
" <td>1659</td>\n",
" <td>2845</td>\n",
" <td>345</td>\n",
" <td>321</td>\n",
" <td>424</td>\n",
" <td>1604</td>\n",
" <td>915</td>\n",
" <td>239</td>\n",
" <td>3</td>\n",
" <td>36.0</td>\n",
" <td>11.0</td>\n",
" <td>50</td>\n",
" </tr>\n",
" <tr>\n",
" <th>112</th>\n",
" <td>136736</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>10</td>\n",
" <td>6</td>\n",
" <td>4</td>\n",
" <td>0.0</td>\n",
" <td>2428</td>\n",
" <td>4510</td>\n",
" <td>311</td>\n",
" <td>238</td>\n",
" <td>323</td>\n",
" <td>2888</td>\n",
" <td>1560</td>\n",
" <td>236</td>\n",
" <td>4</td>\n",
" <td>117.0</td>\n",
" <td>18.0</td>\n",
" <td>139</td>\n",
" </tr>\n",
" <tr>\n",
" <th>204</th>\n",
" <td>132817</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>8</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>3358</td>\n",
" <td>5682</td>\n",
" <td>394</td>\n",
" <td>323</td>\n",
" <td>523</td>\n",
" <td>4200</td>\n",
" <td>2426</td>\n",
" <td>298</td>\n",
" <td>2</td>\n",
" <td>114.0</td>\n",
" <td>16.0</td>\n",
" <td>132</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td>138353</td>\n",
" <td>Link</td>\n",
" <td>1</td>\n",
" <td>12</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>1925</td>\n",
" <td>3481</td>\n",
" <td>97</td>\n",
" <td>83</td>\n",
" <td>126</td>\n",
" <td>2307</td>\n",
" <td>1180</td>\n",
" <td>77</td>\n",
" <td>6</td>\n",
" <td>18.0</td>\n",
" <td>8.0</td>\n",
" <td>32</td>\n",
" </tr>\n",
" <tr>\n",
" <th>260</th>\n",
" <td>129600</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>7</td>\n",
" <td>2</td>\n",
" <td>7</td>\n",
" <td>1.0</td>\n",
" <td>4274</td>\n",
" <td>7948</td>\n",
" <td>701</td>\n",
" <td>638</td>\n",
" <td>1020</td>\n",
" <td>5936</td>\n",
" <td>3164</td>\n",
" <td>460</td>\n",
" <td>0</td>\n",
" <td>128.0</td>\n",
" <td>15.0</td>\n",
" <td>143</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>394</th>\n",
" <td>107907</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" <td>13</td>\n",
" <td>0.0</td>\n",
" <td>4240</td>\n",
" <td>7057</td>\n",
" <td>601</td>\n",
" <td>542</td>\n",
" <td>730</td>\n",
" <td>5026</td>\n",
" <td>2868</td>\n",
" <td>461</td>\n",
" <td>3</td>\n",
" <td>114.0</td>\n",
" <td>21.0</td>\n",
" <td>138</td>\n",
" </tr>\n",
" <tr>\n",
" <th>171</th>\n",
" <td>135195</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>9</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>1543</td>\n",
" <td>2874</td>\n",
" <td>360</td>\n",
" <td>334</td>\n",
" <td>463</td>\n",
" <td>2373</td>\n",
" <td>1228</td>\n",
" <td>267</td>\n",
" <td>2</td>\n",
" <td>30.0</td>\n",
" <td>6.0</td>\n",
" <td>38</td>\n",
" </tr>\n",
" <tr>\n",
" <th>76</th>\n",
" <td>137893</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>11</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>1228</td>\n",
" <td>2392</td>\n",
" <td>17</td>\n",
" <td>17</td>\n",
" <td>19</td>\n",
" <td>2392</td>\n",
" <td>1228</td>\n",
" <td>17</td>\n",
" <td>0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td>138353</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>12</td>\n",
" <td>4</td>\n",
" <td>11</td>\n",
" <td>0.0</td>\n",
" <td>4284</td>\n",
" <td>8387</td>\n",
" <td>355</td>\n",
" <td>316</td>\n",
" <td>513</td>\n",
" <td>7283</td>\n",
" <td>3634</td>\n",
" <td>291</td>\n",
" <td>0</td>\n",
" <td>47.0</td>\n",
" <td>11.0</td>\n",
" <td>58</td>\n",
" </tr>\n",
" <tr>\n",
" <th>186</th>\n",
" <td>134879</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>9</td>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.0</td>\n",
" <td>4048</td>\n",
" <td>7217</td>\n",
" <td>544</td>\n",
" <td>405</td>\n",
" <td>602</td>\n",
" <td>4046</td>\n",
" <td>2280</td>\n",
" <td>368</td>\n",
" <td>5</td>\n",
" <td>223.0</td>\n",
" <td>35.0</td>\n",
" <td>263</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>499 rows × 19 columns</p>\n",
"</div>"
],
"text/plain": [
" Page total likes Type Category Post Month Post Weekday Post Hour \n",
"212 132201 Photo 2 8 5 1 \\\n",
"112 136736 Photo 2 10 6 4 \n",
"204 132817 Photo 3 8 2 3 \n",
"47 138353 Link 1 12 3 2 \n",
"260 129600 Photo 2 7 2 7 \n",
".. ... ... ... ... ... ... \n",
"394 107907 Photo 3 4 7 13 \n",
"171 135195 Photo 1 9 2 2 \n",
"76 137893 Photo 1 11 3 2 \n",
"44 138353 Photo 1 12 4 11 \n",
"186 134879 Photo 2 9 1 6 \n",
"\n",
" Paid Lifetime Post Total Reach Lifetime Post Total Impressions \n",
"212 0.0 1659 2845 \\\n",
"112 0.0 2428 4510 \n",
"204 0.0 3358 5682 \n",
"47 0.0 1925 3481 \n",
"260 1.0 4274 7948 \n",
".. ... ... ... \n",
"394 0.0 4240 7057 \n",
"171 0.0 1543 2874 \n",
"76 0.0 1228 2392 \n",
"44 0.0 4284 8387 \n",
"186 0.0 4048 7217 \n",
"\n",
" Lifetime Engaged Users Lifetime Post Consumers \n",
"212 345 321 \\\n",
"112 311 238 \n",
"204 394 323 \n",
"47 97 83 \n",
"260 701 638 \n",
".. ... ... \n",
"394 601 542 \n",
"171 360 334 \n",
"76 17 17 \n",
"44 355 316 \n",
"186 544 405 \n",
"\n",
" Lifetime Post Consumptions \n",
"212 424 \\\n",
"112 323 \n",
"204 523 \n",
"47 126 \n",
"260 1020 \n",
".. ... \n",
"394 730 \n",
"171 463 \n",
"76 19 \n",
"44 513 \n",
"186 602 \n",
"\n",
" Lifetime Post Impressions by people who have liked your Page \n",
"212 1604 \\\n",
"112 2888 \n",
"204 4200 \n",
"47 2307 \n",
"260 5936 \n",
".. ... \n",
"394 5026 \n",
"171 2373 \n",
"76 2392 \n",
"44 7283 \n",
"186 4046 \n",
"\n",
" Lifetime Post reach by people who like your Page \n",
"212 915 \\\n",
"112 1560 \n",
"204 2426 \n",
"47 1180 \n",
"260 3164 \n",
".. ... \n",
"394 2868 \n",
"171 1228 \n",
"76 1228 \n",
"44 3634 \n",
"186 2280 \n",
"\n",
" Lifetime People who have liked your Page and engaged with your post \n",
"212 239 \\\n",
"112 236 \n",
"204 298 \n",
"47 77 \n",
"260 460 \n",
".. ... \n",
"394 461 \n",
"171 267 \n",
"76 17 \n",
"44 291 \n",
"186 368 \n",
"\n",
" comment like share Total Interactions \n",
"212 3 36.0 11.0 50 \n",
"112 4 117.0 18.0 139 \n",
"204 2 114.0 16.0 132 \n",
"47 6 18.0 8.0 32 \n",
"260 0 128.0 15.0 143 \n",
".. ... ... ... ... \n",
"394 3 114.0 21.0 138 \n",
"171 2 30.0 6.0 38 \n",
"76 0 0.0 0.0 0 \n",
"44 0 47.0 11.0 58 \n",
"186 5 223.0 35.0 263 \n",
"\n",
"[499 rows x 19 columns]"
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"train_test_merge = pd.concat([data_train,data_test])\n",
"train_test_merge"
]
},
{
"cell_type": "code",
"execution_count": 13,
"id": "1d17db84",
"metadata": {
"tags": []
},
"outputs": [],
"source": [
"#Row-wise subsets \n",
"row_subset_1 = data.iloc[0:249,:]\n",
"row_subset_2 = data.iloc[248:,:]"
]
},
{
"cell_type": "code",
"execution_count": 14,
"id": "391a1d6e",
"metadata": {
"tags": []
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Page total likes</th>\n",
" <th>Type</th>\n",
" <th>Category</th>\n",
" <th>Post Month</th>\n",
" <th>Post Weekday</th>\n",
" <th>Post Hour</th>\n",
" <th>Paid</th>\n",
" <th>Lifetime Post Total Reach</th>\n",
" <th>Lifetime Post Total Impressions</th>\n",
" <th>Lifetime Engaged Users</th>\n",
" <th>Lifetime Post Consumers</th>\n",
" <th>Lifetime Post Consumptions</th>\n",
" <th>Lifetime Post Impressions by people who have liked your Page</th>\n",
" <th>Lifetime Post reach by people who like your Page</th>\n",
" <th>Lifetime People who have liked your Page and engaged with your post</th>\n",
" <th>comment</th>\n",
" <th>like</th>\n",
" <th>share</th>\n",
" <th>Total Interactions</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>4</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>2752</td>\n",
" <td>5091</td>\n",
" <td>178</td>\n",
" <td>109</td>\n",
" <td>159</td>\n",
" <td>3078</td>\n",
" <td>1640</td>\n",
" <td>119</td>\n",
" <td>4</td>\n",
" <td>79.0</td>\n",
" <td>17.0</td>\n",
" <td>100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>139441</td>\n",
" <td>Status</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>3</td>\n",
" <td>10</td>\n",
" <td>0.0</td>\n",
" <td>10460</td>\n",
" <td>19057</td>\n",
" <td>1457</td>\n",
" <td>1361</td>\n",
" <td>1674</td>\n",
" <td>11710</td>\n",
" <td>6112</td>\n",
" <td>1108</td>\n",
" <td>5</td>\n",
" <td>130.0</td>\n",
" <td>29.0</td>\n",
" <td>164</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>12</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>2413</td>\n",
" <td>4373</td>\n",
" <td>177</td>\n",
" <td>113</td>\n",
" <td>154</td>\n",
" <td>2812</td>\n",
" <td>1503</td>\n",
" <td>132</td>\n",
" <td>0</td>\n",
" <td>66.0</td>\n",
" <td>14.0</td>\n",
" <td>80</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>2</td>\n",
" <td>10</td>\n",
" <td>1.0</td>\n",
" <td>50128</td>\n",
" <td>87991</td>\n",
" <td>2211</td>\n",
" <td>790</td>\n",
" <td>1119</td>\n",
" <td>61027</td>\n",
" <td>32048</td>\n",
" <td>1386</td>\n",
" <td>58</td>\n",
" <td>1572.0</td>\n",
" <td>147.0</td>\n",
" <td>1777</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>7244</td>\n",
" <td>13594</td>\n",
" <td>671</td>\n",
" <td>410</td>\n",
" <td>580</td>\n",
" <td>6228</td>\n",
" <td>3200</td>\n",
" <td>396</td>\n",
" <td>19</td>\n",
" <td>325.0</td>\n",
" <td>49.0</td>\n",
" <td>393</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>244</th>\n",
" <td>130791</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>7</td>\n",
" <td>3</td>\n",
" <td>5</td>\n",
" <td>1.0</td>\n",
" <td>180480</td>\n",
" <td>319133</td>\n",
" <td>8072</td>\n",
" <td>4010</td>\n",
" <td>6242</td>\n",
" <td>108752</td>\n",
" <td>51456</td>\n",
" <td>3316</td>\n",
" <td>372</td>\n",
" <td>5172.0</td>\n",
" <td>790.0</td>\n",
" <td>6334</td>\n",
" </tr>\n",
" <tr>\n",
" <th>245</th>\n",
" <td>130791</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>2</td>\n",
" <td>13</td>\n",
" <td>0.0</td>\n",
" <td>44464</td>\n",
" <td>66824</td>\n",
" <td>1052</td>\n",
" <td>930</td>\n",
" <td>1571</td>\n",
" <td>22904</td>\n",
" <td>14080</td>\n",
" <td>559</td>\n",
" <td>4</td>\n",
" <td>154.0</td>\n",
" <td>30.0</td>\n",
" <td>188</td>\n",
" </tr>\n",
" <tr>\n",
" <th>246</th>\n",
" <td>130791</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>7</td>\n",
" <td>2</td>\n",
" <td>8</td>\n",
" <td>0.0</td>\n",
" <td>2881</td>\n",
" <td>5188</td>\n",
" <td>550</td>\n",
" <td>503</td>\n",
" <td>730</td>\n",
" <td>3840</td>\n",
" <td>2040</td>\n",
" <td>323</td>\n",
" <td>0</td>\n",
" <td>73.0</td>\n",
" <td>15.0</td>\n",
" <td>88</td>\n",
" </tr>\n",
" <tr>\n",
" <th>247</th>\n",
" <td>129600</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>7</td>\n",
" <td>1</td>\n",
" <td>12</td>\n",
" <td>0.0</td>\n",
" <td>3460</td>\n",
" <td>6503</td>\n",
" <td>541</td>\n",
" <td>482</td>\n",
" <td>667</td>\n",
" <td>4371</td>\n",
" <td>2260</td>\n",
" <td>314</td>\n",
" <td>0</td>\n",
" <td>96.0</td>\n",
" <td>19.0</td>\n",
" <td>115</td>\n",
" </tr>\n",
" <tr>\n",
" <th>248</th>\n",
" <td>129600</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>7</td>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.0</td>\n",
" <td>3406</td>\n",
" <td>5656</td>\n",
" <td>571</td>\n",
" <td>512</td>\n",
" <td>731</td>\n",
" <td>4446</td>\n",
" <td>2598</td>\n",
" <td>355</td>\n",
" <td>1</td>\n",
" <td>98.0</td>\n",
" <td>19.0</td>\n",
" <td>118</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>249 rows × 19 columns</p>\n",
"</div>"
],
"text/plain": [
" 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",
"244 130791 Photo 2 7 3 5 \n",
"245 130791 Photo 1 7 2 13 \n",
"246 130791 Photo 2 7 2 8 \n",
"247 129600 Photo 2 7 1 12 \n",
"248 129600 Photo 3 7 1 6 \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",
"244 1.0 180480 319133 \n",
"245 0.0 44464 66824 \n",
"246 0.0 2881 5188 \n",
"247 0.0 3460 6503 \n",
"248 0.0 3406 5656 \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",
"244 8072 4010 \n",
"245 1052 930 \n",
"246 550 503 \n",
"247 541 482 \n",
"248 571 512 \n",
"\n",
" Lifetime Post Consumptions \n",
"0 159 \\\n",
"1 1674 \n",
"2 154 \n",
"3 1119 \n",
"4 580 \n",
".. ... \n",
"244 6242 \n",
"245 1571 \n",
"246 730 \n",
"247 667 \n",
"248 731 \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",
"244 108752 \n",
"245 22904 \n",
"246 3840 \n",
"247 4371 \n",
"248 4446 \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",
"244 51456 \n",
"245 14080 \n",
"246 2040 \n",
"247 2260 \n",
"248 2598 \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",
"244 3316 \n",
"245 559 \n",
"246 323 \n",
"247 314 \n",
"248 355 \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",
".. ... ... ... ... \n",
"244 372 5172.0 790.0 6334 \n",
"245 4 154.0 30.0 188 \n",
"246 0 73.0 15.0 88 \n",
"247 0 96.0 19.0 115 \n",
"248 1 98.0 19.0 118 \n",
"\n",
"[249 rows x 19 columns]"
]
},
"execution_count": 14,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"row_subset_1"
]
},
{
"cell_type": "code",
"execution_count": 15,
"id": "fc0b9456",
"metadata": {
"tags": []
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Page total likes</th>\n",
" <th>Type</th>\n",
" <th>Category</th>\n",
" <th>Post Month</th>\n",
" <th>Post Weekday</th>\n",
" <th>Post Hour</th>\n",
" <th>Paid</th>\n",
" <th>Lifetime Post Total Reach</th>\n",
" <th>Lifetime Post Total Impressions</th>\n",
" <th>Lifetime Engaged Users</th>\n",
" <th>Lifetime Post Consumers</th>\n",
" <th>Lifetime Post Consumptions</th>\n",
" <th>Lifetime Post Impressions by people who have liked your Page</th>\n",
" <th>Lifetime Post reach by people who like your Page</th>\n",
" <th>Lifetime People who have liked your Page and engaged with your post</th>\n",
" <th>comment</th>\n",
" <th>like</th>\n",
" <th>share</th>\n",
" <th>Total Interactions</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>248</th>\n",
" <td>129600</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>7</td>\n",
" <td>1</td>\n",
" <td>6</td>\n",
" <td>0.0</td>\n",
" <td>3406</td>\n",
" <td>5656</td>\n",
" <td>571</td>\n",
" <td>512</td>\n",
" <td>731</td>\n",
" <td>4446</td>\n",
" <td>2598</td>\n",
" <td>355</td>\n",
" <td>1</td>\n",
" <td>98.0</td>\n",
" <td>19.0</td>\n",
" <td>118</td>\n",
" </tr>\n",
" <tr>\n",
" <th>249</th>\n",
" <td>129600</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>7</td>\n",
" <td>7</td>\n",
" <td>11</td>\n",
" <td>1.0</td>\n",
" <td>2602</td>\n",
" <td>4349</td>\n",
" <td>479</td>\n",
" <td>444</td>\n",
" <td>588</td>\n",
" <td>3342</td>\n",
" <td>1946</td>\n",
" <td>287</td>\n",
" <td>1</td>\n",
" <td>53.0</td>\n",
" <td>14.0</td>\n",
" <td>68</td>\n",
" </tr>\n",
" <tr>\n",
" <th>250</th>\n",
" <td>129600</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>7</td>\n",
" <td>6</td>\n",
" <td>1.0</td>\n",
" <td>5848</td>\n",
" <td>9068</td>\n",
" <td>622</td>\n",
" <td>570</td>\n",
" <td>795</td>\n",
" <td>6651</td>\n",
" <td>4212</td>\n",
" <td>383</td>\n",
" <td>4</td>\n",
" <td>71.0</td>\n",
" <td>10.0</td>\n",
" <td>85</td>\n",
" </tr>\n",
" <tr>\n",
" <th>251</th>\n",
" <td>129600</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>6</td>\n",
" <td>11</td>\n",
" <td>0.0</td>\n",
" <td>26944</td>\n",
" <td>43464</td>\n",
" <td>877</td>\n",
" <td>740</td>\n",
" <td>1097</td>\n",
" <td>20270</td>\n",
" <td>10208</td>\n",
" <td>563</td>\n",
" <td>6</td>\n",
" <td>194.0</td>\n",
" <td>34.0</td>\n",
" <td>234</td>\n",
" </tr>\n",
" <tr>\n",
" <th>252</th>\n",
" <td>129600</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>7</td>\n",
" <td>6</td>\n",
" <td>5</td>\n",
" <td>0.0</td>\n",
" <td>5292</td>\n",
" <td>9321</td>\n",
" <td>756</td>\n",
" <td>646</td>\n",
" <td>1033</td>\n",
" <td>5867</td>\n",
" <td>3404</td>\n",
" <td>516</td>\n",
" <td>6</td>\n",
" <td>226.0</td>\n",
" <td>42.0</td>\n",
" <td>274</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>494</th>\n",
" <td>85093</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>10</td>\n",
" <td>0.0</td>\n",
" <td>5400</td>\n",
" <td>9218</td>\n",
" <td>810</td>\n",
" <td>756</td>\n",
" <td>1003</td>\n",
" <td>5654</td>\n",
" <td>3230</td>\n",
" <td>422</td>\n",
" <td>10</td>\n",
" <td>125.0</td>\n",
" <td>41.0</td>\n",
" <td>176</td>\n",
" </tr>\n",
" <tr>\n",
" <th>495</th>\n",
" <td>85093</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>4684</td>\n",
" <td>7536</td>\n",
" <td>733</td>\n",
" <td>708</td>\n",
" <td>985</td>\n",
" <td>4750</td>\n",
" <td>2876</td>\n",
" <td>392</td>\n",
" <td>5</td>\n",
" <td>53.0</td>\n",
" <td>26.0</td>\n",
" <td>84</td>\n",
" </tr>\n",
" <tr>\n",
" <th>496</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>5</td>\n",
" <td>8</td>\n",
" <td>0.0</td>\n",
" <td>3480</td>\n",
" <td>6229</td>\n",
" <td>537</td>\n",
" <td>508</td>\n",
" <td>687</td>\n",
" <td>3961</td>\n",
" <td>2104</td>\n",
" <td>301</td>\n",
" <td>0</td>\n",
" <td>53.0</td>\n",
" <td>22.0</td>\n",
" <td>75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>497</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>5</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>3778</td>\n",
" <td>7216</td>\n",
" <td>625</td>\n",
" <td>572</td>\n",
" <td>795</td>\n",
" <td>4742</td>\n",
" <td>2388</td>\n",
" <td>363</td>\n",
" <td>4</td>\n",
" <td>93.0</td>\n",
" <td>18.0</td>\n",
" <td>115</td>\n",
" </tr>\n",
" <tr>\n",
" <th>498</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>4</td>\n",
" <td>11</td>\n",
" <td>0.0</td>\n",
" <td>4156</td>\n",
" <td>7564</td>\n",
" <td>626</td>\n",
" <td>574</td>\n",
" <td>832</td>\n",
" <td>4534</td>\n",
" <td>2452</td>\n",
" <td>370</td>\n",
" <td>7</td>\n",
" <td>91.0</td>\n",
" <td>38.0</td>\n",
" <td>136</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>251 rows × 19 columns</p>\n",
"</div>"
],
"text/plain": [
" Page total likes Type Category Post Month Post Weekday Post Hour \n",
"248 129600 Photo 3 7 1 6 \\\n",
"249 129600 Photo 2 7 7 11 \n",
"250 129600 Photo 1 7 7 6 \n",
"251 129600 Photo 1 7 6 11 \n",
"252 129600 Photo 3 7 6 5 \n",
".. ... ... ... ... ... ... \n",
"494 85093 Photo 3 1 7 10 \n",
"495 85093 Photo 3 1 7 2 \n",
"496 81370 Photo 2 1 5 8 \n",
"497 81370 Photo 1 1 5 2 \n",
"498 81370 Photo 3 1 4 11 \n",
"\n",
" Paid Lifetime Post Total Reach Lifetime Post Total Impressions \n",
"248 0.0 3406 5656 \\\n",
"249 1.0 2602 4349 \n",
"250 1.0 5848 9068 \n",
"251 0.0 26944 43464 \n",
"252 0.0 5292 9321 \n",
".. ... ... ... \n",
"494 0.0 5400 9218 \n",
"495 0.0 4684 7536 \n",
"496 0.0 3480 6229 \n",
"497 0.0 3778 7216 \n",
"498 0.0 4156 7564 \n",
"\n",
" Lifetime Engaged Users Lifetime Post Consumers \n",
"248 571 512 \\\n",
"249 479 444 \n",
"250 622 570 \n",
"251 877 740 \n",
"252 756 646 \n",
".. ... ... \n",
"494 810 756 \n",
"495 733 708 \n",
"496 537 508 \n",
"497 625 572 \n",
"498 626 574 \n",
"\n",
" Lifetime Post Consumptions \n",
"248 731 \\\n",
"249 588 \n",
"250 795 \n",
"251 1097 \n",
"252 1033 \n",
".. ... \n",
"494 1003 \n",
"495 985 \n",
"496 687 \n",
"497 795 \n",
"498 832 \n",
"\n",
" Lifetime Post Impressions by people who have liked your Page \n",
"248 4446 \\\n",
"249 3342 \n",
"250 6651 \n",
"251 20270 \n",
"252 5867 \n",
".. ... \n",
"494 5654 \n",
"495 4750 \n",
"496 3961 \n",
"497 4742 \n",
"498 4534 \n",
"\n",
" Lifetime Post reach by people who like your Page \n",
"248 2598 \\\n",
"249 1946 \n",
"250 4212 \n",
"251 10208 \n",
"252 3404 \n",
".. ... \n",
"494 3230 \n",
"495 2876 \n",
"496 2104 \n",
"497 2388 \n",
"498 2452 \n",
"\n",
" Lifetime People who have liked your Page and engaged with your post \n",
"248 355 \\\n",
"249 287 \n",
"250 383 \n",
"251 563 \n",
"252 516 \n",
".. ... \n",
"494 422 \n",
"495 392 \n",
"496 301 \n",
"497 363 \n",
"498 370 \n",
"\n",
" comment like share Total Interactions \n",
"248 1 98.0 19.0 118 \n",
"249 1 53.0 14.0 68 \n",
"250 4 71.0 10.0 85 \n",
"251 6 194.0 34.0 234 \n",
"252 6 226.0 42.0 274 \n",
".. ... ... ... ... \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",
"\n",
"[251 rows x 19 columns]"
]
},
"execution_count": 15,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"row_subset_2"
]
},
{
"cell_type": "code",
"execution_count": 16,
"id": "cf93fdde",
"metadata": {
"tags": []
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Page total likes</th>\n",
" <th>Type</th>\n",
" <th>Category</th>\n",
" <th>Post Month</th>\n",
" <th>Post Weekday</th>\n",
" <th>Post Hour</th>\n",
" <th>Paid</th>\n",
" <th>Lifetime Post Total Reach</th>\n",
" <th>Lifetime Post Total Impressions</th>\n",
" <th>Lifetime Engaged Users</th>\n",
" <th>Lifetime Post Consumers</th>\n",
" <th>Lifetime Post Consumptions</th>\n",
" <th>Lifetime Post Impressions by people who have liked your Page</th>\n",
" <th>Lifetime Post reach by people who like your Page</th>\n",
" <th>Lifetime People who have liked your Page and engaged with your post</th>\n",
" <th>comment</th>\n",
" <th>like</th>\n",
" <th>share</th>\n",
" <th>Total Interactions</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>4</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>2752</td>\n",
" <td>5091</td>\n",
" <td>178</td>\n",
" <td>109</td>\n",
" <td>159</td>\n",
" <td>3078</td>\n",
" <td>1640</td>\n",
" <td>119</td>\n",
" <td>4</td>\n",
" <td>79.0</td>\n",
" <td>17.0</td>\n",
" <td>100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>139441</td>\n",
" <td>Status</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>3</td>\n",
" <td>10</td>\n",
" <td>0.0</td>\n",
" <td>10460</td>\n",
" <td>19057</td>\n",
" <td>1457</td>\n",
" <td>1361</td>\n",
" <td>1674</td>\n",
" <td>11710</td>\n",
" <td>6112</td>\n",
" <td>1108</td>\n",
" <td>5</td>\n",
" <td>130.0</td>\n",
" <td>29.0</td>\n",
" <td>164</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>12</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>2413</td>\n",
" <td>4373</td>\n",
" <td>177</td>\n",
" <td>113</td>\n",
" <td>154</td>\n",
" <td>2812</td>\n",
" <td>1503</td>\n",
" <td>132</td>\n",
" <td>0</td>\n",
" <td>66.0</td>\n",
" <td>14.0</td>\n",
" <td>80</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>2</td>\n",
" <td>10</td>\n",
" <td>1.0</td>\n",
" <td>50128</td>\n",
" <td>87991</td>\n",
" <td>2211</td>\n",
" <td>790</td>\n",
" <td>1119</td>\n",
" <td>61027</td>\n",
" <td>32048</td>\n",
" <td>1386</td>\n",
" <td>58</td>\n",
" <td>1572.0</td>\n",
" <td>147.0</td>\n",
" <td>1777</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>7244</td>\n",
" <td>13594</td>\n",
" <td>671</td>\n",
" <td>410</td>\n",
" <td>580</td>\n",
" <td>6228</td>\n",
" <td>3200</td>\n",
" <td>396</td>\n",
" <td>19</td>\n",
" <td>325.0</td>\n",
" <td>49.0</td>\n",
" <td>393</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>494</th>\n",
" <td>85093</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>10</td>\n",
" <td>0.0</td>\n",
" <td>5400</td>\n",
" <td>9218</td>\n",
" <td>810</td>\n",
" <td>756</td>\n",
" <td>1003</td>\n",
" <td>5654</td>\n",
" <td>3230</td>\n",
" <td>422</td>\n",
" <td>10</td>\n",
" <td>125.0</td>\n",
" <td>41.0</td>\n",
" <td>176</td>\n",
" </tr>\n",
" <tr>\n",
" <th>495</th>\n",
" <td>85093</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>4684</td>\n",
" <td>7536</td>\n",
" <td>733</td>\n",
" <td>708</td>\n",
" <td>985</td>\n",
" <td>4750</td>\n",
" <td>2876</td>\n",
" <td>392</td>\n",
" <td>5</td>\n",
" <td>53.0</td>\n",
" <td>26.0</td>\n",
" <td>84</td>\n",
" </tr>\n",
" <tr>\n",
" <th>496</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>5</td>\n",
" <td>8</td>\n",
" <td>0.0</td>\n",
" <td>3480</td>\n",
" <td>6229</td>\n",
" <td>537</td>\n",
" <td>508</td>\n",
" <td>687</td>\n",
" <td>3961</td>\n",
" <td>2104</td>\n",
" <td>301</td>\n",
" <td>0</td>\n",
" <td>53.0</td>\n",
" <td>22.0</td>\n",
" <td>75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>497</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>5</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>3778</td>\n",
" <td>7216</td>\n",
" <td>625</td>\n",
" <td>572</td>\n",
" <td>795</td>\n",
" <td>4742</td>\n",
" <td>2388</td>\n",
" <td>363</td>\n",
" <td>4</td>\n",
" <td>93.0</td>\n",
" <td>18.0</td>\n",
" <td>115</td>\n",
" </tr>\n",
" <tr>\n",
" <th>498</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>4</td>\n",
" <td>11</td>\n",
" <td>0.0</td>\n",
" <td>4156</td>\n",
" <td>7564</td>\n",
" <td>626</td>\n",
" <td>574</td>\n",
" <td>832</td>\n",
" <td>4534</td>\n",
" <td>2452</td>\n",
" <td>370</td>\n",
" <td>7</td>\n",
" <td>91.0</td>\n",
" <td>38.0</td>\n",
" <td>136</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>500 rows × 19 columns</p>\n",
"</div>"
],
"text/plain": [
" 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",
"494 85093 Photo 3 1 7 10 \n",
"495 85093 Photo 3 1 7 2 \n",
"496 81370 Photo 2 1 5 8 \n",
"497 81370 Photo 1 1 5 2 \n",
"498 81370 Photo 3 1 4 11 \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",
"494 0.0 5400 9218 \n",
"495 0.0 4684 7536 \n",
"496 0.0 3480 6229 \n",
"497 0.0 3778 7216 \n",
"498 0.0 4156 7564 \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",
"494 810 756 \n",
"495 733 708 \n",
"496 537 508 \n",
"497 625 572 \n",
"498 626 574 \n",
"\n",
" Lifetime Post Consumptions \n",
"0 159 \\\n",
"1 1674 \n",
"2 154 \n",
"3 1119 \n",
"4 580 \n",
".. ... \n",
"494 1003 \n",
"495 985 \n",
"496 687 \n",
"497 795 \n",
"498 832 \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",
"494 5654 \n",
"495 4750 \n",
"496 3961 \n",
"497 4742 \n",
"498 4534 \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",
"494 3230 \n",
"495 2876 \n",
"496 2104 \n",
"497 2388 \n",
"498 2452 \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",
"494 422 \n",
"495 392 \n",
"496 301 \n",
"497 363 \n",
"498 370 \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",
".. ... ... ... ... \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",
"\n",
"[500 rows x 19 columns]"
]
},
"execution_count": 16,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"row_merge = pd.concat([row_subset_1,row_subset_2])\n",
"row_merge"
]
},
{
"cell_type": "code",
"execution_count": 17,
"id": "a6458b38",
"metadata": {
"tags": []
},
"outputs": [],
"source": [
"#column-wise subset\n",
"column_subset_1 = data.iloc[:,0:9]\n",
"column_subset_2 = data.iloc[:,9:]"
]
},
{
"cell_type": "code",
"execution_count": 18,
"id": "d6f1cf5f",
"metadata": {
"tags": []
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Page total likes</th>\n",
" <th>Type</th>\n",
" <th>Category</th>\n",
" <th>Post Month</th>\n",
" <th>Post Weekday</th>\n",
" <th>Post Hour</th>\n",
" <th>Paid</th>\n",
" <th>Lifetime Post Total Reach</th>\n",
" <th>Lifetime Post Total Impressions</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>4</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>2752</td>\n",
" <td>5091</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>139441</td>\n",
" <td>Status</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>3</td>\n",
" <td>10</td>\n",
" <td>0.0</td>\n",
" <td>10460</td>\n",
" <td>19057</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>12</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>2413</td>\n",
" <td>4373</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>2</td>\n",
" <td>10</td>\n",
" <td>1.0</td>\n",
" <td>50128</td>\n",
" <td>87991</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>7244</td>\n",
" <td>13594</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>494</th>\n",
" <td>85093</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>10</td>\n",
" <td>0.0</td>\n",
" <td>5400</td>\n",
" <td>9218</td>\n",
" </tr>\n",
" <tr>\n",
" <th>495</th>\n",
" <td>85093</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>4684</td>\n",
" <td>7536</td>\n",
" </tr>\n",
" <tr>\n",
" <th>496</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>5</td>\n",
" <td>8</td>\n",
" <td>0.0</td>\n",
" <td>3480</td>\n",
" <td>6229</td>\n",
" </tr>\n",
" <tr>\n",
" <th>497</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>5</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>3778</td>\n",
" <td>7216</td>\n",
" </tr>\n",
" <tr>\n",
" <th>498</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>4</td>\n",
" <td>11</td>\n",
" <td>0.0</td>\n",
" <td>4156</td>\n",
" <td>7564</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>499 rows × 9 columns</p>\n",
"</div>"
],
"text/plain": [
" 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",
"494 85093 Photo 3 1 7 10 \n",
"495 85093 Photo 3 1 7 2 \n",
"496 81370 Photo 2 1 5 8 \n",
"497 81370 Photo 1 1 5 2 \n",
"498 81370 Photo 3 1 4 11 \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",
"494 0.0 5400 9218 \n",
"495 0.0 4684 7536 \n",
"496 0.0 3480 6229 \n",
"497 0.0 3778 7216 \n",
"498 0.0 4156 7564 \n",
"\n",
"[499 rows x 9 columns]"
]
},
"execution_count": 18,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"column_subset_1"
]
},
{
"cell_type": "code",
"execution_count": 19,
"id": "e79eb46a",
"metadata": {
"tags": []
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Lifetime Engaged Users</th>\n",
" <th>Lifetime Post Consumers</th>\n",
" <th>Lifetime Post Consumptions</th>\n",
" <th>Lifetime Post Impressions by people who have liked your Page</th>\n",
" <th>Lifetime Post reach by people who like your Page</th>\n",
" <th>Lifetime People who have liked your Page and engaged with your post</th>\n",
" <th>comment</th>\n",
" <th>like</th>\n",
" <th>share</th>\n",
" <th>Total Interactions</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>178</td>\n",
" <td>109</td>\n",
" <td>159</td>\n",
" <td>3078</td>\n",
" <td>1640</td>\n",
" <td>119</td>\n",
" <td>4</td>\n",
" <td>79.0</td>\n",
" <td>17.0</td>\n",
" <td>100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>1457</td>\n",
" <td>1361</td>\n",
" <td>1674</td>\n",
" <td>11710</td>\n",
" <td>6112</td>\n",
" <td>1108</td>\n",
" <td>5</td>\n",
" <td>130.0</td>\n",
" <td>29.0</td>\n",
" <td>164</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>177</td>\n",
" <td>113</td>\n",
" <td>154</td>\n",
" <td>2812</td>\n",
" <td>1503</td>\n",
" <td>132</td>\n",
" <td>0</td>\n",
" <td>66.0</td>\n",
" <td>14.0</td>\n",
" <td>80</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>2211</td>\n",
" <td>790</td>\n",
" <td>1119</td>\n",
" <td>61027</td>\n",
" <td>32048</td>\n",
" <td>1386</td>\n",
" <td>58</td>\n",
" <td>1572.0</td>\n",
" <td>147.0</td>\n",
" <td>1777</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>671</td>\n",
" <td>410</td>\n",
" <td>580</td>\n",
" <td>6228</td>\n",
" <td>3200</td>\n",
" <td>396</td>\n",
" <td>19</td>\n",
" <td>325.0</td>\n",
" <td>49.0</td>\n",
" <td>393</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>494</th>\n",
" <td>810</td>\n",
" <td>756</td>\n",
" <td>1003</td>\n",
" <td>5654</td>\n",
" <td>3230</td>\n",
" <td>422</td>\n",
" <td>10</td>\n",
" <td>125.0</td>\n",
" <td>41.0</td>\n",
" <td>176</td>\n",
" </tr>\n",
" <tr>\n",
" <th>495</th>\n",
" <td>733</td>\n",
" <td>708</td>\n",
" <td>985</td>\n",
" <td>4750</td>\n",
" <td>2876</td>\n",
" <td>392</td>\n",
" <td>5</td>\n",
" <td>53.0</td>\n",
" <td>26.0</td>\n",
" <td>84</td>\n",
" </tr>\n",
" <tr>\n",
" <th>496</th>\n",
" <td>537</td>\n",
" <td>508</td>\n",
" <td>687</td>\n",
" <td>3961</td>\n",
" <td>2104</td>\n",
" <td>301</td>\n",
" <td>0</td>\n",
" <td>53.0</td>\n",
" <td>22.0</td>\n",
" <td>75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>497</th>\n",
" <td>625</td>\n",
" <td>572</td>\n",
" <td>795</td>\n",
" <td>4742</td>\n",
" <td>2388</td>\n",
" <td>363</td>\n",
" <td>4</td>\n",
" <td>93.0</td>\n",
" <td>18.0</td>\n",
" <td>115</td>\n",
" </tr>\n",
" <tr>\n",
" <th>498</th>\n",
" <td>626</td>\n",
" <td>574</td>\n",
" <td>832</td>\n",
" <td>4534</td>\n",
" <td>2452</td>\n",
" <td>370</td>\n",
" <td>7</td>\n",
" <td>91.0</td>\n",
" <td>38.0</td>\n",
" <td>136</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>499 rows × 10 columns</p>\n",
"</div>"
],
"text/plain": [
" 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",
"494 810 756 \n",
"495 733 708 \n",
"496 537 508 \n",
"497 625 572 \n",
"498 626 574 \n",
"\n",
" Lifetime Post Consumptions \n",
"0 159 \\\n",
"1 1674 \n",
"2 154 \n",
"3 1119 \n",
"4 580 \n",
".. ... \n",
"494 1003 \n",
"495 985 \n",
"496 687 \n",
"497 795 \n",
"498 832 \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",
"494 5654 \n",
"495 4750 \n",
"496 3961 \n",
"497 4742 \n",
"498 4534 \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",
"494 3230 \n",
"495 2876 \n",
"496 2104 \n",
"497 2388 \n",
"498 2452 \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",
"494 422 \n",
"495 392 \n",
"496 301 \n",
"497 363 \n",
"498 370 \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",
".. ... ... ... ... \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",
"\n",
"[499 rows x 10 columns]"
]
},
"execution_count": 19,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"column_subset_2"
]
},
{
"cell_type": "code",
"execution_count": 20,
"id": "9bd9d8ea",
"metadata": {
"tags": []
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Page total likes</th>\n",
" <th>Type</th>\n",
" <th>Category</th>\n",
" <th>Post Month</th>\n",
" <th>Post Weekday</th>\n",
" <th>Post Hour</th>\n",
" <th>Paid</th>\n",
" <th>Lifetime Post Total Reach</th>\n",
" <th>Lifetime Post Total Impressions</th>\n",
" <th>Lifetime Engaged Users</th>\n",
" <th>Lifetime Post Consumers</th>\n",
" <th>Lifetime Post Consumptions</th>\n",
" <th>Lifetime Post Impressions by people who have liked your Page</th>\n",
" <th>Lifetime Post reach by people who like your Page</th>\n",
" <th>Lifetime People who have liked your Page and engaged with your post</th>\n",
" <th>comment</th>\n",
" <th>like</th>\n",
" <th>share</th>\n",
" <th>Total Interactions</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>4</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>2752</td>\n",
" <td>5091</td>\n",
" <td>178</td>\n",
" <td>109</td>\n",
" <td>159</td>\n",
" <td>3078</td>\n",
" <td>1640</td>\n",
" <td>119</td>\n",
" <td>4</td>\n",
" <td>79.0</td>\n",
" <td>17.0</td>\n",
" <td>100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>139441</td>\n",
" <td>Status</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>3</td>\n",
" <td>10</td>\n",
" <td>0.0</td>\n",
" <td>10460</td>\n",
" <td>19057</td>\n",
" <td>1457</td>\n",
" <td>1361</td>\n",
" <td>1674</td>\n",
" <td>11710</td>\n",
" <td>6112</td>\n",
" <td>1108</td>\n",
" <td>5</td>\n",
" <td>130.0</td>\n",
" <td>29.0</td>\n",
" <td>164</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>12</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>2413</td>\n",
" <td>4373</td>\n",
" <td>177</td>\n",
" <td>113</td>\n",
" <td>154</td>\n",
" <td>2812</td>\n",
" <td>1503</td>\n",
" <td>132</td>\n",
" <td>0</td>\n",
" <td>66.0</td>\n",
" <td>14.0</td>\n",
" <td>80</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>2</td>\n",
" <td>10</td>\n",
" <td>1.0</td>\n",
" <td>50128</td>\n",
" <td>87991</td>\n",
" <td>2211</td>\n",
" <td>790</td>\n",
" <td>1119</td>\n",
" <td>61027</td>\n",
" <td>32048</td>\n",
" <td>1386</td>\n",
" <td>58</td>\n",
" <td>1572.0</td>\n",
" <td>147.0</td>\n",
" <td>1777</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>7244</td>\n",
" <td>13594</td>\n",
" <td>671</td>\n",
" <td>410</td>\n",
" <td>580</td>\n",
" <td>6228</td>\n",
" <td>3200</td>\n",
" <td>396</td>\n",
" <td>19</td>\n",
" <td>325.0</td>\n",
" <td>49.0</td>\n",
" <td>393</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>494</th>\n",
" <td>85093</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>10</td>\n",
" <td>0.0</td>\n",
" <td>5400</td>\n",
" <td>9218</td>\n",
" <td>810</td>\n",
" <td>756</td>\n",
" <td>1003</td>\n",
" <td>5654</td>\n",
" <td>3230</td>\n",
" <td>422</td>\n",
" <td>10</td>\n",
" <td>125.0</td>\n",
" <td>41.0</td>\n",
" <td>176</td>\n",
" </tr>\n",
" <tr>\n",
" <th>495</th>\n",
" <td>85093</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>4684</td>\n",
" <td>7536</td>\n",
" <td>733</td>\n",
" <td>708</td>\n",
" <td>985</td>\n",
" <td>4750</td>\n",
" <td>2876</td>\n",
" <td>392</td>\n",
" <td>5</td>\n",
" <td>53.0</td>\n",
" <td>26.0</td>\n",
" <td>84</td>\n",
" </tr>\n",
" <tr>\n",
" <th>496</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>5</td>\n",
" <td>8</td>\n",
" <td>0.0</td>\n",
" <td>3480</td>\n",
" <td>6229</td>\n",
" <td>537</td>\n",
" <td>508</td>\n",
" <td>687</td>\n",
" <td>3961</td>\n",
" <td>2104</td>\n",
" <td>301</td>\n",
" <td>0</td>\n",
" <td>53.0</td>\n",
" <td>22.0</td>\n",
" <td>75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>497</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>5</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>3778</td>\n",
" <td>7216</td>\n",
" <td>625</td>\n",
" <td>572</td>\n",
" <td>795</td>\n",
" <td>4742</td>\n",
" <td>2388</td>\n",
" <td>363</td>\n",
" <td>4</td>\n",
" <td>93.0</td>\n",
" <td>18.0</td>\n",
" <td>115</td>\n",
" </tr>\n",
" <tr>\n",
" <th>498</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>4</td>\n",
" <td>11</td>\n",
" <td>0.0</td>\n",
" <td>4156</td>\n",
" <td>7564</td>\n",
" <td>626</td>\n",
" <td>574</td>\n",
" <td>832</td>\n",
" <td>4534</td>\n",
" <td>2452</td>\n",
" <td>370</td>\n",
" <td>7</td>\n",
" <td>91.0</td>\n",
" <td>38.0</td>\n",
" <td>136</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>499 rows × 19 columns</p>\n",
"</div>"
],
"text/plain": [
" 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",
"494 85093 Photo 3 1 7 10 \n",
"495 85093 Photo 3 1 7 2 \n",
"496 81370 Photo 2 1 5 8 \n",
"497 81370 Photo 1 1 5 2 \n",
"498 81370 Photo 3 1 4 11 \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",
"494 0.0 5400 9218 \n",
"495 0.0 4684 7536 \n",
"496 0.0 3480 6229 \n",
"497 0.0 3778 7216 \n",
"498 0.0 4156 7564 \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",
"494 810 756 \n",
"495 733 708 \n",
"496 537 508 \n",
"497 625 572 \n",
"498 626 574 \n",
"\n",
" Lifetime Post Consumptions \n",
"0 159 \\\n",
"1 1674 \n",
"2 154 \n",
"3 1119 \n",
"4 580 \n",
".. ... \n",
"494 1003 \n",
"495 985 \n",
"496 687 \n",
"497 795 \n",
"498 832 \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",
"494 5654 \n",
"495 4750 \n",
"496 3961 \n",
"497 4742 \n",
"498 4534 \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",
"494 3230 \n",
"495 2876 \n",
"496 2104 \n",
"497 2388 \n",
"498 2452 \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",
"494 422 \n",
"495 392 \n",
"496 301 \n",
"497 363 \n",
"498 370 \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",
".. ... ... ... ... \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",
"\n",
"[499 rows x 19 columns]"
]
},
"execution_count": 20,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"column_merge = column_subset_1.join(column_subset_2)\n",
"column_merge"
]
},
{
"cell_type": "code",
"execution_count": 21,
"id": "bafb8d66",
"metadata": {
"tags": []
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Page total likes</th>\n",
" <th>Type</th>\n",
" <th>Category</th>\n",
" <th>Post Month</th>\n",
" <th>Post Weekday</th>\n",
" <th>Post Hour</th>\n",
" <th>Paid</th>\n",
" <th>Lifetime Post Total Reach</th>\n",
" <th>Lifetime Post Total Impressions</th>\n",
" <th>Lifetime Engaged Users</th>\n",
" <th>Lifetime Post Consumers</th>\n",
" <th>Lifetime Post Consumptions</th>\n",
" <th>Lifetime Post Impressions by people who have liked your Page</th>\n",
" <th>Lifetime Post reach by people who like your Page</th>\n",
" <th>Lifetime People who have liked your Page and engaged with your post</th>\n",
" <th>comment</th>\n",
" <th>like</th>\n",
" <th>share</th>\n",
" <th>Total Interactions</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>498</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>4</td>\n",
" <td>11</td>\n",
" <td>0.0</td>\n",
" <td>4156</td>\n",
" <td>7564</td>\n",
" <td>626</td>\n",
" <td>574</td>\n",
" <td>832</td>\n",
" <td>4534</td>\n",
" <td>2452</td>\n",
" <td>370</td>\n",
" <td>7</td>\n",
" <td>91.0</td>\n",
" <td>38.0</td>\n",
" <td>136</td>\n",
" </tr>\n",
" <tr>\n",
" <th>497</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>5</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>3778</td>\n",
" <td>7216</td>\n",
" <td>625</td>\n",
" <td>572</td>\n",
" <td>795</td>\n",
" <td>4742</td>\n",
" <td>2388</td>\n",
" <td>363</td>\n",
" <td>4</td>\n",
" <td>93.0</td>\n",
" <td>18.0</td>\n",
" <td>115</td>\n",
" </tr>\n",
" <tr>\n",
" <th>496</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>5</td>\n",
" <td>8</td>\n",
" <td>0.0</td>\n",
" <td>3480</td>\n",
" <td>6229</td>\n",
" <td>537</td>\n",
" <td>508</td>\n",
" <td>687</td>\n",
" <td>3961</td>\n",
" <td>2104</td>\n",
" <td>301</td>\n",
" <td>0</td>\n",
" <td>53.0</td>\n",
" <td>22.0</td>\n",
" <td>75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>493</th>\n",
" <td>85093</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>8412</td>\n",
" <td>13960</td>\n",
" <td>1179</td>\n",
" <td>1111</td>\n",
" <td>1632</td>\n",
" <td>8632</td>\n",
" <td>5348</td>\n",
" <td>699</td>\n",
" <td>17</td>\n",
" <td>185.0</td>\n",
" <td>55.0</td>\n",
" <td>257</td>\n",
" </tr>\n",
" <tr>\n",
" <th>495</th>\n",
" <td>85093</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>4684</td>\n",
" <td>7536</td>\n",
" <td>733</td>\n",
" <td>708</td>\n",
" <td>985</td>\n",
" <td>4750</td>\n",
" <td>2876</td>\n",
" <td>392</td>\n",
" <td>5</td>\n",
" <td>53.0</td>\n",
" <td>26.0</td>\n",
" <td>84</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>139441</td>\n",
" <td>Status</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>5</td>\n",
" <td>10</td>\n",
" <td>0.0</td>\n",
" <td>21744</td>\n",
" <td>42334</td>\n",
" <td>4258</td>\n",
" <td>4100</td>\n",
" <td>4540</td>\n",
" <td>37849</td>\n",
" <td>18952</td>\n",
" <td>3798</td>\n",
" <td>0</td>\n",
" <td>233.0</td>\n",
" <td>19.0</td>\n",
" <td>252</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>5</td>\n",
" <td>10</td>\n",
" <td>0.0</td>\n",
" <td>3112</td>\n",
" <td>5590</td>\n",
" <td>208</td>\n",
" <td>127</td>\n",
" <td>145</td>\n",
" <td>3887</td>\n",
" <td>2174</td>\n",
" <td>165</td>\n",
" <td>0</td>\n",
" <td>88.0</td>\n",
" <td>18.0</td>\n",
" <td>106</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>5</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>2549</td>\n",
" <td>4896</td>\n",
" <td>249</td>\n",
" <td>134</td>\n",
" <td>168</td>\n",
" <td>3631</td>\n",
" <td>1917</td>\n",
" <td>183</td>\n",
" <td>5</td>\n",
" <td>137.0</td>\n",
" <td>10.0</td>\n",
" <td>152</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>12</td>\n",
" <td>7</td>\n",
" <td>9</td>\n",
" <td>1.0</td>\n",
" <td>13720</td>\n",
" <td>24137</td>\n",
" <td>537</td>\n",
" <td>232</td>\n",
" <td>305</td>\n",
" <td>19728</td>\n",
" <td>11056</td>\n",
" <td>422</td>\n",
" <td>0</td>\n",
" <td>325.0</td>\n",
" <td>14.0</td>\n",
" <td>339</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>4</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>2752</td>\n",
" <td>5091</td>\n",
" <td>178</td>\n",
" <td>109</td>\n",
" <td>159</td>\n",
" <td>3078</td>\n",
" <td>1640</td>\n",
" <td>119</td>\n",
" <td>4</td>\n",
" <td>79.0</td>\n",
" <td>17.0</td>\n",
" <td>100</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>499 rows × 19 columns</p>\n",
"</div>"
],
"text/plain": [
" Page total likes Type Category Post Month Post Weekday Post Hour \n",
"498 81370 Photo 3 1 4 11 \\\n",
"497 81370 Photo 1 1 5 2 \n",
"496 81370 Photo 2 1 5 8 \n",
"493 85093 Photo 3 1 1 2 \n",
"495 85093 Photo 3 1 7 2 \n",
".. ... ... ... ... ... ... \n",
"10 139441 Status 2 12 5 10 \n",
"11 139441 Photo 2 12 5 10 \n",
"13 139441 Photo 2 12 5 3 \n",
"7 139441 Photo 3 12 7 9 \n",
"0 139441 Photo 2 12 4 3 \n",
"\n",
" Paid Lifetime Post Total Reach Lifetime Post Total Impressions \n",
"498 0.0 4156 7564 \\\n",
"497 0.0 3778 7216 \n",
"496 0.0 3480 6229 \n",
"493 0.0 8412 13960 \n",
"495 0.0 4684 7536 \n",
".. ... ... ... \n",
"10 0.0 21744 42334 \n",
"11 0.0 3112 5590 \n",
"13 0.0 2549 4896 \n",
"7 1.0 13720 24137 \n",
"0 0.0 2752 5091 \n",
"\n",
" Lifetime Engaged Users Lifetime Post Consumers \n",
"498 626 574 \\\n",
"497 625 572 \n",
"496 537 508 \n",
"493 1179 1111 \n",
"495 733 708 \n",
".. ... ... \n",
"10 4258 4100 \n",
"11 208 127 \n",
"13 249 134 \n",
"7 537 232 \n",
"0 178 109 \n",
"\n",
" Lifetime Post Consumptions \n",
"498 832 \\\n",
"497 795 \n",
"496 687 \n",
"493 1632 \n",
"495 985 \n",
".. ... \n",
"10 4540 \n",
"11 145 \n",
"13 168 \n",
"7 305 \n",
"0 159 \n",
"\n",
" Lifetime Post Impressions by people who have liked your Page \n",
"498 4534 \\\n",
"497 4742 \n",
"496 3961 \n",
"493 8632 \n",
"495 4750 \n",
".. ... \n",
"10 37849 \n",
"11 3887 \n",
"13 3631 \n",
"7 19728 \n",
"0 3078 \n",
"\n",
" Lifetime Post reach by people who like your Page \n",
"498 2452 \\\n",
"497 2388 \n",
"496 2104 \n",
"493 5348 \n",
"495 2876 \n",
".. ... \n",
"10 18952 \n",
"11 2174 \n",
"13 1917 \n",
"7 11056 \n",
"0 1640 \n",
"\n",
" Lifetime People who have liked your Page and engaged with your post \n",
"498 370 \\\n",
"497 363 \n",
"496 301 \n",
"493 699 \n",
"495 392 \n",
".. ... \n",
"10 3798 \n",
"11 165 \n",
"13 183 \n",
"7 422 \n",
"0 119 \n",
"\n",
" comment like share Total Interactions \n",
"498 7 91.0 38.0 136 \n",
"497 4 93.0 18.0 115 \n",
"496 0 53.0 22.0 75 \n",
"493 17 185.0 55.0 257 \n",
"495 5 53.0 26.0 84 \n",
".. ... ... ... ... \n",
"10 0 233.0 19.0 252 \n",
"11 0 88.0 18.0 106 \n",
"13 5 137.0 10.0 152 \n",
"7 0 325.0 14.0 339 \n",
"0 4 79.0 17.0 100 \n",
"\n",
"[499 rows x 19 columns]"
]
},
"execution_count": 21,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#Sorting the data\n",
"data_sort = data.sort_values(by=['Page total likes'])\n",
"data_sort"
]
},
{
"cell_type": "code",
"execution_count": 22,
"id": "52be55d6",
"metadata": {
"tags": []
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Page total likes</th>\n",
" <th>Type</th>\n",
" <th>Category</th>\n",
" <th>Post Month</th>\n",
" <th>Post Weekday</th>\n",
" <th>Post Hour</th>\n",
" <th>Paid</th>\n",
" <th>Lifetime Post Total Reach</th>\n",
" <th>Lifetime Post Total Impressions</th>\n",
" <th>Lifetime Engaged Users</th>\n",
" <th>Lifetime Post Consumers</th>\n",
" <th>Lifetime Post Consumptions</th>\n",
" <th>Lifetime Post Impressions by people who have liked your Page</th>\n",
" <th>Lifetime Post reach by people who like your Page</th>\n",
" <th>Lifetime People who have liked your Page and engaged with your post</th>\n",
" <th>comment</th>\n",
" <th>like</th>\n",
" <th>share</th>\n",
" <th>Total Interactions</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>417</th>\n",
" <td>104070</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>10</td>\n",
" <td>0.0</td>\n",
" <td>1874</td>\n",
" <td>2474</td>\n",
" <td>25</td>\n",
" <td>25</td>\n",
" <td>31</td>\n",
" <td>1483</td>\n",
" <td>1062</td>\n",
" <td>15</td>\n",
" <td>0</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>138414</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>12</td>\n",
" <td>7</td>\n",
" <td>10</td>\n",
" <td>0.0</td>\n",
" <td>1384</td>\n",
" <td>2467</td>\n",
" <td>15</td>\n",
" <td>15</td>\n",
" <td>20</td>\n",
" <td>2196</td>\n",
" <td>1172</td>\n",
" <td>15</td>\n",
" <td>0</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>441</th>\n",
" <td>98195</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>3</td>\n",
" <td>5</td>\n",
" <td>4</td>\n",
" <td>1.0</td>\n",
" <td>1845</td>\n",
" <td>2670</td>\n",
" <td>9</td>\n",
" <td>9</td>\n",
" <td>9</td>\n",
" <td>1614</td>\n",
" <td>1008</td>\n",
" <td>9</td>\n",
" <td>0</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>111</th>\n",
" <td>136736</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>10</td>\n",
" <td>6</td>\n",
" <td>8</td>\n",
" <td>0.0</td>\n",
" <td>1261</td>\n",
" <td>2158</td>\n",
" <td>37</td>\n",
" <td>37</td>\n",
" <td>49</td>\n",
" <td>1911</td>\n",
" <td>1077</td>\n",
" <td>33</td>\n",
" <td>0</td>\n",
" <td>177.945892</td>\n",
" <td>27.266129</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>100</th>\n",
" <td>137020</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>10</td>\n",
" <td>4</td>\n",
" <td>9</td>\n",
" <td>1.0</td>\n",
" <td>1357</td>\n",
" <td>2453</td>\n",
" <td>37</td>\n",
" <td>37</td>\n",
" <td>55</td>\n",
" <td>2154</td>\n",
" <td>1120</td>\n",
" <td>32</td>\n",
" <td>0</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>349</th>\n",
" <td>117764</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>5</td>\n",
" <td>5</td>\n",
" <td>13</td>\n",
" <td>0.0</td>\n",
" <td>81856</td>\n",
" <td>124753</td>\n",
" <td>3000</td>\n",
" <td>1637</td>\n",
" <td>2718</td>\n",
" <td>52477</td>\n",
" <td>27392</td>\n",
" <td>1756</td>\n",
" <td>45</td>\n",
" <td>1639.000000</td>\n",
" <td>122.000000</td>\n",
" <td>1806</td>\n",
" </tr>\n",
" <tr>\n",
" <th>460</th>\n",
" <td>92507</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>13</td>\n",
" <td>0.0</td>\n",
" <td>55520</td>\n",
" <td>665792</td>\n",
" <td>4544</td>\n",
" <td>3586</td>\n",
" <td>6624</td>\n",
" <td>648611</td>\n",
" <td>47488</td>\n",
" <td>3430</td>\n",
" <td>146</td>\n",
" <td>1546.000000</td>\n",
" <td>181.000000</td>\n",
" <td>1873</td>\n",
" </tr>\n",
" <tr>\n",
" <th>168</th>\n",
" <td>135428</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>9</td>\n",
" <td>3</td>\n",
" <td>10</td>\n",
" <td>0.0</td>\n",
" <td>41984</td>\n",
" <td>68290</td>\n",
" <td>3370</td>\n",
" <td>2420</td>\n",
" <td>4074</td>\n",
" <td>34802</td>\n",
" <td>20928</td>\n",
" <td>2126</td>\n",
" <td>144</td>\n",
" <td>1622.000000</td>\n",
" <td>208.000000</td>\n",
" <td>1974</td>\n",
" </tr>\n",
" <tr>\n",
" <th>379</th>\n",
" <td>111620</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>4</td>\n",
" <td>1</td>\n",
" <td>14</td>\n",
" <td>1.0</td>\n",
" <td>105632</td>\n",
" <td>147918</td>\n",
" <td>3984</td>\n",
" <td>2254</td>\n",
" <td>3391</td>\n",
" <td>48575</td>\n",
" <td>27328</td>\n",
" <td>1936</td>\n",
" <td>51</td>\n",
" <td>1998.000000</td>\n",
" <td>128.000000</td>\n",
" <td>2177</td>\n",
" </tr>\n",
" <tr>\n",
" <th>244</th>\n",
" <td>130791</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>7</td>\n",
" <td>3</td>\n",
" <td>5</td>\n",
" <td>1.0</td>\n",
" <td>180480</td>\n",
" <td>319133</td>\n",
" <td>8072</td>\n",
" <td>4010</td>\n",
" <td>6242</td>\n",
" <td>108752</td>\n",
" <td>51456</td>\n",
" <td>3316</td>\n",
" <td>372</td>\n",
" <td>5172.000000</td>\n",
" <td>790.000000</td>\n",
" <td>6334</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>499 rows × 19 columns</p>\n",
"</div>"
],
"text/plain": [
" Page total likes Type Category Post Month Post Weekday Post Hour \n",
"417 104070 Photo 1 3 3 10 \\\n",
"21 138414 Photo 1 12 7 10 \n",
"441 98195 Photo 1 3 5 4 \n",
"111 136736 Photo 1 10 6 8 \n",
"100 137020 Photo 1 10 4 9 \n",
".. ... ... ... ... ... ... \n",
"349 117764 Photo 3 5 5 13 \n",
"460 92507 Photo 3 2 1 13 \n",
"168 135428 Photo 1 9 3 10 \n",
"379 111620 Photo 3 4 1 14 \n",
"244 130791 Photo 2 7 3 5 \n",
"\n",
" Paid Lifetime Post Total Reach Lifetime Post Total Impressions \n",
"417 0.0 1874 2474 \\\n",
"21 0.0 1384 2467 \n",
"441 1.0 1845 2670 \n",
"111 0.0 1261 2158 \n",
"100 1.0 1357 2453 \n",
".. ... ... ... \n",
"349 0.0 81856 124753 \n",
"460 0.0 55520 665792 \n",
"168 0.0 41984 68290 \n",
"379 1.0 105632 147918 \n",
"244 1.0 180480 319133 \n",
"\n",
" Lifetime Engaged Users Lifetime Post Consumers \n",
"417 25 25 \\\n",
"21 15 15 \n",
"441 9 9 \n",
"111 37 37 \n",
"100 37 37 \n",
".. ... ... \n",
"349 3000 1637 \n",
"460 4544 3586 \n",
"168 3370 2420 \n",
"379 3984 2254 \n",
"244 8072 4010 \n",
"\n",
" Lifetime Post Consumptions \n",
"417 31 \\\n",
"21 20 \n",
"441 9 \n",
"111 49 \n",
"100 55 \n",
".. ... \n",
"349 2718 \n",
"460 6624 \n",
"168 4074 \n",
"379 3391 \n",
"244 6242 \n",
"\n",
" Lifetime Post Impressions by people who have liked your Page \n",
"417 1483 \\\n",
"21 2196 \n",
"441 1614 \n",
"111 1911 \n",
"100 2154 \n",
".. ... \n",
"349 52477 \n",
"460 648611 \n",
"168 34802 \n",
"379 48575 \n",
"244 108752 \n",
"\n",
" Lifetime Post reach by people who like your Page \n",
"417 1062 \\\n",
"21 1172 \n",
"441 1008 \n",
"111 1077 \n",
"100 1120 \n",
".. ... \n",
"349 27392 \n",
"460 47488 \n",
"168 20928 \n",
"379 27328 \n",
"244 51456 \n",
"\n",
" Lifetime People who have liked your Page and engaged with your post \n",
"417 15 \\\n",
"21 15 \n",
"441 9 \n",
"111 33 \n",
"100 32 \n",
".. ... \n",
"349 1756 \n",
"460 3430 \n",
"168 2126 \n",
"379 1936 \n",
"244 3316 \n",
"\n",
" comment like share Total Interactions \n",
"417 0 0.000000 0.000000 0 \n",
"21 0 0.000000 0.000000 0 \n",
"441 0 0.000000 0.000000 0 \n",
"111 0 177.945892 27.266129 0 \n",
"100 0 0.000000 0.000000 0 \n",
".. ... ... ... ... \n",
"349 45 1639.000000 122.000000 1806 \n",
"460 146 1546.000000 181.000000 1873 \n",
"168 144 1622.000000 208.000000 1974 \n",
"379 51 1998.000000 128.000000 2177 \n",
"244 372 5172.000000 790.000000 6334 \n",
"\n",
"[499 rows x 19 columns]"
]
},
"execution_count": 22,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data_sort = data.sort_values(by=[\"Total Interactions\"])\n",
"data_sort"
]
},
{
"cell_type": "code",
"execution_count": 23,
"id": "ecec0d9b",
"metadata": {
"tags": []
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>0</th>\n",
" <th>1</th>\n",
" <th>2</th>\n",
" <th>3</th>\n",
" <th>4</th>\n",
" <th>5</th>\n",
" <th>6</th>\n",
" <th>7</th>\n",
" <th>8</th>\n",
" <th>9</th>\n",
" <th>...</th>\n",
" <th>489</th>\n",
" <th>490</th>\n",
" <th>491</th>\n",
" <th>492</th>\n",
" <th>493</th>\n",
" <th>494</th>\n",
" <th>495</th>\n",
" <th>496</th>\n",
" <th>497</th>\n",
" <th>498</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>Page total likes</th>\n",
" <td>139441</td>\n",
" <td>139441</td>\n",
" <td>139441</td>\n",
" <td>139441</td>\n",
" <td>139441</td>\n",
" <td>139441</td>\n",
" <td>139441</td>\n",
" <td>139441</td>\n",
" <td>139441</td>\n",
" <td>139441</td>\n",
" <td>...</td>\n",
" <td>85979</td>\n",
" <td>85979</td>\n",
" <td>85979</td>\n",
" <td>85979</td>\n",
" <td>85093</td>\n",
" <td>85093</td>\n",
" <td>85093</td>\n",
" <td>81370</td>\n",
" <td>81370</td>\n",
" <td>81370</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Type</th>\n",
" <td>Photo</td>\n",
" <td>Status</td>\n",
" <td>Photo</td>\n",
" <td>Photo</td>\n",
" <td>Photo</td>\n",
" <td>Status</td>\n",
" <td>Photo</td>\n",
" <td>Photo</td>\n",
" <td>Status</td>\n",
" <td>Photo</td>\n",
" <td>...</td>\n",
" <td>Photo</td>\n",
" <td>Photo</td>\n",
" <td>Photo</td>\n",
" <td>Link</td>\n",
" <td>Photo</td>\n",
" <td>Photo</td>\n",
" <td>Photo</td>\n",
" <td>Photo</td>\n",
" <td>Photo</td>\n",
" <td>Photo</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Category</th>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>...</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Post Month</th>\n",
" <td>12</td>\n",
" <td>12</td>\n",
" <td>12</td>\n",
" <td>12</td>\n",
" <td>12</td>\n",
" <td>12</td>\n",
" <td>12</td>\n",
" <td>12</td>\n",
" <td>12</td>\n",
" <td>12</td>\n",
" <td>...</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Post Weekday</th>\n",
" <td>4</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>2</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>7</td>\n",
" <td>6</td>\n",
" <td>...</td>\n",
" <td>7</td>\n",
" <td>6</td>\n",
" <td>6</td>\n",
" <td>5</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>7</td>\n",
" <td>5</td>\n",
" <td>5</td>\n",
" <td>4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Post Hour</th>\n",
" <td>3</td>\n",
" <td>10</td>\n",
" <td>3</td>\n",
" <td>10</td>\n",
" <td>3</td>\n",
" <td>9</td>\n",
" <td>3</td>\n",
" <td>9</td>\n",
" <td>3</td>\n",
" <td>10</td>\n",
" <td>...</td>\n",
" <td>2</td>\n",
" <td>11</td>\n",
" <td>3</td>\n",
" <td>11</td>\n",
" <td>2</td>\n",
" <td>10</td>\n",
" <td>2</td>\n",
" <td>8</td>\n",
" <td>2</td>\n",
" <td>11</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Paid</th>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>...</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>1.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Lifetime Post Total Reach</th>\n",
" <td>2752</td>\n",
" <td>10460</td>\n",
" <td>2413</td>\n",
" <td>50128</td>\n",
" <td>7244</td>\n",
" <td>10472</td>\n",
" <td>11692</td>\n",
" <td>13720</td>\n",
" <td>11844</td>\n",
" <td>4694</td>\n",
" <td>...</td>\n",
" <td>4800</td>\n",
" <td>5280</td>\n",
" <td>6184</td>\n",
" <td>45920</td>\n",
" <td>8412</td>\n",
" <td>5400</td>\n",
" <td>4684</td>\n",
" <td>3480</td>\n",
" <td>3778</td>\n",
" <td>4156</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Lifetime Post Total Impressions</th>\n",
" <td>5091</td>\n",
" <td>19057</td>\n",
" <td>4373</td>\n",
" <td>87991</td>\n",
" <td>13594</td>\n",
" <td>20849</td>\n",
" <td>19479</td>\n",
" <td>24137</td>\n",
" <td>22538</td>\n",
" <td>8668</td>\n",
" <td>...</td>\n",
" <td>7754</td>\n",
" <td>8703</td>\n",
" <td>10228</td>\n",
" <td>5808</td>\n",
" <td>13960</td>\n",
" <td>9218</td>\n",
" <td>7536</td>\n",
" <td>6229</td>\n",
" <td>7216</td>\n",
" <td>7564</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Lifetime Engaged Users</th>\n",
" <td>178</td>\n",
" <td>1457</td>\n",
" <td>177</td>\n",
" <td>2211</td>\n",
" <td>671</td>\n",
" <td>1191</td>\n",
" <td>481</td>\n",
" <td>537</td>\n",
" <td>1530</td>\n",
" <td>280</td>\n",
" <td>...</td>\n",
" <td>975</td>\n",
" <td>951</td>\n",
" <td>956</td>\n",
" <td>753</td>\n",
" <td>1179</td>\n",
" <td>810</td>\n",
" <td>733</td>\n",
" <td>537</td>\n",
" <td>625</td>\n",
" <td>626</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Lifetime Post Consumers</th>\n",
" <td>109</td>\n",
" <td>1361</td>\n",
" <td>113</td>\n",
" <td>790</td>\n",
" <td>410</td>\n",
" <td>1073</td>\n",
" <td>265</td>\n",
" <td>232</td>\n",
" <td>1407</td>\n",
" <td>183</td>\n",
" <td>...</td>\n",
" <td>938</td>\n",
" <td>911</td>\n",
" <td>901</td>\n",
" <td>655</td>\n",
" <td>1111</td>\n",
" <td>756</td>\n",
" <td>708</td>\n",
" <td>508</td>\n",
" <td>572</td>\n",
" <td>574</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Lifetime Post Consumptions</th>\n",
" <td>159</td>\n",
" <td>1674</td>\n",
" <td>154</td>\n",
" <td>1119</td>\n",
" <td>580</td>\n",
" <td>1389</td>\n",
" <td>364</td>\n",
" <td>305</td>\n",
" <td>1692</td>\n",
" <td>250</td>\n",
" <td>...</td>\n",
" <td>1278</td>\n",
" <td>1237</td>\n",
" <td>1140</td>\n",
" <td>763</td>\n",
" <td>1632</td>\n",
" <td>1003</td>\n",
" <td>985</td>\n",
" <td>687</td>\n",
" <td>795</td>\n",
" <td>832</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Lifetime Post Impressions by people who have liked your Page</th>\n",
" <td>3078</td>\n",
" <td>11710</td>\n",
" <td>2812</td>\n",
" <td>61027</td>\n",
" <td>6228</td>\n",
" <td>16034</td>\n",
" <td>15432</td>\n",
" <td>19728</td>\n",
" <td>15220</td>\n",
" <td>4309</td>\n",
" <td>...</td>\n",
" <td>4932</td>\n",
" <td>5757</td>\n",
" <td>6085</td>\n",
" <td>15766</td>\n",
" <td>8632</td>\n",
" <td>5654</td>\n",
" <td>4750</td>\n",
" <td>3961</td>\n",
" <td>4742</td>\n",
" <td>4534</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Lifetime Post reach by people who like your Page</th>\n",
" <td>1640</td>\n",
" <td>6112</td>\n",
" <td>1503</td>\n",
" <td>32048</td>\n",
" <td>3200</td>\n",
" <td>7852</td>\n",
" <td>9328</td>\n",
" <td>11056</td>\n",
" <td>7912</td>\n",
" <td>2324</td>\n",
" <td>...</td>\n",
" <td>2820</td>\n",
" <td>3300</td>\n",
" <td>3502</td>\n",
" <td>10720</td>\n",
" <td>5348</td>\n",
" <td>3230</td>\n",
" <td>2876</td>\n",
" <td>2104</td>\n",
" <td>2388</td>\n",
" <td>2452</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Lifetime People who have liked your Page and engaged with your post</th>\n",
" <td>119</td>\n",
" <td>1108</td>\n",
" <td>132</td>\n",
" <td>1386</td>\n",
" <td>396</td>\n",
" <td>1016</td>\n",
" <td>379</td>\n",
" <td>422</td>\n",
" <td>1250</td>\n",
" <td>199</td>\n",
" <td>...</td>\n",
" <td>432</td>\n",
" <td>431</td>\n",
" <td>437</td>\n",
" <td>220</td>\n",
" <td>699</td>\n",
" <td>422</td>\n",
" <td>392</td>\n",
" <td>301</td>\n",
" <td>363</td>\n",
" <td>370</td>\n",
" </tr>\n",
" <tr>\n",
" <th>comment</th>\n",
" <td>4</td>\n",
" <td>5</td>\n",
" <td>0</td>\n",
" <td>58</td>\n",
" <td>19</td>\n",
" <td>1</td>\n",
" <td>3</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>3</td>\n",
" <td>...</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>17</td>\n",
" <td>10</td>\n",
" <td>5</td>\n",
" <td>0</td>\n",
" <td>4</td>\n",
" <td>7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>like</th>\n",
" <td>79.0</td>\n",
" <td>130.0</td>\n",
" <td>66.0</td>\n",
" <td>1572.0</td>\n",
" <td>325.0</td>\n",
" <td>152.0</td>\n",
" <td>249.0</td>\n",
" <td>325.0</td>\n",
" <td>161.0</td>\n",
" <td>113.0</td>\n",
" <td>...</td>\n",
" <td>74.0</td>\n",
" <td>79.0</td>\n",
" <td>105.0</td>\n",
" <td>128.0</td>\n",
" <td>185.0</td>\n",
" <td>125.0</td>\n",
" <td>53.0</td>\n",
" <td>53.0</td>\n",
" <td>93.0</td>\n",
" <td>91.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>share</th>\n",
" <td>17.0</td>\n",
" <td>29.0</td>\n",
" <td>14.0</td>\n",
" <td>147.0</td>\n",
" <td>49.0</td>\n",
" <td>33.0</td>\n",
" <td>27.0</td>\n",
" <td>14.0</td>\n",
" <td>31.0</td>\n",
" <td>26.0</td>\n",
" <td>...</td>\n",
" <td>28.0</td>\n",
" <td>30.0</td>\n",
" <td>46.0</td>\n",
" <td>9.0</td>\n",
" <td>55.0</td>\n",
" <td>41.0</td>\n",
" <td>26.0</td>\n",
" <td>22.0</td>\n",
" <td>18.0</td>\n",
" <td>38.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Total Interactions</th>\n",
" <td>100</td>\n",
" <td>164</td>\n",
" <td>80</td>\n",
" <td>1777</td>\n",
" <td>393</td>\n",
" <td>186</td>\n",
" <td>279</td>\n",
" <td>339</td>\n",
" <td>192</td>\n",
" <td>142</td>\n",
" <td>...</td>\n",
" <td>103</td>\n",
" <td>110</td>\n",
" <td>152</td>\n",
" <td>137</td>\n",
" <td>257</td>\n",
" <td>176</td>\n",
" <td>84</td>\n",
" <td>75</td>\n",
" <td>115</td>\n",
" <td>136</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>19 rows × 499 columns</p>\n",
"</div>"
],
"text/plain": [
" 0 1 2 \n",
"Page total likes 139441 139441 139441 \\\n",
"Type Photo Status Photo \n",
"Category 2 2 3 \n",
"Post Month 12 12 12 \n",
"Post Weekday 4 3 3 \n",
"Post Hour 3 10 3 \n",
"Paid 0.0 0.0 0.0 \n",
"Lifetime Post Total Reach 2752 10460 2413 \n",
"Lifetime Post Total Impressions 5091 19057 4373 \n",
"Lifetime Engaged Users 178 1457 177 \n",
"Lifetime Post Consumers 109 1361 113 \n",
"Lifetime Post Consumptions 159 1674 154 \n",
"Lifetime Post Impressions by people who have li... 3078 11710 2812 \n",
"Lifetime Post reach by people who like your Page 1640 6112 1503 \n",
"Lifetime People who have liked your Page and en... 119 1108 132 \n",
"comment 4 5 0 \n",
"like 79.0 130.0 66.0 \n",
"share 17.0 29.0 14.0 \n",
"Total Interactions 100 164 80 \n",
"\n",
" 3 4 5 \n",
"Page total likes 139441 139441 139441 \\\n",
"Type Photo Photo Status \n",
"Category 2 2 2 \n",
"Post Month 12 12 12 \n",
"Post Weekday 2 2 1 \n",
"Post Hour 10 3 9 \n",
"Paid 1.0 0.0 0.0 \n",
"Lifetime Post Total Reach 50128 7244 10472 \n",
"Lifetime Post Total Impressions 87991 13594 20849 \n",
"Lifetime Engaged Users 2211 671 1191 \n",
"Lifetime Post Consumers 790 410 1073 \n",
"Lifetime Post Consumptions 1119 580 1389 \n",
"Lifetime Post Impressions by people who have li... 61027 6228 16034 \n",
"Lifetime Post reach by people who like your Page 32048 3200 7852 \n",
"Lifetime People who have liked your Page and en... 1386 396 1016 \n",
"comment 58 19 1 \n",
"like 1572.0 325.0 152.0 \n",
"share 147.0 49.0 33.0 \n",
"Total Interactions 1777 393 186 \n",
"\n",
" 6 7 8 \n",
"Page total likes 139441 139441 139441 \\\n",
"Type Photo Photo Status \n",
"Category 3 3 2 \n",
"Post Month 12 12 12 \n",
"Post Weekday 1 7 7 \n",
"Post Hour 3 9 3 \n",
"Paid 1.0 1.0 0.0 \n",
"Lifetime Post Total Reach 11692 13720 11844 \n",
"Lifetime Post Total Impressions 19479 24137 22538 \n",
"Lifetime Engaged Users 481 537 1530 \n",
"Lifetime Post Consumers 265 232 1407 \n",
"Lifetime Post Consumptions 364 305 1692 \n",
"Lifetime Post Impressions by people who have li... 15432 19728 15220 \n",
"Lifetime Post reach by people who like your Page 9328 11056 7912 \n",
"Lifetime People who have liked your Page and en... 379 422 1250 \n",
"comment 3 0 0 \n",
"like 249.0 325.0 161.0 \n",
"share 27.0 14.0 31.0 \n",
"Total Interactions 279 339 192 \n",
"\n",
" 9 ... 489 490 \n",
"Page total likes 139441 ... 85979 85979 \\\n",
"Type Photo ... Photo Photo \n",
"Category 3 ... 3 3 \n",
"Post Month 12 ... 1 1 \n",
"Post Weekday 6 ... 7 6 \n",
"Post Hour 10 ... 2 11 \n",
"Paid 0.0 ... 0.0 0.0 \n",
"Lifetime Post Total Reach 4694 ... 4800 5280 \n",
"Lifetime Post Total Impressions 8668 ... 7754 8703 \n",
"Lifetime Engaged Users 280 ... 975 951 \n",
"Lifetime Post Consumers 183 ... 938 911 \n",
"Lifetime Post Consumptions 250 ... 1278 1237 \n",
"Lifetime Post Impressions by people who have li... 4309 ... 4932 5757 \n",
"Lifetime Post reach by people who like your Page 2324 ... 2820 3300 \n",
"Lifetime People who have liked your Page and en... 199 ... 432 431 \n",
"comment 3 ... 1 1 \n",
"like 113.0 ... 74.0 79.0 \n",
"share 26.0 ... 28.0 30.0 \n",
"Total Interactions 142 ... 103 110 \n",
"\n",
" 491 492 493 \n",
"Page total likes 85979 85979 85093 \\\n",
"Type Photo Link Photo \n",
"Category 3 1 3 \n",
"Post Month 1 1 1 \n",
"Post Weekday 6 5 1 \n",
"Post Hour 3 11 2 \n",
"Paid 1.0 0.0 0.0 \n",
"Lifetime Post Total Reach 6184 45920 8412 \n",
"Lifetime Post Total Impressions 10228 5808 13960 \n",
"Lifetime Engaged Users 956 753 1179 \n",
"Lifetime Post Consumers 901 655 1111 \n",
"Lifetime Post Consumptions 1140 763 1632 \n",
"Lifetime Post Impressions by people who have li... 6085 15766 8632 \n",
"Lifetime Post reach by people who like your Page 3502 10720 5348 \n",
"Lifetime People who have liked your Page and en... 437 220 699 \n",
"comment 1 0 17 \n",
"like 105.0 128.0 185.0 \n",
"share 46.0 9.0 55.0 \n",
"Total Interactions 152 137 257 \n",
"\n",
" 494 495 496 \n",
"Page total likes 85093 85093 81370 \\\n",
"Type Photo Photo Photo \n",
"Category 3 3 2 \n",
"Post Month 1 1 1 \n",
"Post Weekday 7 7 5 \n",
"Post Hour 10 2 8 \n",
"Paid 0.0 0.0 0.0 \n",
"Lifetime Post Total Reach 5400 4684 3480 \n",
"Lifetime Post Total Impressions 9218 7536 6229 \n",
"Lifetime Engaged Users 810 733 537 \n",
"Lifetime Post Consumers 756 708 508 \n",
"Lifetime Post Consumptions 1003 985 687 \n",
"Lifetime Post Impressions by people who have li... 5654 4750 3961 \n",
"Lifetime Post reach by people who like your Page 3230 2876 2104 \n",
"Lifetime People who have liked your Page and en... 422 392 301 \n",
"comment 10 5 0 \n",
"like 125.0 53.0 53.0 \n",
"share 41.0 26.0 22.0 \n",
"Total Interactions 176 84 75 \n",
"\n",
" 497 498 \n",
"Page total likes 81370 81370 \n",
"Type Photo Photo \n",
"Category 1 3 \n",
"Post Month 1 1 \n",
"Post Weekday 5 4 \n",
"Post Hour 2 11 \n",
"Paid 0.0 0.0 \n",
"Lifetime Post Total Reach 3778 4156 \n",
"Lifetime Post Total Impressions 7216 7564 \n",
"Lifetime Engaged Users 625 626 \n",
"Lifetime Post Consumers 572 574 \n",
"Lifetime Post Consumptions 795 832 \n",
"Lifetime Post Impressions by people who have li... 4742 4534 \n",
"Lifetime Post reach by people who like your Page 2388 2452 \n",
"Lifetime People who have liked your Page and en... 363 370 \n",
"comment 4 7 \n",
"like 93.0 91.0 \n",
"share 18.0 38.0 \n",
"Total Interactions 115 136 \n",
"\n",
"[19 rows x 499 columns]"
]
},
"execution_count": 23,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"#Transposing the data\n",
"data_transpose = data.transpose()\n",
"data_transpose"
]
},
{
"cell_type": "code",
"execution_count": 24,
"id": "2ce28ad0",
"metadata": {
"tags": []
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Page total likes</th>\n",
" <th>Type</th>\n",
" <th>Category</th>\n",
" <th>Post Month</th>\n",
" <th>Post Weekday</th>\n",
" <th>Post Hour</th>\n",
" <th>Paid</th>\n",
" <th>Lifetime Post Total Reach</th>\n",
" <th>Lifetime Post Total Impressions</th>\n",
" <th>Lifetime Engaged Users</th>\n",
" <th>Lifetime Post Consumers</th>\n",
" <th>Lifetime Post Consumptions</th>\n",
" <th>Lifetime Post Impressions by people who have liked your Page</th>\n",
" <th>Lifetime Post reach by people who like your Page</th>\n",
" <th>Lifetime People who have liked your Page and engaged with your post</th>\n",
" <th>comment</th>\n",
" <th>like</th>\n",
" <th>share</th>\n",
" <th>Total Interactions</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>4</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>2752</td>\n",
" <td>5091</td>\n",
" <td>178</td>\n",
" <td>109</td>\n",
" <td>159</td>\n",
" <td>3078</td>\n",
" <td>1640</td>\n",
" <td>119</td>\n",
" <td>4</td>\n",
" <td>79.0</td>\n",
" <td>17.0</td>\n",
" <td>100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>139441</td>\n",
" <td>Status</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>3</td>\n",
" <td>10</td>\n",
" <td>0.0</td>\n",
" <td>10460</td>\n",
" <td>19057</td>\n",
" <td>1457</td>\n",
" <td>1361</td>\n",
" <td>1674</td>\n",
" <td>11710</td>\n",
" <td>6112</td>\n",
" <td>1108</td>\n",
" <td>5</td>\n",
" <td>130.0</td>\n",
" <td>29.0</td>\n",
" <td>164</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>12</td>\n",
" <td>3</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>2413</td>\n",
" <td>4373</td>\n",
" <td>177</td>\n",
" <td>113</td>\n",
" <td>154</td>\n",
" <td>2812</td>\n",
" <td>1503</td>\n",
" <td>132</td>\n",
" <td>0</td>\n",
" <td>66.0</td>\n",
" <td>14.0</td>\n",
" <td>80</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>2</td>\n",
" <td>10</td>\n",
" <td>1.0</td>\n",
" <td>50128</td>\n",
" <td>87991</td>\n",
" <td>2211</td>\n",
" <td>790</td>\n",
" <td>1119</td>\n",
" <td>61027</td>\n",
" <td>32048</td>\n",
" <td>1386</td>\n",
" <td>58</td>\n",
" <td>1572.0</td>\n",
" <td>147.0</td>\n",
" <td>1777</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>139441</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>12</td>\n",
" <td>2</td>\n",
" <td>3</td>\n",
" <td>0.0</td>\n",
" <td>7244</td>\n",
" <td>13594</td>\n",
" <td>671</td>\n",
" <td>410</td>\n",
" <td>580</td>\n",
" <td>6228</td>\n",
" <td>3200</td>\n",
" <td>396</td>\n",
" <td>19</td>\n",
" <td>325.0</td>\n",
" <td>49.0</td>\n",
" <td>393</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>494</th>\n",
" <td>85093</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>10</td>\n",
" <td>0.0</td>\n",
" <td>5400</td>\n",
" <td>9218</td>\n",
" <td>810</td>\n",
" <td>756</td>\n",
" <td>1003</td>\n",
" <td>5654</td>\n",
" <td>3230</td>\n",
" <td>422</td>\n",
" <td>10</td>\n",
" <td>125.0</td>\n",
" <td>41.0</td>\n",
" <td>176</td>\n",
" </tr>\n",
" <tr>\n",
" <th>495</th>\n",
" <td>85093</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>7</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>4684</td>\n",
" <td>7536</td>\n",
" <td>733</td>\n",
" <td>708</td>\n",
" <td>985</td>\n",
" <td>4750</td>\n",
" <td>2876</td>\n",
" <td>392</td>\n",
" <td>5</td>\n",
" <td>53.0</td>\n",
" <td>26.0</td>\n",
" <td>84</td>\n",
" </tr>\n",
" <tr>\n",
" <th>496</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>2</td>\n",
" <td>1</td>\n",
" <td>5</td>\n",
" <td>8</td>\n",
" <td>0.0</td>\n",
" <td>3480</td>\n",
" <td>6229</td>\n",
" <td>537</td>\n",
" <td>508</td>\n",
" <td>687</td>\n",
" <td>3961</td>\n",
" <td>2104</td>\n",
" <td>301</td>\n",
" <td>0</td>\n",
" <td>53.0</td>\n",
" <td>22.0</td>\n",
" <td>75</td>\n",
" </tr>\n",
" <tr>\n",
" <th>497</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>5</td>\n",
" <td>2</td>\n",
" <td>0.0</td>\n",
" <td>3778</td>\n",
" <td>7216</td>\n",
" <td>625</td>\n",
" <td>572</td>\n",
" <td>795</td>\n",
" <td>4742</td>\n",
" <td>2388</td>\n",
" <td>363</td>\n",
" <td>4</td>\n",
" <td>93.0</td>\n",
" <td>18.0</td>\n",
" <td>115</td>\n",
" </tr>\n",
" <tr>\n",
" <th>498</th>\n",
" <td>81370</td>\n",
" <td>Photo</td>\n",
" <td>3</td>\n",
" <td>1</td>\n",
" <td>4</td>\n",
" <td>11</td>\n",
" <td>0.0</td>\n",
" <td>4156</td>\n",
" <td>7564</td>\n",
" <td>626</td>\n",
" <td>574</td>\n",
" <td>832</td>\n",
" <td>4534</td>\n",
" <td>2452</td>\n",
" <td>370</td>\n",
" <td>7</td>\n",
" <td>91.0</td>\n",
" <td>38.0</td>\n",
" <td>136</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>499 rows × 19 columns</p>\n",
"</div>"
],
"text/plain": [
" 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",
"494 85093 Photo 3 1 7 10 \n",
"495 85093 Photo 3 1 7 2 \n",
"496 81370 Photo 2 1 5 8 \n",
"497 81370 Photo 1 1 5 2 \n",
"498 81370 Photo 3 1 4 11 \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",
"494 0.0 5400 9218 \n",
"495 0.0 4684 7536 \n",
"496 0.0 3480 6229 \n",
"497 0.0 3778 7216 \n",
"498 0.0 4156 7564 \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",
"494 810 756 \n",
"495 733 708 \n",
"496 537 508 \n",
"497 625 572 \n",
"498 626 574 \n",
"\n",
" Lifetime Post Consumptions \n",
"0 159 \\\n",
"1 1674 \n",
"2 154 \n",
"3 1119 \n",
"4 580 \n",
".. ... \n",
"494 1003 \n",
"495 985 \n",
"496 687 \n",
"497 795 \n",
"498 832 \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",
"494 5654 \n",
"495 4750 \n",
"496 3961 \n",
"497 4742 \n",
"498 4534 \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",
"494 3230 \n",
"495 2876 \n",
"496 2104 \n",
"497 2388 \n",
"498 2452 \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",
"494 422 \n",
"495 392 \n",
"496 301 \n",
"497 363 \n",
"498 370 \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",
".. ... ... ... ... \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",
"\n",
"[499 rows x 19 columns]"
]
},
"execution_count": 24,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.shape\n",
"data"
]
},
{
"cell_type": "code",
"execution_count": 25,
"id": "944c5852",
"metadata": {
"tags": []
},
"outputs": [
{
"data": {
"text/plain": [
"Index(['Page total likes', 'Type', 'Category', 'Post Month', 'Post Weekday',\n",
" 'Post Hour', 'Paid', 'Lifetime Post Total Reach',\n",
" 'Lifetime Post Total Impressions', 'Lifetime Engaged Users',\n",
" 'Lifetime Post Consumers', 'Lifetime Post Consumptions',\n",
" 'Lifetime Post Impressions by people who have liked your Page',\n",
" 'Lifetime Post reach by people who like your Page',\n",
" 'Lifetime People who have liked your Page and engaged with your post',\n",
" 'comment', 'like', 'share', 'Total Interactions'],\n",
" dtype='object')"
]
},
"execution_count": 25,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"data.columns"
]
},
{
"cell_type": "code",
"execution_count": 26,
"id": "f0313cd9-dba7-4aca-b5c1-43d9854d12f4",
"metadata": {
"tags": []
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead tr th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe thead tr:last-of-type th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr>\n",
" <th></th>\n",
" <th colspan=\"2\" halign=\"left\">Category</th>\n",
" <th colspan=\"2\" halign=\"left\">Lifetime Engaged Users</th>\n",
" <th colspan=\"2\" halign=\"left\">Lifetime People who have liked your Page and engaged with your post</th>\n",
" <th colspan=\"2\" halign=\"left\">Lifetime Post Consumers</th>\n",
" <th colspan=\"2\" halign=\"left\">Lifetime Post Consumptions</th>\n",
" <th>...</th>\n",
" <th colspan=\"2\" halign=\"left\">Post Weekday</th>\n",
" <th colspan=\"2\" halign=\"left\">Total Interactions</th>\n",
" <th colspan=\"2\" halign=\"left\">comment</th>\n",
" <th colspan=\"2\" halign=\"left\">like</th>\n",
" <th colspan=\"2\" halign=\"left\">share</th>\n",
" </tr>\n",
" <tr>\n",
" <th>Paid</th>\n",
" <th>0.0</th>\n",
" <th>1.0</th>\n",
" <th>0.0</th>\n",
" <th>1.0</th>\n",
" <th>0.0</th>\n",
" <th>1.0</th>\n",
" <th>0.0</th>\n",
" <th>1.0</th>\n",
" <th>0.0</th>\n",
" <th>1.0</th>\n",
" <th>...</th>\n",
" <th>0.0</th>\n",
" <th>1.0</th>\n",
" <th>0.0</th>\n",
" <th>1.0</th>\n",
" <th>0.0</th>\n",
" <th>1.0</th>\n",
" <th>0.0</th>\n",
" <th>1.0</th>\n",
" <th>0.0</th>\n",
" <th>1.0</th>\n",
" </tr>\n",
" <tr>\n",
" <th>Type</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>Link</th>\n",
" <td>1.187500</td>\n",
" <td>1.000000</td>\n",
" <td>385.562500</td>\n",
" <td>228.833333</td>\n",
" <td>235.375000</td>\n",
" <td>144.333333</td>\n",
" <td>333.000000</td>\n",
" <td>185.166667</td>\n",
" <td>419.500000</td>\n",
" <td>253.000000</td>\n",
" <td>...</td>\n",
" <td>4.000000</td>\n",
" <td>5.000000</td>\n",
" <td>95.812500</td>\n",
" <td>71.000000</td>\n",
" <td>2.375000</td>\n",
" <td>4.000000</td>\n",
" <td>79.562500</td>\n",
" <td>56.666667</td>\n",
" <td>13.875000</td>\n",
" <td>10.333333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Photo</th>\n",
" <td>1.918301</td>\n",
" <td>1.915966</td>\n",
" <td>743.228758</td>\n",
" <td>1015.789916</td>\n",
" <td>482.957516</td>\n",
" <td>571.521008</td>\n",
" <td>634.656863</td>\n",
" <td>835.252101</td>\n",
" <td>1181.398693</td>\n",
" <td>1606.168067</td>\n",
" <td>...</td>\n",
" <td>4.124183</td>\n",
" <td>4.067227</td>\n",
" <td>191.248366</td>\n",
" <td>282.537815</td>\n",
" <td>6.598039</td>\n",
" <td>9.857143</td>\n",
" <td>160.235117</td>\n",
" <td>240.882353</td>\n",
" <td>25.353152</td>\n",
" <td>31.798319</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Status</th>\n",
" <td>2.057143</td>\n",
" <td>1.900000</td>\n",
" <td>1937.942857</td>\n",
" <td>2398.200000</td>\n",
" <td>1657.228571</td>\n",
" <td>1939.000000</td>\n",
" <td>1853.857143</td>\n",
" <td>2284.500000</td>\n",
" <td>2623.542857</td>\n",
" <td>3592.500000</td>\n",
" <td>...</td>\n",
" <td>4.628571</td>\n",
" <td>4.400000</td>\n",
" <td>181.571429</td>\n",
" <td>341.200000</td>\n",
" <td>7.200000</td>\n",
" <td>14.900000</td>\n",
" <td>147.828571</td>\n",
" <td>277.800000</td>\n",
" <td>26.542857</td>\n",
" <td>48.500000</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Video</th>\n",
" <td>1.000000</td>\n",
" <td>1.000000</td>\n",
" <td>1458.666667</td>\n",
" <td>1893.250000</td>\n",
" <td>943.666667</td>\n",
" <td>1006.250000</td>\n",
" <td>1352.333333</td>\n",
" <td>1759.000000</td>\n",
" <td>2092.000000</td>\n",
" <td>2981.250000</td>\n",
" <td>...</td>\n",
" <td>2.333333</td>\n",
" <td>4.500000</td>\n",
" <td>285.666667</td>\n",
" <td>303.500000</td>\n",
" <td>10.333333</td>\n",
" <td>13.750000</td>\n",
" <td>216.000000</td>\n",
" <td>243.000000</td>\n",
" <td>59.333333</td>\n",
" <td>46.750000</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>4 rows × 34 columns</p>\n",
"</div>"
],
"text/plain": [
" Category Lifetime Engaged Users \n",
"Paid 0.0 1.0 0.0 1.0 \n",
"Type \n",
"Link 1.187500 1.000000 385.562500 228.833333 \\\n",
"Photo 1.918301 1.915966 743.228758 1015.789916 \n",
"Status 2.057143 1.900000 1937.942857 2398.200000 \n",
"Video 1.000000 1.000000 1458.666667 1893.250000 \n",
"\n",
" Lifetime People who have liked your Page and engaged with your post \n",
"Paid 0.0 \n",
"Type \n",
"Link 235.375000 \\\n",
"Photo 482.957516 \n",
"Status 1657.228571 \n",
"Video 943.666667 \n",
"\n",
" Lifetime Post Consumers \n",
"Paid 1.0 0.0 1.0 \n",
"Type \n",
"Link 144.333333 333.000000 185.166667 \\\n",
"Photo 571.521008 634.656863 835.252101 \n",
"Status 1939.000000 1853.857143 2284.500000 \n",
"Video 1006.250000 1352.333333 1759.000000 \n",
"\n",
" Lifetime Post Consumptions ... Post Weekday \n",
"Paid 0.0 1.0 ... 0.0 1.0 \n",
"Type ... \n",
"Link 419.500000 253.000000 ... 4.000000 5.000000 \\\n",
"Photo 1181.398693 1606.168067 ... 4.124183 4.067227 \n",
"Status 2623.542857 3592.500000 ... 4.628571 4.400000 \n",
"Video 2092.000000 2981.250000 ... 2.333333 4.500000 \n",
"\n",
" Total Interactions comment like \n",
"Paid 0.0 1.0 0.0 1.0 0.0 \n",
"Type \n",
"Link 95.812500 71.000000 2.375000 4.000000 79.562500 \\\n",
"Photo 191.248366 282.537815 6.598039 9.857143 160.235117 \n",
"Status 181.571429 341.200000 7.200000 14.900000 147.828571 \n",
"Video 285.666667 303.500000 10.333333 13.750000 216.000000 \n",
"\n",
" share \n",
"Paid 1.0 0.0 1.0 \n",
"Type \n",
"Link 56.666667 13.875000 10.333333 \n",
"Photo 240.882353 25.353152 31.798319 \n",
"Status 277.800000 26.542857 48.500000 \n",
"Video 243.000000 59.333333 46.750000 \n",
"\n",
"[4 rows x 34 columns]"
]
},
"execution_count": 26,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pd.pivot_table(data,index='Type',columns='Paid')"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "e4e30b99-f553-46fd-b3fb-7e2dd4dcb2f4",
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"id": "6ed3631c",
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"id": "89521af3",
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"id": "f3938d25",
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"id": "a158e7bd",
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"id": "a18eb45b",
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"id": "8065d0ce",
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"id": "45366147",
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"id": "4278a525",
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"id": "2bbd8ad6",
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3 (ipykernel)",
"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.8.10"
}
},
"nbformat": 4,
"nbformat_minor": 5
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment