Overview

Dataset statistics

Number of variables7
Number of observations194
Missing cells152
Missing cells (%)11.2%
Duplicate rows1
Duplicate rows (%)0.5%
Total size in memory10.7 KiB
Average record size in memory56.7 B

Variable types

Text2
Categorical5

Dataset

Description인천광역시 남동구 의회 의안처리현황에 대한 데이터로 의안번호, 의안명, 제안자, 소관위원회, 발의일, 상태, 의결일 항목을 제공합니다.
Author인천광역시 남동구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15075589&srcSe=7661IVAWM27C61E190

Alerts

Dataset has 1 (0.5%) duplicate rowsDuplicates
발의일 is highly overall correlated with 소관위원회 and 1 other fieldsHigh correlation
의결일 is highly overall correlated with 발의일High correlation
소관위원회 is highly overall correlated with 발의일High correlation
상태 is highly imbalanced (51.7%)Imbalance
의안번호 has 76 (39.2%) missing valuesMissing
의안명 has 76 (39.2%) missing valuesMissing

Reproduction

Analysis started2024-01-28 11:06:09.359290
Analysis finished2024-01-28 11:06:09.936388
Duration0.58 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

의안번호
Text

MISSING 

Distinct118
Distinct (%)100.0%
Missing76
Missing (%)39.2%
Memory size1.6 KiB
2024-01-28T20:06:10.146546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length4
Mean length4.0508475
Min length4

Characters and Unicode

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

Unique118 ?
Unique (%)100.0%

Sample

1st row2599
2nd row2600
3rd row2601
4th row2602
5th row2603
ValueCountFrequency (%)
2628 1
 
0.8%
2689 1
 
0.8%
2686 1
 
0.8%
2685 1
 
0.8%
2684 1
 
0.8%
2683 1
 
0.8%
2682 1
 
0.8%
2681 1
 
0.8%
2680 1
 
0.8%
2679 1
 
0.8%
Other values (108) 108
91.5%
2024-01-28T20:06:10.516199image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 141
29.5%
6 121
25.3%
7 38
 
7.9%
0 35
 
7.3%
1 27
 
5.6%
5 24
 
5.0%
3 23
 
4.8%
9 23
 
4.8%
4 22
 
4.6%
8 21
 
4.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 475
99.4%
Dash Punctuation 3
 
0.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 141
29.7%
6 121
25.5%
7 38
 
8.0%
0 35
 
7.4%
1 27
 
5.7%
5 24
 
5.1%
3 23
 
4.8%
9 23
 
4.8%
4 22
 
4.6%
8 21
 
4.4%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 478
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 141
29.5%
6 121
25.3%
7 38
 
7.9%
0 35
 
7.3%
1 27
 
5.6%
5 24
 
5.0%
3 23
 
4.8%
9 23
 
4.8%
4 22
 
4.6%
8 21
 
4.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 478
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 141
29.5%
6 121
25.3%
7 38
 
7.9%
0 35
 
7.3%
1 27
 
5.6%
5 24
 
5.0%
3 23
 
4.8%
9 23
 
4.8%
4 22
 
4.6%
8 21
 
4.4%

의안명
Text

MISSING 

Distinct106
Distinct (%)89.8%
Missing76
Missing (%)39.2%
Memory size1.6 KiB
2024-01-28T20:06:10.730022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length42
Median length33.5
Mean length24.669492
Min length10

Characters and Unicode

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

Unique

Unique97 ?
Unique (%)82.2%

Sample

1st row남동구민축구단 육성 및 지원에 관한 조례 폐지조례안
2nd row남동구민축구단 육성 및 지원에 관한 조례안
3rd row남동구 국공립어린이집 민간위탁 동의안
4th row아이사랑꿈터 남동구10~12호점 민간위탁 동의안
5th row남동구의회 사무국 설치 조례 전부개정조례안
ValueCountFrequency (%)
남동구 68
 
10.2%
조례 48
 
7.2%
일부개정조례안 42
 
6.3%
관한 35
 
5.3%
및 32
 
4.8%
조례안 22
 
3.3%
건 18
 
2.7%
남동구의회 11
 
1.7%
지원에 11
 
1.7%
동의안 10
 
1.5%
Other values (244) 368
55.3%
2024-01-28T20:06:11.041473image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
552
 
19.0%
조 125
 
4.3%
례 119
 
4.1%
구 115
 
4.0%
동 114
 
3.9%
안 104
 
3.6%
남 90
 
3.1%
정 67
 
2.3%
의 64
 
2.2%
관 58
 
2.0%
Other values (217) 1503
51.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2256
77.5%
Space Separator 552
 
19.0%
Decimal Number 86
 
3.0%
Close Punctuation 5
 
0.2%
Open Punctuation 5
 
0.2%
Other Punctuation 5
 
0.2%
Math Symbol 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
조 125
 
5.5%
례 119
 
5.3%
구 115
 
5.1%
동 114
 
5.1%
안 104
 
4.6%
남 90
 
4.0%
정 67
 
3.0%
의 64
 
2.8%
관 58
 
2.6%
지 52
 
2.3%
Other values (202) 1348
59.8%
Decimal Number
ValueCountFrequency (%)
2 47
54.7%
0 19
22.1%
3 9
 
10.5%
1 5
 
5.8%
5 2
 
2.3%
6 1
 
1.2%
9 1
 
1.2%
4 1
 
1.2%
7 1
 
1.2%
Other Punctuation
ValueCountFrequency (%)
· 4
80.0%
: 1
 
20.0%
Space Separator
ValueCountFrequency (%)
552
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5
100.0%
Open Punctuation
ValueCountFrequency (%)
( 5
100.0%
Math Symbol
ValueCountFrequency (%)
~ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2256
77.5%
Common 655
 
22.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
조 125
 
5.5%
례 119
 
5.3%
구 115
 
5.1%
동 114
 
5.1%
안 104
 
4.6%
남 90
 
4.0%
정 67
 
3.0%
의 64
 
2.8%
관 58
 
2.6%
지 52
 
2.3%
Other values (202) 1348
59.8%
Common
ValueCountFrequency (%)
552
84.3%
2 47
 
7.2%
0 19
 
2.9%
3 9
 
1.4%
) 5
 
0.8%
( 5
 
0.8%
1 5
 
0.8%
· 4
 
0.6%
5 2
 
0.3%
~ 2
 
0.3%
Other values (5) 5
 
0.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2253
77.4%
ASCII 651
 
22.4%
None 4
 
0.1%
Compat Jamo 3
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
552
84.8%
2 47
 
7.2%
0 19
 
2.9%
3 9
 
1.4%
) 5
 
0.8%
( 5
 
0.8%
1 5
 
0.8%
5 2
 
0.3%
~ 2
 
0.3%
: 1
 
0.2%
Other values (4) 4
 
0.6%
Hangul
ValueCountFrequency (%)
조 125
 
5.5%
례 119
 
5.3%
구 115
 
5.1%
동 114
 
5.1%
안 104
 
4.6%
남 90
 
4.0%
정 67
 
3.0%
의 64
 
2.8%
관 58
 
2.6%
지 52
 
2.3%
Other values (201) 1345
59.7%
None
ValueCountFrequency (%)
· 4
100.0%
Compat Jamo
ValueCountFrequency (%)
ㆍ 3
100.0%

제안자
Categorical

Distinct24
Distinct (%)12.4%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
<NA>
76 
구청장
70 
이정순
 
6
정승환
 
5
황규진
 
5
Other values (19)
32 

Length

Max length8
Median length3
Mean length3.443299
Min length3

Unique

Unique11 ?
Unique (%)5.7%

Sample

1st row구청장
2nd row구청장
3rd row구청장
4th row구청장
5th row이정순

Common Values

ValueCountFrequency (%)
<NA> 76
39.2%
구청장 70
36.1%
이정순 6
 
3.1%
정승환 5
 
2.6%
황규진 5
 
2.6%
김재남 5
 
2.6%
장덕수 4
 
2.1%
박정하 2
 
1.0%
반미선 2
 
1.0%
이철상 2
 
1.0%
Other values (14) 17
 
8.8%

Length

2024-01-28T20:06:11.153963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 76
38.4%
구청장 70
35.4%
이정순 6
 
3.0%
정승환 5
 
2.5%
황규진 5
 
2.5%
김재남 5
 
2.5%
장덕수 4
 
2.0%
육은아 2
 
1.0%
김은숙 2
 
1.0%
외 2
 
1.0%
Other values (16) 21
 
10.6%

소관위원회
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
<NA>
76 
총무위원회
43 
사회도시위원회
39 
의회운영위원회
17 
본회의
10 
Other values (2)
9 

Length

Max length9
Median length7
Mean length4.9793814
Min length2

Unique

Unique1 ?
Unique (%)0.5%

Sample

1st row총무위원회
2nd row총무위원회
3rd row사회도시위원회
4th row사회도시위원회
5th row의회운영위원회

Common Values

ValueCountFrequency (%)
<NA> 76
39.2%
총무위원회 43
22.2%
사회도시위원회 39
20.1%
의회운영위원회 17
 
8.8%
본회의 10
 
5.2%
공통 8
 
4.1%
예산결산특별위원회 1
 
0.5%

Length

2024-01-28T20:06:11.252994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T20:06:11.344218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 76
39.2%
총무위원회 43
22.2%
사회도시위원회 39
20.1%
의회운영위원회 17
 
8.8%
본회의 10
 
5.2%
공통 8
 
4.1%
예산결산특별위원회 1
 
0.5%

발의일
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)8.8%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
<NA>
76 
2022-09-02
25 
2022-11-10
24 
2022-10-07
14 
2022-07-01
13 
Other values (12)
42 

Length

Max length10
Median length10
Mean length7.6494845
Min length4

Unique

Unique6 ?
Unique (%)3.1%

Sample

1st row2022-01-27
2nd row2022-01-27
3rd row2022-01-27
4th row2022-01-27
5th row2022-01-27

Common Values

ValueCountFrequency (%)
<NA> 76
39.2%
2022-09-02 25
 
12.9%
2022-11-10 24
 
12.4%
2022-10-07 14
 
7.2%
2022-07-01 13
 
6.7%
2022-03-11 13
 
6.7%
2022-01-27 12
 
6.2%
2022-09-15 4
 
2.1%
2022-09-05 3
 
1.5%
2022-03-16 2
 
1.0%
Other values (7) 8
 
4.1%

Length

2024-01-28T20:06:11.446530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 76
39.2%
2022-09-02 25
 
12.9%
2022-11-10 24
 
12.4%
2022-10-07 14
 
7.2%
2022-07-01 13
 
6.7%
2022-03-11 13
 
6.7%
2022-01-27 12
 
6.2%
2022-09-15 4
 
2.1%
2022-09-05 3
 
1.5%
2022-03-16 2
 
1.0%
Other values (7) 8
 
4.1%

상태
Categorical

IMBALANCE 

Distinct9
Distinct (%)4.6%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
<NA>
90 
가결(원안)
87 
가결(수정)
 
9
부결(폐기)
 
2
의안철회
 
2
Other values (4)
 
4

Length

Max length15
Median length6
Mean length5.0773196
Min length4

Unique

Unique4 ?
Unique (%)2.1%

Sample

1st row보류(폐기)
2nd row부결(폐기)
3rd row가결(원안)
4th row가결(원안)
5th row가결(원안)

Common Values

ValueCountFrequency (%)
<NA> 90
46.4%
가결(원안) 87
44.8%
가결(수정) 9
 
4.6%
부결(폐기) 2
 
1.0%
의안철회 2
 
1.0%
보류(폐기) 1
 
0.5%
본회의에 부의하지않기로 의결 1
 
0.5%
원안채택 1
 
0.5%
보고청취 1
 
0.5%

Length

2024-01-28T20:06:11.539128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T20:06:11.628085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 90
45.9%
가결(원안 87
44.4%
가결(수정 9
 
4.6%
부결(폐기 2
 
1.0%
의안철회 2
 
1.0%
보류(폐기 1
 
0.5%
본회의에 1
 
0.5%
부의하지않기로 1
 
0.5%
의결 1
 
0.5%
원안채택 1
 
0.5%

의결일
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)5.2%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
<NA>
96 
2022-09-21
23 
2022-12-08
20 
2022-10-28
14 
2022-04-01
11 
Other values (5)
30 

Length

Max length10
Median length10
Mean length7.0309278
Min length4

Unique

Unique1 ?
Unique (%)0.5%

Sample

1st row<NA>
2nd row<NA>
3rd row2022-02-17
4th row2022-02-17
5th row2022-02-17

Common Values

ValueCountFrequency (%)
<NA> 96
49.5%
2022-09-21 23
 
11.9%
2022-12-08 20
 
10.3%
2022-10-28 14
 
7.2%
2022-04-01 11
 
5.7%
2022-02-17 10
 
5.2%
2022-07-19 10
 
5.2%
2022-09-29 5
 
2.6%
2022-12-19 4
 
2.1%
2022-06-10 1
 
0.5%

Length

2024-01-28T20:06:11.728499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T20:06:11.821166image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 96
49.5%
2022-09-21 23
 
11.9%
2022-12-08 20
 
10.3%
2022-10-28 14
 
7.2%
2022-04-01 11
 
5.7%
2022-02-17 10
 
5.2%
2022-07-19 10
 
5.2%
2022-09-29 5
 
2.6%
2022-12-19 4
 
2.1%
2022-06-10 1
 
0.5%

Correlations

2024-01-28T20:06:11.893193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
제안자소관위원회발의일상태의결일
제안자1.0000.5980.8850.0000.766
소관위원회0.5981.0000.8000.5940.661
발의일0.8850.8001.0000.5670.984
상태0.0000.5940.5671.0000.340
의결일0.7660.6610.9840.3401.000
2024-01-28T20:06:11.967993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
소관위원회상태발의일제안자의결일
소관위원회1.0000.3780.5220.2930.393
상태0.3781.0000.2890.0000.216
발의일0.5220.2891.0000.4900.902
제안자0.2930.0000.4901.0000.404
의결일0.3930.2160.9020.4041.000
2024-01-28T20:06:12.046169image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
제안자소관위원회발의일상태의결일
제안자1.0000.2930.4900.0000.404
소관위원회0.2931.0000.5220.3780.393
발의일0.4900.5221.0000.2890.902
상태0.0000.3780.2891.0000.216
의결일0.4040.3930.9020.2161.000

Missing values

2024-01-28T20:06:09.700580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-28T20:06:09.785046image/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-28T20:06:09.871783image/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

의안번호의안명제안자소관위원회발의일상태의결일
02599남동구민축구단 육성 및 지원에 관한 조례 폐지조례안구청장총무위원회2022-01-27보류(폐기)<NA>
12600남동구민축구단 육성 및 지원에 관한 조례안구청장총무위원회2022-01-27부결(폐기)<NA>
22601남동구 국공립어린이집 민간위탁 동의안구청장사회도시위원회2022-01-27가결(원안)2022-02-17
32602아이사랑꿈터 남동구10~12호점 민간위탁 동의안구청장사회도시위원회2022-01-27가결(원안)2022-02-17
42603남동구의회 사무국 설치 조례 전부개정조례안이정순의회운영위원회2022-01-27가결(원안)2022-02-17
52604남동구의회 사무국 직원 추천 등에 관한 조례 폐지조례안이정순의회운영위원회2022-01-27가결(원안)2022-02-17
62605남동구의회 사무국 직제규칙 폐지규칙안이정순의회운영위원회2022-01-27가결(원안)2022-02-17
72606남동구의회 시험수당 지급 조례안김안나의회운영위원회2022-01-27가결(원안)2022-02-17
82607남동구의회 공무원 당직 및 비상근무 규칙안조성민의회운영위원회2022-01-27가결(원안)2022-02-17
92608남동구의회 사무기구 직무대리 규칙안최재현의회운영위원회2022-01-27가결(원안)2022-02-17
의안번호의안명제안자소관위원회발의일상태의결일
184<NA><NA><NA><NA><NA><NA><NA>
185<NA><NA><NA><NA><NA><NA><NA>
186<NA><NA><NA><NA><NA><NA><NA>
187<NA><NA><NA><NA><NA><NA><NA>
188<NA><NA><NA><NA><NA><NA><NA>
189<NA><NA><NA><NA><NA><NA><NA>
190<NA><NA><NA><NA><NA><NA><NA>
191<NA><NA><NA><NA><NA><NA><NA>
192<NA><NA><NA><NA><NA><NA><NA>
193<NA><NA><NA><NA><NA><NA><NA>

Duplicate rows

Most frequently occurring

의안번호의안명제안자소관위원회발의일상태의결일# duplicates
0<NA><NA><NA><NA><NA><NA><NA>76