Overview

Dataset statistics

Number of variables18
Number of observations24
Missing cells109
Missing cells (%)25.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.7 KiB
Average record size in memory158.5 B

Variable types

Numeric4
Categorical5
DateTime2
Unsupported3
Text4

Dataset

Description충청남도 청양군에 소재하는 소비자를 직접 방문하여 화장품 등 재화 또는 용역을 판매하는 업소 데이터로 영업상태, 주소, 사업장명 등의 정보 제공
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=420&beforeMenuCd=DOM_000000201001001000&publicdatapk=3078357

Alerts

개방서비스명 has constant value ""Constant
영업상태구분코드 is highly overall correlated with 번호 and 5 other fieldsHigh correlation
상세영업상태명 is highly overall correlated with 번호 and 5 other fieldsHigh correlation
상세영업상태코드 is highly overall correlated with 번호 and 5 other fieldsHigh correlation
영업상태명 is highly overall correlated with 번호 and 5 other fieldsHigh correlation
번호 is highly overall correlated with 영업상태구분코드 and 3 other fieldsHigh correlation
관리번호 is highly overall correlated with 영업상태구분코드 and 3 other fieldsHigh correlation
좌표정보(Y) is highly overall correlated with 영업상태구분코드 and 3 other fieldsHigh correlation
폐업일자 has 10 (41.7%) missing valuesMissing
휴업시작일자 has 24 (100.0%) missing valuesMissing
휴업종료일자 has 24 (100.0%) missing valuesMissing
재개업일자 has 24 (100.0%) missing valuesMissing
소재지전화 has 7 (29.2%) missing valuesMissing
소재지전체주소 has 2 (8.3%) missing valuesMissing
도로명전체주소 has 6 (25.0%) missing valuesMissing
좌표정보(X) has 6 (25.0%) missing valuesMissing
좌표정보(Y) has 6 (25.0%) missing valuesMissing
번호 has unique valuesUnique
관리번호 has unique valuesUnique
사업장명 has unique valuesUnique
휴업시작일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
휴업종료일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
재개업일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-04-16 18:57:20.658515
Analysis finished2024-04-16 18:57:25.462157
Duration4.8 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct24
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean72871.5
Minimum72860
Maximum72883
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2024-04-17T03:57:25.530850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum72860
5-th percentile72861.15
Q172865.75
median72871.5
Q372877.25
95-th percentile72881.85
Maximum72883
Range23
Interquartile range (IQR)11.5

Descriptive statistics

Standard deviation7.0710678
Coefficient of variation (CV)9.703475 × 10-5
Kurtosis-1.2
Mean72871.5
Median Absolute Deviation (MAD)6
Skewness0
Sum1748916
Variance50
MonotonicityStrictly increasing
2024-04-17T03:57:25.672087image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
72860 1
 
4.2%
72873 1
 
4.2%
72883 1
 
4.2%
72882 1
 
4.2%
72881 1
 
4.2%
72880 1
 
4.2%
72879 1
 
4.2%
72878 1
 
4.2%
72877 1
 
4.2%
72876 1
 
4.2%
Other values (14) 14
58.3%
ValueCountFrequency (%)
72860 1
4.2%
72861 1
4.2%
72862 1
4.2%
72863 1
4.2%
72864 1
4.2%
72865 1
4.2%
72866 1
4.2%
72867 1
4.2%
72868 1
4.2%
72869 1
4.2%
ValueCountFrequency (%)
72883 1
4.2%
72882 1
4.2%
72881 1
4.2%
72880 1
4.2%
72879 1
4.2%
72878 1
4.2%
72877 1
4.2%
72876 1
4.2%
72875 1
4.2%
72874 1
4.2%

개방서비스명
Categorical

CONSTANT 

Distinct1
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size324.0 B
방문판매업
24 

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 (%)
방문판매업 24
100.0%

Length

2024-04-17T03:57:25.793371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T03:57:25.881560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
방문판매업 24
100.0%

관리번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct24
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0112923 × 1018
Minimum1.995459 × 1018
Maximum2.020459 × 1018
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2024-04-17T03:57:25.987293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.995459 × 1018
5-th percentile2.004459 × 1018
Q12.007459 × 1018
median2.010459 × 1018
Q32.017709 × 1018
95-th percentile2.019459 × 1018
Maximum2.020459 × 1018
Range2.500001 × 1016
Interquartile range (IQR)1.025 × 1016

Descriptive statistics

Standard deviation6.1053559 × 1015
Coefficient of variation (CV)0.0030355388
Kurtosis0.37610609
Mean2.0112923 × 1018
Median Absolute Deviation (MAD)3 × 1015
Skewness-0.36164503
Sum-7.0692162 × 1018
Variance3.7275371 × 1031
MonotonicityNot monotonic
2024-04-17T03:57:26.117573image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
2019459001023200001 1
 
4.2%
2009459001023200002 1
 
4.2%
2019459001023200002 1
 
4.2%
2007459001023200003 1
 
4.2%
2007459001023200002 1
 
4.2%
2007459001023200001 1
 
4.2%
2004459001023200002 1
 
4.2%
2017459001023200001 1
 
4.2%
2013459001023200001 1
 
4.2%
2012459001023200001 1
 
4.2%
Other values (14) 14
58.3%
ValueCountFrequency (%)
1995459001023200001 1
4.2%
2004459001023200001 1
4.2%
2004459001023200002 1
4.2%
2007459001023200001 1
4.2%
2007459001023200002 1
4.2%
2007459001023200003 1
4.2%
2007459001023200004 1
4.2%
2007459001023200005 1
4.2%
2008459001023200001 1
4.2%
2008459001023200002 1
4.2%
ValueCountFrequency (%)
2020459011323200001 1
4.2%
2019459001023200002 1
4.2%
2019459001023200001 1
4.2%
2018459001023200004 1
4.2%
2018459001023200003 1
4.2%
2018459001023200001 1
4.2%
2017459001023200001 1
4.2%
2013459001023200001 1
4.2%
2012459001023200003 1
4.2%
2012459001023200001 1
4.2%

인허가일자
Date

Distinct23
Distinct (%)95.8%
Missing0
Missing (%)0.0%
Memory size324.0 B
Minimum1995-05-29 00:00:00
Maximum2019-04-02 00:00:00
2024-04-17T03:57:26.242497image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T03:57:26.355728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)

영업상태구분코드
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)12.5%
Missing0
Missing (%)0.0%
Memory size324.0 B
3
14 
1
8 
4
2 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row3
3rd row1
4th row1
5th row1

Common Values

ValueCountFrequency (%)
3 14
58.3%
1 8
33.3%
4 2
 
8.3%

Length

2024-04-17T03:57:26.489354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T03:57:26.588597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 14
58.3%
1 8
33.3%
4 2
 
8.3%

영업상태명
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)12.5%
Missing0
Missing (%)0.0%
Memory size324.0 B
폐업
14 
영업/정상
8 
취소/말소/만료/정지/중지
2 

Length

Max length14
Median length2
Mean length4
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row영업/정상
2nd row폐업
3rd row영업/정상
4th row영업/정상
5th row영업/정상

Common Values

ValueCountFrequency (%)
폐업 14
58.3%
영업/정상 8
33.3%
취소/말소/만료/정지/중지 2
 
8.3%

Length

2024-04-17T03:57:26.698084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T03:57:26.792481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 14
58.3%
영업/정상 8
33.3%
취소/말소/만료/정지/중지 2
 
8.3%

상세영업상태코드
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)12.5%
Missing0
Missing (%)0.0%
Memory size324.0 B
3
14 
1
8 
7
2 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row3
3rd row1
4th row1
5th row1

Common Values

ValueCountFrequency (%)
3 14
58.3%
1 8
33.3%
7 2
 
8.3%

Length

2024-04-17T03:57:26.889966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T03:57:26.984614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 14
58.3%
1 8
33.3%
7 2
 
8.3%

상세영업상태명
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)12.5%
Missing0
Missing (%)0.0%
Memory size324.0 B
폐업처리
14 
정상영업
8 
직권말소
2 

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 (%)
폐업처리 14
58.3%
정상영업 8
33.3%
직권말소 2
 
8.3%

Length

2024-04-17T03:57:27.079627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T03:57:27.182135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업처리 14
58.3%
정상영업 8
33.3%
직권말소 2
 
8.3%

폐업일자
Date

MISSING 

Distinct14
Distinct (%)100.0%
Missing10
Missing (%)41.7%
Memory size324.0 B
Minimum2007-05-18 00:00:00
Maximum2020-01-17 00:00:00
2024-04-17T03:57:27.278318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T03:57:27.432050image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)

휴업시작일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

휴업종료일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

재개업일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

소재지전화
Text

MISSING 

Distinct17
Distinct (%)100.0%
Missing7
Missing (%)29.2%
Memory size324.0 B
2024-04-17T03:57:27.608399image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique17 ?
Unique (%)100.0%

Sample

1st row041-944-1228
2nd row041-942-2922
3rd row041-943-8942
4th row041-943-0281
5th row041-942-0681
ValueCountFrequency (%)
041-944-1228 1
 
5.9%
041-942-5955 1
 
5.9%
041-943-6665 1
 
5.9%
041-942-9400 1
 
5.9%
041-856-6513 1
 
5.9%
041-942-9701 1
 
5.9%
041-943-0407 1
 
5.9%
041-942-9300 1
 
5.9%
041-943-3225 1
 
5.9%
041-942-2922 1
 
5.9%
Other values (7) 7
41.2%
2024-04-17T03:57:27.897851image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4 38
18.6%
- 34
16.7%
0 28
13.7%
1 26
12.7%
9 25
12.3%
2 20
9.8%
3 12
 
5.9%
5 7
 
3.4%
8 6
 
2.9%
6 6
 
2.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 170
83.3%
Dash Punctuation 34
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 38
22.4%
0 28
16.5%
1 26
15.3%
9 25
14.7%
2 20
11.8%
3 12
 
7.1%
5 7
 
4.1%
8 6
 
3.5%
6 6
 
3.5%
7 2
 
1.2%
Dash Punctuation
ValueCountFrequency (%)
- 34
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 204
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
4 38
18.6%
- 34
16.7%
0 28
13.7%
1 26
12.7%
9 25
12.3%
2 20
9.8%
3 12
 
5.9%
5 7
 
3.4%
8 6
 
2.9%
6 6
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 204
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4 38
18.6%
- 34
16.7%
0 28
13.7%
1 26
12.7%
9 25
12.3%
2 20
9.8%
3 12
 
5.9%
5 7
 
3.4%
8 6
 
2.9%
6 6
 
2.9%

소재지전체주소
Text

MISSING 

Distinct22
Distinct (%)100.0%
Missing2
Missing (%)8.3%
Memory size324.0 B
2024-04-17T03:57:28.124056image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length42
Median length28
Mean length25.590909
Min length16

Characters and Unicode

Total characters563
Distinct characters52
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

Unique22 ?
Unique (%)100.0%

Sample

1st row충청남도 청양군 정산면 역촌리 386번지 4호
2nd row충청남도 청양군 정산면 서정리 473-7번지
3rd row충청남도 청양군 청양읍 읍내리 203번지 30호
4th row충청남도 청양군 청양읍 읍내리 201번지 4호
5th row충청남도 청양군 청양읍 읍내리 375번지 2호
ValueCountFrequency (%)
청양군 22
16.9%
충청남도 20
15.4%
청양읍 18
13.8%
읍내리 15
 
11.5%
정산면 3
 
2.3%
4호 3
 
2.3%
9호 2
 
1.5%
충남 2
 
1.5%
서정리 2
 
1.5%
1호 2
 
1.5%
Other values (41) 41
31.5%
2024-04-17T03:57:28.492184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
108
19.2%
청 61
 
10.8%
양 41
 
7.3%
읍 34
 
6.0%
충 22
 
3.9%
남 22
 
3.9%
군 22
 
3.9%
리 22
 
3.9%
1 22
 
3.9%
도 20
 
3.6%
Other values (42) 189
33.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 352
62.5%
Space Separator 108
 
19.2%
Decimal Number 96
 
17.1%
Dash Punctuation 7
 
1.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
청 61
17.3%
양 41
11.6%
읍 34
9.7%
충 22
 
6.2%
남 22
 
6.2%
군 22
 
6.2%
리 22
 
6.2%
도 20
 
5.7%
번 18
 
5.1%
지 18
 
5.1%
Other values (30) 72
20.5%
Decimal Number
ValueCountFrequency (%)
1 22
22.9%
2 16
16.7%
7 13
13.5%
0 10
10.4%
3 9
9.4%
4 7
 
7.3%
9 6
 
6.2%
5 5
 
5.2%
8 5
 
5.2%
6 3
 
3.1%
Space Separator
ValueCountFrequency (%)
108
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 352
62.5%
Common 211
37.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
청 61
17.3%
양 41
11.6%
읍 34
9.7%
충 22
 
6.2%
남 22
 
6.2%
군 22
 
6.2%
리 22
 
6.2%
도 20
 
5.7%
번 18
 
5.1%
지 18
 
5.1%
Other values (30) 72
20.5%
Common
ValueCountFrequency (%)
108
51.2%
1 22
 
10.4%
2 16
 
7.6%
7 13
 
6.2%
0 10
 
4.7%
3 9
 
4.3%
- 7
 
3.3%
4 7
 
3.3%
9 6
 
2.8%
5 5
 
2.4%
Other values (2) 8
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 352
62.5%
ASCII 211
37.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
108
51.2%
1 22
 
10.4%
2 16
 
7.6%
7 13
 
6.2%
0 10
 
4.7%
3 9
 
4.3%
- 7
 
3.3%
4 7
 
3.3%
9 6
 
2.8%
5 5
 
2.4%
Other values (2) 8
 
3.8%
Hangul
ValueCountFrequency (%)
청 61
17.3%
양 41
11.6%
읍 34
9.7%
충 22
 
6.2%
남 22
 
6.2%
군 22
 
6.2%
리 22
 
6.2%
도 20
 
5.7%
번 18
 
5.1%
지 18
 
5.1%
Other values (30) 72
20.5%

도로명전체주소
Text

MISSING 

Distinct18
Distinct (%)100.0%
Missing6
Missing (%)25.0%
Memory size324.0 B
2024-04-17T03:57:28.684179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length31
Median length25
Mean length22.333333
Min length19

Characters and Unicode

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

Unique

Unique18 ?
Unique (%)100.0%

Sample

1st row충청남도 청양군 정산면 충의로 1576-16
2nd row충청남도 청양군 청양읍 칠갑산로 245-2
3rd row충청남도 청양군 청양읍 중앙로9길 6
4th row충청남도 청양군 청양읍 중앙로 134
5th row충청남도 청양군 청양읍 중앙로 72
ValueCountFrequency (%)
충청남도 18
19.1%
청양군 18
19.1%
청양읍 15
16.0%
중앙로 3
 
3.2%
칠갑산로 2
 
2.1%
칠갑산로6길 2
 
2.1%
정산면 2
 
2.1%
8 1
 
1.1%
청산로 1
 
1.1%
29 1
 
1.1%
Other values (31) 31
33.0%
2024-04-17T03:57:28.996851image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
76
18.9%
청 54
13.4%
양 34
 
8.5%
충 19
 
4.7%
남 18
 
4.5%
도 18
 
4.5%
군 18
 
4.5%
읍 15
 
3.7%
로 14
 
3.5%
길 10
 
2.5%
Other values (41) 126
31.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 262
65.2%
Space Separator 76
 
18.9%
Decimal Number 54
 
13.4%
Dash Punctuation 6
 
1.5%
Other Punctuation 2
 
0.5%
Open Punctuation 1
 
0.2%
Close Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
청 54
20.6%
양 34
13.0%
충 19
 
7.3%
남 18
 
6.9%
도 18
 
6.9%
군 18
 
6.9%
읍 15
 
5.7%
로 14
 
5.3%
길 10
 
3.8%
산 10
 
3.8%
Other values (27) 52
19.8%
Decimal Number
ValueCountFrequency (%)
2 10
18.5%
1 9
16.7%
8 7
13.0%
3 7
13.0%
6 6
11.1%
7 4
 
7.4%
9 4
 
7.4%
5 4
 
7.4%
4 3
 
5.6%
Space Separator
ValueCountFrequency (%)
76
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%
Other Punctuation
ValueCountFrequency (%)
, 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 262
65.2%
Common 140
34.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
청 54
20.6%
양 34
13.0%
충 19
 
7.3%
남 18
 
6.9%
도 18
 
6.9%
군 18
 
6.9%
읍 15
 
5.7%
로 14
 
5.3%
길 10
 
3.8%
산 10
 
3.8%
Other values (27) 52
19.8%
Common
ValueCountFrequency (%)
76
54.3%
2 10
 
7.1%
1 9
 
6.4%
8 7
 
5.0%
3 7
 
5.0%
- 6
 
4.3%
6 6
 
4.3%
7 4
 
2.9%
9 4
 
2.9%
5 4
 
2.9%
Other values (4) 7
 
5.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 262
65.2%
ASCII 140
34.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
76
54.3%
2 10
 
7.1%
1 9
 
6.4%
8 7
 
5.0%
3 7
 
5.0%
- 6
 
4.3%
6 6
 
4.3%
7 4
 
2.9%
9 4
 
2.9%
5 4
 
2.9%
Other values (4) 7
 
5.0%
Hangul
ValueCountFrequency (%)
청 54
20.6%
양 34
13.0%
충 19
 
7.3%
남 18
 
6.9%
도 18
 
6.9%
군 18
 
6.9%
읍 15
 
5.7%
로 14
 
5.3%
길 10
 
3.8%
산 10
 
3.8%
Other values (27) 52
19.8%

사업장명
Text

UNIQUE 

Distinct24
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size324.0 B
2024-04-17T03:57:29.198514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length11
Mean length7.5416667
Min length3

Characters and Unicode

Total characters181
Distinct characters102
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

Unique24 ?
Unique (%)100.0%

Sample

1st row한스텍 주식회사
2nd row이주통상
3rd row뉴톤보청기 청양부여지사
4th row동명생활건강
5th row오휘(충남지사)
ValueCountFrequency (%)
한스텍 1
 
3.2%
삼성관광 1
 
3.2%
청양학원 1
 
3.2%
영어숲 1
 
3.2%
윤선생 1
 
3.2%
직거래 1
 
3.2%
청양특약점 1
 
3.2%
아모레퍼시픽 1
 
3.2%
윤선생영어교실 1
 
3.2%
남양유업청양가정대리점 1
 
3.2%
Other values (21) 21
67.7%
2024-04-17T03:57:29.529181image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
청 10
 
5.5%
양 9
 
5.0%
7
 
3.9%
동 5
 
2.8%
대 4
 
2.2%
사 4
 
2.2%
점 4
 
2.2%
산 3
 
1.7%
업 3
 
1.7%
생 3
 
1.7%
Other values (92) 129
71.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 169
93.4%
Space Separator 7
 
3.9%
Close Punctuation 2
 
1.1%
Open Punctuation 2
 
1.1%
Other Punctuation 1
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
청 10
 
5.9%
양 9
 
5.3%
동 5
 
3.0%
대 4
 
2.4%
사 4
 
2.4%
점 4
 
2.4%
산 3
 
1.8%
업 3
 
1.8%
생 3
 
1.8%
기 3
 
1.8%
Other values (88) 121
71.6%
Space Separator
ValueCountFrequency (%)
7
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 169
93.4%
Common 12
 
6.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
청 10
 
5.9%
양 9
 
5.3%
동 5
 
3.0%
대 4
 
2.4%
사 4
 
2.4%
점 4
 
2.4%
산 3
 
1.8%
업 3
 
1.8%
생 3
 
1.8%
기 3
 
1.8%
Other values (88) 121
71.6%
Common
ValueCountFrequency (%)
7
58.3%
) 2
 
16.7%
( 2
 
16.7%
& 1
 
8.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 169
93.4%
ASCII 12
 
6.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
청 10
 
5.9%
양 9
 
5.3%
동 5
 
3.0%
대 4
 
2.4%
사 4
 
2.4%
점 4
 
2.4%
산 3
 
1.8%
업 3
 
1.8%
생 3
 
1.8%
기 3
 
1.8%
Other values (88) 121
71.6%
ASCII
ValueCountFrequency (%)
7
58.3%
) 2
 
16.7%
( 2
 
16.7%
& 1
 
8.3%

좌표정보(X)
Real number (ℝ)

MISSING 

Distinct18
Distinct (%)100.0%
Missing6
Missing (%)25.0%
Infinite0
Infinite (%)0.0%
Mean183916.26
Minimum182013.22
Maximum195598.81
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2024-04-17T03:57:29.664740image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum182013.22
5-th percentile182082.07
Q1182181.26
median182262.22
Q3182361.43
95-th percentile195443.94
Maximum195598.81
Range13585.587
Interquartile range (IQR)180.16772

Descriptive statistics

Standard deviation4309.4822
Coefficient of variation (CV)0.023431763
Kurtosis5.2001805
Mean183916.26
Median Absolute Deviation (MAD)94.295562
Skewness2.523531
Sum3310492.7
Variance18571637
MonotonicityNot monotonic
2024-04-17T03:57:29.795886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
182276.297442 1
 
4.2%
182238.451645 1
 
4.2%
182122.094877 1
 
4.2%
182013.218962 1
 
4.2%
182389.454644 1
 
4.2%
185989.021766 1
 
4.2%
182248.139541 1
 
4.2%
182170.64791 1
 
4.2%
195598.805925 1
 
4.2%
182321.846536 1
 
4.2%
Other values (8) 8
33.3%
(Missing) 6
25.0%
ValueCountFrequency (%)
182013.218962 1
4.2%
182094.225438 1
4.2%
182122.094877 1
4.2%
182165.19795 1
4.2%
182170.64791 1
4.2%
182213.089682 1
4.2%
182222.556504 1
4.2%
182238.451645 1
4.2%
182248.139541 1
4.2%
182276.297442 1
4.2%
ValueCountFrequency (%)
195598.805925 1
4.2%
195416.610776 1
4.2%
185989.021766 1
4.2%
182389.454644 1
4.2%
182367.171747 1
4.2%
182344.189055 1
4.2%
182321.846536 1
4.2%
182301.6944 1
4.2%
182276.297442 1
4.2%
182248.139541 1
4.2%

좌표정보(Y)
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct18
Distinct (%)100.0%
Missing6
Missing (%)25.0%
Infinite0
Infinite (%)0.0%
Mean327821.87
Minimum323365.92
Maximum335699.55
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2024-04-17T03:57:29.939928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum323365.92
5-th percentile324640.49
Q1327373.49
median327748.42
Q3327855.7
95-th percentile330854.8
Maximum335699.55
Range12333.632
Interquartile range (IQR)482.20872

Descriptive statistics

Standard deviation2402.16
Coefficient of variation (CV)0.0073276381
Kurtosis7.331092
Mean327821.87
Median Absolute Deviation (MAD)232.29435
Skewness1.8265645
Sum5900793.7
Variance5770372.8
MonotonicityNot monotonic
2024-04-17T03:57:30.050359image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
327721.662946 1
 
4.2%
327775.183823 1
 
4.2%
327430.662547 1
 
4.2%
326565.416961 1
 
4.2%
327858.904827 1
 
4.2%
335699.551716 1
 
4.2%
327177.074784 1
 
4.2%
327633.378831 1
 
4.2%
324865.415662 1
 
4.2%
327806.002852 1
 
4.2%
Other values (8) 8
33.3%
(Missing) 6
25.0%
ValueCountFrequency (%)
323365.919401 1
4.2%
324865.415662 1
4.2%
326565.416961 1
4.2%
327177.074784 1
4.2%
327354.428516 1
4.2%
327430.662547 1
4.2%
327633.378831 1
4.2%
327683.28446 1
4.2%
327721.662946 1
4.2%
327775.183823 1
4.2%
ValueCountFrequency (%)
335699.551716 1
4.2%
329999.845528 1
4.2%
328328.835731 1
4.2%
327895.251242 1
4.2%
327858.904827 1
4.2%
327846.068489 1
4.2%
327806.002852 1
4.2%
327786.809982 1
4.2%
327775.183823 1
4.2%
327721.662946 1
4.2%

Interactions

2024-04-17T03:57:24.555735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T03:57:23.181400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T03:57:23.808217image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T03:57:24.190547image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T03:57:24.645095image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T03:57:23.326571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T03:57:23.897449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T03:57:24.278150image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T03:57:24.735871image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T03:57:23.432871image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T03:57:24.010943image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T03:57:24.364002image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T03:57:24.839315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T03:57:23.725605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T03:57:24.104839image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T03:57:24.463990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-17T03:57:30.144105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호관리번호인허가일자영업상태구분코드영업상태명상세영업상태코드상세영업상태명폐업일자소재지전화소재지전체주소도로명전체주소사업장명좌표정보(X)좌표정보(Y)
번호1.0000.7471.0000.7820.7820.7820.7821.0001.0001.0001.0001.0000.0000.000
관리번호0.7471.0001.0000.7070.7070.7070.7071.0001.0001.0001.0001.0000.0000.763
인허가일자1.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0000.0000.521
영업상태구분코드0.7820.7071.0001.0001.0001.0001.000NaN1.0001.0001.0001.0000.0000.929
영업상태명0.7820.7071.0001.0001.0001.0001.000NaN1.0001.0001.0001.0000.0000.929
상세영업상태코드0.7820.7071.0001.0001.0001.0001.000NaN1.0001.0001.0001.0000.0000.929
상세영업상태명0.7820.7071.0001.0001.0001.0001.000NaN1.0001.0001.0001.0000.0000.929
폐업일자1.0001.0001.000NaNNaNNaNNaN1.0001.0001.0001.0001.0001.0001.000
소재지전화1.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.000
소재지전체주소1.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.000
도로명전체주소1.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.000
사업장명1.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.0001.000
좌표정보(X)0.0000.0000.0000.0000.0000.0000.0001.0001.0001.0001.0001.0001.0001.000
좌표정보(Y)0.0000.7630.5210.9290.9290.9290.9291.0001.0001.0001.0001.0001.0001.000
2024-04-17T03:57:30.304537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
영업상태구분코드상세영업상태명상세영업상태코드영업상태명
영업상태구분코드1.0001.0001.0001.000
상세영업상태명1.0001.0001.0001.000
상세영업상태코드1.0001.0001.0001.000
영업상태명1.0001.0001.0001.000
2024-04-17T03:57:30.746371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호관리번호좌표정보(X)좌표정보(Y)영업상태구분코드영업상태명상세영업상태코드상세영업상태명
번호1.000-0.245-0.278-0.0130.5430.5430.5430.543
관리번호-0.2451.0000.166-0.0340.5240.5240.5240.524
좌표정보(X)-0.2780.1661.0000.0380.0000.0000.0000.000
좌표정보(Y)-0.013-0.0340.0381.0000.5760.5760.5760.576
영업상태구분코드0.5430.5240.0000.5761.0001.0001.0001.000
영업상태명0.5430.5240.0000.5761.0001.0001.0001.000
상세영업상태코드0.5430.5240.0000.5761.0001.0001.0001.000
상세영업상태명0.5430.5240.0000.5761.0001.0001.0001.000

Missing values

2024-04-17T03:57:24.973555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-17T03:57:25.202250image/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.
2024-04-17T03:57:25.376785image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

번호개방서비스명관리번호인허가일자영업상태구분코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자소재지전화소재지전체주소도로명전체주소사업장명좌표정보(X)좌표정보(Y)
072860방문판매업20194590010232000012019-04-021영업/정상1정상영업<NA><NA><NA><NA>041-944-1228충청남도 청양군 정산면 역촌리 386번지 4호충청남도 청양군 정산면 충의로 1576-16한스텍 주식회사195598.805925324865.415662
172861방문판매업20074590010232000042007-07-103폐업3폐업처리2008-01-14<NA><NA><NA><NA>충청남도 청양군 정산면 서정리 473-7번지<NA>이주통상<NA><NA>
272862방문판매업20184590010232000042018-10-051영업/정상1정상영업<NA><NA><NA><NA>041-942-2922충청남도 청양군 청양읍 읍내리 203번지 30호충청남도 청양군 청양읍 칠갑산로 245-2뉴톤보청기 청양부여지사182321.846536327806.002852
372863방문판매업20204590113232000012019-03-121영업/정상1정상영업<NA><NA><NA><NA><NA>충청남도 청양군 청양읍 읍내리 201번지 4호충청남도 청양군 청양읍 중앙로9길 6동명생활건강182213.089682327895.251242
472864방문판매업20124590010232000032012-12-181영업/정상1정상영업<NA><NA><NA><NA>041-943-8942<NA>충청남도 청양군 청양읍 중앙로 134오휘(충남지사)182301.6944327846.068489
572865방문판매업19954590010232000011995-05-291영업/정상1정상영업<NA><NA><NA><NA>041-943-0281충청남도 청양군 청양읍 읍내리 375번지 2호충청남도 청양군 청양읍 중앙로 72기아자동차 칠갑대리점182222.556504327354.428516
672866방문판매업20184590010232000012018-03-201영업/정상1정상영업<NA><NA><NA><NA>041-942-0681충청남도 청양군 정산면 서정리 157번지 9호 정산농협충청남도 청양군 정산면 정현길 67, 정산농협정산농업협동조합195416.610776323365.919401
772867방문판매업20184590010232000032018-05-211영업/정상1정상영업<NA><NA><NA><NA>041-942-3111충청남도 청양군 청양읍 읍내리 187번지 1호 청양축협충청남도 청양군 청양읍 칠갑산로 224, 청양축협청양축산업협동조합182094.225438327786.809982
872868방문판매업20044590010232000012004-11-174취소/말소/만료/정지/중지7직권말소<NA><NA><NA><NA>041-943-1022충남 청양군 청양읍 읍내리 229-8<NA>예산대우자동차판매청양출장소<NA><NA>
972869방문판매업20074590010232000052007-12-134취소/말소/만료/정지/중지7직권말소<NA><NA><NA><NA>041-942-2943충청남도 청양군 청양읍 학당리 114번지충청남도 청양군 청양읍 원학당길 38낙원농원182165.19795329999.845528
번호개방서비스명관리번호인허가일자영업상태구분코드영업상태명상세영업상태코드상세영업상태명폐업일자휴업시작일자휴업종료일자재개업일자소재지전화소재지전체주소도로명전체주소사업장명좌표정보(X)좌표정보(Y)
1472874방문판매업20114590010232000032011-04-283폐업3폐업처리2016-05-09<NA><NA><NA><NA>충청남도 청양군 청양읍 읍내5리 182번지 19호충청남도 청양군 청양읍 칠갑산로6길 18애터미화장품182170.64791327633.378831
1572875방문판매업20114590010232000042011-10-313폐업3폐업처리2012-10-08<NA><NA><NA>041-943-0407충청남도 청양군 청양읍 읍내리 377번지 5호 천강아파트 101동 1104호충청남도 청양군 청양읍 청산로 29한국암웨이(청양지점)182248.139541327177.074784
1672876방문판매업20124590010232000012012-03-283폐업3폐업처리2012-05-07<NA><NA><NA><NA>충청남도 청양군 운곡면 위라리충청남도 청양군 운곡면 청신로 858대전유통185989.021766335699.551716
1772877방문판매업20134590010232000012013-11-083폐업3폐업처리2014-12-15<NA><NA><NA>041-942-9701<NA>충청남도 청양군 청양읍 칠갑산로5길 8픽스컴&텔182389.454644327858.904827
1872878방문판매업20174590010232000012017-06-263폐업3폐업처리2020-01-17<NA><NA><NA><NA>충청남도 청양군 청양읍 벽천리 172번지 4호충청남도 청양군 청양읍 학사길 21-39남양유업청양가정대리점182013.218962326565.416961
1972879방문판매업20044590010232000022004-12-073폐업3폐업처리2007-05-18<NA><NA><NA>041-856-6513충남 청양군 청양읍 읍내리 201-8<NA>윤선생영어교실<NA><NA>
2072880방문판매업20074590010232000012007-02-013폐업3폐업처리2013-09-06<NA><NA><NA>041-942-9400충청남도 청양군 청양읍 읍내리 326번지 비젼빌딩 2층충청남도 청양군 청양읍 고리섬들길 73 (비젼빌딩 2층)아모레퍼시픽 청양특약점182122.094877327430.662547
2172881방문판매업20074590010232000022007-08-213폐업3폐업처리2007-11-27<NA><NA><NA><NA>충청남도 청양군 청양읍 읍내리 197-1번지<NA>직거래<NA><NA>
2272882방문판매업20074590010232000032007-05-253폐업3폐업처리2014-07-03<NA><NA><NA>041-943-6665충청남도 청양군 청양읍 읍내리 170-9번지<NA>윤선생 영어숲 청양학원<NA><NA>
2372883방문판매업20194590010232000022019-04-021영업/정상1정상영업<NA><NA><NA><NA>041-943-9980충청남도 청양군 청양읍 읍내리 202번지 6호충청남도 청양군 청양읍 칠갑산로6길 3-3굿모닝보청기182238.451645327775.183823