Overview

Dataset statistics

Number of variables20
Number of observations499
Missing cells3997
Missing cells (%)40.1%
Total size in memory78.1 KiB
Average record size in memory160.3 B

Variable types

Categorical7
Numeric5
Unsupported8

Warnings

SNS has constant value "SNS" Constant
facebook has constant value "facebook" Constant
가파도정기여객선 has a high cardinality: 66 distinct values High cardinality
가파도 has a high cardinality: 209 distinct values High cardinality
https://facebook.com/watch?v=925876464421481^https://facebook.com/watch?v=377131432914716 has a high cardinality: 182 distinct values High cardinality
Unnamed: 7 has 499 (100.0%) missing values Missing
Unnamed: 8 has 499 (100.0%) missing values Missing
https://facebook.com/watch?v=925876464421481^https://facebook.com/watch?v=377131432914716 has 5 (1.0%) missing values Missing
Unnamed: 10 has 499 (100.0%) missing values Missing
Unnamed: 12 has 499 (100.0%) missing values Missing
Unnamed: 16 has 499 (100.0%) missing values Missing
Unnamed: 17 has 499 (100.0%) missing values Missing
Unnamed: 18 has 499 (100.0%) missing values Missing
Unnamed: 19 has 499 (100.0%) missing values Missing
Unnamed: 7 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 12 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 16 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 17 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 18 is an unsupported type, check if it needs cleaning or further analysis Unsupported
Unnamed: 19 is an unsupported type, check if it needs cleaning or further analysis Unsupported
0 has 346 (69.3%) zeros Zeros

Reproduction

Analysis started2022-06-15 05:30:55.450798
Analysis finished2022-06-15 05:30:55.508852
Duration0.06 seconds
Software versionpandas-profiling v3.0.0
Download configurationconfig.json

Variables

가파도정기여객선
Categorical

HIGH CARDINALITY

Distinct66
Distinct (%)13.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
세화카페
 
25
성산맛집
 
23
함덕맛집
 
22
세화맛집
 
18
김녕맛집
 
17
Other values (61)
394 

Unique

Unique3 ?
Unique (%)0.6%

Sample

1st row가파도정기여객선
2nd row가파도정기여객선
3rd row비체올린
4th row비체올린
5th row비체올린

Common Values

ValueCountFrequency (%)
세화카페25
 
5.0%
성산맛집23
 
4.6%
함덕맛집22
 
4.4%
세화맛집18
 
3.6%
김녕맛집17
 
3.4%
중문술집16
 
3.2%
핫플레이스14
 
2.8%
동문시장13
 
2.6%
사이카레12
 
2.4%
월정맛집11
 
2.2%
Other values (56)328
65.7%

SNS
Categorical

CONSTANT
REJECTED

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
SNS
499 

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowSNS
2nd rowSNS
3rd rowSNS
4th rowSNS
5th rowSNS

Common Values

ValueCountFrequency (%)
SNS499
100.0%

facebook
Categorical

CONSTANT
REJECTED

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
facebook
499 

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowfacebook
2nd rowfacebook
3rd rowfacebook
4th rowfacebook
5th rowfacebook

Common Values

ValueCountFrequency (%)
facebook499
100.0%

20190830
Real number (ℝ≥0)

Distinct65
Distinct (%)13.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20176515.71
Minimum20150325
Maximum20191229
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.0 KiB
2022-06-15T14:30:56.221000image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Quantile statistics

Minimum20150325
5-th percentile20159193.6
Q120170105
median20180721
Q320190306
95-th percentile20190718
Maximum20191229
Range40904
Interquartile range (IQR)20201

Descriptive statistics

Standard deviation12242.76529
Coefficient of variation (CV)0.0006067829289
Kurtosis-0.9551086896
Mean20176515.71
Median Absolute Deviation (MAD)9793
Skewness-0.449686524
Sum1.006808134 × 1010
Variance149885302.1
MonotonicityNot monotonic
2022-06-15T14:30:56.485513image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2016091625
 
5.0%
2016010123
 
4.6%
2016052222
 
4.4%
2015102718
 
3.6%
2017072017
 
3.4%
2017120516
 
3.2%
2018112414
 
2.8%
2016011313
 
2.6%
2018101612
 
2.4%
2018110811
 
2.2%
Other values (55)328
65.7%
ValueCountFrequency (%)
201503257
 
1.4%
2015102718
3.6%
2016010123
4.6%
2016011313
2.6%
2016052222
4.4%
ValueCountFrequency (%)
201912299
1.8%
201911085
1.0%
201910168
1.6%
201908302
 
0.4%
201907188
1.6%

20190902
Real number (ℝ≥0)

Distinct61
Distinct (%)12.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20188422.99
Minimum20180718
Maximum20191230
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.0 KiB
2022-06-15T14:30:56.724179image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Quantile statistics

Minimum20180718
5-th percentile20180922
Q120190221
median20190524
Q320190807
95-th percentile20191220
Maximum20191230
Range10512
Interquartile range (IQR)586

Descriptive statistics

Standard deviation4120.625889
Coefficient of variation (CV)0.0002041083591
Kurtosis-0.4304000868
Mean20188422.99
Median Absolute Deviation (MAD)298
Skewness-1.244760308
Sum1.007402307 × 1010
Variance16979557.71
MonotonicityNot monotonic
2022-06-15T14:30:56.947761image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2019082225
 
5.0%
2019101223
 
4.6%
2019080722
 
4.4%
2019073121
 
4.2%
2019040618
 
3.6%
2019052317
 
3.4%
2019122016
 
3.2%
2019030614
 
2.8%
2019032214
 
2.8%
2019052413
 
2.6%
Other values (51)316
63.3%
ValueCountFrequency (%)
201807182
0.4%
201807252
0.4%
201808082
0.4%
201808142
0.4%
201808194
0.8%
ValueCountFrequency (%)
201912306
 
1.2%
201912299
1.8%
2019122016
3.2%
201911085
 
1.0%
2019110411
2.2%

가파도
Categorical

HIGH CARDINALITY

Distinct209
Distinct (%)41.9%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
제주도
45 
제주시
 
28
여행
 
26
서귀
 
22
서귀포
 
22
Other values (204)
356 

Unique

Unique148 ?
Unique (%)29.7%

Sample

1st row여행
2nd row여행지
3rd row비체올린
4th row캠핑장
5th row캠핑

Common Values

ValueCountFrequency (%)
제주도45
 
9.0%
제주시28
 
5.6%
여행26
 
5.2%
서귀22
 
4.4%
서귀포22
 
4.4%
레이12
 
2.4%
바다11
 
2.2%
한림9
 
1.8%
중문8
 
1.6%
해맞이해안로8
 
1.6%
Other values (199)308
61.7%

27
Real number (ℝ≥0)

Distinct43
Distinct (%)8.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean21.25450902
Minimum2
Maximum1326
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.0 KiB
2022-06-15T14:30:57.564384image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile3
Q13
median6
Q312
95-th percentile42.3
Maximum1326
Range1324
Interquartile range (IQR)9

Descriptive statistics

Standard deviation92.5568823
Coefficient of variation (CV)4.354693972
Kurtosis123.0205869
Mean21.25450902
Median Absolute Deviation (MAD)3
Skewness10.28726738
Sum10606
Variance8566.776461
MonotonicityNot monotonic
2022-06-15T14:30:57.702529image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram with fixed size bins (bins=43)
ValueCountFrequency (%)
6155
31.1%
3151
30.3%
1240
 
8.0%
939
 
7.8%
1831
 
6.2%
1514
 
2.8%
27
 
1.4%
247
 
1.4%
365
 
1.0%
45
 
1.0%
Other values (33)45
 
9.0%
ValueCountFrequency (%)
27
 
1.4%
3151
30.3%
45
 
1.0%
52
 
0.4%
6155
31.1%
ValueCountFrequency (%)
13261
0.2%
11041
0.2%
6781
0.2%
4111
0.2%
4051
0.2%

Unnamed: 7
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing499
Missing (%)100.0%
Memory size4.0 KiB

Unnamed: 8
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing499
Missing (%)100.0%
Memory size4.0 KiB

https://facebook.com/watch?v=925876464421481^https://facebook.com/watch?v=377131432914716
Categorical

HIGH CARDINALITY
MISSING

Distinct182
Distinct (%)36.8%
Missing5
Missing (%)1.0%
Memory size4.0 KiB
https://facebook.com/story.php?story_fbid=1956945224556915&id=1915833195334785
 
11
https://facebook.com/story.php?story_fbid=2219761794965277&id=2140496859558438
 
11
https://facebook.com/story.php?story_fbid=2376420519301309&id=1614182155525153
 
10
https://facebook.com/story.php?story_fbid=2450749795201714&id=1614182155525153^https://facebook.com/story.php?story_fbid=2364975617112466&id=1614182155525153
 
9
https://facebook.com/watch?v=430985370876668^https://facebook.com/story.php?story_fbid=2462574897352537&id=1614182155525153^https://facebook.com/story.php?story_fbid=2453107161632644&id=1614182155525153^https://facebook.com/story.php?story_fbid=2436216523321708&id=1614182155525153^https://facebook.com/story.php?story_fbid=2434515736825120&id=1614182155525153
 
9
Other values (177)
444 

Unique

Unique74 ?
Unique (%)15.0%

Sample

1st rowhttps://facebook.com/watch?v=925876464421481^https://facebook.com/watch?v=377131432914716
2nd rowhttps://facebook.com/watch?v=377131432914716
3rd rowhttps://facebook.com/watch?v=436542190536436^https://facebook.com/story.php?story_fbid=2384232621851526&id=2140496859558438^https://facebook.com/story.php?story_fbid=2348162585458530&id=2140496859558438^https://facebook.com/watch?v=671078649731338
4th rowhttps://facebook.com/watch?v=436542190536436^https://facebook.com/story.php?story_fbid=2384232621851526&id=2140496859558438
5th rowhttps://facebook.com/watch?v=436542190536436^https://facebook.com/story.php?story_fbid=2384232621851526&id=2140496859558438

Common Values

ValueCountFrequency (%)
https://facebook.com/story.php?story_fbid=1956945224556915&id=191583319533478511
 
2.2%
https://facebook.com/story.php?story_fbid=2219761794965277&id=214049685955843811
 
2.2%
https://facebook.com/story.php?story_fbid=2376420519301309&id=161418215552515310
 
2.0%
https://facebook.com/story.php?story_fbid=2450749795201714&id=1614182155525153^https://facebook.com/story.php?story_fbid=2364975617112466&id=16141821555251539
 
1.8%
https://facebook.com/watch?v=430985370876668^https://facebook.com/story.php?story_fbid=2462574897352537&id=1614182155525153^https://facebook.com/story.php?story_fbid=2453107161632644&id=1614182155525153^https://facebook.com/story.php?story_fbid=2436216523321708&id=1614182155525153^https://facebook.com/story.php?story_fbid=2434515736825120&id=16141821555251539
 
1.8%
https://facebook.com/story.php?story_fbid=2584959478447411&id=16141821555251539
 
1.8%
https://facebook.com/watch?v=3038917068677969
 
1.8%
https://facebook.com/story.php?story_fbid=2233912870218742&id=16141821555251538
 
1.6%
https://facebook.com/story.php?story_fbid=2395618860714808&id=16141821555251538
 
1.6%
https://facebook.com/story.php?story_fbid=2439395736337120&id=16141821555251538
 
1.6%
Other values (172)402
80.6%

Unnamed: 10
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing499
Missing (%)100.0%
Memory size4.0 KiB

62
Real number (ℝ≥0)

Distinct57
Distinct (%)11.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1987.082164
Minimum4
Maximum39845
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.0 KiB
2022-06-15T14:30:58.183625image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Quantile statistics

Minimum4
5-th percentile12.8
Q139
median90
Q3376
95-th percentile1150
Maximum39845
Range39841
Interquartile range (IQR)337

Descriptive statistics

Standard deviation8143.694348
Coefficient of variation (CV)4.098317873
Kurtosis17.86593891
Mean1987.082164
Median Absolute Deviation (MAD)75
Skewness4.445753295
Sum991554
Variance66319757.64
MonotonicityNot monotonic
2022-06-15T14:30:58.452507image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
33825
 
5.0%
77523
 
4.6%
3984522
 
4.4%
40718
 
3.6%
25417
 
3.4%
20816
 
3.2%
1815
 
3.0%
4114
 
2.8%
2114
 
2.8%
8113
 
2.6%
Other values (47)322
64.5%
ValueCountFrequency (%)
45
1.0%
1010
2.0%
1110
2.0%
139
1.8%
141
 
0.2%
ValueCountFrequency (%)
3984522
4.4%
11504
 
0.8%
110913
2.6%
10269
1.8%
83511
2.2%

Unnamed: 12
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing499
Missing (%)100.0%
Memory size4.0 KiB

0
Real number (ℝ≥0)

ZEROS

Distinct15
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20.04208417
Minimum0
Maximum185
Zeros346
Zeros (%)69.3%
Negative0
Negative (%)0.0%
Memory size4.0 KiB
2022-06-15T14:30:58.679310image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q39
95-th percentile134
Maximum185
Range185
Interquartile range (IQR)9

Descriptive statistics

Standard deviation47.2305317
Coefficient of variation (CV)2.356567875
Kurtosis5.36858581
Mean20.04208417
Median Absolute Deviation (MAD)0
Skewness2.565959422
Sum10001
Variance2230.723125
MonotonicityNot monotonic
2022-06-15T14:30:58.897515image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
0346
69.3%
1827
 
5.4%
13423
 
4.6%
18522
 
4.4%
6618
 
3.6%
513
 
2.6%
1211
 
2.2%
610
 
2.0%
910
 
2.0%
216
 
1.2%
Other values (5)13
 
2.6%
ValueCountFrequency (%)
0346
69.3%
41
 
0.2%
513
 
2.6%
610
 
2.0%
910
 
2.0%
ValueCountFrequency (%)
18522
4.4%
13423
4.6%
1222
 
0.4%
6618
3.6%
632
 
0.4%

관광지
Categorical

Distinct3
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
관광지
346 
음식점
127 
숙박지
 
26

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row관광지
2nd row관광지
3rd row관광지
4th row관광지
5th row관광지

Common Values

ValueCountFrequency (%)
관광지346
69.3%
음식점127
 
25.5%
숙박지26
 
5.2%

관광지.1
Categorical

Distinct6
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
키워드
194 
관광지
151 
주소지
106 
음식점
40 
숙박지
 
7

Unique

Unique1 ?
Unique (%)0.2%

Sample

1st row키워드
2nd row키워드
3rd row관광지
4th row키워드
5th row키워드

Common Values

ValueCountFrequency (%)
키워드194
38.9%
관광지151
30.3%
주소지106
21.2%
음식점40
 
8.0%
숙박지7
 
1.4%
행사1
 
0.2%

Unnamed: 16
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing499
Missing (%)100.0%
Memory size4.0 KiB

Unnamed: 17
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing499
Missing (%)100.0%
Memory size4.0 KiB

Unnamed: 18
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing499
Missing (%)100.0%
Memory size4.0 KiB

Unnamed: 19
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing499
Missing (%)100.0%
Memory size4.0 KiB