Overview

Dataset statistics

Number of variables11
Number of observations1464
Missing cells2873
Missing cells (%)17.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory128.8 KiB
Average record size in memory90.1 B

Variable types

Numeric2
Categorical2
Text4
DateTime3

Dataset

Description위원회번호,위원회명,안건번호,안건명,개최일자,개최장소,세부절차,결재상태,등록일시,수정일시,안건내용
Author서울특별시
URLhttps://data.seoul.go.kr/dataList/OA-2554/S/1/datasetView.do

Alerts

결재상태 is highly overall correlated with 위원회번호 and 2 other fieldsHigh correlation
위원회명 is highly overall correlated with 위원회번호 and 1 other fieldsHigh correlation
위원회번호 is highly overall correlated with 위원회명 and 1 other fieldsHigh correlation
안건번호 is highly overall correlated with 결재상태High correlation
결재상태 is highly imbalanced (98.5%)Imbalance
세부절차 has 1445 (98.7%) missing valuesMissing
안건내용 has 1428 (97.5%) missing valuesMissing
안건번호 has unique valuesUnique
등록일시 has unique valuesUnique
수정일시 has unique valuesUnique

Reproduction

Analysis started2023-12-11 05:55:26.466456
Analysis finished2023-12-11 05:55:28.340484
Duration1.87 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

위원회번호
Real number (ℝ)

HIGH CORRELATION 

Distinct21
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20091878
Minimum20090004
Maximum20101113
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size13.0 KiB
2023-12-11T14:55:28.406608image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20090004
5-th percentile20090004
Q120090004
median20090032
Q320090038
95-th percentile20100002
Maximum20101113
Range11109
Interquartile range (IQR)34

Descriptive statistics

Standard deviation3898.8876
Coefficient of variation (CV)0.00019405292
Kurtosis0.62564393
Mean20091878
Median Absolute Deviation (MAD)28
Skewness1.6190603
Sum2.941451 × 1010
Variance15201325
MonotonicityNot monotonic
2023-12-11T14:55:28.557050image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
20090004 657
44.9%
20090033 236
 
16.1%
20100001 183
 
12.5%
20090038 97
 
6.6%
20100002 80
 
5.5%
20090039 70
 
4.8%
20090032 54
 
3.7%
20090014 24
 
1.6%
20090021 19
 
1.3%
20090036 13
 
0.9%
Other values (11) 31
 
2.1%
ValueCountFrequency (%)
20090004 657
44.9%
20090006 13
 
0.9%
20090014 24
 
1.6%
20090019 6
 
0.4%
20090021 19
 
1.3%
20090022 1
 
0.1%
20090024 1
 
0.1%
20090032 54
 
3.7%
20090033 236
 
16.1%
20090036 13
 
0.9%
ValueCountFrequency (%)
20101113 1
 
0.1%
20101074 1
 
0.1%
20101036 1
 
0.1%
20101035 2
 
0.1%
20101016 3
 
0.2%
20101008 1
 
0.1%
20100002 80
5.5%
20100001 183
12.5%
20090039 70
 
4.8%
20090038 97
6.6%

위원회명
Categorical

HIGH CORRELATION 

Distinct21
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size11.6 KiB
건축위원회
657 
지방토지수용위원회
236 
교통영향분석 개선대책심의위원회
183 
행정심판위원회
97 
미술장식심의위원회
80 
Other values (16)
211 

Length

Max length18
Median length16
Mean length8.0034153
Min length5

Unique

Unique7 ?
Unique (%)0.5%

Sample

1st row미술장식심의위원회
2nd row건축위원회
3rd row건축위원회
4th row건축위원회
5th row건축위원회

Common Values

ValueCountFrequency (%)
건축위원회 657
44.9%
지방토지수용위원회 236
 
16.1%
교통영향분석 개선대책심의위원회 183
 
12.5%
행정심판위원회 97
 
6.6%
미술장식심의위원회 80
 
5.5%
환경영향평가심의위원회 70
 
4.8%
지방세심의위원회 54
 
3.7%
교통방송시청자위원회 24
 
1.6%
수돗물평가위원회 19
 
1.3%
투자심사위원회 13
 
0.9%
Other values (11) 31
 
2.1%

Length

2023-12-11T14:55:28.719189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
건축위원회 657
39.8%
지방토지수용위원회 236
 
14.3%
교통영향분석 183
 
11.1%
개선대책심의위원회 183
 
11.1%
행정심판위원회 97
 
5.9%
미술장식심의위원회 80
 
4.9%
환경영향평가심의위원회 70
 
4.2%
지방세심의위원회 54
 
3.3%
교통방송시청자위원회 24
 
1.5%
수돗물평가위원회 19
 
1.2%
Other values (14) 46
 
2.8%

안건번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct1464
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20112298
Minimum20100002
Maximum20130261
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size13.0 KiB
2023-12-11T14:55:28.892176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20100002
5-th percentile20100080
Q120100385
median20110284
Q320120162
95-th percentile20130184
Maximum20130261
Range30259
Interquartile range (IQR)19777.5

Descriptive statistics

Standard deviation10600.184
Coefficient of variation (CV)0.00052704987
Kurtosis-1.0732378
Mean20112298
Median Absolute Deviation (MAD)9889
Skewness0.40386964
Sum2.9444404 × 1010
Variance1.123639 × 108
MonotonicityStrictly decreasing
2023-12-11T14:55:29.079755image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20130261 1
 
0.1%
20110016 1
 
0.1%
20110018 1
 
0.1%
20110019 1
 
0.1%
20110020 1
 
0.1%
20110022 1
 
0.1%
20110023 1
 
0.1%
20110024 1
 
0.1%
20110025 1
 
0.1%
20110026 1
 
0.1%
Other values (1454) 1454
99.3%
ValueCountFrequency (%)
20100002 1
0.1%
20100003 1
0.1%
20100004 1
0.1%
20100005 1
0.1%
20100006 1
0.1%
20100007 1
0.1%
20100008 1
0.1%
20100009 1
0.1%
20100010 1
0.1%
20100011 1
0.1%
ValueCountFrequency (%)
20130261 1
0.1%
20130260 1
0.1%
20130258 1
0.1%
20130257 1
0.1%
20130256 1
0.1%
20130255 1
0.1%
20130254 1
0.1%
20130253 1
0.1%
20130252 1
0.1%
20130251 1
0.1%

안건명
Text

Distinct1238
Distinct (%)84.6%
Missing0
Missing (%)0.0%
Memory size11.6 KiB
2023-12-11T14:55:29.342818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length39
Mean length19.10724
Min length6

Characters and Unicode

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

Unique

Unique1079 ?
Unique (%)73.7%

Sample

1st row2013년 제19차 미술작품심의 결과
2nd row삼호가든3차 주택재건축정비사업
3rd row수색6재정비촉진구역 주택재개발정비사업
4th row동대문구 용두동 주상복합 신축사업
5th row위례신도시 A1-10블럭 공동주택신축사업
ValueCountFrequency (%)
주택재개발정비사업 181
 
4.2%
개최 122
 
2.8%
주택재건축정비사업 109
 
2.5%
도시환경정비사업 108
 
2.5%
행정심판위원회 89
 
2.0%
결과 79
 
1.8%
재정비촉진구역 67
 
1.5%
신축사업 54
 
1.2%
신축 53
 
1.2%
미술장식심의 41
 
0.9%
Other values (1685) 3455
79.3%
2023-12-11T14:55:29.801499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2921
 
10.4%
1 1009
 
3.6%
사 996
 
3.6%
정 813
 
2.9%
업 793
 
2.8%
구 710
 
2.5%
비 648
 
2.3%
2 644
 
2.3%
주 643
 
2.3%
재 618
 
2.2%
Other values (435) 18178
65.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 20732
74.1%
Decimal Number 3263
 
11.7%
Space Separator 2921
 
10.4%
Dash Punctuation 294
 
1.1%
Close Punctuation 204
 
0.7%
Open Punctuation 203
 
0.7%
Uppercase Letter 147
 
0.5%
Other Punctuation 116
 
0.4%
Math Symbol 67
 
0.2%
Lowercase Letter 25
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 996
 
4.8%
정 813
 
3.9%
업 793
 
3.8%
구 710
 
3.4%
비 648
 
3.1%
주 643
 
3.1%
재 618
 
3.0%
택 548
 
2.6%
개 543
 
2.6%
제 540
 
2.6%
Other values (373) 13880
66.9%
Uppercase Letter
ValueCountFrequency (%)
C 25
17.0%
D 17
11.6%
L 12
 
8.2%
A 11
 
7.5%
B 11
 
7.5%
T 9
 
6.1%
E 8
 
5.4%
M 8
 
5.4%
R 7
 
4.8%
S 6
 
4.1%
Other values (13) 33
22.4%
Lowercase Letter
ValueCountFrequency (%)
t 5
20.0%
s 4
16.0%
b 4
16.0%
e 3
12.0%
v 1
 
4.0%
k 1
 
4.0%
r 1
 
4.0%
n 1
 
4.0%
x 1
 
4.0%
l 1
 
4.0%
Other values (3) 3
12.0%
Decimal Number
ValueCountFrequency (%)
1 1009
30.9%
2 644
19.7%
0 528
16.2%
3 263
 
8.1%
4 231
 
7.1%
5 145
 
4.4%
6 145
 
4.4%
7 117
 
3.6%
8 91
 
2.8%
9 90
 
2.8%
Other Punctuation
ValueCountFrequency (%)
& 37
31.9%
# 34
29.3%
; 34
29.3%
? 5
 
4.3%
. 3
 
2.6%
: 2
 
1.7%
？ 1
 
0.9%
Close Punctuation
ValueCountFrequency (%)
) 203
99.5%
」 1
 
0.5%
Open Punctuation
ValueCountFrequency (%)
( 202
99.5%
「 1
 
0.5%
Math Symbol
ValueCountFrequency (%)
~ 66
98.5%
+ 1
 
1.5%
Space Separator
ValueCountFrequency (%)
2921
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 294
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 20733
74.1%
Common 7068
 
25.3%
Latin 172
 
0.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 996
 
4.8%
정 813
 
3.9%
업 793
 
3.8%
구 710
 
3.4%
비 648
 
3.1%
주 643
 
3.1%
재 618
 
3.0%
택 548
 
2.6%
개 543
 
2.6%
제 540
 
2.6%
Other values (374) 13881
67.0%
Latin
ValueCountFrequency (%)
C 25
14.5%
D 17
 
9.9%
L 12
 
7.0%
A 11
 
6.4%
B 11
 
6.4%
T 9
 
5.2%
E 8
 
4.7%
M 8
 
4.7%
R 7
 
4.1%
S 6
 
3.5%
Other values (26) 58
33.7%
Common
ValueCountFrequency (%)
2921
41.3%
1 1009
 
14.3%
2 644
 
9.1%
0 528
 
7.5%
- 294
 
4.2%
3 263
 
3.7%
4 231
 
3.3%
) 203
 
2.9%
( 202
 
2.9%
5 145
 
2.1%
Other values (15) 628
 
8.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 20732
74.1%
ASCII 7237
 
25.9%
None 4
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2921
40.4%
1 1009
 
13.9%
2 644
 
8.9%
0 528
 
7.3%
- 294
 
4.1%
3 263
 
3.6%
4 231
 
3.2%
) 203
 
2.8%
( 202
 
2.8%
5 145
 
2.0%
Other values (48) 797
 
11.0%
Hangul
ValueCountFrequency (%)
사 996
 
4.8%
정 813
 
3.9%
업 793
 
3.8%
구 710
 
3.4%
비 648
 
3.1%
주 643
 
3.1%
재 618
 
3.0%
택 548
 
2.6%
개 543
 
2.6%
제 540
 
2.6%
Other values (373) 13880
66.9%
None
ValueCountFrequency (%)
？ 1
25.0%
」 1
25.0%
「 1
25.0%
㈜ 1
25.0%

개최일자
Date

Distinct491
Distinct (%)33.5%
Missing0
Missing (%)0.0%
Memory size11.6 KiB
Minimum2009-11-23 00:00:00
Maximum2013-12-17 00:00:00
2023-12-11T14:55:29.981994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:55:30.182076image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

개최장소
Text

Distinct216
Distinct (%)14.8%
Missing0
Missing (%)0.0%
Memory size11.6 KiB
2023-12-11T14:55:30.524502image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length22
Mean length11.640027
Min length3

Characters and Unicode

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

Unique

Unique127 ?
Unique (%)8.7%

Sample

1st row서울시청 서소문청사 1동 5층 회의실
2nd row서울시청 3층 주택정책실 공용회의실
3rd row서울시청 3층 주택정책실 공용회의실
4th row서울시청 3층 주택정책실 공용회의실
5th row서울시청 3층 주택정책실 공용회의실
ValueCountFrequency (%)
회의실 801
21.3%
서울시청 418
11.1%
주택국 345
 
9.2%
3층 279
 
7.4%
주택정책실 256
 
6.8%
공용회의실 244
 
6.5%
13층 165
 
4.4%
13층회의실 127
 
3.4%
1동 123
 
3.3%
교통정책과 114
 
3.0%
Other values (154) 894
23.7%
2023-12-11T14:55:30.972768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2304
 
13.5%
실 1693
 
9.9%
의 1402
 
8.2%
회 1398
 
8.2%
층 793
 
4.7%
1 690
 
4.0%
3 625
 
3.7%
주 615
 
3.6%
택 613
 
3.6%
청 608
 
3.6%
Other values (109) 6300
37.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 12934
75.9%
Space Separator 2304
 
13.5%
Decimal Number 1486
 
8.7%
Close Punctuation 133
 
0.8%
Open Punctuation 133
 
0.8%
Lowercase Letter 19
 
0.1%
Other Punctuation 18
 
0.1%
Uppercase Letter 13
 
0.1%
Other Number 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
실 1693
 
13.1%
의 1402
 
10.8%
회 1398
 
10.8%
층 793
 
6.1%
주 615
 
4.8%
택 613
 
4.7%
청 608
 
4.7%
서 585
 
4.5%
시 469
 
3.6%
책 451
 
3.5%
Other values (86) 4307
33.3%
Decimal Number
ValueCountFrequency (%)
1 690
46.4%
3 625
42.1%
4 78
 
5.2%
2 28
 
1.9%
0 24
 
1.6%
5 24
 
1.6%
7 13
 
0.9%
9 4
 
0.3%
Lowercase Letter
ValueCountFrequency (%)
a 7
36.8%
b 4
21.1%
s 4
21.1%
t 4
21.1%
Other Punctuation
ValueCountFrequency (%)
& 6
33.3%
# 6
33.3%
; 6
33.3%
Close Punctuation
ValueCountFrequency (%)
) 132
99.2%
] 1
 
0.8%
Open Punctuation
ValueCountFrequency (%)
( 132
99.2%
[ 1
 
0.8%
Uppercase Letter
ValueCountFrequency (%)
A 11
84.6%
B 2
 
15.4%
Space Separator
ValueCountFrequency (%)
2304
100.0%
Other Number
ValueCountFrequency (%)
② 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 12934
75.9%
Common 4075
 
23.9%
Latin 32
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
실 1693
 
13.1%
의 1402
 
10.8%
회 1398
 
10.8%
층 793
 
6.1%
주 615
 
4.8%
택 613
 
4.7%
청 608
 
4.7%
서 585
 
4.5%
시 469
 
3.6%
책 451
 
3.5%
Other values (86) 4307
33.3%
Common
ValueCountFrequency (%)
2304
56.5%
1 690
 
16.9%
3 625
 
15.3%
) 132
 
3.2%
( 132
 
3.2%
4 78
 
1.9%
2 28
 
0.7%
0 24
 
0.6%
5 24
 
0.6%
7 13
 
0.3%
Other values (7) 25
 
0.6%
Latin
ValueCountFrequency (%)
A 11
34.4%
a 7
21.9%
b 4
 
12.5%
s 4
 
12.5%
t 4
 
12.5%
B 2
 
6.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 12934
75.9%
ASCII 4106
 
24.1%
Enclosed Alphanum 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2304
56.1%
1 690
 
16.8%
3 625
 
15.2%
) 132
 
3.2%
( 132
 
3.2%
4 78
 
1.9%
2 28
 
0.7%
0 24
 
0.6%
5 24
 
0.6%
7 13
 
0.3%
Other values (12) 56
 
1.4%
Hangul
ValueCountFrequency (%)
실 1693
 
13.1%
의 1402
 
10.8%
회 1398
 
10.8%
층 793
 
6.1%
주 615
 
4.8%
택 613
 
4.7%
청 608
 
4.7%
서 585
 
4.5%
시 469
 
3.6%
책 451
 
3.5%
Other values (86) 4307
33.3%
Enclosed Alphanum
ValueCountFrequency (%)
② 1
100.0%

세부절차
Text

MISSING 

Distinct13
Distinct (%)68.4%
Missing1445
Missing (%)98.7%
Memory size11.6 KiB
2023-12-11T14:55:31.186874image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length17
Mean length10.736842
Min length5

Characters and Unicode

Total characters204
Distinct characters36
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

Unique9 ?
Unique (%)47.4%

Sample

1st row지방세심의위원회 개최
2nd row지방세 심의(이의신청 심사청구)결과
3rd row지방세심의위원회 개최결과
4th row지방세심의 결과
5th row지방세심의 결과
ValueCountFrequency (%)
결과 10
23.3%
지방세심의위원회 6
14.0%
지방세심의 4
 
9.3%
지방세 4
 
9.3%
개최결과 2
 
4.7%
정례회의 2
 
4.7%
개최 2
 
4.7%
심의 2
 
4.7%
2011년 1
 
2.3%
제4차 1
 
2.3%
Other values (9) 9
20.9%
2023-12-11T14:55:31.503974image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
24
11.8%
의 19
 
9.3%
심 17
 
8.3%
지 15
 
7.4%
방 15
 
7.4%
세 15
 
7.4%
결 14
 
6.9%
과 13
 
6.4%
회 12
 
5.9%
원 7
 
3.4%
Other values (26) 53
26.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 170
83.3%
Space Separator 24
 
11.8%
Decimal Number 8
 
3.9%
Close Punctuation 1
 
0.5%
Open Punctuation 1
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
의 19
11.2%
심 17
10.0%
지 15
8.8%
방 15
8.8%
세 15
8.8%
결 14
 
8.2%
과 13
 
7.6%
회 12
 
7.1%
원 7
 
4.1%
위 7
 
4.1%
Other values (18) 36
21.2%
Decimal Number
ValueCountFrequency (%)
1 4
50.0%
2 1
 
12.5%
0 1
 
12.5%
8 1
 
12.5%
4 1
 
12.5%
Space Separator
ValueCountFrequency (%)
24
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 170
83.3%
Common 34
 
16.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
의 19
11.2%
심 17
10.0%
지 15
8.8%
방 15
8.8%
세 15
8.8%
결 14
 
8.2%
과 13
 
7.6%
회 12
 
7.1%
원 7
 
4.1%
위 7
 
4.1%
Other values (18) 36
21.2%
Common
ValueCountFrequency (%)
24
70.6%
1 4
 
11.8%
) 1
 
2.9%
2 1
 
2.9%
0 1
 
2.9%
8 1
 
2.9%
( 1
 
2.9%
4 1
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 170
83.3%
ASCII 34
 
16.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
24
70.6%
1 4
 
11.8%
) 1
 
2.9%
2 1
 
2.9%
0 1
 
2.9%
8 1
 
2.9%
( 1
 
2.9%
4 1
 
2.9%
Hangul
ValueCountFrequency (%)
의 19
11.2%
심 17
10.0%
지 15
8.8%
방 15
8.8%
세 15
8.8%
결 14
 
8.2%
과 13
 
7.6%
회 12
 
7.1%
원 7
 
4.1%
위 7
 
4.1%
Other values (18) 36
21.2%

결재상태
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size11.6 KiB
결재완료
1462 
<NA>
 
2

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row결재완료
2nd row결재완료
3rd row결재완료
4th row결재완료
5th row결재완료

Common Values

ValueCountFrequency (%)
결재완료 1462
99.9%
<NA> 2
 
0.1%

Length

2023-12-11T14:55:31.643324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T14:55:31.751287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
결재완료 1462
99.9%
na 2
 
0.1%

등록일시
Date

UNIQUE 

Distinct1464
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size11.6 KiB
Minimum2010-01-05 16:48:55
Maximum2013-12-13 18:07:24
2023-12-11T14:55:31.879572image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:55:32.034558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

수정일시
Date

UNIQUE 

Distinct1464
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size11.6 KiB
Minimum2010-01-05 17:24:12
Maximum2013-12-13 18:07:33
2023-12-11T14:55:32.174890image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:55:32.341847image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

안건내용
Text

MISSING 

Distinct35
Distinct (%)97.2%
Missing1428
Missing (%)97.5%
Memory size11.6 KiB
2023-12-11T14:55:32.605470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length129
Median length113.5
Mean length98.527778
Min length49

Characters and Unicode

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

Unique

Unique34 ?
Unique (%)94.4%

Sample

1st rowㅇ 심의일 : 2010.12.30 (서면심의) ㅇ 안건 : 종로구 주얼리비즈니스센터 건립 ㅇ 심의결과 : 조건부추진
2nd rowㅇ 일시 : 2010.11.8 서면심의 ㅇ 안건 : 시공원 수해지역 복구 외 16개 사업
3rd row1. 사업위치 : 양천구 목동 900-12번지 2. 규 모 - 층 수 : 지하1층 지상5층 - 연 면 적 : 11230.54 ㎡ - 용 도 : 공공업무
4th row1. 사업위치 : 강서구 마곡동가양동공항동방화동내외발산동 일원 2. 규 모 - 대지면적 : 3665336.00 ㎡
5th row1. 사업위치 : 양천구 목동 919-7번지 2. 규 모 - 층 수 : 지하2층 지상6층 - 연 면 적 : 47172.03㎡ - 용 도 : 판매 교육연구
ValueCountFrequency (%)
199
22.8%
2 32
 
3.7%
1 31
 
3.6%
규 31
 
3.6%
사업위치 31
 
3.6%
모 31
 
3.6%
도 26
 
3.0%
㎡ 26
 
3.0%
용 26
 
3.0%
연 21
 
2.4%
Other values (207) 417
47.9%
2023-12-11T14:55:33.078070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1401
39.5%
: 118
 
3.3%
. 106
 
3.0%
- 97
 
2.7%
1 96
 
2.7%
지 90
 
2.5%
2 84
 
2.4%
0 59
 
1.7%
층 57
 
1.6%
업 52
 
1.5%
Other values (175) 1387
39.1%

Most occurring categories

ValueCountFrequency (%)
Space Separator 1401
39.5%
Other Letter 1307
36.8%
Decimal Number 476
 
13.4%
Other Punctuation 224
 
6.3%
Dash Punctuation 97
 
2.7%
Other Symbol 31
 
0.9%
Uppercase Letter 9
 
0.3%
Close Punctuation 1
 
< 0.1%
Open Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
지 90
 
6.9%
층 57
 
4.4%
업 52
 
4.0%
구 51
 
3.9%
동 48
 
3.7%
사 41
 
3.1%
위 36
 
2.8%
용 35
 
2.7%
면 33
 
2.5%
연 31
 
2.4%
Other values (153) 833
63.7%
Decimal Number
ValueCountFrequency (%)
1 96
20.2%
2 84
17.6%
0 59
12.4%
8 41
8.6%
3 40
8.4%
4 36
 
7.6%
9 35
 
7.4%
6 34
 
7.1%
7 26
 
5.5%
5 25
 
5.3%
Uppercase Letter
ValueCountFrequency (%)
D 3
33.3%
M 2
22.2%
C 2
22.2%
B 1
 
11.1%
E 1
 
11.1%
Other Punctuation
ValueCountFrequency (%)
: 118
52.7%
. 106
47.3%
Space Separator
ValueCountFrequency (%)
1401
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 97
100.0%
Other Symbol
ValueCountFrequency (%)
㎡ 31
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2231
62.9%
Hangul 1307
36.8%
Latin 9
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
지 90
 
6.9%
층 57
 
4.4%
업 52
 
4.0%
구 51
 
3.9%
동 48
 
3.7%
사 41
 
3.1%
위 36
 
2.8%
용 35
 
2.7%
면 33
 
2.5%
연 31
 
2.4%
Other values (153) 833
63.7%
Common
ValueCountFrequency (%)
1401
62.8%
: 118
 
5.3%
. 106
 
4.8%
- 97
 
4.3%
1 96
 
4.3%
2 84
 
3.8%
0 59
 
2.6%
8 41
 
1.8%
3 40
 
1.8%
4 36
 
1.6%
Other values (7) 153
 
6.9%
Latin
ValueCountFrequency (%)
D 3
33.3%
M 2
22.2%
C 2
22.2%
B 1
 
11.1%
E 1
 
11.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2209
62.3%
Hangul 1295
36.5%
CJK Compat 31
 
0.9%
Compat Jamo 12
 
0.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1401
63.4%
: 118
 
5.3%
. 106
 
4.8%
- 97
 
4.4%
1 96
 
4.3%
2 84
 
3.8%
0 59
 
2.7%
8 41
 
1.9%
3 40
 
1.8%
4 36
 
1.6%
Other values (11) 131
 
5.9%
Hangul
ValueCountFrequency (%)
지 90
 
6.9%
층 57
 
4.4%
업 52
 
4.0%
구 51
 
3.9%
동 48
 
3.7%
사 41
 
3.2%
위 36
 
2.8%
용 35
 
2.7%
면 33
 
2.5%
연 31
 
2.4%
Other values (151) 821
63.4%
CJK Compat
ValueCountFrequency (%)
㎡ 31
100.0%
Compat Jamo
ValueCountFrequency (%)
ㅇ 11
91.7%
ㆍ 1
 
8.3%

Interactions

2023-12-11T14:55:27.399169image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:55:27.185015image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:55:27.506900image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T14:55:27.284410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T14:55:33.202359image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위원회번호위원회명안건번호세부절차안건내용
위원회번호1.0001.0000.1101.0001.000
위원회명1.0001.0000.4571.0001.000
안건번호0.1100.4571.0000.8121.000
세부절차1.0001.0000.8121.000NaN
안건내용1.0001.0001.000NaN1.000
2023-12-11T14:55:33.334532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
결재상태위원회명
결재상태1.0001.000
위원회명1.0001.000
2023-12-11T14:55:33.410393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위원회번호안건번호위원회명결재상태
위원회번호1.000-0.2320.9941.000
안건번호-0.2321.0000.2621.000
위원회명0.9940.2621.0001.000
결재상태1.0001.0001.0001.000

Missing values

2023-12-11T14:55:27.663313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T14:55:28.146765image/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-11T14:55:28.277699image/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

위원회번호위원회명안건번호안건명개최일자개최장소세부절차결재상태등록일시수정일시안건내용
020100002미술장식심의위원회201302612013년 제19차 미술작품심의 결과2013-12-13 00:00:00.0서울시청 서소문청사 1동 5층 회의실<NA>결재완료2013-12-13 18:07:24.02013-12-13 18:07:33.0<NA>
120090004건축위원회20130260삼호가든3차 주택재건축정비사업2013-12-17 00:00:00.0서울시청 3층 주택정책실 공용회의실<NA>결재완료2013-12-13 11:14:24.02013-12-13 11:14:24.0<NA>
220090004건축위원회20130258수색6재정비촉진구역 주택재개발정비사업2013-12-17 00:00:00.0서울시청 3층 주택정책실 공용회의실<NA>결재완료2013-12-13 11:13:20.02013-12-13 11:13:20.0<NA>
320090004건축위원회20130257동대문구 용두동 주상복합 신축사업2013-12-17 00:00:00.0서울시청 3층 주택정책실 공용회의실<NA>결재완료2013-12-13 11:12:27.02013-12-13 11:12:27.0<NA>
420090004건축위원회20130256위례신도시 A1-10블럭 공동주택신축사업2013-12-17 00:00:00.0서울시청 3층 주택정책실 공용회의실<NA>결재완료2013-12-13 11:11:59.02013-12-13 11:11:59.0<NA>
520090004건축위원회20130255천호 특계 D2구역 주상복합 신축사업2013-12-17 00:00:00.0서울시청 3층 주택정책실 공용회의실<NA>결재완료2013-12-13 11:11:25.02013-12-13 11:11:25.0<NA>
620090004건축위원회20130254묵1구역 주택재건축정비사업2013-12-17 00:00:00.0서울시청 3층 주택정책실 공용회의실<NA>결재완료2013-12-13 11:10:53.02013-12-13 11:10:53.0<NA>
720090004건축위원회20130253거여동 장기전세주택 건립사업2013-12-17 00:00:00.0서울시청 3층 주택정책실 공용회의실<NA>결재완료2013-12-13 11:10:22.02013-12-13 11:10:22.0<NA>
820090038행정심판위원회20130252제23회 행정심판위원회 개최2013-12-09 00:00:00.0대회의실 3층(신청사)<NA>결재완료2013-12-09 18:02:32.02013-12-09 18:02:32.0<NA>
920090004건축위원회20130251장위6재정비촉진구역 주택재개발정비사업2013-12-04 00:00:00.0서울시청 3층 주택정책실 공용회의실<NA>결재완료2013-11-29 16:10:57.02013-11-29 16:10:57.0<NA>
위원회번호위원회명안건번호안건명개최일자개최장소세부절차결재상태등록일시수정일시안건내용
145420100002미술장식심의위원회20100011제1차 미술장식심의2010-01-08 00:00:00.0별관1동 4층 디자인서울총괄본부 회의실<NA>결재완료2010-01-07 18:10:27.02010-01-08 17:49:53.0<NA>
145520090039환경영향평가심의위원회20100010용산구 원효로 1가 환경영향평가2010-01-20 00:00:00.0남산별관 3층 회의실<NA>결재완료2010-01-07 13:41:59.02010-01-07 20:25:04.0<NA>
145620090004건축위원회20100009여의도 1번지 업무시설 미관심의2010-01-12 00:00:00.0주택국 회의실<NA>결재완료2010-01-06 16:41:40.02010-01-25 13:12:55.0<NA>
145720090004건축위원회20100008김포공항 스카이파크 조성공사2010-01-12 00:00:00.0주택국 회의실<NA>결재완료2010-01-06 16:18:31.02010-11-03 11:16:03.0<NA>
145820090004건축위원회20100007흑석6구역 주택재개발사업2010-01-12 00:00:00.0주택국 회의실<NA>결재완료2010-01-06 16:13:49.02010-01-06 16:13:49.0<NA>
145920090033지방토지수용위원회20100006은천동국지경로당건립사업2010-01-15 00:00:00.01동13층회의실<NA><NA>2010-01-06 16:09:37.02010-01-06 16:09:37.0<NA>
146020090033지방토지수용위원회20100005초안산근린공원조성 사업2010-01-15 00:00:00.01동13층회의실<NA>결재완료2010-01-06 16:07:52.02010-01-06 16:07:52.0<NA>
146120090033지방토지수용위원회20100004석관제3구역주택재개발정비사업2010-01-15 00:00:00.01동13층 회의실<NA><NA>2010-01-06 15:32:55.02010-01-06 15:37:31.0<NA>
146220090004건축위원회20100003신림2재정비촉진구역 주택재개발정비사업2010-01-12 00:00:00.0주택국 회의실<NA>결재완료2010-01-06 15:18:30.02010-01-25 13:12:33.0<NA>
146320090033지방토지수용위원회20100002용산역전면 제2구역 도시환경정비사업2010-01-15 00:00:00.0시청13층 회의실<NA>결재완료2010-01-05 16:48:55.02010-01-05 17:24:12.0<NA>