Overview

Dataset statistics

Number of variables7
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.0 KiB
Average record size in memory61.3 B

Variable types

Categorical3
Numeric4

Alerts

trrsrt_nm is highly overall correlated with tel_no and 2 other fieldsHigh correlation
addr is highly overall correlated with tel_no and 2 other fieldsHigh correlation
tel_no is highly overall correlated with trrsrt_nm and 1 other fieldsHigh correlation
cl_nm is highly overall correlated with trrsrt_nm and 1 other fieldsHigh correlation
tot_entrn_nmpr_co has unique valuesUnique
setle_price has 41 (41.0%) zerosZeros

Reproduction

Analysis started2023-12-10 10:10:17.425039
Analysis finished2023-12-10 10:10:21.513757
Duration4.09 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

cl_nm
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
자연
64 
공연전시
34 
숙박시설
 
2

Length

Max length4
Median length2
Mean length2.72
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row공연전시
2nd row자연
3rd row공연전시
4th row공연전시
5th row공연전시

Common Values

ValueCountFrequency (%)
자연 64
64.0%
공연전시 34
34.0%
숙박시설 2
 
2.0%

Length

2023-12-10T19:10:21.661300image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:10:21.862034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
자연 64
64.0%
공연전시 34
34.0%
숙박시설 2
 
2.0%

trrsrt_nm
Categorical

HIGH CORRELATION 

Distinct20
Distinct (%)20.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
서귀포치유의숲
 
6
모구리야영장
 
6
산방산암벽식물지대
 
6
정방폭포
 
6
만장굴
 
6
Other values (15)
70 

Length

Max length10
Median length9
Mean length5.83
Min length3

Unique

Unique1 ?
Unique (%)1.0%

Sample

1st row감귤박물관
2nd row천지연폭포
3rd row감귤박물관
4th row감귤박물관
5th row감귤박물관

Common Values

ValueCountFrequency (%)
서귀포치유의숲 6
 
6.0%
모구리야영장 6
 
6.0%
산방산암벽식물지대 6
 
6.0%
정방폭포 6
 
6.0%
만장굴 6
 
6.0%
성산일출봉 6
 
6.0%
비자림 6
 
6.0%
제주돌문화공원 6
 
6.0%
소암기념관 6
 
6.0%
서복전시관 6
 
6.0%
Other values (10) 40
40.0%

Length

2023-12-10T19:10:22.056025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
서귀포치유의숲 6
 
6.0%
제주돌문화공원 6
 
6.0%
용머리해안 6
 
6.0%
모구리야영장 6
 
6.0%
서복전시관 6
 
6.0%
소암기념관 6
 
6.0%
서귀포천문과학문화관 6
 
6.0%
비자림 6
 
6.0%
성산일출봉 6
 
6.0%
만장굴 6
 
6.0%
Other values (10) 40
40.0%

addr
Categorical

HIGH CORRELATION 

Distinct18
Distinct (%)18.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
제주 서귀포시 이어도로 36-24
 
6
제주 제주시 조천읍 남조로 2023
 
6
제주 서귀포시 안덕면 사계리 산16
 
6
제주 제주시 구좌읍 비자숲길 55
 
6
제주 제주시 구좌읍 만장굴길 182
 
6
Other values (13)
70 

Length

Max length27
Median length24
Mean length19.39
Min length14

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row제주 서귀포시 효돈순환로 441
2nd row제주 서귀포시 천지동 667-7
3rd row제주 서귀포시 효돈순환로 441
4th row제주 서귀포시 효돈순환로 441
5th row제주 서귀포시 효돈순환로 441

Common Values

ValueCountFrequency (%)
제주 서귀포시 이어도로 36-24 6
 
6.0%
제주 제주시 조천읍 남조로 2023 6
 
6.0%
제주 서귀포시 안덕면 사계리 산16 6
 
6.0%
제주 제주시 구좌읍 비자숲길 55 6
 
6.0%
제주 제주시 구좌읍 만장굴길 182 6
 
6.0%
제주 서귀포시 산록남로 2271 6
 
6.0%
제주 서귀포시 성산읍 서성일로 260 6
 
6.0%
제주 서귀포시 성산읍 성산리 1 6
 
6.0%
제주 서귀포시 안덕면 사계리 112-3 6
 
6.0%
제주 서귀포시 소암로 15 6
 
6.0%
Other values (8) 40
40.0%

Length

2023-12-10T19:10:22.312466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
제주 100
21.8%
서귀포시 82
17.9%
제주시 18
 
3.9%
성산읍 12
 
2.6%
안덕면 12
 
2.6%
사계리 12
 
2.6%
구좌읍 12
 
2.6%
15 11
 
2.4%
156-8 6
 
1.3%
112-3 6
 
1.3%
Other values (34) 187
40.8%

tel_no
Real number (ℝ)

HIGH CORRELATION 

Distinct18
Distinct (%)18.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.4748858 × 108
Minimum6.4710773 × 108
Maximum6.4794294 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:10:22.520836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum6.4710773 × 108
5-th percentile6.4710773 × 108
Q16.4733153 × 108
median6.4760324 × 108
Q36.4760633 × 108
95-th percentile6.4794294 × 108
Maximum6.4794294 × 108
Range835209
Interquartile range (IQR)274801

Descriptive statistics

Standard deviation240110.78
Coefficient of variation (CV)0.00037083401
Kurtosis-0.70729125
Mean6.4748858 × 108
Median Absolute Deviation (MAD)212626.5
Skewness-0.1215742
Sum6.4748858 × 1010
Variance5.7653188 × 1010
MonotonicityNot monotonic
2023-12-10T19:10:22.768911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
647381521 6
 
6.0%
647603067 6
 
6.0%
647331530 6
 
6.0%
647399701 6
 
6.0%
647606361 6
 
6.0%
647603511 6
 
6.0%
647606321 6
 
6.0%
647107731 6
 
6.0%
647603408 6
 
6.0%
647830959 6
 
6.0%
Other values (8) 40
40.0%
ValueCountFrequency (%)
647107731 6
6.0%
647107903 6
6.0%
647107912 6
6.0%
647331528 3
3.0%
647331530 6
6.0%
647331586 5
5.0%
647381521 6
6.0%
647399701 6
6.0%
647603067 6
6.0%
647603408 6
6.0%
ValueCountFrequency (%)
647942940 6
6.0%
647830959 6
6.0%
647673010 5
5.0%
647606361 6
6.0%
647606331 4
4.0%
647606321 6
6.0%
647603567 5
5.0%
647603511 6
6.0%
647603408 6
6.0%
647603067 6
6.0%

tot_entrn_nmpr_co
Real number (ℝ)

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean28978.18
Minimum193
Maximum108320
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:10:23.092466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum193
5-th percentile640.7
Q11982.75
median12631
Q350967
95-th percentile86251.6
Maximum108320
Range108127
Interquartile range (IQR)48984.25

Descriptive statistics

Standard deviation30923.355
Coefficient of variation (CV)1.0671255
Kurtosis-0.22116057
Mean28978.18
Median Absolute Deviation (MAD)11931
Skewness0.94981062
Sum2897818
Variance9.5625391 × 108
MonotonicityNot monotonic
2023-12-10T19:10:23.450314image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
6493 1
 
1.0%
10319 1
 
1.0%
62615 1
 
1.0%
46892 1
 
1.0%
73016 1
 
1.0%
81153 1
 
1.0%
11675 1
 
1.0%
13684 1
 
1.0%
11712 1
 
1.0%
8013 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
193 1
1.0%
472 1
1.0%
563 1
1.0%
566 1
1.0%
635 1
1.0%
641 1
1.0%
676 1
1.0%
724 1
1.0%
773 1
1.0%
802 1
1.0%
ValueCountFrequency (%)
108320 1
1.0%
103948 1
1.0%
102525 1
1.0%
102451 1
1.0%
101786 1
1.0%
85434 1
1.0%
83798 1
1.0%
82486 1
1.0%
81153 1
1.0%
78547 1
1.0%

setle_price
Real number (ℝ)

ZEROS 

Distinct60
Distinct (%)60.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23173142
Minimum0
Maximum2.4937 × 108
Zeros41
Zeros (%)41.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:10:23.696644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median942775
Q316200312
95-th percentile1.1052415 × 108
Maximum2.4937 × 108
Range2.4937 × 108
Interquartile range (IQR)16200312

Descriptive statistics

Standard deviation43393076
Coefficient of variation (CV)1.872559
Kurtosis7.3260185
Mean23173142
Median Absolute Deviation (MAD)942775
Skewness2.4420471
Sum2.3173142 × 109
Variance1.882959 × 1015
MonotonicityNot monotonic
2023-12-10T19:10:24.031915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 41
41.0%
4872900 1
 
1.0%
64903900 1
 
1.0%
107749500 1
 
1.0%
11077500 1
 
1.0%
7271000 1
 
1.0%
6259500 1
 
1.0%
7933150 1
 
1.0%
7550050 1
 
1.0%
6417000 1
 
1.0%
Other values (50) 50
50.0%
ValueCountFrequency (%)
0 41
41.0%
326500 1
 
1.0%
486400 1
 
1.0%
572050 1
 
1.0%
613950 1
 
1.0%
644950 1
 
1.0%
645750 1
 
1.0%
677950 1
 
1.0%
698450 1
 
1.0%
800050 1
 
1.0%
ValueCountFrequency (%)
249370000 1
1.0%
149096000 1
1.0%
135640700 1
1.0%
115954700 1
1.0%
115516500 1
1.0%
110261400 1
1.0%
107749500 1
1.0%
102305200 1
1.0%
93463600 1
1.0%
91227300 1
1.0%

base_ym
Real number (ℝ)

Distinct6
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean202203.51
Minimum202201
Maximum202206
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:10:24.249147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum202201
5-th percentile202201
Q1202202
median202204
Q3202205
95-th percentile202206
Maximum202206
Range5
Interquartile range (IQR)3

Descriptive statistics

Standard deviation1.7026124
Coefficient of variation (CV)8.4202909 × 10-6
Kurtosis-1.2364852
Mean202203.51
Median Absolute Deviation (MAD)1
Skewness-0.036252344
Sum20220351
Variance2.8988889
MonotonicityNot monotonic
2023-12-10T19:10:24.569751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
202204 18
18.0%
202201 17
17.0%
202203 17
17.0%
202205 17
17.0%
202206 16
16.0%
202202 15
15.0%
ValueCountFrequency (%)
202201 17
17.0%
202202 15
15.0%
202203 17
17.0%
202204 18
18.0%
202205 17
17.0%
202206 16
16.0%
ValueCountFrequency (%)
202206 16
16.0%
202205 17
17.0%
202204 18
18.0%
202203 17
17.0%
202202 15
15.0%
202201 17
17.0%

Interactions

2023-12-10T19:10:20.540887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:18.149375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:18.915034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:19.490645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:20.685344image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:18.334175image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:19.061072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:19.646216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:20.852033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:18.561079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:19.194289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:19.824548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:21.004872image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:18.753035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:19.345244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:10:20.033182image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T19:10:24.814536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
cl_nmtrrsrt_nmaddrtel_notot_entrn_nmpr_cosetle_pricebase_ym
cl_nm1.0000.8830.9440.4120.7230.2170.000
trrsrt_nm0.8831.0001.0001.0000.7880.7390.000
addr0.9441.0001.0001.0000.8230.7320.000
tel_no0.4121.0001.0001.0000.4350.5210.000
tot_entrn_nmpr_co0.7230.7880.8230.4351.0000.6470.175
setle_price0.2170.7390.7320.5210.6471.0000.266
base_ym0.0000.0000.0000.0000.1750.2661.000
2023-12-10T19:10:25.001215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
trrsrt_nmaddrcl_nm
trrsrt_nm1.0000.9880.674
addr0.9881.0000.689
cl_nm0.6740.6891.000
2023-12-10T19:10:25.222085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
tel_notot_entrn_nmpr_cosetle_pricebase_ymcl_nmtrrsrt_nmaddr
tel_no1.000-0.2150.045-0.0230.2970.9270.939
tot_entrn_nmpr_co-0.2151.0000.2250.1200.4190.4320.406
setle_price0.0450.2251.0000.0040.1430.3990.410
base_ym-0.0230.1200.0041.0000.0000.0000.000
cl_nm0.2970.4190.1430.0001.0000.6740.689
trrsrt_nm0.9270.4320.3990.0000.6741.0000.988
addr0.9390.4060.4100.0000.6890.9881.000

Missing values

2023-12-10T19:10:21.225780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T19:10:21.412695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

cl_nmtrrsrt_nmaddrtel_notot_entrn_nmpr_cosetle_pricebase_ym
0공연전시감귤박물관제주 서귀포시 효돈순환로 44164767301064934872900202201
1자연천지연폭포제주 서귀포시 천지동 667-764733152882486115954700202204
2공연전시감귤박물관제주 서귀포시 효돈순환로 4416476730102840326500202203
3공연전시감귤박물관제주 서귀포시 효돈순환로 44164767301033040202204
4공연전시감귤박물관제주 서귀포시 효돈순환로 44164767301072710202205
5공연전시감귤박물관제주 서귀포시 효돈순환로 44164767301079040202206
6공연전시기당미술관제주 서귀포시 남성중로153번길 1564733158610640202205
7자연천지연폭포제주 서귀포시 천지동 667-76473315281039480202205
8공연전시서귀포시립기당미술관제주 서귀포시 남성중로153번길 1564733158616941107300202201
9공연전시서귀포시립기당미술관제주 서귀포시 남성중로153번길 156473315861196800050202202
cl_nmtrrsrt_nmaddrtel_notot_entrn_nmpr_cosetle_pricebase_ym
90자연제주돌문화공원제주 제주시 조천읍 남조로 202364710773194690202202
91자연제주돌문화공원제주 제주시 조천읍 남조로 2023647107731105810202203
92자연제주돌문화공원제주 제주시 조천읍 남조로 2023647107731174810202204
93자연제주돌문화공원제주 제주시 조천읍 남조로 2023647107731277280202205
94자연주상절리대제주 서귀포시 이어도로 36-246473815211083200202205
95자연주상절리대제주 서귀포시 이어도로 36-24647381521102451115516500202206
96자연천제연폭포제주 서귀포시 천제연로 132 천제연폭포관리소6476063313009852397650202201
97자연천제연폭포제주 서귀포시 천제연로 132 천제연폭포관리소6476063312986351527900202202
98자연천제연폭포제주 서귀포시 천제연로 132 천제연폭포관리소6476063312802642206175202203
99자연천제연폭포제주 서귀포시 천제연로 132 천제연폭포관리소6476063313896267748025202204