Overview

Dataset statistics

Number of variables7
Number of observations2631
Missing cells2
Missing cells (%)< 0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory146.6 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.0%)Imbalance

Reproduction

Analysis started2024-01-09 19:50:59.648589
Analysis finished2024-01-09 19:51:00.433158
Duration0.78 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

의안번호
Real number (ℝ)

Distinct2625
Distinct (%)99.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1418.2531
Minimum0
Maximum2826
Zeros1
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2024-01-10T04:51:00.486860image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile131.5
Q1656.5
median1512
Q32168.5
95-th percentile2695.5
Maximum2826
Range2826
Interquartile range (IQR)1512

Descriptive statistics

Standard deviation845.98679
Coefficient of variation (CV)0.59649915
Kurtosis-1.32235
Mean1418.2531
Median Absolute Deviation (MAD)756
Skewness-0.018229617
Sum3731424
Variance715693.65
MonotonicityNot monotonic
2024-01-10T04:51:00.591738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2813 2
 
0.1%
1732 2
 
0.1%
1363 2
 
0.1%
2303 2
 
0.1%
606 2
 
0.1%
962 2
 
0.1%
717 1
 
< 0.1%
907 1
 
< 0.1%
912 1
 
< 0.1%
911 1
 
< 0.1%
Other values (2615) 2615
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 (%)
2826 1
< 0.1%
2825 1
< 0.1%
2824 1
< 0.1%
2823 1
< 0.1%
2822 1
< 0.1%
2821 1
< 0.1%
2820 1
< 0.1%
2819 1
< 0.1%
2818 1
< 0.1%
2817 1
< 0.1%

의안명
Text

Distinct2082
Distinct (%)79.1%
Missing0
Missing (%)0.0%
Memory size20.7 KiB
2024-01-10T04:51:00.766933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length58
Median length44
Mean length22.305207
Min length6

Characters and Unicode

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

Unique

Unique1847 ?
Unique (%)70.2%

Sample

1st row2023년도 제3회 일반 및 특별회계 추가경정예산안 수정동의안
2nd row집중호우 피해 중소기업 특별지원 촉구 건의안
3rd row예산결산특별위원회 구성의 건
4th row관계공무원 출석 요구의 건
5th row회기 결정의 건
ValueCountFrequency (%)
부여군 917
 
9.6%
조례 554
 
5.8%
일부개정조례안 472
 
4.9%
및 411
 
4.3%
조례안 359
 
3.8%
관한 335
 
3.5%
건 164
 
1.7%
운영 156
 
1.6%
설치 117
 
1.2%
지원 103
 
1.1%
Other values (2333) 5977
62.5%
2024-01-10T04:51:01.061593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6934
 
11.8%
조 2917
 
5.0%
례 2808
 
4.8%
부 2618
 
4.5%
안 2371
 
4.0%
군 1905
 
3.2%
여 1856
 
3.2%
정 1762
 
3.0%
개 1196
 
2.0%
관 1001
 
1.7%
Other values (435) 33317
56.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 48832
83.2%
Space Separator 6934
 
11.8%
Decimal Number 2469
 
4.2%
Close Punctuation 173
 
0.3%
Open Punctuation 173
 
0.3%
Other Punctuation 87
 
0.1%
Uppercase Letter 8
 
< 0.1%
Dash Punctuation 4
 
< 0.1%
Other Symbol 2
 
< 0.1%
Initial Punctuation 1
 
< 0.1%
Other values (2) 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
조 2917
 
6.0%
례 2808
 
5.8%
부 2618
 
5.4%
안 2371
 
4.9%
군 1905
 
3.9%
여 1856
 
3.8%
정 1762
 
3.6%
개 1196
 
2.4%
관 1001
 
2.0%
의 990
 
2.0%
Other values (403) 29408
60.2%
Decimal Number
ValueCountFrequency (%)
2 732
29.6%
0 660
26.7%
1 335
13.6%
9 287
 
11.6%
3 126
 
5.1%
5 72
 
2.9%
4 71
 
2.9%
6 64
 
2.6%
7 63
 
2.6%
8 59
 
2.4%
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 (%)
· 54
62.1%
. 16
 
18.4%
, 9
 
10.3%
: 7
 
8.0%
/ 1
 
1.1%
Close Punctuation
ValueCountFrequency (%)
) 172
99.4%
] 1
 
0.6%
Open Punctuation
ValueCountFrequency (%)
( 172
99.4%
[ 1
 
0.6%
Space Separator
ValueCountFrequency (%)
6934
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%
Other Symbol
ValueCountFrequency (%)
○ 2
100.0%
Initial Punctuation
ValueCountFrequency (%)
‘ 1
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%
Final Punctuation
ValueCountFrequency (%)
’ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 48832
83.2%
Common 9845
 
16.8%
Latin 8
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
조 2917
 
6.0%
례 2808
 
5.8%
부 2618
 
5.4%
안 2371
 
4.9%
군 1905
 
3.9%
여 1856
 
3.8%
정 1762
 
3.6%
개 1196
 
2.4%
관 1001
 
2.0%
의 990
 
2.0%
Other values (403) 29408
60.2%
Common
ValueCountFrequency (%)
6934
70.4%
2 732
 
7.4%
0 660
 
6.7%
1 335
 
3.4%
9 287
 
2.9%
) 172
 
1.7%
( 172
 
1.7%
3 126
 
1.3%
5 72
 
0.7%
4 71
 
0.7%
Other values (15) 284
 
2.9%
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 48829
83.2%
ASCII 9795
 
16.7%
None 54
 
0.1%
Compat Jamo 3
 
< 0.1%
Geometric Shapes 2
 
< 0.1%
Punctuation 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6934
70.8%
2 732
 
7.5%
0 660
 
6.7%
1 335
 
3.4%
9 287
 
2.9%
) 172
 
1.8%
( 172
 
1.8%
3 126
 
1.3%
5 72
 
0.7%
4 71
 
0.7%
Other values (18) 234
 
2.4%
Hangul
ValueCountFrequency (%)
조 2917
 
6.0%
례 2808
 
5.8%
부 2618
 
5.4%
안 2371
 
4.9%
군 1905
 
3.9%
여 1856
 
3.8%
정 1762
 
3.6%
개 1196
 
2.4%
관 1001
 
2.1%
의 990
 
2.0%
Other values (402) 29405
60.2%
None
ValueCountFrequency (%)
· 54
100.0%
Compat Jamo
ValueCountFrequency (%)
ㆍ 3
100.0%
Geometric Shapes
ValueCountFrequency (%)
○ 2
100.0%
Punctuation
ValueCountFrequency (%)
‘ 1
50.0%
’ 1
50.0%

발의자
Text

Distinct230
Distinct (%)8.7%
Missing1
Missing (%)< 0.1%
Memory size20.7 KiB
2024-01-10T04:51:01.225146image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length4
Mean length4.5471483
Min length2

Characters and Unicode

Total characters11959
Distinct characters122
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

Unique139 ?
Unique (%)5.3%

Sample

1st row김영춘 의원 등 4인
2nd row박상우 의원 등 11인
3rd row의장
4th row송복섭 의원 등 5인
5th row의장
ValueCountFrequency (%)
부여군수 1505
45.9%
군수 556
 
17.0%
의원 231
 
7.1%
등 171
 
5.2%
의장 60
 
1.8%
대표발의 53
 
1.6%
5인 46
 
1.4%
6인 41
 
1.3%
송복섭 36
 
1.1%
의회운영위원회 34
 
1.0%
Other values (164) 543
 
16.6%
2024-01-10T04:51:01.501951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
군 2077
17.4%
수 2074
17.3%
부 1520
12.7%
여 1520
12.7%
646
 
5.4%
의 540
 
4.5%
원 491
 
4.1%
등 213
 
1.8%
인 212
 
1.8%
회 170
 
1.4%
Other values (112) 2496
20.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 10996
91.9%
Space Separator 646
 
5.4%
Decimal Number 309
 
2.6%
Other Punctuation 4
 
< 0.1%
Open Punctuation 2
 
< 0.1%
Close Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
군 2077
18.9%
수 2074
18.9%
부 1520
13.8%
여 1520
13.8%
의 540
 
4.9%
원 491
 
4.5%
등 213
 
1.9%
인 212
 
1.9%
회 170
 
1.5%
위 160
 
1.5%
Other values (97) 2019
18.4%
Decimal Number
ValueCountFrequency (%)
5 83
26.9%
6 65
21.0%
3 48
15.5%
4 44
14.2%
1 31
 
10.0%
0 10
 
3.2%
2 8
 
2.6%
7 8
 
2.6%
9 7
 
2.3%
8 5
 
1.6%
Other Punctuation
ValueCountFrequency (%)
. 3
75.0%
/ 1
 
25.0%
Space Separator
ValueCountFrequency (%)
646
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 10996
91.9%
Common 963
 
8.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
군 2077
18.9%
수 2074
18.9%
부 1520
13.8%
여 1520
13.8%
의 540
 
4.9%
원 491
 
4.5%
등 213
 
1.9%
인 212
 
1.9%
회 170
 
1.5%
위 160
 
1.5%
Other values (97) 2019
18.4%
Common
ValueCountFrequency (%)
646
67.1%
5 83
 
8.6%
6 65
 
6.7%
3 48
 
5.0%
4 44
 
4.6%
1 31
 
3.2%
0 10
 
1.0%
2 8
 
0.8%
7 8
 
0.8%
9 7
 
0.7%
Other values (5) 13
 
1.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 10996
91.9%
ASCII 963
 
8.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
군 2077
18.9%
수 2074
18.9%
부 1520
13.8%
여 1520
13.8%
의 540
 
4.9%
원 491
 
4.5%
등 213
 
1.9%
인 212
 
1.9%
회 170
 
1.5%
위 160
 
1.5%
Other values (97) 2019
18.4%
ASCII
ValueCountFrequency (%)
646
67.1%
5 83
 
8.6%
6 65
 
6.7%
3 48
 
5.0%
4 44
 
4.6%
1 31
 
3.2%
0 10
 
1.0%
2 8
 
0.8%
7 8
 
0.8%
9 7
 
0.7%
Other values (5) 13
 
1.3%

발의일
Text

Distinct676
Distinct (%)25.7%
Missing1
Missing (%)< 0.1%
Memory size20.7 KiB
2024-01-10T04:51:01.756626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length9.9897338
Min length1

Characters and Unicode

Total characters26273
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

Unique318 ?
Unique (%)12.1%

Sample

1st row2023-07-31
2nd row2023-07-28
3rd row2023-07-17
4th row2023-07-17
5th row2023-07-17
ValueCountFrequency (%)
2016-11-15 49
 
1.9%
2021-11-18 39
 
1.5%
2015-10-14 37
 
1.4%
2018-11-14 37
 
1.4%
2022-03-08 31
 
1.2%
2022-11-21 27
 
1.0%
2017-11-10 27
 
1.0%
2017-10-11 26
 
1.0%
2022-09-07 24
 
0.9%
2019-11-11 24
 
0.9%
Other values (666) 2309
87.8%
2024-01-10T04:51:02.158123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 5670
21.6%
- 5257
20.0%
1 4968
18.9%
2 4177
15.9%
9 1996
 
7.6%
5 802
 
3.1%
7 762
 
2.9%
3 692
 
2.6%
6 676
 
2.6%
4 671
 
2.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 21016
80.0%
Dash Punctuation 5257
 
20.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 5670
27.0%
1 4968
23.6%
2 4177
19.9%
9 1996
 
9.5%
5 802
 
3.8%
7 762
 
3.6%
3 692
 
3.3%
6 676
 
3.2%
4 671
 
3.2%
8 602
 
2.9%
Dash Punctuation
ValueCountFrequency (%)
- 5257
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 26273
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 5670
21.6%
- 5257
20.0%
1 4968
18.9%
2 4177
15.9%
9 1996
 
7.6%
5 802
 
3.1%
7 762
 
2.9%
3 692
 
2.6%
6 676
 
2.6%
4 671
 
2.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 26273
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 5670
21.6%
- 5257
20.0%
1 4968
18.9%
2 4177
15.9%
9 1996
 
7.6%
5 802
 
3.1%
7 762
 
2.9%
3 692
 
2.6%
6 676
 
2.6%
4 671
 
2.6%

소관위원회
Categorical

Distinct16
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size20.7 KiB
총무위원회
1251 
산업건설위원회
419 
본회의
245 
<NA>
231 
사회산업위원회행정사무감사
173 
Other values (11)
312 

Length

Max length22
Median length13
Mean length5.9901178
Min length3

Unique

Unique3 ?
Unique (%)0.1%

Sample

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

Common Values

ValueCountFrequency (%)
총무위원회 1251
47.5%
산업건설위원회 419
 
15.9%
본회의 245
 
9.3%
<NA> 231
 
8.8%
사회산업위원회행정사무감사 173
 
6.6%
예산결산특별위원회 109
 
4.1%
의회운영위원회 103
 
3.9%
총무위원회행정사무감사 42
 
1.6%
행정사무감사특별위원회 24
 
0.9%
운영위원회 23
 
0.9%
Other values (6) 11
 
0.4%

Length

2024-01-10T04:51:02.494274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
총무위원회 1251
47.5%
산업건설위원회 419
 
15.9%
본회의 245
 
9.3%
na 231
 
8.8%
사회산업위원회행정사무감사 173
 
6.6%
예산결산특별위원회 109
 
4.1%
의회운영위원회 103
 
3.9%
총무위원회행정사무감사 42
 
1.6%
행정사무감사특별위원회 24
 
0.9%
운영위원회 23
 
0.9%
Other values (6) 11
 
0.4%

처리결과
Categorical

IMBALANCE 

Distinct11
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size20.7 KiB
처리-가결(원안)
1249 
<NA>
1113 
처리-가결(수정)
175 
처리-부결
 
33
처리
 
20
Other values (6)
 
41

Length

Max length9
Median length9
Mean length6.7054352
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

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

Common Values

ValueCountFrequency (%)
처리-가결(원안) 1249
47.5%
<NA> 1113
42.3%
처리-가결(수정) 175
 
6.7%
처리-부결 33
 
1.3%
처리 20
 
0.8%
찬성의견 14
 
0.5%
처리-폐기 12
 
0.5%
처리-철회 6
 
0.2%
미처리 5
 
0.2%
보류 3
 
0.1%

Length

2024-01-10T04:51:02.608178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
처리-가결(원안 1249
47.5%
na 1113
42.3%
처리-가결(수정 175
 
6.7%
처리-부결 33
 
1.3%
처리 20
 
0.8%
찬성의견 14
 
0.5%
처리-폐기 12
 
0.5%
처리-철회 6
 
0.2%
미처리 5
 
0.2%
보류 3
 
0.1%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size20.7 KiB
Minimum2023-10-12 00:00:00
Maximum2023-10-12 00:00:00
2024-01-10T04:51:02.690236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T04:51:02.755667image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

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

Correlations

2024-01-10T04:51:02.807649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
의안번호소관위원회처리결과
의안번호1.0000.5630.136
소관위원회0.5631.0000.377
처리결과0.1360.3771.000
2024-01-10T04:51:02.871625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
소관위원회처리결과
소관위원회1.0000.170
처리결과0.1701.000
2024-01-10T04:51:02.934389image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
의안번호소관위원회처리결과
의안번호1.0000.2470.062
소관위원회0.2471.0000.170
처리결과0.0620.1701.000

Missing values

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

의안번호의안명발의자발의일소관위원회처리결과데이터기준일자
028132023년도 제3회 일반 및 특별회계 추가경정예산안 수정동의안김영춘 의원 등 4인2023-07-31<NA><NA>2023-10-12
12826집중호우 피해 중소기업 특별지원 촉구 건의안박상우 의원 등 11인2023-07-28<NA><NA>2023-10-12
22825예산결산특별위원회 구성의 건의장2023-07-17<NA><NA>2023-10-12
32824관계공무원 출석 요구의 건송복섭 의원 등 5인2023-07-17<NA><NA>2023-10-12
42823회기 결정의 건의장2023-07-17<NA><NA>2023-10-12
52822고령자 장애인 주택 개조사업 민간위탁 동의안부여군수2023-07-07산업건설위원회처리-가결(원안)2023-10-12
62821부여군 123사비공예마을 시설물 관리ㆍ운영 조례안부여군수2023-07-07산업건설위원회처리-가결(원안)2023-10-12
72820부여군 만수산자연휴양림 관리 및 운영 조례 일부개정조례안부여군수2023-07-07산업건설위원회처리-가결(원안)2023-10-12
82819부여군 택시운송사업 발전 및 지원에 관한 조례 일부개정조례안부여군수2023-07-07산업건설위원회처리-가결(원안)2023-10-12
92818부여군 외국인주민 및 다문화가족 지원 조례 일부개정조례안부여군수2023-07-07총무위원회처리-가결(수정)2023-10-12
의안번호의안명발의자발의일소관위원회처리결과데이터기준일자
262110정수물품취득승인요청안(91.10.14. 수정안)부여군수1991-10-01본회의<NA>2023-10-12
2622991제2회추경예산(심의)안부여군수1991-10-01본회의<NA>2023-10-12
26238부여군이장자녀장학금지급조례중개정조례안부여군수1991-07-24본회의<NA>2023-10-12
26247부여군지방세징수포상금지급조례중개정조례안부여군수1991-07-24본회의<NA>2023-10-12
26256부여군공공용지에편입된사권토지에대한종합토지세불균일과세에대한조례중개정조례안부여군수1991-07-24본회의<NA>2023-10-12
26265부여군수입증지조례중개정조례안부여군수1991-07-24본회의<NA>2023-10-12
2627491공유재산관리계획변경의건부여군수1991-07-24본회의<NA>2023-10-12
2628391공유재산관리계획변경의건부여군수1991-05-31본회의<NA>2023-10-12
2629290결산검사위원선임의건부여군수1991-05-31본회의<NA>2023-10-12
2630191군도및농어촌소득원도로확포장채무부담의건부여군수1991-05-31본회의<NA>2023-10-12