Overview

Dataset statistics

Number of variables18
Number of observations100
Missing cells800
Missing cells (%)44.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory15.9 KiB
Average record size in memory163.3 B

Variable types

Categorical8
Unsupported8
Numeric2

Dataset

DescriptionSample
Author인하대학교 산학협력단
URLhttps://www.bigdata-coast.kr/gdsInfo/gdsInfoDetail.do?gdsCd=CT03IHU002

Alerts

WTCH_YR has constant value ""Constant
WTCH_MNTH has constant value ""Constant
WTCH_DD has constant value ""Constant
WTCH_HHS has constant value ""Constant
WTCH_SEC has constant value ""Constant
WTCH_LO is highly overall correlated with WTCH_MIN and 1 other fieldsHigh correlation
WTCH_LA is highly overall correlated with WTCH_MIN and 1 other fieldsHigh correlation
WTCH_MIN is highly overall correlated with WTCH_LA and 1 other fieldsHigh correlation
WTCH_WTDP is highly overall correlated with WTCH_SLNTYHigh correlation
WTCH_SLNTY is highly overall correlated with WTCH_WTDPHigh correlation
WTCH_WTRLV has 100 (100.0%) missing valuesMissing
WTCH_CRSPD has 100 (100.0%) missing valuesMissing
WTCH_CRDRC has 100 (100.0%) missing valuesMissing
WTCH_WTEM has 100 (100.0%) missing valuesMissing
SSC_CCTR has 100 (100.0%) missing valuesMissing
MVMN_DRC has 100 (100.0%) missing valuesMissing
MVMN_VE has 100 (100.0%) missing valuesMissing
WTDP_VARTION_QY has 100 (100.0%) missing valuesMissing
WTCH_SLNTY has unique valuesUnique
WTCH_WTRLV is an unsupported type, check if it needs cleaning or further analysisUnsupported
WTCH_CRSPD is an unsupported type, check if it needs cleaning or further analysisUnsupported
WTCH_CRDRC is an unsupported type, check if it needs cleaning or further analysisUnsupported
WTCH_WTEM is an unsupported type, check if it needs cleaning or further analysisUnsupported
SSC_CCTR is an unsupported type, check if it needs cleaning or further analysisUnsupported
MVMN_DRC is an unsupported type, check if it needs cleaning or further analysisUnsupported
MVMN_VE is an unsupported type, check if it needs cleaning or further analysisUnsupported
WTDP_VARTION_QY is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-03-13 12:53:46.932953
Analysis finished2024-03-13 12:53:48.286355
Duration1.35 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

WTCH_YR
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2012
100 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2012 100
100.0%

Length

2024-03-13T21:53:48.837042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T21:53:48.973968image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2012 100
100.0%

WTCH_MNTH
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
7
100 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
7 100
100.0%

Length

2024-03-13T21:53:49.127743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T21:53:49.229133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
7 100
100.0%

WTCH_DD
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
20
100 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
20 100
100.0%

Length

2024-03-13T21:53:49.356715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T21:53:49.500222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20 100
100.0%

WTCH_HHS
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
8
100 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
8 100
100.0%

Length

2024-03-13T21:53:49.684814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T21:53:49.828673image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
8 100
100.0%

WTCH_MIN
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
10
62 
13
38 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
10 62
62.0%
13 38
38.0%

Length

2024-03-13T21:53:49.958325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T21:53:50.100236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
10 62
62.0%
13 38
38.0%

WTCH_SEC
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
0
100 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 100
100.0%

Length

2024-03-13T21:53:50.246654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T21:53:50.364681image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 100
100.0%

WTCH_LA
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
34.782278
62 
34.786194
38 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row34.782278
2nd row34.782278
3rd row34.782278
4th row34.782278
5th row34.782278

Common Values

ValueCountFrequency (%)
34.782278 62
62.0%
34.786194 38
38.0%

Length

2024-03-13T21:53:50.493882image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T21:53:50.622542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
34.782278 62
62.0%
34.786194 38
38.0%

WTCH_LO
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
126.433667
62 
126.4315
38 

Length

Max length10
Median length10
Mean length9.24
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row126.433667
2nd row126.433667
3rd row126.433667
4th row126.433667
5th row126.433667

Common Values

ValueCountFrequency (%)
126.433667 62
62.0%
126.4315 38
38.0%

Length

2024-03-13T21:53:50.805573image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T21:53:50.999140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
126.433667 62
62.0%
126.4315 38
38.0%

WTCH_WTRLV
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

WTCH_WTDP
Real number (ℝ)

HIGH CORRELATION 

Distinct62
Distinct (%)62.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7.365
Minimum0.88
Maximum16.13
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2024-03-13T21:53:51.161800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.88
5-th percentile1.38
Q13.88
median7.005
Q310.13
95-th percentile14.8925
Maximum16.13
Range15.25
Interquartile range (IQR)6.25

Descriptive statistics

Standard deviation4.1906612
Coefficient of variation (CV)0.56899677
Kurtosis-0.8410014
Mean7.365
Median Absolute Deviation (MAD)3.125
Skewness0.34982767
Sum736.5
Variance17.561641
MonotonicityNot monotonic
2024-03-13T21:53:51.364645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.88 2
 
2.0%
8.13 2
 
2.0%
6.38 2
 
2.0%
6.63 2
 
2.0%
6.88 2
 
2.0%
7.13 2
 
2.0%
7.38 2
 
2.0%
7.63 2
 
2.0%
7.88 2
 
2.0%
8.38 2
 
2.0%
Other values (52) 80
80.0%
ValueCountFrequency (%)
0.88 2
2.0%
1.13 2
2.0%
1.38 2
2.0%
1.63 2
2.0%
1.88 2
2.0%
2.13 2
2.0%
2.38 2
2.0%
2.63 2
2.0%
2.88 2
2.0%
3.13 2
2.0%
ValueCountFrequency (%)
16.13 1
1.0%
15.88 1
1.0%
15.63 1
1.0%
15.38 1
1.0%
15.13 1
1.0%
14.88 1
1.0%
14.63 1
1.0%
14.38 1
1.0%
14.13 1
1.0%
13.88 1
1.0%

WTCH_CRSPD
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

WTCH_CRDRC
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

WTCH_WTEM
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

WTCH_SLNTY
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean24.18141
Minimum4.93
Maximum29.372
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2024-03-13T21:53:51.561408image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4.93
5-th percentile7.955
Q123.17225
median27.8355
Q329.009
95-th percentile29.22765
Maximum29.372
Range24.442
Interquartile range (IQR)5.83675

Descriptive statistics

Standard deviation7.1708866
Coefficient of variation (CV)0.29654543
Kurtosis0.87707502
Mean24.18141
Median Absolute Deviation (MAD)1.346
Skewness-1.5105097
Sum2418.141
Variance51.421614
MonotonicityNot monotonic
2024-03-13T21:53:51.796421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
6.678 1
 
1.0%
6.868 1
 
1.0%
23.122 1
 
1.0%
22.25 1
 
1.0%
21.233 1
 
1.0%
19.442 1
 
1.0%
16.672 1
 
1.0%
12.915 1
 
1.0%
11.376 1
 
1.0%
10.231 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
4.93 1
1.0%
5.994 1
1.0%
6.678 1
1.0%
6.868 1
1.0%
7.67 1
1.0%
7.97 1
1.0%
8.066 1
1.0%
8.792 1
1.0%
9.149 1
1.0%
9.358 1
1.0%
ValueCountFrequency (%)
29.372 1
1.0%
29.345 1
1.0%
29.334 1
1.0%
29.298 1
1.0%
29.259 1
1.0%
29.226 1
1.0%
29.211 1
1.0%
29.206 1
1.0%
29.197 1
1.0%
29.184 1
1.0%

SSC_CCTR
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

MVMN_DRC
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

MVMN_VE
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

WTDP_VARTION_QY
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing100
Missing (%)100.0%
Memory size1.0 KiB

Interactions

2024-03-13T21:53:47.529952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T21:53:47.266410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T21:53:47.651382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T21:53:47.401253image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T21:53:51.970966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
WTCH_MINWTCH_LAWTCH_LOWTCH_WTDPWTCH_SLNTY
WTCH_MIN1.0000.9990.9990.4060.000
WTCH_LA0.9991.0000.9990.4060.000
WTCH_LO0.9990.9991.0000.4060.000
WTCH_WTDP0.4060.4060.4061.0000.877
WTCH_SLNTY0.0000.0000.0000.8771.000
2024-03-13T21:53:52.156818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
WTCH_LOWTCH_LAWTCH_MIN
WTCH_LO1.0000.9790.979
WTCH_LA0.9791.0000.979
WTCH_MIN0.9790.9791.000
2024-03-13T21:53:52.283995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
WTCH_WTDPWTCH_SLNTYWTCH_MINWTCH_LAWTCH_LO
WTCH_WTDP1.0000.9890.2970.2970.297
WTCH_SLNTY0.9891.0000.0000.0000.000
WTCH_MIN0.2970.0001.0000.9790.979
WTCH_LA0.2970.0000.9791.0000.979
WTCH_LO0.2970.0000.9790.9791.000

Missing values

2024-03-13T21:53:47.846650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T21:53:48.168616image/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

WTCH_YRWTCH_MNTHWTCH_DDWTCH_HHSWTCH_MINWTCH_SECWTCH_LAWTCH_LOWTCH_WTRLVWTCH_WTDPWTCH_CRSPDWTCH_CRDRCWTCH_WTEMWTCH_SLNTYSSC_CCTRMVMN_DRCMVMN_VEWTDP_VARTION_QY
02012720810034.782278126.433667<NA>0.88<NA><NA><NA>6.678<NA><NA><NA><NA>
12012720810034.782278126.433667<NA>1.13<NA><NA><NA>7.67<NA><NA><NA><NA>
22012720810034.782278126.433667<NA>1.38<NA><NA><NA>7.97<NA><NA><NA><NA>
32012720810034.782278126.433667<NA>1.63<NA><NA><NA>8.792<NA><NA><NA><NA>
42012720810034.782278126.433667<NA>1.88<NA><NA><NA>9.358<NA><NA><NA><NA>
52012720810034.782278126.433667<NA>2.13<NA><NA><NA>10.239<NA><NA><NA><NA>
62012720810034.782278126.433667<NA>2.38<NA><NA><NA>11.881<NA><NA><NA><NA>
72012720810034.782278126.433667<NA>2.63<NA><NA><NA>15.185<NA><NA><NA><NA>
82012720810034.782278126.433667<NA>2.88<NA><NA><NA>16.659<NA><NA><NA><NA>
92012720810034.782278126.433667<NA>3.13<NA><NA><NA>19.966<NA><NA><NA><NA>
WTCH_YRWTCH_MNTHWTCH_DDWTCH_HHSWTCH_MINWTCH_SECWTCH_LAWTCH_LOWTCH_WTRLVWTCH_WTDPWTCH_CRSPDWTCH_CRDRCWTCH_WTEMWTCH_SLNTYSSC_CCTRMVMN_DRCMVMN_VEWTDP_VARTION_QY
902012720813034.786194126.4315<NA>7.88<NA><NA><NA>28.737<NA><NA><NA><NA>
912012720813034.786194126.4315<NA>8.13<NA><NA><NA>28.773<NA><NA><NA><NA>
922012720813034.786194126.4315<NA>8.38<NA><NA><NA>28.805<NA><NA><NA><NA>
932012720813034.786194126.4315<NA>8.63<NA><NA><NA>28.816<NA><NA><NA><NA>
942012720813034.786194126.4315<NA>8.88<NA><NA><NA>28.837<NA><NA><NA><NA>
952012720813034.786194126.4315<NA>9.13<NA><NA><NA>28.918<NA><NA><NA><NA>
962012720813034.786194126.4315<NA>9.38<NA><NA><NA>29.008<NA><NA><NA><NA>
972012720813034.786194126.4315<NA>9.63<NA><NA><NA>29.127<NA><NA><NA><NA>
982012720813034.786194126.4315<NA>9.88<NA><NA><NA>29.152<NA><NA><NA><NA>
992012720813034.786194126.4315<NA>10.13<NA><NA><NA>29.181<NA><NA><NA><NA>