Overview

Dataset statistics

Number of variables8
Number of observations74
Missing cells1
Missing cells (%)0.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.9 KiB
Average record size in memory67.8 B

Variable types

Numeric2
Text1
DateTime3
Categorical2

Dataset

Description부평구 월별 공동주택 이행보증보험증권 현황입니다.(위치, 건축주, 보증기간 등)ex) 1,인천광역시 부평구 부평동 408-4,이보현, 황정순,2012-11-30,93,2012-11-30,2022-11-29,대한주택보증(서울중앙지점),02-3771-6464
Author인천광역시 부평구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=3047317&srcSe=7661IVAWM27C61E190

Alerts

보증가입기관 is highly overall correlated with 전화번호High correlation
전화번호 is highly overall correlated with 보증가입기관High correlation
세대수 has 1 (1.4%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2024-01-28 06:30:40.790901
Analysis finished2024-01-28 06:30:41.550027
Duration0.76 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct74
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.5
Minimum1
Maximum74
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size798.0 B
2024-01-28T15:30:41.600454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.65
Q119.25
median37.5
Q355.75
95-th percentile70.35
Maximum74
Range73
Interquartile range (IQR)36.5

Descriptive statistics

Standard deviation21.505813
Coefficient of variation (CV)0.57348835
Kurtosis-1.2
Mean37.5
Median Absolute Deviation (MAD)18.5
Skewness0
Sum2775
Variance462.5
MonotonicityStrictly increasing
2024-01-28T15:30:41.713534image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.4%
57 1
 
1.4%
55 1
 
1.4%
54 1
 
1.4%
53 1
 
1.4%
52 1
 
1.4%
51 1
 
1.4%
50 1
 
1.4%
49 1
 
1.4%
48 1
 
1.4%
Other values (64) 64
86.5%
ValueCountFrequency (%)
1 1
1.4%
2 1
1.4%
3 1
1.4%
4 1
1.4%
5 1
1.4%
6 1
1.4%
7 1
1.4%
8 1
1.4%
9 1
1.4%
10 1
1.4%
ValueCountFrequency (%)
74 1
1.4%
73 1
1.4%
72 1
1.4%
71 1
1.4%
70 1
1.4%
69 1
1.4%
68 1
1.4%
67 1
1.4%
66 1
1.4%
65 1
1.4%

위치
Text

Distinct72
Distinct (%)97.3%
Missing0
Missing (%)0.0%
Memory size724.0 B
2024-01-28T15:30:41.934534image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length22
Mean length18.351351
Min length14

Characters and Unicode

Total characters1358
Distinct characters36
Distinct categories7 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique71 ?
Unique (%)95.9%

Sample

1st row인천광역시 부평구 부개동 296
2nd row인천광역시 부평구 십정동 181-4
3rd row인천광역시 부평구 부평동 798-16
4th row인천광역시 부평구 갈산동 29-14 외1필지
5th row인천광역시 부평구 십정동 352-5
ValueCountFrequency (%)
인천광역시 74
26.8%
부평동 26
 
9.4%
십정동 13
 
4.7%
외 13
 
4.7%
부개동 12
 
4.3%
외1필지 12
 
4.3%
산곡동 8
 
2.9%
일신동 7
 
2.5%
부평구 7
 
2.5%
1 5
 
1.8%
Other values (85) 99
35.9%
2024-01-28T15:30:42.253801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
202
14.9%
1 113
 
8.3%
천 78
 
5.7%
동 76
 
5.6%
인 74
 
5.4%
시 74
 
5.4%
역 74
 
5.4%
광 74
 
5.4%
- 72
 
5.3%
2 50
 
3.7%
Other values (26) 471
34.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 705
51.9%
Decimal Number 374
27.5%
Space Separator 202
 
14.9%
Dash Punctuation 72
 
5.3%
Open Punctuation 2
 
0.1%
Close Punctuation 2
 
0.1%
Modifier Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
천 78
11.1%
동 76
10.8%
인 74
10.5%
시 74
10.5%
역 74
10.5%
광 74
10.5%
부 45
6.4%
외 40
 
5.7%
평 33
 
4.7%
필 25
 
3.5%
Other values (11) 112
15.9%
Decimal Number
ValueCountFrequency (%)
1 113
30.2%
2 50
13.4%
4 33
 
8.8%
3 32
 
8.6%
6 31
 
8.3%
5 28
 
7.5%
7 24
 
6.4%
8 22
 
5.9%
0 21
 
5.6%
9 20
 
5.3%
Space Separator
ValueCountFrequency (%)
202
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 72
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 705
51.9%
Common 653
48.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
천 78
11.1%
동 76
10.8%
인 74
10.5%
시 74
10.5%
역 74
10.5%
광 74
10.5%
부 45
6.4%
외 40
 
5.7%
평 33
 
4.7%
필 25
 
3.5%
Other values (11) 112
15.9%
Common
ValueCountFrequency (%)
202
30.9%
1 113
17.3%
- 72
 
11.0%
2 50
 
7.7%
4 33
 
5.1%
3 32
 
4.9%
6 31
 
4.7%
5 28
 
4.3%
7 24
 
3.7%
8 22
 
3.4%
Other values (5) 46
 
7.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 705
51.9%
ASCII 653
48.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
202
30.9%
1 113
17.3%
- 72
 
11.0%
2 50
 
7.7%
4 33
 
5.1%
3 32
 
4.9%
6 31
 
4.7%
5 28
 
4.3%
7 24
 
3.7%
8 22
 
3.4%
Other values (5) 46
 
7.0%
Hangul
ValueCountFrequency (%)
천 78
11.1%
동 76
10.8%
인 74
10.5%
시 74
10.5%
역 74
10.5%
광 74
10.5%
부 45
6.4%
외 40
 
5.7%
평 33
 
4.7%
필 25
 
3.5%
Other values (11) 112
15.9%

승인일자
Date

Distinct61
Distinct (%)82.4%
Missing0
Missing (%)0.0%
Memory size724.0 B
Minimum2019-09-06 00:00:00
Maximum2022-07-25 00:00:00
2024-01-28T15:30:42.357727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T15:30:42.458951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

세대수
Real number (ℝ)

MISSING 

Distinct28
Distinct (%)38.4%
Missing1
Missing (%)1.4%
Infinite0
Infinite (%)0.0%
Mean21.068493
Minimum4
Maximum219
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size798.0 B
2024-01-28T15:30:42.551814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4
5-th percentile6
Q18
median10
Q319
95-th percentile64.6
Maximum219
Range215
Interquartile range (IQR)11

Descriptive statistics

Standard deviation33.417115
Coefficient of variation (CV)1.5861179
Kurtosis22.618447
Mean21.068493
Median Absolute Deviation (MAD)2
Skewness4.5270733
Sum1538
Variance1116.7036
MonotonicityNot monotonic
2024-01-28T15:30:42.634558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=28)
ValueCountFrequency (%)
8 20
27.0%
10 8
 
10.8%
11 5
 
6.8%
12 4
 
5.4%
16 3
 
4.1%
6 3
 
4.1%
23 3
 
4.1%
9 3
 
4.1%
82 2
 
2.7%
28 2
 
2.7%
Other values (18) 20
27.0%
ValueCountFrequency (%)
4 1
 
1.4%
5 1
 
1.4%
6 3
 
4.1%
7 1
 
1.4%
8 20
27.0%
9 3
 
4.1%
10 8
 
10.8%
11 5
 
6.8%
12 4
 
5.4%
13 1
 
1.4%
ValueCountFrequency (%)
219 1
1.4%
175 1
1.4%
82 2
2.7%
53 1
1.4%
48 1
1.4%
40 2
2.7%
34 1
1.4%
28 2
2.7%
25 1
1.4%
24 1
1.4%

보증기간 시작일
Date

Distinct64
Distinct (%)86.5%
Missing0
Missing (%)0.0%
Memory size724.0 B
Minimum2019-08-30 00:00:00
Maximum2022-08-05 00:00:00
2024-01-28T15:30:42.724347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T15:30:42.822695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

보증기간 종료일
Date

Distinct65
Distinct (%)87.8%
Missing0
Missing (%)0.0%
Memory size724.0 B
Minimum2020-08-06 00:00:00
Maximum2032-08-04 00:00:00
2024-01-28T15:30:42.915294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T15:30:43.223523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

보증가입기관
Categorical

HIGH CORRELATION 

Distinct24
Distinct (%)32.4%
Missing0
Missing (%)0.0%
Memory size724.0 B
서울보증보험주식회사(부평지점)
13 
서울보증(부평지점)
10 
서울보증보험주식회사(인천지점)
10 
서울보증(인천지점)
8 
건설공제조합(인천지점)
4 
Other values (19)
29 

Length

Max length19
Median length18
Mean length14.027027
Min length10

Unique

Unique13 ?
Unique (%)17.6%

Sample

1st row서울보증(인천지점)
2nd row서울보증(부평지점)
3rd row건설공제조합(삼성지점)
4th row서울보증(부평지점)
5th row서울보증(부평지점)

Common Values

ValueCountFrequency (%)
서울보증보험주식회사(부평지점) 13
17.6%
서울보증(부평지점) 10
13.5%
서울보증보험주식회사(인천지점) 10
13.5%
서울보증(인천지점) 8
10.8%
건설공제조합(인천지점) 4
 
5.4%
서울보증(부평지점) 4
 
5.4%
주택도시보증공사(서울동부지사) 3
 
4.1%
건설공제조합(인천지점) 3
 
4.1%
서울보증(송도지점) 2
 
2.7%
서울보증보험주식회사(부천지점) 2
 
2.7%
Other values (14) 15
20.3%

Length

2024-01-28T15:30:43.329896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
서울보증(부평지점 14
18.9%
서울보증보험주식회사(부평지점 13
17.6%
서울보증보험주식회사(인천지점 10
13.5%
서울보증(인천지점 9
12.2%
건설공제조합(인천지점 7
9.5%
주택도시보증공사(서울동부지사 3
 
4.1%
서울보증(송도지점 3
 
4.1%
서울보증보험주식회사(부천지점 2
 
2.7%
서울보증보험주식회사(송도지점 2
 
2.7%
건설공제조합(부천지점 2
 
2.7%
Other values (9) 9
12.2%

전화번호
Categorical

HIGH CORRELATION 

Distinct15
Distinct (%)20.3%
Missing0
Missing (%)0.0%
Memory size724.0 B
032-521-0021
27 
032-428-0021
20 
032-859-0021
6 
032-439-7197
4 
032-439-7198
3 
Other values (10)
14 

Length

Max length12
Median length12
Mean length11.945946
Min length11

Unique

Unique7 ?
Unique (%)9.5%

Sample

1st row032-428-0021
2nd row032-428-0021
3rd row02-3449-2160
4th row032-521-0021
5th row032-521-0021

Common Values

ValueCountFrequency (%)
032-521-0021 27
36.5%
032-428-0021 20
27.0%
032-859-0021 6
 
8.1%
032-439-7197 4
 
5.4%
032-439-7198 3
 
4.1%
02-2050-7838 3
 
4.1%
032-324-0384 2
 
2.7%
032-651-0021 2
 
2.7%
02-3449-2160 1
 
1.4%
02-846-0021 1
 
1.4%
Other values (5) 5
 
6.8%

Length

2024-01-28T15:30:43.416069image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
032-521-0021 27
36.5%
032-428-0021 20
27.0%
032-859-0021 6
 
8.1%
032-439-7197 4
 
5.4%
032-439-7198 3
 
4.1%
02-2050-7838 3
 
4.1%
032-324-0384 2
 
2.7%
032-651-0021 2
 
2.7%
02-3449-2160 1
 
1.4%
02-846-0021 1
 
1.4%
Other values (5) 5
 
6.8%

Interactions

2024-01-28T15:30:41.285849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T15:30:41.163477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T15:30:41.344488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T15:30:41.227845image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-28T15:30:43.478768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번위치승인일자세대수보증기간 시작일보증기간 종료일보증가입기관전화번호
연번1.0001.0000.9790.2020.9660.9780.8120.478
위치1.0001.0001.0000.0001.0001.0001.0001.000
승인일자0.9791.0001.0000.0000.9991.0000.9930.992
세대수0.2020.0000.0001.0000.0000.0000.6460.530
보증기간 시작일0.9661.0000.9990.0001.0001.0000.9940.993
보증기간 종료일0.9781.0001.0000.0001.0001.0000.9920.993
보증가입기관0.8121.0000.9930.6460.9940.9921.0001.000
전화번호0.4781.0000.9920.5300.9930.9931.0001.000
2024-01-28T15:30:43.562709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
보증가입기관전화번호
보증가입기관1.0000.917
전화번호0.9171.000
2024-01-28T15:30:43.623899image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번세대수보증가입기관전화번호
연번1.000-0.0450.4050.184
세대수-0.0451.0000.2640.255
보증가입기관0.4050.2641.0000.917
전화번호0.1840.2550.9171.000

Missing values

2024-01-28T15:30:41.423609image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-28T15:30:41.515114image/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인천광역시 부평구 부개동 2962019-09-06282019-09-182029-09-17서울보증(인천지점)032-428-0021
12인천광역시 부평구 십정동 181-42019-09-1182019-08-302029-08-29서울보증(부평지점)032-428-0021
23인천광역시 부평구 부평동 798-162019-10-07252019-10-072024-10-06건설공제조합(삼성지점)02-3449-2160
34인천광역시 부평구 갈산동 29-14 외1필지2019-10-16212019-10-162029-10-15서울보증(부평지점)032-521-0021
45인천광역시 부평구 십정동 352-52019-12-17122019-12-212029-12-20서울보증(부평지점)032-521-0021
56인천광역시 부평구 일신동 126-442019-12-1782019-12-212029-12-20서울보증(부평지점)032-521-0021
67인천광역시 부평구 산곡동 369-227 외1필지2019-12-31402019-12-302029-12-29서울보증(송도지점)032-859-0021
78인천광역시 십정동 181-112 외 22020-02-0772020-02-102030-02-09서울보증(구로디지털점)02-846-0021
89인천광역시 십정동 581-32020-02-20192020-02-212030-02-20서울보증(인천지점)032-428-0021
910인천광역시 십정동 181-122 외 12020-03-13102020-03-102030-03-09서울보증(인천지점)032-428-0021
연번위치승인일자세대수보증기간 시작일보증기간 종료일보증가입기관전화번호
6465인천광역시 부평동 747-13 외2필지2022-01-0582022-01-062032-01-05서울보증보험주식회사(부천지점)032-651-0021
6566인천광역시 일신동 55-82022-01-11102022-01-122032-01-11서울보증보험주식회사(부천지점)032-651-0021
6667인천광역시 부평동 431-14 외4필지2022-02-11532022-02-112032-02-10서울보증보험주식회사(인천지점)032-428-0021
6768인천광역시 부평동 903-32022-02-1682022-02-082032-02-07건설공제조합(안양지점)031-388-0103
6869인천광역시 부평동 671-32 외 2필지2022-03-3082022-03-292032-03-28서울보증보험주식회사(인천지점)032-428-0021
6970인천광역시 청천동 17-122022-05-2582022-05-192032-05-18서울보증보험주식회사(부평지점)032-521-0021
7071인천광역시 부평동 623-182022-06-17112022-05-272032-05-26건설공제조합(인천지점)032-439-7197
7172인천광역시 일신동 122-1 외1필지2022-07-20122022-08-052032-08-04서울보증보험주식회사(부평지점)032-521-0021
7273인천광역시 일신동 122-38 외1필지2022-07-2082022-08-052032-08-04서울보증보험주식회사(부평지점)032-521-0021
7374인천광역시 부개동 101-1 외1필지2022-07-25112022-07-272032-07-26서울보증보험주식회사(부평지점)032-521-0021