Overview

Dataset statistics

Number of variables5
Number of observations133
Missing cells0
Missing cells (%)0.0%
Duplicate rows1
Duplicate rows (%)0.8%
Total size in memory5.3 KiB
Average record size in memory41.0 B

Variable types

DateTime1
Categorical2
Text2

Dataset

Description대구광역시 서구_행정처분업소 현황_20240208
Author대구광역시 서구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=3054454&dataSetDetailId=3054454182bcaf4b68e7&provdMethod=FILE

Alerts

Dataset has 1 (0.8%) duplicate rowsDuplicates

Reproduction

Analysis started2024-03-13 14:14:50.764198
Analysis finished2024-03-13 14:14:51.515869
Duration0.75 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

처분일자
Date

Distinct84
Distinct (%)63.2%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
Minimum2023-02-09 00:00:00
Maximum2024-02-05 00:00:00
2024-03-13T23:14:51.579787image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T23:14:51.709574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

업종명
Categorical

Distinct19
Distinct (%)14.3%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
일반음식점
40 
인터넷컴퓨터게임시설제공업
18 
휴게음식점
13 
노래연습장업
11 
일반게임제공업
11 
Other values (14)
40 

Length

Max length13
Median length11
Mean length6.9473684
Min length4

Unique

Unique4 ?
Unique (%)3.0%

Sample

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

Common Values

ValueCountFrequency (%)
일반음식점 40
30.1%
인터넷컴퓨터게임시설제공업 18
13.5%
휴게음식점 13
 
9.8%
노래연습장업 11
 
8.3%
일반게임제공업 11
 
8.3%
즉석판매제조가공업 7
 
5.3%
청소년게임제공업 6
 
4.5%
목욕장업 5
 
3.8%
숙박업(일반) 4
 
3.0%
식품제조가공업 4
 
3.0%
Other values (9) 14
 
10.5%

Length

2024-03-13T23:14:51.892701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
일반음식점 40
30.1%
인터넷컴퓨터게임시설제공업 18
13.5%
휴게음식점 13
 
9.8%
노래연습장업 11
 
8.3%
일반게임제공업 11
 
8.3%
즉석판매제조가공업 7
 
5.3%
청소년게임제공업 6
 
4.5%
목욕장업 5
 
3.8%
식품제조가공업 4
 
3.0%
숙박업(일반 4
 
3.0%
Other values (9) 14
 
10.5%

업소명
Text

Distinct115
Distinct (%)86.5%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2024-03-13T23:14:52.211655image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length9
Mean length5.7443609
Min length1

Characters and Unicode

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

Unique

Unique106 ?
Unique (%)79.7%

Sample

1st row거송생고기
2nd row뼈나루감자탕
3rd row뼈큰감자탕 내당점
4th row정하용선산곱창
5th row노벨치킨
ValueCountFrequency (%)
파도게임랜드 5
 
3.4%
태영목욕탕 5
 
3.4%
뉴트리디언 4
 
2.8%
양지 3
 
2.1%
봄봄성인오락실 2
 
1.4%
겜블pc 2
 
1.4%
독도노래연습장 2
 
1.4%
부초식당 2
 
1.4%
금전수성인오락실 2
 
1.4%
세븐 1
 
0.7%
Other values (117) 117
80.7%
2024-03-13T23:14:52.723711image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
C 20
 
2.6%
P 18
 
2.4%
이 16
 
2.1%
장 15
 
2.0%
노 14
 
1.8%
점 13
 
1.7%
스 13
 
1.7%
12
 
1.6%
연 12
 
1.6%
래 12
 
1.6%
Other values (255) 619
81.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 658
86.1%
Uppercase Letter 64
 
8.4%
Space Separator 12
 
1.6%
Decimal Number 10
 
1.3%
Close Punctuation 7
 
0.9%
Open Punctuation 7
 
0.9%
Other Punctuation 3
 
0.4%
Lowercase Letter 2
 
0.3%
Dash Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
이 16
 
2.4%
장 15
 
2.3%
노 14
 
2.1%
점 13
 
2.0%
스 13
 
2.0%
연 12
 
1.8%
래 12
 
1.8%
습 11
 
1.7%
리 10
 
1.5%
오 10
 
1.5%
Other values (224) 532
80.9%
Uppercase Letter
ValueCountFrequency (%)
C 20
31.2%
P 18
28.1%
A 4
 
6.2%
E 4
 
6.2%
K 2
 
3.1%
S 2
 
3.1%
B 2
 
3.1%
M 2
 
3.1%
G 2
 
3.1%
F 2
 
3.1%
Other values (6) 6
 
9.4%
Decimal Number
ValueCountFrequency (%)
2 3
30.0%
0 2
20.0%
4 2
20.0%
5 1
 
10.0%
8 1
 
10.0%
7 1
 
10.0%
Other Punctuation
ValueCountFrequency (%)
& 1
33.3%
, 1
33.3%
? 1
33.3%
Lowercase Letter
ValueCountFrequency (%)
n 1
50.0%
u 1
50.0%
Space Separator
ValueCountFrequency (%)
12
100.0%
Close Punctuation
ValueCountFrequency (%)
) 7
100.0%
Open Punctuation
ValueCountFrequency (%)
( 7
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 658
86.1%
Latin 66
 
8.6%
Common 40
 
5.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
이 16
 
2.4%
장 15
 
2.3%
노 14
 
2.1%
점 13
 
2.0%
스 13
 
2.0%
연 12
 
1.8%
래 12
 
1.8%
습 11
 
1.7%
리 10
 
1.5%
오 10
 
1.5%
Other values (224) 532
80.9%
Latin
ValueCountFrequency (%)
C 20
30.3%
P 18
27.3%
A 4
 
6.1%
E 4
 
6.1%
K 2
 
3.0%
S 2
 
3.0%
B 2
 
3.0%
M 2
 
3.0%
G 2
 
3.0%
F 2
 
3.0%
Other values (8) 8
 
12.1%
Common
ValueCountFrequency (%)
12
30.0%
) 7
17.5%
( 7
17.5%
2 3
 
7.5%
0 2
 
5.0%
4 2
 
5.0%
& 1
 
2.5%
, 1
 
2.5%
? 1
 
2.5%
- 1
 
2.5%
Other values (3) 3
 
7.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 658
86.1%
ASCII 106
 
13.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
C 20
18.9%
P 18
17.0%
12
11.3%
) 7
 
6.6%
( 7
 
6.6%
A 4
 
3.8%
E 4
 
3.8%
2 3
 
2.8%
0 2
 
1.9%
K 2
 
1.9%
Other values (21) 27
25.5%
Hangul
ValueCountFrequency (%)
이 16
 
2.4%
장 15
 
2.3%
노 14
 
2.1%
점 13
 
2.0%
스 13
 
2.0%
연 12
 
1.8%
래 12
 
1.8%
습 11
 
1.7%
리 10
 
1.5%
오 10
 
1.5%
Other values (224) 532
80.9%

소재지(도로명)
Text

Distinct114
Distinct (%)85.7%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2024-03-13T23:14:53.048178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length44
Median length36
Mean length26.578947
Min length21

Characters and Unicode

Total characters3535
Distinct characters81
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

Unique105 ?
Unique (%)78.9%

Sample

1st row대구광역시 서구 달서천로 422, 1층 (원대동1가)
2nd row대구광역시 서구 달서로 249 (비산동)
3rd row대구광역시 서구 서대구로 54 (내당동)
4th row대구광역시 서구 서대구로62길 96-1 (비산동)
5th row대구광역시 서구 서대구로62길 74, 1층 (비산동)
ValueCountFrequency (%)
대구광역시 133
17.7%
서구 133
17.7%
비산동 54
 
7.2%
1층 41
 
5.5%
평리동 36
 
4.8%
내당동 24
 
3.2%
서대구로 20
 
2.7%
달서로 13
 
1.7%
국채보상로 11
 
1.5%
서대구로62길 11
 
1.5%
Other values (167) 275
36.6%
2024-03-13T23:14:53.597602image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
618
17.5%
구 309
 
8.7%
서 201
 
5.7%
대 184
 
5.2%
광 134
 
3.8%
( 133
 
3.8%
역 133
 
3.8%
시 133
 
3.8%
로 133
 
3.8%
) 133
 
3.8%
Other values (71) 1424
40.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2012
56.9%
Space Separator 618
 
17.5%
Decimal Number 570
 
16.1%
Open Punctuation 133
 
3.8%
Close Punctuation 133
 
3.8%
Other Punctuation 41
 
1.2%
Dash Punctuation 26
 
0.7%
Uppercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 309
15.4%
서 201
 
10.0%
대 184
 
9.1%
광 134
 
6.7%
역 133
 
6.6%
시 133
 
6.6%
로 133
 
6.6%
동 133
 
6.6%
산 61
 
3.0%
층 60
 
3.0%
Other values (54) 531
26.4%
Decimal Number
ValueCountFrequency (%)
1 133
23.3%
2 86
15.1%
3 65
11.4%
5 54
9.5%
6 51
 
8.9%
4 49
 
8.6%
0 39
 
6.8%
7 35
 
6.1%
8 33
 
5.8%
9 25
 
4.4%
Uppercase Letter
ValueCountFrequency (%)
M 1
50.0%
E 1
50.0%
Space Separator
ValueCountFrequency (%)
618
100.0%
Open Punctuation
ValueCountFrequency (%)
( 133
100.0%
Close Punctuation
ValueCountFrequency (%)
) 133
100.0%
Other Punctuation
ValueCountFrequency (%)
, 41
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 26
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2012
56.9%
Common 1521
43.0%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 309
15.4%
서 201
 
10.0%
대 184
 
9.1%
광 134
 
6.7%
역 133
 
6.6%
시 133
 
6.6%
로 133
 
6.6%
동 133
 
6.6%
산 61
 
3.0%
층 60
 
3.0%
Other values (54) 531
26.4%
Common
ValueCountFrequency (%)
618
40.6%
( 133
 
8.7%
) 133
 
8.7%
1 133
 
8.7%
2 86
 
5.7%
3 65
 
4.3%
5 54
 
3.6%
6 51
 
3.4%
4 49
 
3.2%
, 41
 
2.7%
Other values (5) 158
 
10.4%
Latin
ValueCountFrequency (%)
M 1
50.0%
E 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2012
56.9%
ASCII 1523
43.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
618
40.6%
( 133
 
8.7%
) 133
 
8.7%
1 133
 
8.7%
2 86
 
5.6%
3 65
 
4.3%
5 54
 
3.5%
6 51
 
3.3%
4 49
 
3.2%
, 41
 
2.7%
Other values (7) 160
 
10.5%
Hangul
ValueCountFrequency (%)
구 309
15.4%
서 201
 
10.0%
대 184
 
9.1%
광 134
 
6.7%
역 133
 
6.6%
시 133
 
6.6%
로 133
 
6.6%
동 133
 
6.6%
산 61
 
3.0%
층 60
 
3.0%
Other values (54) 531
26.4%

처분명
Categorical

Distinct9
Distinct (%)6.8%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
과징금부과
31 
영업정지
28 
과태료부과
26 
직권말소
22 
시정명령
12 
Other values (4)
14 

Length

Max length5
Median length4
Mean length4.3834586
Min length2

Unique

Unique2 ?
Unique (%)1.5%

Sample

1st row직권말소
2nd row시정명령
3rd row과징금부과
4th row과태료부과
5th row과징금부과

Common Values

ValueCountFrequency (%)
과징금부과 31
23.3%
영업정지 28
21.1%
과태료부과 26
19.5%
직권말소 22
16.5%
시정명령 12
 
9.0%
영업소폐쇄 6
 
4.5%
경고 6
 
4.5%
개선명령 1
 
0.8%
허가취소 1
 
0.8%

Length

2024-03-13T23:14:53.747660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T23:14:53.882037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
과징금부과 31
23.3%
영업정지 28
21.1%
과태료부과 26
19.5%
직권말소 22
16.5%
시정명령 12
 
9.0%
영업소폐쇄 6
 
4.5%
경고 6
 
4.5%
개선명령 1
 
0.8%
허가취소 1
 
0.8%

Correlations

2024-03-13T23:14:53.988630image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
처분일자업종명처분명
처분일자1.0000.0000.878
업종명0.0001.0000.672
처분명0.8780.6721.000
2024-03-13T23:14:54.083383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
처분명업종명
처분명1.0000.323
업종명0.3231.000
2024-03-13T23:14:54.164896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종명처분명
업종명1.0000.323
처분명0.3231.000

Missing values

2024-03-13T23:14:51.391780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T23:14:51.480527image/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

처분일자업종명업소명소재지(도로명)처분명
02023-02-09일반음식점거송생고기대구광역시 서구 달서천로 422, 1층 (원대동1가)직권말소
12023-05-16일반음식점뼈나루감자탕대구광역시 서구 달서로 249 (비산동)시정명령
22023-11-27일반음식점뼈큰감자탕 내당점대구광역시 서구 서대구로 54 (내당동)과징금부과
32023-02-16일반음식점정하용선산곱창대구광역시 서구 서대구로62길 96-1 (비산동)과태료부과
42023-04-11일반음식점노벨치킨대구광역시 서구 서대구로62길 74, 1층 (비산동)과징금부과
52023-04-05일반음식점대원명가대구광역시 서구 고성로 105-1 (원대동3가)과태료부과
62023-04-04일반음식점덕만이 국수집대구광역시 서구 달서천로53길 49 (비산동)과징금부과
72023-11-09일반음식점막창하우스대구광역시 서구 평리로 422 (내당동)영업정지
82023-10-31일반음식점요리왕대구광역시 서구 통학로 156 (평리동)시정명령
92023-07-31일반음식점화이트하우스대구광역시 서구 통학로 171 (평리동)시정명령
처분일자업종명업소명소재지(도로명)처분명
1232023-04-14노래연습장업연다라노래연습장대구광역시 서구 서대구로 180 (평리동 1086-1)영업정지
1242023-04-14일반게임제공업금전수성인오락실대구광역시 서구 국채보상로 168 (중리동)과징금부과
1252023-03-31인터넷컴퓨터게임시설제공업챔피언PC대구광역시 서구 문화로 215 (평리동)영업정지
1262023-07-05인터넷컴퓨터게임시설제공업nuPC대구광역시 서구 서대구로 86 (평리동)과징금부과
1272023-03-16인터넷컴퓨터게임시설제공업이노스페이스 비산점대구광역시 서구 달서천로57길 43 (비산동)과징금부과
1282023-03-08노래연습장업동경 노래연습장대구광역시 서구 평리로 419 지하1층 (비산동)영업정지
1292023-03-03노래연습장업비젼노래연습장대구광역시 서구 달서로 103 지하1층 (비산동)영업정지
1302023-07-04일반게임제공업대영성인오락실대구광역시 서구 달서로 50 2층 (내당동)허가취소
1312023-03-27일반게임제공업금전수성인오락실대구광역시 서구 국채보상로 168 (중리동)과징금부과
1322024-02-05노래연습장업올레노래연습장대구광역시 서구 달구벌대로375길 18 지하1층 (내당동)영업정지

Duplicate rows

Most frequently occurring

처분일자업종명업소명소재지(도로명)처분명# duplicates
02023-02-09일반음식점부초식당대구광역시 서구 평리로 358 (내당동)직권말소2