Overview

Dataset statistics

Number of variables6
Number of observations37
Missing cells10
Missing cells (%)4.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.0 KiB
Average record size in memory54.6 B

Variable types

Numeric3
Text3

Dataset

Description인천광역시 미추홀구의 우유판매 대리점에 관한 데이터이며 상호명, 도로명주소, 전화번호, 죄표값 등의 항목을 제공하고 있습니다.
Author인천광역시 미추홀구
URLhttps://www.data.go.kr/data/15087021/fileData.do

Alerts

전화번호 has 10 (27.0%) missing valuesMissing
연번 has unique valuesUnique
상호명 has unique valuesUnique

Reproduction

Analysis started2023-12-11 22:56:37.002015
Analysis finished2023-12-11 22:56:38.562219
Duration1.56 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct37
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19
Minimum1
Maximum37
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size465.0 B
2023-12-12T07:56:38.631234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.8
Q110
median19
Q328
95-th percentile35.2
Maximum37
Range36
Interquartile range (IQR)18

Descriptive statistics

Standard deviation10.824355
Coefficient of variation (CV)0.56970291
Kurtosis-1.2
Mean19
Median Absolute Deviation (MAD)9
Skewness0
Sum703
Variance117.16667
MonotonicityStrictly increasing
2023-12-12T07:56:38.776134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=37)
ValueCountFrequency (%)
1 1
 
2.7%
29 1
 
2.7%
22 1
 
2.7%
23 1
 
2.7%
24 1
 
2.7%
25 1
 
2.7%
26 1
 
2.7%
27 1
 
2.7%
28 1
 
2.7%
30 1
 
2.7%
Other values (27) 27
73.0%
ValueCountFrequency (%)
1 1
2.7%
2 1
2.7%
3 1
2.7%
4 1
2.7%
5 1
2.7%
6 1
2.7%
7 1
2.7%
8 1
2.7%
9 1
2.7%
10 1
2.7%
ValueCountFrequency (%)
37 1
2.7%
36 1
2.7%
35 1
2.7%
34 1
2.7%
33 1
2.7%
32 1
2.7%
31 1
2.7%
30 1
2.7%
29 1
2.7%
28 1
2.7%

상호명
Text

UNIQUE 

Distinct37
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size428.0 B
2023-12-12T07:56:39.104138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length13
Mean length9.7297297
Min length3

Characters and Unicode

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

Unique

Unique37 ?
Unique (%)100.0%

Sample

1st row강성원우유 인천2대리점
2nd row연세우유인천주안대리점
3rd rowhy인하점
4th row건국유업 연수보급소
5th rowhy학익점
ValueCountFrequency (%)
서울우유 6
 
9.2%
매일유업 5
 
7.7%
남양유업 4
 
6.2%
정식품 3
 
4.6%
대리점 2
 
3.1%
건국유업 2
 
3.1%
서울우유관교동고객센터 1
 
1.5%
인천특판ds대리점 1
 
1.5%
숭의동고객센터 1
 
1.5%
남인천대리점 1
 
1.5%
Other values (39) 39
60.0%
2023-12-12T07:56:39.537549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 29
 
8.1%
28
 
7.8%
유 25
 
6.9%
대 23
 
6.4%
리 23
 
6.4%
우 15
 
4.2%
업 12
 
3.3%
남 10
 
2.8%
서 8
 
2.2%
울 8
 
2.2%
Other values (72) 179
49.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 319
88.6%
Space Separator 28
 
7.8%
Lowercase Letter 10
 
2.8%
Uppercase Letter 2
 
0.6%
Decimal Number 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 29
 
9.1%
유 25
 
7.8%
대 23
 
7.2%
리 23
 
7.2%
우 15
 
4.7%
업 12
 
3.8%
남 10
 
3.1%
서 8
 
2.5%
울 8
 
2.5%
구 7
 
2.2%
Other values (66) 159
49.8%
Lowercase Letter
ValueCountFrequency (%)
h 5
50.0%
y 5
50.0%
Uppercase Letter
ValueCountFrequency (%)
D 1
50.0%
S 1
50.0%
Space Separator
ValueCountFrequency (%)
28
100.0%
Decimal Number
ValueCountFrequency (%)
2 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 319
88.6%
Common 29
 
8.1%
Latin 12
 
3.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 29
 
9.1%
유 25
 
7.8%
대 23
 
7.2%
리 23
 
7.2%
우 15
 
4.7%
업 12
 
3.8%
남 10
 
3.1%
서 8
 
2.5%
울 8
 
2.5%
구 7
 
2.2%
Other values (66) 159
49.8%
Latin
ValueCountFrequency (%)
h 5
41.7%
y 5
41.7%
D 1
 
8.3%
S 1
 
8.3%
Common
ValueCountFrequency (%)
28
96.6%
2 1
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 319
88.6%
ASCII 41
 
11.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 29
 
9.1%
유 25
 
7.8%
대 23
 
7.2%
리 23
 
7.2%
우 15
 
4.7%
업 12
 
3.8%
남 10
 
3.1%
서 8
 
2.5%
울 8
 
2.5%
구 7
 
2.2%
Other values (66) 159
49.8%
ASCII
ValueCountFrequency (%)
28
68.3%
h 5
 
12.2%
y 5
 
12.2%
D 1
 
2.4%
S 1
 
2.4%
2 1
 
2.4%

도로명주소
Text

Distinct36
Distinct (%)97.3%
Missing0
Missing (%)0.0%
Memory size428.0 B
2023-12-12T07:56:39.852140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length32
Median length25
Mean length22.648649
Min length17

Characters and Unicode

Total characters838
Distinct characters64
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

Unique35 ?
Unique (%)94.6%

Sample

1st row인천광역시 미추홀구 인주대로354번길 12 강성원우유대리점
2nd row인천광역시 미추홀구 동주길 23
3rd row인천광역시 미추홀구 토금북로57번길 19
4th row인천광역시 미추홀구 경원대로640번길 25-32
5th row인천광역시 미추홀구 학익소로 6-8
ValueCountFrequency (%)
인천광역시 37
24.5%
미추홀구 37
24.5%
23 3
 
2.0%
35 2
 
1.3%
경인로42번길 2
 
1.3%
석정로282번길 2
 
1.3%
경원대로640번길 2
 
1.3%
경원대로716번길 2
 
1.3%
한나루로403번길 2
 
1.3%
116-1 2
 
1.3%
Other values (60) 60
39.7%
2023-12-12T07:56:40.373709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
114
 
13.6%
인 47
 
5.6%
미 38
 
4.5%
추 38
 
4.5%
홀 38
 
4.5%
길 38
 
4.5%
광 37
 
4.4%
역 37
 
4.4%
시 37
 
4.4%
구 37
 
4.4%
Other values (54) 377
45.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 546
65.2%
Decimal Number 168
 
20.0%
Space Separator 114
 
13.6%
Dash Punctuation 10
 
1.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
인 47
 
8.6%
미 38
 
7.0%
추 38
 
7.0%
홀 38
 
7.0%
길 38
 
7.0%
광 37
 
6.8%
역 37
 
6.8%
시 37
 
6.8%
구 37
 
6.8%
천 37
 
6.8%
Other values (42) 162
29.7%
Decimal Number
ValueCountFrequency (%)
2 29
17.3%
1 26
15.5%
4 21
12.5%
3 20
11.9%
6 19
11.3%
5 13
7.7%
7 13
7.7%
0 10
 
6.0%
9 9
 
5.4%
8 8
 
4.8%
Space Separator
ValueCountFrequency (%)
114
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 546
65.2%
Common 292
34.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
인 47
 
8.6%
미 38
 
7.0%
추 38
 
7.0%
홀 38
 
7.0%
길 38
 
7.0%
광 37
 
6.8%
역 37
 
6.8%
시 37
 
6.8%
구 37
 
6.8%
천 37
 
6.8%
Other values (42) 162
29.7%
Common
ValueCountFrequency (%)
114
39.0%
2 29
 
9.9%
1 26
 
8.9%
4 21
 
7.2%
3 20
 
6.8%
6 19
 
6.5%
5 13
 
4.5%
7 13
 
4.5%
- 10
 
3.4%
0 10
 
3.4%
Other values (2) 17
 
5.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 546
65.2%
ASCII 292
34.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
114
39.0%
2 29
 
9.9%
1 26
 
8.9%
4 21
 
7.2%
3 20
 
6.8%
6 19
 
6.5%
5 13
 
4.5%
7 13
 
4.5%
- 10
 
3.4%
0 10
 
3.4%
Other values (2) 17
 
5.8%
Hangul
ValueCountFrequency (%)
인 47
 
8.6%
미 38
 
7.0%
추 38
 
7.0%
홀 38
 
7.0%
길 38
 
7.0%
광 37
 
6.8%
역 37
 
6.8%
시 37
 
6.8%
구 37
 
6.8%
천 37
 
6.8%
Other values (42) 162
29.7%

전화번호
Text

MISSING 

Distinct27
Distinct (%)100.0%
Missing10
Missing (%)27.0%
Memory size428.0 B
2023-12-12T07:56:40.581107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.037037
Min length12

Characters and Unicode

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

Unique27 ?
Unique (%)100.0%

Sample

1st row032-817-8588
2nd row032-433-8864
3rd row032-885-6123
4th row032-425-0211
5th row032-868-7220
ValueCountFrequency (%)
032-817-8588 1
 
3.7%
032-425-2223 1
 
3.7%
032-435-2689 1
 
3.7%
032-422-4215 1
 
3.7%
032-815-9545 1
 
3.7%
032-862-0281 1
 
3.7%
032-874-3166 1
 
3.7%
032-867-0510 1
 
3.7%
032-832-5880 1
 
3.7%
032-432-4537 1
 
3.7%
Other values (17) 17
63.0%
2023-12-12T07:56:40.936810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 54
16.6%
2 52
16.0%
3 44
13.5%
0 41
12.6%
8 36
11.1%
4 24
7.4%
5 21
 
6.5%
6 18
 
5.5%
1 14
 
4.3%
9 11
 
3.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 271
83.4%
Dash Punctuation 54
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 52
19.2%
3 44
16.2%
0 41
15.1%
8 36
13.3%
4 24
8.9%
5 21
7.7%
6 18
 
6.6%
1 14
 
5.2%
9 11
 
4.1%
7 10
 
3.7%
Dash Punctuation
ValueCountFrequency (%)
- 54
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 325
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 54
16.6%
2 52
16.0%
3 44
13.5%
0 41
12.6%
8 36
11.1%
4 24
7.4%
5 21
 
6.5%
6 18
 
5.5%
1 14
 
4.3%
9 11
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 325
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 54
16.6%
2 52
16.0%
3 44
13.5%
0 41
12.6%
8 36
11.1%
4 24
7.4%
5 21
 
6.5%
6 18
 
5.5%
1 14
 
4.3%
9 11
 
3.4%

위도
Real number (ℝ)

Distinct36
Distinct (%)97.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.45487
Minimum37.441352
Maximum37.469671
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size465.0 B
2023-12-12T07:56:41.068341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.441352
5-th percentile37.444216
Q137.446828
median37.452347
Q337.463658
95-th percentile37.468706
Maximum37.469671
Range0.02831899
Interquartile range (IQR)0.01682997

Descriptive statistics

Standard deviation0.0086095124
Coefficient of variation (CV)0.00022986363
Kurtosis-1.1898234
Mean37.45487
Median Absolute Deviation (MAD)0.00644073
Skewness0.33099386
Sum1385.8302
Variance7.4123704 × 10-5
MonotonicityNot monotonic
2023-12-12T07:56:41.218588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=36)
ValueCountFrequency (%)
37.44577457 2
 
5.4%
37.45091047 1
 
2.7%
37.46374092 1
 
2.7%
37.45197717 1
 
2.7%
37.46904729 1
 
2.7%
37.46392707 1
 
2.7%
37.44661288 1
 
2.7%
37.46862119 1
 
2.7%
37.45038687 1
 
2.7%
37.44682783 1
 
2.7%
Other values (26) 26
70.3%
ValueCountFrequency (%)
37.44135216 1
2.7%
37.44181494 1
2.7%
37.44481629 1
2.7%
37.44577457 2
5.4%
37.44590653 1
2.7%
37.44597999 1
2.7%
37.44607325 1
2.7%
37.44661288 1
2.7%
37.44682783 1
2.7%
37.44908978 1
2.7%
ValueCountFrequency (%)
37.46967115 1
2.7%
37.46904729 1
2.7%
37.46862119 1
2.7%
37.46753401 1
2.7%
37.46741742 1
2.7%
37.46657462 1
2.7%
37.46599071 1
2.7%
37.46392707 1
2.7%
37.46374092 1
2.7%
37.4636578 1
2.7%

경도
Real number (ℝ)

Distinct36
Distinct (%)97.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.66982
Minimum126.63258
Maximum126.6948
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size465.0 B
2023-12-12T07:56:41.348172image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.63258
5-th percentile126.64487
Q1126.65881
median126.66718
Q3126.68405
95-th percentile126.69357
Maximum126.6948
Range0.0622208
Interquartile range (IQR)0.025243

Descriptive statistics

Standard deviation0.016317234
Coefficient of variation (CV)0.00012881707
Kurtosis-0.63405891
Mean126.66982
Median Absolute Deviation (MAD)0.0110024
Skewness-0.16700316
Sum4686.7832
Variance0.00026625213
MonotonicityNot monotonic
2023-12-12T07:56:41.526512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=36)
ValueCountFrequency (%)
126.6588057 2
 
5.4%
126.6757204 1
 
2.7%
126.6576081 1
 
2.7%
126.6325828 1
 
2.7%
126.6781808 1
 
2.7%
126.6476474 1
 
2.7%
126.6904572 1
 
2.7%
126.6755419 1
 
2.7%
126.6681832 1
 
2.7%
126.6606457 1
 
2.7%
Other values (26) 26
70.3%
ValueCountFrequency (%)
126.6325828 1
2.7%
126.6406502 1
2.7%
126.6459202 1
2.7%
126.6476474 1
2.7%
126.649316 1
2.7%
126.653168 1
2.7%
126.6576081 1
2.7%
126.6579601 1
2.7%
126.6588057 2
5.4%
126.6593997 1
2.7%
ValueCountFrequency (%)
126.6948036 1
2.7%
126.6940611 1
2.7%
126.6934413 1
2.7%
126.6926732 1
2.7%
126.6922379 1
2.7%
126.6904572 1
2.7%
126.6903822 1
2.7%
126.6848389 1
2.7%
126.6846272 1
2.7%
126.6840487 1
2.7%

Interactions

2023-12-12T07:56:37.835190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T07:56:37.297518image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T07:56:37.547595image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T07:56:38.163086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T07:56:37.382648image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T07:56:37.637621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T07:56:38.253014image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T07:56:37.466709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T07:56:37.732422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T07:56:41.611325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번상호명도로명주소전화번호위도경도
연번1.0001.0000.9391.0000.0000.000
상호명1.0001.0001.0001.0001.0001.000
도로명주소0.9391.0001.0001.0001.0001.000
전화번호1.0001.0001.0001.0001.0001.000
위도0.0001.0001.0001.0001.0000.595
경도0.0001.0001.0001.0000.5951.000
2023-12-12T07:56:41.712249image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번위도경도
연번1.0000.119-0.172
위도0.1191.000-0.351
경도-0.172-0.3511.000

Missing values

2023-12-12T07:56:38.370425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T07:56:38.499321image/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강성원우유 인천2대리점인천광역시 미추홀구 인주대로354번길 12 강성원우유대리점032-817-858837.45091126.67572
12연세우유인천주안대리점인천광역시 미추홀구 동주길 23032-433-886437.452347126.684627
23hy인하점인천광역시 미추홀구 토금북로57번길 19032-885-612337.453892126.64065
34건국유업 연수보급소인천광역시 미추홀구 경원대로640번길 25-32032-425-021137.441815126.694804
45hy학익점인천광역시 미추홀구 학익소로 6-8032-868-722037.446073126.667178
56연세우유 중구대리점인천광역시 미추홀구 석정로202번길 7032-885-389537.467417126.65796
67hy용현점인천광역시 미추홀구 독정이로9번길 29<NA>37.456946126.653168
78남양유업인천지점인천광역시 미추홀구 경인로 473032-431-611637.45915126.692238
89hy관교점인천광역시 미추홀구 인주대로496번길 35032-432-483937.449567126.692673
910썬듀구월대리점인천광역시 미추홀구 경원대로712번길 6-6032-424-292937.44598126.690382
연번상호명도로명주소전화번호위도경도
2728남양유업 학익대리점인천광역시 미추홀구 한나루로478번길 9-36<NA>37.450387126.668183
2829매일유업 동부 대리점인천광역시 미추홀구 한나루로411번길 82-39032-832-588037.446828126.660646
2930남양우유 남동남구대리점인천광역시 미추홀구 석정로279번길 30032-867-051037.469671126.667348
3031매일유업 중구동구가정배달대리점인천광역시 미추홀구 한나루로403번길 116-1032-874-316637.445775126.658806
3132정식품 주안대리점인천광역시 미추홀구 인주대로408번길 22032-862-028137.450164126.681598
3233매일유업 우주대리점인천광역시 미추홀구 석정로76번길 8032-815-954537.465991126.64592
3334서울우유석암고객센터인천광역시 미추홀구 주안중로16번길 23032-422-421537.4598126.684049
3435정식품 용현대리점인천광역시 미추홀구 재넘이길19번길 35032-889-478637.445907126.665282
3536서울우유 학익동고객센터인천광역시 미추홀구 인하로163번길 60<NA>37.451711126.66675
3637정식품 송림대리점인천광역시 미추홀구 석정로282번길 13-12<NA>37.467534126.667112