Overview

Dataset statistics

Number of variables10
Number of observations5525
Missing cells11050
Missing cells (%)20.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory464.1 KiB
Average record size in memory86.0 B

Variable types

Numeric4
DateTime3
Categorical1
Unsupported2

Dataset

Description대구도시개발공사 전세임대 고객 우편발송 내역 입니다. 메타데이터기반 공공데이터 개방자료이기 때문에 가공되지 않은 원본 테이블의 데이터가 등록되었습니다.
URLhttps://www.data.go.kr/data/15120619/fileData.do

Alerts

일련번호 is highly overall correlated with 발송내역High correlation
등록자번호 is highly overall correlated with 수정자번호High correlation
수정자번호 is highly overall correlated with 등록자번호High correlation
발송내역 is highly overall correlated with 일련번호High correlation
반송일자 has 5525 (100.0%) missing valuesMissing
반송사유 has 5525 (100.0%) missing valuesMissing
일련번호 has unique valuesUnique
반송일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
반송사유 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 14:46:09.432469
Analysis finished2023-12-12 14:46:12.565513
Duration3.13 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

신청자번호
Real number (ℝ)

Distinct2126
Distinct (%)38.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.5204384 × 108
Minimum1.2017 × 108
Maximum8.2021001 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size48.7 KiB
2023-12-12T23:46:12.659605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.2017 × 108
5-th percentile1.2019003 × 108
Q12.2019006 × 108
median5.2017004 × 108
Q36.202 × 108
95-th percentile7.2021002 × 108
Maximum8.2021001 × 108
Range7.0004001 × 108
Interquartile range (IQR)4.0000995 × 108

Descriptive statistics

Standard deviation2.243142 × 108
Coefficient of variation (CV)0.49622223
Kurtosis-1.3816263
Mean4.5204384 × 108
Median Absolute Deviation (MAD)2.0001998 × 108
Skewness-0.081971978
Sum2.4975422 × 1012
Variance5.0316861 × 1016
MonotonicityNot monotonic
2023-12-12T23:46:12.826347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
120210001 30
 
0.5%
220180085 10
 
0.2%
620180050 10
 
0.2%
220180083 9
 
0.2%
520180070 9
 
0.2%
620180031 9
 
0.2%
620180032 9
 
0.2%
620180033 9
 
0.2%
620180034 9
 
0.2%
620180035 9
 
0.2%
Other values (2116) 5412
98.0%
ValueCountFrequency (%)
120170001 3
0.1%
120170002 3
0.1%
120170003 3
0.1%
120170004 3
0.1%
120170005 3
0.1%
120170006 3
0.1%
120170007 3
0.1%
120170008 3
0.1%
120170009 3
0.1%
120170010 3
0.1%
ValueCountFrequency (%)
820210007 1
< 0.1%
820210006 1
< 0.1%
820210005 1
< 0.1%
820210004 1
< 0.1%
820210003 1
< 0.1%
820210002 1
< 0.1%
820210001 1
< 0.1%
820200035 1
< 0.1%
820200034 1
< 0.1%
820200033 1
< 0.1%

일련번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct5525
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2763
Minimum1
Maximum5525
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size48.7 KiB
2023-12-12T23:46:12.992487image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile277.2
Q11382
median2763
Q34144
95-th percentile5248.8
Maximum5525
Range5524
Interquartile range (IQR)2762

Descriptive statistics

Standard deviation1595.0744
Coefficient of variation (CV)0.57729803
Kurtosis-1.2
Mean2763
Median Absolute Deviation (MAD)1381
Skewness0
Sum15265575
Variance2544262.5
MonotonicityNot monotonic
2023-12-12T23:46:13.134857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
208 1
 
< 0.1%
3927 1
 
< 0.1%
3935 1
 
< 0.1%
3934 1
 
< 0.1%
3933 1
 
< 0.1%
3932 1
 
< 0.1%
3931 1
 
< 0.1%
3930 1
 
< 0.1%
3929 1
 
< 0.1%
3928 1
 
< 0.1%
Other values (5515) 5515
99.8%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
ValueCountFrequency (%)
5525 1
< 0.1%
5524 1
< 0.1%
5523 1
< 0.1%
5522 1
< 0.1%
5521 1
< 0.1%
5520 1
< 0.1%
5519 1
< 0.1%
5518 1
< 0.1%
5517 1
< 0.1%
5516 1
< 0.1%

발송일자
Date

Distinct16
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size43.3 KiB
Minimum2017-03-29 00:00:00
Maximum2023-04-21 00:00:00
2023-12-12T23:46:13.270293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:46:13.381725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)

발송내역
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size43.3 KiB
기존주택 전세임대 입주자선정 및 계약(주택물색) 안내
4119 
기존주택 전세임대 주택물색 및 계약안내
1142 
2021년도 기존주택 전세임대주택 입주대상자 선정 및 계약(주택물색) 안내
 
264

Length

Max length41
Median length29
Mean length27.919819
Min length21

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row기존주택 전세임대 주택물색 및 계약안내
2nd row기존주택 전세임대 주택물색 및 계약안내
3rd row기존주택 전세임대 주택물색 및 계약안내
4th row기존주택 전세임대 주택물색 및 계약안내
5th row기존주택 전세임대 주택물색 및 계약안내

Common Values

ValueCountFrequency (%)
기존주택 전세임대 입주자선정 및 계약(주택물색) 안내 4119
74.6%
기존주택 전세임대 주택물색 및 계약안내 1142
 
20.7%
2021년도 기존주택 전세임대주택 입주대상자 선정 및 계약(주택물색) 안내 264
 
4.8%

Length

2023-12-12T23:46:13.526751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:46:13.664978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기존주택 5525
17.0%
및 5525
17.0%
전세임대 5261
16.2%
계약(주택물색 4383
13.5%
안내 4383
13.5%
입주자선정 4119
12.7%
주택물색 1142
 
3.5%
계약안내 1142
 
3.5%
2021년도 264
 
0.8%
전세임대주택 264
 
0.8%
Other values (2) 528
 
1.6%

반송일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5525
Missing (%)100.0%
Memory size48.7 KiB

반송사유
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5525
Missing (%)100.0%
Memory size48.7 KiB

등록자번호
Real number (ℝ)

HIGH CORRELATION 

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20248209
Minimum19880040
Maximum99999992
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size48.7 KiB
2023-12-12T23:46:13.800453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19880040
5-th percentile19920113
Q119920113
median19920113
Q319940148
95-th percentile20179076
Maximum99999992
Range80119952
Interquartile range (IQR)20035

Descriptive statistics

Standard deviation4808055
Coefficient of variation (CV)0.23745582
Kurtosis271.36544
Mean20248209
Median Absolute Deviation (MAD)0
Skewness16.528741
Sum1.1187135 × 1011
Variance2.3117393 × 1013
MonotonicityNot monotonic
2023-12-12T23:46:13.954308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
19920113 4055
73.4%
20080209 589
 
10.7%
19940148 300
 
5.4%
20179076 295
 
5.3%
20050190 265
 
4.8%
99999992 20
 
0.4%
19880040 1
 
< 0.1%
ValueCountFrequency (%)
19880040 1
 
< 0.1%
19920113 4055
73.4%
19940148 300
 
5.4%
20050190 265
 
4.8%
20080209 589
 
10.7%
20179076 295
 
5.3%
99999992 20
 
0.4%
ValueCountFrequency (%)
99999992 20
 
0.4%
20179076 295
 
5.3%
20080209 589
 
10.7%
20050190 265
 
4.8%
19940148 300
 
5.4%
19920113 4055
73.4%
19880040 1
 
< 0.1%

등록일시
Date

Distinct87
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size43.3 KiB
Minimum2017-03-29 10:14:09
Maximum2023-04-21 09:23:49
2023-12-12T23:46:14.095794image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:46:14.265651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

수정자번호
Real number (ℝ)

HIGH CORRELATION 

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20248209
Minimum19880040
Maximum99999992
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size48.7 KiB
2023-12-12T23:46:14.394728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19880040
5-th percentile19920113
Q119920113
median19920113
Q319940148
95-th percentile20179076
Maximum99999992
Range80119952
Interquartile range (IQR)20035

Descriptive statistics

Standard deviation4808055
Coefficient of variation (CV)0.23745582
Kurtosis271.36544
Mean20248209
Median Absolute Deviation (MAD)0
Skewness16.528741
Sum1.1187135 × 1011
Variance2.3117393 × 1013
MonotonicityNot monotonic
2023-12-12T23:46:14.525267image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
19920113 4055
73.4%
20080209 589
 
10.7%
19940148 300
 
5.4%
20179076 295
 
5.3%
20050190 265
 
4.8%
99999992 20
 
0.4%
19880040 1
 
< 0.1%
ValueCountFrequency (%)
19880040 1
 
< 0.1%
19920113 4055
73.4%
19940148 300
 
5.4%
20050190 265
 
4.8%
20080209 589
 
10.7%
20179076 295
 
5.3%
99999992 20
 
0.4%
ValueCountFrequency (%)
99999992 20
 
0.4%
20179076 295
 
5.3%
20080209 589
 
10.7%
20050190 265
 
4.8%
19940148 300
 
5.4%
19920113 4055
73.4%
19880040 1
 
< 0.1%

수정일시
Date

Distinct87
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size43.3 KiB
Minimum2017-03-29 10:14:09
Maximum2023-04-21 09:23:49
2023-12-12T23:46:14.650745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:46:14.798288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-12T23:46:11.737668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:46:09.923236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:46:10.709780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:46:11.216592image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:46:11.865934image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:46:10.021020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:46:10.833115image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:46:11.345198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:46:12.002129image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:46:10.112178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:46:10.940561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:46:11.455735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:46:12.150567image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:46:10.225286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:46:11.072985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:46:11.581560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:46:14.900945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
신청자번호일련번호발송일자발송내역등록자번호등록일시수정자번호수정일시
신청자번호1.0000.3270.5240.3900.2090.8470.2090.847
일련번호0.3271.0000.9280.8920.2300.9960.2300.996
발송일자0.5240.9281.0000.9941.0001.0001.0001.000
발송내역0.3900.8920.9941.0000.0181.0000.0181.000
등록자번호0.2090.2301.0000.0181.0001.0000.9991.000
등록일시0.8470.9961.0001.0001.0001.0001.0001.000
수정자번호0.2090.2301.0000.0180.9991.0001.0001.000
수정일시0.8470.9961.0001.0001.0001.0001.0001.000
2023-12-12T23:46:15.017556image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
신청자번호일련번호등록자번호수정자번호발송내역
신청자번호1.0000.083-0.210-0.2100.270
일련번호0.0831.000-0.371-0.3710.837
등록자번호-0.210-0.3711.0001.0000.030
수정자번호-0.210-0.3711.0001.0000.030
발송내역0.2700.8370.0300.0301.000

Missing values

2023-12-12T23:46:12.335686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:46:12.500857image/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

신청자번호일련번호발송일자발송내역반송일자반송사유등록자번호등록일시수정자번호수정일시
06201700022082017-03-29기존주택 전세임대 주택물색 및 계약안내<NA><NA>200802092017-03-29 10:14:10200802092017-03-29 10:14:10
16201700032092017-03-29기존주택 전세임대 주택물색 및 계약안내<NA><NA>200802092017-03-29 10:14:10200802092017-03-29 10:14:10
26201700042102017-03-29기존주택 전세임대 주택물색 및 계약안내<NA><NA>200802092017-03-29 10:14:10200802092017-03-29 10:14:10
36201700052112017-03-29기존주택 전세임대 주택물색 및 계약안내<NA><NA>200802092017-03-29 10:14:10200802092017-03-29 10:14:10
46201700062122017-03-29기존주택 전세임대 주택물색 및 계약안내<NA><NA>200802092017-03-29 10:14:10200802092017-03-29 10:14:10
56201700072132017-03-29기존주택 전세임대 주택물색 및 계약안내<NA><NA>200802092017-03-29 10:14:10200802092017-03-29 10:14:10
66201700082142017-03-29기존주택 전세임대 주택물색 및 계약안내<NA><NA>200802092017-03-29 10:14:10200802092017-03-29 10:14:10
76201700092152017-03-29기존주택 전세임대 주택물색 및 계약안내<NA><NA>200802092017-03-29 10:14:10200802092017-03-29 10:14:10
86201700102162017-03-29기존주택 전세임대 주택물색 및 계약안내<NA><NA>200802092017-03-29 10:14:10200802092017-03-29 10:14:10
96201700112172017-03-29기존주택 전세임대 주택물색 및 계약안내<NA><NA>200802092017-03-29 10:14:10200802092017-03-29 10:14:10
신청자번호일련번호발송일자발송내역반송일자반송사유등록자번호등록일시수정자번호수정일시
551552021001354692021-04-122021년도 기존주택 전세임대주택 입주대상자 선정 및 계약(주택물색) 안내<NA><NA>200501902021-04-12 17:24:28200501902021-04-12 17:24:28
551652021001454702021-04-122021년도 기존주택 전세임대주택 입주대상자 선정 및 계약(주택물색) 안내<NA><NA>200501902021-04-12 17:24:28200501902021-04-12 17:24:28
551752021001554712021-04-122021년도 기존주택 전세임대주택 입주대상자 선정 및 계약(주택물색) 안내<NA><NA>200501902021-04-12 17:24:28200501902021-04-12 17:24:28
551852021001654722021-04-122021년도 기존주택 전세임대주택 입주대상자 선정 및 계약(주택물색) 안내<NA><NA>200501902021-04-12 17:24:28200501902021-04-12 17:24:28
551952021001754732021-04-122021년도 기존주택 전세임대주택 입주대상자 선정 및 계약(주택물색) 안내<NA><NA>200501902021-04-12 17:24:28200501902021-04-12 17:24:28
552052021001854742021-04-122021년도 기존주택 전세임대주택 입주대상자 선정 및 계약(주택물색) 안내<NA><NA>200501902021-04-12 17:24:28200501902021-04-12 17:24:28
552152021001954752021-04-122021년도 기존주택 전세임대주택 입주대상자 선정 및 계약(주택물색) 안내<NA><NA>200501902021-04-12 17:24:28200501902021-04-12 17:24:28
552252021002054762021-04-122021년도 기존주택 전세임대주택 입주대상자 선정 및 계약(주택물색) 안내<NA><NA>200501902021-04-12 17:24:28200501902021-04-12 17:24:28
552352021002154772021-04-122021년도 기존주택 전세임대주택 입주대상자 선정 및 계약(주택물색) 안내<NA><NA>200501902021-04-12 17:24:28200501902021-04-12 17:24:28
552432021001355242021-05-072021년도 기존주택 전세임대주택 입주대상자 선정 및 계약(주택물색) 안내<NA><NA>200501902021-05-07 09:37:35200501902021-05-07 09:37:35