Overview

Dataset statistics

Number of variables9
Number of observations44
Missing cells1
Missing cells (%)0.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.2 KiB
Average record size in memory74.9 B

Variable types

Categorical9

Dataset

Description창원시 시의원정보(성명, 이메일주소,정당,구역,선거구,사진URL,위원회,전화번호,데이터기준일)
Author경상남도
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15031337

Alerts

데이터기준일 has constant value "2018-07-30" Constant
위원회 is highly correlated with 사진URL and 4 other fieldsHigh correlation
선거구 is highly correlated with 사진URL and 4 other fieldsHigh correlation
사진URL is highly correlated with 위원회 and 7 other fieldsHigh correlation
성명 is highly correlated with 위원회 and 7 other fieldsHigh correlation
구역 is highly correlated with 사진URL and 4 other fieldsHigh correlation
전화번호 is highly correlated with 위원회 and 7 other fieldsHigh correlation
정당 is highly correlated with 사진URL and 4 other fieldsHigh correlation
데이터기준일 is highly correlated with 위원회 and 7 other fieldsHigh correlation
이메일주소 is highly correlated with 위원회 and 7 other fieldsHigh correlation
위원회 has 1 (2.3%) missing values Missing
성명 has unique values Unique
이메일주소 has unique values Unique
사진URL has unique values Unique
전화번호 has unique values Unique

Reproduction

Analysis started2022-09-24 09:59:19.755116
Analysis finished2022-09-24 09:59:22.789674
Duration3.03 seconds
Software versionpandas-profiling v3.2.0
Download configurationconfig.json

Variables

성명
Categorical

HIGH CORRELATION
UNIQUE

Distinct44
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size480.0 B
권성현
 
1
김장하
 
1
이찬호
 
1
백태현
 
1
최은하
 
1
Other values (39)
39 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique44 ?
Unique (%)100.0%

Sample

1st row권성현
2nd row김장하
3rd row백태현
4th row최은하
5th row구점득

Common Values

ValueCountFrequency (%)
권성현1
 
2.3%
김장하1
 
2.3%
이찬호1
 
2.3%
백태현1
 
2.3%
최은하1
 
2.3%
구점득1
 
2.3%
김우겸1
 
2.3%
주철우1
 
2.3%
공창섭1
 
2.3%
박현재1
 
2.3%
Other values (34)34
77.3%

Length

2022-09-24T18:59:22.970588image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
권성현1
 
2.3%
김장하1
 
2.3%
이해련1
 
2.3%
이우완1
 
2.3%
진상락1
 
2.3%
김종대1
 
2.3%
임해진1
 
2.3%
문순규1
 
2.3%
손태화1
 
2.3%
조영명1
 
2.3%
Other values (34)34
77.3%

이메일주소
Categorical

HIGH CORRELATION
UNIQUE

Distinct44
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size480.0 B
kwonvictory@naver.com
 
1
resuns@naver.com
 
1
roman97@hanmail.net
 
1
bth78@naver.com
 
1
h4223@hanmail.net
 
1
Other values (39)
39 

Length

Max length25
Median length22
Mean length19.22727273
Min length15

Unique

Unique44 ?
Unique (%)100.0%

Sample

1st rowkwonvictory@naver.com
2nd rowresuns@naver.com
3rd rowbth78@naver.com
4th rowh4223@hanmail.net
5th row01020068283@hanmail.net

Common Values

ValueCountFrequency (%)
kwonvictory@naver.com1
 
2.3%
resuns@naver.com1
 
2.3%
roman97@hanmail.net1
 
2.3%
bth78@naver.com1
 
2.3%
h4223@hanmail.net1
 
2.3%
01020068283@hanmail.net1
 
2.3%
wkim244@gmail.com1
 
2.3%
jjjmovie@daum.net1
 
2.3%
pola8820@hanmail.net1
 
2.3%
bhj7119@naver.com1
 
2.3%
Other values (34)34
77.3%

Length

2022-09-24T18:59:23.228452image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
kwonvictory@naver.com1
 
2.3%
resuns@naver.com1
 
2.3%
woobaeyi@haamail.net1
 
2.3%
asadarl@hanmail.net1
 
2.3%
jsr8505@hanmail.net1
 
2.3%
masan-kjd@hanmail.net1
 
2.3%
hjinyim@naver.com1
 
2.3%
anstnsrb3150@naver.com1
 
2.3%
sonth0528@naver.com1
 
2.3%
cho4466@hanmail.net1
 
2.3%
Other values (34)34
77.3%

정당
Categorical

HIGH CORRELATION

Distinct3
Distinct (%)6.8%
Missing0
Missing (%)0.0%
Memory size480.0 B
자유한국당
21 
더불어민주당
21 
정의당
 
2

Length

Max length6
Median length5
Mean length5.386363636
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row자유한국당
2nd row더불어민주당
3rd row자유한국당
4th row더불어민주당
5th row자유한국당

Common Values

ValueCountFrequency (%)
자유한국당21
47.7%
더불어민주당21
47.7%
정의당2
 
4.5%

Length

2022-09-24T18:59:23.514371image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram of lengths of the category

Category Frequency Plot

2022-09-24T18:59:23.901099image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
ValueCountFrequency (%)
자유한국당21
47.7%
더불어민주당21
47.7%
정의당2
 
4.5%

구역
Categorical

HIGH CORRELATION

Distinct6
Distinct (%)13.6%
Missing0
Missing (%)0.0%
Memory size480.0 B
의창구
9 
마산합포구
8 
진해구
8 
성산구
7 
마산회원구
7 

Length

Max length5
Median length3
Mean length3.795454545
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row의창구
2nd row의창구
3rd row의창구
4th row의창구
5th row의창구

Common Values

ValueCountFrequency (%)
의창구9
20.5%
마산합포구8
18.2%
진해구8
18.2%
성산구7
15.9%
마산회원구7
15.9%
비례대표5
11.4%

Length

2022-09-24T18:59:24.161422image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram of lengths of the category

Category Frequency Plot

2022-09-24T18:59:24.475594image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
ValueCountFrequency (%)
의창구9
20.5%
마산합포구8
18.2%
진해구8
18.2%
성산구7
15.9%
마산회원구7
15.9%
비례대표5
11.4%

선거구
Categorical

HIGH CORRELATION

Distinct18
Distinct (%)40.9%
Missing0
Missing (%)0.0%
Memory size480.0 B
비례대표
5 
가(동읍,북면,대산면,의창동)
4 
마(상남,사파동)
3 
나(팔룡,명곡동)
3 
파(양덕1,2,합성2,구암1,2,봉암동)
3 
Other values (13)
26 

Length

Max length22
Median length17
Mean length12.68181818
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row가(동읍,북면,대산면,의창동)
2nd row가(동읍,북면,대산면,의창동)
3rd row가(동읍,북면,대산면,의창동)
4th row가(동읍,북면,대산면,의창동)
5th row나(팔룡,명곡동)

Common Values

ValueCountFrequency (%)
비례대표5
 
11.4%
가(동읍,북면,대산면,의창동)4
 
9.1%
마(상남,사파동)3
 
6.8%
나(팔룡,명곡동)3
 
6.8%
파(양덕1,2,합성2,구암1,2,봉암동)3
 
6.8%
카(내서읍)2
 
4.5%
더(웅천,웅동1,2동)2
 
4.5%
너(이동,자은,덕산,풍호동)2
 
4.5%
거(태백,경화,병암,석동)2
 
4.5%
하(중앙,태평,충무,여좌동)2
 
4.5%
Other values (8)16
36.4%

Length

2022-09-24T18:59:24.784825image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
비례대표5
 
10.4%
가(동읍,북면,대산면,의창동4
 
8.3%
마(상남,사파동3
 
6.2%
나(팔룡,명곡동3
 
6.2%
파(양덕1,2,합성2,구암1,2,봉암동3
 
6.2%
자(완월,자산,오동동2
 
4.2%
다(봉림,용지동2
 
4.2%
라(반송,중앙,웅남동2
 
4.2%
바(가음정,성주동2
 
4.2%
진전면2
 
4.2%
Other values (10)20
41.7%

사진URL
Categorical

HIGH CORRELATION
UNIQUE

Distinct44
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size480.0 B
http://council.changwon.go.kr/assem/man_photo/1/20180626JPAMT.jpg
 
1
http://council.changwon.go.kr/assem/man_photo/1/20180626CKINJ.jpg
 
1
http://council.changwon.go.kr/assem/man_photo/1/20180820YDEWI.jpg
 
1
http://council.changwon.go.kr/assem/man_photo/1/20180626QLNGK.jpg
 
1
http://council.changwon.go.kr/assem/man_photo/1/20180626XKVNY.jpg
 
1
Other values (39)
39 

Length

Max length65
Median length65
Mean length65
Min length65

Unique

Unique44 ?
Unique (%)100.0%

Sample

1st rowhttp://council.changwon.go.kr/assem/man_photo/1/20180626JPAMT.jpg
2nd rowhttp://council.changwon.go.kr/assem/man_photo/1/20180626CKINJ.jpg
3rd rowhttp://council.changwon.go.kr/assem/man_photo/1/20180626QLNGK.jpg
4th rowhttp://council.changwon.go.kr/assem/man_photo/1/20180626XKVNY.jpg
5th rowhttp://council.changwon.go.kr/assem/man_photo/1/20180626QPQOS.jpg

Common Values

ValueCountFrequency (%)
http://council.changwon.go.kr/assem/man_photo/1/20180626JPAMT.jpg1
 
2.3%
http://council.changwon.go.kr/assem/man_photo/1/20180626CKINJ.jpg1
 
2.3%
http://council.changwon.go.kr/assem/man_photo/1/20180820YDEWI.jpg1
 
2.3%
http://council.changwon.go.kr/assem/man_photo/1/20180626QLNGK.jpg1
 
2.3%
http://council.changwon.go.kr/assem/man_photo/1/20180626XKVNY.jpg1
 
2.3%
http://council.changwon.go.kr/assem/man_photo/1/20180626QPQOS.jpg1
 
2.3%
http://council.changwon.go.kr/assem/man_photo/1/20180626IEUIG.jpg1
 
2.3%
http://council.changwon.go.kr/assem/man_photo/1/20180626ZFVQG.jpg1
 
2.3%
http://council.changwon.go.kr/assem/man_photo/1/20180626HHPCX.jpg1
 
2.3%
http://council.changwon.go.kr/assem/man_photo/1/20180626XPOXQ.jpg1
 
2.3%
Other values (34)34
77.3%

Length

2022-09-24T18:59:25.066676image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
http://council.changwon.go.kr/assem/man_photo/1/20180626jpamt.jpg1
 
2.3%
http://council.changwon.go.kr/assem/man_photo/1/20180626ckinj.jpg1
 
2.3%
http://council.changwon.go.kr/assem/man_photo/1/20180626hgmcq.jpg1
 
2.3%
http://council.changwon.go.kr/assem/man_photo/1/20180626dbfji.jpg1
 
2.3%
http://council.changwon.go.kr/assem/man_photo/1/20180626ndjaw.jpg1
 
2.3%
http://council.changwon.go.kr/assem/man_photo/1/20180627aktoc.jpg1
 
2.3%
http://council.changwon.go.kr/assem/man_photo/1/20180626uzglq.jpg1
 
2.3%
http://council.changwon.go.kr/assem/man_photo/1/20180626ilkza.jpg1
 
2.3%
http://council.changwon.go.kr/assem/man_photo/1/20180626wriyk.jpg1
 
2.3%
http://council.changwon.go.kr/assem/man_photo/1/20180626knhsj.jpg1
 
2.3%
Other values (34)34
77.3%

위원회
Categorical

HIGH CORRELATION
MISSING

Distinct8
Distinct (%)18.6%
Missing1
Missing (%)2.3%
Memory size480.0 B
경제복지여성위원회
9 
기획행정위원회
9 
문화도시건설위원회
9 
환경해양농림위원회
8 
의회운영위원회,기획행정위원회
2 
Other values (3)
6 

Length

Max length18
Median length17
Mean length10.74418605
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row환경해양농림위원회
2nd row환경해양농림위원회
3rd row의회운영위원회,기획행정위원회
4th row경제복지여성위원회
5th row기획행정위원회

Common Values

ValueCountFrequency (%)
경제복지여성위원회 9
20.5%
기획행정위원회 9
20.5%
문화도시건설위원회 9
20.5%
환경해양농림위원회8
18.2%
의회운영위원회,기획행정위원회 2
 
4.5%
의회운영위원회,문화도시건설위원회 2
 
4.5%
의회운영위원회,환경해양농림위원회2
 
4.5%
의회운영위원회,경제복지여성위원회 2
 
4.5%
(Missing)1
 
2.3%

Length

2022-09-24T18:59:25.306643image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram of lengths of the category

Category Frequency Plot

2022-09-24T18:59:25.558537image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
ValueCountFrequency (%)
경제복지여성위원회9
20.9%
기획행정위원회9
20.9%
문화도시건설위원회9
20.9%
환경해양농림위원회8
18.6%
의회운영위원회,기획행정위원회2
 
4.7%
의회운영위원회,문화도시건설위원회2
 
4.7%
의회운영위원회,환경해양농림위원회2
 
4.7%
의회운영위원회,경제복지여성위원회2
 
4.7%

전화번호
Categorical

HIGH CORRELATION
UNIQUE

Distinct44
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size480.0 B
055-225-5132
 
1
055-225-5010
 
1
055-225-5000
 
1
055-225-5114
 
1
055-225-5124
 
1
Other values (39)
39 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique44 ?
Unique (%)100.0%

Sample

1st row055-225-5132
2nd row055-225-5010
3rd row055-225-5114
4th row055-225-5124
5th row055-225-5119

Common Values

ValueCountFrequency (%)
055-225-51321
 
2.3%
055-225-50101
 
2.3%
055-225-50001
 
2.3%
055-225-51141
 
2.3%
055-225-51241
 
2.3%
055-225-51191
 
2.3%
055-225-51341
 
2.3%
055-225-51151
 
2.3%
055-225-51121
 
2.3%
055-225-51491
 
2.3%
Other values (34)34
77.3%

Length

2022-09-24T18:59:25.729392image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
055-225-51321
 
2.3%
055-225-50101
 
2.3%
055-225-50801
 
2.3%
055-225-51211
 
2.3%
055-225-51311
 
2.3%
055-225-51471
 
2.3%
055-225-51261
 
2.3%
055-225-51281
 
2.3%
055-225-50501
 
2.3%
055-225-51451
 
2.3%
Other values (34)34
77.3%

데이터기준일
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct1
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size480.0 B
2018-07-30
44 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2018-07-30
2nd row2018-07-30
3rd row2018-07-30
4th row2018-07-30
5th row2018-07-30

Common Values

ValueCountFrequency (%)
2018-07-3044
100.0%

Length

2022-09-24T18:59:25.854912image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Histogram of lengths of the category

Category Frequency Plot

2022-09-24T18:59:25.987780image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
ValueCountFrequency (%)
2018-07-3044
100.0%

Correlations

2022-09-24T18:59:26.093140image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.
2022-09-24T18:59:26.278429image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Missing values

2022-09-24T18:59:21.886825image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
A simple visualization of nullity by column.
2022-09-24T18:59:22.349755image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
2022-09-24T18:59:22.556414image/svg+xmlMatplotlib v3.4.3, https://matplotlib.org/
The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

Sample

First rows

성명이메일주소정당구역선거구사진URL위원회전화번호데이터기준일
0권성현kwonvictory@naver.com자유한국당의창구가(동읍,북면,대산면,의창동)http://council.changwon.go.kr/assem/man_photo/1/20180626JPAMT.jpg환경해양농림위원회055-225-51322018-07-30
1김장하resuns@naver.com더불어민주당의창구가(동읍,북면,대산면,의창동)http://council.changwon.go.kr/assem/man_photo/1/20180626CKINJ.jpg환경해양농림위원회055-225-50102018-07-30
2백태현bth78@naver.com자유한국당의창구가(동읍,북면,대산면,의창동)http://council.changwon.go.kr/assem/man_photo/1/20180626QLNGK.jpg의회운영위원회,기획행정위원회055-225-51142018-07-30
3최은하h4223@hanmail.net더불어민주당의창구가(동읍,북면,대산면,의창동)http://council.changwon.go.kr/assem/man_photo/1/20180626XKVNY.jpg경제복지여성위원회055-225-51242018-07-30
4구점득01020068283@hanmail.net자유한국당의창구나(팔룡,명곡동)http://council.changwon.go.kr/assem/man_photo/1/20180626QPQOS.jpg기획행정위원회055-225-51192018-07-30
5김우겸wkim244@gmail.com더불어민주당의창구나(팔룡,명곡동)http://council.changwon.go.kr/assem/man_photo/1/20180626IEUIG.jpg환경해양농림위원회055-225-51342018-07-30
6주철우jjjmovie@daum.net더불어민주당의창구나(팔룡,명곡동)http://council.changwon.go.kr/assem/man_photo/1/20180626ZFVQG.jpg기획행정위원회055-225-51152018-07-30
7공창섭pola8820@hanmail.net더불어민주당의창구다(봉림,용지동)http://council.changwon.go.kr/assem/man_photo/1/20180626HHPCX.jpg기획행정위원회055-225-51122018-07-30
8박현재bhj7119@naver.com자유한국당의창구다(봉림,용지동)http://council.changwon.go.kr/assem/man_photo/1/20180626XPOXQ.jpg문화도시건설위원회055-225-51492018-07-30
9김경희maru105109@naver.com더불어민주당성산구라(반송,중앙,웅남동)http://council.changwon.go.kr/assem/man_photo/1/20180626TIDEA.jpg의회운영위원회,문화도시건설위원회055-225-51412018-07-30

Last rows

성명이메일주소정당구역선거구사진URL위원회전화번호데이터기준일
34정순욱jsu2566@hanmail.net더불어민주당진해구거(태백,경화,병암,석동)http://council.changwon.go.kr/assem/man_photo/1/20180625OEPTY.jpg문화도시건설위원회055-225-51482018-07-30
35김태웅alwlsrla@hanmail.net더불어민주당진해구너(이동,자은,덕산,풍호동)http://council.changwon.go.kr/assem/man_photo/1/20180626UPITA.jpg기획행정위원회055-225-31152018-07-30
36박춘덕ytwoktwo@korea.com자유한국당진해구너(이동,자은,덕산,풍호동)http://council.changwon.go.kr/assem/man_photo/1/20180626ZCHYX.jpg문화도시건설위원회055-225-51462018-07-30
37심영석s8y8s8@hanmail.net더불어민주당진해구더(웅천,웅동1,2동)http://council.changwon.go.kr/assem/man_photo/1/20180626EVRFP.jpg경제복지여성위원회055-225-51252018-07-30
38이치우lcw6040@naver.com자유한국당진해구더(웅천,웅동1,2동)http://council.changwon.go.kr/assem/man_photo/1/20180626QLBCB.jpg의회운영위원회,환경해양농림위원회055-225-50402018-07-30
39이종화ljflower@hanmail.net더불어민주당비례대표비례대표http://council.changwon.go.kr/assem/man_photo/1/20180626QKBID.jpg경제복지여성위원회055-225-51272018-07-30
40김상찬sanai321@naver.com더불어민주당비례대표비례대표http://council.changwon.go.kr/assem/man_photo/1/20180626XPDDQ.jpg기획행정위원회055-225-51162018-07-30
41박선애psa6382@hanmail.net자유한국당비례대표비례대표http://council.changwon.go.kr/assem/man_photo/1/20180626PWMGV.jpg의회운영위원회,경제복지여성위원회055-225-51222018-07-30
42이헌순hs8182@hanmail.net자유한국당비례대표비례대표http://council.changwon.go.kr/assem/man_photo/1/20180626LCLJS.jpg경제복지여성위원회055-225-51232018-07-30
43최영희tipasa97@daum.net정의당비례대표비례대표http://council.changwon.go.kr/assem/man_photo/1/20180626CQVJL.jpg기획행정위원회055-225-51202018-07-30