Overview

Dataset statistics

Number of variables6
Number of observations59
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.0 KiB
Average record size in memory51.2 B

Variable types

Numeric1
Text2
DateTime2
Categorical1

Dataset

Description인천광역시 서구 아파트 이행(하자)보증보험증권 미반환 현황 입니다. 아파트명,위치,사용검사일,비고 등으로 구분하고 있습니다.
Author인천광역시 서구
URLhttps://www.data.go.kr/data/15090888/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
연번 has unique valuesUnique
위치 has unique valuesUnique

Reproduction

Analysis started2023-12-11 22:58:51.786558
Analysis finished2023-12-11 22:58:52.241122
Duration0.45 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct59
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean30
Minimum1
Maximum59
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size663.0 B
2023-12-12T07:58:52.299457image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.9
Q115.5
median30
Q344.5
95-th percentile56.1
Maximum59
Range58
Interquartile range (IQR)29

Descriptive statistics

Standard deviation17.175564
Coefficient of variation (CV)0.5725188
Kurtosis-1.2
Mean30
Median Absolute Deviation (MAD)15
Skewness0
Sum1770
Variance295
MonotonicityStrictly increasing
2023-12-12T07:58:52.411421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.7%
2 1
 
1.7%
33 1
 
1.7%
34 1
 
1.7%
35 1
 
1.7%
36 1
 
1.7%
37 1
 
1.7%
38 1
 
1.7%
39 1
 
1.7%
40 1
 
1.7%
Other values (49) 49
83.1%
ValueCountFrequency (%)
1 1
1.7%
2 1
1.7%
3 1
1.7%
4 1
1.7%
5 1
1.7%
6 1
1.7%
7 1
1.7%
8 1
1.7%
9 1
1.7%
10 1
1.7%
ValueCountFrequency (%)
59 1
1.7%
58 1
1.7%
57 1
1.7%
56 1
1.7%
55 1
1.7%
54 1
1.7%
53 1
1.7%
52 1
1.7%
51 1
1.7%
50 1
1.7%
Distinct58
Distinct (%)98.3%
Missing0
Missing (%)0.0%
Memory size604.0 B
2023-12-12T07:58:52.626234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length19
Mean length12.508475
Min length5

Characters and Unicode

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

Unique

Unique57 ?
Unique (%)96.6%

Sample

1st row청라지구 A36 동문굿모닝힐
2nd row청라지구 A13 중흥S-클래스
3rd row청라지구 M2 우미린
4th row청라지구 A35 골드클래스
5th row청라지구 A38 한양수자인
ValueCountFrequency (%)
청라지구 14
 
9.7%
검단신도시 8
 
5.6%
검단 5
 
3.5%
루원시티 4
 
2.8%
한신더휴 3
 
2.1%
대광로제비앙 3
 
2.1%
view 3
 
2.1%
sk 3
 
2.1%
대성베르힐 3
 
2.1%
우방아이유쉘 3
 
2.1%
Other values (82) 95
66.0%
2023-12-12T07:58:52.966638image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
85
 
11.5%
29
 
3.9%
25
 
3.4%
19
 
2.6%
18
 
2.4%
18
 
2.4%
17
 
2.3%
16
 
2.2%
16
 
2.2%
15
 
2.0%
Other values (155) 480
65.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 576
78.0%
Space Separator 85
 
11.5%
Uppercase Letter 34
 
4.6%
Decimal Number 26
 
3.5%
Lowercase Letter 12
 
1.6%
Other Punctuation 1
 
0.1%
Dash Punctuation 1
 
0.1%
Close Punctuation 1
 
0.1%
Open Punctuation 1
 
0.1%
Final Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
29
 
5.0%
25
 
4.3%
19
 
3.3%
18
 
3.1%
18
 
3.1%
17
 
3.0%
16
 
2.8%
16
 
2.8%
15
 
2.6%
15
 
2.6%
Other values (127) 388
67.4%
Uppercase Letter
ValueCountFrequency (%)
A 10
29.4%
S 4
 
11.8%
W 3
 
8.8%
E 3
 
8.8%
I 3
 
8.8%
V 3
 
8.8%
K 3
 
8.8%
L 2
 
5.9%
M 2
 
5.9%
J 1
 
2.9%
Decimal Number
ValueCountFrequency (%)
2 7
26.9%
3 7
26.9%
1 6
23.1%
6 2
 
7.7%
5 2
 
7.7%
8 1
 
3.8%
7 1
 
3.8%
Lowercase Letter
ValueCountFrequency (%)
e 4
33.3%
s 2
16.7%
r 2
16.7%
d 2
16.7%
a 2
16.7%
Space Separator
ValueCountFrequency (%)
85
100.0%
Other Punctuation
ValueCountFrequency (%)
' 1
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Final Punctuation
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 576
78.0%
Common 116
 
15.7%
Latin 46
 
6.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
29
 
5.0%
25
 
4.3%
19
 
3.3%
18
 
3.1%
18
 
3.1%
17
 
3.0%
16
 
2.8%
16
 
2.8%
15
 
2.6%
15
 
2.6%
Other values (127) 388
67.4%
Latin
ValueCountFrequency (%)
A 10
21.7%
e 4
 
8.7%
S 4
 
8.7%
W 3
 
6.5%
E 3
 
6.5%
I 3
 
6.5%
V 3
 
6.5%
K 3
 
6.5%
s 2
 
4.3%
r 2
 
4.3%
Other values (5) 9
19.6%
Common
ValueCountFrequency (%)
85
73.3%
2 7
 
6.0%
3 7
 
6.0%
1 6
 
5.2%
6 2
 
1.7%
5 2
 
1.7%
' 1
 
0.9%
8 1
 
0.9%
7 1
 
0.9%
- 1
 
0.9%
Other values (3) 3
 
2.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 576
78.0%
ASCII 161
 
21.8%
Punctuation 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
85
52.8%
A 10
 
6.2%
2 7
 
4.3%
3 7
 
4.3%
1 6
 
3.7%
e 4
 
2.5%
S 4
 
2.5%
W 3
 
1.9%
E 3
 
1.9%
I 3
 
1.9%
Other values (17) 29
 
18.0%
Hangul
ValueCountFrequency (%)
29
 
5.0%
25
 
4.3%
19
 
3.3%
18
 
3.1%
18
 
3.1%
17
 
3.0%
16
 
2.8%
16
 
2.8%
15
 
2.6%
15
 
2.6%
Other values (127) 388
67.4%
Punctuation
ValueCountFrequency (%)
1
100.0%

위치
Text

UNIQUE 

Distinct59
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size604.0 B
2023-12-12T07:58:53.196692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length45
Median length34
Mean length25.033898
Min length16

Characters and Unicode

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

Unique

Unique59 ?
Unique (%)100.0%

Sample

1st row인천광역시 서구 경서동 978-2
2nd row인천광역시 서구 연희동 762-2
3rd row인천광역시 서구 연희동 797-1
4th row인천광역시 서구 경서동 974-2
5th row인천광역시 서구 경서동 980-2
ValueCountFrequency (%)
인천광역시 59
20.1%
서구 59
20.1%
검단신도시 16
 
5.5%
원당동 12
 
4.1%
경서동 11
 
3.8%
당하동 11
 
3.8%
가정동 9
 
3.1%
루원시티 6
 
2.0%
청라동 6
 
2.0%
연희동 3
 
1.0%
Other values (93) 101
34.5%
2023-12-12T07:58:53.558373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
236
 
16.0%
86
 
5.8%
71
 
4.8%
70
 
4.7%
63
 
4.3%
62
 
4.2%
1 61
 
4.1%
59
 
4.0%
59
 
4.0%
59
 
4.0%
Other values (61) 651
44.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 894
60.5%
Space Separator 236
 
16.0%
Decimal Number 224
 
15.2%
Uppercase Letter 46
 
3.1%
Dash Punctuation 39
 
2.6%
Open Punctuation 17
 
1.2%
Close Punctuation 17
 
1.2%
Other Punctuation 3
 
0.2%
Math Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
86
 
9.6%
71
 
7.9%
70
 
7.8%
63
 
7.0%
62
 
6.9%
59
 
6.6%
59
 
6.6%
59
 
6.6%
39
 
4.4%
31
 
3.5%
Other values (42) 295
33.0%
Decimal Number
ValueCountFrequency (%)
1 61
27.2%
2 31
13.8%
3 19
 
8.5%
9 19
 
8.5%
0 18
 
8.0%
4 17
 
7.6%
6 17
 
7.6%
8 15
 
6.7%
7 15
 
6.7%
5 12
 
5.4%
Uppercase Letter
ValueCountFrequency (%)
A 33
71.7%
B 11
 
23.9%
L 2
 
4.3%
Space Separator
ValueCountFrequency (%)
236
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 39
100.0%
Open Punctuation
ValueCountFrequency (%)
( 17
100.0%
Close Punctuation
ValueCountFrequency (%)
) 17
100.0%
Other Punctuation
ValueCountFrequency (%)
, 3
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 894
60.5%
Common 537
36.4%
Latin 46
 
3.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
86
 
9.6%
71
 
7.9%
70
 
7.8%
63
 
7.0%
62
 
6.9%
59
 
6.6%
59
 
6.6%
59
 
6.6%
39
 
4.4%
31
 
3.5%
Other values (42) 295
33.0%
Common
ValueCountFrequency (%)
236
43.9%
1 61
 
11.4%
- 39
 
7.3%
2 31
 
5.8%
3 19
 
3.5%
9 19
 
3.5%
0 18
 
3.4%
4 17
 
3.2%
6 17
 
3.2%
( 17
 
3.2%
Other values (6) 63
 
11.7%
Latin
ValueCountFrequency (%)
A 33
71.7%
B 11
 
23.9%
L 2
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 894
60.5%
ASCII 583
39.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
236
40.5%
1 61
 
10.5%
- 39
 
6.7%
A 33
 
5.7%
2 31
 
5.3%
3 19
 
3.3%
9 19
 
3.3%
0 18
 
3.1%
4 17
 
2.9%
6 17
 
2.9%
Other values (9) 93
 
16.0%
Hangul
ValueCountFrequency (%)
86
 
9.6%
71
 
7.9%
70
 
7.8%
63
 
7.0%
62
 
6.9%
59
 
6.6%
59
 
6.6%
59
 
6.6%
39
 
4.4%
31
 
3.5%
Other values (42) 295
33.0%
Distinct57
Distinct (%)96.6%
Missing0
Missing (%)0.0%
Memory size604.0 B
Minimum2010-09-30 00:00:00
Maximum2023-06-29 00:00:00
2023-12-12T07:58:53.681799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T07:58:53.820089image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

비고
Categorical

Distinct14
Distinct (%)23.7%
Missing0
Missing (%)0.0%
Memory size604.0 B
아파트+상가
26 
상가(주택은 수령)
17 
<NA>
 
2
주택 + 상가
 
2
아파트
 
2
Other values (9)
10 

Length

Max length16
Median length15
Mean length7.8644068
Min length2

Unique

Unique8 ?
Unique (%)13.6%

Sample

1st row아파트 + 상가
2nd row<NA>
3rd row<NA>
4th row상가(주택은 수령)
5th row상가(주택은 수령)

Common Values

ValueCountFrequency (%)
아파트+상가 26
44.1%
상가(주택은 수령) 17
28.8%
<NA> 2
 
3.4%
주택 + 상가 2
 
3.4%
아파트 2
 
3.4%
아파트+오피스텔+상가 2
 
3.4%
아파트 + 상가 1
 
1.7%
상가 1
 
1.7%
(주택+상가 모두 수령) 1
 
1.7%
오피스텔(주택은 수령) 1
 
1.7%
Other values (4) 4
 
6.8%

Length

2023-12-12T07:58:53.977911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
아파트+상가 26
29.5%
수령 21
23.9%
상가(주택은 17
19.3%
상가 4
 
4.5%
아파트 3
 
3.4%
3
 
3.4%
아파트+오피스텔+상가 2
 
2.3%
주택 2
 
2.3%
na 2
 
2.3%
주택+상가 1
 
1.1%
Other values (7) 7
 
8.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size604.0 B
Minimum2023-09-30 00:00:00
Maximum2023-09-30 00:00:00
2023-12-12T07:58:54.146512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T07:58:54.234207image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T07:58:52.040637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T07:58:54.323844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번아파트명위치사용검사일비고
연번1.0001.0001.0001.0000.559
아파트명1.0001.0001.0001.0001.000
위치1.0001.0001.0001.0001.000
사용검사일1.0001.0001.0001.0000.000
비고0.5591.0001.0000.0001.000
2023-12-12T07:58:54.420738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번비고
연번1.0000.259
비고0.2591.000

Missing values

2023-12-12T07:58:52.126680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T07:58:52.209047image/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

연번아파트명위치사용검사일비고데이터기준일자
01청라지구 A36 동문굿모닝힐인천광역시 서구 경서동 978-22012-08-14아파트 + 상가2023-09-30
12청라지구 A13 중흥S-클래스인천광역시 서구 연희동 762-22010-09-30<NA>2023-09-30
23청라지구 M2 우미린인천광역시 서구 연희동 797-12013-08-27<NA>2023-09-30
34청라지구 A35 골드클래스인천광역시 서구 경서동 974-22012-02-24상가(주택은 수령)2023-09-30
45청라지구 A38 한양수자인인천광역시 서구 경서동 980-22011-12-26상가(주택은 수령)2023-09-30
56청라지구 A7 한화꿈에그린인천광역시 서구 경서동 856-12012-03-31상가(주택은 수령)2023-09-30
67청라지구 A11 제일풍경채인천광역시 서구 경서동 837-12012-04-30상가(주택은 수령)2023-09-30
78청라지구 A33 반도유보라인천광역시 서구 경서동 975-42011-10-21상가(주택은 수령)2023-09-30
89청라지구 청라파크자이더테라스인천광역시 서구 경서동 981-2(청라지구 LA1블럭)2016-03-18주택 + 상가2023-09-30
910청라지구 청라파크자이더테라스인천광역시 서구 경서동 981-2(청라지구 LA2블럭)2016-03-18주택 + 상가2023-09-30
연번아파트명위치사용검사일비고데이터기준일자
4950검단 대성베르힐 라프리미어인천광역시 서구 당하동 검단신도시 AB3-1블록 (당하동 1316-2번지)2022-11-02아파트+상가2023-09-30
5051신영 루원지웰시티 푸르지오인천광역시 서구 가정동 루원시티 주상3블록2022-11-30아파트+상가2023-09-30
5152포레나 루원시티인천광역시 서구 가정동 루원시티 공동2블록2022-12-23아파트+상가2023-09-30
5253검단신도시 모아엘가 그랑데인천광역시 서구 원당동 검단신도시 AB11블록 (원당동 1063)2023-01-16아파트+상가2023-09-30
5354루원시티 2차 SK Leader’s VIEW인천광역시 서구 가정동 루원시티 주상 5,6블록2023-01-26아파트+상가2023-09-30
5455검단신도시 한신더휴 어반파크인천광역시 서구 당하동 검단신도시 AB5블록2023-02-28아파트+상가2023-09-30
5556루원시티 대성베르힐 2차인천광역시 서구 가정동 루원시티 주상4블록2023-04-27아파트+오피스텔+상가2023-09-30
5657루원시티린스트라우스아파트인천광역시 서구 가정동 루원시티 주상7블록2023-06-16아파트+오피스텔+상가2023-09-30
5758검암역로열파크씨티푸르지오1단지아파트인천광역시 서구 백석동 한들구역 1블록 1로트2023-06-29아파트+상가+어린이집+유치원2023-09-30
5859검암역로열파크씨티푸르지오2단지아파트인천광역시 서구 백석동 한들구역 2블록 1로트2023-06-29아파트+상가+어린이집2023-09-30