Overview

Dataset statistics

Number of variables8
Number of observations110
Missing cells29
Missing cells (%)3.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.1 KiB
Average record size in memory66.2 B

Variable types

Categorical4
Text2
DateTime2

Dataset

Description경기도 군포시 문화유통업 현황에 대한 데이터로 시도명, 시군구명, 시군구코드, 상호, 영업소소재지(도로명주소), 등록일자, 변경일자, 데이터기준일자 항목을 제공합니다.
Author경기도 군포시
URLhttps://www.data.go.kr/data/3076846/fileData.do

Alerts

시도명 has constant value ""Constant
시군구명 has constant value ""Constant
시군구코드 has constant value ""Constant
데이터기준일자 has constant value ""Constant
변경일자 has 29 (26.4%) missing valuesMissing
영업소소재지(도로명) has unique valuesUnique

Reproduction

Analysis started2024-03-14 14:10:37.512457
Analysis finished2024-03-14 14:10:39.110329
Duration1.6 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시도명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1008.0 B
경기도
110 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경기도
2nd row경기도
3rd row경기도
4th row경기도
5th row경기도

Common Values

ValueCountFrequency (%)
경기도 110
100.0%

Length

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

Common Values (Plot)

2024-03-14T23:10:39.824537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 110
100.0%

시군구명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1008.0 B
군포시
110 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row군포시
2nd row군포시
3rd row군포시
4th row군포시
5th row군포시

Common Values

ValueCountFrequency (%)
군포시 110
100.0%

Length

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

Common Values (Plot)

2024-03-14T23:10:40.428147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
군포시 110
100.0%

시군구코드
Categorical

CONSTANT 

Distinct1
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1008.0 B
41410
110 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row41410
2nd row41410
3rd row41410
4th row41410
5th row41410

Common Values

ValueCountFrequency (%)
41410 110
100.0%

Length

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

Common Values (Plot)

2024-03-14T23:10:41.036401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
41410 110
100.0%

상호명
Text

Distinct98
Distinct (%)89.1%
Missing0
Missing (%)0.0%
Memory size1008.0 B
2024-03-14T23:10:41.838089image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length17
Mean length7.9909091
Min length6

Characters and Unicode

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

Unique

Unique89 ?
Unique (%)80.9%

Sample

1st row25시노래연습장
2nd row영노래연습장
3rd row쇼킹노래연습장
4th row달빛노래연습장
5th row월드컵노래연습장
ValueCountFrequency (%)
코인노래연습장 5
 
4.1%
짱노래연습장 3
 
2.4%
앵콜노래연습장 3
 
2.4%
싱어게인코인노래연습장 3
 
2.4%
노래연습장 3
 
2.4%
쇼킹노래연습장 3
 
2.4%
애플노래연습장 2
 
1.6%
와와노래연습장 2
 
1.6%
팡팡노래연습장 2
 
1.6%
영노래연습장 2
 
1.6%
Other values (93) 95
77.2%
2024-03-14T23:10:43.144926image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
장 112
12.7%
연 111
12.6%
래 110
12.5%
습 110
12.5%
노 110
12.5%
인 13
 
1.5%
13
 
1.5%
스 12
 
1.4%
코 11
 
1.3%
와 7
 
0.8%
Other values (166) 270
30.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 823
93.6%
Uppercase Letter 37
 
4.2%
Space Separator 13
 
1.5%
Decimal Number 6
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
장 112
13.6%
연 111
13.5%
래 110
13.4%
습 110
13.4%
노 110
13.4%
인 13
 
1.6%
스 12
 
1.5%
코 11
 
1.3%
와 7
 
0.9%
리 5
 
0.6%
Other values (141) 222
27.0%
Uppercase Letter
ValueCountFrequency (%)
O 4
 
10.8%
M 3
 
8.1%
I 3
 
8.1%
N 3
 
8.1%
T 3
 
8.1%
P 2
 
5.4%
K 2
 
5.4%
S 2
 
5.4%
U 2
 
5.4%
G 2
 
5.4%
Other values (10) 11
29.7%
Decimal Number
ValueCountFrequency (%)
2 3
50.0%
5 1
 
16.7%
1 1
 
16.7%
3 1
 
16.7%
Space Separator
ValueCountFrequency (%)
13
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 823
93.6%
Latin 37
 
4.2%
Common 19
 
2.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
장 112
13.6%
연 111
13.5%
래 110
13.4%
습 110
13.4%
노 110
13.4%
인 13
 
1.6%
스 12
 
1.5%
코 11
 
1.3%
와 7
 
0.9%
리 5
 
0.6%
Other values (141) 222
27.0%
Latin
ValueCountFrequency (%)
O 4
 
10.8%
M 3
 
8.1%
I 3
 
8.1%
N 3
 
8.1%
T 3
 
8.1%
P 2
 
5.4%
K 2
 
5.4%
S 2
 
5.4%
U 2
 
5.4%
G 2
 
5.4%
Other values (10) 11
29.7%
Common
ValueCountFrequency (%)
13
68.4%
2 3
 
15.8%
5 1
 
5.3%
1 1
 
5.3%
3 1
 
5.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 823
93.6%
ASCII 56
 
6.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
장 112
13.6%
연 111
13.5%
래 110
13.4%
습 110
13.4%
노 110
13.4%
인 13
 
1.6%
스 12
 
1.5%
코 11
 
1.3%
와 7
 
0.9%
리 5
 
0.6%
Other values (141) 222
27.0%
ASCII
ValueCountFrequency (%)
13
23.2%
O 4
 
7.1%
M 3
 
5.4%
I 3
 
5.4%
2 3
 
5.4%
N 3
 
5.4%
T 3
 
5.4%
P 2
 
3.6%
K 2
 
3.6%
S 2
 
3.6%
Other values (15) 18
32.1%

영업소소재지(도로명)
Text

UNIQUE 

Distinct110
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1008.0 B
2024-03-14T23:10:44.828360image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length60
Median length44
Mean length31.436364
Min length20

Characters and Unicode

Total characters3458
Distinct characters106
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

Unique110 ?
Unique (%)100.0%

Sample

1st row경기도 군포시 산본로323번길 16-31 (산본동, 한솔프라자 702,703호)
2nd row경기도 군포시 고산로 679, 지하202호 (산본동, 미성프라자)
3rd row경기도 군포시 군포로 490 (당동)
4th row경기도 군포시 고산로724번길 22, 지하1층 (산본동)
5th row경기도 군포시 당산로126번길 1, 지층 (금정동)
ValueCountFrequency (%)
경기도 110
 
15.6%
군포시 110
 
15.6%
산본동 56
 
8.0%
지하1층 31
 
4.4%
당동 31
 
4.4%
산본로323번길 18
 
2.6%
지하층 17
 
2.4%
금정동 15
 
2.1%
2층 13
 
1.8%
군포로 12
 
1.7%
Other values (200) 291
41.3%
2024-03-14T23:10:47.633737image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
594
 
17.2%
군 147
 
4.3%
포 147
 
4.3%
1 144
 
4.2%
, 140
 
4.0%
2 119
 
3.4%
산 116
 
3.4%
동 116
 
3.4%
경 111
 
3.2%
시 111
 
3.2%
Other values (96) 1713
49.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1818
52.6%
Decimal Number 648
 
18.7%
Space Separator 594
 
17.2%
Other Punctuation 141
 
4.1%
Close Punctuation 110
 
3.2%
Open Punctuation 110
 
3.2%
Dash Punctuation 28
 
0.8%
Uppercase Letter 5
 
0.1%
Math Symbol 4
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
군 147
 
8.1%
포 147
 
8.1%
산 116
 
6.4%
동 116
 
6.4%
경 111
 
6.1%
시 111
 
6.1%
기 110
 
6.1%
도 110
 
6.1%
로 107
 
5.9%
본 89
 
4.9%
Other values (74) 654
36.0%
Decimal Number
ValueCountFrequency (%)
1 144
22.2%
2 119
18.4%
3 87
13.4%
4 71
11.0%
0 70
10.8%
6 52
 
8.0%
5 46
 
7.1%
7 31
 
4.8%
9 18
 
2.8%
8 10
 
1.5%
Uppercase Letter
ValueCountFrequency (%)
L 1
20.0%
C 1
20.0%
B 1
20.0%
S 1
20.0%
K 1
20.0%
Other Punctuation
ValueCountFrequency (%)
, 140
99.3%
& 1
 
0.7%
Space Separator
ValueCountFrequency (%)
594
100.0%
Close Punctuation
ValueCountFrequency (%)
) 110
100.0%
Open Punctuation
ValueCountFrequency (%)
( 110
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 28
100.0%
Math Symbol
ValueCountFrequency (%)
~ 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1818
52.6%
Common 1635
47.3%
Latin 5
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
군 147
 
8.1%
포 147
 
8.1%
산 116
 
6.4%
동 116
 
6.4%
경 111
 
6.1%
시 111
 
6.1%
기 110
 
6.1%
도 110
 
6.1%
로 107
 
5.9%
본 89
 
4.9%
Other values (74) 654
36.0%
Common
ValueCountFrequency (%)
594
36.3%
1 144
 
8.8%
, 140
 
8.6%
2 119
 
7.3%
) 110
 
6.7%
( 110
 
6.7%
3 87
 
5.3%
4 71
 
4.3%
0 70
 
4.3%
6 52
 
3.2%
Other values (7) 138
 
8.4%
Latin
ValueCountFrequency (%)
L 1
20.0%
C 1
20.0%
B 1
20.0%
S 1
20.0%
K 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1818
52.6%
ASCII 1640
47.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
594
36.2%
1 144
 
8.8%
, 140
 
8.5%
2 119
 
7.3%
) 110
 
6.7%
( 110
 
6.7%
3 87
 
5.3%
4 71
 
4.3%
0 70
 
4.3%
6 52
 
3.2%
Other values (12) 143
 
8.7%
Hangul
ValueCountFrequency (%)
군 147
 
8.1%
포 147
 
8.1%
산 116
 
6.4%
동 116
 
6.4%
경 111
 
6.1%
시 111
 
6.1%
기 110
 
6.1%
도 110
 
6.1%
로 107
 
5.9%
본 89
 
4.9%
Other values (74) 654
36.0%

등록일자
Date

Distinct83
Distinct (%)75.5%
Missing0
Missing (%)0.0%
Memory size1008.0 B
Minimum1999-06-15 00:00:00
Maximum2023-07-20 00:00:00
2024-03-14T23:10:48.032841image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T23:10:48.484026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

변경일자
Date

MISSING 

Distinct77
Distinct (%)95.1%
Missing29
Missing (%)26.4%
Memory size1008.0 B
Minimum2004-08-10 00:00:00
Maximum2023-07-14 00:00:00
2024-03-14T23:10:48.886548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T23:10:49.309354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size1008.0 B
2023-10-19
110 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-10-19
2nd row2023-10-19
3rd row2023-10-19
4th row2023-10-19
5th row2023-10-19

Common Values

ValueCountFrequency (%)
2023-10-19 110
100.0%

Length

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

Common Values (Plot)

2024-03-14T23:10:50.038948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-10-19 110
100.0%

Correlations

2024-03-14T23:10:50.337964image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상호명등록일자변경일자
상호명1.0000.9900.954
등록일자0.9901.0000.829
변경일자0.9540.8291.000

Missing values

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

시도명시군구명시군구코드상호명영업소소재지(도로명)등록일자변경일자데이터기준일자
0경기도군포시4141025시노래연습장경기도 군포시 산본로323번길 16-31 (산본동, 한솔프라자 702,703호)1999-06-252022-07-072023-10-19
1경기도군포시41410영노래연습장경기도 군포시 고산로 679, 지하202호 (산본동, 미성프라자)1999-06-252017-04-052023-10-19
2경기도군포시41410쇼킹노래연습장경기도 군포시 군포로 490 (당동)1999-06-25<NA>2023-10-19
3경기도군포시41410달빛노래연습장경기도 군포시 고산로724번길 22, 지하1층 (산본동)1999-06-252022-08-042023-10-19
4경기도군포시41410월드컵노래연습장경기도 군포시 당산로126번길 1, 지층 (금정동)1999-06-252017-07-132023-10-19
5경기도군포시41410팡팡노래연습장경기도 군포시 군포로 532, 2층 (당동)1999-06-25<NA>2023-10-19
6경기도군포시41410썬노래연습장경기도 군포시 군포로 494 (당동, 당동빌딩 4층 402호)1999-06-252021-04-052023-10-19
7경기도군포시41410FM노래연습장경기도 군포시 금산로72번길 6, 지하층 (산본동)1999-06-25<NA>2023-10-19
8경기도군포시41410꿈돌이랜드노래연습장경기도 군포시 군포역1길 44, 지하층 (당동)1999-06-252019-12-032023-10-19
9경기도군포시41410신환노래연습장경기도 군포시 금재로 1, 지하층 (금정동, 경원빌딩)1999-08-182023-07-142023-10-19
시도명시군구명시군구코드상호명영업소소재지(도로명)등록일자변경일자데이터기준일자
100경기도군포시41410홍길동전노래연습장경기도 군포시 고산로 246, 2층 (당동)2017-05-03<NA>2023-10-19
101경기도군포시41410쇼킹노래연습장경기도 군포시 금정로 10 (금정동)2017-07-27<NA>2023-10-19
102경기도군포시41410큐노래연습장경기도 군포시 공단로 356-54, 211호 (산본동)2017-11-17<NA>2023-10-19
103경기도군포시41410엔젤스 코인노래연습장경기도 군포시 고산로 685, 지층 101호 (산본동)2018-11-29<NA>2023-10-19
104경기도군포시41410세븐스타 코인노래연습장 군포당동점경기도 군포시 고산로 246-1, 3층 301호 (당동)2019-11-29<NA>2023-10-19
105경기도군포시41410싱어게인코인노래연습장경기도 군포시 산본로323번길 16-15, 광림빌딩 지층 제4호,제9호,제14호,제15호,제17호 (산본동)2021-08-18<NA>2023-10-19
106경기도군포시41410BUSKING 코인노래연습장경기도 군포시 산본로323번길 20-21, 거성빌딩3차 제301호, 제302호, 제303호 (산본동)2022-10-07<NA>2023-10-19
107경기도군포시41410와우코인 노래연습장경기도 군포시 금산로 90, 지하층 (산본동)2022-11-29<NA>2023-10-19
108경기도군포시41410판타스틱 코인노래연습장경기도 군포시 번영로 40, 202호 (부곡동)2023-04-14<NA>2023-10-19
109경기도군포시41410싱어게인코인노래연습장 금정역점경기도 군포시 군포로735번길 4, 2층 (산본동)2023-07-20<NA>2023-10-19