Overview

Dataset statistics

Number of variables21
Number of observations272
Missing cells1615
Missing cells (%)28.3%
Duplicate rows21
Duplicate rows (%)7.7%
Total size in memory44.8 KiB
Average record size in memory168.5 B

Variable types

Unsupported15
Categorical5
Text1

Dataset

Description강원도 철원군 의회 제1대 ~ 8대 현재까지 의안 처리 현황 정보입니다.
Author강원도 철원군
URLhttps://www.data.go.kr/data/15038033/fileData.do

Alerts

Dataset has 21 (7.7%) duplicate rowsDuplicates
Unnamed: 4 is highly imbalanced (60.6%)Imbalance
Unnamed: 7 is highly imbalanced (83.5%)Imbalance
Unnamed: 12 is highly imbalanced (84.4%)Imbalance
Unnamed: 17 is highly imbalanced (59.8%)Imbalance
Unnamed: 6 has 33 (12.1%) missing valuesMissing
Unnamed: 8 has 258 (94.9%) missing valuesMissing
Unnamed: 9 has 257 (94.5%) missing valuesMissing
Unnamed: 10 has 257 (94.5%) missing valuesMissing
Unnamed: 11 has 257 (94.5%) missing valuesMissing
Unnamed: 13 has 264 (97.1%) missing valuesMissing
Unnamed: 14 has 3 (1.1%) missing valuesMissing
Unnamed: 15 has 4 (1.5%) missing valuesMissing
Unnamed: 16 has 5 (1.8%) missing valuesMissing
Unnamed: 18 has 33 (12.1%) missing valuesMissing
Unnamed: 19 has 117 (43.0%) missing valuesMissing
Unnamed: 20 has 119 (43.8%) missing valuesMissing
의안처리부 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 1 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 5 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 6 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 9 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 11 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 13 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 14 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 15 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 16 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 18 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 19 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 20 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 06:02:25.682724
Analysis finished2023-12-12 06:02:25.931958
Duration0.25 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

의안처리부
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.7%
Memory size2.3 KiB

Unnamed: 1
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.7%
Memory size2.3 KiB

Unnamed: 2
Categorical

Distinct9
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
조례
166 
기타
47 
동의
28 
예산 결산
17 
승인
 
5
Other values (4)
 
9

Length

Max length5
Median length2
Mean length2.2022059
Min length2

Unique

Unique1 ?
Unique (%)0.4%

Sample

1st row<NA>
2nd row종류
3rd row<NA>
4th row동의
5th row동의

Common Values

ValueCountFrequency (%)
조례 166
61.0%
기타 47
 
17.3%
동의 28
 
10.3%
예산 결산 17
 
6.2%
승인 5
 
1.8%
결의 3
 
1.1%
건의 3
 
1.1%
<NA> 2
 
0.7%
종류 1
 
0.4%

Length

2023-12-12T15:02:26.007217image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:02:26.135517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
조례 166
57.4%
기타 47
 
16.3%
동의 28
 
9.7%
예산 17
 
5.9%
결산 17
 
5.9%
승인 5
 
1.7%
결의 3
 
1.0%
건의 3
 
1.0%
na 2
 
0.7%
종류 1
 
0.3%

Unnamed: 3
Text

Distinct212
Distinct (%)78.5%
Missing2
Missing (%)0.7%
Memory size2.3 KiB
2023-12-12T15:02:26.373032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length45
Median length37
Mean length20.255556
Min length2

Characters and Unicode

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

Unique

Unique181 ?
Unique (%)67.0%

Sample

1st row건명
2nd row읍면경계조정 대상지역 심의안
3rd row91년도철원군군유재산 관리계획 승인안
4th row부군수및실과소장 출석요구의건
5th row90회계년도세입세출결산 검사위원선임
ValueCountFrequency (%)
개정조례안 105
 
16.7%
조례안 29
 
4.6%
및 18
 
2.9%
조례중 15
 
2.4%
구성결의안 12
 
1.9%
군수및관계공무원출석요구의건 10
 
1.6%
동의안 9
 
1.4%
예산결산특별위원회 7
 
1.1%
에관한 6
 
1.0%
철원군공유재산관리조례중 6
 
1.0%
Other values (310) 410
65.4%
2023-12-12T15:02:26.771323image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
조 307
 
5.6%
례 295
 
5.4%
원 244
 
4.5%
안 223
 
4.1%
군 211
 
3.9%
195
 
3.6%
정 179
 
3.3%
철 178
 
3.3%
176
 
3.2%
의 145
 
2.7%
Other values (212) 3316
60.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4937
90.3%
Control 195
 
3.6%
Space Separator 176
 
3.2%
Decimal Number 149
 
2.7%
Close Punctuation 4
 
0.1%
Other Punctuation 4
 
0.1%
Open Punctuation 4
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
조 307
 
6.2%
례 295
 
6.0%
원 244
 
4.9%
안 223
 
4.5%
군 211
 
4.3%
정 179
 
3.6%
철 178
 
3.6%
의 145
 
2.9%
관 135
 
2.7%
개 127
 
2.6%
Other values (199) 2893
58.6%
Decimal Number
ValueCountFrequency (%)
9 62
41.6%
2 25
16.8%
3 23
 
15.4%
4 16
 
10.7%
1 14
 
9.4%
5 6
 
4.0%
0 2
 
1.3%
7 1
 
0.7%
Control
ValueCountFrequency (%)
195
100.0%
Space Separator
ValueCountFrequency (%)
176
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Other Punctuation
ValueCountFrequency (%)
, 4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4937
90.3%
Common 532
 
9.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
조 307
 
6.2%
례 295
 
6.0%
원 244
 
4.9%
안 223
 
4.5%
군 211
 
4.3%
정 179
 
3.6%
철 178
 
3.6%
의 145
 
2.9%
관 135
 
2.7%
개 127
 
2.6%
Other values (199) 2893
58.6%
Common
ValueCountFrequency (%)
195
36.7%
176
33.1%
9 62
 
11.7%
2 25
 
4.7%
3 23
 
4.3%
4 16
 
3.0%
1 14
 
2.6%
5 6
 
1.1%
) 4
 
0.8%
, 4
 
0.8%
Other values (3) 7
 
1.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4937
90.3%
ASCII 532
 
9.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
조 307
 
6.2%
례 295
 
6.0%
원 244
 
4.9%
안 223
 
4.5%
군 211
 
4.3%
정 179
 
3.6%
철 178
 
3.6%
의 145
 
2.9%
관 135
 
2.7%
개 127
 
2.6%
Other values (199) 2893
58.6%
ASCII
ValueCountFrequency (%)
195
36.7%
176
33.1%
9 62
 
11.7%
2 25
 
4.7%
3 23
 
4.3%
4 16
 
3.0%
1 14
 
2.6%
5 6
 
1.1%
) 4
 
0.8%
, 4
 
0.8%
Other values (3) 7
 
1.3%

Unnamed: 4
Categorical

IMBALANCE 

Distinct30
Distinct (%)11.0%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
철원 군수
201 
지강열 의원외5
 
15
서장원 의원외5
 
7
이희석 의원외5
 
6
마숙현 의원외5
 
4
Other values (25)
39 

Length

Max length9
Median length5
Mean length5.7022059
Min length3

Unique

Unique18 ?
Unique (%)6.6%

Sample

1st row<NA>
2nd row발의자 (제출자)
3rd row<NA>
4th row철원 군수
5th row철원 군수

Common Values

ValueCountFrequency (%)
철원 군수 201
73.9%
지강열 의원외5 15
 
5.5%
서장원 의원외5 7
 
2.6%
이희석 의원외5 6
 
2.2%
마숙현 의원외5 4
 
1.5%
김영석 의원외2 4
 
1.5%
지강열 의원외2 4
 
1.5%
이희석 의원외2 3
 
1.1%
김영석 의원외5 3
 
1.1%
서장원 의원외2 3
 
1.1%
Other values (20) 22
 
8.1%

Length

2023-12-12T15:02:26.992818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
철원 201
37.3%
군수 201
37.3%
의원외5 38
 
7.1%
지강열 24
 
4.5%
의원외2 16
 
3.0%
서장원 12
 
2.2%
이희석 12
 
2.2%
김영석 7
 
1.3%
마숙현 5
 
0.9%
김규세 4
 
0.7%
Other values (9) 19
 
3.5%

Unnamed: 5
Unsupported

REJECTED  UNSUPPORTED 

Missing2
Missing (%)0.7%
Memory size2.3 KiB

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing33
Missing (%)12.1%
Memory size2.3 KiB

Unnamed: 7
Categorical

IMBALANCE 

Distinct6
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
<NA>
255 
예산결산 특별위원회
 
12
청원심사 특별위원회
 
2
소 관 위원회
 
1
철외요구(환경67430-685(93.5.20))
 
1

Length

Max length26
Median length4
Mean length4.4375
Min length4

Unique

Unique3 ?
Unique (%)1.1%

Sample

1st row<NA>
2nd row소 관 위원회
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 255
93.8%
예산결산 특별위원회 12
 
4.4%
청원심사 특별위원회 2
 
0.7%
소 관 위원회 1
 
0.4%
철외요구(환경67430-685(93.5.20)) 1
 
0.4%
냉해피해조사 특별위원회 1
 
0.4%

Length

2023-12-12T15:02:27.135221image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:02:27.259165image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 255
88.2%
특별위원회 15
 
5.2%
예산결산 12
 
4.2%
청원심사 2
 
0.7%
소 1
 
0.3%
관 1
 
0.3%
위원회 1
 
0.3%
철외요구(환경67430-685(93.5.20 1
 
0.3%
냉해피해조사 1
 
0.3%

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing258
Missing (%)94.9%
Memory size2.3 KiB

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing257
Missing (%)94.5%
Memory size2.3 KiB

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing257
Missing (%)94.5%
Memory size2.3 KiB

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing257
Missing (%)94.5%
Memory size2.3 KiB

Unnamed: 12
Categorical

IMBALANCE 

Distinct5
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
<NA>
259 
수정 의결
 
5
원안 가결
 
5
원안 의결
 
2
결과
 
1

Length

Max length5
Median length4
Mean length4.0367647
Min length2

Unique

Unique1 ?
Unique (%)0.4%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 259
95.2%
수정 의결 5
 
1.8%
원안 가결 5
 
1.8%
원안 의결 2
 
0.7%
결과 1
 
0.4%

Length

2023-12-12T15:02:27.434883image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:02:27.564085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 259
91.2%
의결 7
 
2.5%
원안 7
 
2.5%
수정 5
 
1.8%
가결 5
 
1.8%
결과 1
 
0.4%

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing264
Missing (%)97.1%
Memory size2.3 KiB

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)1.1%
Memory size2.3 KiB

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)1.5%
Memory size2.3 KiB

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5
Missing (%)1.8%
Memory size2.3 KiB

Unnamed: 17
Categorical

IMBALANCE 

Distinct14
Distinct (%)5.1%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
원안 가결
180 
원안 의결
63 
수정 의결
 
12
<NA>
 
5
가결
 
2
Other values (9)
 
10

Length

Max length8
Median length5
Mean length4.9338235
Min length2

Unique

Unique8 ?
Unique (%)2.9%

Sample

1st row<NA>
2nd row<NA>
3rd row결과
4th row원안 가결
5th row원안 가결

Common Values

ValueCountFrequency (%)
원안 가결 180
66.2%
원안 의결 63
 
23.2%
수정 의결 12
 
4.4%
<NA> 5
 
1.8%
가결 2
 
0.7%
수정 가결 2
 
0.7%
결과 1
 
0.4%
선임 1
 
0.4%
보류 1
 
0.4%
이전 신축 불가 1
 
0.4%
Other values (4) 4
 
1.5%

Length

2023-12-12T15:02:27.721028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
원안 244
45.6%
가결 184
34.4%
의결 76
 
14.2%
수정 14
 
2.6%
na 5
 
0.9%
선임 2
 
0.4%
불가 2
 
0.4%
결과 1
 
0.2%
보류 1
 
0.2%
이전 1
 
0.2%
Other values (5) 5
 
0.9%

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing33
Missing (%)12.1%
Memory size2.3 KiB

Unnamed: 19
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing117
Missing (%)43.0%
Memory size2.3 KiB

Unnamed: 20
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing119
Missing (%)43.8%
Memory size2.3 KiB

Sample

의안처리부Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20
0NaNNaN<NA><NA><NA>NaNNaN<NA>NaNNaNNaNNaN<NA>NaNNaNNaNNaN<NA>NaNNaNNaN
1연번의안\n번호종류건명발의자 (제출자)발의일\n(제출일)본회의\n보고일소 관 위원회위 원 회NaNNaNNaN<NA>심 사\n보고회\n접수일본회의NaNNaN<NA>자 치\n단 체\n이송일공포\n일공포\n번호
2NaNNaN<NA><NA><NA>NaNNaN<NA>회부\n일보고\n일상정\n일처리\n일결과NaN보고\n일상정\n일처리\n일결과NaNNaNNaN
311동의읍면경계조정 대상지역 심의안철원 군수91.\n4.3091.\n5. 1<NA>NaNNaNNaNNaN<NA>NaN91\n5. 191\n5. 391\n5. 3원안 가결91\n5. 4NaNNaN
422동의91년도철원군군유재산 관리계획 승인안철원 군수4.35. 1<NA>NaNNaNNaNNaN<NA>NaN5. 15. 35. 3원안 가결5. 4NaNNaN
533기타부군수및실과소장 출석요구의건마숙현 의원외55. 15. 1<NA>NaNNaNNaNNaN<NA>NaN5. 15. 15. 1가결5. 1NaNNaN
644기타90회계년도세입세출결산 검사위원선임철원 군수6. 16.13<NA>NaNNaNNaNNaN<NA>NaN6.136.136.13선임6.17NaNNaN
755조례철원군읍면장미임용 행정구역의 행정관리에대한 조례철원 군수6. 16.13<NA>NaNNaNNaNNaN<NA>NaN6.136.146.14원안 가결6.176.271402
866조례철원군상수도수질감시위원회 설치운영조례철원 군수6. 16.13<NA>NaNNaNNaNNaN<NA>NaN6.136.146.14원안 가결6.176.271401
977조례철원군이장정수조례중 개정조례철원 군수6. 16.13<NA>NaNNaNNaNNaN<NA>NaN6.136.146.14보류6.178.121403
의안처리부Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20
262260260조례철원군노인복지기금설치 및 운용 에관한 조례안이규화 의원외53.213.24<NA>NaNNaNNaNNaN<NA>NaN3.243.243.25원안 의결3.314.191557
263261261기타제33회철원군의회(임시회)의사일 정변경의건서장원 의원외53.253.27<NA>NaNNaNNaNNaN<NA>NaN3.273.273.27원안 의결NaNNaNNaN
264262262예산 결산95년도제1회추가경정예산안철원 군수4.114.19예산결산 특별위원회4.174.174.174.19수정 의결NaN4.194.194.19수정 의결4.2NaNNaN
265263263동의95년도철원군공유재산관리계획 제2차변경동의안철원 군수4.114.19<NA>NaNNaNNaNNaN<NA>NaN4.194.194.19원안 의결4.2NaNNaN
266264264기타예산결산특별위원회 구성결의안서장원 의원외54.174.17<NA>NaNNaNNaNNaN<NA>NaN4.174.174.17원안 의결NaNNaNNaN
267265265조례철원군한탄강종합레포츠산업육성 에관한 조례안 재의요구안철원 군수4.25. 8<NA>NaNNaNNaNNaN<NA>NaN5. 85. 85. 8원안 부결5.1NaNNaN
268266266조례철원군오수,분뇨및축산폐수의처리 에관한조례중 개정조례안철원 군수5. 35. 9<NA>NaNNaNNaNNaN<NA>NaN5. 95. 95. 9원안 의결5.15.231559
269267267조례철원군폐기물관리및자원의절약과 재활용촉진에관한과태료부과징수 조례중 개정조례안철원 군수5. 35. 9<NA>NaNNaNNaNNaN<NA>NaN5. 95. 95. 9원안 의결5.15.231558
270268268조례철원군지방공무원정원조례중 개정조례안철원 군수5.175.19<NA>NaNNaNNaNNaN<NA>NaN5.195.195.19원안 의결5.25.231560
271269269조례철원군한탄강종합레포츠산업육성 에관한 조례안서장원 의원외15.135.19<NA>NaNNaNNaNNaN<NA>NaN5.195.195.19원안 의결5.25.251561

Duplicate rows

Most frequently occurring

Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 7Unnamed: 12Unnamed: 17# duplicates
8조례철원군공유재산관리조례중 개정조례안철원 군수<NA><NA>원안 가결4
1동의92년도공유재산변경관리계획 동의안철원 군수<NA><NA>원안 가결3
4동의93년도공유재산변경관리계획 동의안철원 군수<NA><NA>원안 가결3
17조례철원군의회의원일비및여비지급에 관한조례중 개정조례안철원 군수<NA><NA>원안 가결3
0기타군수및관계공무원출석요구의건지강열 의원외5<NA><NA>원안 의결2
2동의92년도정수물품추가취득승인의건철원 군수<NA><NA>원안 가결2
3동의93년도공유재산관리계획동의안철원 군수<NA><NA>원안 가결2
5조례철원군가축사육제한에관한조례중 개정조례안철원 군수<NA><NA>원안 의결2
6조례철원군고문변호사조례중 개정조례안철원 군수<NA><NA>원안 가결2
7조례철원군공동급수시설유지관리조례 중 개정조례안철원 군수<NA><NA>원안 가결2