Overview

Dataset statistics

Number of variables7
Number of observations31
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.9 KiB
Average record size in memory63.3 B

Variable types

Numeric3
Categorical1
DateTime1
Text2

Dataset

Description2023년도 경기도 하남시 모범음식점 현황에 대한 데이터로, 연번, 인허가일자, 업소명, 업소 소재지, 우편번호, 영업장면적 등을 제공합니다.
Author경기도 하남시
URLhttps://www.data.go.kr/data/15042441/fileData.do

Alerts

업종 has constant value ""Constant
연번 has unique valuesUnique
업소명 has unique valuesUnique
영업장면적(제곱미터) has unique valuesUnique

Reproduction

Analysis started2024-05-04 07:59:02.695536
Analysis finished2024-05-04 07:59:06.863804
Duration4.17 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct31
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean16
Minimum1
Maximum31
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size411.0 B
2024-05-04T07:59:07.072483image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.5
Q18.5
median16
Q323.5
95-th percentile29.5
Maximum31
Range30
Interquartile range (IQR)15

Descriptive statistics

Standard deviation9.0921211
Coefficient of variation (CV)0.56825757
Kurtosis-1.2
Mean16
Median Absolute Deviation (MAD)8
Skewness0
Sum496
Variance82.666667
MonotonicityStrictly increasing
2024-05-04T07:59:07.465990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=31)
ValueCountFrequency (%)
1 1
 
3.2%
2 1
 
3.2%
31 1
 
3.2%
30 1
 
3.2%
29 1
 
3.2%
28 1
 
3.2%
27 1
 
3.2%
26 1
 
3.2%
25 1
 
3.2%
24 1
 
3.2%
Other values (21) 21
67.7%
ValueCountFrequency (%)
1 1
3.2%
2 1
3.2%
3 1
3.2%
4 1
3.2%
5 1
3.2%
6 1
3.2%
7 1
3.2%
8 1
3.2%
9 1
3.2%
10 1
3.2%
ValueCountFrequency (%)
31 1
3.2%
30 1
3.2%
29 1
3.2%
28 1
3.2%
27 1
3.2%
26 1
3.2%
25 1
3.2%
24 1
3.2%
23 1
3.2%
22 1
3.2%

업종
Categorical

CONSTANT 

Distinct1
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Memory size380.0 B
일반음식점
31 

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 (%)
일반음식점 31
100.0%

Length

2024-05-04T07:59:07.947099image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-04T07:59:08.204031image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반음식점 31
100.0%
Distinct29
Distinct (%)93.5%
Missing0
Missing (%)0.0%
Memory size380.0 B
Minimum1975-01-24 00:00:00
Maximum2017-09-26 00:00:00
2024-05-04T07:59:08.522554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T07:59:08.929925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)

업소명
Text

UNIQUE 

Distinct31
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size380.0 B
2024-05-04T07:59:09.379818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length8
Mean length5.7741935
Min length2

Characters and Unicode

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

Unique

Unique31 ?
Unique (%)100.0%

Sample

1st row마방집
2nd row소나무집
3rd row리버
4th row노적봉한정식
5th row장어의 꿈
ValueCountFrequency (%)
하남점 2
 
4.9%
마방집 1
 
2.4%
소나무집 1
 
2.4%
먹보한우 1
 
2.4%
동인숯불민물장어 1
 
2.4%
미사풍천장어 1
 
2.4%
팔당원조칼제비칼국수 1
 
2.4%
한우1번지 1
 
2.4%
송추가마골 1
 
2.4%
미사지점 1
 
2.4%
Other values (30) 30
73.2%
2024-05-04T07:59:10.595871image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
10
 
5.6%
7
 
3.9%
6
 
3.4%
5
 
2.8%
5
 
2.8%
5
 
2.8%
5
 
2.8%
4
 
2.2%
4
 
2.2%
4
 
2.2%
Other values (88) 124
69.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 164
91.6%
Space Separator 10
 
5.6%
Other Punctuation 2
 
1.1%
Decimal Number 1
 
0.6%
Close Punctuation 1
 
0.6%
Open Punctuation 1
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
7
 
4.3%
6
 
3.7%
5
 
3.0%
5
 
3.0%
5
 
3.0%
5
 
3.0%
4
 
2.4%
4
 
2.4%
4
 
2.4%
4
 
2.4%
Other values (83) 115
70.1%
Space Separator
ValueCountFrequency (%)
10
100.0%
Other Punctuation
ValueCountFrequency (%)
. 2
100.0%
Decimal Number
ValueCountFrequency (%)
1 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 164
91.6%
Common 15
 
8.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
7
 
4.3%
6
 
3.7%
5
 
3.0%
5
 
3.0%
5
 
3.0%
5
 
3.0%
4
 
2.4%
4
 
2.4%
4
 
2.4%
4
 
2.4%
Other values (83) 115
70.1%
Common
ValueCountFrequency (%)
10
66.7%
. 2
 
13.3%
1 1
 
6.7%
) 1
 
6.7%
( 1
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 164
91.6%
ASCII 15
 
8.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
10
66.7%
. 2
 
13.3%
1 1
 
6.7%
) 1
 
6.7%
( 1
 
6.7%
Hangul
ValueCountFrequency (%)
7
 
4.3%
6
 
3.7%
5
 
3.0%
5
 
3.0%
5
 
3.0%
5
 
3.0%
4
 
2.4%
4
 
2.4%
4
 
2.4%
4
 
2.4%
Other values (83) 115
70.1%
Distinct29
Distinct (%)93.5%
Missing0
Missing (%)0.0%
Memory size380.0 B
2024-05-04T07:59:11.261919image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length47
Median length31
Mean length28.870968
Min length23

Characters and Unicode

Total characters895
Distinct characters78
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

Unique28 ?
Unique (%)90.3%

Sample

1st row경기도 하남시 하남대로 674, 1층 (천현동)
2nd row경기도 하남시 검단산로 342-13, 2,3층 (창우동)
3rd row경기도 하남시 미사동로 102-23, 1,2층 (미사동)
4th row경기도 하남시 검단산로 226, 1,2층 (창우동)
5th row경기도 하남시 서하남로 15, 1,2층 (감북동)
ValueCountFrequency (%)
경기도 31
 
15.9%
하남시 31
 
15.9%
1층 8
 
4.1%
신장동 7
 
3.6%
1,2층 7
 
3.6%
2층 6
 
3.1%
미사대로 5
 
2.6%
검단산로 4
 
2.1%
창우동 4
 
2.1%
750 3
 
1.5%
Other values (66) 89
45.6%
2024-05-04T07:59:12.545841image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
164
18.3%
45
 
5.0%
, 43
 
4.8%
41
 
4.6%
1 36
 
4.0%
35
 
3.9%
) 32
 
3.6%
( 32
 
3.6%
31
 
3.5%
31
 
3.5%
Other values (68) 405
45.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 469
52.4%
Space Separator 164
 
18.3%
Decimal Number 140
 
15.6%
Other Punctuation 43
 
4.8%
Close Punctuation 32
 
3.6%
Open Punctuation 32
 
3.6%
Uppercase Letter 9
 
1.0%
Dash Punctuation 5
 
0.6%
Math Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
45
 
9.6%
41
 
8.7%
35
 
7.5%
31
 
6.6%
31
 
6.6%
31
 
6.6%
31
 
6.6%
31
 
6.6%
30
 
6.4%
11
 
2.3%
Other values (46) 152
32.4%
Decimal Number
ValueCountFrequency (%)
1 36
25.7%
2 29
20.7%
3 16
11.4%
4 11
 
7.9%
8 9
 
6.4%
6 9
 
6.4%
0 9
 
6.4%
7 9
 
6.4%
5 8
 
5.7%
9 4
 
2.9%
Uppercase Letter
ValueCountFrequency (%)
L 3
33.3%
A 2
22.2%
K 1
 
11.1%
I 1
 
11.1%
H 1
 
11.1%
E 1
 
11.1%
Space Separator
ValueCountFrequency (%)
164
100.0%
Other Punctuation
ValueCountFrequency (%)
, 43
100.0%
Close Punctuation
ValueCountFrequency (%)
) 32
100.0%
Open Punctuation
ValueCountFrequency (%)
( 32
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 469
52.4%
Common 417
46.6%
Latin 9
 
1.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
45
 
9.6%
41
 
8.7%
35
 
7.5%
31
 
6.6%
31
 
6.6%
31
 
6.6%
31
 
6.6%
31
 
6.6%
30
 
6.4%
11
 
2.3%
Other values (46) 152
32.4%
Common
ValueCountFrequency (%)
164
39.3%
, 43
 
10.3%
1 36
 
8.6%
) 32
 
7.7%
( 32
 
7.7%
2 29
 
7.0%
3 16
 
3.8%
4 11
 
2.6%
8 9
 
2.2%
6 9
 
2.2%
Other values (6) 36
 
8.6%
Latin
ValueCountFrequency (%)
L 3
33.3%
A 2
22.2%
K 1
 
11.1%
I 1
 
11.1%
H 1
 
11.1%
E 1
 
11.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 469
52.4%
ASCII 426
47.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
164
38.5%
, 43
 
10.1%
1 36
 
8.5%
) 32
 
7.5%
( 32
 
7.5%
2 29
 
6.8%
3 16
 
3.8%
4 11
 
2.6%
8 9
 
2.1%
6 9
 
2.1%
Other values (12) 45
 
10.6%
Hangul
ValueCountFrequency (%)
45
 
9.6%
41
 
8.7%
35
 
7.5%
31
 
6.6%
31
 
6.6%
31
 
6.6%
31
 
6.6%
31
 
6.6%
30
 
6.4%
11
 
2.3%
Other values (46) 152
32.4%

우편번호
Real number (ℝ)

Distinct19
Distinct (%)61.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12968.387
Minimum12900
Maximum13027
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size411.0 B
2024-05-04T07:59:12.954197image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum12900
5-th percentile12904
Q112940
median12963
Q313016
95-th percentile13024
Maximum13027
Range127
Interquartile range (IQR)76

Descriptive statistics

Standard deviation42.470129
Coefficient of variation (CV)0.0032748967
Kurtosis-1.3538235
Mean12968.387
Median Absolute Deviation (MAD)38
Skewness0.010765961
Sum402020
Variance1803.7118
MonotonicityNot monotonic
2024-05-04T07:59:13.390044image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
13023 4
12.9%
12942 3
 
9.7%
12956 2
 
6.5%
12983 2
 
6.5%
12900 2
 
6.5%
12991 2
 
6.5%
13016 2
 
6.5%
12925 2
 
6.5%
12940 2
 
6.5%
12908 1
 
3.2%
Other values (9) 9
29.0%
ValueCountFrequency (%)
12900 2
6.5%
12908 1
 
3.2%
12913 1
 
3.2%
12922 1
 
3.2%
12925 2
6.5%
12940 2
6.5%
12942 3
9.7%
12947 1
 
3.2%
12956 2
6.5%
12963 1
 
3.2%
ValueCountFrequency (%)
13027 1
 
3.2%
13025 1
 
3.2%
13023 4
12.9%
13021 1
 
3.2%
13016 2
6.5%
12991 2
6.5%
12986 1
 
3.2%
12983 2
6.5%
12968 1
 
3.2%
12963 1
 
3.2%

영업장면적(제곱미터)
Real number (ℝ)

UNIQUE 

Distinct31
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean297.98065
Minimum94.5
Maximum1124.2
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size411.0 B
2024-05-04T07:59:13.794188image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum94.5
5-th percentile113.8
Q1190.35
median254.8
Q3346.95
95-th percentile527.2
Maximum1124.2
Range1029.7
Interquartile range (IQR)156.6

Descriptive statistics

Standard deviation192.3368
Coefficient of variation (CV)0.64546743
Kurtosis10.966062
Mean297.98065
Median Absolute Deviation (MAD)83.5
Skewness2.8009819
Sum9237.4
Variance36993.445
MonotonicityNot monotonic
2024-05-04T07:59:14.156086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=31)
ValueCountFrequency (%)
158.9 1
 
3.2%
338.3 1
 
3.2%
199.2 1
 
3.2%
382.9 1
 
3.2%
137.3 1
 
3.2%
241.7 1
 
3.2%
355.6 1
 
3.2%
286.4 1
 
3.2%
246.1 1
 
3.2%
94.5 1
 
3.2%
Other values (21) 21
67.7%
ValueCountFrequency (%)
94.5 1
3.2%
108.8 1
3.2%
118.8 1
3.2%
137.3 1
3.2%
151.3 1
3.2%
158.9 1
3.2%
162.4 1
3.2%
190.2 1
3.2%
190.5 1
3.2%
196.0 1
3.2%
ValueCountFrequency (%)
1124.2 1
3.2%
572.5 1
3.2%
481.9 1
3.2%
461.1 1
3.2%
418.5 1
3.2%
382.9 1
3.2%
376.6 1
3.2%
355.6 1
3.2%
338.3 1
3.2%
336.6 1
3.2%

Interactions

2024-05-04T07:59:05.059183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T07:59:03.241278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T07:59:04.212134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T07:59:05.392740image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T07:59:03.555985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T07:59:04.482937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T07:59:05.718490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T07:59:03.908332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T07:59:04.740159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-04T07:59:14.449683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번인허가일자업소명소재지(도로명)우편번호영업장면적(제곱미터)
연번1.0000.9631.0000.9520.3860.462
인허가일자0.9631.0001.0000.9850.8180.932
업소명1.0001.0001.0001.0001.0001.000
소재지(도로명)0.9520.9851.0001.0001.0000.951
우편번호0.3860.8181.0001.0001.0000.000
영업장면적(제곱미터)0.4620.9321.0000.9510.0001.000
2024-05-04T07:59:14.793633image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번우편번호영업장면적(제곱미터)
연번1.000-0.2450.207
우편번호-0.2451.000-0.151
영업장면적(제곱미터)0.207-0.1511.000

Missing values

2024-05-04T07:59:06.124063image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-04T07:59:06.733040image/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일반음식점1975-01-24마방집경기도 하남시 하남대로 674, 1층 (천현동)12956158.9
12일반음식점1995-05-12소나무집경기도 하남시 검단산로 342-13, 2,3층 (창우동)13023338.3
23일반음식점1996-10-08리버경기도 하남시 미사동로 102-23, 1,2층 (미사동)12900196.0
34일반음식점1996-11-08노적봉한정식경기도 하남시 검단산로 226, 1,2층 (창우동)13023190.2
45일반음식점1998-07-23장어의 꿈경기도 하남시 서하남로 15, 1,2층 (감북동)12991190.5
56일반음식점1999-09-16오늘경기도 하남시 고골로262번길 178, 1층 (항동)13021118.8
67일반음식점2001-10-15청송갈비한마당경기도 하남시 신평로 65, 2층 (신장동)12968108.8
78일반음식점2003-08-27시골남원추어탕경기도 하남시 서하남로 85-7, 2,3층 (감북동)12991278.9
89일반음식점2004-12-10한채당경기도 하남시 미사동로 38, 1~2층 (미사동)12900336.6
910일반음식점2008-04-16강계봉진막국수경기도 하남시 하남대로 191, 2층 (상산곡동)13027254.8
연번업종인허가일자업소명소재지(도로명)우편번호영업장면적(제곱미터)
2122일반음식점2016-04-26한우1번지경기도 하남시 미사대로 680, 1,2층 (신장동)12940572.5
2223일반음식점2016-06-27송추가마골 미사지점경기도 하남시 미사대로 438, 2층 (망월동)129221124.2
2324일반음식점2016-06-28시골여행경기도 하남시 미사강변중앙로 219, 205호 (망월동, LAKE HILL 레이크힐)1291394.5
2425일반음식점2016-08-11소호정경기도 하남시 미사대로 750, 스타필드 하남 지하1층 (신장동)12942246.1
2526일반음식점2016-08-11푸주옥경기도 하남시 풍초로 8, 1,2층 (풍산동)12983286.4
2627일반음식점2016-08-29한우리 하남점경기도 하남시 미사대로 750, 스타필드 하남 지하1층 (신장동)12942355.6
2728일반음식점2016-12-12리향(춘궁점)경기도 하남시 서하남로 441, 1층 (춘궁동)13016241.7
2829일반음식점2016-12-29미사 생고기경기도 하남시 미사강변북로30번안길 34, 1층 (망월동)12908137.3
2930일반음식점2017-04-04풍원장 미역국정찬경기도 하남시 미사대로 750, 스타필드 하남 지하1층 (신장동)12942382.9
3031일반음식점2017-09-26탐라은갈치경기도 하남시 서하남로390번길 17, 1,2층 (춘궁동, A동)13016199.2