Overview

Dataset statistics

Number of variables8
Number of observations41
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.7 KiB
Average record size in memory68.1 B

Variable types

Numeric1
Categorical5
Text2

Dataset

Description전라북도 정읍시 폐형광등 폐건전지 수거대상목록(관리번호, 주택구분, 행정동, 공동주택명, 세부위치, 관리부서, 담당연락처)등의 정보를 제공합니다.
Author전라북도 정읍시
URLhttps://www.data.go.kr/data/15098218/fileData.do

Alerts

주택구분 has constant value ""Constant
관리부서 has constant value ""Constant
담당연락처 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
공동주택명 has unique valuesUnique

Reproduction

Analysis started2024-03-15 02:02:46.687704
Analysis finished2024-03-15 02:02:48.177782
Duration1.49 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct41
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean21
Minimum1
Maximum41
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size497.0 B
2024-03-15T11:02:48.395697image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3
Q111
median21
Q331
95-th percentile39
Maximum41
Range40
Interquartile range (IQR)20

Descriptive statistics

Standard deviation11.979149
Coefficient of variation (CV)0.57043565
Kurtosis-1.2
Mean21
Median Absolute Deviation (MAD)10
Skewness0
Sum861
Variance143.5
MonotonicityStrictly increasing
2024-03-15T11:02:48.663869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=41)
ValueCountFrequency (%)
1 1
 
2.4%
32 1
 
2.4%
24 1
 
2.4%
25 1
 
2.4%
26 1
 
2.4%
27 1
 
2.4%
28 1
 
2.4%
29 1
 
2.4%
30 1
 
2.4%
31 1
 
2.4%
Other values (31) 31
75.6%
ValueCountFrequency (%)
1 1
2.4%
2 1
2.4%
3 1
2.4%
4 1
2.4%
5 1
2.4%
6 1
2.4%
7 1
2.4%
8 1
2.4%
9 1
2.4%
10 1
2.4%
ValueCountFrequency (%)
41 1
2.4%
40 1
2.4%
39 1
2.4%
38 1
2.4%
37 1
2.4%
36 1
2.4%
35 1
2.4%
34 1
2.4%
33 1
2.4%
32 1
2.4%

주택구분
Categorical

CONSTANT 

Distinct1
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size456.0 B
공동주택
41 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row공동주택
2nd row공동주택
3rd row공동주택
4th row공동주택
5th row공동주택

Common Values

ValueCountFrequency (%)
공동주택 41
100.0%

Length

2024-03-15T11:02:48.923882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T11:02:49.237118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공동주택 41
100.0%

행정동
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)24.4%
Missing0
Missing (%)0.0%
Memory size456.0 B
내장상동
13 
초산동
수성동
농소동
북면
Other values (5)

Length

Max length4
Median length3
Mean length3.2682927
Min length2

Unique

Unique3 ?
Unique (%)7.3%

Sample

1st row내장상동
2nd row내장상동
3rd row내장상동
4th row내장상동
5th row내장상동

Common Values

ValueCountFrequency (%)
내장상동 13
31.7%
초산동 8
19.5%
수성동 7
17.1%
농소동 3
 
7.3%
북면 3
 
7.3%
시기동 2
 
4.9%
연지동 2
 
4.9%
상교동 1
 
2.4%
신태인읍 1
 
2.4%
장명동 1
 
2.4%

Length

2024-03-15T11:02:49.537876image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T11:02:49.779589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
내장상동 13
31.7%
초산동 8
19.5%
수성동 7
17.1%
농소동 3
 
7.3%
북면 3
 
7.3%
시기동 2
 
4.9%
연지동 2
 
4.9%
상교동 1
 
2.4%
신태인읍 1
 
2.4%
장명동 1
 
2.4%

공동주택명
Text

UNIQUE 

Distinct41
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size456.0 B
2024-03-15T11:02:50.540695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length7
Mean length6.2682927
Min length2

Characters and Unicode

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

Unique

Unique41 ?
Unique (%)100.0%

Sample

1st row대광로제비앙
2nd row대림
3rd row대우 드림채
4th row상동 주공 2단지
5th row상동 주공 3단지
ValueCountFrequency (%)
주공 7
 
9.1%
2차 5
 
6.5%
상동 5
 
6.5%
현대 4
 
5.2%
1차 4
 
5.2%
성원 3
 
3.9%
파크 3
 
3.9%
수성 3
 
3.9%
3차 3
 
3.9%
시기 2
 
2.6%
Other values (36) 38
49.4%
2024-03-15T11:02:51.546456image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
36
 
14.0%
17
 
6.6%
9
 
3.5%
2 8
 
3.1%
8
 
3.1%
7
 
2.7%
7
 
2.7%
1 6
 
2.3%
6
 
2.3%
6
 
2.3%
Other values (77) 147
57.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 196
76.3%
Space Separator 36
 
14.0%
Decimal Number 19
 
7.4%
Open Punctuation 3
 
1.2%
Close Punctuation 3
 
1.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
17
 
8.7%
9
 
4.6%
8
 
4.1%
7
 
3.6%
7
 
3.6%
6
 
3.1%
6
 
3.1%
6
 
3.1%
6
 
3.1%
4
 
2.0%
Other values (71) 120
61.2%
Decimal Number
ValueCountFrequency (%)
2 8
42.1%
1 6
31.6%
3 5
26.3%
Space Separator
ValueCountFrequency (%)
36
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 196
76.3%
Common 61
 
23.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
17
 
8.7%
9
 
4.6%
8
 
4.1%
7
 
3.6%
7
 
3.6%
6
 
3.1%
6
 
3.1%
6
 
3.1%
6
 
3.1%
4
 
2.0%
Other values (71) 120
61.2%
Common
ValueCountFrequency (%)
36
59.0%
2 8
 
13.1%
1 6
 
9.8%
3 5
 
8.2%
( 3
 
4.9%
) 3
 
4.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 196
76.3%
ASCII 61
 
23.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
36
59.0%
2 8
 
13.1%
1 6
 
9.8%
3 5
 
8.2%
( 3
 
4.9%
) 3
 
4.9%
Hangul
ValueCountFrequency (%)
17
 
8.7%
9
 
4.6%
8
 
4.1%
7
 
3.6%
7
 
3.6%
6
 
3.1%
6
 
3.1%
6
 
3.1%
6
 
3.1%
4
 
2.0%
Other values (71) 120
61.2%
Distinct38
Distinct (%)92.7%
Missing0
Missing (%)0.0%
Memory size456.0 B
2024-03-15T11:02:52.554926image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length23
Mean length17.829268
Min length15

Characters and Unicode

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

Unique

Unique36 ?
Unique (%)87.8%

Sample

1st row전라북도 정읍시 학산로 89-11
2nd row전라북도 정읍시 금붕1길 1-1
3rd row전라북도 정읍시 학산로 103-4
4th row전라북도 정읍시 학산로 89-71
5th row전라북도 정읍시 학산로 89-72
ValueCountFrequency (%)
전라북도 41
24.4%
정읍시 41
24.4%
학산로 7
 
4.2%
북면 3
 
1.8%
정읍북로 3
 
1.8%
631-26 3
 
1.8%
수성2로 2
 
1.2%
47 2
 
1.2%
정읍남로 2
 
1.2%
수성택지2길 2
 
1.2%
Other values (57) 62
36.9%
2024-03-15T11:02:53.832868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
127
17.4%
47
 
6.4%
47
 
6.4%
47
 
6.4%
44
 
6.0%
42
 
5.7%
41
 
5.6%
41
 
5.6%
1 35
 
4.8%
29
 
4.0%
Other values (49) 231
31.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 440
60.2%
Decimal Number 143
 
19.6%
Space Separator 127
 
17.4%
Dash Punctuation 21
 
2.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
47
10.7%
47
10.7%
47
10.7%
44
10.0%
42
9.5%
41
9.3%
41
9.3%
29
 
6.6%
11
 
2.5%
11
 
2.5%
Other values (37) 80
18.2%
Decimal Number
ValueCountFrequency (%)
1 35
24.5%
3 19
13.3%
2 18
12.6%
4 13
 
9.1%
6 12
 
8.4%
9 12
 
8.4%
5 12
 
8.4%
7 9
 
6.3%
8 7
 
4.9%
0 6
 
4.2%
Space Separator
ValueCountFrequency (%)
127
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 21
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 440
60.2%
Common 291
39.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
47
10.7%
47
10.7%
47
10.7%
44
10.0%
42
9.5%
41
9.3%
41
9.3%
29
 
6.6%
11
 
2.5%
11
 
2.5%
Other values (37) 80
18.2%
Common
ValueCountFrequency (%)
127
43.6%
1 35
 
12.0%
- 21
 
7.2%
3 19
 
6.5%
2 18
 
6.2%
4 13
 
4.5%
6 12
 
4.1%
9 12
 
4.1%
5 12
 
4.1%
7 9
 
3.1%
Other values (2) 13
 
4.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 440
60.2%
ASCII 291
39.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
127
43.6%
1 35
 
12.0%
- 21
 
7.2%
3 19
 
6.5%
2 18
 
6.2%
4 13
 
4.5%
6 12
 
4.1%
9 12
 
4.1%
5 12
 
4.1%
7 9
 
3.1%
Other values (2) 13
 
4.5%
Hangul
ValueCountFrequency (%)
47
10.7%
47
10.7%
47
10.7%
44
10.0%
42
9.5%
41
9.3%
41
9.3%
29
 
6.6%
11
 
2.5%
11
 
2.5%
Other values (37) 80
18.2%

관리부서
Categorical

CONSTANT 

Distinct1
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size456.0 B
자원순환과
41 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row자원순환과
2nd row자원순환과
3rd row자원순환과
4th row자원순환과
5th row자원순환과

Common Values

ValueCountFrequency (%)
자원순환과 41
100.0%

Length

2024-03-15T11:02:54.404488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T11:02:54.747755image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
자원순환과 41
100.0%

담당연락처
Categorical

CONSTANT 

Distinct1
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size456.0 B
063-539-8143
41 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row063-539-8143
2nd row063-539-8143
3rd row063-539-8143
4th row063-539-8143
5th row063-539-8143

Common Values

ValueCountFrequency (%)
063-539-8143 41
100.0%

Length

2024-03-15T11:02:55.093685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T11:02:55.443900image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
063-539-8143 41
100.0%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size456.0 B
2023-01-13
41 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-01-13
2nd row2023-01-13
3rd row2023-01-13
4th row2023-01-13
5th row2023-01-13

Common Values

ValueCountFrequency (%)
2023-01-13 41
100.0%

Length

2024-03-15T11:02:55.796727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T11:02:56.139720image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-01-13 41
100.0%

Interactions

2024-03-15T11:02:47.092919image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T11:02:56.358335image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리번호행정동공동주택명세부위치
관리번호1.0000.9471.0001.000
행정동0.9471.0001.0001.000
공동주택명1.0001.0001.0001.000
세부위치1.0001.0001.0001.000
2024-03-15T11:02:56.663005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리번호행정동
관리번호1.0000.615
행정동0.6151.000

Missing values

2024-03-15T11:02:47.468965image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T11:02:48.031060image/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

관리번호주택구분행정동공동주택명세부위치관리부서담당연락처데이터기준일
01공동주택내장상동대광로제비앙전라북도 정읍시 학산로 89-11자원순환과063-539-81432023-01-13
12공동주택내장상동대림전라북도 정읍시 금붕1길 1-1자원순환과063-539-81432023-01-13
23공동주택내장상동대우 드림채전라북도 정읍시 학산로 103-4자원순환과063-539-81432023-01-13
34공동주택내장상동상동 주공 2단지전라북도 정읍시 학산로 89-71자원순환과063-539-81432023-01-13
45공동주택내장상동상동 주공 3단지전라북도 정읍시 학산로 89-72자원순환과063-539-81432023-01-13
56공동주택내장상동상동 현대 1차전라북도 정읍시 하신경9길 14-21자원순환과063-539-81432023-01-13
67공동주택내장상동상동 현대 2차전라북도 정읍시 학산로 127-4자원순환과063-539-81432023-01-13
78공동주택내장상동상동 현대 3차전라북도 정읍시 상동중앙로 62-16자원순환과063-539-81432023-01-13
89공동주택내장상동신성 미소지움전라북도 정읍시 상동중앙로 41자원순환과063-539-81432023-01-13
910공동주택내장상동엘드 수목토전라북도 정읍시 학산로 89-25자원순환과063-539-81432023-01-13
관리번호주택구분행정동공동주택명세부위치관리부서담당연락처데이터기준일
3132공동주택연지동영무예다음(2차)전라북도 정읍시 중앙로 55자원순환과063-539-81432023-01-13
3233공동주택장명동영창 파크전라북도 정읍시 말고개길 73-5자원순환과063-539-81432023-01-13
3334공동주택초산동센트럴 카운티전라북도 정읍시 시기1길 22자원순환과063-539-81432023-01-13
3435공동주택초산동시기 주공전라북도 정읍시 천변로 350자원순환과063-539-81432023-01-13
3536공동주택초산동시기 현대전라북도 정읍시 초산로 3-1자원순환과063-539-81432023-01-13
3637공동주택초산동신기 메이플전라북도 정읍시 정읍남로 1348자원순환과063-539-81432023-01-13
3738공동주택초산동양우내안애아파트전라북도 정읍시 천변로 394-16자원순환과063-539-81432023-01-13
3839공동주택초산동유창 파크 1차전라북도 정읍시 남산5길 19-9자원순환과063-539-81432023-01-13
3940공동주택초산동유창 파크 2차전라북도 정읍시 남산6길 10자원순환과063-539-81432023-01-13
4041공동주택초산동코아루 천년가전라북도 정읍시 정읍남로 1400자원순환과063-539-81432023-01-13