Overview

Dataset statistics

Number of variables32
Number of observations62
Missing cells723
Missing cells (%)36.4%
Duplicate rows3
Duplicate rows (%)4.8%
Total size in memory15.7 KiB
Average record size in memory259.1 B

Variable types

Text1
Categorical1
Unsupported30

Dataset

Description2020년 건축허가 통계 자료입니다.(시군별, 건축종별(신축,증축·개축·이전·대수선,용도변경), 면적, 건 수, 동 수)
Author경상남도
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15050512

Alerts

Dataset has 3 (4.8%) duplicate rowsDuplicates
건축물 허가통계표(시군별/건축종별) has 41 (66.1%) missing valuesMissing
Unnamed: 2 has 3 (4.8%) missing valuesMissing
Unnamed: 3 has 23 (37.1%) missing valuesMissing
Unnamed: 4 has 23 (37.1%) missing valuesMissing
Unnamed: 5 has 23 (37.1%) missing valuesMissing
Unnamed: 6 has 23 (37.1%) missing valuesMissing
Unnamed: 7 has 23 (37.1%) missing valuesMissing
Unnamed: 8 has 23 (37.1%) missing valuesMissing
Unnamed: 9 has 3 (4.8%) missing valuesMissing
Unnamed: 10 has 23 (37.1%) missing valuesMissing
Unnamed: 11 has 23 (37.1%) missing valuesMissing
Unnamed: 12 has 23 (37.1%) missing valuesMissing
Unnamed: 13 has 23 (37.1%) missing valuesMissing
Unnamed: 14 has 23 (37.1%) missing valuesMissing
Unnamed: 15 has 23 (37.1%) missing valuesMissing
Unnamed: 16 has 3 (4.8%) missing valuesMissing
Unnamed: 17 has 23 (37.1%) missing valuesMissing
Unnamed: 18 has 23 (37.1%) missing valuesMissing
Unnamed: 19 has 23 (37.1%) missing valuesMissing
Unnamed: 20 has 23 (37.1%) missing valuesMissing
Unnamed: 21 has 22 (35.5%) missing valuesMissing
Unnamed: 22 has 23 (37.1%) missing valuesMissing
Unnamed: 23 has 2 (3.2%) missing valuesMissing
Unnamed: 24 has 23 (37.1%) missing valuesMissing
Unnamed: 25 has 23 (37.1%) missing valuesMissing
Unnamed: 26 has 23 (37.1%) missing valuesMissing
Unnamed: 27 has 23 (37.1%) missing valuesMissing
Unnamed: 28 has 23 (37.1%) missing valuesMissing
Unnamed: 29 has 23 (37.1%) missing valuesMissing
Unnamed: 30 has 62 (100.0%) missing valuesMissing
Unnamed: 31 has 58 (93.5%) missing valuesMissing
Unnamed: 2 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 3 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 4 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 5 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 6 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 7 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 9 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 11 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 12 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 13 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 14 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 15 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 16 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 17 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 18 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 19 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 20 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 21 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 22 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 23 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 24 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 25 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 26 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 27 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 28 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 29 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 30 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 31 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-11 00:21:13.246503
Analysis finished2023-12-11 00:21:13.735545
Duration0.49 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

건축물 허가통계표(시군별/건축종별)
Text

MISSING 

Distinct21
Distinct (%)100.0%
Missing41
Missing (%)66.1%
Memory size628.0 B
2023-12-11T09:21:13.888296image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length3
Mean length3.5714286
Min length1

Characters and Unicode

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

Unique

Unique21 ?
Unique (%)100.0%

Sample

1st row(용도별/건축구분/구조별)
2nd row구 분
3rd row계
4th row창원시
5th row진주시
ValueCountFrequency (%)
용도별/건축구분/구조별 1
 
4.5%
구 1
 
4.5%
거창군 1
 
4.5%
함양군 1
 
4.5%
산청군 1
 
4.5%
하동군 1
 
4.5%
남해군 1
 
4.5%
고성군 1
 
4.5%
창녕군 1
 
4.5%
함안군 1
 
4.5%
Other values (12) 12
54.5%
2023-12-11T09:21:14.268397image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
군 10
 
13.3%
시 8
 
10.7%
4
 
5.3%
구 3
 
4.0%
창 3
 
4.0%
양 3
 
4.0%
천 2
 
2.7%
해 2
 
2.7%
산 2
 
2.7%
함 2
 
2.7%
Other values (32) 36
48.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 67
89.3%
Space Separator 4
 
5.3%
Other Punctuation 2
 
2.7%
Open Punctuation 1
 
1.3%
Close Punctuation 1
 
1.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
군 10
 
14.9%
시 8
 
11.9%
구 3
 
4.5%
창 3
 
4.5%
양 3
 
4.5%
천 2
 
3.0%
해 2
 
3.0%
산 2
 
3.0%
함 2
 
3.0%
거 2
 
3.0%
Other values (28) 30
44.8%
Space Separator
ValueCountFrequency (%)
4
100.0%
Other Punctuation
ValueCountFrequency (%)
/ 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 67
89.3%
Common 8
 
10.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
군 10
 
14.9%
시 8
 
11.9%
구 3
 
4.5%
창 3
 
4.5%
양 3
 
4.5%
천 2
 
3.0%
해 2
 
3.0%
산 2
 
3.0%
함 2
 
3.0%
거 2
 
3.0%
Other values (28) 30
44.8%
Common
ValueCountFrequency (%)
4
50.0%
/ 2
25.0%
( 1
 
12.5%
) 1
 
12.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 67
89.3%
ASCII 8
 
10.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
군 10
 
14.9%
시 8
 
11.9%
구 3
 
4.5%
창 3
 
4.5%
양 3
 
4.5%
천 2
 
3.0%
해 2
 
3.0%
산 2
 
3.0%
함 2
 
3.0%
거 2
 
3.0%
Other values (28) 30
44.8%
ASCII
ValueCountFrequency (%)
4
50.0%
/ 2
25.0%
( 1
 
12.5%
) 1
 
12.5%

Unnamed: 1
Categorical

Distinct4
Distinct (%)6.5%
Missing0
Missing (%)0.0%
Memory size628.0 B
건수
19 
동수
19 
연면적
19 
<NA>
5 

Length

Max length4
Median length2
Mean length2.4677419
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
건수 19
30.6%
동수 19
30.6%
연면적 19
30.6%
<NA> 5
 
8.1%

Length

2023-12-11T09:21:14.491205image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T09:21:14.677879image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
건수 19
30.6%
동수 19
30.6%
연면적 19
30.6%
na 5
 
8.1%

Unnamed: 2
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.8%
Memory size628.0 B

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.8%
Memory size628.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.8%
Memory size628.0 B

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 19
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 20
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 21
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing22
Missing (%)35.5%
Memory size628.0 B

Unnamed: 22
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 23
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)3.2%
Memory size628.0 B

Unnamed: 24
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 25
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 26
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 27
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 28
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 29
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)37.1%
Memory size628.0 B

Unnamed: 30
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing62
Missing (%)100.0%
Memory size690.0 B

Unnamed: 31
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing58
Missing (%)93.5%
Memory size628.0 B

Sample

건축물 허가통계표(시군별/건축종별)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22Unnamed: 23Unnamed: 24Unnamed: 25Unnamed: 26Unnamed: 27Unnamed: 28Unnamed: 29Unnamed: 30Unnamed: 31
0<NA><NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN[경상남도 2014년 09월]NaNNaNNaNNaNNaNNaNNaNNaN<NA>NaN
1<NA><NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<NA>NaN
2(용도별/건축구분/구조별)<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN(단위 : 건,동,제곱미터)NaNNaNNaNNaNNaNNaN<NA>NaN
3구 분<NA>합 계NaNNaNNaNNaNNaNNaN신 축NaNNaNNaNNaNNaNNaN증축/개축/이전/대수선NaNNaNNaNNaNNaNNaN용도변경NaNNaNNaNNaNNaNNaN<NA>NaN
4<NA><NA>계철근콘\n크리트철골조적철골\n철근나무기타계철근콘\n크리트철골조적철골\n철근나무기타계철근콘\n크리트철골조적철골\n철근나무기타계철근콘\n크리트철골조적철골\n철근나무기타<NA>검증
5계건수1238NaNNaNNaNNaNNaNNaN901NaNNaNNaNNaNNaNNaN263NaNNaNNaNNaNNaNNaN74NaNNaNNaNNaNNaNNaN<NA>0
6<NA>동수1668575878116591311864515936527234038027332018079441219310<NA>0
7<NA>연면적766353504358228677107481500973282336762154791851677198047144186613233716381107758613129106570185001409623451410591580<NA>0
8창원시건수202NaNNaNNaNNaNNaNNaN142NaNNaNNaNNaNNaNNaN38NaNNaNNaNNaNNaNNaN22NaNNaNNaNNaNNaNNaN<NA>NaN
9<NA>동수2511239230060186976419060439268000221723000<NA>NaN
건축물 허가통계표(시군별/건축종별)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22Unnamed: 23Unnamed: 24Unnamed: 25Unnamed: 26Unnamed: 27Unnamed: 28Unnamed: 29Unnamed: 30Unnamed: 31
52<NA>연면적623220122294482014440554719521884453012580470602532901280215015700580<NA>NaN
53함양군건수35NaNNaNNaNNaNNaNNaN27NaNNaNNaNNaNNaNNaN7NaNNaNNaNNaNNaNNaN1NaNNaNNaNNaNNaNNaN<NA>NaN
54<NA>동수525375041413304031102700101001000<NA>NaN
55<NA>연면적10798198580844120225928075147659673150225922645509211719000780078000<NA>NaN
56거창군건수44NaNNaNNaNNaNNaNNaN34NaNNaNNaNNaNNaNNaN9NaNNaNNaNNaNNaNNaN1NaNNaNNaNNaNNaNNaN<NA>NaN
57<NA>동수50142550603813164050111810101010000<NA>NaN
58<NA>연면적1223386782530429059601045977181779402056001690960667270360840840000<NA>NaN
59합천군건수39NaNNaNNaNNaNNaNNaN33NaNNaNNaNNaNNaNNaN5NaNNaNNaNNaNNaNNaN1NaNNaNNaNNaNNaNNaN<NA>NaN
60<NA>동수6394740304453240301831500001100000<NA>NaN
61<NA>연면적756214785506310026804958982339831002680210802108000049649600000<NA>NaN

Duplicate rows

Most frequently occurring

건축물 허가통계표(시군별/건축종별)Unnamed: 1# duplicates
0<NA>동수19
1<NA>연면적19
2<NA><NA>3