Overview

Dataset statistics

Number of variables7
Number of observations82
Missing cells49
Missing cells (%)8.5%
Duplicate rows1
Duplicate rows (%)1.2%
Total size in memory4.7 KiB
Average record size in memory58.6 B

Variable types

Numeric1
Categorical1
DateTime2
Text3

Dataset

Description경상남도 거제시 게임제공업소 현황 자료입니다. 인터넷컴퓨터게임시설제공업, 복합유통게임제공업, 일반게임제공업, 청소년게임제공업 등의 상호명, 지번, 도로명, 위경도 좌표정보을 제공합니다.
Author경상남도 거제시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=3079213

Alerts

데이터기준일자 has constant value ""Constant
Dataset has 1 (1.2%) duplicate rowsDuplicates
연번 is highly overall correlated with 업종명High correlation
업종명 is highly overall correlated with 연번High correlation
연번 has 8 (9.8%) missing valuesMissing
등록(신고)일자 has 8 (9.8%) missing valuesMissing
상호 has 8 (9.8%) missing valuesMissing
영업소소재지(도로명) has 9 (11.0%) missing valuesMissing
영업소소재지(지번) has 8 (9.8%) missing valuesMissing
데이터기준일자 has 8 (9.8%) missing valuesMissing

Reproduction

Analysis started2023-12-11 00:56:31.422730
Analysis finished2023-12-11 00:56:32.504890
Duration1.08 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct74
Distinct (%)100.0%
Missing8
Missing (%)9.8%
Infinite0
Infinite (%)0.0%
Mean37.5
Minimum1
Maximum74
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size870.0 B
2023-12-11T09:56:32.571581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.65
Q119.25
median37.5
Q355.75
95-th percentile70.35
Maximum74
Range73
Interquartile range (IQR)36.5

Descriptive statistics

Standard deviation21.505813
Coefficient of variation (CV)0.57348835
Kurtosis-1.2
Mean37.5
Median Absolute Deviation (MAD)18.5
Skewness0
Sum2775
Variance462.5
MonotonicityStrictly increasing
2023-12-11T09:56:32.723273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
57 1
 
1.2%
55 1
 
1.2%
54 1
 
1.2%
53 1
 
1.2%
52 1
 
1.2%
51 1
 
1.2%
50 1
 
1.2%
49 1
 
1.2%
48 1
 
1.2%
47 1
 
1.2%
Other values (64) 64
78.0%
(Missing) 8
 
9.8%
ValueCountFrequency (%)
1 1
1.2%
2 1
1.2%
3 1
1.2%
4 1
1.2%
5 1
1.2%
6 1
1.2%
7 1
1.2%
8 1
1.2%
9 1
1.2%
10 1
1.2%
ValueCountFrequency (%)
74 1
1.2%
73 1
1.2%
72 1
1.2%
71 1
1.2%
70 1
1.2%
69 1
1.2%
68 1
1.2%
67 1
1.2%
66 1
1.2%
65 1
1.2%

업종명
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)6.1%
Missing0
Missing (%)0.0%
Memory size788.0 B
인터넷컴퓨터게임시설제공업
49 
청소년게임제공업
19 
<NA>
복합유통게임제공업
일반게임제공업
 
1

Length

Max length13
Median length13
Mean length10.646341
Min length4

Unique

Unique1 ?
Unique (%)1.2%

Sample

1st row인터넷컴퓨터게임시설제공업
2nd row인터넷컴퓨터게임시설제공업
3rd row인터넷컴퓨터게임시설제공업
4th row인터넷컴퓨터게임시설제공업
5th row인터넷컴퓨터게임시설제공업

Common Values

ValueCountFrequency (%)
인터넷컴퓨터게임시설제공업 49
59.8%
청소년게임제공업 19
 
23.2%
<NA> 8
 
9.8%
복합유통게임제공업 5
 
6.1%
일반게임제공업 1
 
1.2%

Length

2023-12-11T09:56:32.860258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T09:56:32.958219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
인터넷컴퓨터게임시설제공업 49
59.8%
청소년게임제공업 19
 
23.2%
na 8
 
9.8%
복합유통게임제공업 5
 
6.1%
일반게임제공업 1
 
1.2%

등록(신고)일자
Date

MISSING 

Distinct70
Distinct (%)94.6%
Missing8
Missing (%)9.8%
Memory size788.0 B
Minimum2007-07-25 00:00:00
Maximum2022-04-20 00:00:00
2023-12-11T09:56:33.092041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:56:33.250447image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

상호
Text

MISSING 

Distinct73
Distinct (%)98.6%
Missing8
Missing (%)9.8%
Memory size788.0 B
2023-12-11T09:56:33.490502image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length13
Mean length6.6351351
Min length2

Characters and Unicode

Total characters491
Distinct characters136
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

Unique72 ?
Unique (%)97.3%

Sample

1st row블루넷 PC방
2nd row메트로 PC방
3rd row짱pc방
4th row피씨토랑 거제본점 2호점
5th row스펀지 PC방
ValueCountFrequency (%)
pc방 5
 
5.3%
골드pc 2
 
2.1%
pc 2
 
2.1%
갤러리pc방 2
 
2.1%
짱pc방 2
 
2.1%
펀존게임랜드(고현점 1
 
1.1%
샵퍼스널씨 1
 
1.1%
아인스플러스피시방 1
 
1.1%
pc(피시 1
 
1.1%
g 1
 
1.1%
Other values (77) 77
81.1%
2023-12-11T09:56:33.949835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
P 30
 
6.1%
C 30
 
6.1%
22
 
4.5%
21
 
4.3%
p 18
 
3.7%
c 18
 
3.7%
16
 
3.3%
12
 
2.4%
11
 
2.2%
10
 
2.0%
Other values (126) 303
61.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 342
69.7%
Uppercase Letter 66
 
13.4%
Lowercase Letter 40
 
8.1%
Space Separator 21
 
4.3%
Open Punctuation 9
 
1.8%
Close Punctuation 9
 
1.8%
Decimal Number 3
 
0.6%
Dash Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
22
 
6.4%
16
 
4.7%
12
 
3.5%
11
 
3.2%
10
 
2.9%
9
 
2.6%
9
 
2.6%
9
 
2.6%
8
 
2.3%
8
 
2.3%
Other values (106) 228
66.7%
Uppercase Letter
ValueCountFrequency (%)
P 30
45.5%
C 30
45.5%
N 1
 
1.5%
G 1
 
1.5%
T 1
 
1.5%
E 1
 
1.5%
M 1
 
1.5%
R 1
 
1.5%
Lowercase Letter
ValueCountFrequency (%)
p 18
45.0%
c 18
45.0%
n 1
 
2.5%
z 1
 
2.5%
o 1
 
2.5%
e 1
 
2.5%
Decimal Number
ValueCountFrequency (%)
2 2
66.7%
3 1
33.3%
Space Separator
ValueCountFrequency (%)
21
100.0%
Open Punctuation
ValueCountFrequency (%)
( 9
100.0%
Close Punctuation
ValueCountFrequency (%)
) 9
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 342
69.7%
Latin 106
 
21.6%
Common 43
 
8.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
22
 
6.4%
16
 
4.7%
12
 
3.5%
11
 
3.2%
10
 
2.9%
9
 
2.6%
9
 
2.6%
9
 
2.6%
8
 
2.3%
8
 
2.3%
Other values (106) 228
66.7%
Latin
ValueCountFrequency (%)
P 30
28.3%
C 30
28.3%
p 18
17.0%
c 18
17.0%
N 1
 
0.9%
G 1
 
0.9%
T 1
 
0.9%
E 1
 
0.9%
n 1
 
0.9%
z 1
 
0.9%
Other values (4) 4
 
3.8%
Common
ValueCountFrequency (%)
21
48.8%
( 9
20.9%
) 9
20.9%
2 2
 
4.7%
- 1
 
2.3%
3 1
 
2.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 342
69.7%
ASCII 149
30.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
P 30
20.1%
C 30
20.1%
21
14.1%
p 18
12.1%
c 18
12.1%
( 9
 
6.0%
) 9
 
6.0%
2 2
 
1.3%
N 1
 
0.7%
G 1
 
0.7%
Other values (10) 10
 
6.7%
Hangul
ValueCountFrequency (%)
22
 
6.4%
16
 
4.7%
12
 
3.5%
11
 
3.2%
10
 
2.9%
9
 
2.6%
9
 
2.6%
9
 
2.6%
8
 
2.3%
8
 
2.3%
Other values (106) 228
66.7%
Distinct73
Distinct (%)100.0%
Missing9
Missing (%)11.0%
Memory size788.0 B
2023-12-11T09:56:34.257699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length38
Mean length30.369863
Min length22

Characters and Unicode

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

Unique

Unique73 ?
Unique (%)100.0%

Sample

1st row경상남도 거제시 중곡로1길 36-5, 2층 (고현동)
2nd row경상남도 거제시 거제중앙로 1913 (고현동,동주빌딩 5층)
3rd row경상남도 거제시 옥포대첩로2길 48 (옥포동)
4th row경상남도 거제시 거제중앙로 1766, 1층 (상동동)
5th row경상남도 거제시 장평로 37 (장평동,장평종합상가 2층 278호)
ValueCountFrequency (%)
경상남도 73
 
15.9%
거제시 73
 
15.9%
1층 22
 
4.8%
옥포동 17
 
3.7%
고현동 15
 
3.3%
2층 13
 
2.8%
장평동 12
 
2.6%
능포동 8
 
1.7%
아주동 6
 
1.3%
4층 6
 
1.3%
Other values (149) 215
46.7%
2023-12-11T09:56:34.676375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
389
 
17.5%
1 122
 
5.5%
87
 
3.9%
85
 
3.8%
85
 
3.8%
, 78
 
3.5%
78
 
3.5%
77
 
3.5%
73
 
3.3%
73
 
3.3%
Other values (94) 1070
48.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1208
54.5%
Space Separator 389
 
17.5%
Decimal Number 378
 
17.1%
Other Punctuation 78
 
3.5%
Close Punctuation 72
 
3.2%
Open Punctuation 72
 
3.2%
Dash Punctuation 18
 
0.8%
Math Symbol 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
87
 
7.2%
85
 
7.0%
85
 
7.0%
78
 
6.5%
77
 
6.4%
73
 
6.0%
73
 
6.0%
73
 
6.0%
70
 
5.8%
54
 
4.5%
Other values (78) 453
37.5%
Decimal Number
ValueCountFrequency (%)
1 122
32.3%
2 63
16.7%
3 38
 
10.1%
0 34
 
9.0%
4 33
 
8.7%
6 30
 
7.9%
5 25
 
6.6%
7 12
 
3.2%
8 12
 
3.2%
9 9
 
2.4%
Space Separator
ValueCountFrequency (%)
389
100.0%
Other Punctuation
ValueCountFrequency (%)
, 78
100.0%
Close Punctuation
ValueCountFrequency (%)
) 72
100.0%
Open Punctuation
ValueCountFrequency (%)
( 72
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 18
100.0%
Math Symbol
ValueCountFrequency (%)
~ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1208
54.5%
Common 1009
45.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
87
 
7.2%
85
 
7.0%
85
 
7.0%
78
 
6.5%
77
 
6.4%
73
 
6.0%
73
 
6.0%
73
 
6.0%
70
 
5.8%
54
 
4.5%
Other values (78) 453
37.5%
Common
ValueCountFrequency (%)
389
38.6%
1 122
 
12.1%
, 78
 
7.7%
) 72
 
7.1%
( 72
 
7.1%
2 63
 
6.2%
3 38
 
3.8%
0 34
 
3.4%
4 33
 
3.3%
6 30
 
3.0%
Other values (6) 78
 
7.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1208
54.5%
ASCII 1009
45.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
389
38.6%
1 122
 
12.1%
, 78
 
7.7%
) 72
 
7.1%
( 72
 
7.1%
2 63
 
6.2%
3 38
 
3.8%
0 34
 
3.4%
4 33
 
3.3%
6 30
 
3.0%
Other values (6) 78
 
7.7%
Hangul
ValueCountFrequency (%)
87
 
7.2%
85
 
7.0%
85
 
7.0%
78
 
6.5%
77
 
6.4%
73
 
6.0%
73
 
6.0%
73
 
6.0%
70
 
5.8%
54
 
4.5%
Other values (78) 453
37.5%
Distinct72
Distinct (%)97.3%
Missing8
Missing (%)9.8%
Memory size788.0 B
2023-12-11T09:56:34.956801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length35
Median length32.5
Mean length21.418919
Min length17

Characters and Unicode

Total characters1585
Distinct characters75
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

Unique70 ?
Unique (%)94.6%

Sample

1st row경상남도 거제시 고현동 1009-2
2nd row경상남도 거제시 고현동 961-25 동주빌딩 5층
3rd row경상남도 거제시 옥포동 550-22
4th row경상남도 거제시 상동동 436-13
5th row경상남도 거제시 장평동 56-1 장평종합상가 2층 278호
ValueCountFrequency (%)
경상남도 74
22.7%
거제시 74
22.7%
고현동 18
 
5.5%
옥포동 17
 
5.2%
장평동 13
 
4.0%
능포동 8
 
2.5%
아주동 7
 
2.1%
2층 3
 
0.9%
수월동 3
 
0.9%
상동동 3
 
0.9%
Other values (100) 106
32.5%
2023-12-11T09:56:35.364751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
324
20.4%
1 90
 
5.7%
80
 
5.0%
77
 
4.9%
77
 
4.9%
76
 
4.8%
75
 
4.7%
74
 
4.7%
74
 
4.7%
74
 
4.7%
Other values (65) 564
35.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 824
52.0%
Decimal Number 365
23.0%
Space Separator 324
 
20.4%
Dash Punctuation 69
 
4.4%
Close Punctuation 1
 
0.1%
Open Punctuation 1
 
0.1%
Math Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
80
9.7%
77
9.3%
77
9.3%
76
9.2%
75
9.1%
74
9.0%
74
9.0%
74
9.0%
27
 
3.3%
20
 
2.4%
Other values (50) 170
20.6%
Decimal Number
ValueCountFrequency (%)
1 90
24.7%
3 39
10.7%
6 39
10.7%
5 37
10.1%
2 37
10.1%
0 33
 
9.0%
9 31
 
8.5%
7 28
 
7.7%
8 17
 
4.7%
4 14
 
3.8%
Space Separator
ValueCountFrequency (%)
324
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 69
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 824
52.0%
Common 761
48.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
80
9.7%
77
9.3%
77
9.3%
76
9.2%
75
9.1%
74
9.0%
74
9.0%
74
9.0%
27
 
3.3%
20
 
2.4%
Other values (50) 170
20.6%
Common
ValueCountFrequency (%)
324
42.6%
1 90
 
11.8%
- 69
 
9.1%
3 39
 
5.1%
6 39
 
5.1%
5 37
 
4.9%
2 37
 
4.9%
0 33
 
4.3%
9 31
 
4.1%
7 28
 
3.7%
Other values (5) 34
 
4.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 824
52.0%
ASCII 761
48.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
324
42.6%
1 90
 
11.8%
- 69
 
9.1%
3 39
 
5.1%
6 39
 
5.1%
5 37
 
4.9%
2 37
 
4.9%
0 33
 
4.3%
9 31
 
4.1%
7 28
 
3.7%
Other values (5) 34
 
4.5%
Hangul
ValueCountFrequency (%)
80
9.7%
77
9.3%
77
9.3%
76
9.2%
75
9.1%
74
9.0%
74
9.0%
74
9.0%
27
 
3.3%
20
 
2.4%
Other values (50) 170
20.6%

데이터기준일자
Date

CONSTANT  MISSING 

Distinct1
Distinct (%)1.4%
Missing8
Missing (%)9.8%
Memory size788.0 B
Minimum2022-05-02 00:00:00
Maximum2022-05-02 00:00:00
2023-12-11T09:56:35.477237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:56:35.563037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-11T09:56:32.057069image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T09:56:35.931020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종명등록(신고)일자상호영업소소재지(도로명)영업소소재지(지번)
연번1.0000.7921.0000.9381.0000.856
업종명0.7921.0001.0001.0001.0000.885
등록(신고)일자1.0001.0001.0000.9941.0000.984
상호0.9381.0000.9941.0001.0000.995
영업소소재지(도로명)1.0001.0001.0001.0001.0001.000
영업소소재지(지번)0.8560.8850.9840.9951.0001.000
2023-12-11T09:56:36.021287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번업종명
연번1.0000.585
업종명0.5851.000

Missing values

2023-12-11T09:56:32.172582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T09:56:32.296184image/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-11T09:56:32.424767image/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

연번업종명등록(신고)일자상호영업소소재지(도로명)영업소소재지(지번)데이터기준일자
01인터넷컴퓨터게임시설제공업2007-07-25블루넷 PC방경상남도 거제시 중곡로1길 36-5, 2층 (고현동)경상남도 거제시 고현동 1009-22022-05-02
12인터넷컴퓨터게임시설제공업2007-10-04메트로 PC방경상남도 거제시 거제중앙로 1913 (고현동,동주빌딩 5층)경상남도 거제시 고현동 961-25 동주빌딩 5층2022-05-02
23인터넷컴퓨터게임시설제공업2007-10-24짱pc방경상남도 거제시 옥포대첩로2길 48 (옥포동)경상남도 거제시 옥포동 550-222022-05-02
34인터넷컴퓨터게임시설제공업2007-10-24피씨토랑 거제본점 2호점경상남도 거제시 거제중앙로 1766, 1층 (상동동)경상남도 거제시 상동동 436-132022-05-02
45인터넷컴퓨터게임시설제공업2007-11-16스펀지 PC방경상남도 거제시 장평로 37 (장평동,장평종합상가 2층 278호)경상남도 거제시 장평동 56-1 장평종합상가 2층 278호2022-05-02
56인터넷컴퓨터게임시설제공업2007-12-21넷토피아 PC방경상남도 거제시 거제면 기성로 6, 1층경상남도 거제시 거제면 서정리 766-12022-05-02
67인터넷컴퓨터게임시설제공업2008-02-04엔터PC방경상남도 거제시 능포로 146, 3층 309호 (능포동, 동림상가)경상남도 거제시 능포동 660-82022-05-02
78인터넷컴퓨터게임시설제공업2008-03-13N-TER PC방경상남도 거제시 옥포로6길 35 (옥포동)경상남도 거제시 옥포동 603-22022-05-02
89인터넷컴퓨터게임시설제공업2008-05-07해피로PC경상남도 거제시 옥포로 237-1, 2층 (옥포동)경상남도 거제시 옥포동 514-122022-05-02
910인터넷컴퓨터게임시설제공업2008-05-16M3PC방경상남도 거제시 고현로 112 (고현동)경상남도 거제시 고현동 37-342022-05-02
연번업종명등록(신고)일자상호영업소소재지(도로명)영업소소재지(지번)데이터기준일자
7273청소년게임제공업2020-11-23홈런짱게임랜드경상남도 거제시 장평로4길 16, 102호 (장평동)경상남도 거제시 장평동 1195-62022-05-02
7374청소년게임제공업2022-04-19애플게임장경상남도 거제시 옥포로 155, 1층 102호 (옥포동)경상남도 거제시 옥포동 553-12022-05-02
74<NA><NA><NA><NA><NA><NA><NA>
75<NA><NA><NA><NA><NA><NA><NA>
76<NA><NA><NA><NA><NA><NA><NA>
77<NA><NA><NA><NA><NA><NA><NA>
78<NA><NA><NA><NA><NA><NA><NA>
79<NA><NA><NA><NA><NA><NA><NA>
80<NA><NA><NA><NA><NA><NA><NA>
81<NA><NA><NA><NA><NA><NA><NA>

Duplicate rows

Most frequently occurring

연번업종명등록(신고)일자상호영업소소재지(도로명)영업소소재지(지번)데이터기준일자# duplicates
0<NA><NA><NA><NA><NA><NA><NA>8