Overview

Dataset statistics

Number of variables8
Number of observations178
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory11.6 KiB
Average record size in memory66.7 B

Variable types

Numeric2
Text2
Categorical4

Dataset

Description양주시 문화유통업 현황에 대한 데이터로, 상호명, 우편번호, 주소, 업종(게임산업, 노래연습장업) 등의 내용을 포함합니다.
Author경기도 양주시
URLhttps://www.data.go.kr/data/3079893/fileData.do

Alerts

관련부서명 has constant value ""Constant
관리기관전화번호 has constant value ""Constant
데이터기준일 has constant value ""Constant
연번 is highly overall correlated with 업종High correlation
업종 is highly overall correlated with 연번High correlation
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 15:35:31.654047
Analysis finished2023-12-12 15:35:32.582274
Duration0.93 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct178
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean89.5
Minimum1
Maximum178
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.7 KiB
2023-12-13T00:35:32.670198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile9.85
Q145.25
median89.5
Q3133.75
95-th percentile169.15
Maximum178
Range177
Interquartile range (IQR)88.5

Descriptive statistics

Standard deviation51.528309
Coefficient of variation (CV)0.5757353
Kurtosis-1.2
Mean89.5
Median Absolute Deviation (MAD)44.5
Skewness0
Sum15931
Variance2655.1667
MonotonicityStrictly increasing
2023-12-13T00:35:32.821730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.6%
135 1
 
0.6%
115 1
 
0.6%
116 1
 
0.6%
117 1
 
0.6%
118 1
 
0.6%
119 1
 
0.6%
120 1
 
0.6%
121 1
 
0.6%
122 1
 
0.6%
Other values (168) 168
94.4%
ValueCountFrequency (%)
1 1
0.6%
2 1
0.6%
3 1
0.6%
4 1
0.6%
5 1
0.6%
6 1
0.6%
7 1
0.6%
8 1
0.6%
9 1
0.6%
10 1
0.6%
ValueCountFrequency (%)
178 1
0.6%
177 1
0.6%
176 1
0.6%
175 1
0.6%
174 1
0.6%
173 1
0.6%
172 1
0.6%
171 1
0.6%
170 1
0.6%
169 1
0.6%

상호
Text

Distinct171
Distinct (%)96.1%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
2023-12-13T00:35:33.077218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length18
Mean length7.4606742
Min length3

Characters and Unicode

Total characters1328
Distinct characters252
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

Unique165 ?
Unique (%)92.7%

Sample

1st row아론PC방
2nd row대성PC
3rd row더샵PC방
4th rowALL2 PC
5th row피씨나인
ValueCountFrequency (%)
노래연습장 19
 
7.7%
pc 10
 
4.1%
양주옥정점 6
 
2.4%
cafe 4
 
1.6%
황제pc 3
 
1.2%
골드pc 3
 
1.2%
pc방 3
 
1.2%
광사점 2
 
0.8%
덕정점 2
 
0.8%
654 2
 
0.8%
Other values (184) 192
78.0%
2023-12-13T00:35:33.489949image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
88
 
6.6%
84
 
6.3%
84
 
6.3%
82
 
6.2%
82
 
6.2%
68
 
5.1%
P 46
 
3.5%
C 46
 
3.5%
26
 
2.0%
25
 
1.9%
Other values (242) 697
52.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1043
78.5%
Uppercase Letter 133
 
10.0%
Space Separator 68
 
5.1%
Lowercase Letter 54
 
4.1%
Decimal Number 15
 
1.1%
Close Punctuation 7
 
0.5%
Open Punctuation 7
 
0.5%
Dash Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
88
 
8.4%
84
 
8.1%
84
 
8.1%
82
 
7.9%
82
 
7.9%
26
 
2.5%
25
 
2.4%
17
 
1.6%
17
 
1.6%
15
 
1.4%
Other values (200) 523
50.1%
Uppercase Letter
ValueCountFrequency (%)
P 46
34.6%
C 46
34.6%
A 5
 
3.8%
V 4
 
3.0%
O 4
 
3.0%
E 4
 
3.0%
F 3
 
2.3%
X 3
 
2.3%
M 3
 
2.3%
L 3
 
2.3%
Other values (8) 12
 
9.0%
Lowercase Letter
ValueCountFrequency (%)
c 19
35.2%
p 18
33.3%
e 5
 
9.3%
n 2
 
3.7%
h 2
 
3.7%
f 2
 
3.7%
o 2
 
3.7%
t 1
 
1.9%
m 1
 
1.9%
s 1
 
1.9%
Decimal Number
ValueCountFrequency (%)
2 3
20.0%
4 2
13.3%
0 2
13.3%
6 2
13.3%
5 2
13.3%
3 1
 
6.7%
8 1
 
6.7%
7 1
 
6.7%
1 1
 
6.7%
Space Separator
ValueCountFrequency (%)
68
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 1043
78.5%
Latin 187
 
14.1%
Common 98
 
7.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
88
 
8.4%
84
 
8.1%
84
 
8.1%
82
 
7.9%
82
 
7.9%
26
 
2.5%
25
 
2.4%
17
 
1.6%
17
 
1.6%
15
 
1.4%
Other values (200) 523
50.1%
Latin
ValueCountFrequency (%)
P 46
24.6%
C 46
24.6%
c 19
10.2%
p 18
 
9.6%
e 5
 
2.7%
A 5
 
2.7%
V 4
 
2.1%
O 4
 
2.1%
E 4
 
2.1%
F 3
 
1.6%
Other values (19) 33
17.6%
Common
ValueCountFrequency (%)
68
69.4%
) 7
 
7.1%
( 7
 
7.1%
2 3
 
3.1%
4 2
 
2.0%
0 2
 
2.0%
6 2
 
2.0%
5 2
 
2.0%
3 1
 
1.0%
- 1
 
1.0%
Other values (3) 3
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1043
78.5%
ASCII 285
 
21.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
88
 
8.4%
84
 
8.1%
84
 
8.1%
82
 
7.9%
82
 
7.9%
26
 
2.5%
25
 
2.4%
17
 
1.6%
17
 
1.6%
15
 
1.4%
Other values (200) 523
50.1%
ASCII
ValueCountFrequency (%)
68
23.9%
P 46
16.1%
C 46
16.1%
c 19
 
6.7%
p 18
 
6.3%
) 7
 
2.5%
( 7
 
2.5%
e 5
 
1.8%
A 5
 
1.8%
V 4
 
1.4%
Other values (32) 60
21.1%

우편번호
Real number (ℝ)

Distinct41
Distinct (%)23.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11463.376
Minimum11404
Maximum11523
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.7 KiB
2023-12-13T00:35:33.666211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum11404
5-th percentile11419
Q111442.25
median11473
Q311492
95-th percentile11513
Maximum11523
Range119
Interquartile range (IQR)49.75

Descriptive statistics

Standard deviation32.077042
Coefficient of variation (CV)0.0027982194
Kurtosis-1.0976973
Mean11463.376
Median Absolute Deviation (MAD)22
Skewness-0.10244587
Sum2040481
Variance1028.9366
MonotonicityNot monotonic
2023-12-13T00:35:33.814617image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=41)
ValueCountFrequency (%)
11473 27
15.2%
11492 26
14.6%
11419 24
13.5%
11456 10
 
5.6%
11444 9
 
5.1%
11451 8
 
4.5%
11510 6
 
3.4%
11404 6
 
3.4%
11427 6
 
3.4%
11486 5
 
2.8%
Other values (31) 51
28.7%
ValueCountFrequency (%)
11404 6
 
3.4%
11417 1
 
0.6%
11419 24
13.5%
11425 1
 
0.6%
11426 2
 
1.1%
11427 6
 
3.4%
11429 1
 
0.6%
11433 1
 
0.6%
11439 1
 
0.6%
11442 2
 
1.1%
ValueCountFrequency (%)
11523 1
 
0.6%
11520 1
 
0.6%
11519 1
 
0.6%
11518 1
 
0.6%
11517 2
 
1.1%
11516 1
 
0.6%
11513 3
1.7%
11512 1
 
0.6%
11510 6
3.4%
11508 2
 
1.1%
Distinct175
Distinct (%)98.3%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
2023-12-13T00:35:34.156136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length38
Mean length27.5
Min length18

Characters and Unicode

Total characters4895
Distinct characters146
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

Unique172 ?
Unique (%)96.6%

Sample

1st row경기도 양주시 평화로 1452 (덕계동)
2nd row경기도 양주시 남면 개나리17길 29
3rd row경기도 양주시 백석읍 양주산성로 636
4th row경기도 양주시 백석읍 양주산성로 544
5th row경기도 양주시 회정로 114 (덕정동)
ValueCountFrequency (%)
경기도 178
 
16.5%
양주시 178
 
16.5%
1층 33
 
3.1%
옥정동 28
 
2.6%
광사동 28
 
2.6%
광적면 25
 
2.3%
덕정동 22
 
2.0%
고읍남로 21
 
1.9%
백석읍 19
 
1.8%
2층 18
 
1.7%
Other values (263) 529
49.0%
2023-12-13T00:35:34.697397image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
902
 
18.4%
1 228
 
4.7%
191
 
3.9%
190
 
3.9%
180
 
3.7%
179
 
3.7%
178
 
3.6%
178
 
3.6%
144
 
2.9%
141
 
2.9%
Other values (136) 2384
48.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2720
55.6%
Space Separator 902
 
18.4%
Decimal Number 862
 
17.6%
Other Punctuation 126
 
2.6%
Open Punctuation 120
 
2.5%
Close Punctuation 120
 
2.5%
Dash Punctuation 37
 
0.8%
Uppercase Letter 5
 
0.1%
Math Symbol 3
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
191
 
7.0%
190
 
7.0%
180
 
6.6%
179
 
6.6%
178
 
6.5%
178
 
6.5%
144
 
5.3%
141
 
5.2%
95
 
3.5%
86
 
3.2%
Other values (117) 1158
42.6%
Decimal Number
ValueCountFrequency (%)
1 228
26.5%
2 110
12.8%
0 90
 
10.4%
3 84
 
9.7%
4 78
 
9.0%
6 71
 
8.2%
7 60
 
7.0%
5 59
 
6.8%
9 47
 
5.5%
8 35
 
4.1%
Uppercase Letter
ValueCountFrequency (%)
R 2
40.0%
G 2
40.0%
B 1
20.0%
Space Separator
ValueCountFrequency (%)
902
100.0%
Other Punctuation
ValueCountFrequency (%)
, 126
100.0%
Open Punctuation
ValueCountFrequency (%)
( 120
100.0%
Close Punctuation
ValueCountFrequency (%)
) 120
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 37
100.0%
Math Symbol
ValueCountFrequency (%)
~ 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2720
55.6%
Common 2170
44.3%
Latin 5
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
191
 
7.0%
190
 
7.0%
180
 
6.6%
179
 
6.6%
178
 
6.5%
178
 
6.5%
144
 
5.3%
141
 
5.2%
95
 
3.5%
86
 
3.2%
Other values (117) 1158
42.6%
Common
ValueCountFrequency (%)
902
41.6%
1 228
 
10.5%
, 126
 
5.8%
( 120
 
5.5%
) 120
 
5.5%
2 110
 
5.1%
0 90
 
4.1%
3 84
 
3.9%
4 78
 
3.6%
6 71
 
3.3%
Other values (6) 241
 
11.1%
Latin
ValueCountFrequency (%)
R 2
40.0%
G 2
40.0%
B 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2720
55.6%
ASCII 2175
44.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
902
41.5%
1 228
 
10.5%
, 126
 
5.8%
( 120
 
5.5%
) 120
 
5.5%
2 110
 
5.1%
0 90
 
4.1%
3 84
 
3.9%
4 78
 
3.6%
6 71
 
3.3%
Other values (9) 246
 
11.3%
Hangul
ValueCountFrequency (%)
191
 
7.0%
190
 
7.0%
180
 
6.6%
179
 
6.6%
178
 
6.5%
178
 
6.5%
144
 
5.3%
141
 
5.2%
95
 
3.5%
86
 
3.2%
Other values (117) 1158
42.6%

업종
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
노래연습장업
82 
인터넷컴퓨터게임시설제공업
65 
청소년게임제공업
30 
일반게임제공업
 
1

Length

Max length13
Median length8
Mean length8.8988764
Min length6

Unique

Unique1 ?
Unique (%)0.6%

Sample

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

Common Values

ValueCountFrequency (%)
노래연습장업 82
46.1%
인터넷컴퓨터게임시설제공업 65
36.5%
청소년게임제공업 30
 
16.9%
일반게임제공업 1
 
0.6%

Length

2023-12-13T00:35:34.891233image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:35:35.038083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
노래연습장업 82
46.1%
인터넷컴퓨터게임시설제공업 65
36.5%
청소년게임제공업 30
 
16.9%
일반게임제공업 1
 
0.6%

관련부서명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
양주시 문화관광과
178 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row양주시 문화관광과
2nd row양주시 문화관광과
3rd row양주시 문화관광과
4th row양주시 문화관광과
5th row양주시 문화관광과

Common Values

ValueCountFrequency (%)
양주시 문화관광과 178
100.0%

Length

2023-12-13T00:35:35.201684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:35:35.339805image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
양주시 178
50.0%
문화관광과 178
50.0%

관리기관전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
031-8082-5654
178 

Length

Max length13
Median length13
Mean length13
Min length13

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row031-8082-5654
2nd row031-8082-5654
3rd row031-8082-5654
4th row031-8082-5654
5th row031-8082-5654

Common Values

ValueCountFrequency (%)
031-8082-5654 178
100.0%

Length

2023-12-13T00:35:35.473471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:35:35.639138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
031-8082-5654 178
100.0%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.5 KiB
2023-11-02
178 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-11-02
2nd row2023-11-02
3rd row2023-11-02
4th row2023-11-02
5th row2023-11-02

Common Values

ValueCountFrequency (%)
2023-11-02 178
100.0%

Length

2023-12-13T00:35:35.788757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:35:35.924949image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-11-02 178
100.0%

Interactions

2023-12-13T00:35:32.145545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:35:31.970983image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:35:32.249105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:35:32.056803image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T00:35:35.992109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번우편번호업종
연번1.0000.4180.873
우편번호0.4181.0000.135
업종0.8730.1351.000
2023-12-13T00:35:36.096417image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번우편번호업종
연번1.000-0.0040.721
우편번호-0.0041.0000.037
업종0.7210.0371.000

Missing values

2023-12-13T00:35:32.374971image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T00:35:32.524882image/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아론PC방11444경기도 양주시 평화로 1452 (덕계동)인터넷컴퓨터게임시설제공업양주시 문화관광과031-8082-56542023-11-02
12대성PC11404경기도 양주시 남면 개나리17길 29인터넷컴퓨터게임시설제공업양주시 문화관광과031-8082-56542023-11-02
23더샵PC방11510경기도 양주시 백석읍 양주산성로 636인터넷컴퓨터게임시설제공업양주시 문화관광과031-8082-56542023-11-02
34ALL2 PC11510경기도 양주시 백석읍 양주산성로 544인터넷컴퓨터게임시설제공업양주시 문화관광과031-8082-56542023-11-02
45피씨나인11456경기도 양주시 회정로 114 (덕정동)인터넷컴퓨터게임시설제공업양주시 문화관광과031-8082-56542023-11-02
56아이비PC11419경기도 양주시 광적면 가래비11길 12인터넷컴퓨터게임시설제공업양주시 문화관광과031-8082-56542023-11-02
67피씨앤쿡11492경기도 양주시 고읍로 96, 202호 (광사동, 그린프라자)인터넷컴퓨터게임시설제공업양주시 문화관광과031-8082-56542023-11-02
78POW PC CAFE11486경기도 양주시 삼숭로38번길 19 (삼숭동, 자이안상가 501,502호)인터넷컴퓨터게임시설제공업양주시 문화관광과031-8082-56542023-11-02
89엔터나인PC방 덕정점11451경기도 양주시 회정로 99, 2층 (덕정동)인터넷컴퓨터게임시설제공업양주시 문화관광과031-8082-56542023-11-02
910퍼즐PC방11494경기도 양주시 부흥로 2038-71, 천신빌딩 1층 (만송동)인터넷컴퓨터게임시설제공업양주시 문화관광과031-8082-56542023-11-02
연번상호우편번호영업소소재지(도로명)업종관련부서명관리기관전화번호데이터기준일
168169옥스(OX) 코인노래연습장 광사점11492경기도 양주시 고읍남로 14, 더테라스 3층 301호 (광사동)노래연습장업양주시 문화관광과031-8082-56542023-11-02
169170삼가대노래연습장11482경기도 양주시 어하고개로 114 (삼숭동)노래연습장업양주시 문화관광과031-8082-56542023-11-02
170171아싸노래연습장11473경기도 양주시 옥정동로7다길 62, 대길프라자 4층 406호 (옥정동)노래연습장업양주시 문화관광과031-8082-56542023-11-02
171172네박자 노래연습장11507경기도 양주시 백석읍 부흥로 1166-3, 상가동 지하 1층 (대교 산과내아파트)노래연습장업양주시 문화관광과031-8082-56542023-11-02
172173654 노래연습장11492경기도 양주시 고읍남로 6-9, 1층 111호 (광사동)노래연습장업양주시 문화관광과031-8082-56542023-11-02
173174세븐틴코인노래연습장 양주옥정점11473경기도 양주시 옥정동로7다길 12-21, 폴리프라자2 307,308,309호 (옥정동)노래연습장업양주시 문화관광과031-8082-56542023-11-02
174175락휴코인노래연습장 양주옥정점11473경기도 양주시 옥정동로7다길 40, 306,307호 (옥정동)노래연습장업양주시 문화관광과031-8082-56542023-11-02
175176엔젤스코인노래연습장 양주옥정점11473경기도 양주시 옥정동로7다길 62, 대길프라자 507호 (옥정동)노래연습장업양주시 문화관광과031-8082-56542023-11-02
176177텐션업코인노래연습장11473경기도 양주시 옥정동로7다길 62, 대길프라자 705호 (옥정동)노래연습장업양주시 문화관광과031-8082-56542023-11-02
177178오엑스코인노래연습장 양주옥정점11473경기도 양주시 옥정동로7다길 54, 206호 (옥정동)노래연습장업양주시 문화관광과031-8082-56542023-11-02