Overview

Dataset statistics

Number of variables10
Number of observations31496
Missing cells0
Missing cells (%)0.0%
Total size in memory2.4 MiB
Average record size in memory80.0 B

Variable types

Numeric5
Categorical3
DateTime2

Alerts

recorded has constant value ""Constant
link has a high cardinality: 31463 distinct valuesHigh cardinality
post_id has a high cardinality: 31463 distinct valuesHigh cardinality
comments is highly skewed (γ1 = 22.73162923)Skewed
reactions is highly skewed (γ1 = 41.61488469)Skewed
shares is highly skewed (γ1 = 28.46944763)Skewed
comments has 19469 (61.8%) zerosZeros
reactions has 620 (2.0%) zerosZeros
shares has 13649 (43.3%) zerosZeros

Reproduction

Analysis started2023-05-04 15:13:41.978275
Analysis finished2023-05-04 15:13:42.726131
Duration0.75 seconds
Software versionydata-profiling vv4.1.2
Download configurationconfig.json

Variables

comments
Real number (ℝ)

SKEWED  ZEROS 

Distinct230
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.194056388
Minimum0
Maximum1800
Zeros19469
Zeros (%)61.8%
Negative0
Negative (%)0.0%
Memory size246.2 KiB
2023-05-04T15:13:42.801943image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q32
95-th percentile11
Maximum1800
Range1800
Interquartile range (IQR)2

Descriptive statistics

Standard deviation37.01469222
Coefficient of variation (CV)8.825511341
Kurtosis662.8151042
Mean4.194056388
Median Absolute Deviation (MAD)0
Skewness22.73162923
Sum132096
Variance1370.08744
MonotonicityNot monotonic
2023-05-04T15:13:42.952923image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 19469
61.8%
1 3613
 
11.5%
2 2194
 
7.0%
3 1324
 
4.2%
4 948
 
3.0%
5 641
 
2.0%
6 472
 
1.5%
7 393
 
1.2%
8 337
 
1.1%
9 222
 
0.7%
Other values (220) 1883
 
6.0%
ValueCountFrequency (%)
0 19469
61.8%
1 3613
 
11.5%
2 2194
 
7.0%
3 1324
 
4.2%
4 948
 
3.0%
ValueCountFrequency (%)
1800 1
< 0.1%
1500 1
< 0.1%
1400 1
< 0.1%
1300 1
< 0.1%
1200 2
< 0.1%

link
Categorical

Distinct31463
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Memory size246.2 KiB
/hbhkazincbarcika1/photos/a.1395494867389677/1614667588805736/?type=3&m_entstream_source=timeline&__tn__=-R
 
4
/story.php?story_fbid=2600608660057188&id=617104425074298&m_entstream_source=timeline&__tn__=-R
 
3
/vaskakassorfozde/photos/a.652961974780935/2402132359863879/?type=3&m_entstream_source=timeline&__tn__=-R
 
2
/HorizontSorok/photos/a.288367178006758/1227151610794972/?type=3&m_entstream_source=timeline&__tn__=-R
 
2
/SzentAndrasSorfozde/photos/a.262103920533765/1322428314501315/?type=3&m_entstream_source=timeline&__tn__=-R
 
2
Other values (31458)
31483 

Unique

Unique31433 ?
Unique (%)99.8%

Sample

1st row/story.php?story_fbid=984840285496223&id=175535143093412&m_entstream_source=timeline&__tn__=-R
2nd row/story.php?story_fbid=944277216219197&id=175535143093412&m_entstream_source=timeline&__tn__=-R
3rd row/story.php?story_fbid=904718363508416&id=175535143093412&m_entstream_source=timeline&__tn__=-R
4th row/story.php?story_fbid=880503095929943&id=175535143093412&m_entstream_source=timeline&__tn__=-R
5th row/story.php?story_fbid=879360716044181&id=175535143093412&m_entstream_source=timeline&__tn__=-R

Common Values

ValueCountFrequency (%)
/hbhkazincbarcika1/photos/a.1395494867389677/1614667588805736/?type=3&m_entstream_source=timeline&__tn__=-R 4
 
< 0.1%
/story.php?story_fbid=2600608660057188&id=617104425074298&m_entstream_source=timeline&__tn__=-R 3
 
< 0.1%
/vaskakassorfozde/photos/a.652961974780935/2402132359863879/?type=3&m_entstream_source=timeline&__tn__=-R 2
 
< 0.1%
/HorizontSorok/photos/a.288367178006758/1227151610794972/?type=3&m_entstream_source=timeline&__tn__=-R 2
 
< 0.1%
/SzentAndrasSorfozde/photos/a.262103920533765/1322428314501315/?type=3&m_entstream_source=timeline&__tn__=-R 2
 
< 0.1%
/etyekisor/photos/a.1768568256704369/2610068212554365/?type=3&m_entstream_source=timeline&__tn__=-R 2
 
< 0.1%
/madscientistbeer/photos/a.1670528369839951/3878455029047263/?type=3&m_entstream_source=timeline&__tn__=-R 2
 
< 0.1%
/story.php?story_fbid=348928908921973&id=290021248146073&m_entstream_source=timeline&__tn__=-R 2
 
< 0.1%
/BrewYourMindbeer/photos/a.1023925474305738/2886701408028126/?type=3&m_entstream_source=timeline&__tn__=-R 2
 
< 0.1%
/SynthesisCraftBeer/photos/a.603955936421944/703075596509977/?type=3&m_entstream_source=timeline&__tn__=-R 2
 
< 0.1%
Other values (31453) 31473
99.9%

page_followers
Real number (ℝ)

Distinct48
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean9536.595377
Minimum13
Maximum30557
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size246.2 KiB
2023-05-04T15:13:43.120467image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/

Quantile statistics

Minimum13
5-th percentile863
Q13688
median6039
Q315838
95-th percentile22299
Maximum30557
Range30544
Interquartile range (IQR)12150

Descriptive statistics

Standard deviation8108.454868
Coefficient of variation (CV)0.8502462931
Kurtosis0.03046659688
Mean9536.595377
Median Absolute Deviation (MAD)3263
Skewness1.045883362
Sum300364608
Variance65747040.34
MonotonicityNot monotonic
2023-05-04T15:13:43.270653image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram with fixed size bins (bins=48)
ValueCountFrequency (%)
22299 3031
 
9.6%
11931 2413
 
7.7%
8975 2236
 
7.1%
5241 2104
 
6.7%
16650 1725
 
5.5%
20817 1447
 
4.6%
30557 1388
 
4.4%
3230 1287
 
4.1%
3975 1205
 
3.8%
4684 1076
 
3.4%
Other values (38) 13584
43.1%
ValueCountFrequency (%)
13 4
 
< 0.1%
319 73
 
0.2%
581 34
 
0.1%
620 232
0.7%
662 29
 
0.1%
ValueCountFrequency (%)
30557 1388
4.4%
22299 3031
9.6%
20817 1447
4.6%
16650 1725
5.5%
15838 503
 
1.6%

page_likes
Real number (ℝ)

Distinct48
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean9172.08963
Minimum13
Maximum29844
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size246.2 KiB
2023-05-04T15:13:43.430547image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/

Quantile statistics

Minimum13
5-th percentile838
Q13443
median5688
Q315728
95-th percentile21197
Maximum29844
Range29831
Interquartile range (IQR)12285

Descriptive statistics

Standard deviation7851.744054
Coefficient of variation (CV)0.8560474625
Kurtosis0.1216713718
Mean9172.08963
Median Absolute Deviation (MAD)3049
Skewness1.074020332
Sum288884135
Variance61649884.68
MonotonicityNot monotonic
2023-05-04T15:13:43.579001image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram with fixed size bins (bins=48)
ValueCountFrequency (%)
21197 3031
 
9.6%
11406 2413
 
7.7%
8453 2236
 
7.1%
5135 2104
 
6.7%
15914 1725
 
5.5%
20573 1447
 
4.6%
29844 1388
 
4.4%
3139 1287
 
4.1%
3962 1205
 
3.8%
4568 1076
 
3.4%
Other values (38) 13584
43.1%
ValueCountFrequency (%)
13 4
 
< 0.1%
308 73
 
0.2%
545 34
 
0.1%
568 232
0.7%
635 22
 
0.1%
ValueCountFrequency (%)
29844 1388
4.4%
21197 3031
9.6%
20573 1447
4.6%
15914 1725
5.5%
15728 503
 
1.6%

page_name
Categorical

Distinct48
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size246.2 KiB
Mad Scientist
3031 
FIRST The Craft Beer Co.
2413 
Horizont Brewing
2236 
BigFoot Sörfőzde
2104 
MONYO Brewing Co.
 
1725
Other values (43)
19987 

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row972 Brewpub
2nd row972 Brewpub
3rd row972 Brewpub
4th row972 Brewpub
5th row972 Brewpub

Common Values

ValueCountFrequency (%)
Mad Scientist 3031
 
9.6%
FIRST The Craft Beer Co. 2413
 
7.7%
Horizont Brewing 2236
 
7.1%
BigFoot Sörfőzde 2104
 
6.7%
MONYO Brewing Co. 1725
 
5.5%
Etyeki Sörmanufaktúra 1447
 
4.6%
Békésszentandrási Szent András Sörfőzde 1388
 
4.4%
Nopara 1287
 
4.1%
HBH Bajor Sörház Kazincbarcika 1205
 
3.8%
Beer Corner - Pub & Restaurant 1076
 
3.4%
Other values (38) 13584
43.1%

post_id
Categorical

Distinct31463
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Memory size246.2 KiB
1614667588805736
 
4
2600608660057188
 
3
2402132359863879
 
2
1227151610794972
 
2
1322428314501315
 
2
Other values (31458)
31483 

Unique

Unique31433 ?
Unique (%)99.8%

Sample

1st row984840285496223
2nd row944277216219197
3rd row904718363508416
4th row880503095929943
5th row879360716044181

Common Values

ValueCountFrequency (%)
1614667588805736 4
 
< 0.1%
2600608660057188 3
 
< 0.1%
2402132359863879 2
 
< 0.1%
1227151610794972 2
 
< 0.1%
1322428314501315 2
 
< 0.1%
2610068212554365 2
 
< 0.1%
3878455029047263 2
 
< 0.1%
348928908921973 2
 
< 0.1%
2886701408028126 2
 
< 0.1%
703075596509977 2
 
< 0.1%
Other values (31453) 31473
99.9%

posted
Date

Distinct31130
Distinct (%)98.8%
Missing0
Missing (%)0.0%
Memory size246.2 KiB
Minimum2011-05-09 22:08:00
Maximum2022-06-21 21:40:00
2023-05-04T15:13:43.744321image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-05-04T15:13:43.902205image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

reactions
Real number (ℝ)

SKEWED  ZEROS 

Distinct560
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean39.5520066
Minimum0
Maximum10000
Zeros620
Zeros (%)2.0%
Negative0
Negative (%)0.0%
Memory size246.2 KiB
2023-05-04T15:13:44.071130image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2
Q18
median18
Q342
95-th percentile135
Maximum10000
Range10000
Interquartile range (IQR)34

Descriptive statistics

Standard deviation95.18057984
Coefficient of variation (CV)2.406466524
Kurtosis3889.409905
Mean39.5520066
Median Absolute Deviation (MAD)13
Skewness41.61488469
Sum1245730
Variance9059.342779
MonotonicityNot monotonic
2023-05-04T15:13:44.229372image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4 1142
 
3.6%
5 1102
 
3.5%
3 1041
 
3.3%
6 1011
 
3.2%
8 1005
 
3.2%
7 1003
 
3.2%
9 942
 
3.0%
2 930
 
3.0%
10 892
 
2.8%
1 851
 
2.7%
Other values (550) 21577
68.5%
ValueCountFrequency (%)
0 620
2.0%
1 851
2.7%
2 930
3.0%
3 1041
3.3%
4 1142
3.6%
ValueCountFrequency (%)
10000 1
< 0.1%
2700 1
< 0.1%
2300 1
< 0.1%
2200 2
< 0.1%
2000 2
< 0.1%

recorded
Date

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size246.2 KiB
Minimum2022-06-23 00:00:00
Maximum2022-06-23 00:00:00
2023-05-04T15:13:44.350292image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-05-04T15:13:44.443799image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

shares
Real number (ℝ)

SKEWED  ZEROS 

Distinct182
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.817119634
Minimum0
Maximum1300
Zeros13649
Zeros (%)43.3%
Negative0
Negative (%)0.0%
Memory size246.2 KiB
2023-05-04T15:13:44.568720image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q33
95-th percentile13
Maximum1300
Range1300
Interquartile range (IQR)3

Descriptive statistics

Standard deviation17.79424
Coefficient of variation (CV)4.661693032
Kurtosis1389.94505
Mean3.817119634
Median Absolute Deviation (MAD)1
Skewness28.46944763
Sum120224
Variance316.6349773
MonotonicityNot monotonic
2023-05-04T15:13:44.730575image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 13649
43.3%
1 5322
 
16.9%
2 3345
 
10.6%
3 2237
 
7.1%
4 1462
 
4.6%
5 1016
 
3.2%
6 746
 
2.4%
7 522
 
1.7%
8 409
 
1.3%
9 346
 
1.1%
Other values (172) 2442
 
7.8%
ValueCountFrequency (%)
0 13649
43.3%
1 5322
 
16.9%
2 3345
 
10.6%
3 2237
 
7.1%
4 1462
 
4.6%
ValueCountFrequency (%)
1300 1
< 0.1%
858 1
< 0.1%
681 1
< 0.1%
670 1
< 0.1%
627 1
< 0.1%