Overview

Dataset statistics

Number of variables6
Number of observations36
Missing cells1
Missing cells (%)0.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.9 KiB
Average record size in memory53.7 B

Variable types

Text3
Numeric2
Categorical1

Dataset

Description인천광역시 동구에 위치한 약국에 대해 약국명, 연락처, 주소, 경도, 위도, 데이터 기준일자에 대한 데이터를 제공합니다.
Author인천광역시 동구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15051492&srcSe=7661IVAWM27C61E190

Alerts

데이터기준일자 has constant value ""Constant
전화번호 has 1 (2.8%) missing valuesMissing
약국명 has unique valuesUnique
소재지도로명주소 has unique valuesUnique
위도 has unique valuesUnique
경도 has unique valuesUnique

Reproduction

Analysis started2024-03-18 03:20:25.921540
Analysis finished2024-03-18 03:20:28.141098
Duration2.22 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

약국명
Text

UNIQUE 

Distinct36
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size420.0 B
2024-03-18T12:20:28.316493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length4
Mean length4.3611111
Min length3

Characters and Unicode

Total characters157
Distinct characters66
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique36 ?
Unique (%)100.0%

Sample

1st row가연약국
2nd row동구약국
3rd row정성약국
4th row이화당약국
5th row청십자약국
ValueCountFrequency (%)
가연약국 1
 
2.8%
동구약국 1
 
2.8%
한솔약국 1
 
2.8%
송현메디칼약국 1
 
2.8%
대한약국 1
 
2.8%
오메가약국 1
 
2.8%
다사랑약국 1
 
2.8%
인혜약국 1
 
2.8%
우리들약국 1
 
2.8%
정정안약국 1
 
2.8%
Other values (26) 26
72.2%
2024-03-18T12:20:28.687474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
36
22.9%
36
22.9%
4
 
2.5%
3
 
1.9%
3
 
1.9%
3
 
1.9%
2
 
1.3%
2
 
1.3%
2
 
1.3%
2
 
1.3%
Other values (56) 64
40.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 157
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
36
22.9%
36
22.9%
4
 
2.5%
3
 
1.9%
3
 
1.9%
3
 
1.9%
2
 
1.3%
2
 
1.3%
2
 
1.3%
2
 
1.3%
Other values (56) 64
40.8%

Most occurring scripts

ValueCountFrequency (%)
Hangul 157
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
36
22.9%
36
22.9%
4
 
2.5%
3
 
1.9%
3
 
1.9%
3
 
1.9%
2
 
1.3%
2
 
1.3%
2
 
1.3%
2
 
1.3%
Other values (56) 64
40.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 157
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
36
22.9%
36
22.9%
4
 
2.5%
3
 
1.9%
3
 
1.9%
3
 
1.9%
2
 
1.3%
2
 
1.3%
2
 
1.3%
2
 
1.3%
Other values (56) 64
40.8%
Distinct36
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size420.0 B
2024-03-18T12:20:28.895940image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length46
Median length38
Mean length27.722222
Min length21

Characters and Unicode

Total characters998
Distinct characters85
Distinct categories7 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique36 ?
Unique (%)100.0%

Sample

1st row인천광역시 동구 송림로 73-1, 1층 104호(송림동)
2nd row인천광역시 동구 송림로 80, 송림센트럴타워 1층 102호 (송림동)
3rd row인천광역시 동구 수문통로 7, 정성약국 (화평동)
4th row인천광역시 동구 방축로 191, 인천교자동차매매단지 1층 123,124호 (송림동)
5th row인천광역시 동구 송림로 102, 1층 (송림동)
ValueCountFrequency (%)
인천광역시 36
16.8%
동구 36
16.8%
송림동 17
 
7.9%
1층 16
 
7.5%
송림로 12
 
5.6%
송현동 8
 
3.7%
화도진로 5
 
2.3%
샛골로 4
 
1.9%
화도진로44번길 2
 
0.9%
금곡동 2
 
0.9%
Other values (65) 76
35.5%
2024-03-18T12:20:29.219654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
178
17.8%
75
 
7.5%
1 49
 
4.9%
46
 
4.6%
37
 
3.7%
37
 
3.7%
36
 
3.6%
( 36
 
3.6%
) 36
 
3.6%
36
 
3.6%
Other values (75) 432
43.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 579
58.0%
Space Separator 178
 
17.8%
Decimal Number 138
 
13.8%
Open Punctuation 36
 
3.6%
Close Punctuation 36
 
3.6%
Other Punctuation 28
 
2.8%
Dash Punctuation 3
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
75
13.0%
46
 
7.9%
37
 
6.4%
37
 
6.4%
36
 
6.2%
36
 
6.2%
36
 
6.2%
36
 
6.2%
36
 
6.2%
33
 
5.7%
Other values (60) 171
29.5%
Decimal Number
ValueCountFrequency (%)
1 49
35.5%
2 16
 
11.6%
3 13
 
9.4%
0 12
 
8.7%
4 12
 
8.7%
9 10
 
7.2%
7 10
 
7.2%
8 7
 
5.1%
6 5
 
3.6%
5 4
 
2.9%
Space Separator
ValueCountFrequency (%)
178
100.0%
Open Punctuation
ValueCountFrequency (%)
( 36
100.0%
Close Punctuation
ValueCountFrequency (%)
) 36
100.0%
Other Punctuation
ValueCountFrequency (%)
, 28
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 579
58.0%
Common 419
42.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
75
13.0%
46
 
7.9%
37
 
6.4%
37
 
6.4%
36
 
6.2%
36
 
6.2%
36
 
6.2%
36
 
6.2%
36
 
6.2%
33
 
5.7%
Other values (60) 171
29.5%
Common
ValueCountFrequency (%)
178
42.5%
1 49
 
11.7%
( 36
 
8.6%
) 36
 
8.6%
, 28
 
6.7%
2 16
 
3.8%
3 13
 
3.1%
0 12
 
2.9%
4 12
 
2.9%
9 10
 
2.4%
Other values (5) 29
 
6.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 579
58.0%
ASCII 419
42.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
178
42.5%
1 49
 
11.7%
( 36
 
8.6%
) 36
 
8.6%
, 28
 
6.7%
2 16
 
3.8%
3 13
 
3.1%
0 12
 
2.9%
4 12
 
2.9%
9 10
 
2.4%
Other values (5) 29
 
6.9%
Hangul
ValueCountFrequency (%)
75
13.0%
46
 
7.9%
37
 
6.4%
37
 
6.4%
36
 
6.2%
36
 
6.2%
36
 
6.2%
36
 
6.2%
36
 
6.2%
33
 
5.7%
Other values (60) 171
29.5%

전화번호
Text

MISSING 

Distinct35
Distinct (%)100.0%
Missing1
Missing (%)2.8%
Memory size420.0 B
2024-03-18T12:20:29.396330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.057143
Min length12

Characters and Unicode

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

Unique35 ?
Unique (%)100.0%

Sample

1st row070-4647-2777
2nd row032-762-4407
3rd row032-576-4200
4th row032-761-9686
5th row032-766-2879
ValueCountFrequency (%)
070-4647-2777 1
 
2.9%
032-777-3390 1
 
2.9%
032-764-7727 1
 
2.9%
032-762-2421 1
 
2.9%
032-574-7533 1
 
2.9%
032-761-3355 1
 
2.9%
032-773-8085 1
 
2.9%
032-763-5430 1
 
2.9%
032-772-4959 1
 
2.9%
032-762-3347 1
 
2.9%
Other values (25) 25
71.4%
2024-03-18T12:20:29.717280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 70
16.6%
7 67
15.9%
2 60
14.2%
3 59
14.0%
0 57
13.5%
6 34
8.1%
4 20
 
4.7%
8 15
 
3.6%
5 14
 
3.3%
1 13
 
3.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 352
83.4%
Dash Punctuation 70
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
7 67
19.0%
2 60
17.0%
3 59
16.8%
0 57
16.2%
6 34
9.7%
4 20
 
5.7%
8 15
 
4.3%
5 14
 
4.0%
1 13
 
3.7%
9 13
 
3.7%
Dash Punctuation
ValueCountFrequency (%)
- 70
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 422
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 70
16.6%
7 67
15.9%
2 60
14.2%
3 59
14.0%
0 57
13.5%
6 34
8.1%
4 20
 
4.7%
8 15
 
3.6%
5 14
 
3.3%
1 13
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 422
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 70
16.6%
7 67
15.9%
2 60
14.2%
3 59
14.0%
0 57
13.5%
6 34
8.1%
4 20
 
4.7%
8 15
 
3.6%
5 14
 
3.3%
1 13
 
3.1%

위도
Real number (ℝ)

UNIQUE 

Distinct36
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.477873
Minimum37.473004
Maximum37.484278
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size456.0 B
2024-03-18T12:20:29.846311image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.473004
5-th percentile37.47313
Q137.475707
median37.476487
Q337.480403
95-th percentile37.482983
Maximum37.484278
Range0.01127442
Interquartile range (IQR)0.004695755

Descriptive statistics

Standard deviation0.0031065923
Coefficient of variation (CV)8.2891372 × 10-5
Kurtosis-0.96173767
Mean37.477873
Median Absolute Deviation (MAD)0.00143768
Skewness0.40892145
Sum1349.2034
Variance9.6509156 × 10-6
MonotonicityNot monotonic
2024-03-18T12:20:29.948944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=36)
ValueCountFrequency (%)
37.4754996 1
 
2.8%
37.47632542 1
 
2.8%
37.47580446 1
 
2.8%
37.48305893 1
 
2.8%
37.48270773 1
 
2.8%
37.48427827 1
 
2.8%
37.48013272 1
 
2.8%
37.47498948 1
 
2.8%
37.47626517 1
 
2.8%
37.4763071 1
 
2.8%
Other values (26) 26
72.2%
ValueCountFrequency (%)
37.47300385 1
2.8%
37.47312342 1
2.8%
37.47313165 1
2.8%
37.47498948 1
2.8%
37.47510865 1
2.8%
37.47531301 1
2.8%
37.4754996 1
2.8%
37.47554577 1
2.8%
37.47557763 1
2.8%
37.47575073 1
2.8%
ValueCountFrequency (%)
37.48427827 1
2.8%
37.48305893 1
2.8%
37.4829583 1
2.8%
37.48270773 1
2.8%
37.48191406 1
2.8%
37.48152208 1
2.8%
37.48093143 1
2.8%
37.4807373 1
2.8%
37.4805767 1
2.8%
37.48034538 1
2.8%

경도
Real number (ℝ)

UNIQUE 

Distinct36
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.64035
Minimum126.61995
Maximum126.66512
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size456.0 B
2024-03-18T12:20:30.051267image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.61995
5-th percentile126.62732
Q1126.63397
median126.64312
Q3126.64536
95-th percentile126.65085
Maximum126.66512
Range0.0451714
Interquartile range (IQR)0.011389825

Descriptive statistics

Standard deviation0.009065685
Coefficient of variation (CV)7.1586073 × 10-5
Kurtosis0.96024929
Mean126.64035
Median Absolute Deviation (MAD)0.0043339
Skewness0.25847131
Sum4559.0525
Variance8.2186644 × 10-5
MonotonicityNot monotonic
2024-03-18T12:20:30.151993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=36)
ValueCountFrequency (%)
126.6429267 1
 
2.8%
126.645437 1
 
2.8%
126.6437879 1
 
2.8%
126.6603513 1
 
2.8%
126.6331161 1
 
2.8%
126.6199454 1
 
2.8%
126.645291 1
 
2.8%
126.6456691 1
 
2.8%
126.6449661 1
 
2.8%
126.634281 1
 
2.8%
Other values (26) 26
72.2%
ValueCountFrequency (%)
126.6199454 1
2.8%
126.6266166 1
2.8%
126.6275602 1
2.8%
126.6284054 1
2.8%
126.6284067 1
2.8%
126.6316687 1
2.8%
126.6331161 1
2.8%
126.633314 1
2.8%
126.6337237 1
2.8%
126.6340509 1
2.8%
ValueCountFrequency (%)
126.6651168 1
2.8%
126.6603513 1
2.8%
126.6476892 1
2.8%
126.647211 1
2.8%
126.6463481 1
2.8%
126.6460761 1
2.8%
126.6460294 1
2.8%
126.6456691 1
2.8%
126.645437 1
2.8%
126.6453329 1
2.8%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)2.8%
Missing0
Missing (%)0.0%
Memory size420.0 B
2023-06-26
36 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-06-26
2nd row2023-06-26
3rd row2023-06-26
4th row2023-06-26
5th row2023-06-26

Common Values

ValueCountFrequency (%)
2023-06-26 36
100.0%

Length

2024-03-18T12:20:30.253383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T12:20:30.350421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-06-26 36
100.0%

Interactions

2024-03-18T12:20:27.833502image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:20:27.607641image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:20:27.904651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:20:27.735507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-18T12:20:30.432198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
약국명소재지도로명주소전화번호위도경도
약국명1.0001.0001.0001.0001.000
소재지도로명주소1.0001.0001.0001.0001.000
전화번호1.0001.0001.0001.0001.000
위도1.0001.0001.0001.0000.865
경도1.0001.0001.0000.8651.000
2024-03-18T12:20:30.544992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.000-0.253
경도-0.2531.000

Missing values

2024-03-18T12:20:27.996988image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-18T12:20:28.098634image/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

약국명소재지도로명주소전화번호위도경도데이터기준일자
0가연약국인천광역시 동구 송림로 73-1, 1층 104호(송림동)<NA>37.4755126.6429272023-06-26
1동구약국인천광역시 동구 송림로 80, 송림센트럴타워 1층 102호 (송림동)070-4647-277737.475313126.6437472023-06-26
2정성약국인천광역시 동구 수문통로 7, 정성약국 (화평동)032-762-440737.477467126.6316692023-06-26
3이화당약국인천광역시 동구 방축로 191, 인천교자동차매매단지 1층 123,124호 (송림동)032-576-420037.479803126.6651172023-06-26
4청십자약국인천광역시 동구 송림로 102, 1층 (송림동)032-761-968637.475963126.6460292023-06-26
5인천약국인천광역시 동구 샛골로 212 (송림동)032-766-287937.481522126.6460762023-06-26
6종로모범약국인천광역시 동구 송현로 47 (송현동)032-773-784237.480126126.6366782023-06-26
7도원약국인천광역시 동구 송미로 7, 1층 (송림동)032-765-879537.480931126.6476892023-06-26
8한사랑약국인천광역시 동구 송림로 73-1, 1층 103호(송림동)032-766-261137.475578126.6429392023-06-26
9샘물약국인천광역시 동구 송화로44번길 13-1, 금학빌딩 1층 (송현동)032-867-022137.480345126.6337242023-06-26
약국명소재지도로명주소전화번호위도경도데이터기준일자
26한솔약국인천광역시 동구 동산로 86 (송림동)032-766-709037.474989126.6456692023-06-26
27정정안약국인천광역시 동구 송림로 91 (송림동)032-777-339037.476265126.6449662023-06-26
28나을약국인천광역시 동구 화도진로44번길 12, 1층 (송현동)032-763-289037.476307126.6342812023-06-26
29백제약국인천광역시 동구 화수로 38, 103호 (송현동, 동부프라자)032-764-574737.481914126.6350142023-06-26
30복지약국인천광역시 동구 금곡로 66 (금곡동)032-772-291037.473123126.6427132023-06-26
31한독약국인천광역시 동구 석수로 22 (화수동)032-772-828637.480261126.627562023-06-26
32인일약국인천광역시 동구 금곡로92번길 17 (송림동)032-763-247237.473132126.6463482023-06-26
33해동약국인천광역시 동구 화도진로44번길 24 (송현동)032-773-127037.47621126.6349072023-06-26
34튼튼약국인천광역시 동구 화도진로 109, 화도진그린빌 상가 2층(화수동)032-772-495937.480577126.6284052023-06-26
35동안생약국인천광역시 동구 화도진로 109, 103호(화수동, 화도진그린빌 상가)070-8870-916637.480737126.6284072023-06-26