Overview

Dataset statistics

Number of variables8
Number of observations130
Missing cells74
Missing cells (%)7.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.4 KiB
Average record size in memory66.0 B

Variable types

Numeric1
Categorical5
Text2

Dataset

Description충청남도 보령시 의회 의원 현황으로 의원의 성명, 정당, 선거구, 직위, 전화번호 항목으로 구성되어 있습니다. 의원에 대한 자세한 정보를 원하시는 경우 보령시의회 누리집(http://www.brcouncil.go.kr/kr/member/name.do)을 참고해주시기 바랍니다.
Author충청남도 보령시
URLhttps://www.data.go.kr/data/15114843/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
연번 is highly overall correlated with 대수 and 1 other fieldsHigh correlation
대수 is highly overall correlated with 연번 and 1 other fieldsHigh correlation
소속정당 is highly overall correlated with 연번 and 1 other fieldsHigh correlation
전화번호 has 74 (56.9%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-11 22:58:48.105939
Analysis finished2023-12-11 22:58:48.730956
Duration0.63 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct130
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean65.5
Minimum1
Maximum130
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 KiB
2023-12-12T07:58:48.791085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile7.45
Q133.25
median65.5
Q397.75
95-th percentile123.55
Maximum130
Range129
Interquartile range (IQR)64.5

Descriptive statistics

Standard deviation37.671829
Coefficient of variation (CV)0.57514242
Kurtosis-1.2
Mean65.5
Median Absolute Deviation (MAD)32.5
Skewness0
Sum8515
Variance1419.1667
MonotonicityStrictly increasing
2023-12-12T07:58:48.910238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.8%
99 1
 
0.8%
97 1
 
0.8%
96 1
 
0.8%
95 1
 
0.8%
94 1
 
0.8%
93 1
 
0.8%
92 1
 
0.8%
91 1
 
0.8%
90 1
 
0.8%
Other values (120) 120
92.3%
ValueCountFrequency (%)
1 1
0.8%
2 1
0.8%
3 1
0.8%
4 1
0.8%
5 1
0.8%
6 1
0.8%
7 1
0.8%
8 1
0.8%
9 1
0.8%
10 1
0.8%
ValueCountFrequency (%)
130 1
0.8%
129 1
0.8%
128 1
0.8%
127 1
0.8%
126 1
0.8%
125 1
0.8%
124 1
0.8%
123 1
0.8%
122 1
0.8%
121 1
0.8%

대수
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)6.9%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2대
18 
1대
18 
4대
17 
3대
16 
6대
13 
Other values (4)
48 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row9대
2nd row9대
3rd row9대
4th row9대
5th row9대

Common Values

ValueCountFrequency (%)
2대 18
13.8%
1대 18
13.8%
4대 17
13.1%
3대 16
12.3%
6대 13
10.0%
9대 12
9.2%
8대 12
9.2%
7대 12
9.2%
5대 12
9.2%

Length

2023-12-12T07:58:49.038134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T07:58:49.133293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2대 18
13.8%
1대 18
13.8%
4대 17
13.1%
3대 16
12.3%
6대 13
10.0%
9대 12
9.2%
8대 12
9.2%
7대 12
9.2%
5대 12
9.2%

성명
Text

Distinct85
Distinct (%)65.4%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2023-12-12T07:58:49.379600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters390
Distinct characters102
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique55 ?
Unique (%)42.3%

Sample

1st row박상모
2nd row김충호
3rd row백성현
4th row이정근
5th row백영창
ValueCountFrequency (%)
성태용 4
 
3.1%
오배근 4
 
3.1%
김경제 3
 
2.3%
박상모 3
 
2.3%
박금순 3
 
2.3%
김충수 3
 
2.3%
임세빈 3
 
2.3%
박수만 3
 
2.3%
박영진 3
 
2.3%
편삼범 3
 
2.3%
Other values (75) 98
75.4%
2023-12-12T07:58:49.754044image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 31
 
7.9%
박 20
 
5.1%
성 14
 
3.6%
이 11
 
2.8%
석 11
 
2.8%
수 10
 
2.6%
임 9
 
2.3%
최 9
 
2.3%
태 8
 
2.1%
영 8
 
2.1%
Other values (92) 259
66.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 390
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 31
 
7.9%
박 20
 
5.1%
성 14
 
3.6%
이 11
 
2.8%
석 11
 
2.8%
수 10
 
2.6%
임 9
 
2.3%
최 9
 
2.3%
태 8
 
2.1%
영 8
 
2.1%
Other values (92) 259
66.4%

Most occurring scripts

ValueCountFrequency (%)
Hangul 390
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 31
 
7.9%
박 20
 
5.1%
성 14
 
3.6%
이 11
 
2.8%
석 11
 
2.8%
수 10
 
2.6%
임 9
 
2.3%
최 9
 
2.3%
태 8
 
2.1%
영 8
 
2.1%
Other values (92) 259
66.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 390
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 31
 
7.9%
박 20
 
5.1%
성 14
 
3.6%
이 11
 
2.8%
석 11
 
2.8%
수 10
 
2.6%
임 9
 
2.3%
최 9
 
2.3%
태 8
 
2.1%
영 8
 
2.1%
Other values (92) 259
66.4%

소속정당
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)6.9%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
무소속
72 
국민의힘
14 
더불어민주당
10 
새누리당
9 
자유한국당
8 
Other values (4)
17 

Length

Max length7
Median length3
Mean length3.7846154
Min length3

Unique

Unique1 ?
Unique (%)0.8%

Sample

1st row국민의힘
2nd row국민의힘
3rd row국민의힘
4th row더불어민주당
5th row국민의힘

Common Values

ValueCountFrequency (%)
무소속 72
55.4%
국민의힘 14
 
10.8%
더불어민주당 10
 
7.7%
새누리당 9
 
6.9%
자유한국당 8
 
6.2%
자유선진당 8
 
6.2%
한나라당 5
 
3.8%
새정치민주연합 3
 
2.3%
민주당 1
 
0.8%

Length

2023-12-12T07:58:49.901758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T07:58:50.013786image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
무소속 72
55.4%
국민의힘 14
 
10.8%
더불어민주당 10
 
7.7%
새누리당 9
 
6.9%
자유한국당 8
 
6.2%
자유선진당 8
 
6.2%
한나라당 5
 
3.8%
새정치민주연합 3
 
2.3%
민주당 1
 
0.8%

선거구
Categorical

Distinct27
Distinct (%)20.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
가선거구
15 
라선거구
13 
다선거구
12 
나선거구
11 
비례대표
10 
Other values (22)
69 

Length

Max length4
Median length4
Mean length3.5307692
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row다선거구
2nd row가선거구
3rd row다선거구
4th row라선거구
5th row가선거구

Common Values

ValueCountFrequency (%)
가선거구 15
 
11.5%
라선거구 13
 
10.0%
다선거구 12
 
9.2%
나선거구 11
 
8.5%
비례대표 10
 
7.7%
청라면 5
 
3.8%
주포면 5
 
3.8%
청소면 4
 
3.1%
웅천읍 4
 
3.1%
천북면 4
 
3.1%
Other values (17) 47
36.2%

Length

2023-12-12T07:58:50.156352image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
가선거구 15
 
11.5%
라선거구 13
 
10.0%
다선거구 12
 
9.2%
나선거구 11
 
8.5%
비례대표 10
 
7.7%
청라면 5
 
3.8%
주포면 5
 
3.8%
주산면 4
 
3.1%
성주면 4
 
3.1%
남포면 4
 
3.1%
Other values (17) 47
36.2%

직위
Categorical

Distinct21
Distinct (%)16.2%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
<NA>
45 
의장
14 
부의장
10 
산업건설위원장
8 
총무위원장
7 
Other values (16)
46 

Length

Max length20
Median length19
Mean length5.1692308
Min length2

Unique

Unique8 ?
Unique (%)6.2%

Sample

1st row의장
2nd row부의장
3rd row의회운영위원장
4th row자치행정위원장
5th row경제개발위원장

Common Values

ValueCountFrequency (%)
<NA> 45
34.6%
의장 14
 
10.8%
부의장 10
 
7.7%
산업건설위원장 8
 
6.2%
총무위원장 7
 
5.4%
의회운영위원장 6
 
4.6%
자치행정위원장 6
 
4.6%
예산결산특별위원장 6
 
4.6%
의원 5
 
3.8%
경제개발위원장 5
 
3.8%
Other values (11) 18
 
13.8%

Length

2023-12-12T07:58:50.296820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 45
33.8%
의장 14
 
10.5%
부의장 10
 
7.5%
산업건설위원장 8
 
6.0%
총무위원장 7
 
5.3%
의회운영위원장 6
 
4.5%
자치행정위원장 6
 
4.5%
예산결산특별위원장 6
 
4.5%
의원 5
 
3.8%
경제개발위원장 5
 
3.8%
Other values (14) 21
15.8%

전화번호
Text

MISSING 

Distinct34
Distinct (%)60.7%
Missing74
Missing (%)56.9%
Memory size1.1 KiB
2023-12-12T07:58:50.474794image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique13 ?
Unique (%)23.2%

Sample

1st row041-930-4000
2nd row041-930-4001
3rd row041-930-4007
4th row041-930-4008
5th row041-930-4006
ValueCountFrequency (%)
041-933-6655 3
 
5.4%
041-931-2211 2
 
3.6%
041-936-1496 2
 
3.6%
041-930-4000 2
 
3.6%
041-935-3689 2
 
3.6%
041-930-4010 2
 
3.6%
041-933-6985 2
 
3.6%
041-936-7526 2
 
3.6%
041-932-9155 2
 
3.6%
041-930-4001 2
 
3.6%
Other values (24) 35
62.5%
2023-12-12T07:58:50.761996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 136
20.2%
- 112
16.7%
4 92
13.7%
1 81
12.1%
3 80
11.9%
9 72
10.7%
6 30
 
4.5%
5 28
 
4.2%
2 19
 
2.8%
7 13
 
1.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 560
83.3%
Dash Punctuation 112
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 136
24.3%
4 92
16.4%
1 81
14.5%
3 80
14.3%
9 72
12.9%
6 30
 
5.4%
5 28
 
5.0%
2 19
 
3.4%
7 13
 
2.3%
8 9
 
1.6%
Dash Punctuation
ValueCountFrequency (%)
- 112
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 672
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 136
20.2%
- 112
16.7%
4 92
13.7%
1 81
12.1%
3 80
11.9%
9 72
10.7%
6 30
 
4.5%
5 28
 
4.2%
2 19
 
2.8%
7 13
 
1.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 672
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 136
20.2%
- 112
16.7%
4 92
13.7%
1 81
12.1%
3 80
11.9%
9 72
10.7%
6 30
 
4.5%
5 28
 
4.2%
2 19
 
2.8%
7 13
 
1.9%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2023-11-30
130 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-11-30
2nd row2023-11-30
3rd row2023-11-30
4th row2023-11-30
5th row2023-11-30

Common Values

ValueCountFrequency (%)
2023-11-30 130
100.0%

Length

2023-12-12T07:58:50.878894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T07:58:50.956700image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-11-30 130
100.0%

Interactions

2023-12-12T07:58:48.498478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T07:58:51.013883image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번대수성명소속정당선거구직위전화번호
연번1.0000.9550.0000.8060.2890.3350.251
대수0.9551.0000.0000.9530.0000.3890.000
성명0.0000.0001.0000.0000.9740.6190.996
소속정당0.8060.9530.0001.0000.0000.6860.913
선거구0.2890.0000.9740.0001.0000.0000.980
직위0.3350.3890.6190.6860.0001.0000.000
전화번호0.2510.0000.9960.9130.9800.0001.000
2023-12-12T07:58:51.105423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
직위소속정당선거구대수
직위1.0000.3220.0000.143
소속정당0.3221.0000.0000.645
선거구0.0000.0001.0000.000
대수0.1430.6450.0001.000
2023-12-12T07:58:51.191255image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번대수소속정당선거구직위
연번1.0000.8370.5350.0920.117
대수0.8371.0000.6450.0000.143
소속정당0.5350.6451.0000.0000.322
선거구0.0920.0000.0001.0000.000
직위0.1170.1430.3220.0001.000

Missing values

2023-12-12T07:58:48.592356image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T07:58:48.691696image/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.

Sample

연번대수성명소속정당선거구직위전화번호데이터기준일자
019대박상모국민의힘다선거구의장041-930-40002023-11-30
129대김충호국민의힘가선거구부의장041-930-40012023-11-30
239대백성현국민의힘다선거구의회운영위원장041-930-40072023-11-30
349대이정근더불어민주당라선거구자치행정위원장041-930-40082023-11-30
459대백영창국민의힘가선거구경제개발위원장041-930-40062023-11-30
569대성태용더불어민주당나선거구더불어민주당041-930-40092023-11-30
679대최은순국민의힘나선거구의원041-930-40022023-11-30
789대김정훈국민의힘라선거구예산결산특별위원장041-930-40052023-11-30
899대조장현더불어민주당다선거구의원041-930-40112023-11-30
9109대김재관국민의힘나선거구의원041-930-40042023-11-30
연번대수성명소속정당선거구직위전화번호데이터기준일자
1201211대임흥재무소속주산면<NA><NA>2023-11-30
1211221대김지섭무소속미산면<NA><NA>2023-11-30
1221231대최병걸무소속성주면<NA><NA>2023-11-30
1231241대박병찬무소속원동<NA><NA>2023-11-30
1241251대복기을무소속원동<NA><NA>2023-11-30
1251261대이수직무소속대관동<NA><NA>2023-11-30
1261271대김성복무소속대신동<NA><NA>2023-11-30
1271281대오배근무소속흥덕동<NA><NA>2023-11-30
1281291대전만수무소속현포동<NA><NA>2023-11-30
1291301대천옥석무소속왕대동<NA><NA>2023-11-30