Overview

Dataset statistics

Number of variables4
Number of observations54
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.9 KiB
Average record size in memory35.4 B

Variable types

Numeric1
Text3

Dataset

Description전라북도 전기안전관리업체 현황(2016. 7월 기준) 연번 업체명 전화번호 주소 전주, 군산, 익산, 정읍, 남원, 김제, 완주, 진안, 무주, 장수, 임실, 순창, 고창, 부안
URLhttps://www.data.go.kr/data/15119351/fileData.do

Alerts

연번 has unique valuesUnique
업체명 has unique valuesUnique
주소 has unique valuesUnique

Reproduction

Analysis started2023-12-11 22:53:00.148013
Analysis finished2023-12-11 22:53:00.525073
Duration0.38 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct54
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean27.574074
Minimum1
Maximum56
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size618.0 B
2023-12-12T07:53:00.582338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.65
Q114.25
median27.5
Q340.75
95-th percentile51.7
Maximum56
Range55
Interquartile range (IQR)26.5

Descriptive statistics

Standard deviation15.858575
Coefficient of variation (CV)0.5751263
Kurtosis-1.1629693
Mean27.574074
Median Absolute Deviation (MAD)13.5
Skewness0.02692629
Sum1489
Variance251.49441
MonotonicityStrictly increasing
2023-12-12T07:53:00.690505image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.9%
42 1
 
1.9%
31 1
 
1.9%
32 1
 
1.9%
33 1
 
1.9%
34 1
 
1.9%
35 1
 
1.9%
36 1
 
1.9%
37 1
 
1.9%
38 1
 
1.9%
Other values (44) 44
81.5%
ValueCountFrequency (%)
1 1
1.9%
2 1
1.9%
3 1
1.9%
4 1
1.9%
5 1
1.9%
6 1
1.9%
7 1
1.9%
8 1
1.9%
9 1
1.9%
10 1
1.9%
ValueCountFrequency (%)
56 1
1.9%
54 1
1.9%
53 1
1.9%
51 1
1.9%
50 1
1.9%
49 1
1.9%
48 1
1.9%
47 1
1.9%
46 1
1.9%
45 1
1.9%

업체명
Text

UNIQUE 

Distinct54
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size564.0 B
2023-12-12T07:53:00.895881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length12
Mean length8.9444444
Min length4

Characters and Unicode

Total characters483
Distinct characters79
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique54 ?
Unique (%)100.0%

Sample

1st row(주)케시
2nd row전북전기관리공사
3rd row한국전기관리소
4th row대한전기안전관리
5th row(유)호남전기안전관리
ValueCountFrequency (%)
주식회사 2
 
3.5%
주)케시 1
 
1.8%
한국전력관리단 1
 
1.8%
서브원 1
 
1.8%
신한국전력관리단 1
 
1.8%
동부전기안전관리 1
 
1.8%
주)셉코 1
 
1.8%
한일전기관리단 1
 
1.8%
유)고인돌전기안전관리 1
 
1.8%
대한전기안전관리소 1
 
1.8%
Other values (46) 46
80.7%
2023-12-12T07:53:01.209330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
전 77
15.9%
기 44
 
9.1%
리 40
 
8.3%
관 39
 
8.1%
안 26
 
5.4%
( 23
 
4.8%
) 23
 
4.8%
유 21
 
4.3%
한 19
 
3.9%
사 17
 
3.5%
Other values (69) 154
31.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 422
87.4%
Open Punctuation 23
 
4.8%
Close Punctuation 23
 
4.8%
Uppercase Letter 10
 
2.1%
Space Separator 3
 
0.6%
Dash Punctuation 1
 
0.2%
Other Symbol 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 77
18.2%
기 44
 
10.4%
리 40
 
9.5%
관 39
 
9.2%
안 26
 
6.2%
유 21
 
5.0%
한 19
 
4.5%
사 17
 
4.0%
공 12
 
2.8%
소 10
 
2.4%
Other values (57) 117
27.7%
Uppercase Letter
ValueCountFrequency (%)
K 3
30.0%
E 2
20.0%
S 1
 
10.0%
N 1
 
10.0%
T 1
 
10.0%
O 1
 
10.0%
P 1
 
10.0%
Open Punctuation
ValueCountFrequency (%)
( 23
100.0%
Close Punctuation
ValueCountFrequency (%)
) 23
100.0%
Space Separator
ValueCountFrequency (%)
3
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 423
87.6%
Common 50
 
10.4%
Latin 10
 
2.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 77
18.2%
기 44
 
10.4%
리 40
 
9.5%
관 39
 
9.2%
안 26
 
6.1%
유 21
 
5.0%
한 19
 
4.5%
사 17
 
4.0%
공 12
 
2.8%
소 10
 
2.4%
Other values (58) 118
27.9%
Latin
ValueCountFrequency (%)
K 3
30.0%
E 2
20.0%
S 1
 
10.0%
N 1
 
10.0%
T 1
 
10.0%
O 1
 
10.0%
P 1
 
10.0%
Common
ValueCountFrequency (%)
( 23
46.0%
) 23
46.0%
3
 
6.0%
- 1
 
2.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 422
87.4%
ASCII 60
 
12.4%
None 1
 
0.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
전 77
18.2%
기 44
 
10.4%
리 40
 
9.5%
관 39
 
9.2%
안 26
 
6.2%
유 21
 
5.0%
한 19
 
4.5%
사 17
 
4.0%
공 12
 
2.8%
소 10
 
2.4%
Other values (57) 117
27.7%
ASCII
ValueCountFrequency (%)
( 23
38.3%
) 23
38.3%
3
 
5.0%
K 3
 
5.0%
E 2
 
3.3%
S 1
 
1.7%
N 1
 
1.7%
- 1
 
1.7%
T 1
 
1.7%
O 1
 
1.7%
None
ValueCountFrequency (%)
㈜ 1
100.0%

전화번호
Text

Distinct52
Distinct (%)96.3%
Missing0
Missing (%)0.0%
Memory size564.0 B
2023-12-12T07:53:01.436788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.018519
Min length12

Characters and Unicode

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

Unique50 ?
Unique (%)92.6%

Sample

1st row063-253-0300
2nd row063-858-1625
3rd row063-854-2221
4th row063-278-8771
5th row063-252-1341
ValueCountFrequency (%)
063-535-0401 2
 
3.7%
063-237-2100 2
 
3.7%
063-466-3330 1
 
1.9%
063-253-0300 1
 
1.9%
063-464-5996 1
 
1.9%
063-835-1520 1
 
1.9%
063-537-1921 1
 
1.9%
063-277-5678 1
 
1.9%
063-838-8600 1
 
1.9%
063-564-8885 1
 
1.9%
Other values (42) 42
77.8%
2023-12-12T07:53:01.882417image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 108
16.6%
6 94
14.5%
3 92
14.2%
0 89
13.7%
2 76
11.7%
8 43
 
6.6%
1 41
 
6.3%
5 31
 
4.8%
7 30
 
4.6%
4 28
 
4.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 541
83.4%
Dash Punctuation 108
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 94
17.4%
3 92
17.0%
0 89
16.5%
2 76
14.0%
8 43
7.9%
1 41
7.6%
5 31
 
5.7%
7 30
 
5.5%
4 28
 
5.2%
9 17
 
3.1%
Dash Punctuation
ValueCountFrequency (%)
- 108
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 649
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 108
16.6%
6 94
14.5%
3 92
14.2%
0 89
13.7%
2 76
11.7%
8 43
 
6.6%
1 41
 
6.3%
5 31
 
4.8%
7 30
 
4.6%
4 28
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 649
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 108
16.6%
6 94
14.5%
3 92
14.2%
0 89
13.7%
2 76
11.7%
8 43
 
6.6%
1 41
 
6.3%
5 31
 
4.8%
7 30
 
4.6%
4 28
 
4.3%

주소
Text

UNIQUE 

Distinct54
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size564.0 B
2023-12-12T07:53:02.262463image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length45
Median length31
Mean length27.518519
Min length15

Characters and Unicode

Total characters1486
Distinct characters142
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

Unique54 ?
Unique (%)100.0%

Sample

1st row전주시 덕진구 팔달로 322-7 (진북동 363-5)
2nd row익산시 서동로5길 13 (주현동 245-8)
3rd row익산시 서동로 157 (마동)
4th row전주시 완산구 솟대1길 49(삼천동1가 700-2)
5th row전주시 덕진구 금암2동 1585-4
ValueCountFrequency (%)
전주시 24
 
8.4%
완산구 16
 
5.6%
익산시 12
 
4.2%
덕진구 8
 
2.8%
정읍시 7
 
2.5%
군산시 7
 
2.5%
효자동3가 5
 
1.8%
영등동 4
 
1.4%
남원시 3
 
1.1%
마동 2
 
0.7%
Other values (190) 197
69.1%
2023-12-12T07:53:02.715270image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
262
 
17.6%
1 79
 
5.3%
2 61
 
4.1%
동 59
 
4.0%
시 54
 
3.6%
) 54
 
3.6%
( 54
 
3.6%
3 53
 
3.6%
- 50
 
3.4%
산 49
 
3.3%
Other values (132) 711
47.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 659
44.3%
Decimal Number 400
26.9%
Space Separator 262
 
17.6%
Close Punctuation 54
 
3.6%
Open Punctuation 54
 
3.6%
Dash Punctuation 50
 
3.4%
Other Punctuation 7
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 59
 
9.0%
시 54
 
8.2%
산 49
 
7.4%
로 35
 
5.3%
주 27
 
4.1%
전 27
 
4.1%
길 25
 
3.8%
구 25
 
3.8%
가 24
 
3.6%
완 16
 
2.4%
Other values (115) 318
48.3%
Decimal Number
ValueCountFrequency (%)
1 79
19.8%
2 61
15.2%
3 53
13.2%
5 48
12.0%
4 35
8.8%
6 34
8.5%
7 26
 
6.5%
0 24
 
6.0%
8 21
 
5.2%
9 19
 
4.8%
Other Punctuation
ValueCountFrequency (%)
, 5
71.4%
/ 1
 
14.3%
@ 1
 
14.3%
Space Separator
ValueCountFrequency (%)
262
100.0%
Close Punctuation
ValueCountFrequency (%)
) 54
100.0%
Open Punctuation
ValueCountFrequency (%)
( 54
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 50
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 827
55.7%
Hangul 659
44.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 59
 
9.0%
시 54
 
8.2%
산 49
 
7.4%
로 35
 
5.3%
주 27
 
4.1%
전 27
 
4.1%
길 25
 
3.8%
구 25
 
3.8%
가 24
 
3.6%
완 16
 
2.4%
Other values (115) 318
48.3%
Common
ValueCountFrequency (%)
262
31.7%
1 79
 
9.6%
2 61
 
7.4%
) 54
 
6.5%
( 54
 
6.5%
3 53
 
6.4%
- 50
 
6.0%
5 48
 
5.8%
4 35
 
4.2%
6 34
 
4.1%
Other values (7) 97
 
11.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 827
55.7%
Hangul 659
44.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
262
31.7%
1 79
 
9.6%
2 61
 
7.4%
) 54
 
6.5%
( 54
 
6.5%
3 53
 
6.4%
- 50
 
6.0%
5 48
 
5.8%
4 35
 
4.2%
6 34
 
4.1%
Other values (7) 97
 
11.7%
Hangul
ValueCountFrequency (%)
동 59
 
9.0%
시 54
 
8.2%
산 49
 
7.4%
로 35
 
5.3%
주 27
 
4.1%
전 27
 
4.1%
길 25
 
3.8%
구 25
 
3.8%
가 24
 
3.6%
완 16
 
2.4%
Other values (115) 318
48.3%

Interactions

2023-12-12T07:53:00.332101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T07:53:02.830087image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업체명전화번호주소
연번1.0001.0000.8071.000
업체명1.0001.0001.0001.000
전화번호0.8071.0001.0001.000
주소1.0001.0001.0001.000

Missing values

2023-12-12T07:53:00.428496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T07:53:00.498842image/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(주)케시063-253-0300전주시 덕진구 팔달로 322-7 (진북동 363-5)
12전북전기관리공사063-858-1625익산시 서동로5길 13 (주현동 245-8)
23한국전기관리소063-854-2221익산시 서동로 157 (마동)
34대한전기안전관리063-278-8771전주시 완산구 솟대1길 49(삼천동1가 700-2)
45(유)호남전기안전관리063-252-1341전주시 덕진구 금암2동 1585-4
56나라전기관리공사063-232-6330전주시 완산구 전주객사5길 47 (고사동 203-6) 603호
67(유)한국관리공사063-226-6417전주시 완산구 메너머3길 24, 2층(중화산동2가)
78(유)군장전기안전관리소063-442-2666군산시 월명로 416-1 (미원동 37)
89(유)한국전력보안공사063-222-6627전주시 완산구 신촌3길 27-18 (중화산동2가 485-125)
910전북전기사업소063-242-6321전주시 덕진구 견훤로 302 (인후동1가 765-24)
연번업체명전화번호주소
4445한빛전기관리소063-537-0406정읍시 연지동 305-95
4546(주)대성이엔씨063-837-7974정읍시 북면 3산단1길 88 (북면 태곡리 929)
4647전북전기기술공사063-853-1520익산시 군익로 511 (송학동 16-4)
4748㈜전기안전관리컨설팅063-451-9050군산시 검다메안길 6-8, 202(조촌동)
4849(유)대한전기안전관리공사063-286-9800전주시 완산구 물왕멀로 9(중노송동575-8)
4950(유)장안전기안전관리063-226-0189전주시 완산구 우전로 104(효자동2가)
5051그린전기안전관리063-538-8966정읍시 벚꽃로 539-11(상동)
5153주식회사 희성070-8252-1911전주시 덕진구 가련산로 23,5층 502호(덕진동2가)
5254주식회사 서브원02-6924-4102전주시 완산구 백제대로 323(중화산동2가)
5356유한회사삼성전기관리공사063-535-0401정읍시 서부산업도로 476,202호(수성동)