Overview

Dataset statistics

Number of variables4
Number of observations78
Missing cells77
Missing cells (%)24.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.6 KiB
Average record size in memory33.7 B

Variable types

Unsupported1
Text3

Dataset

Description경상남도 창원시 인터넷컴퓨터게임시설제공업으로 등록된 업소현황입니다. 항목은 연번, 상호, 영업소소재지입니다.
Author경상남도 창원시
URLhttps://www.data.go.kr/data/3075350/fileData.do

Alerts

Unnamed: 3 has constant value ""Constant
Unnamed: 3 has 77 (98.7%) missing valuesMissing
Unnamed: 2 has unique valuesUnique
인터넷컴퓨터게임시설제공업 현황 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 04:15:46.489862
Analysis finished2023-12-12 04:15:46.892533
Duration0.4 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

인터넷컴퓨터게임시설제공업 현황
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size756.0 B

Unnamed: 1
Text

Distinct74
Distinct (%)94.9%
Missing0
Missing (%)0.0%
Memory size756.0 B
2023-12-12T13:15:47.139655image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length6.974359
Min length2

Characters and Unicode

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

Unique

Unique71 ?
Unique (%)91.0%

Sample

1st row상호
2nd row졸라빨라PC방 창대1호점
3rd row하이웨이
4th row프랜드PC방
5th row기분존 PC방
ValueCountFrequency (%)
pc방 18
 
14.8%
pc 8
 
6.6%
zone 6
 
4.9%
k-1 4
 
3.3%
dmzone 2
 
1.6%
봉곡점 2
 
1.6%
졸라빨라pc방 2
 
1.6%
프랜드pc방 2
 
1.6%
기분존 2
 
1.6%
horus 1
 
0.8%
Other values (75) 75
61.5%
2023-12-12T13:15:47.615302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
P 72
 
13.2%
C 71
 
13.1%
방 50
 
9.2%
45
 
8.3%
스 11
 
2.0%
이 10
 
1.8%
존 10
 
1.8%
점 10
 
1.8%
드 7
 
1.3%
Z 7
 
1.3%
Other values (124) 251
46.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 282
51.8%
Uppercase Letter 183
33.6%
Space Separator 45
 
8.3%
Lowercase Letter 21
 
3.9%
Decimal Number 7
 
1.3%
Dash Punctuation 4
 
0.7%
Other Punctuation 2
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
방 50
 
17.7%
스 11
 
3.9%
이 10
 
3.5%
존 10
 
3.5%
점 10
 
3.5%
드 7
 
2.5%
라 6
 
2.1%
프 6
 
2.1%
랜 5
 
1.8%
피 5
 
1.8%
Other values (96) 162
57.4%
Uppercase Letter
ValueCountFrequency (%)
P 72
39.3%
C 71
38.8%
Z 7
 
3.8%
O 6
 
3.3%
E 4
 
2.2%
K 4
 
2.2%
N 4
 
2.2%
D 3
 
1.6%
M 3
 
1.6%
R 2
 
1.1%
Other values (7) 7
 
3.8%
Lowercase Letter
ValueCountFrequency (%)
o 5
23.8%
n 5
23.8%
e 5
23.8%
z 2
 
9.5%
p 2
 
9.5%
c 2
 
9.5%
Decimal Number
ValueCountFrequency (%)
1 5
71.4%
2 2
 
28.6%
Space Separator
ValueCountFrequency (%)
45
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%
Other Punctuation
ValueCountFrequency (%)
. 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 282
51.8%
Latin 204
37.5%
Common 58
 
10.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
방 50
 
17.7%
스 11
 
3.9%
이 10
 
3.5%
존 10
 
3.5%
점 10
 
3.5%
드 7
 
2.5%
라 6
 
2.1%
프 6
 
2.1%
랜 5
 
1.8%
피 5
 
1.8%
Other values (96) 162
57.4%
Latin
ValueCountFrequency (%)
P 72
35.3%
C 71
34.8%
Z 7
 
3.4%
O 6
 
2.9%
o 5
 
2.5%
n 5
 
2.5%
e 5
 
2.5%
E 4
 
2.0%
K 4
 
2.0%
N 4
 
2.0%
Other values (13) 21
 
10.3%
Common
ValueCountFrequency (%)
45
77.6%
1 5
 
8.6%
- 4
 
6.9%
. 2
 
3.4%
2 2
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 282
51.8%
ASCII 262
48.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
P 72
27.5%
C 71
27.1%
45
17.2%
Z 7
 
2.7%
O 6
 
2.3%
o 5
 
1.9%
n 5
 
1.9%
e 5
 
1.9%
1 5
 
1.9%
E 4
 
1.5%
Other values (18) 37
14.1%
Hangul
ValueCountFrequency (%)
방 50
 
17.7%
스 11
 
3.9%
이 10
 
3.5%
존 10
 
3.5%
점 10
 
3.5%
드 7
 
2.5%
라 6
 
2.1%
프 6
 
2.1%
랜 5
 
1.8%
피 5
 
1.8%
Other values (96) 162
57.4%

Unnamed: 2
Text

UNIQUE 

Distinct78
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size756.0 B
2023-12-12T13:15:48.039930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length45
Median length40
Mean length35.141026
Min length11

Characters and Unicode

Total characters2741
Distinct characters113
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

Unique78 ?
Unique (%)100.0%

Sample

1st row영업소소재지(도로명)
2nd row경상남도 창원시 의창구 퇴촌로25번길 6-27 (사림동, 지하1층)
3rd row경상남도 창원시 의창구 원이대로589번길 2 (용호동, (성암빌딩302호))
4th row경상남도 창원시 의창구 동읍 동읍로 1-3 (2층)
5th row경상남도 창원시 의창구 창이대로460번길 13 (용호동)
ValueCountFrequency (%)
창원시 77
 
13.9%
의창구 77
 
13.9%
경상남도 77
 
13.9%
2층 14
 
2.5%
사림동 13
 
2.3%
퇴촌로25번길 12
 
2.2%
소답동 10
 
1.8%
봉곡동 10
 
1.8%
도계동 9
 
1.6%
지하1층 8
 
1.4%
Other values (160) 248
44.7%
2023-12-12T13:15:48.654075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
478
 
17.4%
창 167
 
6.1%
2 99
 
3.6%
상 90
 
3.3%
도 90
 
3.3%
1 89
 
3.2%
원 87
 
3.2%
의 84
 
3.1%
( 83
 
3.0%
) 83
 
3.0%
Other values (103) 1391
50.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1576
57.5%
Space Separator 478
 
17.4%
Decimal Number 426
 
15.5%
Open Punctuation 83
 
3.0%
Close Punctuation 83
 
3.0%
Other Punctuation 72
 
2.6%
Dash Punctuation 20
 
0.7%
Uppercase Letter 3
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
창 167
 
10.6%
상 90
 
5.7%
도 90
 
5.7%
원 87
 
5.5%
의 84
 
5.3%
동 80
 
5.1%
시 79
 
5.0%
구 79
 
5.0%
남 79
 
5.0%
경 77
 
4.9%
Other values (84) 664
42.1%
Decimal Number
ValueCountFrequency (%)
2 99
23.2%
1 89
20.9%
0 55
12.9%
5 43
10.1%
3 37
 
8.7%
6 28
 
6.6%
4 23
 
5.4%
7 21
 
4.9%
8 18
 
4.2%
9 13
 
3.1%
Uppercase Letter
ValueCountFrequency (%)
O 1
33.3%
K 1
33.3%
A 1
33.3%
Other Punctuation
ValueCountFrequency (%)
, 71
98.6%
' 1
 
1.4%
Space Separator
ValueCountFrequency (%)
478
100.0%
Open Punctuation
ValueCountFrequency (%)
( 83
100.0%
Close Punctuation
ValueCountFrequency (%)
) 83
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 20
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1576
57.5%
Common 1162
42.4%
Latin 3
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
창 167
 
10.6%
상 90
 
5.7%
도 90
 
5.7%
원 87
 
5.5%
의 84
 
5.3%
동 80
 
5.1%
시 79
 
5.0%
구 79
 
5.0%
남 79
 
5.0%
경 77
 
4.9%
Other values (84) 664
42.1%
Common
ValueCountFrequency (%)
478
41.1%
2 99
 
8.5%
1 89
 
7.7%
( 83
 
7.1%
) 83
 
7.1%
, 71
 
6.1%
0 55
 
4.7%
5 43
 
3.7%
3 37
 
3.2%
6 28
 
2.4%
Other values (6) 96
 
8.3%
Latin
ValueCountFrequency (%)
O 1
33.3%
K 1
33.3%
A 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1576
57.5%
ASCII 1165
42.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
478
41.0%
2 99
 
8.5%
1 89
 
7.6%
( 83
 
7.1%
) 83
 
7.1%
, 71
 
6.1%
0 55
 
4.7%
5 43
 
3.7%
3 37
 
3.2%
6 28
 
2.4%
Other values (9) 99
 
8.5%
Hangul
ValueCountFrequency (%)
창 167
 
10.6%
상 90
 
5.7%
도 90
 
5.7%
원 87
 
5.5%
의 84
 
5.3%
동 80
 
5.1%
시 79
 
5.0%
구 79
 
5.0%
남 79
 
5.0%
경 77
 
4.9%
Other values (84) 664
42.1%

Unnamed: 3
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing77
Missing (%)98.7%
Memory size756.0 B
2023-12-12T13:15:48.797090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length4
Mean length4
Min length4

Characters and Unicode

Total characters4
Distinct characters4
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

Unique1 ?
Unique (%)100.0%

Sample

1st row전화번호
ValueCountFrequency (%)
전화번호 1
100.0%
2023-12-12T13:15:49.146771image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
전 1
25.0%
화 1
25.0%
번 1
25.0%
호 1
25.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 1
25.0%
화 1
25.0%
번 1
25.0%
호 1
25.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 1
25.0%
화 1
25.0%
번 1
25.0%
호 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
전 1
25.0%
화 1
25.0%
번 1
25.0%
호 1
25.0%

Correlations

2023-12-12T13:15:49.243365image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Unnamed: 1Unnamed: 2
Unnamed: 11.0001.000
Unnamed: 21.0001.000

Missing values

2023-12-12T13:15:46.746004image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T13:15:46.843270image/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

인터넷컴퓨터게임시설제공업 현황Unnamed: 1Unnamed: 2Unnamed: 3
0연번상호영업소소재지(도로명)전화번호
11졸라빨라PC방 창대1호점경상남도 창원시 의창구 퇴촌로25번길 6-27 (사림동, 지하1층)<NA>
22하이웨이경상남도 창원시 의창구 원이대로589번길 2 (용호동, (성암빌딩302호))<NA>
33프랜드PC방경상남도 창원시 의창구 동읍 동읍로 1-3 (2층)<NA>
44기분존 PC방경상남도 창원시 의창구 창이대로460번길 13 (용호동)<NA>
55디엠존PC경상남도 창원시 의창구 읍성로 71 (소답동, 201호)<NA>
66그린존PC경상남도 창원시 의창구 명지로 82-8 (명서동, 시민상가3층)<NA>
77스타피시방경상남도 창원시 의창구 퇴촌로25번길 25 (사림동)<NA>
88프라이드PC방경상남도 창원시 의창구 지귀로12번길 10 (봉곡동, 명성빌딩501호)<NA>
99곤PC경상남도 창원시 의창구 창이대로309번길 7 (봉곡동, 중앙빌딩 지하 1층)<NA>
인터넷컴퓨터게임시설제공업 현황Unnamed: 1Unnamed: 2Unnamed: 3
6868아이비스PC방 창원도계점경상남도 창원시 의창구 원이대로55번길 9 (도계동, 2층)<NA>
6969고스트캐슬PC방창원역점경상남도 창원시 의창구 팔용로 439 (팔용동, 사화빌딩601호)<NA>
7070사이블루PC zone경상남도 창원시 의창구 대봉로 20 (봉림동, 304호 305-1호)<NA>
7171다윗PC방경상남도 창원시 의창구 태복산로15번길 42 (도계동, 진보빌딩401호)<NA>
7272도신PC경상남도 창원시 의창구 지귀로 10 (봉곡동, 아리랑상가 106호)<NA>
7373스피드PC방경상남도 창원시 의창구 의창대로247번길 20 (소답동, 1층)<NA>
7474올레PC방경상남도 창원시 의창구 퇴촌로25번길 6-32 (사림동, 지하1층)<NA>
7575넘버원PC방경상남도 창원시 의창구 천주로12번길 15-10 (서상동, 1층)<NA>
7676PC밸리경상남도 창원시 의창구 퇴촌로45번길 1 (사림동, 지하1층)<NA>
7777대박PC경상남도 창원시 의창구 의창대로54번길 6-12 (팔용동, 2층)<NA>