Overview

Dataset statistics

Number of variables20
Number of observations499
Missing cells3998
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 constant value "키워드" Constant
해피크리스마스 has a high cardinality: 139 distinct values High cardinality
제주도 has a high cardinality: 147 distinct values High cardinality
https://facebook.com/story.php?story_fbid=2515813905360063&id=2140496859558438 has a high cardinality: 231 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/story.php?story_fbid=2515813905360063&id=2140496859558438 has 6 (1.2%) 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 452 (90.6%) zeros Zeros

Reproduction

Analysis started2022-06-15 05:41:42.546464
Analysis finished2022-06-15 05:41:42.611640
Duration0.07 seconds
Software versionpandas-profiling v3.0.0
Download configurationconfig.json

Variables

해피크리스마스
Categorical

HIGH CARDINALITY

Distinct139
Distinct (%)27.9%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
제주도관광지
 
40
2박3일
 
26
제주도잠수함
 
10
빛의벙커
 
9
파스타
 
8
Other values (134)
406 

Unique

Unique22 ?
Unique (%)4.4%

Sample

1st row제주크리스마스
2nd row크리스마스선물
3rd row크리스마스선물
4th row겨울간식
5th row제주도귤체험

Common Values

ValueCountFrequency (%)
제주도관광지40
 
8.0%
2박3일26
 
5.2%
제주도잠수함10
 
2.0%
빛의벙커9
 
1.8%
파스타8
 
1.6%
제주핑크뮬리8
 
1.6%
태풍8
 
1.6%
랜딩커피7
 
1.4%
투명카약7
 
1.4%
꽃사슴먹이주기7
 
1.4%
Other values (129)369
73.9%

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%

20191224
Real number (ℝ≥0)

Distinct117
Distinct (%)23.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20181826.31
Minimum20141216
Maximum20191220
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.0 KiB
2022-06-15T14:41:43.171552image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Quantile statistics

Minimum20141216
5-th percentile20150327
Q120171116
median20190305
Q320190805
95-th percentile20191105.3
Maximum20191220
Range50004
Interquartile range (IQR)19689

Descriptive statistics

Standard deviation13491.91909
Coefficient of variation (CV)0.0006685182444
Kurtosis0.7845780351
Mean20181826.31
Median Absolute Deviation (MAD)613
Skewness-1.417418534
Sum1.007073133 × 1010
Variance182031880.9
MonotonicityNot monotonic
2022-06-15T14:41:43.380508image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2015032740
 
8.0%
2017081726
 
5.2%
2019032812
 
2.4%
2019031410
 
2.0%
2018103010
 
2.0%
201909029
 
1.8%
201812129
 
1.8%
201903189
 
1.8%
201909069
 
1.8%
201910178
 
1.6%
Other values (107)357
71.5%
ValueCountFrequency (%)
201412164
 
0.8%
201503206
 
1.2%
2015032740
8.0%
201608128
 
1.6%
201610058
 
1.6%
ValueCountFrequency (%)
201912201
 
0.2%
201912192
0.4%
201912122
0.4%
201912112
0.4%
201912064
0.8%

20191224.1
Real number (ℝ≥0)

Distinct115
Distinct (%)23.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20189932.78
Minimum20180807
Maximum20191224
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.0 KiB
2022-06-15T14:41:43.520111image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Quantile statistics

Minimum20180807
5-th percentile20181204
Q120190321
median20190724
Q320191010
95-th percentile20191204.2
Maximum20191224
Range10417
Interquartile range (IQR)689

Descriptive statistics

Standard deviation2644.965657
Coefficient of variation (CV)0.0001310041834
Kurtosis7.34974023
Mean20189932.78
Median Absolute Deviation (MAD)322
Skewness-3.019033601
Sum1.007477646 × 1010
Variance6995843.329
MonotonicityNot monotonic
2022-06-15T14:41:43.664091image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2019082240
 
8.0%
2019111626
 
5.2%
2019032812
 
2.4%
2019080510
 
2.0%
2019032610
 
2.0%
2019040810
 
2.0%
201905109
 
1.8%
201903189
 
1.8%
201909029
 
1.8%
201912249
 
1.8%
Other values (105)355
71.1%
ValueCountFrequency (%)
201808071
 
0.2%
201808162
 
0.4%
201808232
 
0.4%
201808292
 
0.4%
201808316
1.2%
ValueCountFrequency (%)
201912249
1.8%
201912205
1.0%
201912192
 
0.4%
201912181
 
0.2%
201912132
 
0.4%

제주도
Categorical

HIGH CARDINALITY

Distinct147
Distinct (%)29.5%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
제주도
99 
여행
98 
여행지
 
21
바다
 
19
제주시
 
13
Other values (142)
249 

Unique

Unique89 ?
Unique (%)17.8%

Sample

1st row여행
2nd row가족여행
3rd row여행
4th row제주도
5th row제주도

Common Values

ValueCountFrequency (%)
제주도99
19.8%
여행98
19.6%
여행지21
 
4.2%
바다19
 
3.8%
제주시13
 
2.6%
가족여행8
 
1.6%
자동차박물관6
 
1.2%
관광6
 
1.2%
세계자동차박물관6
 
1.2%
레이6
 
1.2%
Other values (137)217
43.5%

6
Real number (ℝ≥0)

Distinct26
Distinct (%)5.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8.076152305
Minimum2
Maximum321
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.0 KiB
2022-06-15T14:41:43.937803image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile3
Q13
median4
Q39
95-th percentile18
Maximum321
Range319
Interquartile range (IQR)6

Descriptive statistics

Standard deviation18.72905021
Coefficient of variation (CV)2.319056093
Kurtosis173.1552084
Mean8.076152305
Median Absolute Deviation (MAD)2
Skewness11.83543039
Sum4030
Variance350.7773217
MonotonicityNot monotonic
2022-06-15T14:41:44.051368image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%)
3224
44.9%
6108
21.6%
949
 
9.8%
1226
 
5.2%
222
 
4.4%
1817
 
3.4%
1515
 
3.0%
511
 
2.2%
245
 
1.0%
44
 
0.8%
Other values (16)18
 
3.6%
ValueCountFrequency (%)
222
 
4.4%
3224
44.9%
44
 
0.8%
511
 
2.2%
6108
21.6%
ValueCountFrequency (%)
3211
0.2%
1671
0.2%
1401
0.2%
1101
0.2%
721
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/story.php?story_fbid=2515813905360063&id=2140496859558438
Categorical

HIGH CARDINALITY
MISSING

Distinct231
Distinct (%)46.9%
Missing6
Missing (%)1.2%
Memory size4.0 KiB
https://facebook.com/story.php?story_fbid=787858694719999&id=173124479526760
 
22
https://facebook.com/watch?v=1778225182454182
 
7
https://facebook.com/story.php?story_fbid=2447929338815187&id=2140496859558438
 
7
https://facebook.com/watch?v=2261571797459412
 
7
https://facebook.com/story.php?story_fbid=312049069486366&id=134632230561385
 
6
Other values (226)
444 

Unique

Unique104 ?
Unique (%)21.1%

Sample

1st rowhttps://facebook.com/watch?v=503752383593564
2nd rowhttps://facebook.com/story.php?story_fbid=2510864079188379&id=2140496859558438
3rd rowhttps://facebook.com/story.php?story_fbid=2510864079188379&id=2140496859558438
4th rowhttps://facebook.com/story.php?story_fbid=2509555265985927&id=2140496859558438
5th rowhttps://facebook.com/watch?v=592272954856950^https://facebook.com/story.php?story_fbid=2502548370019950&id=2140496859558438

Common Values

ValueCountFrequency (%)
https://facebook.com/story.php?story_fbid=787858694719999&id=17312447952676022
 
4.4%
https://facebook.com/watch?v=17782251824541827
 
1.4%
https://facebook.com/story.php?story_fbid=2447929338815187&id=21404968595584387
 
1.4%
https://facebook.com/watch?v=22615717974594127
 
1.4%
https://facebook.com/story.php?story_fbid=312049069486366&id=1346322305613856
 
1.2%
https://facebook.com/story.php?story_fbid=1317744811731382&id=1731244795267606
 
1.2%
https://facebook.com/story.php?story_fbid=2393980437543411&id=21404968595584386
 
1.2%
https://facebook.com/story.php?story_fbid=2303882209886568&id=21404968595584385
 
1.0%
https://facebook.com/watch?v=3060784400807025
 
1.0%
https://facebook.com/story.php?story_fbid=2256167284658061&id=21404968595584385
 
1.0%
Other values (221)417
83.6%
(Missing)6
 
1.2%

Unnamed: 10
Unsupported

MISSING
REJECTED
UNSUPPORTED

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

18
Real number (ℝ≥0)

Distinct80
Distinct (%)16.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean136.3346693
Minimum7
Maximum1213
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.0 KiB
2022-06-15T14:41:44.413090image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Quantile statistics

Minimum7
5-th percentile11.9
Q123
median53
Q3164
95-th percentile549.3
Maximum1213
Range1206
Interquartile range (IQR)141

Descriptive statistics

Standard deviation195.7961356
Coefficient of variation (CV)1.4361434
Kurtosis10.27566786
Mean136.3346693
Median Absolute Deviation (MAD)39
Skewness2.923848503
Sum68031
Variance38336.12673
MonotonicityNot monotonic
2022-06-15T14:41:44.596918image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
15740
 
8.0%
19026
 
5.2%
1624
 
4.8%
2721
 
4.2%
4020
 
4.0%
3914
 
2.8%
2014
 
2.8%
5312
 
2.4%
34111
 
2.2%
2411
 
2.2%
Other values (70)306
61.3%
ValueCountFrequency (%)
75
1.0%
83
 
0.6%
92
 
0.4%
1010
2.0%
115
1.0%
ValueCountFrequency (%)
12135
1.0%
8873
 
0.6%
8132
 
0.4%
6938
1.6%
6337
1.4%

Unnamed: 12
Unsupported

MISSING
REJECTED
UNSUPPORTED

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

0
Real number (ℝ≥0)

ZEROS

Distinct7
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.7755511022
Minimum0
Maximum23
Zeros452
Zeros (%)90.6%
Negative0
Negative (%)0.0%
Memory size4.0 KiB
2022-06-15T14:41:44.698563image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile4
Maximum23
Range23
Interquartile range (IQR)0

Descriptive statistics

Standard deviation3.336202096
Coefficient of variation (CV)4.301717948
Kurtosis31.24180691
Mean0.7755511022
Median Absolute Deviation (MAD)0
Skewness5.455747808
Sum387
Variance11.13024442
MonotonicityNot monotonic
2022-06-15T14:41:44.992109image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
0452
90.6%
211
 
2.2%
410
 
2.0%
128
 
1.6%
238
 
1.6%
37
 
1.4%
83
 
0.6%
ValueCountFrequency (%)
0452
90.6%
211
 
2.2%
37
 
1.4%
410
 
2.0%
83
 
0.6%
ValueCountFrequency (%)
238
1.6%
128
1.6%
83
 
0.6%
410
2.0%
37
1.4%

키워드
Categorical

CONSTANT
REJECTED

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
키워드
499 

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
키워드499
100.0%

키워드.1
Categorical

Distinct6
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
키워드
339 
관광지
119 
음식점
 
14
주소지
 
13
행사
 
7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
키워드339
67.9%
관광지119
 
23.8%
음식점14
 
2.8%
주소지13
 
2.6%
행사7
 
1.4%
숙박지7
 
1.4%

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