Overview

Dataset statistics

Number of variables6
Number of observations291
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory14.1 KiB
Average record size in memory49.5 B

Variable types

Numeric1
Categorical3
Text2

Dataset

Description광주광역시 관내에서 영업중인 건설기계사업자 개별 영업상태, 상호(명칭), 사업유형, 등록종별, 주소에 대한 정보입니다
URLhttps://www.data.go.kr/data/15113673/fileData.do

Alerts

상태 has constant value ""Constant
등록종별 is highly overall correlated with 사업유형High correlation
사업유형 is highly overall correlated with 순번 and 1 other fieldsHigh correlation
순번 is highly overall correlated with 사업유형High correlation
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 08:38:58.502902
Analysis finished2023-12-12 08:38:59.188291
Duration0.69 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct291
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean146
Minimum1
Maximum291
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.7 KiB
2023-12-12T17:38:59.283856image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile15.5
Q173.5
median146
Q3218.5
95-th percentile276.5
Maximum291
Range290
Interquartile range (IQR)145

Descriptive statistics

Standard deviation84.148678
Coefficient of variation (CV)0.57636081
Kurtosis-1.2
Mean146
Median Absolute Deviation (MAD)73
Skewness0
Sum42486
Variance7081
MonotonicityStrictly increasing
2023-12-12T17:38:59.506391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.3%
184 1
 
0.3%
200 1
 
0.3%
199 1
 
0.3%
198 1
 
0.3%
197 1
 
0.3%
196 1
 
0.3%
195 1
 
0.3%
194 1
 
0.3%
193 1
 
0.3%
Other values (281) 281
96.6%
ValueCountFrequency (%)
1 1
0.3%
2 1
0.3%
3 1
0.3%
4 1
0.3%
5 1
0.3%
6 1
0.3%
7 1
0.3%
8 1
0.3%
9 1
0.3%
10 1
0.3%
ValueCountFrequency (%)
291 1
0.3%
290 1
0.3%
289 1
0.3%
288 1
0.3%
287 1
0.3%
286 1
0.3%
285 1
0.3%
284 1
0.3%
283 1
0.3%
282 1
0.3%

상태
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
영업
291 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
영업 291
100.0%

Length

2023-12-12T17:38:59.739199image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:38:59.882757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업 291
100.0%

상호(명칭)
Text

Distinct274
Distinct (%)94.2%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
2023-12-12T17:39:00.144944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length14
Mean length8.2302405
Min length3

Characters and Unicode

Total characters2395
Distinct characters217
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

Unique259 ?
Unique (%)89.0%

Sample

1st row공영중기(주)
2nd row(유)금호중기
3rd row(주)대운종합중기
4th row(주)대신중기
5th row(주)대우중기
ValueCountFrequency (%)
주식회사 14
 
4.4%
유한회사 5
 
1.6%
주)강성지게차 3
 
0.9%
전남판매두산중장비(주 3
 
0.9%
현대지게차 3
 
0.9%
두산지게차 3
 
0.9%
유)강산중장비 2
 
0.6%
동경메카트로닉스(주 2
 
0.6%
전남판매(주 2
 
0.6%
주)제이에이치건설중기 2
 
0.6%
Other values (273) 282
87.9%
2023-12-12T17:39:00.583320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 169
 
7.1%
기 164
 
6.8%
) 163
 
6.8%
( 162
 
6.8%
매 115
 
4.8%
중 114
 
4.8%
사 89
 
3.7%
건 81
 
3.4%
상 58
 
2.4%
설 57
 
2.4%
Other values (207) 1223
51.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2020
84.3%
Close Punctuation 163
 
6.8%
Open Punctuation 162
 
6.8%
Space Separator 30
 
1.3%
Uppercase Letter 12
 
0.5%
Lowercase Letter 4
 
0.2%
Other Punctuation 2
 
0.1%
Decimal Number 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 169
 
8.4%
기 164
 
8.1%
매 115
 
5.7%
중 114
 
5.6%
사 89
 
4.4%
건 81
 
4.0%
상 58
 
2.9%
설 57
 
2.8%
계 43
 
2.1%
산 39
 
1.9%
Other values (187) 1091
54.0%
Uppercase Letter
ValueCountFrequency (%)
O 2
16.7%
M 2
16.7%
C 1
8.3%
R 1
8.3%
T 1
8.3%
G 1
8.3%
N 1
8.3%
E 1
8.3%
K 1
8.3%
S 1
8.3%
Lowercase Letter
ValueCountFrequency (%)
o 1
25.0%
e 1
25.0%
n 1
25.0%
p 1
25.0%
Decimal Number
ValueCountFrequency (%)
0 1
50.0%
4 1
50.0%
Close Punctuation
ValueCountFrequency (%)
) 163
100.0%
Open Punctuation
ValueCountFrequency (%)
( 162
100.0%
Space Separator
ValueCountFrequency (%)
30
100.0%
Other Punctuation
ValueCountFrequency (%)
. 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2020
84.3%
Common 359
 
15.0%
Latin 16
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 169
 
8.4%
기 164
 
8.1%
매 115
 
5.7%
중 114
 
5.6%
사 89
 
4.4%
건 81
 
4.0%
상 58
 
2.9%
설 57
 
2.8%
계 43
 
2.1%
산 39
 
1.9%
Other values (187) 1091
54.0%
Latin
ValueCountFrequency (%)
O 2
12.5%
M 2
12.5%
C 1
 
6.2%
R 1
 
6.2%
o 1
 
6.2%
T 1
 
6.2%
e 1
 
6.2%
n 1
 
6.2%
G 1
 
6.2%
N 1
 
6.2%
Other values (4) 4
25.0%
Common
ValueCountFrequency (%)
) 163
45.4%
( 162
45.1%
30
 
8.4%
. 2
 
0.6%
0 1
 
0.3%
4 1
 
0.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2020
84.3%
ASCII 375
 
15.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 169
 
8.4%
기 164
 
8.1%
매 115
 
5.7%
중 114
 
5.6%
사 89
 
4.4%
건 81
 
4.0%
상 58
 
2.9%
설 57
 
2.8%
계 43
 
2.1%
산 39
 
1.9%
Other values (187) 1091
54.0%
ASCII
ValueCountFrequency (%)
) 163
43.5%
( 162
43.2%
30
 
8.0%
O 2
 
0.5%
M 2
 
0.5%
. 2
 
0.5%
0 1
 
0.3%
4 1
 
0.3%
C 1
 
0.3%
R 1
 
0.3%
Other values (10) 10
 
2.7%

사업유형
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
대여업
131 
매매업
87 
정비업
64 
해체재활용업
 
7
등록번호제작자
 
2

Length

Max length7
Median length3
Mean length3.0996564
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대여업
2nd row대여업
3rd row대여업
4th row대여업
5th row대여업

Common Values

ValueCountFrequency (%)
대여업 131
45.0%
매매업 87
29.9%
정비업 64
22.0%
해체재활용업 7
 
2.4%
등록번호제작자 2
 
0.7%

Length

2023-12-12T17:39:00.750027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:39:00.885296image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대여업 131
45.0%
매매업 87
29.9%
정비업 64
22.0%
해체재활용업 7
 
2.4%
등록번호제작자 2
 
0.7%

등록종별
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
일반
111 
<NA>
96 
종합(덤프 및 믹서트럭)
27 
개별
20 
부분(일반)
17 
Other values (4)
20 

Length

Max length19
Median length13
Mean length4.4398625
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일반
2nd row일반
3rd row일반
4th row일반
5th row일반

Common Values

ValueCountFrequency (%)
일반 111
38.1%
<NA> 96
33.0%
종합(덤프 및 믹서트럭) 27
 
9.3%
개별 20
 
6.9%
부분(일반) 17
 
5.8%
전문(유압) 7
 
2.4%
종합(전기종) 5
 
1.7%
부분(일반및 덤프,믹서트럭은 종합) 5
 
1.7%
종합(지게차) 3
 
1.0%

Length

2023-12-12T17:39:01.015306image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T17:39:01.166146image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반 111
31.3%
na 96
27.0%
종합(덤프 27
 
7.6%
및 27
 
7.6%
믹서트럭 27
 
7.6%
개별 20
 
5.6%
부분(일반 17
 
4.8%
전문(유압 7
 
2.0%
종합(전기종 5
 
1.4%
부분(일반및 5
 
1.4%
Other values (3) 13
 
3.7%

주소
Text

Distinct234
Distinct (%)80.4%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
2023-12-12T17:39:01.566716image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length52
Median length41
Mean length27.292096
Min length18

Characters and Unicode

Total characters7942
Distinct characters180
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

Unique197 ?
Unique (%)67.7%

Sample

1st row광주광역시 북구 무등로127번길 21-4(신안동)
2nd row광주광역시 서구 매월2로15번길 16, 201동 215호(매월동, 매월종합상가)
3rd row광주광역시 동구 제봉로222번길 6-12, (대인동)
4th row광주광역시 서구 매월2로15번길 16, 매월종합상가 201동 210호
5th row광주광역시 북구 중가로 107(중흥동)
ValueCountFrequency (%)
광주광역시 291
21.4%
광산구 139
 
10.2%
서구 56
 
4.1%
남구 46
 
3.4%
북구 46
 
3.4%
동곡로 19
 
1.4%
매월2로15번길 18
 
1.3%
16 17
 
1.2%
매월종합상가 15
 
1.1%
송암로 15
 
1.1%
Other values (458) 698
51.3%
2023-12-12T17:39:02.166373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1069
 
13.5%
광 726
 
9.1%
동 392
 
4.9%
주 294
 
3.7%
역 291
 
3.7%
시 291
 
3.7%
구 291
 
3.7%
1 285
 
3.6%
( 274
 
3.5%
) 274
 
3.5%
Other values (170) 3755
47.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4700
59.2%
Decimal Number 1407
 
17.7%
Space Separator 1069
 
13.5%
Open Punctuation 274
 
3.5%
Close Punctuation 274
 
3.5%
Other Punctuation 128
 
1.6%
Dash Punctuation 90
 
1.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 726
15.4%
동 392
 
8.3%
주 294
 
6.3%
역 291
 
6.2%
시 291
 
6.2%
구 291
 
6.2%
로 258
 
5.5%
산 190
 
4.0%
길 136
 
2.9%
번 115
 
2.4%
Other values (155) 1716
36.5%
Decimal Number
ValueCountFrequency (%)
1 285
20.3%
2 253
18.0%
0 170
12.1%
3 135
9.6%
6 121
8.6%
5 117
8.3%
4 111
 
7.9%
7 80
 
5.7%
8 72
 
5.1%
9 63
 
4.5%
Space Separator
ValueCountFrequency (%)
1069
100.0%
Open Punctuation
ValueCountFrequency (%)
( 274
100.0%
Close Punctuation
ValueCountFrequency (%)
) 274
100.0%
Other Punctuation
ValueCountFrequency (%)
, 128
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 90
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4700
59.2%
Common 3242
40.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 726
15.4%
동 392
 
8.3%
주 294
 
6.3%
역 291
 
6.2%
시 291
 
6.2%
구 291
 
6.2%
로 258
 
5.5%
산 190
 
4.0%
길 136
 
2.9%
번 115
 
2.4%
Other values (155) 1716
36.5%
Common
ValueCountFrequency (%)
1069
33.0%
1 285
 
8.8%
( 274
 
8.5%
) 274
 
8.5%
2 253
 
7.8%
0 170
 
5.2%
3 135
 
4.2%
, 128
 
3.9%
6 121
 
3.7%
5 117
 
3.6%
Other values (5) 416
 
12.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4700
59.2%
ASCII 3242
40.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1069
33.0%
1 285
 
8.8%
( 274
 
8.5%
) 274
 
8.5%
2 253
 
7.8%
0 170
 
5.2%
3 135
 
4.2%
, 128
 
3.9%
6 121
 
3.7%
5 117
 
3.6%
Other values (5) 416
 
12.8%
Hangul
ValueCountFrequency (%)
광 726
15.4%
동 392
 
8.3%
주 294
 
6.3%
역 291
 
6.2%
시 291
 
6.2%
구 291
 
6.2%
로 258
 
5.5%
산 190
 
4.0%
길 136
 
2.9%
번 115
 
2.4%
Other values (155) 1716
36.5%

Interactions

2023-12-12T17:38:58.834982image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T17:39:02.288987image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번사업유형등록종별
순번1.0000.8550.586
사업유형0.8551.0001.000
등록종별0.5861.0001.000
2023-12-12T17:39:02.395540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
등록종별사업유형
등록종별1.0000.984
사업유형0.9841.000
2023-12-12T17:39:02.502332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번사업유형등록종별
순번1.0000.5170.343
사업유형0.5171.0000.984
등록종별0.3430.9841.000

Missing values

2023-12-12T17:38:58.989106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T17:38:59.135052image/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영업공영중기(주)대여업일반광주광역시 북구 무등로127번길 21-4(신안동)
12영업(유)금호중기대여업일반광주광역시 서구 매월2로15번길 16, 201동 215호(매월동, 매월종합상가)
23영업(주)대운종합중기대여업일반광주광역시 동구 제봉로222번길 6-12, (대인동)
34영업(주)대신중기대여업일반광주광역시 서구 매월2로15번길 16, 매월종합상가 201동 210호
45영업(주)대우중기대여업일반광주광역시 북구 중가로 107(중흥동)
56영업동산중기(주)대여업일반광주광역시 서구 금호운천길 80-3(쌍촌동)
67영업(유)남도중기대여업일반광주광역시 남구 서동로 29(월산동)
78영업(주)전일중기대여업일반광주광역시 북구 평교로30번길 17, 2층(문흥동)
89영업영풍펌프카대여업일반광주광역시 북구 저불로 52(용봉동)
910영업(주)무등중기대여업일반광주광역시 서구 매월2로15번길 16, 105동 210호(매월동, 매월종합상가)
순번상태상호(명칭)사업유형등록종별주소
281282영업푸른중기매매상사매매업<NA>광주광역시 광산구 임방울대로 611-20(도천동)
282283영업진영중기매매상사매매업<NA>광주광역시 광산구 동곡로 430, 103호(월전동)
283284영업가야중기매매상사매매업<NA>광주광역시 광산구 임방울대로 611-20(도천동)
284285영업유진건설기계매매상사매매업<NA>광주광역시 광산구 임방울대로825번길 60-26, 810호(쌍암동)
285286영업탑건설매매상사매매업<NA>광주광역시 광산구 동곡로 430(월전동)
286287영업(주)광주중기매매상사매매업<NA>광주광역시 광산구 삼도세동길 9-9(송산동)
287288영업이호중기 무역상사매매업<NA>광주광역시 광산구 상무대로 521(우산동)
288289영업덕산ENG매매업<NA>광주광역시 광산구 동곡로 845-2(운수동)
289290영업유한회사 현대지게차종합센타매매업<NA>광주광역시 광산구 사암로 846-2(도천동)
290291영업원탑(One Top) 크레인매매업<NA>광주광역시 광산구 북문대로420번길 106(신창동)