Overview

Dataset statistics

Number of variables7
Number of observations2447
Missing cells1
Missing cells (%)< 0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory136.3 KiB
Average record size in memory57.1 B

Variable types

Numeric1
Text3
Categorical2
DateTime1

Dataset

Description충청남도 부여군 의안정보(의안번호, 의안명, 제안일자, 제안자, 소관위원회, 의안처리결과, 공포번호, 공포일자 등)
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=423&beforeMenuCd=DOM_000000201001001000&publicdatapk=15037914

Alerts

데이터기준일자 has constant value ""Constant
처리결과 is highly imbalanced (55.3%)Imbalance

Reproduction

Analysis started2024-01-09 19:51:03.604185
Analysis finished2024-01-09 19:51:04.267689
Duration0.66 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

의안번호
Real number (ℝ)

Distinct2442
Distinct (%)99.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1319.2096
Minimum0
Maximum2643
Zeros1
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size21.6 KiB
2024-01-10T04:51:04.325561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile122.3
Q1610.5
median1222
Q32030.5
95-th percentile2519.7
Maximum2643
Range2643
Interquartile range (IQR)1420

Descriptive statistics

Standard deviation793.0928
Coefficient of variation (CV)0.60118784
Kurtosis-1.3331859
Mean1319.2096
Median Absolute Deviation (MAD)710
Skewness0.0065560531
Sum3228106
Variance628996.19
MonotonicityNot monotonic
2024-01-10T04:51:04.428185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1363 2
 
0.1%
606 2
 
0.1%
2303 2
 
0.1%
1732 2
 
0.1%
962 2
 
0.1%
2643 1
 
< 0.1%
848 1
 
< 0.1%
852 1
 
< 0.1%
851 1
 
< 0.1%
850 1
 
< 0.1%
Other values (2432) 2432
99.4%
ValueCountFrequency (%)
0 1
< 0.1%
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%
ValueCountFrequency (%)
2643 1
< 0.1%
2642 1
< 0.1%
2641 1
< 0.1%
2640 1
< 0.1%
2639 1
< 0.1%
2638 1
< 0.1%
2637 1
< 0.1%
2636 1
< 0.1%
2635 1
< 0.1%
2634 1
< 0.1%

의안명
Text

Distinct1959
Distinct (%)80.1%
Missing0
Missing (%)0.0%
Memory size19.2 KiB
2024-01-10T04:51:04.637531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length58
Median length44
Mean length22.260319
Min length6

Characters and Unicode

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

Unique

Unique1746 ?
Unique (%)71.4%

Sample

1st row부여군 물의 재이용 촉진 및 지원에 관한 조례 일부개정조례안
2nd row부여군 지하수 조례 일부개정조례안
3rd row부여군 자원봉사활동 지원 조례 일부개정조례안
4th row부여군 법무부 법사랑 부여지역운영협의회 지원 조례 일부개정조례안
5th row부여군수직 인수위원회 설치 및 운영에 관한 조례안
ValueCountFrequency (%)
부여군 838
 
9.8%
조례 495
 
5.8%
일부개정조례안 427
 
5.0%
및 366
 
4.3%
조례안 334
 
3.9%
관한 298
 
3.5%
운영 131
 
1.5%
건 109
 
1.3%
설치 105
 
1.2%
지원 95
 
1.1%
Other values (2213) 5367
62.7%
2024-01-10T04:51:04.987450image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6118
 
11.2%
조 2762
 
5.1%
례 2661
 
4.9%
부 2465
 
4.5%
안 2236
 
4.1%
군 1810
 
3.3%
여 1760
 
3.2%
정 1648
 
3.0%
개 1129
 
2.1%
관 929
 
1.7%
Other values (428) 30953
56.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 45508
83.5%
Space Separator 6118
 
11.2%
Decimal Number 2243
 
4.1%
Other Punctuation 250
 
0.5%
Close Punctuation 169
 
0.3%
Open Punctuation 169
 
0.3%
Uppercase Letter 8
 
< 0.1%
Dash Punctuation 4
 
< 0.1%
Other Symbol 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
조 2762
 
6.1%
례 2661
 
5.8%
부 2465
 
5.4%
안 2236
 
4.9%
군 1810
 
4.0%
여 1760
 
3.9%
정 1648
 
3.6%
개 1129
 
2.5%
관 929
 
2.0%
의 889
 
2.0%
Other values (398) 27219
59.8%
Decimal Number
ValueCountFrequency (%)
2 610
27.2%
0 609
27.2%
1 329
14.7%
9 287
12.8%
3 89
 
4.0%
5 70
 
3.1%
4 69
 
3.1%
7 62
 
2.8%
6 60
 
2.7%
8 58
 
2.6%
Uppercase Letter
ValueCountFrequency (%)
C 2
25.0%
O 1
12.5%
P 1
12.5%
X 1
12.5%
E 1
12.5%
V 1
12.5%
T 1
12.5%
Other Punctuation
ValueCountFrequency (%)
' 172
68.8%
· 45
 
18.0%
. 16
 
6.4%
, 9
 
3.6%
: 7
 
2.8%
/ 1
 
0.4%
Close Punctuation
ValueCountFrequency (%)
) 168
99.4%
] 1
 
0.6%
Open Punctuation
ValueCountFrequency (%)
( 168
99.4%
[ 1
 
0.6%
Space Separator
ValueCountFrequency (%)
6118
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%
Other Symbol
ValueCountFrequency (%)
○ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 45508
83.5%
Common 8955
 
16.4%
Latin 8
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
조 2762
 
6.1%
례 2661
 
5.8%
부 2465
 
5.4%
안 2236
 
4.9%
군 1810
 
4.0%
여 1760
 
3.9%
정 1648
 
3.6%
개 1129
 
2.5%
관 929
 
2.0%
의 889
 
2.0%
Other values (398) 27219
59.8%
Common
ValueCountFrequency (%)
6118
68.3%
2 610
 
6.8%
0 609
 
6.8%
1 329
 
3.7%
9 287
 
3.2%
' 172
 
1.9%
) 168
 
1.9%
( 168
 
1.9%
3 89
 
1.0%
5 70
 
0.8%
Other values (13) 335
 
3.7%
Latin
ValueCountFrequency (%)
C 2
25.0%
O 1
12.5%
P 1
12.5%
X 1
12.5%
E 1
12.5%
V 1
12.5%
T 1
12.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 45507
83.5%
ASCII 8916
 
16.4%
None 45
 
0.1%
Geometric Shapes 2
 
< 0.1%
Compat Jamo 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6118
68.6%
2 610
 
6.8%
0 609
 
6.8%
1 329
 
3.7%
9 287
 
3.2%
' 172
 
1.9%
) 168
 
1.9%
( 168
 
1.9%
3 89
 
1.0%
5 70
 
0.8%
Other values (18) 296
 
3.3%
Hangul
ValueCountFrequency (%)
조 2762
 
6.1%
례 2661
 
5.8%
부 2465
 
5.4%
안 2236
 
4.9%
군 1810
 
4.0%
여 1760
 
3.9%
정 1648
 
3.6%
개 1129
 
2.5%
관 929
 
2.0%
의 889
 
2.0%
Other values (397) 27218
59.8%
None
ValueCountFrequency (%)
· 45
100.0%
Geometric Shapes
ValueCountFrequency (%)
○ 2
100.0%
Compat Jamo
ValueCountFrequency (%)
ㆍ 1
100.0%

발의자
Text

Distinct217
Distinct (%)8.9%
Missing1
Missing (%)< 0.1%
Memory size19.2 KiB
2024-01-10T04:51:05.148625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length4
Mean length4.4656582
Min length2

Characters and Unicode

Total characters10923
Distinct characters119
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

Unique134 ?
Unique (%)5.5%

Sample

1st row부여군수
2nd row부여군수
3rd row부여군수
4th row부여군수
5th row부여군수
ValueCountFrequency (%)
부여군수 1401
47.1%
군수 556
 
18.7%
의원 193
 
6.5%
등 133
 
4.5%
대표발의 53
 
1.8%
5인 37
 
1.2%
의회운영위원회 34
 
1.1%
의장 29
 
1.0%
정태영 25
 
0.8%
민병희 24
 
0.8%
Other values (157) 490
 
16.5%
2024-01-10T04:51:05.416412image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
군 1973
18.1%
수 1970
18.0%
부 1416
13.0%
여 1416
13.0%
529
 
4.8%
의 467
 
4.3%
원 435
 
4.0%
등 175
 
1.6%
인 174
 
1.6%
회 161
 
1.5%
Other values (109) 2207
20.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 10118
92.6%
Space Separator 529
 
4.8%
Decimal Number 268
 
2.5%
Other Punctuation 4
 
< 0.1%
Open Punctuation 2
 
< 0.1%
Close Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
군 1973
19.5%
수 1970
19.5%
부 1416
14.0%
여 1416
14.0%
의 467
 
4.6%
원 435
 
4.3%
등 175
 
1.7%
인 174
 
1.7%
회 161
 
1.6%
위 142
 
1.4%
Other values (94) 1789
17.7%
Decimal Number
ValueCountFrequency (%)
5 74
27.6%
6 46
17.2%
3 43
16.0%
4 42
15.7%
1 26
 
9.7%
0 9
 
3.4%
2 8
 
3.0%
7 8
 
3.0%
9 7
 
2.6%
8 5
 
1.9%
Other Punctuation
ValueCountFrequency (%)
. 3
75.0%
/ 1
 
25.0%
Space Separator
ValueCountFrequency (%)
529
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 10118
92.6%
Common 805
 
7.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
군 1973
19.5%
수 1970
19.5%
부 1416
14.0%
여 1416
14.0%
의 467
 
4.6%
원 435
 
4.3%
등 175
 
1.7%
인 174
 
1.7%
회 161
 
1.6%
위 142
 
1.4%
Other values (94) 1789
17.7%
Common
ValueCountFrequency (%)
529
65.7%
5 74
 
9.2%
6 46
 
5.7%
3 43
 
5.3%
4 42
 
5.2%
1 26
 
3.2%
0 9
 
1.1%
2 8
 
1.0%
7 8
 
1.0%
9 7
 
0.9%
Other values (5) 13
 
1.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 10118
92.6%
ASCII 805
 
7.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
군 1973
19.5%
수 1970
19.5%
부 1416
14.0%
여 1416
14.0%
의 467
 
4.6%
원 435
 
4.3%
등 175
 
1.7%
인 174
 
1.7%
회 161
 
1.6%
위 142
 
1.4%
Other values (94) 1789
17.7%
ASCII
ValueCountFrequency (%)
529
65.7%
5 74
 
9.2%
6 46
 
5.7%
3 43
 
5.3%
4 42
 
5.2%
1 26
 
3.2%
0 9
 
1.1%
2 8
 
1.0%
7 8
 
1.0%
9 7
 
0.9%
Other values (5) 13
 
1.6%

발의일
Text

Distinct642
Distinct (%)26.2%
Missing0
Missing (%)0.0%
Memory size19.2 KiB
2024-01-10T04:51:05.659489image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length9.9852881
Min length1

Characters and Unicode

Total characters24434
Distinct characters11
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique306 ?
Unique (%)12.5%

Sample

1st row2022-07-19
2nd row2022-07-19
3rd row2022-07-19
4th row2022-07-19
5th row2022-07-19
ValueCountFrequency (%)
2016-11-15 49
 
2.0%
2021-11-18 39
 
1.6%
2018-11-14 37
 
1.5%
2015-10-14 37
 
1.5%
2022-03-08 31
 
1.3%
2017-11-10 27
 
1.1%
2017-10-11 26
 
1.1%
2019-11-11 24
 
1.0%
1992-09-05 23
 
0.9%
2016-03-09 22
 
0.9%
Other values (632) 2132
87.1%
2024-01-10T04:51:05.998783image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 5258
21.5%
- 4890
20.0%
1 4790
19.6%
2 3621
14.8%
9 1967
 
8.1%
5 775
 
3.2%
7 681
 
2.8%
6 649
 
2.7%
4 647
 
2.6%
8 597
 
2.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 19544
80.0%
Dash Punctuation 4890
 
20.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 5258
26.9%
1 4790
24.5%
2 3621
18.5%
9 1967
 
10.1%
5 775
 
4.0%
7 681
 
3.5%
6 649
 
3.3%
4 647
 
3.3%
8 597
 
3.1%
3 559
 
2.9%
Dash Punctuation
ValueCountFrequency (%)
- 4890
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 24434
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 5258
21.5%
- 4890
20.0%
1 4790
19.6%
2 3621
14.8%
9 1967
 
8.1%
5 775
 
3.2%
7 681
 
2.8%
6 649
 
2.7%
4 647
 
2.6%
8 597
 
2.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 24434
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 5258
21.5%
- 4890
20.0%
1 4790
19.6%
2 3621
14.8%
9 1967
 
8.1%
5 775
 
3.2%
7 681
 
2.8%
6 649
 
2.7%
4 647
 
2.6%
8 597
 
2.4%

소관위원회
Categorical

Distinct15
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size19.2 KiB
총무위원회
1185 
산업건설위원회
383 
본회의
245 
<NA>
187 
사회산업위원회행정사무감사
173 
Other values (10)
274 

Length

Max length22
Median length13
Mean length5.9934614
Min length3

Unique

Unique3 ?
Unique (%)0.1%

Sample

1st row산업건설위원회
2nd row산업건설위원회
3rd row산업건설위원회
4th row총무위원회
5th row총무위원회

Common Values

ValueCountFrequency (%)
총무위원회 1185
48.4%
산업건설위원회 383
 
15.7%
본회의 245
 
10.0%
<NA> 187
 
7.6%
사회산업위원회행정사무감사 173
 
7.1%
예산결산특별위원회 92
 
3.8%
의회운영위원회 91
 
3.7%
총무위원회행정사무감사 42
 
1.7%
운영위원회 23
 
0.9%
행정사무감사특별위원회 17
 
0.7%
Other values (5) 9
 
0.4%

Length

2024-01-10T04:51:06.118983image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
총무위원회 1185
48.4%
산업건설위원회 383
 
15.7%
본회의 245
 
10.0%
na 187
 
7.6%
사회산업위원회행정사무감사 173
 
7.1%
예산결산특별위원회 92
 
3.8%
의회운영위원회 91
 
3.7%
총무위원회행정사무감사 42
 
1.7%
운영위원회 23
 
0.9%
행정사무감사특별위원회 17
 
0.7%
Other values (5) 9
 
0.4%

처리결과
Categorical

IMBALANCE 

Distinct11
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size19.2 KiB
처리-가결(원안)
1136 
<NA>
1069 
처리-가결(수정)
156 
처리-부결
 
30
처리
 
17
Other values (6)
 
39

Length

Max length9
Median length9
Mean length6.6395586
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row처리-가결(원안)
2nd row처리-가결(원안)
3rd row처리-가결(원안)
4th row처리-가결(원안)
5th row처리-가결(원안)

Common Values

ValueCountFrequency (%)
처리-가결(원안) 1136
46.4%
<NA> 1069
43.7%
처리-가결(수정) 156
 
6.4%
처리-부결 30
 
1.2%
처리 17
 
0.7%
찬성의견 14
 
0.6%
처리-폐기 11
 
0.4%
처리-철회 5
 
0.2%
미처리 5
 
0.2%
보류 3
 
0.1%

Length

2024-01-10T04:51:06.220610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
처리-가결(원안 1136
46.4%
na 1069
43.7%
처리-가결(수정 156
 
6.4%
처리-부결 30
 
1.2%
처리 17
 
0.7%
찬성의견 14
 
0.6%
처리-폐기 11
 
0.4%
처리-철회 5
 
0.2%
미처리 5
 
0.2%
보류 3
 
0.1%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size19.2 KiB
Minimum2022-08-31 00:00:00
Maximum2022-08-31 00:00:00
2024-01-10T04:51:06.297051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T04:51:06.366989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-01-10T04:51:04.057372image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T04:51:06.418802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
의안번호소관위원회처리결과
의안번호1.0000.5150.135
소관위원회0.5151.0000.500
처리결과0.1350.5001.000
2024-01-10T04:51:06.481965image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
소관위원회처리결과
소관위원회1.0000.174
처리결과0.1741.000
2024-01-10T04:51:06.545143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
의안번호소관위원회처리결과
의안번호1.0000.2360.061
소관위원회0.2361.0000.174
처리결과0.0610.1741.000

Missing values

2024-01-10T04:51:04.142664image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T04:51:04.227453image/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

의안번호의안명발의자발의일소관위원회처리결과데이터기준일자
02643부여군 물의 재이용 촉진 및 지원에 관한 조례 일부개정조례안부여군수2022-07-19산업건설위원회처리-가결(원안)2022-08-31
12642부여군 지하수 조례 일부개정조례안부여군수2022-07-19산업건설위원회처리-가결(원안)2022-08-31
22641부여군 자원봉사활동 지원 조례 일부개정조례안부여군수2022-07-19산업건설위원회처리-가결(원안)2022-08-31
32640부여군 법무부 법사랑 부여지역운영협의회 지원 조례 일부개정조례안부여군수2022-07-19총무위원회처리-가결(원안)2022-08-31
42639부여군수직 인수위원회 설치 및 운영에 관한 조례안부여군수2022-07-19총무위원회처리-가결(원안)2022-08-31
52638부여군 착한가격업소 지원 및 관리에 관한 조례안부여군수2022-07-19총무위원회처리-가결(원안)2022-08-31
626372022년도 제4차 수시분 공유재산 관리계획안부여군수2022-07-19총무위원회처리-가결(원안)2022-08-31
726362022년도 제2회 일반 및 특별회계 추가경정예산안부여군수2022-07-19예산결산특별위원회처리-가결(수정)2022-08-31
82635예산결산특별위원회 위원 선임의 건의장2022-07-19<NA><NA>2022-08-31
92634예산결산특별위원회 구성의 건의장2022-07-19<NA><NA>2022-08-31
의안번호의안명발의자발의일소관위원회처리결과데이터기준일자
243710정수물품취득승인요청안('91.10.14. 수정안)부여군수1991-10-01본회의<NA>2022-08-31
2438991제2회추경예산(심의)안부여군수1991-10-01본회의<NA>2022-08-31
24398부여군이장자녀장학금지급조례중개정조례안부여군수1991-07-24본회의<NA>2022-08-31
24407부여군지방세징수포상금지급조례중개정조례안부여군수1991-07-24본회의<NA>2022-08-31
24416부여군공공용지에편입된사권토지에대한종합토지세불균일과세에대한조례중개정조례안부여군수1991-07-24본회의<NA>2022-08-31
24425부여군수입증지조례중개정조례안부여군수1991-07-24본회의<NA>2022-08-31
24434'91공유재산관리계획변경의건부여군수1991-07-24본회의<NA>2022-08-31
24443'91공유재산관리계획변경의건부여군수1991-05-31본회의<NA>2022-08-31
24452'90결산검사위원선임의건부여군수1991-05-31본회의<NA>2022-08-31
24461'91군도및농어촌소득원도로확포장채무부담의건부여군수1991-05-31본회의<NA>2022-08-31