Overview

Dataset statistics

Number of variables5
Number of observations97
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.0 KiB
Average record size in memory42.4 B

Variable types

Numeric1
Text2
Categorical1
DateTime1

Dataset

Description이 데이터는 2023년 7월 28일 기준 전라북도 남원시의 남원사랑상품권 등록 제한 가맹점의 가맹점명, 주소, 업종에 대한 데이터 입니다.
URLhttps://www.data.go.kr/data/15117452/fileData.do

Alerts

데이터 기준일자 has constant value ""Constant
연번 has unique valuesUnique
가맹점명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 22:47:14.077265
Analysis finished2023-12-12 22:47:14.550705
Duration0.47 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct97
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean49
Minimum1
Maximum97
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1005.0 B
2023-12-13T07:47:14.613919image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile5.8
Q125
median49
Q373
95-th percentile92.2
Maximum97
Range96
Interquartile range (IQR)48

Descriptive statistics

Standard deviation28.145456
Coefficient of variation (CV)0.57439705
Kurtosis-1.2
Mean49
Median Absolute Deviation (MAD)24
Skewness0
Sum4753
Variance792.16667
MonotonicityStrictly increasing
2023-12-13T07:47:14.726218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.0%
74 1
 
1.0%
72 1
 
1.0%
71 1
 
1.0%
70 1
 
1.0%
69 1
 
1.0%
68 1
 
1.0%
67 1
 
1.0%
66 1
 
1.0%
65 1
 
1.0%
Other values (87) 87
89.7%
ValueCountFrequency (%)
1 1
1.0%
2 1
1.0%
3 1
1.0%
4 1
1.0%
5 1
1.0%
6 1
1.0%
7 1
1.0%
8 1
1.0%
9 1
1.0%
10 1
1.0%
ValueCountFrequency (%)
97 1
1.0%
96 1
1.0%
95 1
1.0%
94 1
1.0%
93 1
1.0%
92 1
1.0%
91 1
1.0%
90 1
1.0%
89 1
1.0%
88 1
1.0%

가맹점명
Text

UNIQUE 

Distinct97
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size908.0 B
2023-12-13T07:47:14.922446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length16
Mean length10.340206
Min length4

Characters and Unicode

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

Unique

Unique97 ?
Unique (%)100.0%

Sample

1st row춘향골사람들 영농조합법인
2nd row대동공업(주) 남원대리점
3rd row현대농산영농조합법인
4th row은하수주유소
5th row의료법인 원산의료재단
ValueCountFrequency (%)
하나로마트 7
 
4.9%
주 5
 
3.5%
지리산농협 4
 
2.8%
대보유통 4
 
2.8%
주식회사 3
 
2.1%
유한회사 3
 
2.1%
남원농협 3
 
2.1%
향돈촌영농조합법인 3
 
2.1%
남원농업협동조합 2
 
1.4%
영농조합법인 2
 
1.4%
Other values (107) 108
75.0%
2023-12-13T07:47:15.250154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
농 54
 
5.4%
원 48
 
4.8%
48
 
4.8%
협 40
 
4.0%
남 39
 
3.9%
지 33
 
3.3%
유 31
 
3.1%
주 30
 
3.0%
점 27
 
2.7%
산 24
 
2.4%
Other values (183) 629
62.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 898
89.5%
Space Separator 48
 
4.8%
Close Punctuation 23
 
2.3%
Open Punctuation 23
 
2.3%
Uppercase Letter 7
 
0.7%
Other Punctuation 3
 
0.3%
Other Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
농 54
 
6.0%
원 48
 
5.3%
협 40
 
4.5%
남 39
 
4.3%
지 33
 
3.7%
유 31
 
3.5%
주 30
 
3.3%
점 27
 
3.0%
산 24
 
2.7%
소 20
 
2.2%
Other values (171) 552
61.5%
Uppercase Letter
ValueCountFrequency (%)
C 2
28.6%
P 1
14.3%
R 1
14.3%
I 1
14.3%
G 1
14.3%
M 1
14.3%
Other Punctuation
ValueCountFrequency (%)
. 2
66.7%
* 1
33.3%
Space Separator
ValueCountFrequency (%)
48
100.0%
Close Punctuation
ValueCountFrequency (%)
) 23
100.0%
Open Punctuation
ValueCountFrequency (%)
( 23
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 899
89.6%
Common 97
 
9.7%
Latin 7
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
농 54
 
6.0%
원 48
 
5.3%
협 40
 
4.4%
남 39
 
4.3%
지 33
 
3.7%
유 31
 
3.4%
주 30
 
3.3%
점 27
 
3.0%
산 24
 
2.7%
소 20
 
2.2%
Other values (172) 553
61.5%
Latin
ValueCountFrequency (%)
C 2
28.6%
P 1
14.3%
R 1
14.3%
I 1
14.3%
G 1
14.3%
M 1
14.3%
Common
ValueCountFrequency (%)
48
49.5%
) 23
23.7%
( 23
23.7%
. 2
 
2.1%
* 1
 
1.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 898
89.5%
ASCII 104
 
10.4%
None 1
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
농 54
 
6.0%
원 48
 
5.3%
협 40
 
4.5%
남 39
 
4.3%
지 33
 
3.7%
유 31
 
3.5%
주 30
 
3.3%
점 27
 
3.0%
산 24
 
2.7%
소 20
 
2.2%
Other values (171) 552
61.5%
ASCII
ValueCountFrequency (%)
48
46.2%
) 23
22.1%
( 23
22.1%
. 2
 
1.9%
C 2
 
1.9%
P 1
 
1.0%
R 1
 
1.0%
I 1
 
1.0%
G 1
 
1.0%
M 1
 
1.0%
None
ValueCountFrequency (%)
㈜ 1
100.0%

주소
Text

Distinct90
Distinct (%)92.8%
Missing0
Missing (%)0.0%
Memory size908.0 B
2023-12-13T07:47:15.546964image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length23
Mean length18.463918
Min length15

Characters and Unicode

Total characters1791
Distinct characters109
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

Unique85 ?
Unique (%)87.6%

Sample

1st row전라북도 남원시 시묘길 132
2nd row전라북도 남원시 요천로 1784
3rd row전라북도 남원시 요천로 1968
4th row전라북도 남원시 춘향로 214
5th row전라북도 남원시 산곡길 55
ValueCountFrequency (%)
전라북도 97
22.1%
남원시 97
22.1%
요천로 11
 
2.5%
남문로 8
 
1.8%
운봉읍 7
 
1.6%
충정로 5
 
1.1%
아영면 5
 
1.1%
인월면 4
 
0.9%
용성로 4
 
0.9%
사매면 4
 
0.9%
Other values (147) 196
44.7%
2023-12-13T07:47:15.954832image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
341
19.0%
남 105
 
5.9%
도 101
 
5.6%
시 100
 
5.6%
전 99
 
5.5%
원 99
 
5.5%
북 97
 
5.4%
라 97
 
5.4%
로 72
 
4.0%
1 46
 
2.6%
Other values (99) 634
35.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1146
64.0%
Space Separator 341
 
19.0%
Decimal Number 287
 
16.0%
Dash Punctuation 17
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
남 105
 
9.2%
도 101
 
8.8%
시 100
 
8.7%
전 99
 
8.6%
원 99
 
8.6%
북 97
 
8.5%
라 97
 
8.5%
로 72
 
6.3%
면 39
 
3.4%
길 25
 
2.2%
Other values (87) 312
27.2%
Decimal Number
ValueCountFrequency (%)
1 46
16.0%
2 40
13.9%
9 31
10.8%
4 30
10.5%
3 28
9.8%
7 23
8.0%
5 23
8.0%
6 23
8.0%
8 22
7.7%
0 21
7.3%
Space Separator
ValueCountFrequency (%)
341
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 17
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1146
64.0%
Common 645
36.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
남 105
 
9.2%
도 101
 
8.8%
시 100
 
8.7%
전 99
 
8.6%
원 99
 
8.6%
북 97
 
8.5%
라 97
 
8.5%
로 72
 
6.3%
면 39
 
3.4%
길 25
 
2.2%
Other values (87) 312
27.2%
Common
ValueCountFrequency (%)
341
52.9%
1 46
 
7.1%
2 40
 
6.2%
9 31
 
4.8%
4 30
 
4.7%
3 28
 
4.3%
7 23
 
3.6%
5 23
 
3.6%
6 23
 
3.6%
8 22
 
3.4%
Other values (2) 38
 
5.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1146
64.0%
ASCII 645
36.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
341
52.9%
1 46
 
7.1%
2 40
 
6.2%
9 31
 
4.8%
4 30
 
4.7%
3 28
 
4.3%
7 23
 
3.6%
5 23
 
3.6%
6 23
 
3.6%
8 22
 
3.4%
Other values (2) 38
 
5.9%
Hangul
ValueCountFrequency (%)
남 105
 
9.2%
도 101
 
8.8%
시 100
 
8.7%
전 99
 
8.6%
원 99
 
8.6%
북 97
 
8.5%
라 97
 
8.5%
로 72
 
6.3%
면 39
 
3.4%
길 25
 
2.2%
Other values (87) 312
27.2%

업종
Categorical

Distinct12
Distinct (%)12.4%
Missing0
Missing (%)0.0%
Memory size908.0 B
지역농협
40 
주유소
14 
영농법인
12 
기타
9 
도소매
6 
Other values (7)
16 

Length

Max length4
Median length4
Mean length3.3298969
Min length2

Unique

Unique2 ?
Unique (%)2.1%

Sample

1st row영농법인
2nd row기타
3rd row영농법인
4th row주유소
5th row보건업

Common Values

ValueCountFrequency (%)
지역농협 40
41.2%
주유소 14
 
14.4%
영농법인 12
 
12.4%
기타 9
 
9.3%
도소매 6
 
6.2%
병원 5
 
5.2%
약국 3
 
3.1%
식자재 2
 
2.1%
숙박 2
 
2.1%
운수업 2
 
2.1%
Other values (2) 2
 
2.1%

Length

2023-12-13T07:47:16.110966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
지역농협 40
41.2%
주유소 14
 
14.4%
영농법인 12
 
12.4%
기타 9
 
9.3%
도소매 6
 
6.2%
병원 5
 
5.2%
약국 3
 
3.1%
식자재 2
 
2.1%
숙박 2
 
2.1%
운수업 2
 
2.1%
Other values (2) 2
 
2.1%

데이터 기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size908.0 B
Minimum2023-07-28 00:00:00
Maximum2023-07-28 00:00:00
2023-12-13T07:47:16.219756image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:47:16.314284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T07:47:14.332551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T07:47:16.390851image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번가맹점명주소업종
연번1.0001.0000.9700.348
가맹점명1.0001.0001.0001.000
주소0.9701.0001.0000.997
업종0.3481.0000.9971.000
2023-12-13T07:47:16.475568image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종
연번1.0000.148
업종0.1481.000

Missing values

2023-12-13T07:47:14.432801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:47:14.518799image/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춘향골사람들 영농조합법인전라북도 남원시 시묘길 132영농법인2023-07-28
12대동공업(주) 남원대리점전라북도 남원시 요천로 1784기타2023-07-28
23현대농산영농조합법인전라북도 남원시 요천로 1968영농법인2023-07-28
34은하수주유소전라북도 남원시 춘향로 214주유소2023-07-28
45의료법인 원산의료재단전라북도 남원시 산곡길 55보건업2023-07-28
56남원원예농협 로컬푸드직매장전라북도 남원시 오들로 49지역농협2023-07-28
67남원농협하나로마트전라북도 남원시 동문로 94지역농협2023-07-28
78운봉농업협동조합(자재)전라북도 남원시 운봉읍 운봉로 679지역농협2023-07-28
89운봉농업협동조합전라북도 남원시 운봉읍 운봉로 679지역농협2023-07-28
910운봉농협주유소전라북도 남원시 운봉읍 운성로 26지역농협2023-07-28
연번가맹점명주소업종데이터 기준일자
8788남원농협대산지점전라북도 남원시 대산면 운교2길 28지역농협2023-07-28
8889남원농협 R.P.C전라북도 남원시 주생면 남문로 140-4지역농협2023-07-28
8990남원농협서부주유소전라북도 남원시 주생면 남문로 200지역농협2023-07-28
9091(유)로얄전기전라북도 남원시 원천로 47기타2023-07-28
9192(유)코리아에프앤씨전라북도 남원시 교룡로 58-22기타2023-07-28
9293남원농협동문지점전라북도 남원시 동문로 42-1지역농협2023-07-28
9394(의법)태종의료재단지점전라북도 남원시 옥정4길 7병원2023-07-28
9495남원농협용남지점전라북도 남원시 남문로 419-9지역농협2023-07-28
9596남원농협도통지점전라북도 남원시 용성로 220지역농협2023-07-28
9697공무원연금공단 남원상록골프장전라북도 남원시 대산면 월계길 11기타2023-07-28