Overview

Dataset statistics

Number of variables5
Number of observations71
Missing cells3
Missing cells (%)0.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.0 KiB
Average record size in memory42.9 B

Variable types

Categorical2
Text2
DateTime1

Dataset

Description대전광역시 동구 대기배출시설 설치 사업장 현황으로 상호, 소재지, 업종, 종별 항목을 제공하오니, 참고하시기 바랍니다.
URLhttps://www.data.go.kr/data/15080651/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
상호 has 1 (1.4%) missing valuesMissing
소재지 has 1 (1.4%) missing valuesMissing
데이터기준일자 has 1 (1.4%) missing valuesMissing

Reproduction

Analysis started2023-12-12 03:09:00.217566
Analysis finished2023-12-12 03:09:00.942781
Duration0.73 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

종
Categorical

Distinct3
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size700.0 B
5
47 
4
23 
<NA>
 
1

Length

Max length4
Median length1
Mean length1.0422535
Min length1

Unique

Unique1 ?
Unique (%)1.4%

Sample

1st row4
2nd row5
3rd row4
4th row4
5th row4

Common Values

ValueCountFrequency (%)
5 47
66.2%
4 23
32.4%
<NA> 1
 
1.4%

Length

2023-12-12T12:09:01.021608image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T12:09:01.138124image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
5 47
66.2%
4 23
32.4%
na 1
 
1.4%

상호
Text

MISSING 

Distinct70
Distinct (%)100.0%
Missing1
Missing (%)1.4%
Memory size700.0 B
2023-12-12T12:09:01.414701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length15.5
Mean length8.9571429
Min length4

Characters and Unicode

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

Unique

Unique70 ?
Unique (%)100.0%

Sample

1st row현대자동차㈜대전하이테크센터
2nd row한밭자동차공업사
3rd row㈜원동자동차공업사검사소
4th row남부자동차공업㈜
5th row㈜예원테크
ValueCountFrequency (%)
주식회사 5
 
5.3%
주택관리공단㈜ 2
 
2.1%
우송대학교 2
 
2.1%
은진모터스 1
 
1.1%
솔브릿지 1
 
1.1%
동구재활용선별센터 1
 
1.1%
한마당식품 1
 
1.1%
대전고속버스터미널㈜ 1
 
1.1%
태전자동차공업사 1
 
1.1%
이안현대모터스 1
 
1.1%
Other values (78) 78
83.0%
2023-12-12T12:09:02.002432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
대 33
 
5.3%
사 28
 
4.5%
동 26
 
4.1%
25
 
4.0%
㈜ 24
 
3.8%
공 22
 
3.5%
업 21
 
3.3%
전 20
 
3.2%
스 20
 
3.2%
자 19
 
3.0%
Other values (163) 389
62.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 562
89.6%
Space Separator 25
 
4.0%
Other Symbol 24
 
3.8%
Decimal Number 6
 
1.0%
Uppercase Letter 4
 
0.6%
Close Punctuation 2
 
0.3%
Open Punctuation 2
 
0.3%
Other Punctuation 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
대 33
 
5.9%
사 28
 
5.0%
동 26
 
4.6%
공 22
 
3.9%
업 21
 
3.7%
전 20
 
3.6%
스 20
 
3.6%
자 19
 
3.4%
차 18
 
3.2%
터 16
 
2.8%
Other values (152) 339
60.3%
Decimal Number
ValueCountFrequency (%)
1 3
50.0%
3 1
 
16.7%
4 1
 
16.7%
2 1
 
16.7%
Uppercase Letter
ValueCountFrequency (%)
S 2
50.0%
J 2
50.0%
Space Separator
ValueCountFrequency (%)
25
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 24
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Other Punctuation
ValueCountFrequency (%)
, 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 586
93.5%
Common 37
 
5.9%
Latin 4
 
0.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
대 33
 
5.6%
사 28
 
4.8%
동 26
 
4.4%
㈜ 24
 
4.1%
공 22
 
3.8%
업 21
 
3.6%
전 20
 
3.4%
스 20
 
3.4%
자 19
 
3.2%
차 18
 
3.1%
Other values (153) 355
60.6%
Common
ValueCountFrequency (%)
25
67.6%
1 3
 
8.1%
) 2
 
5.4%
( 2
 
5.4%
, 2
 
5.4%
3 1
 
2.7%
4 1
 
2.7%
2 1
 
2.7%
Latin
ValueCountFrequency (%)
S 2
50.0%
J 2
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 562
89.6%
ASCII 41
 
6.5%
None 24
 
3.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
대 33
 
5.9%
사 28
 
5.0%
동 26
 
4.6%
공 22
 
3.9%
업 21
 
3.7%
전 20
 
3.6%
스 20
 
3.6%
자 19
 
3.4%
차 18
 
3.2%
터 16
 
2.8%
Other values (152) 339
60.3%
ASCII
ValueCountFrequency (%)
25
61.0%
1 3
 
7.3%
) 2
 
4.9%
S 2
 
4.9%
( 2
 
4.9%
, 2
 
4.9%
J 2
 
4.9%
3 1
 
2.4%
4 1
 
2.4%
2 1
 
2.4%
None
ValueCountFrequency (%)
㈜ 24
100.0%

소재지
Text

MISSING 

Distinct64
Distinct (%)91.4%
Missing1
Missing (%)1.4%
Memory size700.0 B
2023-12-12T12:09:02.326370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length33
Median length27
Mean length23.342857
Min length18

Characters and Unicode

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

Unique

Unique58 ?
Unique (%)82.9%

Sample

1st row대전광역시 동구 동대전로 271(가양동)
2nd row대전광역시 동구 산내로1352번길 15(낭월동)
3rd row대전광역시 동구 충무로209번길 81(원동)
4th row대전광역시 동구 옥천로 273, 1층(삼정동)
5th row대전광역시 동구 산내로560번길 131 (상소동)
ValueCountFrequency (%)
대전광역시 70
23.3%
동구 70
23.3%
옥천로 9
 
3.0%
대전로 7
 
2.3%
판암동 5
 
1.7%
동대전로 3
 
1.0%
물류로14번길 3
 
1.0%
273 3
 
1.0%
산내로 3
 
1.0%
상소동 3
 
1.0%
Other values (104) 125
41.5%
2023-12-12T12:09:02.802372image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
231
 
14.1%
동 149
 
9.1%
대 104
 
6.4%
전 85
 
5.2%
구 78
 
4.8%
광 70
 
4.3%
역 70
 
4.3%
시 70
 
4.3%
로 67
 
4.1%
( 66
 
4.0%
Other values (73) 644
39.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 964
59.0%
Decimal Number 278
 
17.0%
Space Separator 231
 
14.1%
Open Punctuation 66
 
4.0%
Close Punctuation 66
 
4.0%
Dash Punctuation 20
 
1.2%
Other Punctuation 8
 
0.5%
Uppercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 149
15.5%
대 104
10.8%
전 85
 
8.8%
구 78
 
8.1%
광 70
 
7.3%
역 70
 
7.3%
시 70
 
7.3%
로 67
 
7.0%
번 23
 
2.4%
길 21
 
2.2%
Other values (56) 227
23.5%
Decimal Number
ValueCountFrequency (%)
1 55
19.8%
2 44
15.8%
7 37
13.3%
5 27
9.7%
6 24
8.6%
4 23
8.3%
0 22
 
7.9%
8 18
 
6.5%
3 17
 
6.1%
9 11
 
4.0%
Other Punctuation
ValueCountFrequency (%)
, 7
87.5%
· 1
 
12.5%
Space Separator
ValueCountFrequency (%)
231
100.0%
Open Punctuation
ValueCountFrequency (%)
( 66
100.0%
Close Punctuation
ValueCountFrequency (%)
) 66
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 20
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 964
59.0%
Common 669
40.9%
Latin 1
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 149
15.5%
대 104
10.8%
전 85
 
8.8%
구 78
 
8.1%
광 70
 
7.3%
역 70
 
7.3%
시 70
 
7.3%
로 67
 
7.0%
번 23
 
2.4%
길 21
 
2.2%
Other values (56) 227
23.5%
Common
ValueCountFrequency (%)
231
34.5%
( 66
 
9.9%
) 66
 
9.9%
1 55
 
8.2%
2 44
 
6.6%
7 37
 
5.5%
5 27
 
4.0%
6 24
 
3.6%
4 23
 
3.4%
0 22
 
3.3%
Other values (6) 74
 
11.1%
Latin
ValueCountFrequency (%)
A 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 964
59.0%
ASCII 669
40.9%
None 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
231
34.5%
( 66
 
9.9%
) 66
 
9.9%
1 55
 
8.2%
2 44
 
6.6%
7 37
 
5.5%
5 27
 
4.0%
6 24
 
3.6%
4 23
 
3.4%
0 22
 
3.3%
Other values (6) 74
 
11.1%
Hangul
ValueCountFrequency (%)
동 149
15.5%
대 104
10.8%
전 85
 
8.8%
구 78
 
8.1%
광 70
 
7.3%
역 70
 
7.3%
시 70
 
7.3%
로 67
 
7.0%
번 23
 
2.4%
길 21
 
2.2%
Other values (56) 227
23.5%
None
ValueCountFrequency (%)
· 1
100.0%

업종
Categorical

Distinct33
Distinct (%)46.5%
Missing0
Missing (%)0.0%
Memory size700.0 B
정비공장
20 
자동차종합수리업
9 
교육서비스업
4 
서비스업
 
3
아파트
 
3
Other values (28)
32 

Length

Max length28
Median length21
Mean length6.3239437
Min length3

Unique

Unique24 ?
Unique (%)33.8%

Sample

1st row정비공장
2nd row정비공장
3rd row정비공장
4th row정비공장
5th row간판제조

Common Values

ValueCountFrequency (%)
정비공장 20
28.2%
자동차종합수리업 9
 
12.7%
교육서비스업 4
 
5.6%
서비스업 3
 
4.2%
아파트 3
 
4.2%
욕탕업 2
 
2.8%
대형마트 2
 
2.8%
자동차 정비 2
 
2.8%
건설폐기물중간처리업 2
 
2.8%
전자부품 제조업 1
 
1.4%
Other values (23) 23
32.4%

Length

2023-12-12T12:09:02.949329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
정비공장 20
20.0%
자동차종합수리업 9
 
9.0%
교육서비스업 4
 
4.0%
및 4
 
4.0%
제조업 4
 
4.0%
서비스업 3
 
3.0%
아파트 3
 
3.0%
자동차 3
 
3.0%
기타 3
 
3.0%
욕탕업 2
 
2.0%
Other values (42) 45
45.0%

데이터기준일자
Date

CONSTANT  MISSING 

Distinct1
Distinct (%)1.4%
Missing1
Missing (%)1.4%
Memory size700.0 B
Minimum2023-08-04 00:00:00
Maximum2023-08-04 00:00:00
2023-12-12T12:09:03.055913image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T12:09:03.491826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-12T12:09:03.578364image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
종상호소재지업종
종1.0001.0000.2120.614
상호1.0001.0001.0001.000
소재지0.2121.0001.0000.990
업종0.6141.0000.9901.000
2023-12-12T12:09:03.689432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종종
업종1.0000.362
종0.3621.000
2023-12-12T12:09:03.789819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
종업종
종1.0000.362
업종0.3621.000

Missing values

2023-12-12T12:09:00.613208image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T12:09:00.729656image/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.
2023-12-12T12:09:00.863172image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

종상호소재지업종데이터기준일자
04현대자동차㈜대전하이테크센터대전광역시 동구 동대전로 271(가양동)정비공장2023-08-04
15한밭자동차공업사대전광역시 동구 산내로1352번길 15(낭월동)정비공장2023-08-04
24㈜원동자동차공업사검사소대전광역시 동구 충무로209번길 81(원동)정비공장2023-08-04
34남부자동차공업㈜대전광역시 동구 옥천로 273, 1층(삼정동)정비공장2023-08-04
44㈜예원테크대전광역시 동구 산내로560번길 131 (상소동)간판제조2023-08-04
55대성프라스틱대전광역시 동구 산내로560번길 26 (상소동)고무 및 플라스틱제품제조2023-08-04
64동명자동차공업사대전광역시 동구 옥천로 235(판암동)정비공장2023-08-04
75피니사르대전유한회사대전광역시 동구 새울로 41, 1층(판암동)반도체및기타전자부품제조시설2023-08-04
85팔도기업대전광역시 동구 산내로400번길 150(상소동)공통시설2023-08-04
95㈜고속모터스대전광역시 동구 합내로 73(가양동)정비공장2023-08-04
종상호소재지업종데이터기준일자
614홈플러스㈜ 대전가오점대전광역시 동구 은어송로 72(가오동)대형마트2023-08-04
625화이트씽크대대전광역시 동구 안골로28번길 15-8(구도동)기타 목재 가구 제조업2023-08-04
635새빛기업㈜대전광역시 동구 대전로 277-20(대성동)폐기물중간재활용업2023-08-04
645라움퍼니처대전광역시 동구 물류로14번길 91-5(구도동)주방용 및 음식점용 목재가구 제조업2023-08-04
655현대모터스대전광역시 동구 판암동 428번지자동차 정비2023-08-04
664㈜이마트 대전터미널점대전광역시 동구 동서대로 1689(용전동)대형마트2023-08-04
675은진모터스대전광역시 동구 판암동 420-4자동차종합수리업2023-08-04
685대전고속버스터미널㈜대전광역시 동구 동서대로 1689(용전동)서비스업2023-08-04
695제이에스(JS)모터스대전광역시 동구 용운동 342-2번지 외 2필지자동차종합수리업2023-08-04
70<NA><NA><NA><NA><NA>