Overview

Dataset statistics

Number of variables7
Number of observations819
Missing cells27
Missing cells (%)0.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory47.3 KiB
Average record size in memory59.2 B

Variable types

Numeric3
Text2
DateTime2

Dataset

Description광주광역시 광산구 내 종량제 봉투 지정 판매업소 현황(업소명, 주소, 등록일자, 위도, 경도, 데이터기준일자 등)을 제공합니다.
URLhttps://www.data.go.kr/data/15062471/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
연번 is highly overall correlated with 위도 and 1 other fieldsHigh correlation
위도 is highly overall correlated with 연번 and 1 other fieldsHigh correlation
경도 is highly overall correlated with 연번 and 1 other fieldsHigh correlation
등록일자 has 27 (3.3%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 15:55:44.301159
Analysis finished2023-12-12 15:55:46.773450
Duration2.47 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct819
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean410
Minimum1
Maximum819
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.3 KiB
2023-12-13T00:55:46.857223image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile41.9
Q1205.5
median410
Q3614.5
95-th percentile778.1
Maximum819
Range818
Interquartile range (IQR)409

Descriptive statistics

Standard deviation236.56923
Coefficient of variation (CV)0.57699812
Kurtosis-1.2
Mean410
Median Absolute Deviation (MAD)205
Skewness0
Sum335790
Variance55965
MonotonicityStrictly increasing
2023-12-13T00:55:47.029359image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
552 1
 
0.1%
542 1
 
0.1%
543 1
 
0.1%
544 1
 
0.1%
545 1
 
0.1%
546 1
 
0.1%
547 1
 
0.1%
548 1
 
0.1%
549 1
 
0.1%
Other values (809) 809
98.8%
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 (%)
819 1
0.1%
818 1
0.1%
817 1
0.1%
816 1
0.1%
815 1
0.1%
814 1
0.1%
813 1
0.1%
812 1
0.1%
811 1
0.1%
810 1
0.1%
Distinct799
Distinct (%)97.6%
Missing0
Missing (%)0.0%
Memory size6.5 KiB
2023-12-13T00:55:47.395653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length18
Mean length9.2380952
Min length2

Characters and Unicode

Total characters7566
Distinct characters401
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

Unique784 ?
Unique (%)95.7%

Sample

1st row에스마트(부국슈퍼)
2nd row환희수퍼
3rd row광주비아농협비아지점
4th row세븐일레븐 광주비아중흥점
5th row하나마트
ValueCountFrequency (%)
세븐일레븐 122
 
9.1%
gs25 62
 
4.6%
cu 52
 
3.9%
이마트24 42
 
3.1%
주식회사 29
 
2.2%
미니스톱 27
 
2.0%
씨유 23
 
1.7%
지에스25 12
 
0.9%
와이마트 10
 
0.7%
유한회사 9
 
0.7%
Other values (817) 948
71.0%
2023-12-13T00:55:47.911695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
517
 
6.8%
487
 
6.4%
294
 
3.9%
267
 
3.5%
265
 
3.5%
261
 
3.4%
217
 
2.9%
2 155
 
2.0%
154
 
2.0%
145
 
1.9%
Other values (391) 4804
63.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6103
80.7%
Space Separator 517
 
6.8%
Uppercase Letter 409
 
5.4%
Decimal Number 334
 
4.4%
Close Punctuation 96
 
1.3%
Open Punctuation 89
 
1.2%
Lowercase Letter 13
 
0.2%
Other Punctuation 3
 
< 0.1%
Dash Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
487
 
8.0%
294
 
4.8%
267
 
4.4%
265
 
4.3%
261
 
4.3%
217
 
3.6%
154
 
2.5%
145
 
2.4%
144
 
2.4%
117
 
1.9%
Other values (343) 3752
61.5%
Uppercase Letter
ValueCountFrequency (%)
S 92
22.5%
C 84
20.5%
G 81
19.8%
U 75
18.3%
M 13
 
3.2%
A 10
 
2.4%
I 7
 
1.7%
R 6
 
1.5%
T 5
 
1.2%
O 5
 
1.2%
Other values (14) 31
 
7.6%
Decimal Number
ValueCountFrequency (%)
2 155
46.4%
5 104
31.1%
4 49
 
14.7%
3 12
 
3.6%
6 4
 
1.2%
1 3
 
0.9%
9 3
 
0.9%
7 2
 
0.6%
8 2
 
0.6%
Lowercase Letter
ValueCountFrequency (%)
e 3
23.1%
l 3
23.1%
r 1
 
7.7%
a 1
 
7.7%
t 1
 
7.7%
y 1
 
7.7%
h 1
 
7.7%
s 1
 
7.7%
f 1
 
7.7%
Other Punctuation
ValueCountFrequency (%)
. 2
66.7%
& 1
33.3%
Space Separator
ValueCountFrequency (%)
517
100.0%
Close Punctuation
ValueCountFrequency (%)
) 96
100.0%
Open Punctuation
ValueCountFrequency (%)
( 89
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6103
80.7%
Common 1041
 
13.8%
Latin 422
 
5.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
487
 
8.0%
294
 
4.8%
267
 
4.4%
265
 
4.3%
261
 
4.3%
217
 
3.6%
154
 
2.5%
145
 
2.4%
144
 
2.4%
117
 
1.9%
Other values (343) 3752
61.5%
Latin
ValueCountFrequency (%)
S 92
21.8%
C 84
19.9%
G 81
19.2%
U 75
17.8%
M 13
 
3.1%
A 10
 
2.4%
I 7
 
1.7%
R 6
 
1.4%
T 5
 
1.2%
O 5
 
1.2%
Other values (23) 44
10.4%
Common
ValueCountFrequency (%)
517
49.7%
2 155
 
14.9%
5 104
 
10.0%
) 96
 
9.2%
( 89
 
8.5%
4 49
 
4.7%
3 12
 
1.2%
6 4
 
0.4%
1 3
 
0.3%
9 3
 
0.3%
Other values (5) 9
 
0.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6103
80.7%
ASCII 1463
 
19.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
517
35.3%
2 155
 
10.6%
5 104
 
7.1%
) 96
 
6.6%
S 92
 
6.3%
( 89
 
6.1%
C 84
 
5.7%
G 81
 
5.5%
U 75
 
5.1%
4 49
 
3.3%
Other values (38) 121
 
8.3%
Hangul
ValueCountFrequency (%)
487
 
8.0%
294
 
4.8%
267
 
4.4%
265
 
4.3%
261
 
4.3%
217
 
3.6%
154
 
2.5%
145
 
2.4%
144
 
2.4%
117
 
1.9%
Other values (343) 3752
61.5%

주소
Text

Distinct809
Distinct (%)98.8%
Missing0
Missing (%)0.0%
Memory size6.5 KiB
2023-12-13T00:55:48.277571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length46
Median length39
Mean length29.382173
Min length15

Characters and Unicode

Total characters24064
Distinct characters244
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

Unique799 ?
Unique (%)97.6%

Sample

1st row광주광역시 광산구 비아중앙로 22-1
2nd row광주광역시 광산구 북문대로419번길 61(신창동650-1)
3rd row광주광역시 광산구 비아중앙로 36(비아동)
4th row광주광역시 광산구 비아안길 29, 1층(비아동)
5th row광주광역시 광산구 임방울대로 727-5(월계동759-3)
ValueCountFrequency (%)
광주광역시 817
21.5%
광산구 798
21.0%
1층 67
 
1.8%
상가동 30
 
0.8%
월계로 18
 
0.5%
101호 17
 
0.4%
임방울대로 17
 
0.4%
상무대로 16
 
0.4%
사암로 14
 
0.4%
월곡산정로 12
 
0.3%
Other values (1299) 1988
52.4%
2023-12-13T00:55:48.878917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2975
 
12.4%
2445
 
10.2%
1 1452
 
6.0%
1050
 
4.4%
828
 
3.4%
826
 
3.4%
822
 
3.4%
818
 
3.4%
817
 
3.4%
792
 
3.3%
Other values (234) 11239
46.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 13697
56.9%
Decimal Number 5146
 
21.4%
Space Separator 2975
 
12.4%
Open Punctuation 700
 
2.9%
Close Punctuation 696
 
2.9%
Other Punctuation 485
 
2.0%
Dash Punctuation 336
 
1.4%
Uppercase Letter 16
 
0.1%
Math Symbol 12
 
< 0.1%
Lowercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
2445
17.9%
1050
 
7.7%
828
 
6.0%
826
 
6.0%
822
 
6.0%
818
 
6.0%
817
 
6.0%
792
 
5.8%
430
 
3.1%
428
 
3.1%
Other values (206) 4441
32.4%
Decimal Number
ValueCountFrequency (%)
1 1452
28.2%
2 655
12.7%
0 605
11.8%
3 448
 
8.7%
5 405
 
7.9%
7 333
 
6.5%
4 327
 
6.4%
6 325
 
6.3%
8 324
 
6.3%
9 272
 
5.3%
Uppercase Letter
ValueCountFrequency (%)
B 7
43.8%
L 2
 
12.5%
H 2
 
12.5%
T 1
 
6.2%
P 1
 
6.2%
A 1
 
6.2%
D 1
 
6.2%
N 1
 
6.2%
Other Punctuation
ValueCountFrequency (%)
, 465
95.9%
@ 17
 
3.5%
. 2
 
0.4%
/ 1
 
0.2%
Space Separator
ValueCountFrequency (%)
2975
100.0%
Open Punctuation
ValueCountFrequency (%)
( 700
100.0%
Close Punctuation
ValueCountFrequency (%)
) 696
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 336
100.0%
Math Symbol
ValueCountFrequency (%)
~ 12
100.0%
Lowercase Letter
ValueCountFrequency (%)
s 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 13697
56.9%
Common 10350
43.0%
Latin 17
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
2445
17.9%
1050
 
7.7%
828
 
6.0%
826
 
6.0%
822
 
6.0%
818
 
6.0%
817
 
6.0%
792
 
5.8%
430
 
3.1%
428
 
3.1%
Other values (206) 4441
32.4%
Common
ValueCountFrequency (%)
2975
28.7%
1 1452
14.0%
( 700
 
6.8%
) 696
 
6.7%
2 655
 
6.3%
0 605
 
5.8%
, 465
 
4.5%
3 448
 
4.3%
5 405
 
3.9%
- 336
 
3.2%
Other values (9) 1613
15.6%
Latin
ValueCountFrequency (%)
B 7
41.2%
L 2
 
11.8%
H 2
 
11.8%
s 1
 
5.9%
T 1
 
5.9%
P 1
 
5.9%
A 1
 
5.9%
D 1
 
5.9%
N 1
 
5.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 13697
56.9%
ASCII 10367
43.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2975
28.7%
1 1452
14.0%
( 700
 
6.8%
) 696
 
6.7%
2 655
 
6.3%
0 605
 
5.8%
, 465
 
4.5%
3 448
 
4.3%
5 405
 
3.9%
- 336
 
3.2%
Other values (18) 1630
15.7%
Hangul
ValueCountFrequency (%)
2445
17.9%
1050
 
7.7%
828
 
6.0%
826
 
6.0%
822
 
6.0%
818
 
6.0%
817
 
6.0%
792
 
5.8%
430
 
3.1%
428
 
3.1%
Other values (206) 4441
32.4%

등록일자
Date

MISSING 

Distinct583
Distinct (%)73.6%
Missing27
Missing (%)3.3%
Memory size6.5 KiB
Minimum2006-01-18 00:00:00
Maximum2023-05-01 00:00:00
2023-12-13T00:55:49.060266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:55:49.230999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

위도
Real number (ℝ)

HIGH CORRELATION 

Distinct753
Distinct (%)91.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35.177096
Minimum34.998021
Maximum35.25586
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.3 KiB
2023-12-13T00:55:49.412958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum34.998021
5-th percentile35.126096
Q135.156713
median35.178698
Q335.19771
95-th percentile35.22007
Maximum35.25586
Range0.2578387
Interquartile range (IQR)0.040996784

Descriptive statistics

Standard deviation0.029615596
Coefficient of variation (CV)0.00084189996
Kurtosis0.70913598
Mean35.177096
Median Absolute Deviation (MAD)0.02103489
Skewness-0.48479232
Sum28810.042
Variance0.00087708353
MonotonicityNot monotonic
2023-12-13T00:55:49.594784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
35.1786983203958 4
 
0.5%
35.1976289284711 3
 
0.4%
35.2200213271829 3
 
0.4%
35.1865811338555 3
 
0.4%
35.1663171496993 3
 
0.4%
35.1960412506558 3
 
0.4%
35.1744476453159 3
 
0.4%
35.2172043010014 2
 
0.2%
35.191939946619 2
 
0.2%
35.2020864269436 2
 
0.2%
Other values (743) 791
96.6%
ValueCountFrequency (%)
34.9980214665338 1
0.1%
35.0978204725317 1
0.1%
35.097995548563 1
0.1%
35.0993172730376 1
0.1%
35.1126153997634 1
0.1%
35.1128712577717 1
0.1%
35.1136538647861 1
0.1%
35.1138786838956 1
0.1%
35.1177107318383 1
0.1%
35.1201638904424 1
0.1%
ValueCountFrequency (%)
35.2558601641607 1
0.1%
35.2278560593543 1
0.1%
35.2239943414096 1
0.1%
35.2238673020497 1
0.1%
35.2234474387527 1
0.1%
35.2230973714048 1
0.1%
35.2229436147483 1
0.1%
35.2228545641556 1
0.1%
35.2223889161913 1
0.1%
35.2220676896465 1
0.1%

경도
Real number (ℝ)

HIGH CORRELATION 

Distinct753
Distinct (%)91.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.81393
Minimum126.67251
Maximum126.91863
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.3 KiB
2023-12-13T00:55:49.795737image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.67251
5-th percentile126.77367
Q1126.79878
median126.81118
Q3126.83395
95-th percentile126.84931
Maximum126.91863
Range0.2461211
Interquartile range (IQR)0.035167065

Descriptive statistics

Standard deviation0.02699501
Coefficient of variation (CV)0.00021287102
Kurtosis3.8568735
Mean126.81393
Median Absolute Deviation (MAD)0.015831326
Skewness-0.21586618
Sum103860.61
Variance0.00072873054
MonotonicityNot monotonic
2023-12-13T00:55:49.961342image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
126.815611304865 4
 
0.5%
126.835320637274 3
 
0.4%
126.836282851515 3
 
0.4%
126.834267946601 3
 
0.4%
126.803870190698 3
 
0.4%
126.820273448948 3
 
0.4%
126.816698578944 3
 
0.4%
126.844106938759 2
 
0.2%
126.82628755627 2
 
0.2%
126.804108734874 2
 
0.2%
Other values (743) 791
96.6%
ValueCountFrequency (%)
126.672510114223 1
0.1%
126.674740874164 1
0.1%
126.680394133004 1
0.1%
126.699812604839 1
0.1%
126.701172633997 1
0.1%
126.729937746735 1
0.1%
126.743728121399 1
0.1%
126.745434893351 1
0.1%
126.751299335913 1
0.1%
126.754969019382 1
0.1%
ValueCountFrequency (%)
126.918631215593 1
0.1%
126.916877220082 1
0.1%
126.913490656644 1
0.1%
126.912183450401 1
0.1%
126.907117007428 1
0.1%
126.906344673465 1
0.1%
126.906111971383 1
0.1%
126.905620804273 1
0.1%
126.902165349268 1
0.1%
126.900853319097 1
0.1%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.5 KiB
Minimum2022-12-31 00:00:00
Maximum2022-12-31 00:00:00
2023-12-13T00:55:50.083166image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:55:50.196026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T00:55:46.174808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:55:44.850451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:55:45.726014image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:55:46.297057image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:55:45.437798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:55:45.889362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:55:46.420392image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:55:45.580177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:55:46.035753image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T00:55:50.297676image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번위도경도
연번1.0000.7220.785
위도0.7221.0000.685
경도0.7850.6851.000
2023-12-13T00:55:50.437736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번위도경도
연번1.000-0.675-0.545
위도-0.6751.0000.708
경도-0.5450.7081.000

Missing values

2023-12-13T00:55:46.569577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T00:55:46.725460image/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에스마트(부국슈퍼)광주광역시 광산구 비아중앙로 22-12011-07-1935.220947126.8248642022-12-31
12환희수퍼광주광역시 광산구 북문대로419번길 61(신창동650-1)2016-06-0835.192325126.8461072022-12-31
23광주비아농협비아지점광주광역시 광산구 비아중앙로 36(비아동)2017-11-1435.222068126.8250272022-12-31
34세븐일레븐 광주비아중흥점광주광역시 광산구 비아안길 29, 1층(비아동)2011-01-2035.220793126.817782022-12-31
45하나마트광주광역시 광산구 임방울대로 727-5(월계동759-3)2011-01-2035.218175126.837072022-12-31
56남양마트광주광역시 광산구 월계로 137(월계동765-6)2011-12-1935.213632126.8408972022-12-31
67미래마트광주광역시 광산구 목련로 307-13, 104호(운남동,주공3단지아파트)2019-08-2735.176711126.827132022-12-31
78씨유하남8번로점광주광역시 광산구 하남산단천변우로 28, 1층 (도천동)2016-05-0435.208658126.8134572022-12-31
89영암마트 첨단호반점광주광역시 광산구 월계로 59(월계동763-6)2011-12-0935.21276126.8323662022-12-31
910동부마트광주광역시 광산구 임방울대로 727-5(월계동759-3)2016-05-0435.218175126.837072022-12-31
연번사업장명주소등록일자위도경도데이터기준일자
809810롯데쇼핑 (주)광주점광주광역시 동구 독립로 268(대인동)2018-10-0435.154558126.9121832022-12-31
810811주식회사 쿱스토어 광주전남 신용점광주광역시 북구 첨단연신로107번길 41 1층 3,4호(신용동)2018-11-1635.207261126.8597822022-12-31
811812농협 장성군 로컬푸드직매장전라남도 장성군 진원면 하서대로 333-22019-04-1235.25586126.8108332022-12-31
812813(주) 지맥스광주광역시 북구 양산택지로37번길 89(양산동)<NA>35.207289126.8752672022-12-31
813814홈케어서비스연구소광주광역시 남구 화산로31번안길 2, 117동 107호(진월 풍림@)2022-03-2535.112871126.8995352022-12-31
814815도곡농협로컬푸드직매장전라남도 화순군 도곡면 효죽로 3<NA>34.998021126.9168772022-12-31
815816(주)다우환경광주광역시 북구 자동차로62-1, 2층(신안동)2021-10-2535.164839126.9021652022-12-31
816817(주)엘에스리테일-에스엠마트 내방광주광역시 서구 내방로306번길11, 1층(내방동)2021-11-1735.156408126.8740912022-12-31
817818옐로우시티 장성로컬푸드직매장광주광역시 북구 오룡동949-52022-06-1535.227856126.836572022-12-31
818819유한회사효덕개발광주광역시 남구 서문대로 749번마길 30, 상가 101호2023-03-1435.123067126.8929222022-12-31