Overview

Dataset statistics

Number of variables6
Number of observations59
Missing cells53
Missing cells (%)15.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.0 KiB
Average record size in memory51.2 B

Variable types

Numeric1
Text4
Categorical1

Dataset

Description인천광역시 서구 내 비디오물 제작업소 현황(상호, 영업소 소재지, 취급/제작 품목, 데이터 기준일자 등)을 제공합니다.
URLhttps://www.data.go.kr/data/15081311/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
전화번호 has 53 (89.8%) missing valuesMissing
연번 has unique valuesUnique
상호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 20:28:17.385810
Analysis finished2023-12-12 20:28:18.092105
Duration0.71 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct59
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean30
Minimum1
Maximum59
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size663.0 B
2023-12-13T05:28:18.185771image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.9
Q115.5
median30
Q344.5
95-th percentile56.1
Maximum59
Range58
Interquartile range (IQR)29

Descriptive statistics

Standard deviation17.175564
Coefficient of variation (CV)0.5725188
Kurtosis-1.2
Mean30
Median Absolute Deviation (MAD)15
Skewness0
Sum1770
Variance295
MonotonicityStrictly increasing
2023-12-13T05:28:18.317925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.7%
2 1
 
1.7%
33 1
 
1.7%
34 1
 
1.7%
35 1
 
1.7%
36 1
 
1.7%
37 1
 
1.7%
38 1
 
1.7%
39 1
 
1.7%
40 1
 
1.7%
Other values (49) 49
83.1%
ValueCountFrequency (%)
1 1
1.7%
2 1
1.7%
3 1
1.7%
4 1
1.7%
5 1
1.7%
6 1
1.7%
7 1
1.7%
8 1
1.7%
9 1
1.7%
10 1
1.7%
ValueCountFrequency (%)
59 1
1.7%
58 1
1.7%
57 1
1.7%
56 1
1.7%
55 1
1.7%
54 1
1.7%
53 1
1.7%
52 1
1.7%
51 1
1.7%
50 1
1.7%

상호
Text

UNIQUE 

Distinct59
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size604.0 B
2023-12-13T05:28:18.558107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length12
Mean length7.9322034
Min length2

Characters and Unicode

Total characters468
Distinct characters164
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

Unique59 ?
Unique (%)100.0%

Sample

1st row온라인친구
2nd row핑크프로덕션
3rd row셈미디어
4th row개미
5th row오아이(5i) 커뮤니케이션
ValueCountFrequency (%)
주식회사 16
 
19.3%
온라인친구 1
 
1.2%
인천점 1
 
1.2%
꿈그리다 1
 
1.2%
스쿨에듀 1
 
1.2%
액츠29 1
 
1.2%
주)퍼스트인컴퍼니 1
 
1.2%
호스 1
 
1.2%
시카고라운지 1
 
1.2%
케이엠지엠 1
 
1.2%
Other values (58) 58
69.9%
2023-12-13T05:28:19.314120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
27
 
5.8%
24
 
5.1%
20
 
4.3%
17
 
3.6%
17
 
3.6%
16
 
3.4%
16
 
3.4%
( 13
 
2.8%
) 13
 
2.8%
12
 
2.6%
Other values (154) 293
62.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 402
85.9%
Space Separator 24
 
5.1%
Open Punctuation 13
 
2.8%
Close Punctuation 13
 
2.8%
Lowercase Letter 6
 
1.3%
Uppercase Letter 6
 
1.3%
Decimal Number 3
 
0.6%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
27
 
6.7%
20
 
5.0%
17
 
4.2%
17
 
4.2%
16
 
4.0%
16
 
4.0%
12
 
3.0%
9
 
2.2%
8
 
2.0%
7
 
1.7%
Other values (136) 253
62.9%
Uppercase Letter
ValueCountFrequency (%)
S 1
16.7%
E 1
16.7%
V 1
16.7%
I 1
16.7%
A 1
16.7%
N 1
16.7%
Lowercase Letter
ValueCountFrequency (%)
i 2
33.3%
o 1
16.7%
d 1
16.7%
u 1
16.7%
t 1
16.7%
Decimal Number
ValueCountFrequency (%)
9 1
33.3%
2 1
33.3%
5 1
33.3%
Space Separator
ValueCountFrequency (%)
24
100.0%
Open Punctuation
ValueCountFrequency (%)
( 13
100.0%
Close Punctuation
ValueCountFrequency (%)
) 13
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 402
85.9%
Common 54
 
11.5%
Latin 12
 
2.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
27
 
6.7%
20
 
5.0%
17
 
4.2%
17
 
4.2%
16
 
4.0%
16
 
4.0%
12
 
3.0%
9
 
2.2%
8
 
2.0%
7
 
1.7%
Other values (136) 253
62.9%
Latin
ValueCountFrequency (%)
i 2
16.7%
o 1
8.3%
d 1
8.3%
u 1
8.3%
t 1
8.3%
S 1
8.3%
E 1
8.3%
V 1
8.3%
I 1
8.3%
A 1
8.3%
Common
ValueCountFrequency (%)
24
44.4%
( 13
24.1%
) 13
24.1%
9 1
 
1.9%
2 1
 
1.9%
5 1
 
1.9%
& 1
 
1.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 402
85.9%
ASCII 66
 
14.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
27
 
6.7%
20
 
5.0%
17
 
4.2%
17
 
4.2%
16
 
4.0%
16
 
4.0%
12
 
3.0%
9
 
2.2%
8
 
2.0%
7
 
1.7%
Other values (136) 253
62.9%
ASCII
ValueCountFrequency (%)
24
36.4%
( 13
19.7%
) 13
19.7%
i 2
 
3.0%
9 1
 
1.5%
2 1
 
1.5%
o 1
 
1.5%
d 1
 
1.5%
u 1
 
1.5%
t 1
 
1.5%
Other values (8) 8
 
12.1%
Distinct55
Distinct (%)93.2%
Missing0
Missing (%)0.0%
Memory size604.0 B
2023-12-13T05:28:19.574671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length45
Median length36
Mean length28
Min length17

Characters and Unicode

Total characters1652
Distinct characters150
Distinct categories6 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique52 ?
Unique (%)88.1%

Sample

1st row인천광역시 서구 가좌동 173-294
2nd row인천광역시 서구 검암동 603-3 우영맨션 101동 201호
3rd row인천광역시 서구 가정동 567 한국아파트상가 205호
4th row인천광역시 서구 당하동 1027-15 신안실크벨리아파트 509동 402호
5th row인천광역시 서구 검암동 641-5 굿모닝타운 102동 203호
ValueCountFrequency (%)
인천광역시 59
 
18.1%
서구 59
 
18.1%
청라동 19
 
5.8%
원당동 6
 
1.8%
202-5 6
 
1.8%
당하동 6
 
1.8%
왕길동 5
 
1.5%
가정동 5
 
1.5%
석남동 3
 
0.9%
대산프라자 3
 
0.9%
Other values (134) 155
47.5%
2023-12-13T05:28:20.037718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
300
 
18.2%
1 86
 
5.2%
73
 
4.4%
64
 
3.9%
0 64
 
3.9%
59
 
3.6%
59
 
3.6%
59
 
3.6%
59
 
3.6%
59
 
3.6%
Other values (140) 770
46.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 903
54.7%
Decimal Number 382
23.1%
Space Separator 300
 
18.2%
Dash Punctuation 56
 
3.4%
Uppercase Letter 10
 
0.6%
Letter Number 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
73
 
8.1%
64
 
7.1%
59
 
6.5%
59
 
6.5%
59
 
6.5%
59
 
6.5%
59
 
6.5%
59
 
6.5%
37
 
4.1%
28
 
3.1%
Other values (118) 347
38.4%
Decimal Number
ValueCountFrequency (%)
1 86
22.5%
0 64
16.8%
2 55
14.4%
5 41
10.7%
6 27
 
7.1%
3 27
 
7.1%
4 26
 
6.8%
8 24
 
6.3%
7 16
 
4.2%
9 16
 
4.2%
Uppercase Letter
ValueCountFrequency (%)
K 2
20.0%
S 1
10.0%
V 1
10.0%
I 1
10.0%
B 1
10.0%
E 1
10.0%
G 1
10.0%
J 1
10.0%
W 1
10.0%
Space Separator
ValueCountFrequency (%)
300
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 56
100.0%
Letter Number
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 903
54.7%
Common 738
44.7%
Latin 11
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
73
 
8.1%
64
 
7.1%
59
 
6.5%
59
 
6.5%
59
 
6.5%
59
 
6.5%
59
 
6.5%
59
 
6.5%
37
 
4.1%
28
 
3.1%
Other values (118) 347
38.4%
Common
ValueCountFrequency (%)
300
40.7%
1 86
 
11.7%
0 64
 
8.7%
- 56
 
7.6%
2 55
 
7.5%
5 41
 
5.6%
6 27
 
3.7%
3 27
 
3.7%
4 26
 
3.5%
8 24
 
3.3%
Other values (2) 32
 
4.3%
Latin
ValueCountFrequency (%)
K 2
18.2%
S 1
9.1%
V 1
9.1%
I 1
9.1%
B 1
9.1%
E 1
9.1%
G 1
9.1%
J 1
9.1%
1
9.1%
W 1
9.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 903
54.7%
ASCII 748
45.3%
Number Forms 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
300
40.1%
1 86
 
11.5%
0 64
 
8.6%
- 56
 
7.5%
2 55
 
7.4%
5 41
 
5.5%
6 27
 
3.6%
3 27
 
3.6%
4 26
 
3.5%
8 24
 
3.2%
Other values (11) 42
 
5.6%
Hangul
ValueCountFrequency (%)
73
 
8.1%
64
 
7.1%
59
 
6.5%
59
 
6.5%
59
 
6.5%
59
 
6.5%
59
 
6.5%
59
 
6.5%
37
 
4.1%
28
 
3.1%
Other values (118) 347
38.4%
Number Forms
ValueCountFrequency (%)
1
100.0%

전화번호
Text

MISSING 

Distinct6
Distinct (%)100.0%
Missing53
Missing (%)89.8%
Memory size604.0 B
2023-12-13T05:28:20.233446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length10.5
Mean length10.5
Min length9

Characters and Unicode

Total characters63
Distinct characters11
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique6 ?
Unique (%)100.0%

Sample

1st row032-567-1691
2nd row1544-5687
3rd row032-727-5181
4th row1522-9221
5th row032-566-6611
ValueCountFrequency (%)
032-567-1691 1
16.7%
1544-5687 1
16.7%
032-727-5181 1
16.7%
1522-9221 1
16.7%
032-566-6611 1
16.7%
1661-8667 1
16.7%
2023-12-13T05:28:20.594751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6 11
17.5%
1 11
17.5%
- 9
14.3%
2 8
12.7%
5 6
9.5%
7 5
7.9%
0 3
 
4.8%
3 3
 
4.8%
8 3
 
4.8%
9 2
 
3.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 54
85.7%
Dash Punctuation 9
 
14.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 11
20.4%
1 11
20.4%
2 8
14.8%
5 6
11.1%
7 5
9.3%
0 3
 
5.6%
3 3
 
5.6%
8 3
 
5.6%
9 2
 
3.7%
4 2
 
3.7%
Dash Punctuation
ValueCountFrequency (%)
- 9
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 63
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
6 11
17.5%
1 11
17.5%
- 9
14.3%
2 8
12.7%
5 6
9.5%
7 5
7.9%
0 3
 
4.8%
3 3
 
4.8%
8 3
 
4.8%
9 2
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 63
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6 11
17.5%
1 11
17.5%
- 9
14.3%
2 8
12.7%
5 6
9.5%
7 5
7.9%
0 3
 
4.8%
3 3
 
4.8%
8 3
 
4.8%
9 2
 
3.2%
Distinct45
Distinct (%)76.3%
Missing0
Missing (%)0.0%
Memory size604.0 B
2023-12-13T05:28:20.835380image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length45
Median length25
Mean length10.220339
Min length2

Characters and Unicode

Total characters603
Distinct characters103
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

Unique36 ?
Unique (%)61.0%

Sample

1st row전자상거래소프트웨워개발
2nd row단편 성인비디오
3rd row레슨, 음악, 무용 등
4th row방송프로그램
5th row비디오
ValueCountFrequency (%)
비디오물 14
 
9.7%
영상 12
 
8.3%
광고 9
 
6.2%
8
 
5.5%
7
 
4.8%
홍보영상 6
 
4.1%
제작 6
 
4.1%
영화 6
 
4.1%
각종 4
 
2.8%
관련 3
 
2.1%
Other values (55) 70
48.3%
2023-12-13T05:28:21.233626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
86
 
14.3%
47
 
7.8%
40
 
6.6%
, 31
 
5.1%
25
 
4.1%
24
 
4.0%
24
 
4.0%
22
 
3.6%
17
 
2.8%
17
 
2.8%
Other values (93) 270
44.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 473
78.4%
Space Separator 86
 
14.3%
Other Punctuation 31
 
5.1%
Uppercase Letter 8
 
1.3%
Decimal Number 3
 
0.5%
Open Punctuation 1
 
0.2%
Close Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
47
 
9.9%
40
 
8.5%
25
 
5.3%
24
 
5.1%
24
 
5.1%
22
 
4.7%
17
 
3.6%
17
 
3.6%
17
 
3.6%
17
 
3.6%
Other values (83) 223
47.1%
Uppercase Letter
ValueCountFrequency (%)
V 4
50.0%
R 2
25.0%
T 2
25.0%
Decimal Number
ValueCountFrequency (%)
3 1
33.3%
6 1
33.3%
0 1
33.3%
Space Separator
ValueCountFrequency (%)
86
100.0%
Other Punctuation
ValueCountFrequency (%)
, 31
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 473
78.4%
Common 122
 
20.2%
Latin 8
 
1.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
47
 
9.9%
40
 
8.5%
25
 
5.3%
24
 
5.1%
24
 
5.1%
22
 
4.7%
17
 
3.6%
17
 
3.6%
17
 
3.6%
17
 
3.6%
Other values (83) 223
47.1%
Common
ValueCountFrequency (%)
86
70.5%
, 31
 
25.4%
( 1
 
0.8%
) 1
 
0.8%
3 1
 
0.8%
6 1
 
0.8%
0 1
 
0.8%
Latin
ValueCountFrequency (%)
V 4
50.0%
R 2
25.0%
T 2
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 473
78.4%
ASCII 130
 
21.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
86
66.2%
, 31
 
23.8%
V 4
 
3.1%
R 2
 
1.5%
T 2
 
1.5%
( 1
 
0.8%
) 1
 
0.8%
3 1
 
0.8%
6 1
 
0.8%
0 1
 
0.8%
Hangul
ValueCountFrequency (%)
47
 
9.9%
40
 
8.5%
25
 
5.3%
24
 
5.1%
24
 
5.1%
22
 
4.7%
17
 
3.6%
17
 
3.6%
17
 
3.6%
17
 
3.6%
Other values (83) 223
47.1%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size604.0 B
2023-03-30
59 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-03-30
2nd row2023-03-30
3rd row2023-03-30
4th row2023-03-30
5th row2023-03-30

Common Values

ValueCountFrequency (%)
2023-03-30 59
100.0%

Length

2023-12-13T05:28:21.360998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:28:21.446161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-03-30 59
100.0%

Interactions

2023-12-13T05:28:17.801937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T05:28:21.513643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번상호영업소소재지(지번)전화번호취급_제작품목
연번1.0001.0000.7451.0000.877
상호1.0001.0001.0001.0001.000
영업소소재지(지번)0.7451.0001.0001.0000.984
전화번호1.0001.0001.0001.0001.000
취급_제작품목0.8771.0000.9841.0001.000

Missing values

2023-12-13T05:28:17.919900image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T05:28:18.045381image/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온라인친구인천광역시 서구 가좌동 173-294<NA>전자상거래소프트웨워개발2023-03-30
12핑크프로덕션인천광역시 서구 검암동 603-3 우영맨션 101동 201호<NA>단편 성인비디오2023-03-30
23셈미디어인천광역시 서구 가정동 567 한국아파트상가 205호032-567-1691레슨, 음악, 무용 등2023-03-30
34개미인천광역시 서구 당하동 1027-15 신안실크벨리아파트 509동 402호<NA>방송프로그램2023-03-30
45오아이(5i) 커뮤니케이션인천광역시 서구 검암동 641-5 굿모닝타운 102동 203호<NA>비디오2023-03-30
56주식회사 드림스케치인천광역시 서구 왕길동 662-1 트리풀타워<NA>비디오물제작2023-03-30
67주식회사 루트인천광역시 서구 청라동 5-1<NA>광고,홍보,영상 관련 비디오물2023-03-30
78(주)광성공사인천광역시 서구 심곡동 278-14<NA>광고, 홍보 관련 비디오물2023-03-30
89청라국제방송인천광역시 서구 청라동 152-10 205호<NA>실시간 방송, 360 VR2023-03-30
910이온인천광역시 서구 당하동 1037-3 302동 1203호<NA>광고, 영화비디오물2023-03-30
연번상호영업소소재지(지번)전화번호취급_제작품목데이터기준일자
4950주식회사 베스트컴퍼니플러스인천광역시 서구 청라동 202-5 에이스하이테크시티청라 3동 601호<NA>비디오물2023-03-30
5051(주)초록길미디어인천광역시 서구 원당동 824-10 대산프라자<NA>영상제작2023-03-30
5152토모플래닝인천광역시 서구 공촌동 307-30 104호<NA>세미나 영상 중계 촬영2023-03-30
5253(주)더원아트코리아인천광역시 서구 가정동 565-13<NA>광고영상, 홍보영상, 기획영상 등 영상 제작 관련 일체2023-03-30
5354나이브 스튜디오(NAIVE Studio)인천광역시 서구 청라동 115-1 청라제일풍경채<NA>홍보 영상, 브랜드 영상, 광고, 교육 영상, 행사 영상2023-03-30
5455제이엠씨인천광역시 서구 청라동 104-145 202호<NA>TV프로그램, 웹 동영상, 공공기관 홍보영상 제작2023-03-30
5556오우오스튜디오인천광역시 서구 당하동 1090-1 검단 힐스테이트 4차 405동 804호<NA>광고 영화 및 비디오물, 일반 영화 및 비디오물, 애니메이션 영화 및 비디오물 등2023-03-30
5657에딧츠 바이인천광역시 서구 원당동 987-1 검단신도시 디에트르 더 힐 2918동 1201호<NA>광고 영화 및 비디오물2023-03-30
5758(주)공공환경디자인연구소인천광역시 서구 청라동 202-5 청라에이스하이테크시티 1동 530호<NA>지자체 홍보영상 및 각종 웹 동영상2023-03-30
5859브리즈인천광역시 서구 청라동 103-16 청라 SK VIEW 503동 1004호<NA>방송영상,광고,기업홍보,애니메이션,VR영상 등2023-03-30