Overview

Dataset statistics

Number of variables6
Number of observations76
Missing cells52
Missing cells (%)11.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.8 KiB
Average record size in memory50.7 B

Variable types

Numeric1
Categorical1
Text1
DateTime3

Dataset

Description광주광역시 북구 내 건설(건축)허가현황을 제공합니다. 2022년 7월 1일 이후의 자료를 제공하며, 현재 미사용 승인 현장, 사용승인예정일은 착공 당시 제출 날짜로 변동 가능합니다.
URLhttps://www.data.go.kr/data/15115816/fileData.do

Alerts

착공처리일 has 26 (34.2%) missing valuesMissing
준공예정일(사용승인예정일) has 26 (34.2%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-11 23:13:12.363777
Analysis finished2023-12-11 23:13:12.984519
Duration0.62 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct76
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean38.5
Minimum1
Maximum76
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size816.0 B
2023-12-12T08:13:13.047299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.75
Q119.75
median38.5
Q357.25
95-th percentile72.25
Maximum76
Range75
Interquartile range (IQR)37.5

Descriptive statistics

Standard deviation22.083176
Coefficient of variation (CV)0.57358899
Kurtosis-1.2
Mean38.5
Median Absolute Deviation (MAD)19
Skewness0
Sum2926
Variance487.66667
MonotonicityStrictly increasing
2023-12-12T08:13:13.179137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.3%
50 1
 
1.3%
57 1
 
1.3%
56 1
 
1.3%
55 1
 
1.3%
54 1
 
1.3%
53 1
 
1.3%
52 1
 
1.3%
51 1
 
1.3%
49 1
 
1.3%
Other values (66) 66
86.8%
ValueCountFrequency (%)
1 1
1.3%
2 1
1.3%
3 1
1.3%
4 1
1.3%
5 1
1.3%
6 1
1.3%
7 1
1.3%
8 1
1.3%
9 1
1.3%
10 1
1.3%
ValueCountFrequency (%)
76 1
1.3%
75 1
1.3%
74 1
1.3%
73 1
1.3%
72 1
1.3%
71 1
1.3%
70 1
1.3%
69 1
1.3%
68 1
1.3%
67 1
1.3%

주용도(건설내용)
Categorical

Distinct11
Distinct (%)14.5%
Missing0
Missing (%)0.0%
Memory size740.0 B
제2종근린생활시설
22 
단독주택
15 
제1종근린생활시설
14 
공동주택
7 
창고시설
4 
Other values (6)
14 

Length

Max length9
Median length8
Mean length6.4342105
Min length2

Unique

Unique1 ?
Unique (%)1.3%

Sample

1st row제1종근린생활시설
2nd row제2종근린생활시설
3rd row제1종근린생활시설
4th row창고시설
5th row제2종근린생활시설

Common Values

ValueCountFrequency (%)
제2종근린생활시설 22
28.9%
단독주택 15
19.7%
제1종근린생활시설 14
18.4%
공동주택 7
 
9.2%
창고시설 4
 
5.3%
공장 4
 
5.3%
노유자시설 3
 
3.9%
자동차관련시설 2
 
2.6%
운동시설 2
 
2.6%
업무시설 2
 
2.6%

Length

2023-12-12T08:13:13.345845image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
제2종근린생활시설 22
28.9%
단독주택 15
19.7%
제1종근린생활시설 14
18.4%
공동주택 7
 
9.2%
창고시설 4
 
5.3%
공장 4
 
5.3%
노유자시설 3
 
3.9%
자동차관련시설 2
 
2.6%
운동시설 2
 
2.6%
업무시설 2
 
2.6%

대지위치
Text

Distinct75
Distinct (%)98.7%
Missing0
Missing (%)0.0%
Memory size740.0 B
2023-12-12T08:13:13.626520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length24
Mean length19.342105
Min length15

Characters and Unicode

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

Unique

Unique74 ?
Unique (%)97.4%

Sample

1st row광주광역시 북구 두암동 166-1 외1필지
2nd row광주광역시 북구 용봉동 1400-3
3rd row광주광역시 북구 효령동 475 외2필지
4th row광주광역시 북구 운암동 1286-1
5th row광주광역시 북구 삼각동 581-18
ValueCountFrequency (%)
광주광역시 76
23.1%
북구 76
23.1%
외1필지 14
 
4.3%
양산동 10
 
3.0%
용봉동 7
 
2.1%
중흥동 6
 
1.8%
외2필지 5
 
1.5%
오치동 5
 
1.5%
외3필지 4
 
1.2%
본촌동 4
 
1.2%
Other values (100) 122
37.1%
2023-12-12T08:13:13.990676image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
253
17.2%
광 152
 
10.3%
1 80
 
5.4%
동 78
 
5.3%
역 76
 
5.2%
시 76
 
5.2%
북 76
 
5.2%
구 76
 
5.2%
주 76
 
5.2%
- 55
 
3.7%
Other values (53) 472
32.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 832
56.6%
Decimal Number 330
 
22.4%
Space Separator 253
 
17.2%
Dash Punctuation 55
 
3.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 152
18.3%
동 78
9.4%
역 76
9.1%
시 76
9.1%
북 76
9.1%
구 76
9.1%
주 76
9.1%
지 28
 
3.4%
외 25
 
3.0%
필 25
 
3.0%
Other values (41) 144
17.3%
Decimal Number
ValueCountFrequency (%)
1 80
24.2%
7 32
 
9.7%
2 31
 
9.4%
5 31
 
9.4%
6 30
 
9.1%
3 29
 
8.8%
4 28
 
8.5%
0 28
 
8.5%
8 23
 
7.0%
9 18
 
5.5%
Space Separator
ValueCountFrequency (%)
253
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 55
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 832
56.6%
Common 638
43.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 152
18.3%
동 78
9.4%
역 76
9.1%
시 76
9.1%
북 76
9.1%
구 76
9.1%
주 76
9.1%
지 28
 
3.4%
외 25
 
3.0%
필 25
 
3.0%
Other values (41) 144
17.3%
Common
ValueCountFrequency (%)
253
39.7%
1 80
 
12.5%
- 55
 
8.6%
7 32
 
5.0%
2 31
 
4.9%
5 31
 
4.9%
6 30
 
4.7%
3 29
 
4.5%
4 28
 
4.4%
0 28
 
4.4%
Other values (2) 41
 
6.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 832
56.6%
ASCII 638
43.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
253
39.7%
1 80
 
12.5%
- 55
 
8.6%
7 32
 
5.0%
2 31
 
4.9%
5 31
 
4.9%
6 30
 
4.7%
3 29
 
4.5%
4 28
 
4.4%
0 28
 
4.4%
Other values (2) 41
 
6.4%
Hangul
ValueCountFrequency (%)
광 152
18.3%
동 78
9.4%
역 76
9.1%
시 76
9.1%
북 76
9.1%
구 76
9.1%
주 76
9.1%
지 28
 
3.4%
외 25
 
3.0%
필 25
 
3.0%
Other values (41) 144
17.3%

허가일
Date

Distinct65
Distinct (%)85.5%
Missing0
Missing (%)0.0%
Memory size740.0 B
Minimum2022-07-05 00:00:00
Maximum2023-06-28 00:00:00
2023-12-12T08:13:14.109750image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:13:14.223194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

착공처리일
Date

MISSING 

Distinct44
Distinct (%)88.0%
Missing26
Missing (%)34.2%
Memory size740.0 B
Minimum2022-09-15 00:00:00
Maximum2023-06-26 00:00:00
2023-12-12T08:13:14.343343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:13:14.466268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=44)

준공예정일(사용승인예정일)
Date

MISSING 

Distinct38
Distinct (%)76.0%
Missing26
Missing (%)34.2%
Memory size740.0 B
Minimum2022-12-30 00:00:00
Maximum2024-08-21 00:00:00
2023-12-12T08:13:14.578339image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:13:14.694256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=38)

Interactions

2023-12-12T08:13:12.650964image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T08:13:14.789083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번주용도(건설내용)대지위치허가일착공처리일준공예정일(사용승인예정일)
연번1.0000.0000.9460.9840.8180.632
주용도(건설내용)0.0001.0001.0000.8960.9350.749
대지위치0.9461.0001.0001.0001.0001.000
허가일0.9840.8961.0001.0000.8590.893
착공처리일0.8180.9351.0000.8591.0000.871
준공예정일(사용승인예정일)0.6320.7491.0000.8930.8711.000
2023-12-12T08:13:14.885465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번주용도(건설내용)
연번1.0000.000
주용도(건설내용)0.0001.000

Missing values

2023-12-12T08:13:12.768192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T08:13:12.862229image/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.
2023-12-12T08:13:12.940895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

연번주용도(건설내용)대지위치허가일착공처리일준공예정일(사용승인예정일)
01제1종근린생활시설광주광역시 북구 두암동 166-1 외1필지2023-06-28<NA><NA>
12제2종근린생활시설광주광역시 북구 용봉동 1400-32023-06-26<NA><NA>
23제1종근린생활시설광주광역시 북구 효령동 475 외2필지2023-06-16<NA><NA>
34창고시설광주광역시 북구 운암동 1286-12023-06-082023-06-262023-12-30
45제2종근린생활시설광주광역시 북구 삼각동 581-182023-06-012023-06-192023-08-31
56공장광주광역시 북구 연제동 1054-42023-05-262023-06-202023-09-30
67제2종근린생활시설광주광역시 북구 지야동 807-62023-05-262023-06-072023-12-05
78제2종근린생활시설광주광역시 북구 용두동 1006-6 외1필지2023-05-25<NA><NA>
89자동차관련시설광주광역시 북구 양산동 1008 외1필지2023-05-122023-06-082023-08-29
910제2종근린생활시설광주광역시 북구 임동 37-32023-05-09<NA><NA>
연번주용도(건설내용)대지위치허가일착공처리일준공예정일(사용승인예정일)
6667제2종근린생활시설광주광역시 북구 용두동 5712022-08-192022-12-022023-03-31
6768제1종근린생활시설광주광역시 북구 양산동 572022-08-09<NA><NA>
6869단독주택광주광역시 북구 양산동 57 외2필지2022-08-03<NA><NA>
6970제2종근린생활시설광주광역시 북구 용전동 1228-12022-08-032023-03-172023-06-20
7071단독주택광주광역시 북구 용봉동 1218-42022-07-292023-06-162023-12-14
7172제1종근린생활시설광주광역시 북구 우산동 556-6 외6필지2022-07-292022-09-152023-05-01
7273운동시설광주광역시 북구 연제동 115-2 외2필지2022-07-292022-12-062023-05-30
7374단독주택광주광역시 북구 양산동 57-282022-07-202022-09-282022-12-30
7475제2종근린생활시설광주광역시 북구 문흥동 739-42022-07-082022-10-212023-01-05
7576단독주택광주광역시 북구 우산동 231-362022-07-05<NA><NA>