Overview

Dataset statistics

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

Variable types

Text2
Categorical3
DateTime2

Dataset

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

Alerts

Dataset has 1 (0.5%) duplicate rowsDuplicates
상태 is highly imbalanced (51.7%)Imbalance
의안번호 has 76 (39.2%) missing valuesMissing
의안명 has 76 (39.2%) missing valuesMissing
발의일 has 76 (39.2%) missing valuesMissing
의결일 has 96 (49.5%) missing valuesMissing

Reproduction

Analysis started2024-01-28 11:06:05.138107
Analysis finished2024-01-28 11:06:05.932777
Duration0.79 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:06.139950image/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:06.507781image/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:06.728200image/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:07.060910image/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:07.163887image/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

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:07.258941image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T20:06:07.367375image/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%

발의일
Date

MISSING 

Distinct16
Distinct (%)13.6%
Missing76
Missing (%)39.2%
Memory size1.6 KiB
Minimum2022-01-26 00:00:00
Maximum2022-12-19 00:00:00
2024-01-28T20:06:07.463181image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T20:06:07.543418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)

상태
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:07.635781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T20:06:07.724544image/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%

의결일
Date

MISSING 

Distinct9
Distinct (%)9.2%
Missing96
Missing (%)49.5%
Memory size1.6 KiB
Minimum2022-02-17 00:00:00
Maximum2022-12-19 00:00:00
2024-01-28T20:06:07.809105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T20:06:07.908407image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)

Correlations

2024-01-28T20:06:07.973794image/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:08.048183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
소관위원회제안자상태
소관위원회1.0000.2930.378
제안자0.2931.0000.000
상태0.3780.0001.000
2024-01-28T20:06:08.114892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
제안자소관위원회상태
제안자1.0000.2930.000
소관위원회0.2931.0000.378
상태0.0000.3781.000

Missing values

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