gimi9 Pandas Profiling

Dataset statistics

Number of variables	15
Number of observations	1383
Missing cells	1678
Missing cells (%)	8.1%
Duplicate rows	16
Duplicate rows (%)	1.2%
Total size in memory	177.1 KiB
Average record size in memory	131.1 B

Variable types

Text	3
Categorical	2
Numeric	10

Dataset

Description	전라남도 여수시 관광홈페이지 관광지 시설의 객실정보 데이터로서 전라남도 여수시_여수시문화관광 객실의 종류, 전라남도 여수시 여수시문화관광_관광정보_객실정보 선호도, 전라남도 여수시의 관광 객실정보의 기준인원 등을 제공합니다.
Author	전라남도 여수시
URL	https://www.data.go.kr/data/15040852/fileData.do

Alerts

Dataset has 16 (1.2%) duplicate rows	Duplicates
`기준인원` is highly overall correlated with `최대인원` and 1 other fields	High correlation
`최대인원` is highly overall correlated with `기준인원` and 1 other fields	High correlation
`추가비용` is highly overall correlated with `객실종류영어`	High correlation
`규모` is highly overall correlated with `객실종류영어`	High correlation
`성수기주중요금` is highly overall correlated with `성수기주말요금` and 5 other fields	High correlation
`성수기주말요금` is highly overall correlated with `성수기주중요금` and 5 other fields	High correlation
`극성수기주중요금` is highly overall correlated with `성수기주중요금` and 5 other fields	High correlation
`극성수기주말요금` is highly overall correlated with `성수기주중요금` and 5 other fields	High correlation
`비수기주중요금` is highly overall correlated with `성수기주중요금` and 5 other fields	High correlation
`비수기주말요금` is highly overall correlated with `성수기주중요금` and 5 other fields	High correlation
`객실종류영어` is highly overall correlated with `기준인원` and 9 other fields	High correlation
`객실종류영어` is highly imbalanced (89.6%)	Imbalance
`기타객실정보` has 446 (32.2%) missing values	Missing
`추가객실정보` has 1232 (89.1%) missing values	Missing
`규모` is highly skewed (γ1 = 37.18844707)	Skewed
`기준인원` has 359 (26.0%) zeros	Zeros
`최대인원` has 535 (38.7%) zeros	Zeros
`추가비용` has 697 (50.4%) zeros	Zeros
`규모` has 965 (69.8%) zeros	Zeros
`성수기주중요금` has 268 (19.4%) zeros	Zeros
`성수기주말요금` has 272 (19.7%) zeros	Zeros
`극성수기주중요금` has 464 (33.6%) zeros	Zeros
`극성수기주말요금` has 470 (34.0%) zeros	Zeros
`비수기주중요금` has 263 (19.0%) zeros	Zeros
`비수기주말요금` has 270 (19.5%) zeros	Zeros

Reproduction

Analysis started	2023-12-12 14:40:16.190472
Analysis finished	2023-12-12 14:40:29.020753
Duration	12.83 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

객실종류
Text

Distinct	786
Distinct (%)	56.8%
Missing	0
Missing (%)	0.0%
Memory size	10.9 KiB

Length

Max length	50
Median length	39
Mean length	5.1489516
Min length	1

Characters and Unicode

Total characters	7121
Distinct characters	427
Distinct categories	11 ?
Distinct scripts	4 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	662 ?
Unique (%)	47.9%

Sample

1st row	양실
2nd row	온돌
3rd row	일반
4th row	특실
5th row	트윈룸

Value	Count	Frequency (%)
일반실	111	6.0%
특실	83	4.5%
온돌	74	4.0%
디럭스	41	2.2%
마을회관	39	2.1%
트윈	36	2.0%
스위트	29	1.6%
일반	29	1.6%
스탠다드	29	1.6%
한실	27	1.5%
Other values (764)	1345	73.0%

Most occurring characters

Value	Count	Frequency (%)
	493	6.9%
실	465	6.5%
스	200	2.8%
일	199	2.8%
반	195	2.7%
트	193	2.7%
0	189	2.7%
2	189	2.7%
)	168	2.4%
(	167	2.3%
Other values (417)	4663	65.5%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	4869	68.4%
Decimal Number	781	11.0%
Space Separator	493	6.9%
Lowercase Letter	243	3.4%
Uppercase Letter	238	3.3%
Close Punctuation	168	2.4%
Open Punctuation	168	2.4%
Other Punctuation	116	1.6%
Math Symbol	17	0.2%
Dash Punctuation	16	0.2%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
실	465	9.6%
스	200	4.1%
일	199	4.1%
반	195	4.0%
트	193	4.0%
룸	124	2.5%
온	122	2.5%
돌	121	2.5%
특	117	2.4%
호	110	2.3%
Other values (353)	3023	62.1%

Lowercase Letter

Value	Count	Frequency (%)
e	32	13.2%
i	27	11.1%
o	26	10.7%
l	22	9.1%
u	15	6.2%
n	14	5.8%
m	14	5.8%
a	13	5.3%
p	12	4.9%
t	9	3.7%
Other values (11)	59	24.3%

Uppercase Letter

Value	Count	Frequency (%)
B	35	14.7%
P	34	14.3%
A	29	12.2%
I	27	11.3%
V	27	11.3%
D	16	6.7%
T	13	5.5%
F	13	5.5%
C	12	5.0%
R	9	3.8%
Other values (7)	23	9.7%

Decimal Number

Value	Count	Frequency (%)
0	189	24.2%
2	189	24.2%
1	161	20.6%
3	85	10.9%
4	52	6.7%
5	47	6.0%
6	39	5.0%
8	9	1.2%
7	7	0.9%
9	3	0.4%

Other Punctuation

Value	Count	Frequency (%)
,	98	84.5%
?	9	7.8%
/	3	2.6%
.	3	2.6%
:	2	1.7%
*	1	0.9%

Math Symbol

Value	Count	Frequency (%)
~	14	82.4%
+	1	5.9%
>	1	5.9%
<	1	5.9%

Open Punctuation

Value	Count	Frequency (%)
(	167	99.4%
{	1	0.6%

Space Separator

Value	Count	Frequency (%)
	493	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	168	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	16	100.0%

Control

Value	Count	Frequency (%)
	12	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	4861	68.3%
Common	1771	24.9%
Latin	481	6.8%
Han	8	0.1%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
실	465	9.6%
스	200	4.1%
일	199	4.1%
반	195	4.0%
트	193	4.0%
룸	124	2.6%
온	122	2.5%
돌	121	2.5%
특	117	2.4%
호	110	2.3%
Other values (347)	3015	62.0%

Latin

Value	Count	Frequency (%)
B	35	7.3%
P	34	7.1%
e	32	6.7%
A	29	6.0%
I	27	5.6%
i	27	5.6%
V	27	5.6%
o	26	5.4%
l	22	4.6%
D	16	3.3%
Other values (28)	206	42.8%

Common

Value	Count	Frequency (%)
	493	27.8%
0	189	10.7%
2	189	10.7%
)	168	9.5%
(	167	9.4%
1	161	9.1%
,	98	5.5%
3	85	4.8%
4	52	2.9%
5	47	2.7%
Other values (16)	122	6.9%

Han

Value	Count	Frequency (%)
大	2	25.0%
式	2	25.0%
室	1	12.5%
般	1	12.5%
一	1	12.5%
洋	1	12.5%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	4845	68.0%
ASCII	2252	31.6%
Compat Jamo	16	0.2%
CJK	8	0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	493	21.9%
0	189	8.4%
2	189	8.4%
)	168	7.5%
(	167	7.4%
1	161	7.1%
,	98	4.4%
3	85	3.8%
4	52	2.3%
5	47	2.1%
Other values (54)	603	26.8%

Hangul

Value	Count	Frequency (%)
실	465	9.6%
스	200	4.1%
일	199	4.1%
반	195	4.0%
트	193	4.0%
룸	124	2.6%
온	122	2.5%
돌	121	2.5%
특	117	2.4%
호	110	2.3%
Other values (340)	2999	61.9%

Compat Jamo

Value	Count	Frequency (%)
ㅇ	5	31.2%
ㄴ	4	25.0%
ㅁ	2	12.5%
ㅅ	2	12.5%
ㄹ	1	6.2%
ㄻ	1	6.2%
ㄷ	1	6.2%

CJK

Value	Count	Frequency (%)
大	2	25.0%
式	2	25.0%
室	1	12.5%
般	1	12.5%
一	1	12.5%
洋	1	12.5%

객실종류영어
Categorical

HIGH CORRELATION IMBALANCE

Distinct	22
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Memory size	10.9 KiB

<NA>	1314
Western Style Room	12
Korean Style Room	12
Special Room	12
Standard Room	9
Other values (17)	24

Length

Max length	25
Median length	4
Mean length	4.505423
Min length	4

Unique

Unique	13 ?
Unique (%)	0.9%

Sample

1st row	<NA>
2nd row	Korean Style Room
3rd row	Standard Room
4th row	Special Room
5th row	Special Room

Common Values

Value	Count	Frequency (%)
<NA>	1314	95.0%
Western Style Room	12	0.9%
Korean Style Room	12	0.9%
Special Room	12	0.9%
Standard Room	9	0.7%
VIP Room	4	0.3%
Deluxe Room	3	0.2%
Twin Room	2	0.1%
Suite Room	2	0.1%
Special Room2	1	0.1%
Other values (12)	12	0.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
na	1314	88.8%
room	64	4.3%
style	27	1.8%
korean	15	1.0%
special	15	1.0%
western	12	0.8%
standard	10	0.7%
suite	4	0.3%
vip	4	0.3%
deluxe	3	0.2%
Other values (10)	12	0.8%

선호도
Categorical

Distinct	5
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	10.9 KiB

<NA>	694
1	429
2	144
4	69
3	47

Length

Max length	4
Median length	4
Mean length	2.505423
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
<NA>	694	50.2%
1	429	31.0%
2	144	10.4%
4	69	5.0%
3	47	3.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
na	694	50.2%
1	429	31.0%
2	144	10.4%
4	69	5.0%
3	47	3.4%

기타객실정보
Text

MISSING

Distinct	340
Distinct (%)	36.3%
Missing	446
Missing (%)	32.2%
Memory size	10.9 KiB

Length

Max length	44
Median length	35
Mean length	26.640342
Min length	1

Characters and Unicode

Total characters	24962
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	201 ?
Unique (%)	21.5%

Sample

1st row	01,02,03,04,05,07,08,09,10,11,14,15
2nd row	01,03,04,07,09,10,14,15
3rd row	01,03,04,07,10,14,15
4th row	01,02,03,04,05,06,07,08,09,10,11,14,15
5th row	01,02,03,04,05,07,09,10,11,14,15,16

Value	Count	Frequency (%)
01,02,03,04,05,07,08,09,10,11,14,15	48	5.1%
01,02,03,04,05,06,07,08,09,10,11,14,15	35	3.7%
02,04,12	24	2.6%
01,02,03,04,07,08,09,10,12,13,15	22	2.3%
02,03,04,07,08,10,11,12,13	16	1.7%
02,03,04,07,09,10,15	16	1.7%
01,02,03,04,07,08,10,11,12,13	16	1.7%
01,02,03,04,05,06,07,08,09,10,11,15	14	1.5%
02,12,13,14	13	1.4%
01,02,03,04,07,10,12,13	13	1.4%
Other values (330)	720	76.8%

Most occurring characters

Value	Count	Frequency (%)
,	7700	30.8%
0	6194	24.8%
1	4312	17.3%
4	1392	5.6%
3	1265	5.1%
2	1233	4.9%
7	757	3.0%
5	732	2.9%
9	591	2.4%
8	526	2.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	17262	69.2%
Other Punctuation	7700	30.8%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	6194	35.9%
1	4312	25.0%
4	1392	8.1%
3	1265	7.3%
2	1233	7.1%
7	757	4.4%
5	732	4.2%
9	591	3.4%
8	526	3.0%
6	260	1.5%

Other Punctuation

Value	Count	Frequency (%)
,	7700	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	24962	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
,	7700	30.8%
0	6194	24.8%
1	4312	17.3%
4	1392	5.6%
3	1265	5.1%
2	1233	4.9%
7	757	3.0%
5	732	2.9%
9	591	2.4%
8	526	2.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24962	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
,	7700	30.8%
0	6194	24.8%
1	4312	17.3%
4	1392	5.6%
3	1265	5.1%
2	1233	4.9%
7	757	3.0%
5	732	2.9%
9	591	2.4%
8	526	2.1%

기준인원
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	15
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.670282

Minimum	0
Maximum	24
Zeros	359
Zeros (%)	26.0%
Negative	0
Negative (%)	0.0%
Memory size	12.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	4
95-th percentile	8
Maximum	24
Range	24
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.9505878
Coefficient of variation (CV)	1.1049724
Kurtosis	11.187243
Mean	2.670282
Median Absolute Deviation (MAD)	2
Skewness	2.6688049
Sum	3693
Variance	8.7059686
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
2	575	41.6%
0	359	26.0%
4	210	15.2%
8	64	4.6%
6	47	3.4%
3	43	3.1%
5	27	2.0%
10	17	1.2%
12	11	0.8%
1	11	0.8%
Other values (5)	19	1.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	359	26.0%
1	11	0.8%
2	575	41.6%
3	43	3.1%
4	210	15.2%
5	27	2.0%
6	47	3.4%
7	1	0.1%
8	64	4.6%
10	17	1.2%

Value	Count	Frequency (%)
24	2	0.1%
20	7	0.5%
16	2	0.1%
15	7	0.5%
12	11	0.8%
10	17	1.2%
8	64	4.6%
7	1	0.1%
6	47	3.4%
5	27	2.0%

최대인원
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	22
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.6464208

Minimum	0
Maximum	40
Zeros	535
Zeros (%)	38.7%
Negative	0
Negative (%)	0.0%
Memory size	12.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3
Q3	5
95-th percentile	12
Maximum	40
Range	40
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	4.4841012
Coefficient of variation (CV)	1.2297267
Kurtosis	9.5969902
Mean	3.6464208
Median Absolute Deviation (MAD)	3
Skewness	2.381847
Sum	5043
Variance	20.107163
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
0	535	38.7%
4	254	18.4%
2	110	8.0%
6	110	8.0%
8	90	6.5%
3	80	5.8%
5	59	4.3%
10	39	2.8%
12	25	1.8%
7	23	1.7%
Other values (12)	58	4.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	535	38.7%
1	1	0.1%
2	110	8.0%
3	80	5.8%
4	254	18.4%
5	59	4.3%
6	110	8.0%
7	23	1.7%
8	90	6.5%
9	3	0.2%

Value	Count	Frequency (%)
40	1	0.1%
30	6	0.4%
25	2	0.1%
24	1	0.1%
20	14	1.0%
16	2	0.1%
15	22	1.6%
14	3	0.2%
13	1	0.1%
12	25	1.8%

추가비용
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	10
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5592.1909

Minimum	0
Maximum	350000
Zeros	697
Zeros (%)	50.4%
Negative	0
Negative (%)	0.0%
Memory size	12.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	10000
95-th percentile	10000
Maximum	350000
Range	350000
Interquartile range (IQR)	10000

Descriptive statistics

Standard deviation	12149.932
Coefficient of variation (CV)	2.1726604
Kurtosis	479.54601
Mean	5592.1909
Median Absolute Deviation (MAD)	0
Skewness	18.221839
Sum	7734000
Variance	1.4762084 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	697	50.4%
10000	587	42.4%
5000	53	3.8%
20000	19	1.4%
15000	12	0.9%
100000	5	0.4%
25000	4	0.3%
22000	4	0.3%
1000	1	0.1%
350000	1	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	697	50.4%
1000	1	0.1%
5000	53	3.8%
10000	587	42.4%
15000	12	0.9%
20000	19	1.4%
22000	4	0.3%
25000	4	0.3%
100000	5	0.4%
350000	1	0.1%

Value	Count	Frequency (%)
350000	1	0.1%
100000	5	0.4%
25000	4	0.3%
22000	4	0.3%
20000	19	1.4%
15000	12	0.9%
10000	587	42.4%
5000	53	3.8%
1000	1	0.1%
0	697	50.4%

규모
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	79
Distinct (%)	5.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	316.79899

Minimum	0
Maximum	420000
Zeros	965
Zeros (%)	69.8%
Negative	0
Negative (%)	0.0%
Memory size	12.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	20
95-th percentile	62.8
Maximum	420000
Range	420000
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	11293.424
Coefficient of variation (CV)	35.648549
Kurtosis	1382.9871
Mean	316.79899
Median Absolute Deviation (MAD)	0
Skewness	37.188447
Sum	438133
Variance	1.2754143 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	965	69.8%
33	36	2.6%
53	31	2.2%
20	19	1.4%
43	17	1.2%
26	17	1.2%
30	16	1.2%
52	16	1.2%
16	13	0.9%
59	12	0.9%
Other values (69)	241	17.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	965	69.8%
3	3	0.2%
8	3	0.2%
10	5	0.4%
11	4	0.3%
12	4	0.3%
13	7	0.5%
14	1	0.1%
15	3	0.2%
16	13	0.9%

Value	Count	Frequency (%)
420000	1	0.1%
173	2	0.1%
148	1	0.1%
132	1	0.1%
129	1	0.1%
122	1	0.1%
120	1	0.1%
116	3	0.2%
115	1	0.1%
109	1	0.1%

성수기주중요금
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	114
Distinct (%)	8.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	110906

Minimum	0
Maximum	1100000
Zeros	268
Zeros (%)	19.4%
Negative	0
Negative (%)	0.0%
Memory size	12.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	40000
median	70000
Q3	150000
95-th percentile	350000
Maximum	1100000
Range	1100000
Interquartile range (IQR)	110000

Descriptive statistics

Standard deviation	125029.07
Coefficient of variation (CV)	1.1273427
Kurtosis	9.8045897
Mean	110906
Median Absolute Deviation (MAD)	50000
Skewness	2.4977389
Sum	1.53383 × 10⁸
Variance	1.5632269 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	268	19.4%
50000	117	8.5%
60000	90	6.5%
80000	75	5.4%
70000	73	5.3%
40000	67	4.8%
100000	66	4.8%
150000	54	3.9%
120000	52	3.8%
200000	41	3.0%
Other values (104)	480	34.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	268	19.4%
2000	1	0.1%
10000	1	0.1%
15000	1	0.1%
17000	1	0.1%
20000	6	0.4%
22000	7	0.5%
23000	1	0.1%
25000	10	0.7%
30000	17	1.2%

Value	Count	Frequency (%)
1100000	1	0.1%
990000	1	0.1%
900000	1	0.1%
861000	1	0.1%
830000	1	0.1%
790000	1	0.1%
730000	1	0.1%
710000	1	0.1%
682000	1	0.1%
630000	1	0.1%

성수기주말요금
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	107
Distinct (%)	7.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	118947.94

Minimum	0
Maximum	1100000
Zeros	272
Zeros (%)	19.7%
Negative	0
Negative (%)	0.0%
Memory size	12.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	40000
median	80000
Q3	150000
95-th percentile	369000
Maximum	1100000
Range	1100000
Interquartile range (IQR)	110000

Descriptive statistics

Standard deviation	128010.59
Coefficient of variation (CV)	1.07619
Kurtosis	7.8172702
Mean	118947.94
Median Absolute Deviation (MAD)	60000
Skewness	2.2152202
Sum	1.64505 × 10⁸
Variance	1.6386711 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	272	19.7%
70000	90	6.5%
50000	80	5.8%
60000	79	5.7%
80000	76	5.5%
100000	75	5.4%
150000	63	4.6%
120000	60	4.3%
250000	49	3.5%
90000	39	2.8%
Other values (97)	500	36.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	272	19.7%
10000	3	0.2%
20000	5	0.4%
22000	6	0.4%
23000	1	0.1%
25000	10	0.7%
28000	1	0.1%
30000	16	1.2%
35000	8	0.6%
40000	35	2.5%

Value	Count	Frequency (%)
1100000	1	0.1%
990000	1	0.1%
861000	1	0.1%
830000	1	0.1%
800000	1	0.1%
730000	1	0.1%
710000	1	0.1%
700000	2	0.1%
682000	1	0.1%
600000	3	0.2%

극성수기주중요금
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	92
Distinct (%)	6.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	92704.989

Minimum	0
Maximum	1000000
Zeros	464
Zeros (%)	33.6%
Negative	0
Negative (%)	0.0%
Memory size	12.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	60000
Q3	120000
95-th percentile	319900
Maximum	1000000
Range	1000000
Interquartile range (IQR)	120000

Descriptive statistics

Standard deviation	118404.17
Coefficient of variation (CV)	1.2772146
Kurtosis	11.160343
Mean	92704.989
Median Absolute Deviation (MAD)	60000
Skewness	2.618812
Sum	1.28211 × 10⁸
Variance	1.4019547 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	464	33.6%
50000	75	5.4%
70000	73	5.3%
100000	72	5.2%
80000	70	5.1%
60000	67	4.8%
150000	61	4.4%
120000	54	3.9%
40000	38	2.7%
90000	35	2.5%
Other values (82)	374	27.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	464	33.6%
20000	4	0.3%
22000	7	0.5%
25000	9	0.7%
30000	10	0.7%
35000	8	0.6%
40000	38	2.7%
45000	9	0.7%
50000	75	5.4%
55000	5	0.4%

Value	Count	Frequency (%)
1000000	1	0.1%
990000	1	0.1%
903000	1	0.1%
900000	1	0.1%
800000	1	0.1%
790000	1	0.1%
720000	1	0.1%
600000	1	0.1%
599000	1	0.1%
596000	1	0.1%

극성수기주말요금
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	92
Distinct (%)	6.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	95274.62

Minimum	0
Maximum	1000000
Zeros	470
Zeros (%)	34.0%
Negative	0
Negative (%)	0.0%
Memory size	12.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	70000
Q3	130000
95-th percentile	330000
Maximum	1000000
Range	1000000
Interquartile range (IQR)	130000

Descriptive statistics

Standard deviation	120864
Coefficient of variation (CV)	1.2685855
Kurtosis	10.56387
Mean	95274.62
Median Absolute Deviation (MAD)	70000
Skewness	2.5379942
Sum	1.317648 × 10⁸
Variance	1.4608107 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	470	34.0%
70000	79	5.7%
80000	74	5.4%
60000	72	5.2%
150000	64	4.6%
100000	62	4.5%
50000	52	3.8%
120000	49	3.5%
90000	35	2.5%
250000	31	2.2%
Other values (82)	395	28.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	470	34.0%
20000	4	0.3%
22000	6	0.4%
23000	1	0.1%
25000	9	0.7%
30000	10	0.7%
35000	8	0.6%
40000	24	1.7%
45000	10	0.7%
50000	52	3.8%

Value	Count	Frequency (%)
1000000	1	0.1%
990000	1	0.1%
903000	1	0.1%
900000	2	0.1%
800000	1	0.1%
680000	1	0.1%
600000	1	0.1%
599000	1	0.1%
596000	1	0.1%
580000	1	0.1%

비수기주중요금
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	106
Distinct (%)	7.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	85532.176

Minimum	0
Maximum	1100000
Zeros	263
Zeros (%)	19.0%
Negative	0
Negative (%)	0.0%
Memory size	12.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	35000
median	55000
Q3	100000
95-th percentile	271000
Maximum	1100000
Range	1100000
Interquartile range (IQR)	65000

Descriptive statistics

Standard deviation	104847.73
Coefficient of variation (CV)	1.2258279
Kurtosis	17.710704
Mean	85532.176
Median Absolute Deviation (MAD)	35000
Skewness	3.3633143
Sum	1.18291 × 10⁸
Variance	1.0993047 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	263	19.0%
50000	155	11.2%
40000	127	9.2%
60000	92	6.7%
80000	79	5.7%
70000	75	5.4%
100000	61	4.4%
120000	49	3.5%
130000	40	2.9%
30000	36	2.6%
Other values (96)	406	29.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	263	19.0%
5000	1	0.1%
10000	2	0.1%
15000	2	0.1%
17000	1	0.1%
18000	4	0.3%
20000	13	0.9%
21000	1	0.1%
22000	4	0.3%
25000	10	0.7%

Value	Count	Frequency (%)
1100000	1	0.1%
990000	1	0.1%
830000	1	0.1%
730000	1	0.1%
710000	1	0.1%
682000	1	0.1%
600000	1	0.1%
590000	1	0.1%
580000	1	0.1%
572000	1	0.1%

비수기주말요금
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	111
Distinct (%)	8.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	100303.69

Minimum	0
Maximum	1100000
Zeros	270
Zeros (%)	19.5%
Negative	0
Negative (%)	0.0%
Memory size	12.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	40000
median	70000
Q3	130000
95-th percentile	300000
Maximum	1100000
Range	1100000
Interquartile range (IQR)	90000

Descriptive statistics

Standard deviation	114398.17
Coefficient of variation (CV)	1.1405181
Kurtosis	12.120202
Mean	100303.69
Median Absolute Deviation (MAD)	47000
Skewness	2.7554966
Sum	1.3872 × 10⁸
Variance	1.3086941 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	270	19.5%
50000	129	9.3%
60000	91	6.6%
80000	85	6.1%
70000	84	6.1%
100000	76	5.5%
150000	69	5.0%
40000	68	4.9%
120000	39	2.8%
90000	31	2.2%
Other values (101)	441	31.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	270	19.5%
2000	1	0.1%
10000	2	0.1%
15000	1	0.1%
20000	7	0.5%
22000	5	0.4%
23000	1	0.1%
25000	14	1.0%
30000	18	1.3%
35000	14	1.0%

Value	Count	Frequency (%)
1100000	1	0.1%
990000	1	0.1%
830000	1	0.1%
730000	1	0.1%
710000	1	0.1%
682000	1	0.1%
653000	1	0.1%
630000	1	0.1%
620000	1	0.1%
600000	2	0.1%

추가객실정보
Text

MISSING

Distinct	59
Distinct (%)	39.1%
Missing	1232
Missing (%)	89.1%
Memory size	10.9 KiB

Length

Max length	158
Median length	69
Mean length	22
Min length	5

Characters and Unicode

Total characters	3322
Distinct characters	187
Distinct categories	12 ?
Distinct scripts	3 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	39 ?
Unique (%)	25.8%

Sample

1st row	대인 10,000원 소인 5,000원
2nd row	대인 10,000원 소인 5,000원
3rd row	대인 10,000원 소인 5,000원
4th row	대인 10,000원 소인 5,000원
5th row	대인 10,000원 소인 5,000원

Value	Count	Frequency (%)
소인	52	8.3%
	46	7.3%
10,000원	39	6.2%
추가요금	32	5.1%
5,000원	28	4.5%
객실수	27	4.3%
대인	19	3.0%
가격	15	2.4%
업체	14	2.2%
문의	14	2.2%
Other values (194)	340	54.3%

Most occurring characters

Value	Count	Frequency (%)
	537	16.2%
0	447	13.5%
,	189	5.7%
1	145	4.4%
인	123	3.7%
원	115	3.5%
)	62	1.9%
(	62	1.9%
소	62	1.9%
가	61	1.8%
Other values (177)	1519	45.7%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	1419	42.7%
Decimal Number	831	25.0%
Space Separator	537	16.2%
Other Punctuation	317	9.5%
Close Punctuation	62	1.9%
Open Punctuation	62	1.9%
Lowercase Letter	30	0.9%
Math Symbol	28	0.8%
Control	16	0.5%
Other Symbol	14	0.4%
Other values (2)	6	0.2%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
인	123	8.7%
원	115	8.1%
소	62	4.4%
가	61	4.3%
금	51	3.6%
요	47	3.3%
실	47	3.3%
대	46	3.2%
수	45	3.2%
개	45	3.2%
Other values (143)	777	54.8%

Decimal Number

Value	Count	Frequency (%)
0	447	53.8%
1	145	17.4%
2	60	7.2%
5	57	6.9%
3	34	4.1%
4	28	3.4%
6	24	2.9%
8	15	1.8%
9	13	1.6%
7	8	1.0%

Lowercase Letter

Value	Count	Frequency (%)
r	10	33.3%
b	9	30.0%
a	4	13.3%
x	2	6.7%
t	2	6.7%
d	2	6.7%
o	1	3.3%

Other Punctuation

Value	Count	Frequency (%)
,	189	59.6%
:	57	18.0%
/	30	9.5%
.	29	9.1%
*	11	3.5%
※	1	0.3%

Math Symbol

Value	Count	Frequency (%)
~	8	28.6%
<	7	25.0%
>	7	25.0%
+	6	21.4%

Space Separator

Value	Count	Frequency (%)
	537	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	62	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	62	100.0%

Control

Value	Count	Frequency (%)
	16	100.0%

Other Symbol

Value	Count	Frequency (%)
㎡	14	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	4	100.0%

Uppercase Letter

Value	Count	Frequency (%)
E	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1871	56.3%
Hangul	1419	42.7%
Latin	32	1.0%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
인	123	8.7%
원	115	8.1%
소	62	4.4%
가	61	4.3%
금	51	3.6%
요	47	3.3%
실	47	3.3%
대	46	3.2%
수	45	3.2%
개	45	3.2%
Other values (143)	777	54.8%

Common

Value	Count	Frequency (%)
	537	28.7%
0	447	23.9%
,	189	10.1%
1	145	7.7%
)	62	3.3%
(	62	3.3%
2	60	3.2%
:	57	3.0%
5	57	3.0%
3	34	1.8%
Other values (16)	221	11.8%

Latin

Value	Count	Frequency (%)
r	10	31.2%
b	9	28.1%
a	4	12.5%
x	2	6.2%
t	2	6.2%
d	2	6.2%
E	2	6.2%
o	1	3.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1888	56.8%
Hangul	1419	42.7%
CJK Compat	14	0.4%
Punctuation	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	537	28.4%
0	447	23.7%
,	189	10.0%
1	145	7.7%
)	62	3.3%
(	62	3.3%
2	60	3.2%
:	57	3.0%
5	57	3.0%
3	34	1.8%
Other values (22)	238	12.6%

Hangul

Value	Count	Frequency (%)
인	123	8.7%
원	115	8.1%
소	62	4.4%
가	61	4.3%
금	51	3.6%
요	47	3.3%
실	47	3.3%
대	46	3.2%
수	45	3.2%
개	45	3.2%
Other values (143)	777	54.8%

CJK Compat

Value	Count	Frequency (%)
㎡	14	100.0%

Punctuation

Value	Count	Frequency (%)
※	1	100.0%

Heatmap
Table

	객실종류영어	선호도	기준인원	최대인원	추가비용	규모	성수기주중요금	성수기주말요금	극성수기주중요금	극성수기주말요금	비수기주중요금	비수기주말요금	추가객실정보
객실종류영어	1.000	0.763	0.977	0.693	NaN	NaN	0.981	0.981	0.958	0.950	0.937	0.881	1.000
선호도	0.763	1.000	0.424	0.371	0.000	0.000	0.099	0.110	0.000	0.078	0.129	0.115	0.465
기준인원	0.977	0.424	1.000	0.864	0.000	0.000	0.344	0.414	0.422	0.331	0.375	0.383	0.860
최대인원	0.693	0.371	0.864	1.000	0.000	0.031	0.296	0.340	0.364	0.274	0.336	0.351	0.900
추가비용	NaN	0.000	0.000	0.000	1.000	1.000	0.112	0.088	0.036	0.120	0.109	0.000	NaN
규모	NaN	0.000	0.000	0.031	1.000	1.000	0.150	0.133	0.061	0.135	0.143	0.076	NaN
성수기주중요금	0.981	0.099	0.344	0.296	0.112	0.150	1.000	0.987	0.769	0.860	0.979	0.985	0.956
성수기주말요금	0.981	0.110	0.414	0.340	0.088	0.133	0.987	1.000	0.803	0.911	0.978	0.983	0.964
극성수기주중요금	0.958	0.000	0.422	0.364	0.036	0.061	0.769	0.803	1.000	0.954	0.679	0.745	0.876
극성수기주말요금	0.950	0.078	0.331	0.274	0.120	0.135	0.860	0.911	0.954	1.000	0.815	0.869	0.887
비수기주중요금	0.937	0.129	0.375	0.336	0.109	0.143	0.979	0.978	0.679	0.815	1.000	0.994	0.957
비수기주말요금	0.881	0.115	0.383	0.351	0.000	0.076	0.985	0.983	0.745	0.869	0.994	1.000	0.950
추가객실정보	1.000	0.465	0.860	0.900	NaN	NaN	0.956	0.964	0.876	0.887	0.957	0.950	1.000

Heatmap
Table

	객실종류영어	선호도
객실종류영어	1.000	0.420
선호도	0.420	1.000

Heatmap
Table

	기준인원	최대인원	추가비용	규모	성수기주중요금	성수기주말요금	극성수기주중요금	극성수기주말요금	비수기주중요금	비수기주말요금	객실종류영어	선호도
기준인원	1.000	0.730	-0.114	0.331	0.337	0.324	0.167	0.182	0.335	0.318	0.712	0.276
최대인원	0.730	1.000	-0.120	0.352	0.304	0.295	0.135	0.152	0.312	0.296	0.508	0.235
추가비용	-0.114	-0.120	1.000	-0.244	0.052	0.027	0.144	0.119	-0.002	0.002	1.000	0.000
규모	0.331	0.352	-0.244	1.000	0.324	0.337	0.164	0.179	0.351	0.355	1.000	0.000
성수기주중요금	0.337	0.304	0.052	0.324	1.000	0.954	0.612	0.587	0.879	0.879	0.723	0.063
성수기주말요금	0.324	0.295	0.027	0.337	0.954	1.000	0.608	0.636	0.879	0.908	0.723	0.070
극성수기주중요금	0.167	0.135	0.144	0.164	0.612	0.608	1.000	0.973	0.618	0.633	0.743	0.000
극성수기주말요금	0.182	0.152	0.119	0.179	0.587	0.636	0.973	1.000	0.621	0.649	0.726	0.046
비수기주중요금	0.335	0.312	-0.002	0.351	0.879	0.879	0.618	0.621	1.000	0.967	0.763	0.058
비수기주말요금	0.318	0.296	0.002	0.355	0.879	0.908	0.633	0.649	0.967	1.000	0.696	0.052
객실종류영어	0.712	0.508	1.000	1.000	0.723	0.723	0.743	0.726	0.763	0.696	1.000	0.420
선호도	0.276	0.235	0.000	0.000	0.063	0.070	0.000	0.046	0.058	0.052	0.420	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	객실종류	객실종류영어	선호도	기타객실정보	기준인원	최대인원	추가비용	성수기주중요금	성수기주말요금	극성수기주중요금	극성수기주말요금	비수기주중요금	비수기주말요금	추가객실정보
0	양실	<NA>	1	01,02,03,04,05,07,08,09,10,11,14,15	2	3	10000	50000	50000	50000	50000	40000	40000	<NA>
1	온돌	Korean Style Room	1	01,03,04,07,09,10,14,15	2	0	0	45000	55000	45000	55000	35000	45000	<NA>
2	일반	Standard Room	1	01,03,04,07,10,14,15	2	0	0	45000	55000	45000	55000	35000	45000	<NA>
3	특실	Special Room	1	01,02,03,04,05,06,07,08,09,10,11,14,15	2	0	10000	55000	65000	0	0	45000	55000	<NA>
4	트윈룸	Special Room	1	01,02,03,04,05,07,09,10,11,14,15,16	2	4	10000	70000	70000	70000	70000	70000	70000	<NA>
5	일반실	Western Style Room	1	01,02,03,04,05,07,09,10,11,14,15	2	0	10000	40000	40000	40000	40000	40000	40000	<NA>
6	한실	Korean Style Room	1	01,02,03,04,05,07,09,10,11,14,15	2	4	10000	0	0	0	0	0	0	<NA>
7	한실	<NA>	1	01,03,04,05,07,08,09,10,11,14,15	2	4	5000	0	0	0	0	0	0	<NA>
8	특실	<NA>	1	01,03,04,05,06,07,08,09,10,11,14,15	2	4	10000	80000	100000	0	0	40000	50000	<NA>
9	일반실	<NA>	1	01,03,04,05,07,08,09,10,11,14,15	2	3	10000	60000	70000	60000	70000	40000	50000	<NA>

	객실종류	객실종류영어	선호도	기타객실정보	추가비용	성수기주중요금	성수기주말요금	극성수기주중요금	극성수기주말요금	비수기주중요금	비수기주말요금	추가객실정보
1373	일반실B	<NA>	<NA>	<NA>	10000	45000	70000	75000	75000	45000	70000	대인:10,000(평일), 15,000원(주말) / 소인:5,000(평일), 10,000(주말)
1374	디럭스	<NA>	<NA>	<NA>	10000	50000	80000	90000	90000	50000	80000	대인:10,000(평일), 15,000원(주말) / 소인:5,000(평일), 10,000(주말)
1375	트윈	<NA>	<NA>	<NA>	10000	65000	90000	120000	120000	65000	90000	대인:10,000(평일), 15,000원(주말) / 소인:5,000(평일), 10,000(주말)
1376	2PC룸	<NA>	<NA>	<NA>	10000	65000	90000	120000	120000	65000	90000	대인:10,000(평일), 15,000원(주말) / 소인:5,000(평일), 10,000(주말)
1377	일반	<NA>	<NA>	<NA>	10000	50000	50000	60000	60000	40000	40000	<NA>
1378	일반실 침대	<NA>	<NA>	<NA>	10000	55000	65000	75000	75000	35000	45000	<NA>
1379	일반실 온돌	<NA>	<NA>	<NA>	10000	60000	70000	80000	80000	40000	50000	<NA>
1380	특실	<NA>	<NA>	<NA>	10000	75000	85000	95000	95000	45000	65000	<NA>
1381	트윈실	<NA>	<NA>	<NA>	10000	80000	90000	100000	100000	60000	70000	<NA>
1382	가족실	<NA>	<NA>	<NA>	10000	80000	90000	100000	100000	60000	70000	<NA>

Most frequently occurring

	객실종류	객실종류영어	선호도	기타객실정보	기준인원	최대인원	추가비용	규모	성수기주중요금	성수기주말요금	극성수기주중요금	극성수기주말요금	비수기주중요금	비수기주말요금	추가객실정보	# duplicates
14	펜션	<NA>	1	01,02,03,04,05,07,08,09,10,12,13,14	0	0	0	0	0	0	0	0	0	0	<NA>	6
10	짱구	<NA>	3	01,02,03,04,07,10,12,13	0	0	0	0	0	0	0	0	0	0	<NA>	4
8	일반실	<NA>	<NA>	<NA>	2	0	10000	0	50000	50000	50000	50000	40000	40000	<NA>	3
0	B1, B2	<NA>	1	01,02,03,04,07,08,10,11,12,13	2	4	0	43	150000	210000	0	0	130000	180000	<NA>	2
1	F3	<NA>	2	01,02,03,04,07,08,10,11,12,13	2	2	0	43	200000	260000	0	0	180000	230000	<NA>	2
2	객실	<NA>	1	01,02,03,04,07,10,12,13,14	0	0	0	0	0	0	0	0	0	0	<NA>	2
3	돔하우스 12평형	<NA>	<NA>	<NA>	0	0	0	0	0	0	0	0	0	0	<NA>	2
4	일반실	<NA>	<NA>	02,04,07,09,11,12,13	0	0	0	0	0	0	0	0	0	0	<NA>	2
5	일반실	<NA>	<NA>	<NA>	0	0	0	0	0	0	0	0	0	0	<NA>	2
6	일반실	<NA>	<NA>	<NA>	0	0	10000	0	60000	70000	80000	80000	50000	60000	<NA>	2

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Math Symbol

Open Punctuation

Space Separator

Close Punctuation

Dash Punctuation

Control

Most occurring scripts

Most frequent character per script

Hangul

Latin

Common

Han

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Compat Jamo

CJK

Common Values

Length

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Decimal Number

Lowercase Letter

Other Punctuation

Math Symbol

Space Separator

Close Punctuation

Open Punctuation

Control

Other Symbol

Dash Punctuation

Uppercase Letter

Most occurring scripts

Most frequent character per script

Hangul

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Hangul

CJK Compat

Punctuation

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring