Overview

Dataset statistics

Number of variables6
Number of observations66
Missing cells39
Missing cells (%)9.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.3 KiB
Average record size in memory51.0 B

Variable types

Numeric1
Text3
DateTime1
Categorical1

Dataset

Description광주광역시 서구 관내의 소독업소명칭, 사무실소재지(도로명), 전화번호, 신고일자 등의 현황에 대한 정보입니다.
Author광주광역시 서구
URLhttps://www.data.go.kr/data/15080613/fileData.do

Alerts

데이터기준일 has constant value ""Constant
전화번호 has 39 (59.1%) missing valuesMissing
연번 has unique valuesUnique
소독업체명 has unique valuesUnique

Reproduction

Analysis started2023-12-16 15:47:53.802506
Analysis finished2023-12-16 15:47:58.164147
Duration4.36 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct66
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean33.5
Minimum1
Maximum66
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size726.0 B
2023-12-16T15:47:58.669565image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.25
Q117.25
median33.5
Q349.75
95-th percentile62.75
Maximum66
Range65
Interquartile range (IQR)32.5

Descriptive statistics

Standard deviation19.196354
Coefficient of variation (CV)0.57302549
Kurtosis-1.2
Mean33.5
Median Absolute Deviation (MAD)16.5
Skewness0
Sum2211
Variance368.5
MonotonicityStrictly increasing
2023-12-16T15:47:59.964262image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.5%
51 1
 
1.5%
37 1
 
1.5%
38 1
 
1.5%
39 1
 
1.5%
40 1
 
1.5%
41 1
 
1.5%
42 1
 
1.5%
43 1
 
1.5%
44 1
 
1.5%
Other values (56) 56
84.8%
ValueCountFrequency (%)
1 1
1.5%
2 1
1.5%
3 1
1.5%
4 1
1.5%
5 1
1.5%
6 1
1.5%
7 1
1.5%
8 1
1.5%
9 1
1.5%
10 1
1.5%
ValueCountFrequency (%)
66 1
1.5%
65 1
1.5%
64 1
1.5%
63 1
1.5%
62 1
1.5%
61 1
1.5%
60 1
1.5%
59 1
1.5%
58 1
1.5%
57 1
1.5%

소독업체명
Text

UNIQUE 

Distinct66
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size660.0 B
2023-12-16T15:48:01.192183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length13
Mean length7.8787879
Min length1

Characters and Unicode

Total characters520
Distinct characters156
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

Unique66 ?
Unique (%)100.0%

Sample

1st row(주)정연씨엔씨
2nd row필
3rd row하나방역 광주지사
4th row큰사랑의료기
5th row크린코리아
ValueCountFrequency (%)
주식회사 8
 
9.2%
유한회사 4
 
4.6%
주)세스코 3
 
3.4%
서비스광주지역단 2
 
2.3%
청소박사협동조합 1
 
1.1%
주)지에프엘 1
 
1.1%
우리씨케이용역 1
 
1.1%
운송조합 1
 
1.1%
전세버스 1
 
1.1%
광주광역시 1
 
1.1%
Other values (64) 64
73.6%
2023-12-16T15:48:03.193660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 39
 
7.5%
( 23
 
4.4%
) 23
 
4.4%
사 22
 
4.2%
21
 
4.0%
스 19
 
3.7%
회 15
 
2.9%
이 14
 
2.7%
역 12
 
2.3%
식 10
 
1.9%
Other values (146) 322
61.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 450
86.5%
Open Punctuation 23
 
4.4%
Close Punctuation 23
 
4.4%
Space Separator 21
 
4.0%
Decimal Number 3
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 39
 
8.7%
사 22
 
4.9%
스 19
 
4.2%
회 15
 
3.3%
이 14
 
3.1%
역 12
 
2.7%
식 10
 
2.2%
광 9
 
2.0%
리 9
 
2.0%
방 8
 
1.8%
Other values (140) 293
65.1%
Decimal Number
ValueCountFrequency (%)
8 1
33.3%
1 1
33.3%
5 1
33.3%
Open Punctuation
ValueCountFrequency (%)
( 23
100.0%
Close Punctuation
ValueCountFrequency (%)
) 23
100.0%
Space Separator
ValueCountFrequency (%)
21
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 450
86.5%
Common 70
 
13.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 39
 
8.7%
사 22
 
4.9%
스 19
 
4.2%
회 15
 
3.3%
이 14
 
3.1%
역 12
 
2.7%
식 10
 
2.2%
광 9
 
2.0%
리 9
 
2.0%
방 8
 
1.8%
Other values (140) 293
65.1%
Common
ValueCountFrequency (%)
( 23
32.9%
) 23
32.9%
21
30.0%
8 1
 
1.4%
1 1
 
1.4%
5 1
 
1.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 450
86.5%
ASCII 70
 
13.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 39
 
8.7%
사 22
 
4.9%
스 19
 
4.2%
회 15
 
3.3%
이 14
 
3.1%
역 12
 
2.7%
식 10
 
2.2%
광 9
 
2.0%
리 9
 
2.0%
방 8
 
1.8%
Other values (140) 293
65.1%
ASCII
ValueCountFrequency (%)
( 23
32.9%
) 23
32.9%
21
30.0%
8 1
 
1.4%
1 1
 
1.4%
5 1
 
1.4%

소재지도로명주소
Text

Distinct65
Distinct (%)98.5%
Missing0
Missing (%)0.0%
Memory size660.0 B
2023-12-16T15:48:04.675112image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length38
Mean length31.015152
Min length22

Characters and Unicode

Total characters2047
Distinct characters122
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

Unique64 ?
Unique (%)97.0%

Sample

1st row광주광역시 서구 매월2로15번길 16, 매월 종합상가 106동 2층 210호 (매월동)
2nd row광주광역시 서구 매월2로15번길 16, 매월 종합상가 202동 2층 207호 (매월동)
3rd row광주광역시 서구 군분로229번길 2, 4층 (농성동)
4th row광주광역시 서구 풍암신흥로11번길 14, 1층 (풍암동)
5th row광주광역시 서구 죽봉대로 129, 1층 (광천동)
ValueCountFrequency (%)
광주광역시 66
 
16.0%
서구 66
 
16.0%
쌍촌동 14
 
3.4%
1층 13
 
3.2%
2층 12
 
2.9%
농성동 9
 
2.2%
화정동 8
 
1.9%
매월동 7
 
1.7%
치평동 7
 
1.7%
매월2로15번길 5
 
1.2%
Other values (150) 205
49.8%
2023-12-16T15:48:07.080413image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
346
 
16.9%
광 137
 
6.7%
1 93
 
4.5%
동 73
 
3.6%
주 72
 
3.5%
2 69
 
3.4%
( 68
 
3.3%
시 68
 
3.3%
) 68
 
3.3%
서 67
 
3.3%
Other values (112) 986
48.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1138
55.6%
Decimal Number 364
 
17.8%
Space Separator 346
 
16.9%
Open Punctuation 68
 
3.3%
Close Punctuation 68
 
3.3%
Other Punctuation 47
 
2.3%
Dash Punctuation 16
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 137
 
12.0%
동 73
 
6.4%
주 72
 
6.3%
시 68
 
6.0%
서 67
 
5.9%
구 66
 
5.8%
역 66
 
5.8%
로 63
 
5.5%
층 38
 
3.3%
길 36
 
3.2%
Other values (97) 452
39.7%
Decimal Number
ValueCountFrequency (%)
1 93
25.5%
2 69
19.0%
3 31
 
8.5%
5 31
 
8.5%
4 27
 
7.4%
6 27
 
7.4%
0 26
 
7.1%
7 25
 
6.9%
9 19
 
5.2%
8 16
 
4.4%
Space Separator
ValueCountFrequency (%)
346
100.0%
Open Punctuation
ValueCountFrequency (%)
( 68
100.0%
Close Punctuation
ValueCountFrequency (%)
) 68
100.0%
Other Punctuation
ValueCountFrequency (%)
, 47
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 16
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1138
55.6%
Common 909
44.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 137
 
12.0%
동 73
 
6.4%
주 72
 
6.3%
시 68
 
6.0%
서 67
 
5.9%
구 66
 
5.8%
역 66
 
5.8%
로 63
 
5.5%
층 38
 
3.3%
길 36
 
3.2%
Other values (97) 452
39.7%
Common
ValueCountFrequency (%)
346
38.1%
1 93
 
10.2%
2 69
 
7.6%
( 68
 
7.5%
) 68
 
7.5%
, 47
 
5.2%
3 31
 
3.4%
5 31
 
3.4%
4 27
 
3.0%
6 27
 
3.0%
Other values (5) 102
 
11.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1138
55.6%
ASCII 909
44.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
346
38.1%
1 93
 
10.2%
2 69
 
7.6%
( 68
 
7.5%
) 68
 
7.5%
, 47
 
5.2%
3 31
 
3.4%
5 31
 
3.4%
4 27
 
3.0%
6 27
 
3.0%
Other values (5) 102
 
11.2%
Hangul
ValueCountFrequency (%)
광 137
 
12.0%
동 73
 
6.4%
주 72
 
6.3%
시 68
 
6.0%
서 67
 
5.9%
구 66
 
5.8%
역 66
 
5.8%
로 63
 
5.5%
층 38
 
3.3%
길 36
 
3.2%
Other values (97) 452
39.7%

전화번호
Text

MISSING 

Distinct27
Distinct (%)100.0%
Missing39
Missing (%)59.1%
Memory size660.0 B
2023-12-16T15:48:07.958013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.296296
Min length8

Characters and Unicode

Total characters305
Distinct characters12
Distinct categories3 ?
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 row062-603-2453
2nd row062-225-6800
3rd row062-383-0942
4th row062-447-5085
5th row062-384-2005
ValueCountFrequency (%)
062-603-2453 1
 
3.7%
062-447-4747 1
 
3.7%
062-671-4142 1
 
3.7%
062-676-6645 1
 
3.7%
062-363-6033 1
 
3.7%
062-383-1482 1
 
3.7%
062-372-6771 1
 
3.7%
226-0361 1
 
3.7%
062-369-6133 1
 
3.7%
062-610-5055 1
 
3.7%
Other values (17) 17
63.0%
2023-12-16T15:48:09.661736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 48
15.7%
2 47
15.4%
6 45
14.8%
0 42
13.8%
3 25
8.2%
7 21
6.9%
4 19
 
6.2%
5 19
 
6.2%
1 16
 
5.2%
8 14
 
4.6%
Other values (2) 9
 
3.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 256
83.9%
Dash Punctuation 48
 
15.7%
Close Punctuation 1
 
0.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 47
18.4%
6 45
17.6%
0 42
16.4%
3 25
9.8%
7 21
8.2%
4 19
7.4%
5 19
7.4%
1 16
 
6.2%
8 14
 
5.5%
9 8
 
3.1%
Dash Punctuation
ValueCountFrequency (%)
- 48
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 305
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 48
15.7%
2 47
15.4%
6 45
14.8%
0 42
13.8%
3 25
8.2%
7 21
6.9%
4 19
 
6.2%
5 19
 
6.2%
1 16
 
5.2%
8 14
 
4.6%
Other values (2) 9
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 305
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 48
15.7%
2 47
15.4%
6 45
14.8%
0 42
13.8%
3 25
8.2%
7 21
6.9%
4 19
 
6.2%
5 19
 
6.2%
1 16
 
5.2%
8 14
 
4.6%
Other values (2) 9
 
3.0%

신고일자
Date

Distinct65
Distinct (%)98.5%
Missing0
Missing (%)0.0%
Memory size660.0 B
Minimum1995-07-27 00:00:00
Maximum2023-12-12 00:00:00
2023-12-16T15:48:10.602679image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:48:11.605561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size660.0 B
2023-12-13
66 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-12-13
2nd row2023-12-13
3rd row2023-12-13
4th row2023-12-13
5th row2023-12-13

Common Values

ValueCountFrequency (%)
2023-12-13 66
100.0%

Length

2023-12-16T15:48:12.254654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:48:12.718410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-12-13 66
100.0%

Interactions

2023-12-16T15:47:56.248499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-16T15:48:12.970661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번소독업체명소재지도로명주소전화번호신고일자
연번1.0001.0000.9461.0001.000
소독업체명1.0001.0001.0001.0001.000
소재지도로명주소0.9461.0001.0001.0000.998
전화번호1.0001.0001.0001.0001.000
신고일자1.0001.0000.9981.0001.000

Missing values

2023-12-16T15:47:57.030561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-16T15:47:57.692571image/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로15번길 16, 매월 종합상가 106동 2층 210호 (매월동)062-603-24532023-12-122023-12-13
12필광주광역시 서구 매월2로15번길 16, 매월 종합상가 202동 2층 207호 (매월동)<NA>2023-09-202023-12-13
23하나방역 광주지사광주광역시 서구 군분로229번길 2, 4층 (농성동)<NA>2023-06-202023-12-13
34큰사랑의료기광주광역시 서구 풍암신흥로11번길 14, 1층 (풍암동)<NA>2023-03-202023-12-13
45크린코리아광주광역시 서구 죽봉대로 129, 1층 (광천동)<NA>2023-03-082023-12-13
56(주)행복플러스크리닝광주광역시 서구 화운로303번길 6, 1층 (광천동)<NA>2023-02-012023-12-13
67주식회사 행복한사람들광주광역시 서구 월드컵4강로158번길 15-7, 3층 (쌍촌동)<NA>2023-01-182023-12-13
78미림광주광역시 서구 염화로133번길 17, 1층 (화정동)<NA>2022-12-162023-12-13
89바이오그린광주광역시 서구 매월2로 53, 광주산업용재유통센터 5동 234호 (매월동)<NA>2022-08-092023-12-13
910518 민주화운동부상자회광주광역시 서구 상무화원로32번길 19, 2층 202호 (치평동)<NA>2022-08-042023-12-13
연번소독업체명소재지도로명주소전화번호신고일자데이터기준일
5657목송산업개발(주)광주광역시 서구 무진대로 567 (덕흥동)062-383-14822004-09-162023-12-13
5758(주)우리관리공사광주광역시 서구 금부로95번길 43, 2층 (쌍촌동)062-363-60332004-09-162023-12-13
5859주식회사 에코원광주광역시 서구 화정로 25, 1층 (쌍촌동)062-676-66452003-11-152023-12-13
5960(주)코믹스광주광역시 서구 독립로188번길 8-1, 지하1층 (양동)<NA>2003-03-032023-12-13
6061하나산업개발광주광역시 서구 매월2로15번길 16, 매월 종합상가 203동 2층 224호 (매월동)062-671-41422001-09-032023-12-13
6162금호방역사광주광역시 서구 상무대로 944 (쌍촌동, 해성빌딩 2층)<NA>2000-01-082023-12-13
6263광주보건환경광주광역시 서구 화정로271번길 3-1 (농성동)<NA>1999-09-212023-12-13
6364세모환경개발광주광역시 서구 매월2로 53 (매월동, 광주산업용재선터 123, 223호)062-603-06791999-02-082023-12-13
6465세방방역광주광역시 서구 상무대로1080번길 1 (화정동)<NA>1997-03-132023-12-13
6566(주)도울환경광주광역시 서구 상무대로 1065-1, 2층 207호 (화정동)<NA>1995-07-272023-12-13