Overview

Dataset statistics

Number of variables5
Number of observations63
Missing cells63
Missing cells (%)20.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.7 KiB
Average record size in memory44.1 B

Variable types

Categorical2
Text1
Numeric2

Dataset

Description대전예술의전당 무대조명 기자재 현황(아트홀, 앙상블홀) 콘솔 , 디머, 스팟라이트, 무빙라이트, 파라이트 등 장비의 수량과 기자재의 종류를 목록별로 정리한 파일입니다. 아트홀, 앙상블홀 및 공용으로 사용할 수 있는 장비를 확인 할 수 있습니다.
URLhttps://www.data.go.kr/data/15081825/fileData.do

Alerts

공용장비 is highly overall correlated with 라이트 목록High correlation
라이트 목록 is highly overall correlated with 공용장비High correlation
전용장비 has 38 (60.3%) missing valuesMissing
공용장비 has 25 (39.7%) missing valuesMissing

Reproduction

Analysis started2023-12-12 13:34:20.948196
Analysis finished2023-12-12 13:34:21.803288
Duration0.86 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

Distinct2
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Memory size636.0 B
아트홀
32 
앙상블홀
31 

Length

Max length4
Median length3
Mean length3.4920635
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row아트홀
2nd row아트홀
3rd row아트홀
4th row아트홀
5th row아트홀

Common Values

ValueCountFrequency (%)
아트홀 32
50.8%
앙상블홀 31
49.2%

Length

2023-12-12T22:34:21.886333image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:34:22.018715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
아트홀 32
50.8%
앙상블홀 31
49.2%

라이트 목록
Categorical

HIGH CORRELATION 

Distinct18
Distinct (%)28.6%
Missing0
Missing (%)0.0%
Memory size636.0 B
Moving Light
8 
Zoom Profile Spot Light (w/ Gobo Holder & Iris)
7 
Par Light
6 
Cyclorama Light
6 
Control Console
4 
Other values (13)
32 

Length

Max length47
Median length28
Mean length20.555556
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowControl Console
2nd rowControl Console
3rd rowZoom Profile Spot Light (w/ Gobo Holder & Iris)
4th rowZoom Profile Spot Light (w/ Gobo Holder & Iris)
5th rowZoom Profile Spot Light (w/ Gobo Holder & Iris)

Common Values

ValueCountFrequency (%)
Moving Light 8
12.7%
Zoom Profile Spot Light (w/ Gobo Holder & Iris) 7
11.1%
Par Light 6
 
9.5%
Cyclorama Light 6
 
9.5%
Control Console 4
 
6.3%
HMI Spot Light (w/ Barndoor) 4
 
6.3%
Fresnel Spot Light (w/ Barndoor) 4
 
6.3%
Plano Convex Spot Light (w/ Barndoor) 4
 
6.3%
Dry Ice Machine 2
 
3.2%
Diffusion Fog Machine 2
 
3.2%
Other values (8) 16
25.4%

Length

2023-12-12T22:34:22.154971image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
light 51
22.7%
spot 21
 
9.3%
w 19
 
8.4%
barndoor 12
 
5.3%
machine 8
 
3.6%
moving 8
 
3.6%
gobo 7
 
3.1%
holder 7
 
3.1%
iris 7
 
3.1%
profile 7
 
3.1%
Other values (22) 78
34.7%

제품명
Text

Distinct34
Distinct (%)54.0%
Missing0
Missing (%)0.0%
Memory size636.0 B
2023-12-12T22:34:22.486357image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length26
Mean length20.126984
Min length5

Characters and Unicode

Total characters1268
Distinct characters66
Distinct categories10 ?
Distinct scripts2 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique5 ?
Unique (%)7.9%

Sample

1st rowGrand MA2
2nd rowETC Element 2
3rd rowRobert Juliat 710 SX2 10∼25˚ (2.5Kw)
4th rowETC Source Four 10˚ (750w)
5th rowETC Source Four 25~50˚ (750w)
ValueCountFrequency (%)
etc 10
 
4.3%
500w 8
 
3.4%
1kw 6
 
2.6%
adb 6
 
2.6%
750w 6
 
2.6%
par 6
 
2.6%
four 6
 
2.6%
source 6
 
2.6%
6
 
2.6%
pr 4
 
1.7%
Other values (79) 168
72.4%
2023-12-12T22:34:22.946226image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
169
 
13.3%
0 90
 
7.1%
A 50
 
3.9%
5 48
 
3.8%
) 41
 
3.2%
( 41
 
3.2%
w 41
 
3.2%
r 35
 
2.8%
1 32
 
2.5%
L 30
 
2.4%
Other values (56) 691
54.5%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 423
33.4%
Lowercase Letter 289
22.8%
Decimal Number 252
19.9%
Space Separator 169
 
13.3%
Close Punctuation 41
 
3.2%
Open Punctuation 41
 
3.2%
Dash Punctuation 16
 
1.3%
Math Symbol 13
 
1.0%
Other Punctuation 13
 
1.0%
Modifier Symbol 11
 
0.9%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
A 50
 
11.8%
L 30
 
7.1%
S 29
 
6.9%
C 26
 
6.1%
R 25
 
5.9%
T 24
 
5.7%
F 24
 
5.7%
P 24
 
5.7%
E 24
 
5.7%
M 24
 
5.7%
Other values (15) 143
33.8%
Lowercase Letter
ValueCountFrequency (%)
w 41
14.2%
r 35
12.1%
o 27
9.3%
a 27
9.3%
e 25
 
8.7%
u 19
 
6.6%
l 15
 
5.2%
i 13
 
4.5%
n 12
 
4.2%
c 12
 
4.2%
Other values (11) 63
21.8%
Decimal Number
ValueCountFrequency (%)
0 90
35.7%
5 48
19.0%
1 32
 
12.7%
3 24
 
9.5%
2 23
 
9.1%
4 14
 
5.6%
7 9
 
3.6%
6 6
 
2.4%
8 6
 
2.4%
Math Symbol
ValueCountFrequency (%)
~ 8
61.5%
× 4
30.8%
∼ 1
 
7.7%
Other Punctuation
ValueCountFrequency (%)
, 6
46.2%
. 5
38.5%
/ 2
 
15.4%
Space Separator
ValueCountFrequency (%)
169
100.0%
Close Punctuation
ValueCountFrequency (%)
) 41
100.0%
Open Punctuation
ValueCountFrequency (%)
( 41
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 16
100.0%
Modifier Symbol
ValueCountFrequency (%)
˚ 11
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 712
56.2%
Common 556
43.8%

Most frequent character per script

Latin
ValueCountFrequency (%)
A 50
 
7.0%
w 41
 
5.8%
r 35
 
4.9%
L 30
 
4.2%
S 29
 
4.1%
o 27
 
3.8%
a 27
 
3.8%
C 26
 
3.7%
R 25
 
3.5%
e 25
 
3.5%
Other values (36) 397
55.8%
Common
ValueCountFrequency (%)
169
30.4%
0 90
16.2%
5 48
 
8.6%
) 41
 
7.4%
( 41
 
7.4%
1 32
 
5.8%
3 24
 
4.3%
2 23
 
4.1%
- 16
 
2.9%
4 14
 
2.5%
Other values (10) 58
 
10.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1252
98.7%
Modifier Letters 11
 
0.9%
None 4
 
0.3%
Math Operators 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
169
 
13.5%
0 90
 
7.2%
A 50
 
4.0%
5 48
 
3.8%
) 41
 
3.3%
( 41
 
3.3%
w 41
 
3.3%
r 35
 
2.8%
1 32
 
2.6%
L 30
 
2.4%
Other values (53) 675
53.9%
Modifier Letters
ValueCountFrequency (%)
˚ 11
100.0%
None
ValueCountFrequency (%)
× 4
100.0%
Math Operators
ValueCountFrequency (%)
∼ 1
100.0%

전용장비
Real number (ℝ)

MISSING 

Distinct15
Distinct (%)60.0%
Missing38
Missing (%)60.3%
Infinite0
Infinite (%)0.0%
Mean78.32
Minimum1
Maximum440
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size699.0 B
2023-12-12T22:34:23.121907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median70
Q3104
95-th percentile275
Maximum440
Range439
Interquartile range (IQR)102

Descriptive statistics

Standard deviation106.02269
Coefficient of variation (CV)1.3537115
Kurtosis5.0799665
Mean78.32
Median Absolute Deviation (MAD)68
Skewness2.0616579
Sum1958
Variance11240.81
MonotonicityNot monotonic
2023-12-12T22:34:23.242829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
2 6
 
9.5%
1 5
 
7.9%
96 2
 
3.2%
80 1
 
1.6%
440 1
 
1.6%
88 1
 
1.6%
5 1
 
1.6%
145 1
 
1.6%
175 1
 
1.6%
104 1
 
1.6%
Other values (5) 5
 
7.9%
(Missing) 38
60.3%
ValueCountFrequency (%)
1 5
7.9%
2 6
9.5%
5 1
 
1.6%
70 1
 
1.6%
80 1
 
1.6%
88 1
 
1.6%
95 1
 
1.6%
96 2
 
3.2%
104 1
 
1.6%
122 1
 
1.6%
ValueCountFrequency (%)
440 1
1.6%
300 1
1.6%
175 1
1.6%
145 1
1.6%
125 1
1.6%
122 1
1.6%
104 1
1.6%
96 2
3.2%
95 1
1.6%
88 1
1.6%

공용장비
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct11
Distinct (%)28.9%
Missing25
Missing (%)39.7%
Infinite0
Infinite (%)0.0%
Mean23.263158
Minimum2
Maximum50
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size699.0 B
2023-12-12T22:34:23.364701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile3.7
Q18
median30
Q334.5
95-th percentile41.5
Maximum50
Range48
Interquartile range (IQR)26.5

Descriptive statistics

Standard deviation14.604117
Coefficient of variation (CV)0.62777878
Kurtosis-1.2546155
Mean23.263158
Median Absolute Deviation (MAD)10
Skewness-0.030158401
Sum884
Variance213.28023
MonotonicityNot monotonic
2023-12-12T22:34:23.485867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
30 10
 
15.9%
8 4
 
6.3%
4 4
 
6.3%
16 4
 
6.3%
40 4
 
6.3%
36 2
 
3.2%
50 2
 
3.2%
2 2
 
3.2%
24 2
 
3.2%
38 2
 
3.2%
(Missing) 25
39.7%
ValueCountFrequency (%)
2 2
 
3.2%
4 4
 
6.3%
6 2
 
3.2%
8 4
 
6.3%
16 4
 
6.3%
24 2
 
3.2%
30 10
15.9%
36 2
 
3.2%
38 2
 
3.2%
40 4
 
6.3%
ValueCountFrequency (%)
50 2
 
3.2%
40 4
 
6.3%
38 2
 
3.2%
36 2
 
3.2%
30 10
15.9%
24 2
 
3.2%
16 4
 
6.3%
8 4
 
6.3%
6 2
 
3.2%
4 4
 
6.3%

Interactions

2023-12-12T22:34:21.322428image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:34:21.146000image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:34:21.403650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:34:21.233477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T22:34:23.619380image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분라이트 목록제품명전용장비공용장비
구분1.0000.0000.0000.0000.000
라이트 목록0.0001.0001.0000.4340.863
제품명0.0001.0001.0000.6351.000
전용장비0.0000.4340.6351.000NaN
공용장비0.0000.8631.000NaN1.000
2023-12-12T22:34:23.744153image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분라이트 목록
구분1.0000.000
라이트 목록0.0001.000
2023-12-12T22:34:23.845550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전용장비공용장비구분라이트 목록
전용장비1.000NaN0.0000.172
공용장비NaN1.0000.0000.565
구분0.0000.0001.0000.000
라이트 목록0.1720.5650.0001.000

Missing values

2023-12-12T22:34:21.526601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T22:34:21.646126image/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-12T22:34:21.759255image/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

구분라이트 목록제품명전용장비공용장비
0아트홀Control ConsoleGrand MA22<NA>
1아트홀Control ConsoleETC Element 21<NA>
2아트홀Zoom Profile Spot Light (w/ Gobo Holder & Iris)Robert Juliat 710 SX2 10∼25˚ (2.5Kw)96<NA>
3아트홀Zoom Profile Spot Light (w/ Gobo Holder & Iris)ETC Source Four 10˚ (750w)<NA>36
4아트홀Zoom Profile Spot Light (w/ Gobo Holder & Iris)ETC Source Four 25~50˚ (750w)80<NA>
5아트홀Zoom Profile Spot Light (w/ Gobo Holder & Iris)ETC Source Four 15~30˚ (750w)440<NA>
6아트홀Plano Convex Spot Light (w/ Barndoor)ADB C203S 8~58˚ (2Kw)<NA>30
7아트홀Plano Convex Spot Light (w/ Barndoor)ADB C103S 7~61˚ (1Kw)<NA>50
8아트홀Fresnel Spot Light (w/ Barndoor)MARUMO FQH2 (1.5Kw)88<NA>
9아트홀Fresnel Spot Light (w/ Barndoor)MARUMO FQH (5Kw)<NA>8
구분라이트 목록제품명전용장비공용장비
53앙상블홀Par LightPAR 46 (250w)96<NA>
54앙상블홀Par LightPAR BANK (250w)<NA>40
55앙상블홀Strobe LightDiversitronics 0455 3000-DMX (3000w)<NA>6
56앙상블홀Fill LightADB LF/HF 1000 (1Kw)<NA>30
57앙상블홀Punch LightRIBALTA1 PR 1350 (500w)<NA>30
58앙상블홀Dry Ice MachineAQUAFOG 3300<NA>4
59앙상블홀Black LightWOOD40 UV BLACK LIGHT<NA>30
60앙상블홀MDG Fog MachineATMOSPHERE APS1<NA>
61앙상블홀Diffusion Fog MachineDF-501<NA>
62앙상블홀Fog MachineF-1002<NA>