Overview

Dataset statistics

Number of variables5
Number of observations42
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.9 KiB
Average record size in memory45.1 B

Variable types

Text3
Numeric2

Dataset

Description전북특별자치도 김제시 약국정보입니다.김제시의 약국명, 주소, 전화번호, 경도, 위도 정보를 포함하고 있습니다.
Author전북특별자치도 김제시
URLhttps://www.data.go.kr/data/3068573/fileData.do

Alerts

약국명 has unique valuesUnique
주소 has unique valuesUnique
전화번호 has unique valuesUnique
위도 has unique valuesUnique

Reproduction

Analysis started2024-03-23 06:13:34.591900
Analysis finished2024-03-23 06:13:37.193269
Duration2.6 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

약국명
Text

UNIQUE 

Distinct42
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size468.0 B
2024-03-23T06:13:37.617517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length4
Mean length4.6666667
Min length3

Characters and Unicode

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

Unique

Unique42 ?
Unique (%)100.0%

Sample

1st row민생약국
2nd row온약국
3rd row아람약국
4th row온빛약국
5th row보신약국
ValueCountFrequency (%)
민생약국 1
 
2.4%
건강제일약국 1
 
2.4%
김제백제약국 1
 
2.4%
21세기박약국 1
 
2.4%
건강한약국 1
 
2.4%
중앙종로약국 1
 
2.4%
좋은약국 1
 
2.4%
녹십자약국 1
 
2.4%
우리약국 1
 
2.4%
밝은약국 1
 
2.4%
Other values (32) 32
76.2%
2024-03-23T06:13:38.941008image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
약 42
21.4%
국 42
21.4%
종 5
 
2.6%
은 4
 
2.0%
제 4
 
2.0%
건 4
 
2.0%
강 4
 
2.0%
신 3
 
1.5%
나 3
 
1.5%
세 3
 
1.5%
Other values (62) 82
41.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 191
97.4%
Decimal Number 5
 
2.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
약 42
22.0%
국 42
22.0%
종 5
 
2.6%
은 4
 
2.1%
제 4
 
2.1%
건 4
 
2.1%
강 4
 
2.1%
신 3
 
1.6%
나 3
 
1.6%
세 3
 
1.6%
Other values (59) 77
40.3%
Decimal Number
ValueCountFrequency (%)
0 2
40.0%
1 2
40.0%
2 1
20.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 191
97.4%
Common 5
 
2.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
약 42
22.0%
국 42
22.0%
종 5
 
2.6%
은 4
 
2.1%
제 4
 
2.1%
건 4
 
2.1%
강 4
 
2.1%
신 3
 
1.6%
나 3
 
1.6%
세 3
 
1.6%
Other values (59) 77
40.3%
Common
ValueCountFrequency (%)
0 2
40.0%
1 2
40.0%
2 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 191
97.4%
ASCII 5
 
2.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
약 42
22.0%
국 42
22.0%
종 5
 
2.6%
은 4
 
2.1%
제 4
 
2.1%
건 4
 
2.1%
강 4
 
2.1%
신 3
 
1.6%
나 3
 
1.6%
세 3
 
1.6%
Other values (59) 77
40.3%
ASCII
ValueCountFrequency (%)
0 2
40.0%
1 2
40.0%
2 1
20.0%

주소
Text

UNIQUE 

Distinct42
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size468.0 B
2024-03-23T06:13:39.750614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length25
Mean length24.952381
Min length22

Characters and Unicode

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

Unique42 ?
Unique (%)100.0%

Sample

1st row전북특별자치도 김제시 백구면 유강로 602-4
2nd row전북특별자치도 김제시 동서로 250(요촌동)
3rd row전북특별자치도 김제시 검산택지길 62, 1층 (검산동)
4th row전북특별자치도 김제시 금성로 126 (검산동)
5th row전북특별자치도 김제시 금성로 90 (신풍동)
ValueCountFrequency (%)
전북특별자치도 42
19.7%
김제시 42
19.7%
요촌동 25
 
11.7%
남북로 10
 
4.7%
동서로 9
 
4.2%
검산동 5
 
2.3%
중앙로 3
 
1.4%
금성로 3
 
1.4%
신풍동 2
 
0.9%
금산면 2
 
0.9%
Other values (62) 70
32.9%
2024-03-23T06:13:41.001770image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
171
 
16.3%
북 52
 
5.0%
동 48
 
4.6%
도 44
 
4.2%
전 42
 
4.0%
시 42
 
4.0%
김 42
 
4.0%
제 42
 
4.0%
치 42
 
4.0%
자 42
 
4.0%
Other values (54) 481
45.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 680
64.9%
Space Separator 171
 
16.3%
Decimal Number 122
 
11.6%
Close Punctuation 35
 
3.3%
Open Punctuation 35
 
3.3%
Other Punctuation 3
 
0.3%
Dash Punctuation 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
북 52
 
7.6%
동 48
 
7.1%
도 44
 
6.5%
전 42
 
6.2%
시 42
 
6.2%
김 42
 
6.2%
제 42
 
6.2%
치 42
 
6.2%
자 42
 
6.2%
별 42
 
6.2%
Other values (39) 242
35.6%
Decimal Number
ValueCountFrequency (%)
1 27
22.1%
2 26
21.3%
5 14
11.5%
4 12
9.8%
3 10
 
8.2%
0 10
 
8.2%
6 10
 
8.2%
9 7
 
5.7%
7 4
 
3.3%
8 2
 
1.6%
Space Separator
ValueCountFrequency (%)
171
100.0%
Close Punctuation
ValueCountFrequency (%)
) 35
100.0%
Open Punctuation
ValueCountFrequency (%)
( 35
100.0%
Other Punctuation
ValueCountFrequency (%)
, 3
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 680
64.9%
Common 368
35.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
북 52
 
7.6%
동 48
 
7.1%
도 44
 
6.5%
전 42
 
6.2%
시 42
 
6.2%
김 42
 
6.2%
제 42
 
6.2%
치 42
 
6.2%
자 42
 
6.2%
별 42
 
6.2%
Other values (39) 242
35.6%
Common
ValueCountFrequency (%)
171
46.5%
) 35
 
9.5%
( 35
 
9.5%
1 27
 
7.3%
2 26
 
7.1%
5 14
 
3.8%
4 12
 
3.3%
3 10
 
2.7%
0 10
 
2.7%
6 10
 
2.7%
Other values (5) 18
 
4.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 680
64.9%
ASCII 368
35.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
171
46.5%
) 35
 
9.5%
( 35
 
9.5%
1 27
 
7.3%
2 26
 
7.1%
5 14
 
3.8%
4 12
 
3.3%
3 10
 
2.7%
0 10
 
2.7%
6 10
 
2.7%
Other values (5) 18
 
4.9%
Hangul
ValueCountFrequency (%)
북 52
 
7.6%
동 48
 
7.1%
도 44
 
6.5%
전 42
 
6.2%
시 42
 
6.2%
김 42
 
6.2%
제 42
 
6.2%
치 42
 
6.2%
자 42
 
6.2%
별 42
 
6.2%
Other values (39) 242
35.6%

전화번호
Text

UNIQUE 

Distinct42
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size468.0 B
2024-03-23T06:13:41.633165image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.071429
Min length12

Characters and Unicode

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

Unique42 ?
Unique (%)100.0%

Sample

1st row063-543-0100
2nd row070-7377-6525
3rd row063-545-3200
4th row063-546-1905
5th row063-544-8100
ValueCountFrequency (%)
063-543-0100 1
 
2.4%
063-548-8585 1
 
2.4%
070-8875-5808 1
 
2.4%
063-547-2386 1
 
2.4%
063-543-7571 1
 
2.4%
063-548-2072 1
 
2.4%
063-545-0129 1
 
2.4%
063-545-7275 1
 
2.4%
063-545-7582 1
 
2.4%
063-547-9272 1
 
2.4%
Other values (32) 32
76.2%
2024-03-23T06:13:42.699700image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 84
16.6%
0 73
14.4%
5 70
13.8%
3 62
12.2%
6 53
10.5%
4 53
10.5%
7 34
6.7%
8 28
 
5.5%
2 22
 
4.3%
1 20
 
3.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 423
83.4%
Dash Punctuation 84
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 73
17.3%
5 70
16.5%
3 62
14.7%
6 53
12.5%
4 53
12.5%
7 34
8.0%
8 28
 
6.6%
2 22
 
5.2%
1 20
 
4.7%
9 8
 
1.9%
Dash Punctuation
ValueCountFrequency (%)
- 84
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 507
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 84
16.6%
0 73
14.4%
5 70
13.8%
3 62
12.2%
6 53
10.5%
4 53
10.5%
7 34
6.7%
8 28
 
5.5%
2 22
 
4.3%
1 20
 
3.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 507
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 84
16.6%
0 73
14.4%
5 70
13.8%
3 62
12.2%
6 53
10.5%
4 53
10.5%
7 34
6.7%
8 28
 
5.5%
2 22
 
4.3%
1 20
 
3.9%

위도
Real number (ℝ)

UNIQUE 

Distinct42
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35.802335
Minimum35.714042
Maximum35.907504
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size510.0 B
2024-03-23T06:13:43.207044image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum35.714042
5-th percentile35.77686
Q135.799163
median35.802773
Q335.804451
95-th percentile35.850776
Maximum35.907504
Range0.193462
Interquartile range (IQR)0.00528825

Descriptive statistics

Standard deviation0.02834273
Coefficient of variation (CV)0.00079164474
Kurtosis8.0091399
Mean35.802335
Median Absolute Deviation (MAD)0.0023285
Skewness0.031238954
Sum1503.698
Variance0.00080331034
MonotonicityNot monotonic
2024-03-23T06:13:43.815592image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=42)
ValueCountFrequency (%)
35.907504 1
 
2.4%
35.852512 1
 
2.4%
35.804555 1
 
2.4%
35.805372 1
 
2.4%
35.71415 1
 
2.4%
35.804172 1
 
2.4%
35.803196 1
 
2.4%
35.817787 1
 
2.4%
35.798893 1
 
2.4%
35.799312 1
 
2.4%
Other values (32) 32
76.2%
ValueCountFrequency (%)
35.714042 1
2.4%
35.71415 1
2.4%
35.776021 1
2.4%
35.792806 1
2.4%
35.797663 1
2.4%
35.797838 1
2.4%
35.798027 1
2.4%
35.798417 1
2.4%
35.798797 1
2.4%
35.798893 1
2.4%
ValueCountFrequency (%)
35.907504 1
2.4%
35.852728 1
2.4%
35.852512 1
2.4%
35.817787 1
2.4%
35.806598 1
2.4%
35.805372 1
2.4%
35.804927 1
2.4%
35.804605 1
2.4%
35.80458 1
2.4%
35.804555 1
2.4%

경도
Real number (ℝ)

Distinct41
Distinct (%)97.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.89758
Minimum126.8162
Maximum127.01153
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size510.0 B
2024-03-23T06:13:45.016226image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.8162
5-th percentile126.88055
Q1126.88396
median126.88626
Q3126.89994
95-th percentile126.99307
Maximum127.01153
Range0.195324
Interquartile range (IQR)0.01597275

Descriptive statistics

Standard deviation0.038176898
Coefficient of variation (CV)0.00030084813
Kurtosis3.7152206
Mean126.89758
Median Absolute Deviation (MAD)0.0049
Skewness1.4378521
Sum5329.6982
Variance0.0014574755
MonotonicityNot monotonic
2024-03-23T06:13:45.540084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=41)
ValueCountFrequency (%)
126.884982 2
 
4.8%
126.934235 1
 
2.4%
126.993089 1
 
2.4%
126.88221 1
 
2.4%
126.992688 1
 
2.4%
126.883919 1
 
2.4%
126.894108 1
 
2.4%
126.997293 1
 
2.4%
126.886408 1
 
2.4%
126.886428 1
 
2.4%
Other values (31) 31
73.8%
ValueCountFrequency (%)
126.816203 1
2.4%
126.816233 1
2.4%
126.880461 1
2.4%
126.88221 1
2.4%
126.883205 1
2.4%
126.883492 1
2.4%
126.88362 1
2.4%
126.883778 1
2.4%
126.883882 1
2.4%
126.883919 1
2.4%
ValueCountFrequency (%)
127.011527 1
2.4%
126.997293 1
2.4%
126.993089 1
2.4%
126.992688 1
2.4%
126.934235 1
2.4%
126.904365 1
2.4%
126.903686 1
2.4%
126.902484 1
2.4%
126.902012 1
2.4%
126.901664 1
2.4%

Interactions

2024-03-23T06:13:35.853868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:13:35.210425image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:13:36.273457image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T06:13:35.479214image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-23T06:13:45.827720image/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.902
경도1.0001.0001.0000.9021.000
2024-03-23T06:13:46.102031image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.000-0.377
경도-0.3771.000

Missing values

2024-03-23T06:13:36.709971image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-23T06:13:37.091233image/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민생약국전북특별자치도 김제시 백구면 유강로 602-4063-543-010035.907504126.934235
1온약국전북특별자치도 김제시 동서로 250(요촌동)070-7377-652535.803355126.894601
2아람약국전북특별자치도 김제시 검산택지길 62, 1층 (검산동)063-545-320035.801986126.904365
3온빛약국전북특별자치도 김제시 금성로 126 (검산동)063-546-190535.800584126.903686
4보신약국전북특별자치도 김제시 금성로 90 (신풍동)063-544-810035.799132126.900034
5큰사랑약국전북특별자치도 김제시 금성로 115 (검산동)063-547-222135.800304126.902484
6지평선종합약국전북특별자치도 김제시 남북로 152 (요촌동)063-544-000835.798417126.886196
7새종로약국전북특별자치도 김제시 중앙로 92 (요촌동)063-545-731135.804467126.885857
8솔약국전북특별자치도 김제시 남북로 196 (요촌동)063-544-334635.801457126.884982
9선일약국전북특별자치도 김제시 중앙로 96 (요촌동)063-545-898435.804311126.886316
약국명주소전화번호위도경도
32종근당약국전북특별자치도 김제시 만경읍 만경로 811063-542-578735.852512126.816233
33가정약국전북특별자치도 김제시 금산면 원평4길 3063-543-098935.714042126.993089
34뉴시장약국전북특별자치도 김제시 남북로 223 (요촌동)063-546-653335.803877126.883976
35현대약국전북특별자치도 김제시 동서3길 5 (옥산동)063-545-330735.797838126.883205
36건강종합약국전북특별자치도 김제시 남북로 224 (요촌동)063-547-207335.803919126.884319
37부영약국전북특별자치도 김제시 동서로 260, 1동 101호 (요촌동)063-547-203135.803749126.895525
38혜인당약국전북특별자치도 김제시 금구면 봉두로 91, 102호063-547-510535.776021127.011527
39김제세계로약국전북특별자치도 김제시 동서로 259 (요촌동)063-547-449035.804216126.895291
40김제백제약국전북특별자치도 김제시 동서로 135 (요촌동)070-8875-580835.798027126.883882
41신화약국전북특별자치도 김제시 두월2길 6 (신풍동)063-547-266535.792806126.901664