Overview

Dataset statistics

Number of variables6
Number of observations659
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory33.0 KiB
Average record size in memory51.2 B

Variable types

Numeric3
Text2
DateTime1

Dataset

Description광주광역시 광산구 관내 음식물 쓰레기 스티커 판매업소 현황(사업장명, 주소, 경도, 위도, 데이터기준일자 등) 정보를 제공합니다.
URLhttps://www.data.go.kr/data/15055956/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
위도 is highly overall correlated with 경도High correlation
경도 is highly overall correlated with 위도High correlation
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 14:41:59.793093
Analysis finished2023-12-12 14:42:01.549899
Duration1.76 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct659
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean330
Minimum1
Maximum659
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.9 KiB
2023-12-12T23:42:01.646018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile33.9
Q1165.5
median330
Q3494.5
95-th percentile626.1
Maximum659
Range658
Interquartile range (IQR)329

Descriptive statistics

Standard deviation190.3812
Coefficient of variation (CV)0.57691272
Kurtosis-1.2
Mean330
Median Absolute Deviation (MAD)165
Skewness0
Sum217470
Variance36245
MonotonicityStrictly increasing
2023-12-12T23:42:02.154391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
435 1
 
0.2%
437 1
 
0.2%
438 1
 
0.2%
439 1
 
0.2%
440 1
 
0.2%
441 1
 
0.2%
442 1
 
0.2%
443 1
 
0.2%
444 1
 
0.2%
Other values (649) 649
98.5%
ValueCountFrequency (%)
1 1
0.2%
2 1
0.2%
3 1
0.2%
4 1
0.2%
5 1
0.2%
6 1
0.2%
7 1
0.2%
8 1
0.2%
9 1
0.2%
10 1
0.2%
ValueCountFrequency (%)
659 1
0.2%
658 1
0.2%
657 1
0.2%
656 1
0.2%
655 1
0.2%
654 1
0.2%
653 1
0.2%
652 1
0.2%
651 1
0.2%
650 1
0.2%
Distinct634
Distinct (%)96.2%
Missing0
Missing (%)0.0%
Memory size5.3 KiB
2023-12-12T23:42:02.467752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length18
Mean length8.8679818
Min length2

Characters and Unicode

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

Unique

Unique612 ?
Unique (%)92.9%

Sample

1st row하남공단종합상사
2nd row알리바이(24시편의점)
3rd row주)에스엠마트남동
4th row씨유하남8번로점
5th row미니스톱하남도천점
ValueCountFrequency (%)
세븐일레븐 73
 
7.3%
씨유 48
 
4.8%
지에스25 29
 
2.9%
이마트24 26
 
2.6%
미니스톱 22
 
2.2%
gs25 16
 
1.6%
주식회사 16
 
1.6%
유한회사 10
 
1.0%
cu 9
 
0.9%
지에스(gs)25 7
 
0.7%
Other values (661) 749
74.5%
2023-12-12T23:42:02.964797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
387
 
6.6%
346
 
5.9%
262
 
4.5%
225
 
3.9%
198
 
3.4%
177
 
3.0%
148
 
2.5%
116
 
2.0%
112
 
1.9%
2 111
 
1.9%
Other values (350) 3762
64.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4885
83.6%
Space Separator 346
 
5.9%
Decimal Number 243
 
4.2%
Uppercase Letter 207
 
3.5%
Close Punctuation 73
 
1.2%
Open Punctuation 64
 
1.1%
Lowercase Letter 22
 
0.4%
Other Symbol 3
 
0.1%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
387
 
7.9%
262
 
5.4%
225
 
4.6%
198
 
4.1%
177
 
3.6%
148
 
3.0%
116
 
2.4%
112
 
2.3%
111
 
2.3%
106
 
2.2%
Other values (305) 3043
62.3%
Uppercase Letter
ValueCountFrequency (%)
S 51
24.6%
G 42
20.3%
C 34
16.4%
U 31
15.0%
M 10
 
4.8%
K 5
 
2.4%
D 5
 
2.4%
A 5
 
2.4%
T 3
 
1.4%
O 3
 
1.4%
Other values (10) 18
 
8.7%
Lowercase Letter
ValueCountFrequency (%)
u 4
18.2%
c 4
18.2%
e 4
18.2%
l 3
13.6%
f 1
 
4.5%
s 1
 
4.5%
t 1
 
4.5%
r 1
 
4.5%
a 1
 
4.5%
y 1
 
4.5%
Decimal Number
ValueCountFrequency (%)
2 111
45.7%
5 77
31.7%
4 35
 
14.4%
3 8
 
3.3%
6 4
 
1.6%
1 3
 
1.2%
9 2
 
0.8%
0 2
 
0.8%
8 1
 
0.4%
Space Separator
ValueCountFrequency (%)
346
100.0%
Close Punctuation
ValueCountFrequency (%)
) 73
100.0%
Open Punctuation
ValueCountFrequency (%)
( 64
100.0%
Other Symbol
ValueCountFrequency (%)
3
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4888
83.6%
Common 727
 
12.4%
Latin 229
 
3.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
387
 
7.9%
262
 
5.4%
225
 
4.6%
198
 
4.1%
177
 
3.6%
148
 
3.0%
116
 
2.4%
112
 
2.3%
111
 
2.3%
106
 
2.2%
Other values (306) 3046
62.3%
Latin
ValueCountFrequency (%)
S 51
22.3%
G 42
18.3%
C 34
14.8%
U 31
13.5%
M 10
 
4.4%
K 5
 
2.2%
D 5
 
2.2%
A 5
 
2.2%
u 4
 
1.7%
c 4
 
1.7%
Other values (21) 38
16.6%
Common
ValueCountFrequency (%)
346
47.6%
2 111
 
15.3%
5 77
 
10.6%
) 73
 
10.0%
( 64
 
8.8%
4 35
 
4.8%
3 8
 
1.1%
6 4
 
0.6%
1 3
 
0.4%
9 2
 
0.3%
Other values (3) 4
 
0.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4885
83.6%
ASCII 956
 
16.4%
None 3
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
387
 
7.9%
262
 
5.4%
225
 
4.6%
198
 
4.1%
177
 
3.6%
148
 
3.0%
116
 
2.4%
112
 
2.3%
111
 
2.3%
106
 
2.2%
Other values (305) 3043
62.3%
ASCII
ValueCountFrequency (%)
346
36.2%
2 111
 
11.6%
5 77
 
8.1%
) 73
 
7.6%
( 64
 
6.7%
S 51
 
5.3%
G 42
 
4.4%
4 35
 
3.7%
C 34
 
3.6%
U 31
 
3.2%
Other values (34) 92
 
9.6%
None
ValueCountFrequency (%)
3
100.0%

주소
Text

Distinct658
Distinct (%)99.8%
Missing0
Missing (%)0.0%
Memory size5.3 KiB
2023-12-12T23:42:03.345896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length54
Median length46
Mean length34.086495
Min length17

Characters and Unicode

Total characters22463
Distinct characters274
Distinct categories10 ?
Distinct scripts4 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique657 ?
Unique (%)99.7%

Sample

1st row광주광역시 광산구 하남산단4번로 172 (장덕동 992-11)
2nd row광주광역시 광산구 왕버들로 11, 가동 101호 (장덕동 505-86)
3rd row광주광역시 광산구 장덕로95번길 46 (장덕동 1102, 수완자이아파트 정문)
4th row광주광역시 광산구 하남산단천변우로 28, 1층 (도천동 622-2)
5th row광주광역시 광산구 하남산단8번로 169 기업은행 옆
ValueCountFrequency (%)
광주광역시 659
 
17.1%
광산구 653
 
17.0%
1층 63
 
1.6%
상가동 39
 
1.0%
월계동 29
 
0.8%
장덕동 20
 
0.5%
임방울대로 16
 
0.4%
쌍암동 15
 
0.4%
산정동 14
 
0.4%
월전로 13
 
0.3%
Other values (1517) 2323
60.4%
2023-12-12T23:42:03.876470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3185
 
14.2%
1987
 
8.8%
1 1385
 
6.2%
883
 
3.9%
755
 
3.4%
675
 
3.0%
673
 
3.0%
668
 
3.0%
659
 
2.9%
( 643
 
2.9%
Other values (264) 10950
48.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 11717
52.2%
Decimal Number 5355
23.8%
Space Separator 3185
 
14.2%
Open Punctuation 643
 
2.9%
Close Punctuation 642
 
2.9%
Dash Punctuation 508
 
2.3%
Other Punctuation 382
 
1.7%
Math Symbol 17
 
0.1%
Lowercase Letter 10
 
< 0.1%
Uppercase Letter 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
1987
17.0%
883
 
7.5%
755
 
6.4%
675
 
5.8%
673
 
5.7%
668
 
5.7%
659
 
5.6%
621
 
5.3%
347
 
3.0%
339
 
2.9%
Other values (237) 4110
35.1%
Decimal Number
ValueCountFrequency (%)
1 1385
25.9%
2 641
12.0%
0 569
10.6%
3 443
 
8.3%
5 443
 
8.3%
6 406
 
7.6%
8 382
 
7.1%
7 369
 
6.9%
4 363
 
6.8%
9 354
 
6.6%
Other Punctuation
ValueCountFrequency (%)
, 370
96.9%
@ 7
 
1.8%
· 3
 
0.8%
. 2
 
0.5%
Uppercase Letter
ValueCountFrequency (%)
L 1
25.0%
D 1
25.0%
C 1
25.0%
S 1
25.0%
Lowercase Letter
ValueCountFrequency (%)
m 8
80.0%
t 1
 
10.0%
k 1
 
10.0%
Math Symbol
ValueCountFrequency (%)
~ 9
52.9%
> 8
47.1%
Space Separator
ValueCountFrequency (%)
3185
100.0%
Open Punctuation
ValueCountFrequency (%)
( 643
100.0%
Close Punctuation
ValueCountFrequency (%)
) 642
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 508
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 11711
52.1%
Common 10732
47.8%
Latin 14
 
0.1%
Han 6
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
1987
17.0%
883
 
7.5%
755
 
6.4%
675
 
5.8%
673
 
5.7%
668
 
5.7%
659
 
5.6%
621
 
5.3%
347
 
3.0%
339
 
2.9%
Other values (234) 4104
35.0%
Common
ValueCountFrequency (%)
3185
29.7%
1 1385
12.9%
( 643
 
6.0%
) 642
 
6.0%
2 641
 
6.0%
0 569
 
5.3%
- 508
 
4.7%
3 443
 
4.1%
5 443
 
4.1%
6 406
 
3.8%
Other values (10) 1867
17.4%
Latin
ValueCountFrequency (%)
m 8
57.1%
t 1
 
7.1%
L 1
 
7.1%
k 1
 
7.1%
D 1
 
7.1%
C 1
 
7.1%
S 1
 
7.1%
Han
ValueCountFrequency (%)
2
33.3%
2
33.3%
2
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 11711
52.1%
ASCII 10743
47.8%
CJK 6
 
< 0.1%
None 3
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3185
29.6%
1 1385
12.9%
( 643
 
6.0%
) 642
 
6.0%
2 641
 
6.0%
0 569
 
5.3%
- 508
 
4.7%
3 443
 
4.1%
5 443
 
4.1%
6 406
 
3.8%
Other values (16) 1878
17.5%
Hangul
ValueCountFrequency (%)
1987
17.0%
883
 
7.5%
755
 
6.4%
675
 
5.8%
673
 
5.7%
668
 
5.7%
659
 
5.6%
621
 
5.3%
347
 
3.0%
339
 
2.9%
Other values (234) 4104
35.0%
None
ValueCountFrequency (%)
· 3
100.0%
CJK
ValueCountFrequency (%)
2
33.3%
2
33.3%
2
33.3%

위도
Real number (ℝ)

HIGH CORRELATION 

Distinct608
Distinct (%)92.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35.176982
Minimum35.09782
Maximum35.230808
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.9 KiB
2023-12-12T23:42:04.052801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum35.09782
5-th percentile35.128585
Q135.155806
median35.179339
Q335.196226
95-th percentile35.219846
Maximum35.230808
Range0.1329871
Interquartile range (IQR)0.040420505

Descriptive statistics

Standard deviation0.028132802
Coefficient of variation (CV)0.00079975028
Kurtosis-0.73041257
Mean35.176982
Median Absolute Deviation (MAD)0.019589267
Skewness-0.26718351
Sum23181.631
Variance0.00079145453
MonotonicityNot monotonic
2023-12-12T23:42:04.235592image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
35.2020414404678 3
 
0.5%
35.1285849814422 3
 
0.5%
35.1805262219253 3
 
0.5%
35.1913064197117 3
 
0.5%
35.2119430062134 3
 
0.5%
35.1936267084459 3
 
0.5%
35.1906989157313 2
 
0.3%
35.2166670847609 2
 
0.3%
35.1745095663372 2
 
0.3%
35.1707212276469 2
 
0.3%
Other values (598) 633
96.1%
ValueCountFrequency (%)
35.0978204725317 1
0.2%
35.097995548563 1
0.2%
35.1126153997634 1
0.2%
35.1128712577717 1
0.2%
35.1136538647861 1
0.2%
35.1201638904424 1
0.2%
35.120174473457 1
0.2%
35.120177251281 1
0.2%
35.1201795732614 1
0.2%
35.1206917768525 1
0.2%
ValueCountFrequency (%)
35.2308075752001 1
0.2%
35.2278560593543 1
0.2%
35.2239943414096 1
0.2%
35.2234474387527 1
0.2%
35.2229436147483 1
0.2%
35.2228545641556 1
0.2%
35.2223889161913 1
0.2%
35.2220676896465 1
0.2%
35.2216196615523 1
0.2%
35.2215938176562 1
0.2%

경도
Real number (ℝ)

HIGH CORRELATION 

Distinct608
Distinct (%)92.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.81248
Minimum126.67251
Maximum126.91349
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.9 KiB
2023-12-12T23:42:04.411663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.67251
5-th percentile126.77414
Q1126.79827
median126.81105
Q3126.83087
95-th percentile126.84763
Maximum126.91349
Range0.24098054
Interquartile range (IQR)0.032603382

Descriptive statistics

Standard deviation0.024005515
Coefficient of variation (CV)0.00018929932
Kurtosis3.6488961
Mean126.81248
Median Absolute Deviation (MAD)0.015758343
Skewness-0.63539765
Sum83569.422
Variance0.00057626475
MonotonicityNot monotonic
2023-12-12T23:42:04.580713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
126.815701098364 3
 
0.5%
126.790778782757 3
 
0.5%
126.82001470295 3
 
0.5%
126.828525404885 3
 
0.5%
126.841658519087 3
 
0.5%
126.833517194893 3
 
0.5%
126.809015289957 2
 
0.3%
126.842773600118 2
 
0.3%
126.809396979099 2
 
0.3%
126.809952043127 2
 
0.3%
Other values (598) 633
96.1%
ValueCountFrequency (%)
126.672510114223 1
0.2%
126.674740874164 1
0.2%
126.702557896809 1
0.2%
126.742622245577 1
0.2%
126.744995804999 1
0.2%
126.754969019382 1
0.2%
126.755860644503 1
0.2%
126.756614496799 1
0.2%
126.760603482609 1
0.2%
126.760613396403 1
0.2%
ValueCountFrequency (%)
126.913490656644 1
0.2%
126.899534626245 1
0.2%
126.874091231715 1
0.2%
126.863214691953 1
0.2%
126.859782099275 1
0.2%
126.85257862826 1
0.2%
126.85239146838 1
0.2%
126.851917253723 1
0.2%
126.851796487632 1
0.2%
126.851272951941 1
0.2%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size5.3 KiB
Minimum2023-05-08 00:00:00
Maximum2023-05-08 00:00:00
2023-12-12T23:42:04.700646image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:42:04.804598image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T23:42:01.014156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:42:00.316211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:42:00.656588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:42:01.128732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:42:00.421523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:42:00.779284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:42:01.244932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:42:00.554738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:42:00.902065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:42:04.894083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번위도경도
연번1.0000.8430.672
위도0.8431.0000.782
경도0.6720.7821.000
2023-12-12T23:42:04.992743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번위도경도
연번1.000-0.402-0.245
위도-0.4021.0000.757
경도-0.2450.7571.000

Missing values

2023-12-12T23:42:01.381931image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:42:01.502322image/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하남공단종합상사광주광역시 광산구 하남산단4번로 172 (장덕동 992-11)35.190699126.8090152023-05-08
12알리바이(24시편의점)광주광역시 광산구 왕버들로 11, 가동 101호 (장덕동 505-86)35.202587126.8119262023-05-08
23주)에스엠마트남동광주광역시 광산구 장덕로95번길 46 (장덕동 1102, 수완자이아파트 정문)35.197635126.8198532023-05-08
34씨유하남8번로점광주광역시 광산구 하남산단천변우로 28, 1층 (도천동 622-2)35.208658126.8134572023-05-08
45미니스톱하남도천점광주광역시 광산구 하남산단8번로 169 기업은행 옆35.209141126.8142292023-05-08
56에이젯시스템광주광역시 광산구 사암로 860-10 (도천동 32-12)35.216299126.8247542023-05-08
67S마트광주광역시 광산구 비아중앙로 24 (비아동 66-23)35.221041126.8249852023-05-08
78지에스25 비아일신점광주광역시 광산구 비아중앙로 29-1 (비아동 89-20)35.22162126.8246142023-05-08
89비아농협광주광역시 광산구 비아중앙로 36 (비아동 86-1)35.222068126.8250272023-05-08
910미니스톱광주광역시 광산구 비아로12번길 10 비아119센터 앞 (비아동 707-1)35.220762126.8236132023-05-08
연번사업장명주소위도경도데이터기준일자
649650세븐일레븐 광주수완미래점광주광역시 광산구 장신로 175, 1층(수완동)35.190862126.8294062023-05-08
650651성오종합유통광주광역시 광산구 내상로 53(송정동)35.137701126.7982652023-05-08
651652임페리아푸드광주광역시 광산구 산정공원로 6, 1층(월곡동)35.169243126.8083752023-05-08
652653㈜디제이코퍼레이션광주광역시 광산구 산정공원로81번길 30-20, 1층(산정동)35.17576126.8051122023-05-08
653654세븐일레븐 광주산정대덕점광주광역시 광산구 산정공원로81번길 36, 1층(산정동)35.175099126.8044982023-05-08
654655세계로정육할인마트광주광역시 광산구 비아동원촌길 83, 103호(비아동)35.221591126.829042023-05-08
655656이마트24 광주돈보스코점광주광역시 광산구 고봉로 130(하남동)35.184693126.7940342023-05-08
656657지에스25 하남우체국점광주광역시 광산구 하남산단4번로 172, 1층(장덕동)35.190699126.8090152023-05-08
657658세븐일레븐 광주평동역점광주광역시 광산구 평동산단로 192, 1층(월전동)35.123978126.7685282023-05-08
658659씨유 하남3지구점광주광역시 광산구 고봉로 96, 1층(하남동)35.183445126.7971832023-05-08