Overview

Dataset statistics

Number of variables7
Number of observations26
Missing cells16
Missing cells (%)8.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory61.1 B

Variable types

Categorical3
DateTime1
Text3

Dataset

Description동물용 의약품 판매업에 대한 데이터로 업종명, 신고일자, 업소명, 영업상태, 전화번호, 영업장 주소, 데이터기준일자 등에 항목으로 제공합니다.
Author서울특별시 송파구
URLhttps://www.data.go.kr/data/15090393/fileData.do

Alerts

업종명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
영업상태 is highly imbalanced (57.5%)Imbalance
전화번호 has 16 (61.5%) missing valuesMissing
신고일자 has unique valuesUnique
업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 19:13:09.921921
Analysis finished2023-12-12 19:13:10.455230
Duration0.53 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Memory size340.0 B
동물용의약품판매업
26 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row동물용의약품판매업
2nd row동물용의약품판매업
3rd row동물용의약품판매업
4th row동물용의약품판매업
5th row동물용의약품판매업

Common Values

ValueCountFrequency (%)
동물용의약품판매업 26
100.0%

Length

2023-12-13T04:13:10.541118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T04:13:10.662240image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동물용의약품판매업 26
100.0%

신고일자
Date

UNIQUE 

Distinct26
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size340.0 B
Minimum1996-01-15 00:00:00
Maximum2020-01-09 00:00:00
2023-12-13T04:13:10.779325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:13:10.985518image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)

업소명
Text

UNIQUE 

Distinct26
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size340.0 B
2023-12-13T04:13:11.268177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length10.5
Mean length8.4615385
Min length3

Characters and Unicode

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

Unique

Unique26 ?
Unique (%)100.0%

Sample

1st row(주)씨티씨바이오
2nd row(주)하이엠텍
3rd row바이오베스트
4th row(주)대현교역
5th row신성-벳
ValueCountFrequency (%)
주식회사 3
 
9.4%
주)씨티씨바이오 1
 
3.1%
주)하이엠텍 1
 
3.1%
세라노틱스(주 1
 
3.1%
주식회사씨티씨바이오애니멀헬스 1
 
3.1%
펫메즈코리아 1
 
3.1%
한국엘랑코동물약품(주 1
 
3.1%
주)유니코애니멀헬스 1
 
3.1%
에스엠바이오텍 1
 
3.1%
주 1
 
3.1%
Other values (20) 20
62.5%
2023-12-13T04:13:11.977459image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 20
 
9.1%
( 16
 
7.3%
) 16
 
7.3%
이 11
 
5.0%
스 10
 
4.5%
오 8
 
3.6%
사 6
 
2.7%
바 6
 
2.7%
6
 
2.7%
코 5
 
2.3%
Other values (70) 116
52.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 181
82.3%
Open Punctuation 16
 
7.3%
Close Punctuation 16
 
7.3%
Space Separator 6
 
2.7%
Dash Punctuation 1
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 20
 
11.0%
이 11
 
6.1%
스 10
 
5.5%
오 8
 
4.4%
사 6
 
3.3%
바 6
 
3.3%
코 5
 
2.8%
식 4
 
2.2%
회 4
 
2.2%
씨 4
 
2.2%
Other values (66) 103
56.9%
Open Punctuation
ValueCountFrequency (%)
( 16
100.0%
Close Punctuation
ValueCountFrequency (%)
) 16
100.0%
Space Separator
ValueCountFrequency (%)
6
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 181
82.3%
Common 39
 
17.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 20
 
11.0%
이 11
 
6.1%
스 10
 
5.5%
오 8
 
4.4%
사 6
 
3.3%
바 6
 
3.3%
코 5
 
2.8%
식 4
 
2.2%
회 4
 
2.2%
씨 4
 
2.2%
Other values (66) 103
56.9%
Common
ValueCountFrequency (%)
( 16
41.0%
) 16
41.0%
6
 
15.4%
- 1
 
2.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 181
82.3%
ASCII 39
 
17.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 20
 
11.0%
이 11
 
6.1%
스 10
 
5.5%
오 8
 
4.4%
사 6
 
3.3%
바 6
 
3.3%
코 5
 
2.8%
식 4
 
2.2%
회 4
 
2.2%
씨 4
 
2.2%
Other values (66) 103
56.9%
ASCII
ValueCountFrequency (%)
( 16
41.0%
) 16
41.0%
6
 
15.4%
- 1
 
2.6%

영업상태
Categorical

IMBALANCE 

Distinct4
Distinct (%)15.4%
Missing0
Missing (%)0.0%
Memory size340.0 B
폐업
22 
정상
 
2
말소
 
1
휴업
 
1

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique2 ?
Unique (%)7.7%

Sample

1st row폐업
2nd row폐업
3rd row폐업
4th row폐업
5th row폐업

Common Values

ValueCountFrequency (%)
폐업 22
84.6%
정상 2
 
7.7%
말소 1
 
3.8%
휴업 1
 
3.8%

Length

2023-12-13T04:13:12.106093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T04:13:12.192026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
폐업 22
84.6%
정상 2
 
7.7%
말소 1
 
3.8%
휴업 1
 
3.8%

전화번호
Text

MISSING 

Distinct10
Distinct (%)100.0%
Missing16
Missing (%)61.5%
Memory size340.0 B
2023-12-13T04:13:12.323677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length10
Mean length9.1
Min length7

Characters and Unicode

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

Unique10 ?
Unique (%)100.0%

Sample

1st row3402-0310
2nd row3476-7978
3rd row420-9983
4th row3401-4738-9
5th row408-4191
ValueCountFrequency (%)
3402-0310 1
10.0%
3476-7978 1
10.0%
420-9983 1
10.0%
3401-4738-9 1
10.0%
408-4191 1
10.0%
3436-8252 1
10.0%
02-420-0690 1
10.0%
5530304 1
10.0%
4239806 1
10.0%
02-6933-7484 1
10.0%
2023-12-13T04:13:12.580311image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 14
15.4%
3 13
14.3%
4 13
14.3%
- 11
12.1%
2 8
8.8%
9 8
8.8%
8 7
7.7%
7 5
 
5.5%
6 5
 
5.5%
1 4
 
4.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 80
87.9%
Dash Punctuation 11
 
12.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 14
17.5%
3 13
16.2%
4 13
16.2%
2 8
10.0%
9 8
10.0%
8 7
8.8%
7 5
 
6.2%
6 5
 
6.2%
1 4
 
5.0%
5 3
 
3.8%
Dash Punctuation
ValueCountFrequency (%)
- 11
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 91
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 14
15.4%
3 13
14.3%
4 13
14.3%
- 11
12.1%
2 8
8.8%
9 8
8.8%
8 7
7.7%
7 5
 
5.5%
6 5
 
5.5%
1 4
 
4.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 91
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 14
15.4%
3 13
14.3%
4 13
14.3%
- 11
12.1%
2 8
8.8%
9 8
8.8%
8 7
7.7%
7 5
 
5.5%
6 5
 
5.5%
1 4
 
4.4%

영업장 주소
Text

Distinct25
Distinct (%)96.2%
Missing0
Missing (%)0.0%
Memory size340.0 B
2023-12-13T04:13:12.786527image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length35
Median length31.5
Mean length25.653846
Min length3

Characters and Unicode

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

Unique

Unique24 ?
Unique (%)92.3%

Sample

1st row서울특별시 송파구 오금동 93번지 지상3층
2nd row서울특별시 송파구 문정동 73번지 1호 지상2층
3rd row서울특별시 송파구 방이동 126번지 3호 서호빌딩202호
4th row서울특별시 송파구 가락동 99번지 5호
5th row서울특별시 송파구 송파동 85번지 13호 지층
ValueCountFrequency (%)
서울특별시 24
 
16.9%
송파구 24
 
16.9%
방이동 6
 
4.2%
송파동 4
 
2.8%
1호 3
 
2.1%
지상2층 3
 
2.1%
3호 3
 
2.1%
2호 3
 
2.1%
가락동 3
 
2.1%
4호 3
 
2.1%
Other values (55) 66
46.5%
2023-12-13T04:13:13.102610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
148
22.2%
지 36
 
5.4%
송 29
 
4.3%
파 29
 
4.3%
서 26
 
3.9%
호 26
 
3.9%
울 25
 
3.7%
동 25
 
3.7%
특 24
 
3.6%
별 24
 
3.6%
Other values (53) 275
41.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 407
61.0%
Space Separator 148
 
22.2%
Decimal Number 109
 
16.3%
Uppercase Letter 3
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
지 36
 
8.8%
송 29
 
7.1%
파 29
 
7.1%
서 26
 
6.4%
호 26
 
6.4%
울 25
 
6.1%
동 25
 
6.1%
특 24
 
5.9%
별 24
 
5.9%
시 24
 
5.9%
Other values (39) 139
34.2%
Decimal Number
ValueCountFrequency (%)
2 21
19.3%
1 20
18.3%
3 16
14.7%
5 10
9.2%
4 9
8.3%
9 9
8.3%
0 7
 
6.4%
7 6
 
5.5%
6 6
 
5.5%
8 5
 
4.6%
Uppercase Letter
ValueCountFrequency (%)
A 1
33.3%
M 1
33.3%
C 1
33.3%
Space Separator
ValueCountFrequency (%)
148
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 407
61.0%
Common 257
38.5%
Latin 3
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
지 36
 
8.8%
송 29
 
7.1%
파 29
 
7.1%
서 26
 
6.4%
호 26
 
6.4%
울 25
 
6.1%
동 25
 
6.1%
특 24
 
5.9%
별 24
 
5.9%
시 24
 
5.9%
Other values (39) 139
34.2%
Common
ValueCountFrequency (%)
148
57.6%
2 21
 
8.2%
1 20
 
7.8%
3 16
 
6.2%
5 10
 
3.9%
4 9
 
3.5%
9 9
 
3.5%
0 7
 
2.7%
7 6
 
2.3%
6 6
 
2.3%
Latin
ValueCountFrequency (%)
A 1
33.3%
M 1
33.3%
C 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 407
61.0%
ASCII 260
39.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
148
56.9%
2 21
 
8.1%
1 20
 
7.7%
3 16
 
6.2%
5 10
 
3.8%
4 9
 
3.5%
9 9
 
3.5%
0 7
 
2.7%
7 6
 
2.3%
6 6
 
2.3%
Other values (4) 8
 
3.1%
Hangul
ValueCountFrequency (%)
지 36
 
8.8%
송 29
 
7.1%
파 29
 
7.1%
서 26
 
6.4%
호 26
 
6.4%
울 25
 
6.1%
동 25
 
6.1%
특 24
 
5.9%
별 24
 
5.9%
시 24
 
5.9%
Other values (39) 139
34.2%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Memory size340.0 B
2021-09-16
26 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-09-16
2nd row2021-09-16
3rd row2021-09-16
4th row2021-09-16
5th row2021-09-16

Common Values

ValueCountFrequency (%)
2021-09-16 26
100.0%

Length

2023-12-13T04:13:13.215645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T04:13:13.289433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-09-16 26
100.0%

Correlations

2023-12-13T04:13:13.343847image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
신고일자업소명영업상태전화번호영업장 주소
신고일자1.0001.0001.0001.0001.000
업소명1.0001.0001.0001.0001.000
영업상태1.0001.0001.0001.0000.000
전화번호1.0001.0001.0001.0001.000
영업장 주소1.0001.0000.0001.0001.000

Missing values

2023-12-13T04:13:10.254763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T04:13:10.392077image/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동물용의약품판매업1996-01-15(주)씨티씨바이오폐업<NA>서울특별시 송파구 오금동 93번지 지상3층2021-09-16
1동물용의약품판매업2004-03-22(주)하이엠텍폐업3402-0310서울특별시 송파구 문정동 73번지 1호 지상2층2021-09-16
2동물용의약품판매업2000-01-19바이오베스트폐업<NA>서울특별시 송파구 방이동 126번지 3호 서호빌딩202호2021-09-16
3동물용의약품판매업2000-04-25(주)대현교역폐업<NA>서울특별시 송파구 가락동 99번지 5호2021-09-16
4동물용의약품판매업2001-09-13신성-벳폐업3476-7978서울특별시 송파구 송파동 85번지 13호 지층2021-09-16
5동물용의약품판매업2000-09-20(주)메딕코리아폐업<NA>서울특별시 송파구 거여동 290번지 1호 세신종합상가 415호2021-09-16
6동물용의약품판매업2001-12-13(주)애드바이오텍폐업<NA>서울특별시 송파구 가락동 189번지 13호 3층2021-09-16
7동물용의약품판매업2002-04-04(주)세인인터내셔날폐업<NA>서울특별시 송파구 가락동 10번지 4호 지상2층2021-09-16
8동물용의약품판매업2002-07-23피드넷(주)폐업<NA>서울특별시 송파구 풍납동 405번지 2호 3층2021-09-16
9동물용의약품판매업2002-11-06(주)명진바이오케미칼폐업<NA>서울특별시 송파구 송파동 173번지 13호 지층2021-09-16
업종명신고일자업소명영업상태전화번호영업장 주소데이터기준일자
16동물용의약품판매업2009-03-05주식회사 버박코리아정상<NA>서울특별시 송파구 방이동 65번지 2호2021-09-16
17동물용의약품판매업2009-09-25베이직사이언스폐업<NA>서울특별시 송파구 방이동 191번지 4호 청라빌딩 지상3층2021-09-16
18동물용의약품판매업2010-02-03아피메즈 주식회사 서울영업소휴업<NA>서울특별시 송파구 방이동 160번지 3호 CM빌딩 지하1층2021-09-16
19동물용의약품판매업2011-02-24(주) 에스엠바이오텍폐업02-420-06902021-09-16
20동물용의약품판매업2014-04-30(주)유니코애니멀헬스폐업<NA>서울특별시 송파구 삼전동 49번지 1호2021-09-16
21동물용의약품판매업2017-05-01한국엘랑코동물약품(주)정상5530304서울특별시 송파구 송파동 32번지 7호2021-09-16
22동물용의약품판매업2017-06-15펫메즈코리아폐업4239806서울특별시 송파구 방이동 51번지 2호2021-09-16
23동물용의약품판매업2019-05-13주식회사씨티씨바이오애니멀헬스폐업<NA>서울특별시 송파구 장지동 875번지 서울복합물류 A동 605호2021-09-16
24동물용의약품판매업2019-08-13세라노틱스(주)폐업02-6933-7484서울특별시 송파구 문정동 642번지 송파 테라타워22021-09-16
25동물용의약품판매업2020-01-09주식회사 펫팜폐업<NA>서울특별시 송파구 방이동 48번지 5호 현대주상복합빌딩2021-09-16