Contents

Facebook Pages of Breweries

Facebook Pages of Breweries

A dataset of facebook posts of hungarian breweries.

Entity Relationship Diagram (ERD)

What is an Entity Relationship Diagram (ERD)?

An entity relationship diagram (ERD) shows the relationships of entity sets stored in a database. An entity in this context is an object, a component of data, for example a variable. An entity set is a collection of similar entities. These entities can have attributes that define their properties.

By defining the entities, and their attributes, and showing the relationships between them, an ER diagram illustrates the logical structure of databases.

Each table demonstrates an entity set, where the rows represent the entities. Each entity set contains a primary key (PK) which is unique in the table. A primary key can be one entity, for example, a tax number or a set of entities like longitude and latitude in spatial data.

An entity set may have got a foreign key (FK). It means that the table is connected to another table’s primary key. This relationship can be represented by a line with a sign on its every ending. The sign specifies how many instances of an entity relate to one instance of another entity:

  • double lines (one)

  • branching line (more)

erDiagram post_export { INTEGER comments VARCHAR link INTEGER page_followers INTEGER page_likes VARCHAR page_name VARCHAR post_id DATETIME posted INTEGER reactions DATETIME recorded INTEGER shares }

Exploratory Data Analysis (EDA)

What does exploratory data analysis contain?

These are some summaries of the initial analyses we conducted on the tables of the dataset. They are based on our ideas that we think can be further explored in a research project.

The exploration notebooks can be checked by clicking on the Open Notebook button. If you just want to see the output figures of the analysis, then open them with the Figures button.

First look at stats of pages

Open Notebook

Stats of pages
  Page likes Page followers First post Post count Mean post reactions Median post reactions Mean post comments Median post comments Mean post shares Median post shares
page_name                    
972 Brewpub 1590 1655 2018-07-03 13:22:00 236 23.949153 17.000000 0.991525 0.000000 6.203390 3.000000
Beer Corner - Pub & Restaurant 4568 4684 2018-01-27 18:26:00 1076 23.225836 11.000000 0.679368 0.000000 3.572491 1.000000
BeerPanic 545 581 2019-02-22 11:47:00 34 34.676471 33.000000 1.470588 1.000000 4.205882 2.000000
BigFoot Sörfőzde 5135 5241 2013-11-18 12:51:00 2104 15.778042 10.000000 0.931084 0.000000 2.523289 1.000000
Bors Serfőzde 1232 1317 2016-09-25 21:13:00 143 28.000000 22.000000 2.160839 0.000000 2.797203 0.000000
Brandecker Sörház - Ecser 971 977 2013-03-09 09:26:00 93 6.107527 4.000000 0.451613 0.000000 0.473118 0.000000
Brew Your Mind sörfőzde 3872 4145 2015-09-11 11:39:00 757 44.125495 34.000000 1.565390 0.000000 2.113606 1.000000
Békésszentandrási Szent András Sörfőzde 29844 30557 2011-05-09 22:08:00 1388 81.615274 38.000000 9.742795 1.000000 10.463256 3.000000
Etyeki Sörmanufaktúra 20573 20817 2016-01-11 15:43:00 1447 57.737388 22.000000 27.194886 0.000000 8.912923 1.000000
FIRST The Craft Beer Co. 11406 11931 2016-11-07 11:01:00 2413 20.498135 12.000000 1.353502 0.000000 1.082470 0.000000
Fehér Nyúl Brewery & Taproom 8254 8862 2017-05-26 07:41:00 816 42.094363 27.000000 1.802696 0.000000 3.029412 1.000000
Fekete Péter Manufaktúra 568 620 2019-01-29 15:27:00 232 7.431034 6.000000 0.310345 0.000000 0.469828 0.000000
Fekete és Fiai Kézműves Sörfőzde 1145 1164 2018-04-14 09:13:00 57 50.964912 31.000000 8.421053 0.000000 19.491228 6.000000
Fóti Kézműves Sörfőzde 6102 6447 2012-04-24 18:47:00 819 22.697192 9.000000 1.245421 0.000000 4.940171 1.000000
Guri Sörfőzde 1619 1688 2017-01-11 11:21:00 526 14.176806 8.000000 0.718631 0.000000 2.534221 1.000000
Gyertyános Sörfőzde 644 662 2021-05-10 10:25:00 29 18.068966 8.000000 0.931034 0.000000 8.275862 1.000000
HBH Bajor Sörház Kazincbarcika 3962 3975 2012-11-19 10:35:00 1205 10.281328 5.000000 1.031535 0.000000 3.834855 1.000000
Hajdú Serház sörfőzde és közösségi tér 2303 2396 2016-07-31 15:24:00 427 34.271663 24.000000 3.021077 0.000000 9.836066 3.000000
Hedon 838 863 2015-01-26 20:42:00 924 38.115801 22.000000 5.942641 0.000000 4.417749 1.000000
HopTop Brewery 6150 6439 2016-04-29 14:18:00 939 36.161874 26.000000 2.854100 0.000000 2.395101 0.000000
Hopfanatic Brewery 3644 3779 2013-03-25 21:00:00 343 37.107872 22.000000 3.615160 1.000000 5.116618 1.000000
Horizont Brewing 8453 8975 2014-05-23 00:00:00 2236 25.588998 12.000000 2.315295 0.000000 1.428891 0.000000
KUNST - Kézműves Sörfőzde 708 750 2020-07-01 13:14:00 117 13.717949 11.000000 0.888889 0.000000 4.350427 3.000000
Kissler Sörfőzde 1246 1283 2020-04-13 11:48:00 108 20.796296 6.500000 0.657407 0.000000 17.083333 10.000000
Kurbely Sör 13 13 2021-03-12 11:33:00 4 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000
Lőrinci Sörfőzde 635 663 2018-09-06 10:08:00 22 13.727273 9.500000 0.500000 0.000000 0.863636 0.000000
MONYO Brewing Co. 15914 16650 2014-09-11 06:51:00 1725 80.308986 52.000000 6.659130 2.000000 4.544928 2.000000
Mad Scientist 21197 22299 2015-07-15 00:00:00 3031 76.464203 54.000000 8.199274 3.000000 2.025074 1.000000
Mályi Ászok Kft 835 830 2012-12-05 23:09:00 225 9.982222 6.000000 0.595556 0.000000 1.791111 0.000000
Nopara 3139 3230 2014-01-11 18:52:00 1287 22.013986 17.000000 0.998446 0.000000 2.759907 2.000000
Nyéki sör 1478 1566 2020-06-15 07:55:00 181 16.828729 11.000000 0.790055 0.000000 6.475138 4.000000
Palóc sör 831 855 2013-09-16 13:27:00 124 19.677419 11.500000 1.282258 0.000000 3.814516 2.000000
Pannonhalmi Főapátság Sörfőzde 3268 3389 2020-07-13 15:31:00 160 117.625000 48.500000 11.962500 1.000000 8.525000 3.000000
Rehák Sörmanufaktúra 308 319 2018-01-16 14:02:00 73 19.506849 16.000000 0.575342 0.000000 1.904110 0.000000
Reketye Brewing Co. 5688 6039 2014-09-17 09:40:00 876 41.203196 26.000000 1.907534 0.000000 1.835616 1.000000
Rotburger látványsörfőzde, söröző és sörkert 4212 4290 2012-02-15 01:48:00 564 20.806738 14.000000 0.615248 0.000000 1.654255 0.000000
Ruin Brew 747 799 2021-08-01 12:17:00 140 13.357143 9.000000 0.871429 0.000000 1.135714 0.000000
Stari Sör 2639 2776 2013-02-17 12:33:00 736 20.205163 14.000000 1.226902 0.000000 3.228261 1.000000
SteamCraft Sörkert&Bisztró 1540 1614 2020-04-08 09:37:00 252 18.496032 9.000000 0.912698 0.000000 7.329365 6.000000
Synthesis 1558 1653 2016-04-26 06:45:00 443 11.121896 6.000000 0.722348 0.000000 1.744921 0.000000
Szarvasi Sörfőzde 7233 7294 2014-12-10 11:54:00 423 31.801418 22.000000 4.290780 0.000000 5.978723 1.000000
UGAR Brewery 3602 3887 2016-09-03 17:46:00 911 29.919868 21.000000 1.119649 0.000000 2.710209 2.000000
Vandál Brewing 1117 1197 2018-07-16 22:11:00 119 15.226891 11.000000 0.899160 0.000000 2.243697 1.000000
Vaskakas Sörfőzde 3015 3220 2015-03-13 17:42:00 705 22.462411 14.000000 0.680851 0.000000 3.476596 1.000000
Zirci Apátsági Manufaktúra 15728 15838 2015-06-01 00:00:00 503 181.367793 72.000000 6.520875 1.000000 16.502982 4.000000
Zsombói Sörfőzde 855 892 2016-05-27 22:33:00 33 28.393939 18.000000 2.212121 0.000000 8.090909 2.000000
hübris 3443 3688 2015-05-23 18:04:00 424 18.981132 11.000000 0.603774 0.000000 1.150943 0.000000
ÁPERTE sörök 661 670 2016-05-31 11:24:00 66 19.242424 14.000000 0.772727 0.000000 0.803030 0.000000

Tables

How should I use this?

Table information

Each table has a Table Profile, generated by pandas-profiling. This includes descriptive statistics based on the table data and metadata, which can save significant time during the pre-analysis. Each profiling contains descriptives of the variables and additionally may show interactions, correlations, missing data information, and samples of the data. To see the profiling click on Open Table Profile.

Furthermore, you can check the first 5 rows of the tables by clicking on the First 5 rows button.

Download links

The table data can be downloaded in CSV format with Download CSV button. Before this step, we recommend checking the table profile!

Updating information

Some datasets are updated periodically. In this case, you can check the updating period at the top of this section.

There is 1 table

Post Export Table

Download CSV

Open Table Profile

Size: 31496 × 10 (5.81 MB)

Last Changed: 2022-12-07 17:22

comments link page_followers page_likes page_name post_id posted reactions recorded shares
0 0 /story.php?story_fbid=984840285496223&id=17553... 1655 1590 972 Brewpub 984840285496223 2022-04-15 16:22:00 9 2022-06-23 1
1 0 /story.php?story_fbid=944277216219197&id=17553... 1655 1590 972 Brewpub 944277216219197 2022-02-04 17:57:00 7 2022-06-23 0
2 0 /story.php?story_fbid=904718363508416&id=17553... 1655 1590 972 Brewpub 904718363508416 2021-11-25 16:39:00 3 2022-06-23 0
3 0 /story.php?story_fbid=880503095929943&id=17553... 1655 1590 972 Brewpub 880503095929943 2021-10-14 15:56:00 1 2022-06-23 0
4 0 /story.php?story_fbid=879360716044181&id=17553... 1655 1590 972 Brewpub 879360716044181 2021-10-12 19:15:00 3 2022-06-23 1

previous

Hungarian elections analysis

next

First look at stats of pages