Overview

Dataset statistics

Number of variables9
Number of observations2607
Missing cells75
Missing cells (%)0.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory186.0 KiB
Average record size in memory73.1 B

Variable types

Categorical4
Numeric1
Text2
DateTime2

Dataset

Description경기도 포천시 의회홈페이지시스템에서 제공하는 의회의안정보(기관명, 의안번호, 의안명, 발의자, 소관위원회 등 제공)데이터 입니다.
Author경기도 포천시
URLhttps://www.data.go.kr/data/15061914/fileData.do

Alerts

기관명 has constant value ""Constant
데이터기준일 has constant value ""Constant
본회의처리결과 is highly imbalanced (79.6%)Imbalance
본회의처리일 has 59 (2.3%) missing valuesMissing

Reproduction

Analysis started2023-12-12 01:39:09.111151
Analysis finished2023-12-12 01:39:10.475329
Duration1.36 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size20.5 KiB
포천시의회
2607 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row포천시의회
2nd row포천시의회
3rd row포천시의회
4th row포천시의회
5th row포천시의회

Common Values

ValueCountFrequency (%)
포천시의회 2607
100.0%

Length

2023-12-12T10:39:10.576678image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T10:39:10.703690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
포천시의회 2607
100.0%

의안번호
Real number (ℝ)

Distinct2194
Distinct (%)84.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17328.11
Minimum1
Maximum40486
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.0 KiB
2023-12-12T10:39:10.851541image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile66
Q1327
median20466
Q330345.5
95-th percentile40355.7
Maximum40486
Range40485
Interquartile range (IQR)30018.5

Descriptive statistics

Standard deviation16066.725
Coefficient of variation (CV)0.9272058
Kurtosis-1.600102
Mean17328.11
Median Absolute Deviation (MAD)19798
Skewness0.12726747
Sum45174384
Variance2.5813964 × 108
MonotonicityNot monotonic
2023-12-12T10:39:11.079809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
373 3
 
0.1%
374 3
 
0.1%
375 3
 
0.1%
404 2
 
0.1%
115 2
 
0.1%
123 2
 
0.1%
122 2
 
0.1%
121 2
 
0.1%
120 2
 
0.1%
119 2
 
0.1%
Other values (2184) 2584
99.1%
ValueCountFrequency (%)
1 2
0.1%
2 2
0.1%
3 2
0.1%
4 2
0.1%
5 2
0.1%
6 2
0.1%
7 2
0.1%
8 2
0.1%
9 2
0.1%
10 2
0.1%
ValueCountFrequency (%)
40486 1
< 0.1%
40485 1
< 0.1%
40484 1
< 0.1%
40483 1
< 0.1%
40482 1
< 0.1%
40481 1
< 0.1%
40480 1
< 0.1%
40479 1
< 0.1%
40478 1
< 0.1%
40477 1
< 0.1%
Distinct1702
Distinct (%)65.3%
Missing0
Missing (%)0.0%
Memory size20.5 KiB
2023-12-12T10:39:11.578003image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length91
Median length69
Mean length25.757192
Min length4

Characters and Unicode

Total characters67149
Distinct characters474
Distinct categories14 ?
Distinct scripts4 ?
Distinct blocks9 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1352 ?
Unique (%)51.9%

Sample

1st row제148회 포천시의회(임시회) 회기 결정의 건
2nd row제148회 포천시의회(임시회) 회의록 서명의원 선출의 건
3rd row조례등심사특별위원회 구성 결의안
4th row조례등심사특별위원회 위원 선임의 건
5th row예산결산특별위원회 구성 결의안
ValueCountFrequency (%)
포천시 1224
 
8.4%
조례 838
 
5.7%
757
 
5.2%
652
 
4.5%
일부개정조례안 629
 
4.3%
조례안 354
 
2.4%
관한 344
 
2.4%
설치 262
 
1.8%
운영 224
 
1.5%
포천시의회(임시회 195
 
1.3%
Other values (2040) 9147
62.5%
2023-12-12T10:39:12.352998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
12019
 
17.9%
2466
 
3.7%
2377
 
3.5%
2306
 
3.4%
2253
 
3.4%
2187
 
3.3%
1856
 
2.8%
1771
 
2.6%
1762
 
2.6%
1654
 
2.5%
Other values (464) 36498
54.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 50858
75.7%
Space Separator 12019
 
17.9%
Decimal Number 2542
 
3.8%
Close Punctuation 607
 
0.9%
Open Punctuation 606
 
0.9%
Other Punctuation 410
 
0.6%
Math Symbol 47
 
0.1%
Uppercase Letter 24
 
< 0.1%
Lowercase Letter 19
 
< 0.1%
Dash Punctuation 7
 
< 0.1%
Other values (4) 10
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
2466
 
4.8%
2377
 
4.7%
2306
 
4.5%
2253
 
4.4%
2187
 
4.3%
1856
 
3.6%
1771
 
3.5%
1762
 
3.5%
1654
 
3.3%
1195
 
2.3%
Other values (414) 31031
61.0%
Lowercase Letter
ValueCountFrequency (%)
l 4
21.1%
s 3
15.8%
o 2
10.5%
i 2
10.5%
e 2
10.5%
y 1
 
5.3%
r 1
 
5.3%
v 1
 
5.3%
a 1
 
5.3%
t 1
 
5.3%
Decimal Number
ValueCountFrequency (%)
1 582
22.9%
0 571
22.5%
2 532
20.9%
3 151
 
5.9%
4 145
 
5.7%
9 128
 
5.0%
6 119
 
4.7%
5 115
 
4.5%
7 101
 
4.0%
8 98
 
3.9%
Uppercase Letter
ValueCountFrequency (%)
L 4
16.7%
H 3
12.5%
U 3
12.5%
C 3
12.5%
O 3
12.5%
M 3
12.5%
G 2
8.3%
N 1
 
4.2%
B 1
 
4.2%
A 1
 
4.2%
Close Punctuation
ValueCountFrequency (%)
) 582
95.9%
] 21
 
3.5%
3
 
0.5%
} 1
 
0.2%
Other Punctuation
ValueCountFrequency (%)
, 177
43.2%
. 170
41.5%
· 36
 
8.8%
: 27
 
6.6%
Open Punctuation
ValueCountFrequency (%)
( 581
95.9%
[ 22
 
3.6%
3
 
0.5%
Other Number
ValueCountFrequency (%)
2
66.7%
1
33.3%
Space Separator
ValueCountFrequency (%)
12019
100.0%
Math Symbol
ValueCountFrequency (%)
~ 47
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%
Initial Punctuation
ValueCountFrequency (%)
3
100.0%
Final Punctuation
ValueCountFrequency (%)
3
100.0%
Letter Number
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 50854
75.7%
Common 16247
 
24.2%
Latin 44
 
0.1%
Han 4
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
2466
 
4.8%
2377
 
4.7%
2306
 
4.5%
2253
 
4.4%
2187
 
4.3%
1856
 
3.6%
1771
 
3.5%
1762
 
3.5%
1654
 
3.3%
1195
 
2.3%
Other values (410) 31027
61.0%
Common
ValueCountFrequency (%)
12019
74.0%
1 582
 
3.6%
) 582
 
3.6%
( 581
 
3.6%
0 571
 
3.5%
2 532
 
3.3%
, 177
 
1.1%
. 170
 
1.0%
3 151
 
0.9%
4 145
 
0.9%
Other values (18) 737
 
4.5%
Latin
ValueCountFrequency (%)
L 4
 
9.1%
l 4
 
9.1%
s 3
 
6.8%
H 3
 
6.8%
U 3
 
6.8%
C 3
 
6.8%
O 3
 
6.8%
M 3
 
6.8%
G 2
 
4.5%
o 2
 
4.5%
Other values (12) 14
31.8%
Han
ValueCountFrequency (%)
1
25.0%
1
25.0%
1
25.0%
1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 50848
75.7%
ASCII 16239
 
24.2%
None 42
 
0.1%
Compat Jamo 6
 
< 0.1%
Punctuation 6
 
< 0.1%
Enclosed Alphanum 3
 
< 0.1%
CJK 3
 
< 0.1%
Number Forms 1
 
< 0.1%
CJK Compat Ideographs 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
12019
74.0%
1 582
 
3.6%
) 582
 
3.6%
( 581
 
3.6%
0 571
 
3.5%
2 532
 
3.3%
, 177
 
1.1%
. 170
 
1.0%
3 151
 
0.9%
4 145
 
0.9%
Other values (32) 729
 
4.5%
Hangul
ValueCountFrequency (%)
2466
 
4.8%
2377
 
4.7%
2306
 
4.5%
2253
 
4.4%
2187
 
4.3%
1856
 
3.7%
1771
 
3.5%
1762
 
3.5%
1654
 
3.3%
1195
 
2.4%
Other values (408) 31021
61.0%
None
ValueCountFrequency (%)
· 36
85.7%
3
 
7.1%
3
 
7.1%
Compat Jamo
ValueCountFrequency (%)
5
83.3%
1
 
16.7%
Punctuation
ValueCountFrequency (%)
3
50.0%
3
50.0%
Enclosed Alphanum
ValueCountFrequency (%)
2
66.7%
1
33.3%
Number Forms
ValueCountFrequency (%)
1
100.0%
CJK Compat Ideographs
ValueCountFrequency (%)
1
100.0%
CJK
ValueCountFrequency (%)
1
33.3%
1
33.3%
1
33.3%
Distinct225
Distinct (%)8.6%
Missing0
Missing (%)0.0%
Memory size20.5 KiB
2023-12-12T10:39:12.753688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length32
Median length30
Mean length4.7057921
Min length2

Characters and Unicode

Total characters12268
Distinct characters142
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

Unique130 ?
Unique (%)5.0%

Sample

1st row의장
2nd row의장
3rd row손세화의원등6명
4th row의장
5th row송상국의원등6명
ValueCountFrequency (%)
포천시장 1136
32.3%
의장 540
15.3%
시장 340
 
9.7%
292
 
8.3%
의원 234
 
6.6%
7인 210
 
6.0%
이희승 41
 
1.2%
이원석 35
 
1.0%
윤충식 32
 
0.9%
류재빈 30
 
0.9%
Other values (186) 631
17.9%
2023-12-12T10:39:13.273014image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2107
17.2%
1487
12.1%
1204
9.8%
1145
9.3%
988
 
8.1%
914
 
7.5%
594
 
4.8%
445
 
3.6%
309
 
2.5%
7 266
 
2.2%
Other values (132) 2809
22.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 10876
88.7%
Space Separator 914
 
7.5%
Decimal Number 452
 
3.7%
Other Punctuation 26
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
2107
19.4%
1487
13.7%
1204
11.1%
1145
10.5%
988
9.1%
594
 
5.5%
445
 
4.1%
309
 
2.8%
153
 
1.4%
137
 
1.3%
Other values (120) 2307
21.2%
Decimal Number
ValueCountFrequency (%)
7 266
58.8%
6 77
 
17.0%
4 31
 
6.9%
2 28
 
6.2%
3 21
 
4.6%
5 15
 
3.3%
8 8
 
1.8%
0 4
 
0.9%
1 2
 
0.4%
Other Punctuation
ValueCountFrequency (%)
, 24
92.3%
. 2
 
7.7%
Space Separator
ValueCountFrequency (%)
914
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 10876
88.7%
Common 1392
 
11.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
2107
19.4%
1487
13.7%
1204
11.1%
1145
10.5%
988
9.1%
594
 
5.5%
445
 
4.1%
309
 
2.8%
153
 
1.4%
137
 
1.3%
Other values (120) 2307
21.2%
Common
ValueCountFrequency (%)
914
65.7%
7 266
 
19.1%
6 77
 
5.5%
4 31
 
2.2%
2 28
 
2.0%
, 24
 
1.7%
3 21
 
1.5%
5 15
 
1.1%
8 8
 
0.6%
0 4
 
0.3%
Other values (2) 4
 
0.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 10876
88.7%
ASCII 1392
 
11.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
2107
19.4%
1487
13.7%
1204
11.1%
1145
10.5%
988
9.1%
594
 
5.5%
445
 
4.1%
309
 
2.8%
153
 
1.4%
137
 
1.3%
Other values (120) 2307
21.2%
ASCII
ValueCountFrequency (%)
914
65.7%
7 266
 
19.1%
6 77
 
5.5%
4 31
 
2.2%
2 28
 
2.0%
, 24
 
1.7%
3 21
 
1.5%
5 15
 
1.1%
8 8
 
0.6%
0 4
 
0.3%
Other values (2) 4
 
0.3%

소관위원회
Categorical

Distinct16
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size20.5 KiB
본회의
855 
조례등심사특별위원회
786 
내무위원회
357 
산업건설위원회
214 
예산결산특별위원회
137 
Other values (11)
258 

Length

Max length26
Median length25
Mean length6.8342923
Min length3

Unique

Unique3 ?
Unique (%)0.1%

Sample

1st row본회의
2nd row본회의
3rd row본회의
4th row본회의
5th row본회의

Common Values

ValueCountFrequency (%)
본회의 855
32.8%
조례등심사특별위원회 786
30.1%
내무위원회 357
13.7%
산업건설위원회 214
 
8.2%
예산결산특별위원회 137
 
5.3%
운영위원회 101
 
3.9%
행정사무감사-행정사무감사특별위원회 71
 
2.7%
행정사무감사특별위원회 33
 
1.3%
조례정비특별위원회 32
 
1.2%
사격장등군사시설피해보상촉구특별위원회 7
 
0.3%
Other values (6) 14
 
0.5%

Length

2023-12-12T10:39:13.465448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
본회의 855
32.8%
조례등심사특별위원회 786
30.1%
내무위원회 357
13.7%
산업건설위원회 214
 
8.2%
예산결산특별위원회 137
 
5.3%
운영위원회 101
 
3.9%
행정사무감사-행정사무감사특별위원회 71
 
2.7%
행정사무감사특별위원회 33
 
1.3%
조례정비특별위원회 32
 
1.2%
사격장등군사시설피해보상촉구특별위원회 7
 
0.3%
Other values (6) 14
 
0.5%
Distinct531
Distinct (%)20.5%
Missing16
Missing (%)0.6%
Memory size20.5 KiB
Minimum2006-06-30 00:00:00
Maximum2020-04-02 00:00:00
2023-12-12T10:39:13.632991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:39:13.811412image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

본회의처리일
Date

MISSING 

Distinct268
Distinct (%)10.5%
Missing59
Missing (%)2.3%
Memory size20.5 KiB
Minimum2006-07-10 00:00:00
Maximum2020-04-03 00:00:00
2023-12-12T10:39:14.002540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:39:14.192428image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

본회의처리결과
Categorical

IMBALANCE 

Distinct9
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size20.5 KiB
원안가결
2351 
수정가결
 
158
<NA>
 
34
계류
 
24
기타
 
19
Other values (4)
 
21

Length

Max length5
Median length4
Mean length3.9658611
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row원안가결
2nd row원안가결
3rd row원안가결
4th row원안가결
5th row원안가결

Common Values

ValueCountFrequency (%)
원안가결 2351
90.2%
수정가결 158
 
6.1%
<NA> 34
 
1.3%
계류 24
 
0.9%
기타 19
 
0.7%
부결 7
 
0.3%
상정후철회 7
 
0.3%
의견서채택 4
 
0.2%
의견없음 3
 
0.1%

Length

2023-12-12T10:39:14.385486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T10:39:14.553035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
원안가결 2351
90.2%
수정가결 158
 
6.1%
na 34
 
1.3%
계류 24
 
0.9%
기타 19
 
0.7%
부결 7
 
0.3%
상정후철회 7
 
0.3%
의견서채택 4
 
0.2%
의견없음 3
 
0.1%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size20.5 KiB
2020-06-30
2607 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2020-06-30
2nd row2020-06-30
3rd row2020-06-30
4th row2020-06-30
5th row2020-06-30

Common Values

ValueCountFrequency (%)
2020-06-30 2607
100.0%

Length

2023-12-12T10:39:14.746011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T10:39:14.874294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020-06-30 2607
100.0%

Interactions

2023-12-12T10:39:09.774685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T10:39:14.980924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
의안번호소관위원회본회의처리결과
의안번호1.0000.7750.259
소관위원회0.7751.0000.362
본회의처리결과0.2590.3621.000
2023-12-12T10:39:15.140310image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
소관위원회본회의처리결과
소관위원회1.0000.134
본회의처리결과0.1341.000
2023-12-12T10:39:15.246212image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
의안번호소관위원회본회의처리결과
의안번호1.0000.4720.118
소관위원회0.4721.0000.134
본회의처리결과0.1180.1341.000

Missing values

2023-12-12T10:39:09.985763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T10:39:10.207462image/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-12T10:39:10.389310image/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

기관명의안번호의안명발의자소관위원회발의일본회의처리일본회의처리결과데이터기준일
0포천시의회404제148회 포천시의회(임시회) 회기 결정의 건의장본회의2020-04-022020-04-02원안가결2020-06-30
1포천시의회405제148회 포천시의회(임시회) 회의록 서명의원 선출의 건의장본회의2020-04-022020-04-02원안가결2020-06-30
2포천시의회406조례등심사특별위원회 구성 결의안손세화의원등6명본회의2020-03-272020-04-02원안가결2020-06-30
3포천시의회407조례등심사특별위원회 위원 선임의 건의장본회의2020-04-022020-04-02원안가결2020-06-30
4포천시의회408예산결산특별위원회 구성 결의안송상국의원등6명본회의2020-03-272020-04-02원안가결2020-06-30
5포천시의회409예산결산특별위원회 위원 선임의 건의장본회의2020-04-022020-04-02원안가결2020-06-30
6포천시의회410포천시 재난기본소득 지급 조례안강준모의원등7명본회의2020-03-312020-04-03원안가결2020-06-30
7포천시의회4112020년도 제2회 추가경정 예산안포천시장예산결산특별위원회2020-03-312020-04-03수정가결2020-06-30
8포천시의회376예산결산특별위원회 구성 결의안임종훈본회의2020-03-122020-03-19원안가결2020-06-30
9포천시의회377예산결산특별위원회 위원 선임의 건의장본회의2020-03-192020-03-19원안가결2020-06-30
기관명의안번호의안명발의자소관위원회발의일본회의처리일본회의처리결과데이터기준일
2597포천시의회20301제26회 포천시의회(임시회)회기결정의건의장본회의2006-07-102006-07-10원안가결2020-06-30
2598포천시의회20302제26회 포천시의회(임시회)회의록서명의원 선출의건의장본회의2006-07-102006-07-10원안가결2020-06-30
2599포천시의회246제111회 포천시의회(임시회) 회기 결정의 건이명희 의원 등 7인본회의<NA>2015-10-14원안가결2020-06-30
2600포천시의회107행복연합기숙사 입사생 선발 및 입사 지원에 관한 조례안포천시장본회의<NA><NA>상정후철회2020-06-30
2601포천시의회373장자, 용정일반산업단지 분양에 관한 행정사무 조사특별위원회 활동기간연장의건장자,용정 일반산업단지 분양에 관한 행정사무 조사특별위원회본회의<NA>2020-02-12원안가결2020-06-30
2602포천시의회374제147회 포천시의회(임시회) 회기 결정의 건의장본회의<NA><NA>원안가결2020-06-30
2603포천시의회375제147회 포천시의회(임시회) 회의록 서명의원 선출의 건의장본회의<NA><NA>원안가결2020-06-30
2604포천시의회209제110회 포천시의회(임시회) 회기 결정의 건의장본회의<NA>2015-09-08원안가결2020-06-30
2605포천시의회211조례등심사특별위원회 구성결의안이원석본회의<NA>2015-09-08원안가결2020-06-30
2606포천시의회213행정사무감사특별위원회 구성 결의안류재빈본회의<NA>2015-09-08원안가결2020-06-30