Overview

Dataset statistics

Number of variables15
Number of observations2581
Missing cells3940
Missing cells (%)10.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory307.6 KiB
Average record size in memory122.1 B

Variable types

Categorical4
Numeric1
Text5
DateTime5

Dataset

Description충청남도 아산시의회의 의안들에 대한 파일 데이터입니다.각 의안명과 의안종류, 회부일, 위원회상정일, 심사일, 상임위결과, 본회의보고일, 본회의상정일, 본회의처리일, 결과 등의 정보가 포함되어 있습니다.
Author충청남도 아산시
URLhttps://www.data.go.kr/data/15087222/fileData.do

Alerts

대수 is highly overall correlated with 회기 and 2 other fieldsHigh correlation
본회의 보고일 is highly overall correlated with 회기 and 2 other fieldsHigh correlation
회기 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 2 other fieldsHigh correlation
본회의 보고일 is highly imbalanced (63.8%)Imbalance
회부일 has 891 (34.5%) missing valuesMissing
위원회상정일 has 825 (32.0%) missing valuesMissing
심사일 has 837 (32.4%) missing valuesMissing
상임위결과 has 708 (27.4%) missing valuesMissing
본회의상정일 has 207 (8.0%) missing valuesMissing
본회의처리일 has 209 (8.1%) missing valuesMissing
결과 has 263 (10.2%) missing valuesMissing

Reproduction

Analysis started2024-04-29 22:52:11.284701
Analysis finished2024-04-29 22:52:14.711488
Duration3.43 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

대수
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size20.3 KiB
8
1086 
7
954 
9
541 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row9
2nd row9
3rd row9
4th row9
5th row9

Common Values

ValueCountFrequency (%)
8 1086
42.1%
7 954
37.0%
9 541
21.0%

Length

2024-04-30T07:52:14.774662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T07:52:14.863435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
8 1086
42.1%
7 954
37.0%
9 541
21.0%

회기
Real number (ℝ)

HIGH CORRELATION 

Distinct77
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean212.23944
Minimum0
Maximum247
Zeros4
Zeros (%)0.2%
Negative0
Negative (%)0.0%
Memory size22.8 KiB
2024-04-30T07:52:14.972332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile176
Q1191
median214
Q3234
95-th percentile245
Maximum247
Range247
Interquartile range (IQR)43

Descriptive statistics

Standard deviation24.290251
Coefficient of variation (CV)0.11444739
Kurtosis7.3515414
Mean212.23944
Median Absolute Deviation (MAD)21
Skewness-1.128813
Sum547790
Variance590.01629
MonotonicityNot monotonic
2024-04-30T07:52:15.108084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
237 75
 
2.9%
235 71
 
2.8%
234 68
 
2.6%
191 67
 
2.6%
240 63
 
2.4%
183 57
 
2.2%
199 55
 
2.1%
246 54
 
2.1%
244 53
 
2.1%
226 52
 
2.0%
Other values (67) 1966
76.2%
ValueCountFrequency (%)
0 4
 
0.2%
172 11
 
0.4%
173 22
0.9%
174 21
0.8%
175 35
1.4%
176 47
1.8%
177 30
1.2%
178 29
1.1%
179 28
1.1%
180 43
1.7%
ValueCountFrequency (%)
247 37
1.4%
246 54
2.1%
245 50
1.9%
244 53
2.1%
243 34
1.3%
242 34
1.3%
241 45
1.7%
240 63
2.4%
239 40
1.5%
238 43
1.7%
Distinct2567
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Memory size20.3 KiB
2024-04-30T07:52:15.472713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length4
Mean length4.0007749
Min length4

Characters and Unicode

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

Unique

Unique2555 ?
Unique (%)99.0%

Sample

1st row5428
2nd row5427
3rd row5426
4th row5425
5th row5424
ValueCountFrequency (%)
4118 3
 
0.1%
4178 3
 
0.1%
4261 2
 
0.1%
3900 2
 
0.1%
4335 2
 
0.1%
4342 2
 
0.1%
4287 2
 
0.1%
3908 2
 
0.1%
4251 2
 
0.1%
3909 2
 
0.1%
Other values (2557) 2559
99.1%
2024-04-30T07:52:15.950662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 1813
17.6%
4 1747
16.9%
5 1137
11.0%
2 960
9.3%
0 823
8.0%
1 822
8.0%
9 818
7.9%
8 763
7.4%
7 720
 
7.0%
6 719
 
7.0%
Other values (4) 4
 
< 0.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 10322
> 99.9%
Lowercase Letter 2
 
< 0.1%
Uppercase Letter 1
 
< 0.1%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 1813
17.6%
4 1747
16.9%
5 1137
11.0%
2 960
9.3%
0 823
8.0%
1 822
8.0%
9 818
7.9%
8 763
7.4%
7 720
 
7.0%
6 719
 
7.0%
Lowercase Letter
ValueCountFrequency (%)
a 1
50.0%
n 1
50.0%
Uppercase Letter
ValueCountFrequency (%)
J 1
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 10323
> 99.9%
Latin 3
 
< 0.1%

Most frequent character per script

Common
ValueCountFrequency (%)
3 1813
17.6%
4 1747
16.9%
5 1137
11.0%
2 960
9.3%
0 823
8.0%
1 822
8.0%
9 818
7.9%
8 763
7.4%
7 720
 
7.0%
6 719
 
7.0%
Latin
ValueCountFrequency (%)
J 1
33.3%
a 1
33.3%
n 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 10326
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 1813
17.6%
4 1747
16.9%
5 1137
11.0%
2 960
9.3%
0 823
8.0%
1 822
8.0%
9 818
7.9%
8 763
7.4%
7 720
 
7.0%
6 719
 
7.0%
Other values (4) 4
 
< 0.1%
Distinct1731
Distinct (%)67.1%
Missing0
Missing (%)0.0%
Memory size20.3 KiB
2024-04-30T07:52:16.210481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length87
Median length47
Mean length24.965517
Min length5

Characters and Unicode

Total characters64436
Distinct characters490
Distinct categories12 ?
Distinct scripts3 ?
Distinct blocks5 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1473 ?
Unique (%)57.1%

Sample

1st row2024년 행정사무감사 계획서 승인의 건
2nd row2024년 건설도시위원회 행정사무감사 계획서 작성의 건
3rd row2024년 문화환경위원회 행정사무감사 계획서 작성의 건
4th row2024년 기획행정위원회 행정사무감사 계획서 작성의 건
5th row휴회의 건
ValueCountFrequency (%)
아산시 1524
 
10.3%
조례 944
 
6.4%
767
 
5.2%
일부개정조례안 765
 
5.2%
650
 
4.4%
관한 573
 
3.9%
조례안 398
 
2.7%
운영 254
 
1.7%
위원 234
 
1.6%
설치 198
 
1.3%
Other values (2081) 8547
57.5%
2024-04-30T07:52:16.670705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
12385
 
19.2%
2380
 
3.7%
2307
 
3.6%
2269
 
3.5%
2244
 
3.5%
1923
 
3.0%
1910
 
3.0%
1833
 
2.8%
1502
 
2.3%
1405
 
2.2%
Other values (480) 34278
53.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 49688
77.1%
Space Separator 12385
 
19.2%
Decimal Number 1099
 
1.7%
Close Punctuation 473
 
0.7%
Open Punctuation 473
 
0.7%
Other Punctuation 281
 
0.4%
Uppercase Letter 16
 
< 0.1%
Dash Punctuation 7
 
< 0.1%
Lowercase Letter 7
 
< 0.1%
Initial Punctuation 3
 
< 0.1%
Other values (2) 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
2380
 
4.8%
2307
 
4.6%
2269
 
4.6%
2244
 
4.5%
1923
 
3.9%
1910
 
3.8%
1833
 
3.7%
1502
 
3.0%
1405
 
2.8%
1199
 
2.4%
Other values (432) 30716
61.8%
Uppercase Letter
ValueCountFrequency (%)
D 4
25.0%
A 2
12.5%
N 2
12.5%
L 1
 
6.2%
E 1
 
6.2%
G 1
 
6.2%
S 1
 
6.2%
W 1
 
6.2%
B 1
 
6.2%
T 1
 
6.2%
Decimal Number
ValueCountFrequency (%)
2 394
35.9%
0 264
24.0%
1 186
16.9%
7 50
 
4.5%
8 47
 
4.3%
9 40
 
3.6%
4 35
 
3.2%
3 34
 
3.1%
6 28
 
2.5%
5 21
 
1.9%
Other Punctuation
ValueCountFrequency (%)
· 234
83.3%
, 16
 
5.7%
" 16
 
5.7%
: 8
 
2.8%
' 4
 
1.4%
/ 1
 
0.4%
. 1
 
0.4%
& 1
 
0.4%
Lowercase Letter
ValueCountFrequency (%)
l 2
28.6%
i 1
14.3%
n 1
14.3%
g 1
14.3%
y 1
14.3%
e 1
14.3%
Close Punctuation
ValueCountFrequency (%)
) 450
95.1%
16
 
3.4%
] 6
 
1.3%
1
 
0.2%
Open Punctuation
ValueCountFrequency (%)
( 450
95.1%
16
 
3.4%
[ 6
 
1.3%
1
 
0.2%
Space Separator
ValueCountFrequency (%)
12385
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%
Initial Punctuation
ValueCountFrequency (%)
3
100.0%
Final Punctuation
ValueCountFrequency (%)
3
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 49688
77.1%
Common 14725
 
22.9%
Latin 23
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
2380
 
4.8%
2307
 
4.6%
2269
 
4.6%
2244
 
4.5%
1923
 
3.9%
1910
 
3.8%
1833
 
3.7%
1502
 
3.0%
1405
 
2.8%
1199
 
2.4%
Other values (432) 30716
61.8%
Common
ValueCountFrequency (%)
12385
84.1%
) 450
 
3.1%
( 450
 
3.1%
2 394
 
2.7%
0 264
 
1.8%
· 234
 
1.6%
1 186
 
1.3%
7 50
 
0.3%
8 47
 
0.3%
9 40
 
0.3%
Other values (21) 225
 
1.5%
Latin
ValueCountFrequency (%)
D 4
17.4%
A 2
 
8.7%
l 2
 
8.7%
N 2
 
8.7%
i 1
 
4.3%
n 1
 
4.3%
g 1
 
4.3%
y 1
 
4.3%
L 1
 
4.3%
e 1
 
4.3%
Other values (7) 7
30.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 49687
77.1%
ASCII 14474
 
22.5%
None 268
 
0.4%
Punctuation 6
 
< 0.1%
Compat Jamo 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
12385
85.6%
) 450
 
3.1%
( 450
 
3.1%
2 394
 
2.7%
0 264
 
1.8%
1 186
 
1.3%
7 50
 
0.3%
8 47
 
0.3%
9 40
 
0.3%
4 35
 
0.2%
Other values (31) 173
 
1.2%
Hangul
ValueCountFrequency (%)
2380
 
4.8%
2307
 
4.6%
2269
 
4.6%
2244
 
4.5%
1923
 
3.9%
1910
 
3.8%
1833
 
3.7%
1502
 
3.0%
1405
 
2.8%
1199
 
2.4%
Other values (431) 30715
61.8%
None
ValueCountFrequency (%)
· 234
87.3%
16
 
6.0%
16
 
6.0%
1
 
0.4%
1
 
0.4%
Punctuation
ValueCountFrequency (%)
3
50.0%
3
50.0%
Compat Jamo
ValueCountFrequency (%)
1
100.0%
Distinct154
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Memory size20.3 KiB
2024-04-30T07:52:16.904241image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length134
Median length2
Mean length5.6884928
Min length2

Characters and Unicode

Total characters14682
Distinct characters102
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

Unique78 ?
Unique (%)3.0%

Sample

1st row의장
2nd row건설도시위원장
3rd row문화환경위원장
4th row기획행정위원장
5th row의장
ValueCountFrequency (%)
시장 1077
25.1%
의장 597
13.9%
의원 535
 
12.5%
아산시장 150
 
3.5%
김미영 100
 
2.3%
홍성표 98
 
2.3%
맹의석 91
 
2.1%
안정근 89
 
2.1%
김희영 89
 
2.1%
전남수 79
 
1.8%
Other values (84) 1387
32.3%
2024-04-30T07:52:17.311546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1937
13.2%
1719
 
11.7%
1695
 
11.5%
1270
 
8.7%
, 1123
 
7.6%
1076
 
7.3%
496
 
3.4%
455
 
3.1%
233
 
1.6%
229
 
1.6%
Other values (92) 4449
30.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 11818
80.5%
Space Separator 1719
 
11.7%
Other Punctuation 1123
 
7.6%
Decimal Number 22
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
1937
16.4%
1695
14.3%
1270
 
10.7%
1076
 
9.1%
496
 
4.2%
455
 
3.9%
233
 
2.0%
229
 
1.9%
198
 
1.7%
187
 
1.6%
Other values (85) 4042
34.2%
Decimal Number
ValueCountFrequency (%)
1 10
45.5%
4 9
40.9%
3 1
 
4.5%
8 1
 
4.5%
2 1
 
4.5%
Space Separator
ValueCountFrequency (%)
1719
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1123
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 11818
80.5%
Common 2864
 
19.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
1937
16.4%
1695
14.3%
1270
 
10.7%
1076
 
9.1%
496
 
4.2%
455
 
3.9%
233
 
2.0%
229
 
1.9%
198
 
1.7%
187
 
1.6%
Other values (85) 4042
34.2%
Common
ValueCountFrequency (%)
1719
60.0%
, 1123
39.2%
1 10
 
0.3%
4 9
 
0.3%
3 1
 
< 0.1%
8 1
 
< 0.1%
2 1
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 11818
80.5%
ASCII 2864
 
19.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
1937
16.4%
1695
14.3%
1270
 
10.7%
1076
 
9.1%
496
 
4.2%
455
 
3.9%
233
 
2.0%
229
 
1.9%
198
 
1.7%
187
 
1.6%
Other values (85) 4042
34.2%
ASCII
ValueCountFrequency (%)
1719
60.0%
, 1123
39.2%
1 10
 
0.3%
4 9
 
0.3%
3 1
 
< 0.1%
8 1
 
< 0.1%
2 1
 
< 0.1%

의안종류
Categorical

HIGH CORRELATION 

Distinct29
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size20.3 KiB
조례
1341 
운영
360 
동의
194 
추천
190 
감사
 
76
Other values (24)
420 

Length

Max length4
Median length2
Mean length2.0410694
Min length2

Unique

Unique2 ?
Unique (%)0.1%

Sample

1st row감사
2nd row감사
3rd row감사
4th row감사
5th row운영

Common Values

ValueCountFrequency (%)
조례 1341
52.0%
운영 360
 
13.9%
동의 194
 
7.5%
추천 190
 
7.4%
감사 76
 
2.9%
인사 57
 
2.2%
의견 50
 
1.9%
재산 46
 
1.8%
예산 43
 
1.7%
기금 33
 
1.3%
Other values (19) 191
 
7.4%

Length

2024-04-30T07:52:17.472945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
조례 1341
52.0%
운영 360
 
13.9%
동의 194
 
7.5%
추천 190
 
7.4%
감사 76
 
2.9%
인사 57
 
2.2%
의견 50
 
1.9%
재산 46
 
1.8%
예산 43
 
1.7%
기금 33
 
1.3%
Other values (19) 191
 
7.4%

소관위원회
Categorical

HIGH CORRELATION 

Distinct38
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size20.3 KiB
<NA>
694 
총무
418 
산업
357 
기획행정
226 
복지환경
162 
Other values (33)
724 

Length

Max length23
Median length4
Mean length3.1739636
Min length2

Unique

Unique13 ?
Unique (%)0.5%

Sample

1st row<NA>
2nd row건설도시
3rd row문화환경
4th row기획행정
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 694
26.9%
총무 418
16.2%
산업 357
13.8%
기획행정 226
 
8.8%
복지환경 162
 
6.3%
건설도시 144
 
5.6%
기획 113
 
4.4%
복지 94
 
3.6%
운영 66
 
2.6%
의회운영 65
 
2.5%
Other values (28) 242
 
9.4%

Length

2024-04-30T07:52:17.593035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 694
26.8%
총무 424
16.4%
산업 363
14.0%
기획행정 226
 
8.7%
복지환경 162
 
6.2%
건설도시 144
 
5.6%
기획 113
 
4.4%
복지 94
 
3.6%
운영 66
 
2.5%
의회운영 65
 
2.5%
Other values (33) 242
 
9.3%

회부일
Date

MISSING 

Distinct101
Distinct (%)6.0%
Missing891
Missing (%)34.5%
Memory size20.3 KiB
Minimum2014-07-21 00:00:00
Maximum2024-02-27 00:00:00
2024-04-30T07:52:17.730602image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T07:52:17.881603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

위원회상정일
Date

MISSING 

Distinct147
Distinct (%)8.4%
Missing825
Missing (%)32.0%
Memory size20.3 KiB
Minimum2014-07-21 00:00:00
Maximum2024-02-08 00:00:00
2024-04-30T07:52:18.012933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T07:52:18.150266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

심사일
Date

MISSING 

Distinct156
Distinct (%)8.9%
Missing837
Missing (%)32.4%
Memory size20.3 KiB
Minimum2014-07-21 00:00:00
Maximum2024-02-21 00:00:00
2024-04-30T07:52:18.275935image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T07:52:18.648298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

상임위결과
Text

MISSING 

Distinct54
Distinct (%)2.9%
Missing708
Missing (%)27.4%
Memory size20.3 KiB
2024-04-30T07:52:18.836294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length4
Mean length4.2562734
Min length2

Characters and Unicode

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

Unique

Unique31 ?
Unique (%)1.7%

Sample

1st row계획서 작성
2nd row계획서 작성
3rd row계획서 작성
4th row의견서 작성
5th row의견서 작성
ValueCountFrequency (%)
원안가결 1327
66.9%
수정가결 276
 
13.9%
작성 86
 
4.3%
부결 40
 
2.0%
의견서 39
 
2.0%
감사계획서 26
 
1.3%
결과보고서 22
 
1.1%
철회 22
 
1.1%
보고종결 21
 
1.1%
심사보류 19
 
1.0%
Other values (53) 105
 
5.3%
2024-04-30T07:52:19.194544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1688
21.2%
1603
20.1%
1329
16.7%
1329
16.7%
276
 
3.5%
276
 
3.5%
114
 
1.4%
110
 
1.4%
89
 
1.1%
89
 
1.1%
Other values (64) 1069
13.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7534
94.5%
Decimal Number 195
 
2.4%
Space Separator 114
 
1.4%
Other Punctuation 73
 
0.9%
Open Punctuation 28
 
0.4%
Close Punctuation 28
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
1688
22.4%
1603
21.3%
1329
17.6%
1329
17.6%
276
 
3.7%
276
 
3.7%
110
 
1.5%
89
 
1.2%
89
 
1.2%
75
 
1.0%
Other values (50) 670
 
8.9%
Decimal Number
ValueCountFrequency (%)
2 59
30.3%
1 49
25.1%
0 39
20.0%
5 12
 
6.2%
8 10
 
5.1%
3 9
 
4.6%
9 8
 
4.1%
4 6
 
3.1%
7 2
 
1.0%
6 1
 
0.5%
Space Separator
ValueCountFrequency (%)
114
100.0%
Other Punctuation
ValueCountFrequency (%)
. 73
100.0%
Open Punctuation
ValueCountFrequency (%)
( 28
100.0%
Close Punctuation
ValueCountFrequency (%)
) 28
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7534
94.5%
Common 438
 
5.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
1688
22.4%
1603
21.3%
1329
17.6%
1329
17.6%
276
 
3.7%
276
 
3.7%
110
 
1.5%
89
 
1.2%
89
 
1.2%
75
 
1.0%
Other values (50) 670
 
8.9%
Common
ValueCountFrequency (%)
114
26.0%
. 73
16.7%
2 59
13.5%
1 49
11.2%
0 39
 
8.9%
( 28
 
6.4%
) 28
 
6.4%
5 12
 
2.7%
8 10
 
2.3%
3 9
 
2.1%
Other values (4) 17
 
3.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7534
94.5%
ASCII 438
 
5.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
1688
22.4%
1603
21.3%
1329
17.6%
1329
17.6%
276
 
3.7%
276
 
3.7%
110
 
1.5%
89
 
1.2%
89
 
1.2%
75
 
1.0%
Other values (50) 670
 
8.9%
ASCII
ValueCountFrequency (%)
114
26.0%
. 73
16.7%
2 59
13.5%
1 49
11.2%
0 39
 
8.9%
( 28
 
6.4%
) 28
 
6.4%
5 12
 
2.7%
8 10
 
2.3%
3 9
 
2.1%
Other values (4) 17
 
3.9%

본회의 보고일
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct33
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size20.3 KiB
<NA>
1969 
2021-12-02
 
56
2023-08-25
 
53
2022-03-29
 
53
2023-10-16
 
50
Other values (28)
400 

Length

Max length10
Median length4
Mean length5.4227044
Min length4

Unique

Unique6 ?
Unique (%)0.2%

Sample

1st row<NA>
2nd row2024-02-27
3rd row2024-02-27
4th row2024-02-27
5th row2024-02-19

Common Values

ValueCountFrequency (%)
<NA> 1969
76.3%
2021-12-02 56
 
2.2%
2023-08-25 53
 
2.1%
2022-03-29 53
 
2.1%
2023-10-16 50
 
1.9%
2023-12-04 39
 
1.5%
2021-08-31 35
 
1.4%
2021-10-25 34
 
1.3%
2023-05-12 34
 
1.3%
2024-02-19 33
 
1.3%
Other values (23) 225
 
8.7%

Length

2024-04-30T07:52:19.345091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 1969
76.3%
2021-12-02 56
 
2.2%
2023-08-25 53
 
2.1%
2022-03-29 53
 
2.1%
2023-10-16 50
 
1.9%
2023-12-04 39
 
1.5%
2021-08-31 35
 
1.4%
2021-10-25 34
 
1.3%
2023-05-12 34
 
1.3%
2024-02-19 33
 
1.3%
Other values (23) 225
 
8.7%

본회의상정일
Date

MISSING 

Distinct157
Distinct (%)6.6%
Missing207
Missing (%)8.0%
Memory size20.3 KiB
Minimum2014-07-04 00:00:00
Maximum2024-02-27 00:00:00
2024-04-30T07:52:19.467793image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T07:52:19.599249image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

본회의처리일
Date

MISSING 

Distinct157
Distinct (%)6.6%
Missing209
Missing (%)8.1%
Memory size20.3 KiB
Minimum2014-07-04 00:00:00
Maximum2024-02-27 00:00:00
2024-04-30T07:52:19.733695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T07:52:19.902478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

결과
Text

MISSING 

Distinct497
Distinct (%)21.4%
Missing263
Missing (%)10.2%
Memory size20.3 KiB
2024-04-30T07:52:20.270491image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length272
Median length4
Mean length7.8943054
Min length2

Characters and Unicode

Total characters18299
Distinct characters189
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

Unique416 ?
Unique (%)17.9%

Sample

1st row계획서 승인
2nd row2024. 2. 26.까지 휴회
3rd row이은우, 장지우, 박미자
4th row천철호 의원
5th row윤원준 의원
ValueCountFrequency (%)
원안가결 1322
32.2%
의원 381
 
9.3%
수정가결 276
 
6.7%
130
 
3.2%
채택 67
 
1.6%
휴회 43
 
1.0%
의견서 40
 
1.0%
맹의석 37
 
0.9%
홍성표 36
 
0.9%
김미영 31
 
0.8%
Other values (487) 1742
42.4%
2024-04-30T07:52:20.774533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2135
 
11.7%
1834
 
10.0%
1639
 
9.0%
1599
 
8.7%
1391
 
7.6%
902
 
4.9%
. 728
 
4.0%
2 635
 
3.5%
, 605
 
3.3%
1 517
 
2.8%
Other values (179) 6314
34.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 12395
67.7%
Decimal Number 2223
 
12.1%
Space Separator 1834
 
10.0%
Other Punctuation 1409
 
7.7%
Open Punctuation 132
 
0.7%
Close Punctuation 131
 
0.7%
Math Symbol 130
 
0.7%
Dash Punctuation 44
 
0.2%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
2135
17.2%
1639
13.2%
1599
12.9%
1391
 
11.2%
902
 
7.3%
337
 
2.7%
316
 
2.5%
224
 
1.8%
219
 
1.8%
140
 
1.1%
Other values (155) 3493
28.2%
Decimal Number
ValueCountFrequency (%)
2 635
28.6%
1 517
23.3%
0 363
16.3%
9 110
 
4.9%
8 110
 
4.9%
6 109
 
4.9%
3 100
 
4.5%
5 97
 
4.4%
7 93
 
4.2%
4 89
 
4.0%
Other Punctuation
ValueCountFrequency (%)
. 728
51.7%
, 605
42.9%
: 67
 
4.8%
/ 5
 
0.4%
" 4
 
0.3%
Math Symbol
ValueCountFrequency (%)
~ 122
93.8%
5
 
3.8%
> 2
 
1.5%
< 1
 
0.8%
Space Separator
ValueCountFrequency (%)
1834
100.0%
Open Punctuation
ValueCountFrequency (%)
( 132
100.0%
Close Punctuation
ValueCountFrequency (%)
) 131
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 44
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 12395
67.7%
Common 5903
32.3%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
2135
17.2%
1639
13.2%
1599
12.9%
1391
 
11.2%
902
 
7.3%
337
 
2.7%
316
 
2.5%
224
 
1.8%
219
 
1.8%
140
 
1.1%
Other values (155) 3493
28.2%
Common
ValueCountFrequency (%)
1834
31.1%
. 728
 
12.3%
2 635
 
10.8%
, 605
 
10.2%
1 517
 
8.8%
0 363
 
6.1%
( 132
 
2.2%
) 131
 
2.2%
~ 122
 
2.1%
9 110
 
1.9%
Other values (13) 726
 
12.3%
Latin
ValueCountFrequency (%)
A 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 12395
67.7%
ASCII 5899
32.2%
Math Operators 5
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
2135
17.2%
1639
13.2%
1599
12.9%
1391
 
11.2%
902
 
7.3%
337
 
2.7%
316
 
2.5%
224
 
1.8%
219
 
1.8%
140
 
1.1%
Other values (155) 3493
28.2%
ASCII
ValueCountFrequency (%)
1834
31.1%
. 728
 
12.3%
2 635
 
10.8%
, 605
 
10.3%
1 517
 
8.8%
0 363
 
6.2%
( 132
 
2.2%
) 131
 
2.2%
~ 122
 
2.1%
9 110
 
1.9%
Other values (13) 722
 
12.2%
Math Operators
ValueCountFrequency (%)
5
100.0%

Interactions

2024-04-30T07:52:13.925035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-30T07:52:20.884453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
대수회기의안종류소관위원회상임위결과본회의 보고일
대수1.0000.7350.4450.8990.4291.000
회기0.7351.0000.4830.9470.3811.000
의안종류0.4450.4831.0000.9350.9420.909
소관위원회0.8990.9470.9351.0000.7120.840
상임위결과0.4290.3810.9420.7121.0000.778
본회의 보고일1.0001.0000.9090.8400.7781.000
2024-04-30T07:52:20.984102image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
대수본회의 보고일소관위원회의안종류
대수1.0000.9760.7280.253
본회의 보고일0.9761.0000.4390.503
소관위원회0.7280.4391.0000.525
의안종류0.2530.5030.5251.000
2024-04-30T07:52:21.075867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
회기대수의안종류소관위원회본회의 보고일
회기1.0000.7300.2550.8240.975
대수0.7301.0000.2530.7280.976
의안종류0.2550.2531.0000.5250.503
소관위원회0.8240.7280.5251.0000.439
본회의 보고일0.9750.9760.5030.4391.000

Missing values

2024-04-30T07:52:14.151302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-30T07:52:14.401484image/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.
2024-04-30T07:52:14.599364image/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

대수회기의안번호의안명발의자의안종류소관위원회회부일위원회상정일심사일상임위결과본회의 보고일본회의상정일본회의처리일결과
0924754282024년 행정사무감사 계획서 승인의 건의장감사<NA>2024-02-27<NA><NA><NA><NA>2024-02-272024-02-27계획서 승인
1924754272024년 건설도시위원회 행정사무감사 계획서 작성의 건건설도시위원장감사건설도시2024-02-26<NA><NA>계획서 작성2024-02-27<NA><NA><NA>
2924754262024년 문화환경위원회 행정사무감사 계획서 작성의 건문화환경위원장감사문화환경2024-02-26<NA><NA>계획서 작성2024-02-27<NA><NA><NA>
3924754252024년 기획행정위원회 행정사무감사 계획서 작성의 건기획행정위원장감사기획행정2024-02-26<NA><NA>계획서 작성2024-02-27<NA><NA><NA>
492475424휴회의 건의장운영<NA>2024-02-19<NA><NA><NA>2024-02-192024-02-192024-02-192024. 2. 26.까지 휴회
592475423(재)아산시청소년재단 임원추천위원회 위원 추천의 건의장추천<NA>2024-02-19<NA><NA><NA>2024-02-192024-02-192024-02-19이은우, 장지우, 박미자
692475422아산시 특별회계관리운영위원회 위원 추천의 건의장추천<NA>2024-02-19<NA><NA><NA>2024-02-192024-02-192024-02-19천철호 의원
792475421아산시 화학물질 안전관리위원회 위원 추천의 건의장추천<NA>2024-02-19<NA><NA><NA>2024-02-192024-02-192024-02-19윤원준 의원
892475420아산시 여성폭력방지위원회 위원 추천의 건의장추천<NA>2024-02-19<NA><NA><NA>2024-02-192024-02-192024-02-19신미진 의원
992475419아산시 노동자종합복지관 운영 민간위탁 심의위원회 위원 추천의 건의장추천<NA>2024-02-19<NA><NA><NA>2024-02-192024-02-192024-02-19천철호 의원, 안정근 의원
대수회기의안번호의안명발의자의안종류소관위원회회부일위원회상정일심사일상임위결과본회의 보고일본회의상정일본회의처리일결과
257171722869제7대 아산시의회 전반기 산업건설위원회 위원장 선거의 건의장인사<NA><NA><NA><NA><NA><NA>2014-07-042014-07-04위원장 : 이기애의원
257271722868제7대 아산시의회 전반기 총무복지위원회 위원장 선거의 건의장인사<NA><NA><NA><NA><NA><NA>2014-07-042014-07-04위원장 : 성시열의원
257371722867제7대 아산시의회 전반기 의회운영위원회 위원장 선거의 건의장인사<NA><NA><NA><NA><NA><NA>2014-07-042014-07-04위원장 : 유명근의원
257471722866제7대 아산시의회 전반기 산업건설위원회 위원 선임의 건의장인사<NA><NA><NA><NA><NA><NA>2014-07-042014-07-04이기애의원, 황재만의원, 오안영의원, 유명근의원, 심상복의원(부위원장), 안장헌의원, 김희영의원
257571722865제7대 아산시의회 전반기 총무복지위원회 위원 선임의 건의장인사<NA><NA><NA><NA><NA><NA>2014-07-042014-07-04박성순의원, 현인배의원, 김영애의원, 김진구의원, 성시열의원, 조철기의원, 이영해의원(부위원장)
257671722864제7대 아산시의회 전반기 의회운영위원회 위원 선임의 건의장인사<NA><NA><NA><NA><NA><NA>2014-07-042014-07-04박성순의원, 김영애의원, 김진구의원(부위원장), 유명근의원, 안장헌의원
257771722863회의록 서명의원 선출의 건의장운영<NA><NA><NA><NA><NA><NA>2014-07-042014-07-04박성순의원, 이기애의원
257871722862제7대 아산시의회 전반기 부의장 선거의 건의장인사<NA><NA><NA><NA><NA><NA>2014-07-042014-07-04부의장 : 김진구의원
257971722861제7대 아산시의회 전반기 의장 선거의 건의장직무대행인사<NA><NA><NA><NA><NA><NA>2014-07-042014-07-04의장 : 유기준의원
258071722860회기 결정의 건의장직무대행운영<NA><NA><NA><NA><NA><NA>2014-07-042014-07-04회기 : 2010.07.04.(1일간)