Overview

Dataset statistics

Number of variables6
Number of observations168
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.0 KiB
Average record size in memory48.8 B

Variable types

DateTime2
Categorical3
Text1

Dataset

Description전라북도 무주군의 부서정보현황 데이터로써, 조직개편일자, 시군명, 부서명, 부서대표번호, 부서팩스번호, 기준일자 항목으로 구성
URLhttps://www.data.go.kr/data/15042659/fileData.do

Alerts

시군명 has constant value ""Constant
기준일자 has constant value ""Constant
부서팩스번호 is highly overall correlated with 부서대표번호High correlation
부서대표번호 is highly overall correlated with 부서팩스번호High correlation
부서명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 16:13:02.421214
Analysis finished2023-12-12 16:13:02.877235
Duration0.46 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

조직개편일자
Date

Distinct3
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2018-10-15 00:00:00
Maximum2023-01-03 00:00:00
2023-12-13T01:13:02.929133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:13:03.044344image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=3)

시군명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
전라북도 무주군
168 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row전라북도 무주군
2nd row전라북도 무주군
3rd row전라북도 무주군
4th row전라북도 무주군
5th row전라북도 무주군

Common Values

ValueCountFrequency (%)
전라북도 무주군 168
100.0%

Length

2023-12-13T01:13:03.192443image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T01:13:03.335917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전라북도 168
50.0%
무주군 168
50.0%

부서명
Text

UNIQUE 

Distinct168
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-13T01:13:03.742313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length7.9642857
Min length2

Characters and Unicode

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

Unique

Unique168 ?
Unique (%)100.0%

Sample

1st row군수
2nd row전라북도 무주군수 비서실
3rd row부군수
4th row부군수 부속실
5th row기획실
ValueCountFrequency (%)
의료지원과 11
 
3.6%
민원봉사과 8
 
2.6%
자치행정과 7
 
2.3%
재무과 7
 
2.3%
사회복지과 7
 
2.3%
기획실 7
 
2.3%
안성면 6
 
2.0%
산업경제과 6
 
2.0%
기술연구과 6
 
2.0%
개발 6
 
2.0%
Other values (137) 232
76.6%
2023-12-13T01:13:04.390810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
135
 
10.1%
과 109
 
8.1%
지 56
 
4.2%
업 39
 
2.9%
원 36
 
2.7%
사 35
 
2.6%
무 33
 
2.5%
정 31
 
2.3%
면 27
 
2.0%
농 26
 
1.9%
Other values (160) 811
60.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1203
89.9%
Space Separator 135
 
10.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
과 109
 
9.1%
지 56
 
4.7%
업 39
 
3.2%
원 36
 
3.0%
사 35
 
2.9%
무 33
 
2.7%
정 31
 
2.6%
면 27
 
2.2%
농 26
 
2.2%
건 25
 
2.1%
Other values (159) 786
65.3%
Space Separator
ValueCountFrequency (%)
135
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1203
89.9%
Common 135
 
10.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
과 109
 
9.1%
지 56
 
4.7%
업 39
 
3.2%
원 36
 
3.0%
사 35
 
2.9%
무 33
 
2.7%
정 31
 
2.6%
면 27
 
2.2%
농 26
 
2.2%
건 25
 
2.1%
Other values (159) 786
65.3%
Common
ValueCountFrequency (%)
135
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1203
89.9%
ASCII 135
 
10.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
135
100.0%
Hangul
ValueCountFrequency (%)
과 109
 
9.1%
지 56
 
4.7%
업 39
 
3.2%
원 36
 
3.0%
사 35
 
2.9%
무 33
 
2.7%
정 31
 
2.6%
면 27
 
2.2%
농 26
 
2.2%
건 25
 
2.1%
Other values (159) 786
65.3%

부서대표번호
Categorical

HIGH CORRELATION 

Distinct32
Distinct (%)19.0%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
063-320-8403
 
11
063-320-2242
 
8
063-320-2141
 
7
063-320-2842
 
7
063-320-2284
 
7
Other values (27)
128 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique4 ?
Unique (%)2.4%

Sample

1st row063-320-2201
2nd row063-320-2306
3rd row063-320-2204
4th row063-320-2205
5th row063-320-2146

Common Values

ValueCountFrequency (%)
063-320-8403 11
 
6.5%
063-320-2242 8
 
4.8%
063-320-2141 7
 
4.2%
063-320-2842 7
 
4.2%
063-320-2284 7
 
4.2%
063-320-2323 7
 
4.2%
063-320-2146 7
 
4.2%
063-320-2778 6
 
3.6%
063-320-8212 6
 
3.6%
063-320-2857 6
 
3.6%
Other values (22) 96
57.1%

Length

2023-12-13T01:13:04.594478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
063-320-8403 11
 
6.5%
063-320-2242 8
 
4.8%
063-320-2141 7
 
4.2%
063-320-2842 7
 
4.2%
063-320-2284 7
 
4.2%
063-320-2323 7
 
4.2%
063-320-2146 7
 
4.2%
063-320-2354 6
 
3.6%
063-320-5803 6
 
3.6%
063-320-5705 6
 
3.6%
Other values (22) 96
57.1%

부서팩스번호
Categorical

HIGH CORRELATION 

Distinct34
Distinct (%)20.2%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
063-320-2229
 
9
063-320-2248
 
8
063-320-2239
 
8
063-320-2389
 
7
063-320-2838
 
7
Other values (29)
129 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique6 ?
Unique (%)3.6%

Sample

1st row063-320-2303
2nd row063-320-2303
3rd row063-320-2229
4th row063-320-2229
5th row063-320-2229

Common Values

ValueCountFrequency (%)
063-320-2229 9
 
5.4%
063-320-2248 8
 
4.8%
063-320-2239 8
 
4.8%
063-320-2389 7
 
4.2%
063-320-2838 7
 
4.2%
063-320-2289 7
 
4.2%
063-320-2349 7
 
4.2%
063-320-2879 6
 
3.6%
063-320-2815 6
 
3.6%
063-320-2806 6
 
3.6%
Other values (24) 97
57.7%

Length

2023-12-13T01:13:04.776673image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
063-320-2229 9
 
5.4%
063-320-2239 8
 
4.8%
063-320-2248 8
 
4.8%
063-320-2389 7
 
4.2%
063-320-2838 7
 
4.2%
063-320-2289 7
 
4.2%
063-320-2349 7
 
4.2%
063-320-2681 6
 
3.6%
063-320-8239 6
 
3.6%
063-324-2283 6
 
3.6%
Other values (24) 97
57.7%

기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2023-03-07 00:00:00
Maximum2023-03-07 00:00:00
2023-12-13T01:13:04.929294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:13:05.069213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-13T01:13:05.173482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
조직개편일자부서대표번호부서팩스번호
조직개편일자1.0000.8170.810
부서대표번호0.8171.0000.997
부서팩스번호0.8100.9971.000
2023-12-13T01:13:05.304001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
부서팩스번호부서대표번호
부서팩스번호1.0000.906
부서대표번호0.9061.000
2023-12-13T01:13:05.816180image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
부서대표번호부서팩스번호
부서대표번호1.0000.906
부서팩스번호0.9061.000

Missing values

2023-12-13T01:13:02.714702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T01:13:02.836438image/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

조직개편일자시군명부서명부서대표번호부서팩스번호기준일자
02018-10-15전라북도 무주군군수063-320-2201063-320-23032023-03-07
12018-10-15전라북도 무주군전라북도 무주군수 비서실063-320-2306063-320-23032023-03-07
22018-10-15전라북도 무주군부군수063-320-2204063-320-22292023-03-07
32018-10-15전라북도 무주군부군수 부속실063-320-2205063-320-22292023-03-07
42018-10-15전라북도 무주군기획실063-320-2146063-320-22292023-03-07
52023-01-03전라북도 무주군기획실 기획063-320-2146063-320-22292023-03-07
62018-10-15전라북도 무주군기획실 예산063-320-2146063-320-22292023-03-07
72018-10-15전라북도 무주군기획실 홍보063-320-2146063-320-22292023-03-07
82018-10-15전라북도 무주군기획실 감사063-320-2146063-320-22292023-03-07
92023-01-03전라북도 무주군기획실 법무063-320-2146063-320-22292023-03-07
조직개편일자시군명부서명부서대표번호부서팩스번호기준일자
1582018-10-15전라북도 무주군안성면 총무063-320-5903063-323-75532023-03-07
1592018-10-15전라북도 무주군안성면 민원063-320-5903063-323-75532023-03-07
1602018-10-15전라북도 무주군안성면 맞춤형복지063-320-5903063-323-75532023-03-07
1612018-10-15전라북도 무주군안성면 산업063-320-5903063-323-75532023-03-07
1622018-10-15전라북도 무주군안성면 개발063-320-5903063-323-75532023-03-07
1632018-10-15전라북도 무주군부남면063-320-5953063-320-59782023-03-07
1642018-10-15전라북도 무주군부남면 총무063-320-5953063-320-59782023-03-07
1652018-10-15전라북도 무주군부남면 맞춤형복지063-320-5953063-320-59782023-03-07
1662018-10-15전라북도 무주군부남면 산업063-320-5953063-320-59782023-03-07
1672023-01-03전라북도 무주군부남면 개발063-320-5953063-320-59782023-03-07