Overview

Dataset statistics

Number of variables7
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows17
Duplicate rows (%)17.0%
Total size in memory5.8 KiB
Average record size in memory59.3 B

Variable types

Categorical4
Text1
Numeric2

Dataset

DescriptionSample
Author경기대학교 빅데이터센터
URLhttps://www.bigdata-telecom.kr/invoke/SOKBP2603/?goodsCode=KGUPUBLICWIFI

Alerts

광역시도명 has constant value ""Constant
시군구명 has constant value ""Constant
Dataset has 17 (17.0%) duplicate rowsDuplicates
위도Y좌표 is highly overall correlated with AP명High correlation
경도X좌표 is highly overall correlated with AP명High correlation
AP명 is highly overall correlated with 위도Y좌표 and 2 other fieldsHigh correlation
카테고리명 is highly overall correlated with AP명High correlation
위도Y좌표 has 16 (16.0%) zerosZeros
경도X좌표 has 16 (16.0%) zerosZeros

Reproduction

Analysis started2023-12-10 06:25:54.408204
Analysis finished2023-12-10 06:25:56.074708
Duration1.67 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

광역시도명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
강원도
100 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row강원도
2nd row강원도
3rd row강원도
4th row강원도
5th row강원도

Common Values

ValueCountFrequency (%)
강원도 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:25:56.348720image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
강원도 100
100.0%

시군구명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
강릉시
100 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row강릉시
2nd row강릉시
3rd row강릉시
4th row강릉시
5th row강릉시

Common Values

ValueCountFrequency (%)
강릉시 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:25:56.668493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
강릉시 100
100.0%

상세주소
Text

Distinct52
Distinct (%)52.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-10T15:25:57.030766image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length50
Median length39
Mean length24.75
Min length11

Characters and Unicode

Total characters2475
Distinct characters141
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique32 ?
Unique (%)32.0%

Sample

1st row옥계면 금진리 464-1번지
2nd row옥계면 금진리 464-1번지
3rd row옥계면 금진리 464-1번지
4th row옥계면 금진리 464-1번지
5th row옥계면 금진리 464-1번지
ValueCountFrequency (%)
강릉시 45
 
9.5%
강원도 37
 
7.8%
내곡동 16
 
3.4%
413-0 16
 
3.4%
1층 15
 
3.2%
옥계면 12
 
2.5%
금진리 12
 
2.5%
464-1번지 11
 
2.3%
주문진읍 11
 
2.3%
공공-강릉-강릉시 10
 
2.1%
Other values (113) 287
60.8%
2023-12-10T15:25:57.669403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
386
 
15.6%
- 162
 
6.5%
강 146
 
5.9%
1 125
 
5.1%
릉 80
 
3.2%
4 74
 
3.0%
동 73
 
2.9%
2 70
 
2.8%
원 64
 
2.6%
시 64
 
2.6%
Other values (131) 1231
49.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1391
56.2%
Decimal Number 489
 
19.8%
Space Separator 386
 
15.6%
Dash Punctuation 162
 
6.5%
Uppercase Letter 20
 
0.8%
Close Punctuation 10
 
0.4%
Open Punctuation 10
 
0.4%
Other Symbol 4
 
0.2%
Other Punctuation 3
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
강 146
 
10.5%
릉 80
 
5.8%
동 73
 
5.2%
원 64
 
4.6%
시 64
 
4.6%
리 44
 
3.2%
도 44
 
3.2%
지 40
 
2.9%
번 39
 
2.8%
면 36
 
2.6%
Other values (109) 761
54.7%
Decimal Number
ValueCountFrequency (%)
1 125
25.6%
4 74
15.1%
2 70
14.3%
0 50
 
10.2%
6 46
 
9.4%
3 45
 
9.2%
8 25
 
5.1%
5 23
 
4.7%
7 16
 
3.3%
9 15
 
3.1%
Uppercase Letter
ValueCountFrequency (%)
A 6
30.0%
G 6
30.0%
P 3
15.0%
I 3
15.0%
T 1
 
5.0%
K 1
 
5.0%
Space Separator
ValueCountFrequency (%)
386
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 162
100.0%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 4
100.0%
Other Punctuation
ValueCountFrequency (%)
/ 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1395
56.4%
Common 1060
42.8%
Latin 20
 
0.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
강 146
 
10.5%
릉 80
 
5.7%
동 73
 
5.2%
원 64
 
4.6%
시 64
 
4.6%
리 44
 
3.2%
도 44
 
3.2%
지 40
 
2.9%
번 39
 
2.8%
면 36
 
2.6%
Other values (110) 765
54.8%
Common
ValueCountFrequency (%)
386
36.4%
- 162
15.3%
1 125
 
11.8%
4 74
 
7.0%
2 70
 
6.6%
0 50
 
4.7%
6 46
 
4.3%
3 45
 
4.2%
8 25
 
2.4%
5 23
 
2.2%
Other values (5) 54
 
5.1%
Latin
ValueCountFrequency (%)
A 6
30.0%
G 6
30.0%
P 3
15.0%
I 3
15.0%
T 1
 
5.0%
K 1
 
5.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1391
56.2%
ASCII 1080
43.6%
None 4
 
0.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
386
35.7%
- 162
15.0%
1 125
 
11.6%
4 74
 
6.9%
2 70
 
6.5%
0 50
 
4.6%
6 46
 
4.3%
3 45
 
4.2%
8 25
 
2.3%
5 23
 
2.1%
Other values (11) 74
 
6.9%
Hangul
ValueCountFrequency (%)
강 146
 
10.5%
릉 80
 
5.8%
동 73
 
5.2%
원 64
 
4.6%
시 64
 
4.6%
리 44
 
3.2%
도 44
 
3.2%
지 40
 
2.9%
번 39
 
2.8%
면 36
 
2.6%
Other values (109) 761
54.7%
None
ValueCountFrequency (%)
㈜ 4
100.0%

AP명
Categorical

HIGH CORRELATION 

Distinct42
Distinct (%)42.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
(재)한국여성수련원
12 
강원도립대학
7 
경포해수욕장
 
6
강원_강릉시_송정동
 
5
LG유플러스
 
4
Other values (37)
66 

Length

Max length33
Median length25
Mean length13.43
Min length4

Unique

Unique17 ?
Unique (%)17.0%

Sample

1st row(재)한국여성수련원
2nd row(재)한국여성수련원
3rd row(재)한국여성수련원
4th row(재)한국여성수련원
5th row(재)한국여성수련원

Common Values

ValueCountFrequency (%)
(재)한국여성수련원 12
 
12.0%
강원도립대학 7
 
7.0%
경포해수욕장 6
 
6.0%
강원_강릉시_송정동 5
 
5.0%
LG유플러스 4
 
4.0%
강릉원주대학교 4
 
4.0%
공공-강릉-강남동사무소-1-1 3
 
3.0%
Northern Senior Welfare Center 1 3
 
3.0%
공공-강릉-교2동사무소-1-1-6 3
 
3.0%
공공-강릉-강동면사무소-1-1-174 3
 
3.0%
Other values (32) 50
50.0%

Length

2023-12-10T15:25:57.970070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
공공-강릉-강릉시 16
 
10.7%
재)한국여성수련원 12
 
8.1%
강원도립대학 7
 
4.7%
경포해수욕장 6
 
4.0%
강원_강릉시_송정동 5
 
3.4%
center 5
 
3.4%
lg유플러스 4
 
2.7%
강릉원주대학교 4
 
2.7%
1 4
 
2.7%
강릉의료원 3
 
2.0%
Other values (50) 83
55.7%

위도Y좌표
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct33
Distinct (%)33.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean31.73675
Minimum0
Maximum38
Zeros16
Zeros (%)16.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T15:25:58.173455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q137.629313
median37.743505
Q337.773636
95-th percentile38
Maximum38
Range38
Interquartile range (IQR)0.1443224

Descriptive statistics

Standard deviation13.921166
Coefficient of variation (CV)0.43864498
Kurtosis1.5772792
Mean31.73675
Median Absolute Deviation (MAD)0.084956172
Skewness-1.8830194
Sum3173.675
Variance193.79886
MonotonicityNot monotonic
2023-12-10T15:25:58.403927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=33)
ValueCountFrequency (%)
0.0 16
16.0%
37.74269 15
15.0%
37.629313443461 12
12.0%
38.0 10
 
10.0%
37.851125659491 4
 
4.0%
37.749572382085 3
 
3.0%
37.773402438699 3
 
3.0%
37.76794 3
 
3.0%
37.72808 3
 
3.0%
37.74416 3
 
3.0%
Other values (23) 28
28.0%
ValueCountFrequency (%)
0.0 16
16.0%
37.629313443461 12
12.0%
37.71833 1
 
1.0%
37.723026963 2
 
2.0%
37.72808 3
 
3.0%
37.74269 15
15.0%
37.74285 1
 
1.0%
37.74416 3
 
3.0%
37.749572382085 3
 
3.0%
37.7546 1
 
1.0%
ValueCountFrequency (%)
38.0 10
10.0%
37.911939 1
 
1.0%
37.893746 2
 
2.0%
37.89125 1
 
1.0%
37.874196 1
 
1.0%
37.874161 1
 
1.0%
37.874121 1
 
1.0%
37.8688765226 1
 
1.0%
37.851125659491 4
 
4.0%
37.805796684479 1
 
1.0%

경도X좌표
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct33
Distinct (%)33.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean108.2893
Minimum0
Maximum129.0465
Zeros16
Zeros (%)16.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T15:25:58.651911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q1128.83139
median128.88448
Q3128.95147
95-th percentile129.0465
Maximum129.0465
Range129.0465
Interquartile range (IQR)0.12007704

Descriptive statistics

Standard deviation47.499474
Coefficient of variation (CV)0.43863496
Kurtosis1.5776506
Mean108.2893
Median Absolute Deviation (MAD)0.055355528
Skewness-1.8832095
Sum10828.93
Variance2256.2
MonotonicityNot monotonic
2023-12-10T15:25:58.897321image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=33)
ValueCountFrequency (%)
0.0 16
16.0%
128.88281 15
15.0%
129.0465029905 12
12.0%
129.0 10
 
10.0%
128.740030338159 4
 
4.0%
128.889517475176 3
 
3.0%
128.913294408344 3
 
3.0%
128.89233 3
 
3.0%
128.95422 3
 
3.0%
128.90556 3
 
3.0%
Other values (23) 28
28.0%
ValueCountFrequency (%)
0.0 16
16.0%
128.740030338159 4
 
4.0%
128.816803 1
 
1.0%
128.823175 2
 
2.0%
128.826856944444 1
 
1.0%
128.831386 1
 
1.0%
128.831395 1
 
1.0%
128.831417 1
 
1.0%
128.845406909 1
 
1.0%
128.854290603018 2
 
2.0%
ValueCountFrequency (%)
129.0465029905 12
12.0%
129.0 10
10.0%
128.95422 3
 
3.0%
128.950553055556 1
 
1.0%
128.924694444444 1
 
1.0%
128.919007 1
 
1.0%
128.913294408344 3
 
3.0%
128.913288888889 1
 
1.0%
128.910655962377 1
 
1.0%
128.907432187916 1
 
1.0%

카테고리명
Categorical

HIGH CORRELATION 

Distinct13
Distinct (%)13.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
의료시설
22 
체육시설
17 
교육시설
16 
공공기관
13 
문화시설
11 
Other values (8)
21 

Length

Max length10
Median length4
Mean length3.89
Min length2

Unique

Unique3 ?
Unique (%)3.0%

Sample

1st row체육시설
2nd row체육시설
3rd row체육시설
4th row체육시설
5th row체육시설

Common Values

ValueCountFrequency (%)
의료시설 22
22.0%
체육시설 17
17.0%
교육시설 16
16.0%
공공기관 13
13.0%
문화시설 11
11.0%
해변 7
 
7.0%
휴게소 4
 
4.0%
복지시설 3
 
3.0%
공원 2
 
2.0%
공항/터미널/대합실 2
 
2.0%
Other values (3) 3
 
3.0%

Length

2023-12-10T15:25:59.127699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
의료시설 22
22.0%
체육시설 17
17.0%
교육시설 16
16.0%
공공기관 13
13.0%
문화시설 11
11.0%
해변 7
 
7.0%
휴게소 4
 
4.0%
복지시설 3
 
3.0%
공원 2
 
2.0%
공항/터미널/대합실 2
 
2.0%
Other values (3) 3
 
3.0%

Interactions

2023-12-10T15:25:55.437153image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:25:55.046287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:25:55.629114image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:25:55.203814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:25:59.260117image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상세주소AP명위도Y좌표경도X좌표카테고리명
상세주소1.0000.9980.9930.9931.000
AP명0.9981.0000.9950.9950.999
위도Y좌표0.9930.9951.0000.9980.530
경도X좌표0.9930.9950.9981.0000.530
카테고리명1.0000.9990.5300.5301.000
2023-12-10T15:25:59.446104image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
AP명카테고리명
AP명1.0000.810
카테고리명0.8101.000
2023-12-10T15:25:59.582704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도Y좌표경도X좌표AP명카테고리명
위도Y좌표1.0000.2760.7270.466
경도X좌표0.2761.0000.7270.466
AP명0.7270.7271.0000.810
카테고리명0.4660.4660.8101.000

Missing values

2023-12-10T15:25:55.816200image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T15:25:55.999801image/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

광역시도명시군구명상세주소AP명위도Y좌표경도X좌표카테고리명
0강원도강릉시옥계면 금진리 464-1번지(재)한국여성수련원37.629313129.046503체육시설
1강원도강릉시옥계면 금진리 464-1번지(재)한국여성수련원37.629313129.046503체육시설
2강원도강릉시옥계면 금진리 464-1번지(재)한국여성수련원37.629313129.046503체육시설
3강원도강릉시옥계면 금진리 464-1번지(재)한국여성수련원37.629313129.046503체육시설
4강원도강릉시옥계면 금진리 464-1번지(재)한국여성수련원37.629313129.046503체육시설
5강원도강릉시옥계면 금진리 464-1번지(재)한국여성수련원37.629313129.046503체육시설
6강원도강릉시옥계면 금진리 464-1 한국여성수련원 기가대개체(재)한국여성수련원37.629313129.046503체육시설
7강원도강릉시옥계면 금진리 464-1번지(재)한국여성수련원37.629313129.046503체육시설
8강원도강릉시옥계면 금진리 464-1번지(재)한국여성수련원37.629313129.046503체육시설
9강원도강릉시옥계면 금진리 464-1번지(재)한국여성수련원37.629313129.046503체육시설
광역시도명시군구명상세주소AP명위도Y좌표경도X좌표카테고리명
90강원도강릉시강원도 강릉시 내곡동 413-0 공공-강릉-강릉시 보건소-3-1-246공공-강릉-강릉시 보건소-3-1-24637.74269128.88281의료시설
91강원도강릉시강원도 강릉시 내곡동 413-0 해당없음공공-강릉-강릉시 보건소-3-2-24737.74269128.88281의료시설
92강원도강릉시강원도 강릉시 내곡동 413-0 공공-강릉-강릉시 보건소-3-2-247공공-강릉-강릉시 보건소-3-2-24737.74269128.88281의료시설
93강원도강릉시강원도 강릉시 내곡동 413-0 공공-강릉-강릉시 보건소-3-3-248공공-강릉-강릉시 보건소-3-3-24837.74269128.88281의료시설
94강원도강릉시강원도 강릉시 내곡동 413-0 해당없음공공-강릉-강릉시 보건소-3-3-24837.74269128.88281의료시설
95강원도강릉시강원도 강릉시 내곡동 413-0 공공-강릉-강릉시 보건소민원실-1-80공공-강릉-강릉시 보건소민원실-1-8037.74285128.88269의료시설
96강원도강릉시강원도 강릉시 교동 1874-0 공공-강릉-교2동사무소-1-1-6공공-강릉-교2동사무소-1-1-637.76794128.89233공공기관
97강원도강릉시강원도 강릉시 교동 1874-0 공공-강릉-교2동사무소-1-1-6공공-강릉-교2동사무소-1-1-637.76794128.89233공공기관
98강원도강릉시강원도 강릉시 교동 1874-0 해당없음공공-강릉-교2동사무소-1-1-637.76794128.89233공공기관
99강원도강릉시강원도 강릉시 구정면 여찬리 354-7 공공-강릉-구정면사무소-1-1-347공공-강릉-구정면사무소-1-1-34737.71833128.88공공기관

Duplicate rows

Most frequently occurring

광역시도명시군구명상세주소AP명위도Y좌표경도X좌표카테고리명# duplicates
11강원도강릉시옥계면 금진리 464-1번지(재)한국여성수련원37.629313129.046503체육시설11
5강원도강릉시강원도 강릉시 송정동 1047 -0 한국방송통신대학교 1층강원_강릉시_송정동0.00.0교육시설5
9강원도강릉시사천면 사천진리 산1-3번지강릉원주대학교0.00.0교육시설4
13강원도강릉시주문진읍 교항리 8-2번지 강원도립대학 (구내변경)강원도립대학38.0129.0교육시설4
0강원도강릉시강문동 260-26번지 경포해수욕장 1층경포해수욕장38.0129.0해변3
6강원도강릉시강원도 강릉시 포남2동 1295 강릉시여성문화회관강원_강릉시_포남2동0.00.0문화시설3
8강원도강릉시남문동 164-1번지강릉의료원37.749572128.889517의료시설3
10강원도강릉시연곡면 퇴곡리 226 소금강수련원 / 구내설변LG유플러스37.851126128.74003체육시설3
12강원도강릉시주문진읍 교항리 8-2번지강원도립대학38.0129.0교육시설3
15강원도강릉시포남2동 1295번지 여성문화회관강릉시여성문화회관37.773402128.913294문화시설3