Overview

Dataset statistics

Number of variables5
Number of observations1293
Missing cells1
Missing cells (%)< 0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory51.9 KiB
Average record size in memory41.1 B

Variable types

Numeric1
Text2
DateTime2

Dataset

Description광주광역시 광산구의 담배소매인지정( 업체명, 주소, 등록일자, 데이터기준일자 등)에 대한 정보를 제공합니다.
URLhttps://www.data.go.kr/data/15055711/fileData.do

Alerts

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

Reproduction

Analysis started2023-12-12 02:43:36.608691
Analysis finished2023-12-12 02:43:37.362856
Duration0.75 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct1293
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean647
Minimum1
Maximum1293
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size11.5 KiB
2023-12-12T11:43:37.429731image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile65.6
Q1324
median647
Q3970
95-th percentile1228.4
Maximum1293
Range1292
Interquartile range (IQR)646

Descriptive statistics

Standard deviation373.40126
Coefficient of variation (CV)0.57712714
Kurtosis-1.2
Mean647
Median Absolute Deviation (MAD)323
Skewness0
Sum836571
Variance139428.5
MonotonicityStrictly increasing
2023-12-12T11:43:37.561573image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
890 1
 
0.1%
868 1
 
0.1%
867 1
 
0.1%
866 1
 
0.1%
865 1
 
0.1%
864 1
 
0.1%
863 1
 
0.1%
862 1
 
0.1%
861 1
 
0.1%
Other values (1283) 1283
99.2%
ValueCountFrequency (%)
1 1
0.1%
2 1
0.1%
3 1
0.1%
4 1
0.1%
5 1
0.1%
6 1
0.1%
7 1
0.1%
8 1
0.1%
9 1
0.1%
10 1
0.1%
ValueCountFrequency (%)
1293 1
0.1%
1292 1
0.1%
1291 1
0.1%
1290 1
0.1%
1289 1
0.1%
1288 1
0.1%
1287 1
0.1%
1286 1
0.1%
1285 1
0.1%
1284 1
0.1%
Distinct1221
Distinct (%)94.5%
Missing1
Missing (%)0.1%
Memory size10.2 KiB
2023-12-12T11:43:37.740121image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length20
Mean length8.0990712
Min length2

Characters and Unicode

Total characters10464
Distinct characters527
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

Unique1190 ?
Unique (%)92.1%

Sample

1st row세븐일레븐 광주광산환영점
2nd row이마트24 산정태양점
3rd row세븐일레븐 광주평동역점
4th row이마트24 광주CMC타워점
5th row씨유 하남3지구점
ValueCountFrequency (%)
세븐일레븐 90
 
5.0%
씨유 50
 
2.8%
주식회사 41
 
2.3%
이마트24 39
 
2.2%
지에스25 37
 
2.1%
상호없음 31
 
1.7%
미니스톱 20
 
1.1%
주)코리아세븐 14
 
0.8%
유한회사 14
 
0.8%
지에스(gs)25 13
 
0.7%
Other values (1294) 1448
80.6%
2023-12-12T11:43:38.065197image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
551
 
5.3%
505
 
4.8%
351
 
3.4%
312
 
3.0%
282
 
2.7%
251
 
2.4%
231
 
2.2%
170
 
1.6%
) 168
 
1.6%
( 165
 
1.6%
Other values (517) 7478
71.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 8909
85.1%
Space Separator 505
 
4.8%
Decimal Number 339
 
3.2%
Uppercase Letter 313
 
3.0%
Close Punctuation 168
 
1.6%
Open Punctuation 165
 
1.6%
Lowercase Letter 51
 
0.5%
Other Punctuation 12
 
0.1%
Dash Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
551
 
6.2%
351
 
3.9%
312
 
3.5%
282
 
3.2%
251
 
2.8%
231
 
2.6%
170
 
1.9%
165
 
1.9%
147
 
1.7%
142
 
1.6%
Other values (460) 6307
70.8%
Uppercase Letter
ValueCountFrequency (%)
S 62
19.8%
G 61
19.5%
C 50
16.0%
U 36
11.5%
M 12
 
3.8%
I 11
 
3.5%
D 10
 
3.2%
K 9
 
2.9%
A 9
 
2.9%
O 8
 
2.6%
Other values (13) 45
14.4%
Lowercase Letter
ValueCountFrequency (%)
a 6
11.8%
o 6
11.8%
r 6
11.8%
l 5
9.8%
e 5
9.8%
t 4
7.8%
d 3
 
5.9%
i 3
 
5.9%
g 2
 
3.9%
k 2
 
3.9%
Other values (7) 9
17.6%
Decimal Number
ValueCountFrequency (%)
2 149
44.0%
5 102
30.1%
4 48
 
14.2%
3 10
 
2.9%
0 9
 
2.7%
1 5
 
1.5%
6 5
 
1.5%
7 4
 
1.2%
9 4
 
1.2%
8 3
 
0.9%
Other Punctuation
ValueCountFrequency (%)
. 9
75.0%
# 2
 
16.7%
/ 1
 
8.3%
Space Separator
ValueCountFrequency (%)
505
100.0%
Close Punctuation
ValueCountFrequency (%)
) 168
100.0%
Open Punctuation
ValueCountFrequency (%)
( 165
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 8909
85.1%
Common 1191
 
11.4%
Latin 364
 
3.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
551
 
6.2%
351
 
3.9%
312
 
3.5%
282
 
3.2%
251
 
2.8%
231
 
2.6%
170
 
1.9%
165
 
1.9%
147
 
1.7%
142
 
1.6%
Other values (460) 6307
70.8%
Latin
ValueCountFrequency (%)
S 62
17.0%
G 61
16.8%
C 50
13.7%
U 36
 
9.9%
M 12
 
3.3%
I 11
 
3.0%
D 10
 
2.7%
K 9
 
2.5%
A 9
 
2.5%
O 8
 
2.2%
Other values (30) 96
26.4%
Common
ValueCountFrequency (%)
505
42.4%
) 168
 
14.1%
( 165
 
13.9%
2 149
 
12.5%
5 102
 
8.6%
4 48
 
4.0%
3 10
 
0.8%
0 9
 
0.8%
. 9
 
0.8%
1 5
 
0.4%
Other values (7) 21
 
1.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 8909
85.1%
ASCII 1555
 
14.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
551
 
6.2%
351
 
3.9%
312
 
3.5%
282
 
3.2%
251
 
2.8%
231
 
2.6%
170
 
1.9%
165
 
1.9%
147
 
1.7%
142
 
1.6%
Other values (460) 6307
70.8%
ASCII
ValueCountFrequency (%)
505
32.5%
) 168
 
10.8%
( 165
 
10.6%
2 149
 
9.6%
5 102
 
6.6%
S 62
 
4.0%
G 61
 
3.9%
C 50
 
3.2%
4 48
 
3.1%
U 36
 
2.3%
Other values (47) 209
13.4%

주소
Text

Distinct1281
Distinct (%)99.1%
Missing0
Missing (%)0.0%
Memory size10.2 KiB
2023-12-12T11:43:38.343967image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length73
Median length56
Mean length29.679041
Min length15

Characters and Unicode

Total characters38375
Distinct characters310
Distinct categories10 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1269 ?
Unique (%)98.1%

Sample

1st row광주광역시 광산구 사암로 823 (도천동)
2nd row광주광역시 광산구 산정공원로59번길 40. 1층 (산정동)
3rd row광주광역시 광산구 평동산단로 192. 1층 (월전동)
4th row광주광역시 광산구 첨단중앙로152번길 81-15
5th row광주광역시 광산구 고봉로 96. 1층 (하남동)
ValueCountFrequency (%)
광산구 1292
 
17.6%
광주광역시 1291
 
17.6%
1층 275
 
3.8%
월계동 90
 
1.2%
우산동 87
 
1.2%
송정동 82
 
1.1%
상가동 71
 
1.0%
장덕동 69
 
0.9%
월곡동 68
 
0.9%
101호 68
 
0.9%
Other values (1489) 3940
53.7%
2023-12-12T11:43:38.756244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6369
 
16.6%
3925
 
10.2%
1 1758
 
4.6%
1736
 
4.5%
1508
 
3.9%
1333
 
3.5%
1322
 
3.4%
1311
 
3.4%
1293
 
3.4%
) 1151
 
3.0%
Other values (300) 16669
43.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 22346
58.2%
Space Separator 6369
 
16.6%
Decimal Number 6251
 
16.3%
Close Punctuation 1151
 
3.0%
Open Punctuation 1149
 
3.0%
Other Punctuation 711
 
1.9%
Dash Punctuation 338
 
0.9%
Uppercase Letter 51
 
0.1%
Lowercase Letter 5
 
< 0.1%
Math Symbol 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
3925
17.6%
1736
 
7.8%
1508
 
6.7%
1333
 
6.0%
1322
 
5.9%
1311
 
5.9%
1293
 
5.8%
1121
 
5.0%
563
 
2.5%
561
 
2.5%
Other values (262) 7673
34.3%
Uppercase Letter
ValueCountFrequency (%)
B 10
19.6%
A 8
15.7%
C 6
11.8%
L 4
 
7.8%
E 4
 
7.8%
S 4
 
7.8%
T 2
 
3.9%
P 2
 
3.9%
M 2
 
3.9%
G 2
 
3.9%
Other values (5) 7
13.7%
Decimal Number
ValueCountFrequency (%)
1 1758
28.1%
2 833
13.3%
0 679
 
10.9%
3 607
 
9.7%
5 478
 
7.6%
4 438
 
7.0%
6 395
 
6.3%
7 374
 
6.0%
8 359
 
5.7%
9 330
 
5.3%
Lowercase Letter
ValueCountFrequency (%)
b 1
20.0%
s 1
20.0%
e 1
20.0%
h 1
20.0%
t 1
20.0%
Other Punctuation
ValueCountFrequency (%)
. 696
97.9%
@ 14
 
2.0%
/ 1
 
0.1%
Space Separator
ValueCountFrequency (%)
6369
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1151
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1149
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 338
100.0%
Math Symbol
ValueCountFrequency (%)
~ 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 22346
58.2%
Common 15973
41.6%
Latin 56
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
3925
17.6%
1736
 
7.8%
1508
 
6.7%
1333
 
6.0%
1322
 
5.9%
1311
 
5.9%
1293
 
5.8%
1121
 
5.0%
563
 
2.5%
561
 
2.5%
Other values (262) 7673
34.3%
Latin
ValueCountFrequency (%)
B 10
17.9%
A 8
14.3%
C 6
10.7%
L 4
 
7.1%
E 4
 
7.1%
S 4
 
7.1%
T 2
 
3.6%
P 2
 
3.6%
M 2
 
3.6%
G 2
 
3.6%
Other values (10) 12
21.4%
Common
ValueCountFrequency (%)
6369
39.9%
1 1758
 
11.0%
) 1151
 
7.2%
( 1149
 
7.2%
2 833
 
5.2%
. 696
 
4.4%
0 679
 
4.3%
3 607
 
3.8%
5 478
 
3.0%
4 438
 
2.7%
Other values (8) 1815
 
11.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 22346
58.2%
ASCII 16029
41.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6369
39.7%
1 1758
 
11.0%
) 1151
 
7.2%
( 1149
 
7.2%
2 833
 
5.2%
. 696
 
4.3%
0 679
 
4.2%
3 607
 
3.8%
5 478
 
3.0%
4 438
 
2.7%
Other values (28) 1871
 
11.7%
Hangul
ValueCountFrequency (%)
3925
17.6%
1736
 
7.8%
1508
 
6.7%
1333
 
6.0%
1322
 
5.9%
1311
 
5.9%
1293
 
5.8%
1121
 
5.0%
563
 
2.5%
561
 
2.5%
Other values (262) 7673
34.3%
Distinct1016
Distinct (%)78.6%
Missing0
Missing (%)0.0%
Memory size10.2 KiB
Minimum1989-06-14 00:00:00
Maximum2022-12-30 00:00:00
2023-12-12T11:43:38.903453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:43:39.047525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size10.2 KiB
Minimum2022-12-31 00:00:00
Maximum2022-12-31 00:00:00
2023-12-12T11:43:39.160285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:43:39.246548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T11:43:37.087278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-12T11:43:37.233019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T11:43:37.327714image/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세븐일레븐 광주광산환영점광주광역시 광산구 사암로 823 (도천동)2022-12-302022-12-31
12이마트24 산정태양점광주광역시 광산구 산정공원로59번길 40. 1층 (산정동)2022-12-302022-12-31
23세븐일레븐 광주평동역점광주광역시 광산구 평동산단로 192. 1층 (월전동)2022-12-302022-12-31
34이마트24 광주CMC타워점광주광역시 광산구 첨단중앙로152번길 81-152022-12-262022-12-31
45씨유 하남3지구점광주광역시 광산구 고봉로 96. 1층 (하남동)2022-12-222022-12-31
56이마트24 광주돈보스코점광주광역시 광산구 고봉로 130. 1층 (하남동)2022-12-202022-12-31
67세븐일레븐 광주송정대화점광주광역시 광산구 송도로212번길 31-82022-12-192022-12-31
78세븐일레븐 광주산정대덕점광주광역시 광산구 산정공원로81번길 36. 1층 (산정동)2022-12-192022-12-31
89이마트24 광주신가원룸점광주광역시 광산구 신가삼효로 26. 1층 (신가동)2022-12-132022-12-31
910유한회사 장보고푸드광주광역시 광산구 목련로381번길 25. 101호 (신가동)2022-12-132022-12-31
연번업체명주소등록일자데이터기준일자
12831284상호없음광주광역시 광산구 고봉로 99 (하남동)1990-01-012022-12-31
12841285상호없음광주광역시 광산구 장수길 66 (장수동)1990-01-012022-12-31
12851286미니슈퍼광주광역시 광산구 신가동 30-10361990-01-012022-12-31
12861287상호없음광주광역시 광산구 쌍암동 1821990-01-012022-12-31
12871288상호없음광주광역시 광산구 상완길 153 (수완동)1990-01-012022-12-31
12881289만국체인광주광역시 광산구 신창동 910호1990-01-012022-12-31
12891290상호없음광주광역시 광산구 북문대로 342-68 (신창동)1990-01-012022-12-31
12901291상호없음광주광역시 광산구 신가삼효로 25(신가동)1990-01-012022-12-31
12911292일진슈퍼문구광주광역시 광산구 내상로15번길 16 (송정동)1989-09-052022-12-31
12921293상호없음광주광역시 광산구 우산로 85 (우산동)1989-06-142022-12-31