Overview

Dataset statistics

Number of variables5
Number of observations500
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory20.1 KiB
Average record size in memory41.3 B

Variable types

Numeric1
Categorical1
Text3

Dataset

Description대전광역시 한국전기공사협회에 소속된 회원사들의 상호명과 소재지를 정리한 데이터(파일)입니다. 해당 파일은 업종, 상호명, 대표자명, 소재지 데이터를 포함하고 있습니다.
Author대전광역시
URLhttps://www.data.go.kr/data/15081504/fileData.do

Alerts

업종 has constant value ""Constant
연번 has unique valuesUnique
상호명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 10:26:34.783365
Analysis finished2023-12-12 10:26:35.538268
Duration0.75 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct500
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean250.5
Minimum1
Maximum500
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.5 KiB
2023-12-12T19:26:35.646280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile25.95
Q1125.75
median250.5
Q3375.25
95-th percentile475.05
Maximum500
Range499
Interquartile range (IQR)249.5

Descriptive statistics

Standard deviation144.48183
Coefficient of variation (CV)0.57677378
Kurtosis-1.2
Mean250.5
Median Absolute Deviation (MAD)125
Skewness0
Sum125250
Variance20875
MonotonicityStrictly increasing
2023-12-12T19:26:35.839109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
331 1
 
0.2%
344 1
 
0.2%
343 1
 
0.2%
342 1
 
0.2%
341 1
 
0.2%
340 1
 
0.2%
339 1
 
0.2%
338 1
 
0.2%
337 1
 
0.2%
Other values (490) 490
98.0%
ValueCountFrequency (%)
1 1
0.2%
2 1
0.2%
3 1
0.2%
4 1
0.2%
5 1
0.2%
6 1
0.2%
7 1
0.2%
8 1
0.2%
9 1
0.2%
10 1
0.2%
ValueCountFrequency (%)
500 1
0.2%
499 1
0.2%
498 1
0.2%
497 1
0.2%
496 1
0.2%
495 1
0.2%
494 1
0.2%
493 1
0.2%
492 1
0.2%
491 1
0.2%

업종
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
전기공사업
500 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row전기공사업
2nd row전기공사업
3rd row전기공사업
4th row전기공사업
5th row전기공사업

Common Values

ValueCountFrequency (%)
전기공사업 500
100.0%

Length

2023-12-12T19:26:36.013937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:26:36.135642image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전기공사업 500
100.0%

상호명
Text

UNIQUE 

Distinct500
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
2023-12-12T19:26:36.453819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length40
Median length32
Mean length9.06
Min length3

Characters and Unicode

Total characters4530
Distinct characters263
Distinct categories8 ?
Distinct scripts4 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique500 ?
Unique (%)100.0%

Sample

1st row주식회사 강중
2nd row주식회사 드림앤테크
3rd row주식회사 경진전기
4th row주식회사 대청에너지
5th row주식회사 대덕전업공사
ValueCountFrequency (%)
주식회사 303
36.3%
합자회사 5
 
0.6%
ltd 4
 
0.5%
co 3
 
0.4%
대영전력 2
 
0.2%
주)블루코드 1
 
0.1%
가람전력 1
 
0.1%
세아엔지니어링 1
 
0.1%
협신 1
 
0.1%
보원전기 1
 
0.1%
Other values (512) 512
61.4%
2023-12-12T19:26:36.935723image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 453
 
10.0%
사 339
 
7.5%
334
 
7.4%
회 309
 
6.8%
식 303
 
6.7%
전 258
 
5.7%
( 177
 
3.9%
) 177
 
3.9%
기 126
 
2.8%
이 108
 
2.4%
Other values (253) 1946
43.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3721
82.1%
Space Separator 334
 
7.4%
Open Punctuation 177
 
3.9%
Close Punctuation 177
 
3.9%
Uppercase Letter 73
 
1.6%
Lowercase Letter 36
 
0.8%
Other Punctuation 11
 
0.2%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 453
 
12.2%
사 339
 
9.1%
회 309
 
8.3%
식 303
 
8.1%
전 258
 
6.9%
기 126
 
3.4%
이 108
 
2.9%
력 106
 
2.8%
에 72
 
1.9%
지 71
 
1.9%
Other values (209) 1576
42.4%
Uppercase Letter
ValueCountFrequency (%)
E 11
15.1%
C 10
13.7%
L 7
9.6%
N 7
9.6%
S 5
 
6.8%
T 5
 
6.8%
O 4
 
5.5%
R 4
 
5.5%
G 3
 
4.1%
M 3
 
4.1%
Other values (10) 14
19.2%
Lowercase Letter
ValueCountFrequency (%)
o 8
22.2%
t 6
16.7%
d 4
11.1%
n 2
 
5.6%
a 2
 
5.6%
r 2
 
5.6%
e 2
 
5.6%
x 1
 
2.8%
l 1
 
2.8%
g 1
 
2.8%
Other values (7) 7
19.4%
Other Punctuation
ValueCountFrequency (%)
. 8
72.7%
, 2
 
18.2%
& 1
 
9.1%
Space Separator
ValueCountFrequency (%)
334
100.0%
Open Punctuation
ValueCountFrequency (%)
( 177
100.0%
Close Punctuation
ValueCountFrequency (%)
) 177
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3713
82.0%
Common 700
 
15.5%
Latin 109
 
2.4%
Han 8
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 453
 
12.2%
사 339
 
9.1%
회 309
 
8.3%
식 303
 
8.2%
전 258
 
6.9%
기 126
 
3.4%
이 108
 
2.9%
력 106
 
2.9%
에 72
 
1.9%
지 71
 
1.9%
Other values (201) 1568
42.2%
Latin
ValueCountFrequency (%)
E 11
 
10.1%
C 10
 
9.2%
o 8
 
7.3%
L 7
 
6.4%
N 7
 
6.4%
t 6
 
5.5%
S 5
 
4.6%
T 5
 
4.6%
d 4
 
3.7%
O 4
 
3.7%
Other values (27) 42
38.5%
Han
ValueCountFrequency (%)
電 1
12.5%
株 1
12.5%
式 1
12.5%
會 1
12.5%
社 1
12.5%
誠 1
12.5%
一 1
12.5%
機 1
12.5%
Common
ValueCountFrequency (%)
334
47.7%
( 177
25.3%
) 177
25.3%
. 8
 
1.1%
, 2
 
0.3%
- 1
 
0.1%
& 1
 
0.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3713
82.0%
ASCII 809
 
17.9%
CJK 8
 
0.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 453
 
12.2%
사 339
 
9.1%
회 309
 
8.3%
식 303
 
8.2%
전 258
 
6.9%
기 126
 
3.4%
이 108
 
2.9%
력 106
 
2.9%
에 72
 
1.9%
지 71
 
1.9%
Other values (201) 1568
42.2%
ASCII
ValueCountFrequency (%)
334
41.3%
( 177
21.9%
) 177
21.9%
E 11
 
1.4%
C 10
 
1.2%
o 8
 
1.0%
. 8
 
1.0%
L 7
 
0.9%
N 7
 
0.9%
t 6
 
0.7%
Other values (34) 64
 
7.9%
CJK
ValueCountFrequency (%)
電 1
12.5%
株 1
12.5%
式 1
12.5%
會 1
12.5%
社 1
12.5%
誠 1
12.5%
一 1
12.5%
機 1
12.5%

대표자명
Text

Distinct491
Distinct (%)98.2%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
2023-12-12T19:26:37.317216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length2.992
Min length2

Characters and Unicode

Total characters1496
Distinct characters174
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

Unique482 ?
Unique (%)96.4%

Sample

1st row김은영
2nd row김석진
3rd row윤철호
4th row채수영
5th row김종인
ValueCountFrequency (%)
김종규 2
 
0.4%
오원근 2
 
0.4%
김동욱 2
 
0.4%
이상규 2
 
0.4%
박용균 2
 
0.4%
김경희 2
 
0.4%
이종현 2
 
0.4%
이정현 2
 
0.4%
김현수 2
 
0.4%
이상헌 1
 
0.2%
Other values (481) 481
96.2%
2023-12-12T19:26:38.176477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 103
 
6.9%
이 85
 
5.7%
정 51
 
3.4%
영 45
 
3.0%
박 44
 
2.9%
현 34
 
2.3%
수 32
 
2.1%
종 27
 
1.8%
희 27
 
1.8%
윤 25
 
1.7%
Other values (164) 1023
68.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1496
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 103
 
6.9%
이 85
 
5.7%
정 51
 
3.4%
영 45
 
3.0%
박 44
 
2.9%
현 34
 
2.3%
수 32
 
2.1%
종 27
 
1.8%
희 27
 
1.8%
윤 25
 
1.7%
Other values (164) 1023
68.4%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1496
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 103
 
6.9%
이 85
 
5.7%
정 51
 
3.4%
영 45
 
3.0%
박 44
 
2.9%
현 34
 
2.3%
수 32
 
2.1%
종 27
 
1.8%
희 27
 
1.8%
윤 25
 
1.7%
Other values (164) 1023
68.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1496
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 103
 
6.9%
이 85
 
5.7%
정 51
 
3.4%
영 45
 
3.0%
박 44
 
2.9%
현 34
 
2.3%
수 32
 
2.1%
종 27
 
1.8%
희 27
 
1.8%
윤 25
 
1.7%
Other values (164) 1023
68.4%

소재지
Text

Distinct494
Distinct (%)98.8%
Missing0
Missing (%)0.0%
Memory size4.0 KiB
2023-12-12T19:26:38.532519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length53
Median length42
Mean length27.756
Min length15

Characters and Unicode

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

Unique

Unique489 ?
Unique (%)97.8%

Sample

1st row대전광역시 유성구 송강로 15, 상가동 제지하층 제6호 (송강동, 한솔아파트)
2nd row대전광역시 서구 문정로90번길 21, 503호(탄방동,이노타워빌딩) (탄방동)
3rd row대전광역시 중구 수침로91번길 39, 1층(태평동)
4th row대전광역시 대덕구 산업단지로87번길 82(신일동)
5th row대전광역시 유성구 교촌로 5
ValueCountFrequency (%)
대전광역시 500
 
19.6%
유성구 137
 
5.4%
대덕구 119
 
4.7%
서구 100
 
3.9%
동구 74
 
2.9%
중구 70
 
2.7%
오정동 20
 
0.8%
2층 18
 
0.7%
1층 16
 
0.6%
테크노2로 10
 
0.4%
Other values (958) 1488
58.3%
2023-12-12T19:26:38.994701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2099
 
15.1%
대 798
 
5.8%
동 585
 
4.2%
1 566
 
4.1%
전 546
 
3.9%
구 513
 
3.7%
광 502
 
3.6%
역 500
 
3.6%
시 500
 
3.6%
로 479
 
3.5%
Other values (232) 6790
48.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 8025
57.8%
Decimal Number 2475
 
17.8%
Space Separator 2099
 
15.1%
Open Punctuation 430
 
3.1%
Close Punctuation 429
 
3.1%
Other Punctuation 307
 
2.2%
Dash Punctuation 109
 
0.8%
Uppercase Letter 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
대 798
 
9.9%
동 585
 
7.3%
전 546
 
6.8%
구 513
 
6.4%
광 502
 
6.3%
역 500
 
6.2%
시 500
 
6.2%
로 479
 
6.0%
길 284
 
3.5%
번 264
 
3.3%
Other values (212) 3054
38.1%
Decimal Number
ValueCountFrequency (%)
1 566
22.9%
2 356
14.4%
3 281
11.4%
0 248
10.0%
5 209
 
8.4%
4 199
 
8.0%
7 188
 
7.6%
6 158
 
6.4%
8 145
 
5.9%
9 125
 
5.1%
Uppercase Letter
ValueCountFrequency (%)
T 1
25.0%
K 1
25.0%
B 1
25.0%
A 1
25.0%
Other Punctuation
ValueCountFrequency (%)
, 306
99.7%
. 1
 
0.3%
Space Separator
ValueCountFrequency (%)
2099
100.0%
Open Punctuation
ValueCountFrequency (%)
( 430
100.0%
Close Punctuation
ValueCountFrequency (%)
) 429
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 109
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 8025
57.8%
Common 5849
42.1%
Latin 4
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
대 798
 
9.9%
동 585
 
7.3%
전 546
 
6.8%
구 513
 
6.4%
광 502
 
6.3%
역 500
 
6.2%
시 500
 
6.2%
로 479
 
6.0%
길 284
 
3.5%
번 264
 
3.3%
Other values (212) 3054
38.1%
Common
ValueCountFrequency (%)
2099
35.9%
1 566
 
9.7%
( 430
 
7.4%
) 429
 
7.3%
2 356
 
6.1%
, 306
 
5.2%
3 281
 
4.8%
0 248
 
4.2%
5 209
 
3.6%
4 199
 
3.4%
Other values (6) 726
 
12.4%
Latin
ValueCountFrequency (%)
T 1
25.0%
K 1
25.0%
B 1
25.0%
A 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 8025
57.8%
ASCII 5853
42.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2099
35.9%
1 566
 
9.7%
( 430
 
7.3%
) 429
 
7.3%
2 356
 
6.1%
, 306
 
5.2%
3 281
 
4.8%
0 248
 
4.2%
5 209
 
3.6%
4 199
 
3.4%
Other values (10) 730
 
12.5%
Hangul
ValueCountFrequency (%)
대 798
 
9.9%
동 585
 
7.3%
전 546
 
6.8%
구 513
 
6.4%
광 502
 
6.3%
역 500
 
6.2%
시 500
 
6.2%
로 479
 
6.0%
길 284
 
3.5%
번 264
 
3.3%
Other values (212) 3054
38.1%

Interactions

2023-12-12T19:26:35.248366image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-12T19:26:35.394109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T19:26:35.499359image/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전기공사업주식회사 강중김은영대전광역시 유성구 송강로 15, 상가동 제지하층 제6호 (송강동, 한솔아파트)
12전기공사업주식회사 드림앤테크김석진대전광역시 서구 문정로90번길 21, 503호(탄방동,이노타워빌딩) (탄방동)
23전기공사업주식회사 경진전기윤철호대전광역시 중구 수침로91번길 39, 1층(태평동)
34전기공사업주식회사 대청에너지채수영대전광역시 대덕구 산업단지로87번길 82(신일동)
45전기공사업주식회사 대덕전업공사김종인대전광역시 유성구 교촌로 5
56전기공사업성림파워텍 주식회사장현기대전광역시 서구 신갈마로181번길 20, 102호 (갈마동)
67전기공사업주식회사 우성이앤씨홍상준대전광역시 중구 부사로32번길 52(부사동)
78전기공사업주식회사 신현이앤지강미정대전광역시 서구 도솔로 446 (탄방동)
89전기공사업신현전력(주)현석화대전광역시 서구 도솔로 446 (탄방동), 2층
910전기공사업명지전력 주식회사오명수대전광역시 중구 동서대로1273번길 17(태평동)
연번업종상호명대표자명소재지
490491전기공사업에이스기전(주)이정현대전광역시 중구 유등천동로324번길 58-3 (유천동)
491492전기공사업알디엠산업개발 주식회사이계혁대전광역시 중구 대종로 544, 102호 (선화동)
492493전기공사업대현전기건설 주식회사방선영대전광역시 대덕구 덕암북로96번길 58(덕암동)
493494전기공사업(주)원창전력김영만대전광역시 중구 문화로105번안길 15 (유천동)
494495전기공사업주식회사 위진전기통신강윤철대전광역시 대덕구 한밭대로 1011, 2층 (오정동)
495496전기공사업대광전업 주식회사신태호대전광역시 유성구 갑동로 71-1
496497전기공사업파인건설 주식회사이관근대전광역시 서구 둔산남로105번길 27 (둔산동)
497498전기공사업주식회사 에스알권순일대전광역시 유성구 노은로 174, 501호 (지족동, 도원프라자)
498499전기공사업보문 주식회사이종애대전광역시 유성구 죽동로 81 (죽동)
499500전기공사업주식회사 티에스하대용대전광역시 대덕구 대화로50번길 63, (대화동)