Overview

Dataset statistics

Number of variables4
Number of observations45
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory35.9 B

Variable types

Numeric1
Categorical1
Text2

Dataset

Description충청남도 계룡시 종량제 봉투 판매소에 관한 데이터로서, 면동별, 상호명, 판매소 주소에 대한 공공데이터를 제공합니다.
Author공공데이터포털
URLhttps://www.data.go.kr/data/15093924/fileData.do

Alerts

연번 is highly overall correlated with 면동High correlation
면동 is highly overall correlated with 연번High correlation
연번 has unique valuesUnique
상호 has unique valuesUnique

Reproduction

Analysis started2024-04-17 14:42:11.290992
Analysis finished2024-04-17 14:42:11.684450
Duration0.39 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct45
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23
Minimum1
Maximum45
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size537.0 B
2024-04-17T23:42:11.739938image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.2
Q112
median23
Q334
95-th percentile42.8
Maximum45
Range44
Interquartile range (IQR)22

Descriptive statistics

Standard deviation13.133926
Coefficient of variation (CV)0.57104024
Kurtosis-1.2
Mean23
Median Absolute Deviation (MAD)11
Skewness0
Sum1035
Variance172.5
MonotonicityStrictly increasing
2024-04-17T23:42:11.846176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=45)
ValueCountFrequency (%)
1 1
 
2.2%
35 1
 
2.2%
26 1
 
2.2%
27 1
 
2.2%
28 1
 
2.2%
29 1
 
2.2%
30 1
 
2.2%
31 1
 
2.2%
32 1
 
2.2%
33 1
 
2.2%
Other values (35) 35
77.8%
ValueCountFrequency (%)
1 1
2.2%
2 1
2.2%
3 1
2.2%
4 1
2.2%
5 1
2.2%
6 1
2.2%
7 1
2.2%
8 1
2.2%
9 1
2.2%
10 1
2.2%
ValueCountFrequency (%)
45 1
2.2%
44 1
2.2%
43 1
2.2%
42 1
2.2%
41 1
2.2%
40 1
2.2%
39 1
2.2%
38 1
2.2%
37 1
2.2%
36 1
2.2%

면동
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)8.9%
Missing0
Missing (%)0.0%
Memory size492.0 B
엄사면
17 
두마면
12 
금암동
12 
신도안면

Length

Max length4
Median length3
Mean length3.0888889
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row두마면
2nd row두마면
3rd row두마면
4th row두마면
5th row두마면

Common Values

ValueCountFrequency (%)
엄사면 17
37.8%
두마면 12
26.7%
금암동 12
26.7%
신도안면 4
 
8.9%

Length

2024-04-17T23:42:11.949640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T23:42:12.040217image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
엄사면 17
37.8%
두마면 12
26.7%
금암동 12
26.7%
신도안면 4
 
8.9%

상호
Text

UNIQUE 

Distinct45
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size492.0 B
2024-04-17T23:42:12.200657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length17
Mean length10.911111
Min length3

Characters and Unicode

Total characters491
Distinct characters144
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique45 ?
Unique (%)100.0%

Sample

1st row이마트24 계룡포스코점
2nd row논산계룡농협 계룡로컬푸드센터(직매장)
3rd rowGS25 계룡공단점
4th row지에스 계룡대실와노점
5th row(주)코리아세븐 계룡리슈빌점
ValueCountFrequency (%)
세븐일레븐 7
 
8.6%
씨유 6
 
7.4%
계룡점 4
 
4.9%
지에스25 3
 
3.7%
이마트24 2
 
2.5%
논산계룡농협 2
 
2.5%
gs25 2
 
2.5%
계룡공단점 2
 
2.5%
계룡신성점 2
 
2.5%
주)코리아세븐 2
 
2.5%
Other values (48) 49
60.5%
2024-04-17T23:42:12.501044image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
37
 
7.5%
36
 
7.3%
36
 
7.3%
31
 
6.3%
17
 
3.5%
14
 
2.9%
2 12
 
2.4%
10
 
2.0%
10
 
2.0%
5 9
 
1.8%
Other values (134) 279
56.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 409
83.3%
Space Separator 36
 
7.3%
Decimal Number 23
 
4.7%
Close Punctuation 7
 
1.4%
Open Punctuation 7
 
1.4%
Uppercase Letter 5
 
1.0%
Lowercase Letter 4
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
37
 
9.0%
36
 
8.8%
31
 
7.6%
17
 
4.2%
14
 
3.4%
10
 
2.4%
10
 
2.4%
9
 
2.2%
8
 
2.0%
8
 
2.0%
Other values (123) 229
56.0%
Decimal Number
ValueCountFrequency (%)
2 12
52.2%
5 9
39.1%
4 2
 
8.7%
Uppercase Letter
ValueCountFrequency (%)
S 2
40.0%
G 2
40.0%
R 1
20.0%
Lowercase Letter
ValueCountFrequency (%)
s 2
50.0%
g 2
50.0%
Space Separator
ValueCountFrequency (%)
36
100.0%
Close Punctuation
ValueCountFrequency (%)
) 7
100.0%
Open Punctuation
ValueCountFrequency (%)
( 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 409
83.3%
Common 73
 
14.9%
Latin 9
 
1.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
37
 
9.0%
36
 
8.8%
31
 
7.6%
17
 
4.2%
14
 
3.4%
10
 
2.4%
10
 
2.4%
9
 
2.2%
8
 
2.0%
8
 
2.0%
Other values (123) 229
56.0%
Common
ValueCountFrequency (%)
36
49.3%
2 12
 
16.4%
5 9
 
12.3%
) 7
 
9.6%
( 7
 
9.6%
4 2
 
2.7%
Latin
ValueCountFrequency (%)
S 2
22.2%
G 2
22.2%
s 2
22.2%
g 2
22.2%
R 1
11.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 409
83.3%
ASCII 82
 
16.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
37
 
9.0%
36
 
8.8%
31
 
7.6%
17
 
4.2%
14
 
3.4%
10
 
2.4%
10
 
2.4%
9
 
2.2%
8
 
2.0%
8
 
2.0%
Other values (123) 229
56.0%
ASCII
ValueCountFrequency (%)
36
43.9%
2 12
 
14.6%
5 9
 
11.0%
) 7
 
8.5%
( 7
 
8.5%
S 2
 
2.4%
4 2
 
2.4%
G 2
 
2.4%
s 2
 
2.4%
g 2
 
2.4%
Distinct44
Distinct (%)97.8%
Missing0
Missing (%)0.0%
Memory size492.0 B
2024-04-17T23:42:12.711238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length51
Median length38
Mean length31.666667
Min length19

Characters and Unicode

Total characters1425
Distinct characters113
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique43 ?
Unique (%)95.6%

Sample

1st row충청남도 계룡시 두마면 사계로 101 (상가 207~208호)
2nd row충청남도 계룡시 두마면 대실남북1길 11, 계룡로컬푸드센터
3rd row충청남도 계룡시 두마면 사계로 205
4th row충청남도 계룡시 두마면 대실남북로 82, 101호 (계룡대실 LH 4단지)
5th row충청남도 계룡시 두마면 농소로 64, 101호, 102호(계룡대실리슈빌아파트상가)
ValueCountFrequency (%)
충청남도 45
 
15.3%
계룡시 45
 
15.3%
엄사면 17
 
5.8%
1층 13
 
4.4%
두마면 12
 
4.1%
금암동 9
 
3.1%
번영로 5
 
1.7%
상가동 5
 
1.7%
101호 5
 
1.7%
엄사중앙로 5
 
1.7%
Other values (103) 134
45.4%
2024-04-17T23:42:13.043773image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
250
 
17.5%
1 78
 
5.5%
60
 
4.2%
57
 
4.0%
51
 
3.6%
51
 
3.6%
45
 
3.2%
45
 
3.2%
45
 
3.2%
, 37
 
2.6%
Other values (103) 706
49.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 857
60.1%
Space Separator 250
 
17.5%
Decimal Number 223
 
15.6%
Other Punctuation 37
 
2.6%
Open Punctuation 23
 
1.6%
Close Punctuation 23
 
1.6%
Dash Punctuation 7
 
0.5%
Math Symbol 3
 
0.2%
Uppercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
60
 
7.0%
57
 
6.7%
51
 
6.0%
51
 
6.0%
45
 
5.3%
45
 
5.3%
45
 
5.3%
33
 
3.9%
31
 
3.6%
26
 
3.0%
Other values (85) 413
48.2%
Decimal Number
ValueCountFrequency (%)
1 78
35.0%
0 32
14.3%
3 24
 
10.8%
6 19
 
8.5%
7 18
 
8.1%
2 16
 
7.2%
5 12
 
5.4%
8 12
 
5.4%
4 10
 
4.5%
9 2
 
0.9%
Uppercase Letter
ValueCountFrequency (%)
H 1
50.0%
L 1
50.0%
Space Separator
ValueCountFrequency (%)
250
100.0%
Other Punctuation
ValueCountFrequency (%)
, 37
100.0%
Open Punctuation
ValueCountFrequency (%)
( 23
100.0%
Close Punctuation
ValueCountFrequency (%)
) 23
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%
Math Symbol
ValueCountFrequency (%)
~ 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 857
60.1%
Common 566
39.7%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
60
 
7.0%
57
 
6.7%
51
 
6.0%
51
 
6.0%
45
 
5.3%
45
 
5.3%
45
 
5.3%
33
 
3.9%
31
 
3.6%
26
 
3.0%
Other values (85) 413
48.2%
Common
ValueCountFrequency (%)
250
44.2%
1 78
 
13.8%
, 37
 
6.5%
0 32
 
5.7%
3 24
 
4.2%
( 23
 
4.1%
) 23
 
4.1%
6 19
 
3.4%
7 18
 
3.2%
2 16
 
2.8%
Other values (6) 46
 
8.1%
Latin
ValueCountFrequency (%)
H 1
50.0%
L 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 857
60.1%
ASCII 568
39.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
250
44.0%
1 78
 
13.7%
, 37
 
6.5%
0 32
 
5.6%
3 24
 
4.2%
( 23
 
4.0%
) 23
 
4.0%
6 19
 
3.3%
7 18
 
3.2%
2 16
 
2.8%
Other values (8) 48
 
8.5%
Hangul
ValueCountFrequency (%)
60
 
7.0%
57
 
6.7%
51
 
6.0%
51
 
6.0%
45
 
5.3%
45
 
5.3%
45
 
5.3%
33
 
3.9%
31
 
3.6%
26
 
3.0%
Other values (85) 413
48.2%

Interactions

2024-04-17T23:42:11.508054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-17T23:42:13.124512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번면동상호판매소위치
연번1.0000.9081.0000.930
면동0.9081.0001.0001.000
상호1.0001.0001.0001.000
판매소위치0.9301.0001.0001.000
2024-04-17T23:42:13.206434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번면동
연번1.0000.734
면동0.7341.000

Missing values

2024-04-17T23:42:11.588767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-17T23:42:11.657951image/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두마면이마트24 계룡포스코점충청남도 계룡시 두마면 사계로 101 (상가 207~208호)
12두마면논산계룡농협 계룡로컬푸드센터(직매장)충청남도 계룡시 두마면 대실남북1길 11, 계룡로컬푸드센터
23두마면GS25 계룡공단점충청남도 계룡시 두마면 사계로 205
34두마면지에스 계룡대실와노점충청남도 계룡시 두마면 대실남북로 82, 101호 (계룡대실 LH 4단지)
45두마면(주)코리아세븐 계룡리슈빌점충청남도 계룡시 두마면 농소로 64, 101호, 102호(계룡대실리슈빌아파트상가)
56두마면장보고마트충청남도 계룡시 두마면 사계로 46, 1층 103호~107호
67두마면(주)코리아세븐 계룡푸르지오점충청남도 계룡시 두마면 농소로 63, 계룡푸르지오더퍼스트아파트 단지내상가 107호, 108호
78두마면바른청과야채충청남도 계룡시 두마면 농소로 40, 1층 107, 108호(드림프라자)
89두마면씨유 계룡공단점충청남도 계룡시 두마면 왕대로 98
910두마면픽미픽미아이스크림할인점충청남도 계룡시 두마면 농소로 63, 상가동 205호 (계룡 푸르지오 더 퍼스트)
연번면동상호판매소위치
3536금암동지에스25(gs25) 계룡우림점충청남도 계룡시 장안로 75, 101호 (금암동, 우림루미아트아파트)
3637금암동씨유 계룡점충청남도 계룡시 서금암3길 5, 107호, 108-1호(금암동, 쉐리움)
3738금암동청춘애견 계룡점충청남도 계룡시 계룡대로 333 (금암동)
3839금암동씨유 계룡미소지움2차점충청남도 계룡시 대실남북로 36, 신성2차미소지움아파트 105호 (금암동)
3940금암동계룡철물충청남도 계룡시 금암로 166 (금암동)
4041금암동현대문구충청남도 계룡시 장안로 75 (금암동,우림아파트상가107호)
4142금암동코리아세븐 계룡신성점충청남도 계룡시 장안로 76, 1층 (금암동)
4243금암동세븐일레븐 계룡신성점충청남도 계룡시 장안로 76(금암동)
4344금암동세븐일레븐 계룡클래스점충청남도 계룡시 서금암로 10, 108호 (금암동, 계룡한양아이클래스)
4445금암동수입브랜드 계룡점충청남도 계룡시 서금암2길 13-16, 1층 103호 (금암동)