{ "cells": [ { "cell_type": "markdown", "id": "b79686c9", "metadata": {}, "source": [ "# First look at stats of pages" ] }, { "cell_type": "code", "execution_count": 1, "id": "116035f1", "metadata": { "execution": { "iopub.execute_input": "2023-05-04T15:13:58.043209Z", "iopub.status.busy": "2023-05-04T15:13:58.042916Z", "iopub.status.idle": "2023-05-04T15:13:58.355767Z", "shell.execute_reply": "2023-05-04T15:13:58.354967Z" } }, "outputs": [], "source": [ "import pandas as pd\n", "from itertools import product" ] }, { "cell_type": "code", "execution_count": 2, "id": "76f0f59f", "metadata": { "execution": { "iopub.execute_input": "2023-05-04T15:13:58.359578Z", "iopub.status.busy": "2023-05-04T15:13:58.359019Z", "iopub.status.idle": "2023-05-04T15:13:58.460298Z", "shell.execute_reply": "2023-05-04T15:13:58.459483Z" } }, "outputs": [], "source": [ "df_post_export = pd.read_csv(\"post_export.csv\")" ] }, { "cell_type": "code", "execution_count": 3, "id": "a68d840e", "metadata": { "execution": { "iopub.execute_input": "2023-05-04T15:13:58.464759Z", "iopub.status.busy": "2023-05-04T15:13:58.464290Z", "iopub.status.idle": "2023-05-04T15:13:58.597337Z", "shell.execute_reply": "2023-05-04T15:13:58.596557Z" }, "scrolled": false }, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Stats of pages
 Page likesPage followersFirst postPost countMean post reactionsMedian post reactionsMean post commentsMedian post commentsMean post sharesMedian post shares
page_name          
972 Brewpub159016552018-07-03 13:22:0023623.94915317.0000000.9915250.0000006.2033903.000000
Beer Corner - Pub & Restaurant456846842018-01-27 18:26:00107623.22583611.0000000.6793680.0000003.5724911.000000
BeerPanic5455812019-02-22 11:47:003434.67647133.0000001.4705881.0000004.2058822.000000
BigFoot Sörfőzde513552412013-11-18 12:51:00210415.77804210.0000000.9310840.0000002.5232891.000000
Bors Serfőzde123213172016-09-25 21:13:0014328.00000022.0000002.1608390.0000002.7972030.000000
Brandecker Sörház - Ecser9719772013-03-09 09:26:00936.1075274.0000000.4516130.0000000.4731180.000000
Brew Your Mind sörfőzde387241452015-09-11 11:39:0075744.12549534.0000001.5653900.0000002.1136061.000000
Békésszentandrási Szent András Sörfőzde29844305572011-05-09 22:08:00138881.61527438.0000009.7427951.00000010.4632563.000000
Etyeki Sörmanufaktúra20573208172016-01-11 15:43:00144757.73738822.00000027.1948860.0000008.9129231.000000
FIRST The Craft Beer Co.11406119312016-11-07 11:01:00241320.49813512.0000001.3535020.0000001.0824700.000000
Fehér Nyúl Brewery & Taproom825488622017-05-26 07:41:0081642.09436327.0000001.8026960.0000003.0294121.000000
Fekete Péter Manufaktúra5686202019-01-29 15:27:002327.4310346.0000000.3103450.0000000.4698280.000000
Fekete és Fiai Kézműves Sörfőzde114511642018-04-14 09:13:005750.96491231.0000008.4210530.00000019.4912286.000000
Fóti Kézműves Sörfőzde610264472012-04-24 18:47:0081922.6971929.0000001.2454210.0000004.9401711.000000
Guri Sörfőzde161916882017-01-11 11:21:0052614.1768068.0000000.7186310.0000002.5342211.000000
Gyertyános Sörfőzde6446622021-05-10 10:25:002918.0689668.0000000.9310340.0000008.2758621.000000
HBH Bajor Sörház Kazincbarcika396239752012-11-19 10:35:00120510.2813285.0000001.0315350.0000003.8348551.000000
Hajdú Serház sörfőzde és közösségi tér230323962016-07-31 15:24:0042734.27166324.0000003.0210770.0000009.8360663.000000
Hedon8388632015-01-26 20:42:0092438.11580122.0000005.9426410.0000004.4177491.000000
HopTop Brewery615064392016-04-29 14:18:0093936.16187426.0000002.8541000.0000002.3951010.000000
Hopfanatic Brewery364437792013-03-25 21:00:0034337.10787222.0000003.6151601.0000005.1166181.000000
Horizont Brewing845389752014-05-23 00:00:00223625.58899812.0000002.3152950.0000001.4288910.000000
KUNST - Kézműves Sörfőzde7087502020-07-01 13:14:0011713.71794911.0000000.8888890.0000004.3504273.000000
Kissler Sörfőzde124612832020-04-13 11:48:0010820.7962966.5000000.6574070.00000017.08333310.000000
Kurbely Sör13132021-03-12 11:33:0040.0000000.0000000.0000000.0000000.0000000.000000
Lőrinci Sörfőzde6356632018-09-06 10:08:002213.7272739.5000000.5000000.0000000.8636360.000000
MONYO Brewing Co.15914166502014-09-11 06:51:00172580.30898652.0000006.6591302.0000004.5449282.000000
Mad Scientist21197222992015-07-15 00:00:00303176.46420354.0000008.1992743.0000002.0250741.000000
Mályi Ászok Kft8358302012-12-05 23:09:002259.9822226.0000000.5955560.0000001.7911110.000000
Nopara313932302014-01-11 18:52:00128722.01398617.0000000.9984460.0000002.7599072.000000
Nyéki sör147815662020-06-15 07:55:0018116.82872911.0000000.7900550.0000006.4751384.000000
Palóc sör8318552013-09-16 13:27:0012419.67741911.5000001.2822580.0000003.8145162.000000
Pannonhalmi Főapátság Sörfőzde326833892020-07-13 15:31:00160117.62500048.50000011.9625001.0000008.5250003.000000
Rehák Sörmanufaktúra3083192018-01-16 14:02:007319.50684916.0000000.5753420.0000001.9041100.000000
Reketye Brewing Co.568860392014-09-17 09:40:0087641.20319626.0000001.9075340.0000001.8356161.000000
Rotburger látványsörfőzde, söröző és sörkert421242902012-02-15 01:48:0056420.80673814.0000000.6152480.0000001.6542550.000000
Ruin Brew7477992021-08-01 12:17:0014013.3571439.0000000.8714290.0000001.1357140.000000
Stari Sör263927762013-02-17 12:33:0073620.20516314.0000001.2269020.0000003.2282611.000000
SteamCraft Sörkert&Bisztró154016142020-04-08 09:37:0025218.4960329.0000000.9126980.0000007.3293656.000000
Synthesis155816532016-04-26 06:45:0044311.1218966.0000000.7223480.0000001.7449210.000000
Szarvasi Sörfőzde723372942014-12-10 11:54:0042331.80141822.0000004.2907800.0000005.9787231.000000
UGAR Brewery360238872016-09-03 17:46:0091129.91986821.0000001.1196490.0000002.7102092.000000
Vandál Brewing111711972018-07-16 22:11:0011915.22689111.0000000.8991600.0000002.2436971.000000
Vaskakas Sörfőzde301532202015-03-13 17:42:0070522.46241114.0000000.6808510.0000003.4765961.000000
Zirci Apátsági Manufaktúra15728158382015-06-01 00:00:00503181.36779372.0000006.5208751.00000016.5029824.000000
Zsombói Sörfőzde8558922016-05-27 22:33:003328.39393918.0000002.2121210.0000008.0909092.000000
hübris344336882015-05-23 18:04:0042418.98113211.0000000.6037740.0000001.1509430.000000
ÁPERTE sörök6616702016-05-31 11:24:006619.24242414.0000000.7727270.0000000.8030300.000000
\n" ], "text/plain": [ "" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_post_export.groupby(\"page_name\").agg(\n", " **{\n", " \"Page likes\": pd.NamedAgg(\"page_likes\", \"first\"),\n", " \"Page followers\": pd.NamedAgg(\"page_followers\", \"first\"),\n", " \"First post\": pd.NamedAgg(\"posted\", \"min\"),\n", " \"Post count\": pd.NamedAgg(\"link\", \"count\"),\n", " **{\n", " f\"{agg.title()} post {k}\": pd.NamedAgg(k, agg)\n", " for k, agg in product([\"reactions\", \"comments\", \"shares\"], [\"mean\", \"median\"])\n", " },\n", " }\n", ").style.background_gradient(axis=0,).set_caption(\"Stats of pages\")" ] } ], "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.10.11" } }, "nbformat": 4, "nbformat_minor": 5 }