Overview

Dataset statistics

Number of variables20
Number of observations27
Missing cells43
Missing cells (%)8.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.5 KiB
Average record size in memory168.9 B

Variable types

Numeric2
Text3
Unsupported1
Categorical13
DateTime1

Dataset

Description광주광역시 동구 내 모범음식점 현황입니다. 음식점명, 소재지, 전화번호, 주메뉴, 데이터기준일자 등을 제공합니다.
Author광주광역시 동구
URLhttps://www.data.go.kr/data/3034591/fileData.do

Alerts

영업상태구분코드 has constant value ""Constant
영업상태명 has constant value ""Constant
폐업일자 has constant value ""Constant
지정취소일자 has constant value ""Constant
지정취소사유 has constant value ""Constant
불가일자 has constant value ""Constant
불가사유 has constant value ""Constant
재지정일자 has constant value ""Constant
최종수정일자 has constant value ""Constant
데이터갱신일자 has constant value ""Constant
기타 is highly overall correlated with 관리번호 and 2 other fieldsHigh correlation
지정일자 is highly overall correlated with 음식의유형 and 1 other fieldsHigh correlation
관리번호 is highly overall correlated with 기타High correlation
인허가번호 is highly overall correlated with 음식의유형 and 1 other fieldsHigh correlation
음식의유형 is highly overall correlated with 인허가번호 and 1 other fieldsHigh correlation
소재지주소 has 27 (100.0%) missing valuesMissing
주된음식종류 has 16 (59.3%) missing valuesMissing
인허가번호 has unique valuesUnique
도로명주소 has unique valuesUnique
소재지주소 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 22:43:04.854063
Analysis finished2023-12-12 22:43:06.149695
Duration1.3 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리번호
Real number (ℝ)

HIGH CORRELATION 

Distinct18
Distinct (%)66.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean81.222222
Minimum1
Maximum903
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size375.0 B
2023-12-13T07:43:06.220556image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1.3
Q14
median8
Q331.5
95-th percentile650
Maximum903
Range902
Interquartile range (IQR)27.5

Descriptive statistics

Standard deviation237.31905
Coefficient of variation (CV)2.9218488
Kurtosis10.530848
Mean81.222222
Median Absolute Deviation (MAD)6
Skewness3.4171043
Sum2193
Variance56320.333
MonotonicityNot monotonic
2023-12-13T07:43:06.333240image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
4 4
14.8%
5 3
 
11.1%
8 2
 
7.4%
2 2
 
7.4%
1 2
 
7.4%
9 2
 
7.4%
32 1
 
3.7%
31 1
 
3.7%
33 1
 
3.7%
7 1
 
3.7%
Other values (8) 8
29.6%
ValueCountFrequency (%)
1 2
7.4%
2 2
7.4%
4 4
14.8%
5 3
11.1%
7 1
 
3.7%
8 2
7.4%
9 2
7.4%
11 1
 
3.7%
15 1
 
3.7%
28 1
 
3.7%
ValueCountFrequency (%)
903 1
3.7%
902 1
3.7%
62 1
3.7%
56 1
3.7%
42 1
3.7%
33 1
3.7%
32 1
3.7%
31 1
3.7%
28 1
3.7%
15 1
3.7%

인허가번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.9913547 × 1010
Minimum1.9690214 × 1010
Maximum2.0080214 × 1010
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size375.0 B
2023-12-13T07:43:06.454720image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.9690214 × 1010
5-th percentile1.9713214 × 1010
Q11.9825214 × 1010
median1.9940214 × 1010
Q32.0000214 × 1010
95-th percentile2.0070214 × 1010
Maximum2.0080214 × 1010
Range3.9000018 × 108
Interquartile range (IQR)1.7500021 × 108

Descriptive statistics

Standard deviation1.2219161 × 108
Coefficient of variation (CV)0.0061361046
Kurtosis-0.87255477
Mean1.9913547 × 1010
Median Absolute Deviation (MAD)80000339
Skewness-0.53231826
Sum5.3766578 × 1011
Variance1.493079 × 1016
MonotonicityNot monotonic
2023-12-13T07:43:06.606956image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
19920214107 1
 
3.7%
19980214030 1
 
3.7%
19960214100 1
 
3.7%
19730214022 1
 
3.7%
19720214013 1
 
3.7%
19720214004 1
 
3.7%
20020214097 1
 
3.7%
20080214186 1
 
3.7%
19710214003 1
 
3.7%
19980214233 1
 
3.7%
Other values (17) 17
63.0%
ValueCountFrequency (%)
19690214006 1
3.7%
19710214003 1
3.7%
19720214004 1
3.7%
19720214013 1
3.7%
19730214022 1
3.7%
19780214013 1
3.7%
19810214001 1
3.7%
19840214070 1
3.7%
19900214024 1
3.7%
19910214069 1
3.7%
ValueCountFrequency (%)
20080214186 1
3.7%
20070214300 1
3.7%
20070214093 1
3.7%
20060214230 1
3.7%
20030214249 1
3.7%
20020214531 1
3.7%
20020214097 1
3.7%
19980214403 1
3.7%
19980214233 1
3.7%
19980214030 1
3.7%

업소명
Text

Distinct26
Distinct (%)96.3%
Missing0
Missing (%)0.0%
Memory size348.0 B
2023-12-13T07:43:06.820059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length7
Mean length4.9259259
Min length2

Characters and Unicode

Total characters133
Distinct characters93
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

Unique25 ?
Unique (%)92.6%

Sample

1st row고려조삼계탕
2nd row고흥장어나라
3rd row관가
4th row광양숯불구이지산점
5th row구수숯불갈비
ValueCountFrequency (%)
신락원 2
 
6.9%
고려조삼계탕 1
 
3.4%
황솔촌 1
 
3.4%
하우스 1
 
3.4%
아리랑 1
 
3.4%
한성회관 1
 
3.4%
청하 1
 
3.4%
청원모밀 1
 
3.4%
제주항 1
 
3.4%
제주삼다갈치 1
 
3.4%
Other values (18) 18
62.1%
2023-12-13T07:43:07.186351image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
원 6
 
4.5%
신 3
 
2.3%
이 3
 
2.3%
제 3
 
2.3%
동 3
 
2.3%
장 3
 
2.3%
삼 2
 
1.5%
갈 2
 
1.5%
성 2
 
1.5%
리 2
 
1.5%
Other values (83) 104
78.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 129
97.0%
Space Separator 2
 
1.5%
Close Punctuation 1
 
0.8%
Open Punctuation 1
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
원 6
 
4.7%
신 3
 
2.3%
이 3
 
2.3%
제 3
 
2.3%
동 3
 
2.3%
장 3
 
2.3%
삼 2
 
1.6%
갈 2
 
1.6%
성 2
 
1.6%
리 2
 
1.6%
Other values (80) 100
77.5%
Space Separator
ValueCountFrequency (%)
2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 129
97.0%
Common 4
 
3.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
원 6
 
4.7%
신 3
 
2.3%
이 3
 
2.3%
제 3
 
2.3%
동 3
 
2.3%
장 3
 
2.3%
삼 2
 
1.6%
갈 2
 
1.6%
성 2
 
1.6%
리 2
 
1.6%
Other values (80) 100
77.5%
Common
ValueCountFrequency (%)
2
50.0%
) 1
25.0%
( 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 129
97.0%
ASCII 4
 
3.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
원 6
 
4.7%
신 3
 
2.3%
이 3
 
2.3%
제 3
 
2.3%
동 3
 
2.3%
장 3
 
2.3%
삼 2
 
1.6%
갈 2
 
1.6%
성 2
 
1.6%
리 2
 
1.6%
Other values (80) 100
77.5%
ASCII
ValueCountFrequency (%)
2
50.0%
) 1
25.0%
( 1
25.0%

도로명주소
Text

UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size348.0 B
2023-12-13T07:43:07.493504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length35
Median length31
Mean length28.62963
Min length22

Characters and Unicode

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

Unique

Unique27 ?
Unique (%)100.0%

Sample

1st row광주광역시 동구 금남로 231 (금남로2가,(점포21개))
2nd row광주광역시 동구 필문대로191번길 5-10 (산수동)
3rd row광주광역시 동구 의재로96번길 18 (소태동)
4th row광주광역시 동구 필문대로 229 (지산동)
5th row광주광역시 동구 필문대로191번길 15-10 (산수동,(1층))
ValueCountFrequency (%)
광주광역시 27
 
19.1%
동구 27
 
19.1%
충장로 4
 
2.8%
필문대로 3
 
2.1%
2층 2
 
1.4%
구성로 2
 
1.4%
충장로5가 2
 
1.4%
필문대로191번길 2
 
1.4%
계림동,(1,2층 1
 
0.7%
동명동 1
 
0.7%
Other values (70) 70
49.6%
2023-12-13T07:43:07.947678image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
114
 
14.7%
광 55
 
7.1%
동 49
 
6.3%
1 43
 
5.6%
( 38
 
4.9%
) 38
 
4.9%
로 34
 
4.4%
구 31
 
4.0%
2 28
 
3.6%
시 27
 
3.5%
Other values (57) 316
40.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 411
53.2%
Decimal Number 138
 
17.9%
Space Separator 114
 
14.7%
Open Punctuation 38
 
4.9%
Close Punctuation 38
 
4.9%
Other Punctuation 21
 
2.7%
Dash Punctuation 12
 
1.6%
Math Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 55
13.4%
동 49
 
11.9%
로 34
 
8.3%
구 31
 
7.5%
시 27
 
6.6%
역 27
 
6.6%
주 27
 
6.6%
층 15
 
3.6%
길 11
 
2.7%
번 10
 
2.4%
Other values (40) 125
30.4%
Decimal Number
ValueCountFrequency (%)
1 43
31.2%
2 28
20.3%
5 11
 
8.0%
0 11
 
8.0%
4 10
 
7.2%
3 9
 
6.5%
7 9
 
6.5%
6 7
 
5.1%
9 6
 
4.3%
8 4
 
2.9%
Other Punctuation
ValueCountFrequency (%)
, 20
95.2%
. 1
 
4.8%
Space Separator
ValueCountFrequency (%)
114
100.0%
Open Punctuation
ValueCountFrequency (%)
( 38
100.0%
Close Punctuation
ValueCountFrequency (%)
) 38
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 12
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 411
53.2%
Common 362
46.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 55
13.4%
동 49
 
11.9%
로 34
 
8.3%
구 31
 
7.5%
시 27
 
6.6%
역 27
 
6.6%
주 27
 
6.6%
층 15
 
3.6%
길 11
 
2.7%
번 10
 
2.4%
Other values (40) 125
30.4%
Common
ValueCountFrequency (%)
114
31.5%
1 43
 
11.9%
( 38
 
10.5%
) 38
 
10.5%
2 28
 
7.7%
, 20
 
5.5%
- 12
 
3.3%
5 11
 
3.0%
0 11
 
3.0%
4 10
 
2.8%
Other values (7) 37
 
10.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 411
53.2%
ASCII 362
46.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
114
31.5%
1 43
 
11.9%
( 38
 
10.5%
) 38
 
10.5%
2 28
 
7.7%
, 20
 
5.5%
- 12
 
3.3%
5 11
 
3.0%
0 11
 
3.0%
4 10
 
2.8%
Other values (7) 37
 
10.2%
Hangul
ValueCountFrequency (%)
광 55
13.4%
동 49
 
11.9%
로 34
 
8.3%
구 31
 
7.5%
시 27
 
6.6%
역 27
 
6.6%
주 27
 
6.6%
층 15
 
3.6%
길 11
 
2.7%
번 10
 
2.4%
Other values (40) 125
30.4%

소재지주소
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing27
Missing (%)100.0%
Memory size375.0 B

영업상태구분코드
Categorical

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
1
27 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 27
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:43:08.199154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 27
100.0%

영업상태명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
영업
27 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row영업
2nd row영업
3rd row영업
4th row영업
5th row영업

Common Values

ValueCountFrequency (%)
영업 27
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:43:08.375983image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업 27
100.0%

폐업일자
Categorical

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
해당없음
27 

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 (%)
해당없음 27
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:43:08.581697image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
해당없음 27
100.0%

신청일자
Date

Distinct14
Distinct (%)51.9%
Missing0
Missing (%)0.0%
Memory size348.0 B
Minimum2000-07-24 00:00:00
Maximum2013-10-29 00:00:00
2023-12-13T07:43:08.676123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:43:08.816627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)

지정일자
Categorical

HIGH CORRELATION 

Distinct13
Distinct (%)48.1%
Missing0
Missing (%)0.0%
Memory size348.0 B
2007-06-20
3 
2008-06-24
3 
2009-06-30
3 
2003-11-11
3 
2010-06-30
3 
Other values (8)
12 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique4 ?
Unique (%)14.8%

Sample

1st row2007-06-20
2nd row2005-04-01
3rd row2001-07-12
4th row2006-12-18
5th row2008-06-24

Common Values

ValueCountFrequency (%)
2007-06-20 3
11.1%
2008-06-24 3
11.1%
2009-06-30 3
11.1%
2003-11-11 3
11.1%
2010-06-30 3
11.1%
2001-07-12 2
7.4%
2004-12-15 2
7.4%
2002-07-04 2
7.4%
2000-07-24 2
7.4%
2005-04-01 1
 
3.7%
Other values (3) 3
11.1%

Length

2023-12-13T07:43:08.962588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2007-06-20 3
11.1%
2008-06-24 3
11.1%
2009-06-30 3
11.1%
2003-11-11 3
11.1%
2010-06-30 3
11.1%
2001-07-12 2
7.4%
2004-12-15 2
7.4%
2002-07-04 2
7.4%
2000-07-24 2
7.4%
2005-04-01 1
 
3.7%
Other values (3) 3
11.1%

지정취소일자
Categorical

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
해당없음
27 

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 (%)
해당없음 27
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:43:09.207398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
해당없음 27
100.0%

지정취소사유
Categorical

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
해당없음
27 

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 (%)
해당없음 27
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:43:09.399744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
해당없음 27
100.0%

불가일자
Categorical

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
해당없음
27 

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 (%)
해당없음 27
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:43:09.593955image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
해당없음 27
100.0%

불가사유
Categorical

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
해당없음
27 

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 (%)
해당없음 27
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:43:09.850400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
해당없음 27
100.0%

음식의유형
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)11.1%
Missing0
Missing (%)0.0%
Memory size348.0 B
<NA>
22 
중식
4 
한식
 
1

Length

Max length4
Median length4
Mean length3.6296296
Min length2

Unique

Unique1 ?
Unique (%)3.7%

Sample

1st row한식
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 22
81.5%
중식 4
 
14.8%
한식 1
 
3.7%

Length

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

Common Values (Plot)

2023-12-13T07:43:10.107174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 22
81.5%
중식 4
 
14.8%
한식 1
 
3.7%

주된음식종류
Text

MISSING 

Distinct8
Distinct (%)72.7%
Missing16
Missing (%)59.3%
Memory size348.0 B
2023-12-13T07:43:10.221897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length2
Mean length2.0909091
Min length2

Characters and Unicode

Total characters23
Distinct characters15
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique7 ?
Unique (%)63.6%

Sample

1st row삼계탕
2nd row장어
3rd row갈비
4th row백반
5th row중식
ValueCountFrequency (%)
중식 4
36.4%
삼계탕 1
 
9.1%
장어 1
 
9.1%
갈비 1
 
9.1%
백반 1
 
9.1%
백숙 1
 
9.1%
갈치 1
 
9.1%
메밀 1
 
9.1%
2023-12-13T07:43:10.551999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
중 4
17.4%
식 4
17.4%
갈 2
 
8.7%
백 2
 
8.7%
삼 1
 
4.3%
계 1
 
4.3%
탕 1
 
4.3%
장 1
 
4.3%
어 1
 
4.3%
비 1
 
4.3%
Other values (5) 5
21.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 23
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
중 4
17.4%
식 4
17.4%
갈 2
 
8.7%
백 2
 
8.7%
삼 1
 
4.3%
계 1
 
4.3%
탕 1
 
4.3%
장 1
 
4.3%
어 1
 
4.3%
비 1
 
4.3%
Other values (5) 5
21.7%

Most occurring scripts

ValueCountFrequency (%)
Hangul 23
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
중 4
17.4%
식 4
17.4%
갈 2
 
8.7%
백 2
 
8.7%
삼 1
 
4.3%
계 1
 
4.3%
탕 1
 
4.3%
장 1
 
4.3%
어 1
 
4.3%
비 1
 
4.3%
Other values (5) 5
21.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 23
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
중 4
17.4%
식 4
17.4%
갈 2
 
8.7%
백 2
 
8.7%
삼 1
 
4.3%
계 1
 
4.3%
탕 1
 
4.3%
장 1
 
4.3%
어 1
 
4.3%
비 1
 
4.3%
Other values (5) 5
21.7%

재지정일자
Categorical

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
해당없음
27 

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 (%)
해당없음 27
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:43:10.824450image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
해당없음 27
100.0%

최종수정일자
Categorical

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
2023-08-31
27 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-08-31
2nd row2023-08-31
3rd row2023-08-31
4th row2023-08-31
5th row2023-08-31

Common Values

ValueCountFrequency (%)
2023-08-31 27
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:43:11.037609image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-08-31 27
100.0%

기타
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)7.4%
Missing0
Missing (%)0.0%
Memory size348.0 B
음식정보 미보유
22 
<NA>
5 

Length

Max length8
Median length8
Mean length7.2592593
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row음식정보 미보유
3rd row음식정보 미보유
4th row음식정보 미보유
5th row음식정보 미보유

Common Values

ValueCountFrequency (%)
음식정보 미보유 22
81.5%
<NA> 5
 
18.5%

Length

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

Common Values (Plot)

2023-12-13T07:43:11.275535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
음식정보 22
44.9%
미보유 22
44.9%
na 5
 
10.2%

데이터갱신일자
Categorical

CONSTANT 

Distinct1
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size348.0 B
2023-08-31
27 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-08-31
2nd row2023-08-31
3rd row2023-08-31
4th row2023-08-31
5th row2023-08-31

Common Values

ValueCountFrequency (%)
2023-08-31 27
100.0%

Length

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

Common Values (Plot)

2023-12-13T07:43:11.518623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-08-31 27
100.0%

Interactions

2023-12-13T07:43:05.491341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:43:05.314125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:43:05.610345image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:43:05.395460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T07:43:11.587518image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리번호인허가번호업소명도로명주소신청일자지정일자음식의유형주된음식종류
관리번호1.0000.0000.0001.0000.6940.6300.0000.000
인허가번호0.0001.0000.9501.0000.6320.5551.0000.365
업소명0.0000.9501.0001.0000.9010.9041.0001.000
도로명주소1.0001.0001.0001.0001.0001.0001.0001.000
신청일자0.6940.6320.9011.0001.0001.0001.0000.902
지정일자0.6300.5550.9041.0001.0001.0001.0000.902
음식의유형0.0001.0001.0001.0001.0001.0001.0000.000
주된음식종류0.0000.3651.0001.0000.9020.9020.0001.000
2023-12-13T07:43:11.734074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
음식의유형기타지정일자
음식의유형1.000NaN0.577
기타NaN1.0001.000
지정일자0.5771.0001.000
2023-12-13T07:43:12.174301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리번호인허가번호지정일자음식의유형기타
관리번호1.0000.0060.4310.0001.000
인허가번호0.0061.0000.1921.0001.000
지정일자0.4310.1921.0000.5771.000
음식의유형0.0001.0000.5771.0000.000
기타1.0001.0001.0000.0001.000

Missing values

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

관리번호인허가번호업소명도로명주소소재지주소영업상태구분코드영업상태명폐업일자신청일자지정일자지정취소일자지정취소사유불가일자불가사유음식의유형주된음식종류재지정일자최종수정일자기타데이터갱신일자
0819920214107고려조삼계탕광주광역시 동구 금남로 231 (금남로2가,(점포21개))<NA>1영업해당없음2007-05-252007-06-20해당없음해당없음해당없음해당없음한식삼계탕해당없음2023-08-31<NA>2023-08-31
1919980214030고흥장어나라광주광역시 동구 필문대로191번길 5-10 (산수동)<NA>1영업해당없음2005-04-012005-04-01해당없음해당없음해당없음해당없음<NA>장어해당없음2023-08-31음식정보 미보유2023-08-31
2519920214056관가광주광역시 동구 의재로96번길 18 (소태동)<NA>1영업해당없음2001-07-122001-07-12해당없음해당없음해당없음해당없음<NA><NA>해당없음2023-08-31음식정보 미보유2023-08-31
35619960214091광양숯불구이지산점광주광역시 동구 필문대로 229 (지산동)<NA>1영업해당없음2006-12-082006-12-18해당없음해당없음해당없음해당없음<NA><NA>해당없음2023-08-31음식정보 미보유2023-08-31
4219940214192구수숯불갈비광주광역시 동구 필문대로191번길 15-10 (산수동,(1층))<NA>1영업해당없음2008-05-232008-06-24해당없음해당없음해당없음해당없음<NA>갈비해당없음2023-08-31음식정보 미보유2023-08-31
52820030214249동명가원식당광주광역시 동구 필문대로 230 (동명동,(1층))<NA>1영업해당없음2004-12-152004-12-15해당없음해당없음해당없음해당없음<NA><NA>해당없음2023-08-31음식정보 미보유2023-08-31
61520060214230동원게장백반광주광역시 동구 지호로 128 (지산동,(1층))<NA>1영업해당없음2007-05-252007-06-20해당없음해당없음해당없음해당없음<NA>백반해당없음2023-08-31음식정보 미보유2023-08-31
7419810214001동해바다광주광역시 동구 충장로46번길 6-1 (충장로5가)<NA>1영업해당없음2007-05-232007-06-20해당없음해당없음해당없음해당없음<NA><NA>해당없음2023-08-31음식정보 미보유2023-08-31
8120070214300뜰안채광주광역시 동구 문화전당로26번길 10-4, 2층 (남동)<NA>1영업해당없음2008-05-232008-06-24해당없음해당없음해당없음해당없음<NA><NA>해당없음2023-08-31음식정보 미보유2023-08-31
990220020214531목포복집광주광역시 동구 구성로 150 (수기동,(1층))<NA>1영업해당없음2009-06-302009-06-30해당없음해당없음해당없음해당없음<NA><NA>해당없음2023-08-31음식정보 미보유2023-08-31
관리번호인허가번호업소명도로명주소소재지주소영업상태구분코드영업상태명폐업일자신청일자지정일자지정취소일자지정취소사유불가일자불가사유음식의유형주된음식종류재지정일자최종수정일자기타데이터갱신일자
17419910214069오대양광주광역시 동구 동계천로 79 (동명동)<NA>1영업해당없음2001-07-122001-07-12해당없음해당없음해당없음해당없음<NA><NA>해당없음2023-08-31음식정보 미보유2023-08-31
186219910214125올능이능이버섯백숙광주광역시 동구 무등로 326 (계림동)<NA>1영업해당없음2000-07-242000-07-24해당없음해당없음해당없음해당없음<NA>백숙해당없음2023-08-31음식정보 미보유2023-08-31
19719980214233운림골농원(달달한레시피)광주광역시 동구 운림길 57-7 (운림동)<NA>1영업해당없음2002-07-042002-07-04해당없음해당없음해당없음해당없음<NA><NA>해당없음2023-08-31음식정보 미보유2023-08-31
20819710214003제일중화요리광주광역시 동구 구성로 174, 1,2층 (금남로5가)<NA>1영업해당없음2010-06-302010-06-30해당없음해당없음해당없음해당없음중식중식해당없음2023-08-31<NA>2023-08-31
21120080214186제주삼다갈치광주광역시 동구 구성로204번길 28 (대인동,(1층))<NA>1영업해당없음2010-06-302010-06-30해당없음해당없음해당없음해당없음<NA>갈치해당없음2023-08-31음식정보 미보유2023-08-31
223320020214097제주항광주광역시 동구 필문대로 200 (산수동,(1,2층))<NA>1영업해당없음2004-12-152004-12-15해당없음해당없음해당없음해당없음<NA><NA>해당없음2023-08-31음식정보 미보유2023-08-31
233119720214004청원모밀광주광역시 동구 중앙로 174-1 (충장로3가)<NA>1영업해당없음2003-11-112003-11-11해당없음해당없음해당없음해당없음<NA>메밀해당없음2023-08-31음식정보 미보유2023-08-31
24419720214013청하광주광역시 동구 충장로 45-12 (충장로4가,외3필지(1층))<NA>1영업해당없음2008-05-232008-06-24해당없음해당없음해당없음해당없음<NA><NA>해당없음2023-08-31음식정보 미보유2023-08-31
25919730214022한성회관광주광역시 동구 충장로 45-22 (금남로4가)<NA>1영업해당없음2003-11-112003-11-11해당없음해당없음해당없음해당없음<NA><NA>해당없음2023-08-31음식정보 미보유2023-08-31
26519960214100황솔촌 충장점광주광역시 동구 중앙로160번길 16-10, 1~2층 (호남동)<NA>1영업해당없음2009-06-302009-06-30해당없음해당없음해당없음해당없음<NA><NA>해당없음2023-08-31음식정보 미보유2023-08-31