Overview

Dataset statistics

Number of variables5
Number of observations22
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.0 KiB
Average record size in memory48.0 B

Variable types

Numeric2
Text3

Dataset

Description광주광역시 현재 지역에 등록된 대규모 점포 현황에 관한 데이터로 상호명, 소재지, 전화번호, 매장면적을 제공합니다.
URLhttps://www.data.go.kr/data/3083073/fileData.do

Alerts

연번 has unique valuesUnique
상호명 has unique valuesUnique
전화번호 has unique valuesUnique
매장(제곱미터) has unique valuesUnique

Reproduction

Analysis started2023-12-12 09:52:00.795544
Analysis finished2023-12-12 09:52:01.527167
Duration0.73 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct22
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11.5
Minimum1
Maximum22
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size330.0 B
2023-12-12T18:52:01.585991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.05
Q16.25
median11.5
Q316.75
95-th percentile20.95
Maximum22
Range21
Interquartile range (IQR)10.5

Descriptive statistics

Standard deviation6.4935866
Coefficient of variation (CV)0.5646597
Kurtosis-1.2
Mean11.5
Median Absolute Deviation (MAD)5.5
Skewness0
Sum253
Variance42.166667
MonotonicityStrictly increasing
2023-12-12T18:52:01.759849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=22)
ValueCountFrequency (%)
1 1
 
4.5%
13 1
 
4.5%
22 1
 
4.5%
21 1
 
4.5%
20 1
 
4.5%
19 1
 
4.5%
18 1
 
4.5%
17 1
 
4.5%
16 1
 
4.5%
15 1
 
4.5%
Other values (12) 12
54.5%
ValueCountFrequency (%)
1 1
4.5%
2 1
4.5%
3 1
4.5%
4 1
4.5%
5 1
4.5%
6 1
4.5%
7 1
4.5%
8 1
4.5%
9 1
4.5%
10 1
4.5%
ValueCountFrequency (%)
22 1
4.5%
21 1
4.5%
20 1
4.5%
19 1
4.5%
18 1
4.5%
17 1
4.5%
16 1
4.5%
15 1
4.5%
14 1
4.5%
13 1
4.5%

상호명
Text

UNIQUE 

Distinct22
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size308.0 B
2023-12-12T18:52:02.010644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length12
Mean length9
Min length4

Characters and Unicode

Total characters198
Distinct characters66
Distinct categories6 ?
Distinct scripts3 ?
Distinct blocks3 ?
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롯데백화점 광주점
2nd row홈플러스(주)계림점
3rd row㈜금호계림복합상가
4th rowNC WAVE 충장점
5th row와이즈파크 충장로점
ValueCountFrequency (%)
광주점 2
 
7.1%
롯데백화점 1
 
3.6%
문구완구종합상가 1
 
3.6%
㈜이마트광산점 1
 
3.6%
홈플러스(주)하남점 1
 
3.6%
롯데마트수완점 1
 
3.6%
롯데마트첨단점 1
 
3.6%
각화동종합상가 1
 
3.6%
홈플러스(주)동광주점 1
 
3.6%
nc백화점 1
 
3.6%
Other values (17) 17
60.7%
2023-12-12T18:52:02.451177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 18
 
9.1%
주 12
 
6.1%
롯 9
 
4.5%
데 9
 
4.5%
광 8
 
4.0%
트 7
 
3.5%
마 7
 
3.5%
6
 
3.0%
㈜ 6
 
3.0%
( 5
 
2.5%
Other values (56) 111
56.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 168
84.8%
Uppercase Letter 8
 
4.0%
Space Separator 6
 
3.0%
Other Symbol 6
 
3.0%
Open Punctuation 5
 
2.5%
Close Punctuation 5
 
2.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 18
 
10.7%
주 12
 
7.1%
롯 9
 
5.4%
데 9
 
5.4%
광 8
 
4.8%
트 7
 
4.2%
마 7
 
4.2%
이 4
 
2.4%
상 4
 
2.4%
스 4
 
2.4%
Other values (46) 86
51.2%
Uppercase Letter
ValueCountFrequency (%)
C 2
25.0%
N 2
25.0%
E 1
12.5%
V 1
12.5%
A 1
12.5%
W 1
12.5%
Space Separator
ValueCountFrequency (%)
6
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 6
100.0%
Open Punctuation
ValueCountFrequency (%)
( 5
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 174
87.9%
Common 16
 
8.1%
Latin 8
 
4.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 18
 
10.3%
주 12
 
6.9%
롯 9
 
5.2%
데 9
 
5.2%
광 8
 
4.6%
트 7
 
4.0%
마 7
 
4.0%
㈜ 6
 
3.4%
이 4
 
2.3%
상 4
 
2.3%
Other values (47) 90
51.7%
Latin
ValueCountFrequency (%)
C 2
25.0%
N 2
25.0%
E 1
12.5%
V 1
12.5%
A 1
12.5%
W 1
12.5%
Common
ValueCountFrequency (%)
6
37.5%
( 5
31.2%
) 5
31.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 168
84.8%
ASCII 24
 
12.1%
None 6
 
3.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 18
 
10.7%
주 12
 
7.1%
롯 9
 
5.4%
데 9
 
5.4%
광 8
 
4.8%
트 7
 
4.2%
마 7
 
4.2%
이 4
 
2.4%
상 4
 
2.4%
스 4
 
2.4%
Other values (46) 86
51.2%
ASCII
ValueCountFrequency (%)
6
25.0%
( 5
20.8%
) 5
20.8%
C 2
 
8.3%
N 2
 
8.3%
E 1
 
4.2%
V 1
 
4.2%
A 1
 
4.2%
W 1
 
4.2%
None
ValueCountFrequency (%)
㈜ 6
100.0%

소재지
Text

Distinct20
Distinct (%)90.9%
Missing0
Missing (%)0.0%
Memory size308.0 B
2023-12-12T18:52:02.740022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length25
Mean length22.5
Min length21

Characters and Unicode

Total characters495
Distinct characters75
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

Unique18 ?
Unique (%)81.8%

Sample

1st row광주광역시 동구 독립로 268 (대인동)
2nd row광주광역시 동구 무등로 314 (계림동)
3rd row광주광역시 동구 중앙로 358 (계림동)
4th row광주광역시 동구 중앙로 163 (충장로4가)
5th row광주광역시 동구 충장로 72 (충장로3가)
ValueCountFrequency (%)
광주광역시 22
22.0%
서구 8
 
8.0%
동구 5
 
5.0%
광산구 5
 
5.0%
화정동 3
 
3.0%
북구 3
 
3.0%
동문대로 2
 
2.0%
장신로 2
 
2.0%
98(장덕동 2
 
2.0%
금화로 2
 
2.0%
Other values (42) 46
46.0%
2023-12-12T18:52:03.177622image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
79
16.0%
광 50
 
10.1%
동 27
 
5.5%
로 24
 
4.8%
시 23
 
4.6%
주 22
 
4.4%
구 22
 
4.4%
( 22
 
4.4%
역 22
 
4.4%
) 22
 
4.4%
Other values (65) 182
36.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 306
61.8%
Space Separator 79
 
16.0%
Decimal Number 66
 
13.3%
Open Punctuation 22
 
4.4%
Close Punctuation 22
 
4.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 50
16.3%
동 27
 
8.8%
로 24
 
7.8%
시 23
 
7.5%
주 22
 
7.2%
구 22
 
7.2%
역 22
 
7.2%
서 8
 
2.6%
장 7
 
2.3%
대 6
 
2.0%
Other values (52) 95
31.0%
Decimal Number
ValueCountFrequency (%)
2 10
15.2%
9 10
15.2%
3 10
15.2%
4 9
13.6%
1 6
9.1%
0 6
9.1%
8 6
9.1%
7 4
 
6.1%
6 3
 
4.5%
5 2
 
3.0%
Space Separator
ValueCountFrequency (%)
79
100.0%
Open Punctuation
ValueCountFrequency (%)
( 22
100.0%
Close Punctuation
ValueCountFrequency (%)
) 22
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 306
61.8%
Common 189
38.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 50
16.3%
동 27
 
8.8%
로 24
 
7.8%
시 23
 
7.5%
주 22
 
7.2%
구 22
 
7.2%
역 22
 
7.2%
서 8
 
2.6%
장 7
 
2.3%
대 6
 
2.0%
Other values (52) 95
31.0%
Common
ValueCountFrequency (%)
79
41.8%
( 22
 
11.6%
) 22
 
11.6%
2 10
 
5.3%
9 10
 
5.3%
3 10
 
5.3%
4 9
 
4.8%
1 6
 
3.2%
0 6
 
3.2%
8 6
 
3.2%
Other values (3) 9
 
4.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 306
61.8%
ASCII 189
38.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
79
41.8%
( 22
 
11.6%
) 22
 
11.6%
2 10
 
5.3%
9 10
 
5.3%
3 10
 
5.3%
4 9
 
4.8%
1 6
 
3.2%
0 6
 
3.2%
8 6
 
3.2%
Other values (3) 9
 
4.8%
Hangul
ValueCountFrequency (%)
광 50
16.3%
동 27
 
8.8%
로 24
 
7.8%
시 23
 
7.5%
주 22
 
7.2%
구 22
 
7.2%
역 22
 
7.2%
서 8
 
2.6%
장 7
 
2.3%
대 6
 
2.0%
Other values (52) 95
31.0%

전화번호
Text

UNIQUE 

Distinct22
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size308.0 B
2023-12-12T18:52:03.427067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.045455
Min length12

Characters and Unicode

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

Unique22 ?
Unique (%)100.0%

Sample

1st row062-221-0311
2nd row062-530-8121
3rd row062-522-5522
4th row062-718-9320
5th row062-236-5989
ValueCountFrequency (%)
062-221-0311 1
 
4.5%
062-530-8121 1
 
4.5%
062-949-1234 1
 
4.5%
062-616-8000 1
 
4.5%
062-975-2500 1
 
4.5%
062-962-2500 1
 
4.5%
062-251-6996 1
 
4.5%
062-250-8000 1
 
4.5%
062-510-7000 1
 
4.5%
062-611-1234 1
 
4.5%
Other values (12) 12
54.5%
2023-12-12T18:52:03.850697image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 58
21.9%
2 45
17.0%
- 44
16.6%
6 39
14.7%
1 20
 
7.5%
5 18
 
6.8%
3 12
 
4.5%
9 10
 
3.8%
8 8
 
3.0%
4 6
 
2.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 221
83.4%
Dash Punctuation 44
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 58
26.2%
2 45
20.4%
6 39
17.6%
1 20
 
9.0%
5 18
 
8.1%
3 12
 
5.4%
9 10
 
4.5%
8 8
 
3.6%
4 6
 
2.7%
7 5
 
2.3%
Dash Punctuation
ValueCountFrequency (%)
- 44
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 265
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 58
21.9%
2 45
17.0%
- 44
16.6%
6 39
14.7%
1 20
 
7.5%
5 18
 
6.8%
3 12
 
4.5%
9 10
 
3.8%
8 8
 
3.0%
4 6
 
2.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 265
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 58
21.9%
2 45
17.0%
- 44
16.6%
6 39
14.7%
1 20
 
7.5%
5 18
 
6.8%
3 12
 
4.5%
9 10
 
3.8%
8 8
 
3.0%
4 6
 
2.3%

매장(제곱미터)
Real number (ℝ)

UNIQUE 

Distinct22
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14679
Minimum3105
Maximum29917
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size330.0 B
2023-12-12T18:52:04.015236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3105
5-th percentile4887.2
Q19504.75
median13170
Q319948
95-th percentile26785.25
Maximum29917
Range26812
Interquartile range (IQR)10443.25

Descriptive statistics

Standard deviation7192.7876
Coefficient of variation (CV)0.49000528
Kurtosis-0.4718756
Mean14679
Median Absolute Deviation (MAD)4687
Skewness0.52033063
Sum322938
Variance51736193
MonotonicityNot monotonic
2023-12-12T18:52:04.214540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=22)
ValueCountFrequency (%)
29917 1
 
4.5%
20462 1
 
4.5%
22473 1
 
4.5%
9342 1
 
4.5%
9993 1
 
4.5%
8499 1
 
4.5%
8467 1
 
4.5%
3105 1
 
4.5%
15111 1
 
4.5%
21532 1
 
4.5%
Other values (12) 12
54.5%
ValueCountFrequency (%)
3105 1
4.5%
4707 1
4.5%
8311 1
4.5%
8467 1
4.5%
8499 1
4.5%
9342 1
4.5%
9993 1
4.5%
10855 1
4.5%
11182 1
4.5%
11213 1
4.5%
ValueCountFrequency (%)
29917 1
4.5%
26906 1
4.5%
24491 1
4.5%
22473 1
4.5%
21532 1
4.5%
20462 1
4.5%
18406 1
4.5%
17553 1
4.5%
15111 1
4.5%
14073 1
4.5%

Interactions

2023-12-12T18:52:01.186720image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:52:01.014560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:52:01.271129image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:52:01.096769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T18:52:04.309838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번상호명소재지전화번호매장(제곱미터)
연번1.0001.0000.8841.0000.189
상호명1.0001.0001.0001.0001.000
소재지0.8841.0001.0001.0000.909
전화번호1.0001.0001.0001.0001.000
매장(제곱미터)0.1891.0000.9091.0001.000
2023-12-12T18:52:04.753643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번매장(제곱미터)
연번1.000-0.211
매장(제곱미터)-0.2111.000

Missing values

2023-12-12T18:52:01.385726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:52:01.489654image/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롯데백화점 광주점광주광역시 동구 독립로 268 (대인동)062-221-031129917
12홈플러스(주)계림점광주광역시 동구 무등로 314 (계림동)062-530-812111182
23㈜금호계림복합상가광주광역시 동구 중앙로 358 (계림동)062-522-55224707
34NC WAVE 충장점광주광역시 동구 중앙로 163 (충장로4가)062-718-932018406
45와이즈파크 충장로점광주광역시 동구 충장로 72 (충장로3가)062-236-59898311
56㈜광주신세계광주광역시 서구 무진대로 932 (광천동)062-1588-123426906
67㈜이마트광주점광주광역시 서구 죽봉대로 61 (화정동)062-360-012313309
78롯데쇼핑(주)롯데마트맥스상무점광주광역시 서구 시청로 40 (치평동)062-602-250014073
89롯데쇼핑(주)롯데마트월드컵점광주광역시 서구 금화로 240 (풍암동)062-610-250013031
910금호월드광주광역시 서구 군분2로 54 (화정동)062-350-811424491
연번상호명소재지전화번호매장(제곱미터)
1213㈜광주세정아울렛광주광역시 서구 상무대로 773(치평동)062-370-900020462
1314㈜이마트봉선점광주광역시 남구 봉선로 198(봉선동)062-611-123410855
1415NC백화점 광주점광주광역시 북구 경열로 249(신안동)062-510-700021532
1516홈플러스(주)동광주점광주광역시 북구 동문대로 200 (두암동)062-250-800015111
1617각화동종합상가광주광역시 북구 동문대로 248번길39(각화동)062-251-69963105
1718롯데마트첨단점광주광역시 광산구 첨단강변로99번길(쌍암동)062-962-25008467
1819롯데마트수완점광주광역시 광산구 장신로 98(장덕동)062-975-25008499
1920홈플러스(주)하남점광주광역시 광산구 용아로 390(하남동)062-616-80009993
2021㈜이마트광산점광주광역시 광산구 사암로 172(우산동)062-949-12349342
2122롯데아울렛수완점광주광역시 광산구 장신로 98(장덕동)062-616-250022473