Overview

Dataset statistics

Number of variables11
Number of observations49
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.5 KiB
Average record size in memory93.7 B

Variable types

Numeric3
Categorical8

Dataset

DescriptionSample
Author에이치더블유
URLhttps://www.bigdata-sea.kr/datasearch/base/view.do?prodId=PROD_000064

Alerts

CTGRY_MLSFC_NM has constant value ""Constant
SOF has constant value ""Constant
PHOTO_INFO_ESSN_ID has constant value ""Constant
QLT_MSRM_RSLT is highly overall correlated with CNSGN_STNDRHigh correlation
CNSGN_STNDR is highly overall correlated with MCS_NM and 1 other fieldsHigh correlation
SEQ_NO is highly overall correlated with RN and 3 other fieldsHigh correlation
RN is highly overall correlated with SEQ_NO and 3 other fieldsHigh correlation
CNSGN_YMD is highly overall correlated with SEQ_NO and 3 other fieldsHigh correlation
MCS_NM is highly overall correlated with SEQ_NO and 4 other fieldsHigh correlation
SMRY_CONT is highly overall correlated with SEQ_NO and 3 other fieldsHigh correlation
SEQ_NO has unique valuesUnique
RN has unique valuesUnique

Reproduction

Analysis started2023-12-10 14:47:53.965356
Analysis finished2023-12-10 14:47:55.878506
Duration1.91 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

SEQ_NO
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct49
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean437
Minimum413
Maximum461
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size573.0 B
2023-12-10T23:47:55.946517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum413
5-th percentile415.4
Q1425
median437
Q3449
95-th percentile458.6
Maximum461
Range48
Interquartile range (IQR)24

Descriptive statistics

Standard deviation14.28869
Coefficient of variation (CV)0.032697232
Kurtosis-1.2
Mean437
Median Absolute Deviation (MAD)12
Skewness0
Sum21413
Variance204.16667
MonotonicityStrictly increasing
2023-12-10T23:47:56.124481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=49)
ValueCountFrequency (%)
413 1
 
2.0%
450 1
 
2.0%
440 1
 
2.0%
441 1
 
2.0%
442 1
 
2.0%
443 1
 
2.0%
444 1
 
2.0%
445 1
 
2.0%
446 1
 
2.0%
447 1
 
2.0%
Other values (39) 39
79.6%
ValueCountFrequency (%)
413 1
2.0%
414 1
2.0%
415 1
2.0%
416 1
2.0%
417 1
2.0%
418 1
2.0%
419 1
2.0%
420 1
2.0%
421 1
2.0%
422 1
2.0%
ValueCountFrequency (%)
461 1
2.0%
460 1
2.0%
459 1
2.0%
458 1
2.0%
457 1
2.0%
456 1
2.0%
455 1
2.0%
454 1
2.0%
453 1
2.0%
452 1
2.0%

CNSGN_YMD
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)8.2%
Missing0
Missing (%)0.0%
Memory size524.0 B
22-Sep-2015 00:00:00
18 
21-Sep-2015 00:00:00
13 
18-Sep-2015 00:00:00
12 
17-Sep-2015 00:00:00
6 

Length

Max length20
Median length20
Mean length20
Min length20

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row17-Sep-2015 00:00:00
2nd row17-Sep-2015 00:00:00
3rd row17-Sep-2015 00:00:00
4th row17-Sep-2015 00:00:00
5th row17-Sep-2015 00:00:00

Common Values

ValueCountFrequency (%)
22-Sep-2015 00:00:00 18
36.7%
21-Sep-2015 00:00:00 13
26.5%
18-Sep-2015 00:00:00 12
24.5%
17-Sep-2015 00:00:00 6
 
12.2%

Length

2023-12-10T23:47:56.293039image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:47:56.393175image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
00:00:00 49
50.0%
22-sep-2015 18
 
18.4%
21-sep-2015 13
 
13.3%
18-sep-2015 12
 
12.2%
17-sep-2015 6
 
6.1%

MCS_NM
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)4.1%
Missing0
Missing (%)0.0%
Memory size524.0 B
여수수협공판장
33 
마산수협공판장
16 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row마산수협공판장
2nd row마산수협공판장
3rd row여수수협공판장
4th row여수수협공판장
5th row여수수협공판장

Common Values

ValueCountFrequency (%)
여수수협공판장 33
67.3%
마산수협공판장 16
32.7%

Length

2023-12-10T23:47:56.515644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:47:56.617437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
여수수협공판장 33
67.3%
마산수협공판장 16
32.7%

CTGRY_MLSFC_NM
Categorical

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size524.0 B
연체류 해물모둠
49 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row연체류 해물모둠
2nd row연체류 해물모둠
3rd row연체류 해물모둠
4th row연체류 해물모둠
5th row연체류 해물모둠

Common Values

ValueCountFrequency (%)
연체류 해물모둠 49
100.0%

Length

2023-12-10T23:47:56.717289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:47:56.812011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
연체류 49
50.0%
해물모둠 49
50.0%

SOF
Categorical

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size524.0 B
오징어
49 

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 (%)
오징어 49
100.0%

Length

2023-12-10T23:47:56.922993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:47:57.029504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
오징어 49
100.0%

SMRY_CONT
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)4.1%
Missing0
Missing (%)0.0%
Memory size524.0 B
냉오징어
31 
오징어
18 

Length

Max length4
Median length4
Mean length3.6326531
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row오징어
2nd row오징어
3rd row냉오징어
4th row냉오징어
5th row냉오징어

Common Values

ValueCountFrequency (%)
냉오징어 31
63.3%
오징어 18
36.7%

Length

2023-12-10T23:47:57.145039image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:47:57.242534image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
냉오징어 31
63.3%
오징어 18
36.7%

CNSGN_STNDR
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)12.2%
Missing0
Missing (%)0.0%
Memory size524.0 B
무표
35 
2단
7 
3단
4 
3단파
 
1
小
 
1

Length

Max length3
Median length2
Mean length1.9795918
Min length1

Unique

Unique3 ?
Unique (%)6.1%

Sample

1st row무표
2nd row3단파
3rd row무표
4th row무표
5th row무표

Common Values

ValueCountFrequency (%)
무표 35
71.4%
2단 7
 
14.3%
3단 4
 
8.2%
3단파 1
 
2.0%
小 1
 
2.0%
B 1
 
2.0%

Length

2023-12-10T23:47:57.368057image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:47:57.489626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
무표 35
71.4%
2단 7
 
14.3%
3단 4
 
8.2%
3단파 1
 
2.0%
小 1
 
2.0%
b 1
 
2.0%

CNSGN_PRICE
Real number (ℝ)

Distinct38
Distinct (%)77.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean22936051
Minimum60000
Maximum1.419 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size573.0 B
2023-12-10T23:47:57.596809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum60000
5-th percentile193200
Q11245000
median14157000
Q315984000
95-th percentile92431800
Maximum1.419 × 108
Range1.4184 × 108
Interquartile range (IQR)14739000

Descriptive statistics

Standard deviation33241386
Coefficient of variation (CV)1.4493073
Kurtosis5.6706431
Mean22936051
Median Absolute Deviation (MAD)12912000
Skewness2.3603676
Sum1.1238665 × 109
Variance1.1049898 × 1015
MonotonicityNot monotonic
2023-12-10T23:47:57.719968image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=38)
ValueCountFrequency (%)
14157000 10
 
20.4%
420000 2
 
4.1%
13845000 2
 
4.1%
77307000 1
 
2.0%
58338000 1
 
2.0%
47697000 1
 
2.0%
560000 1
 
2.0%
102515000 1
 
2.0%
4896000 1
 
2.0%
297000 1
 
2.0%
Other values (28) 28
57.1%
ValueCountFrequency (%)
60000 1
2.0%
128000 1
2.0%
174000 1
2.0%
222000 1
2.0%
225000 1
2.0%
286000 1
2.0%
297000 1
2.0%
415000 1
2.0%
420000 2
4.1%
532000 1
2.0%
ValueCountFrequency (%)
141900000 1
2.0%
141875500 1
2.0%
102515000 1
2.0%
77307000 1
2.0%
59454000 1
2.0%
58338000 1
2.0%
54747000 1
2.0%
47697000 1
2.0%
43524000 1
2.0%
43416000 1
2.0%

QLT_MSRM_RSLT
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)6.1%
Missing0
Missing (%)0.0%
Memory size524.0 B
무표
35 
상
11 
하
 
3

Length

Max length4
Median length4
Mean length3.7142857
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row 무표
2nd row 하
3rd row 무표
4th row 무표
5th row 무표

Common Values

ValueCountFrequency (%)
무표 35
71.4%
상 11
 
22.4%
하 3
 
6.1%

Length

2023-12-10T23:47:57.850341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:47:57.935715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
무표 35
71.4%
상 11
 
22.4%
하 3
 
6.1%

PHOTO_INFO_ESSN_ID
Categorical

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size524.0 B
data/1607816286_hoxG
49 

Length

Max length20
Median length20
Mean length20
Min length20

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowdata/1607816286_hoxG
2nd rowdata/1607816286_hoxG
3rd rowdata/1607816286_hoxG
4th rowdata/1607816286_hoxG
5th rowdata/1607816286_hoxG

Common Values

ValueCountFrequency (%)
data/1607816286_hoxG 49
100.0%

Length

2023-12-10T23:47:58.027449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:47:58.109097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
data/1607816286_hoxg 49
100.0%

RN
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct49
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean26
Minimum2
Maximum50
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size573.0 B
2023-12-10T23:47:58.206009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile4.4
Q114
median26
Q338
95-th percentile47.6
Maximum50
Range48
Interquartile range (IQR)24

Descriptive statistics

Standard deviation14.28869
Coefficient of variation (CV)0.54956501
Kurtosis-1.2
Mean26
Median Absolute Deviation (MAD)12
Skewness0
Sum1274
Variance204.16667
MonotonicityStrictly increasing
2023-12-10T23:47:58.344666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=49)
ValueCountFrequency (%)
2 1
 
2.0%
39 1
 
2.0%
29 1
 
2.0%
30 1
 
2.0%
31 1
 
2.0%
32 1
 
2.0%
33 1
 
2.0%
34 1
 
2.0%
35 1
 
2.0%
36 1
 
2.0%
Other values (39) 39
79.6%
ValueCountFrequency (%)
2 1
2.0%
3 1
2.0%
4 1
2.0%
5 1
2.0%
6 1
2.0%
7 1
2.0%
8 1
2.0%
9 1
2.0%
10 1
2.0%
11 1
2.0%
ValueCountFrequency (%)
50 1
2.0%
49 1
2.0%
48 1
2.0%
47 1
2.0%
46 1
2.0%
45 1
2.0%
44 1
2.0%
43 1
2.0%
42 1
2.0%
41 1
2.0%

Interactions

2023-12-10T23:47:54.984408image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:47:54.428659image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:47:54.735964image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:47:55.407696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:47:54.523220image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:47:54.816200image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:47:55.493705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:47:54.634489image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:47:54.907839image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T23:47:58.454443image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
SEQ_NOCNSGN_YMDMCS_NMSMRY_CONTCNSGN_STNDRCNSGN_PRICEQLT_MSRM_RSLTRN
SEQ_NO1.0000.9490.8300.8850.4050.3750.5621.000
CNSGN_YMD0.9491.0000.7780.7610.4330.4350.2720.953
MCS_NM0.8300.7781.0000.9780.7810.0000.2630.806
SMRY_CONT0.8850.7610.9781.0000.7090.0000.2180.862
CNSGN_STNDR0.4050.4330.7810.7091.0000.0001.0000.410
CNSGN_PRICE0.3750.4350.0000.0000.0001.0000.0000.358
QLT_MSRM_RSLT0.5620.2720.2630.2181.0000.0001.0000.574
RN1.0000.9530.8060.8620.4100.3580.5741.000
2023-12-10T23:47:58.563837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
QLT_MSRM_RSLTMCS_NMSMRY_CONTCNSGN_YMDCNSGN_STNDR
QLT_MSRM_RSLT1.0000.4220.3520.2550.967
MCS_NM0.4221.0000.8660.5560.560
SMRY_CONT0.3520.8661.0000.5400.498
CNSGN_YMD0.2550.5560.5401.0000.282
CNSGN_STNDR0.9670.5600.4980.2821.000
2023-12-10T23:47:58.654530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
SEQ_NOCNSGN_PRICERNCNSGN_YMDMCS_NMSMRY_CONTCNSGN_STNDRQLT_MSRM_RSLT
SEQ_NO1.000-0.0481.0000.8190.5850.6350.1900.364
CNSGN_PRICE-0.0481.000-0.0480.1440.0000.0000.0000.000
RN1.000-0.0481.0000.8190.5850.6350.1900.364
CNSGN_YMD0.8190.1440.8191.0000.5560.5400.2820.255
MCS_NM0.5850.0000.5850.5561.0000.8660.5600.422
SMRY_CONT0.6350.0000.6350.5400.8661.0000.4980.352
CNSGN_STNDR0.1900.0000.1900.2820.5600.4981.0000.967
QLT_MSRM_RSLT0.3640.0000.3640.2550.4220.3520.9671.000

Missing values

2023-12-10T23:47:55.646965image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T23:47:55.817831image/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

SEQ_NOCNSGN_YMDMCS_NMCTGRY_MLSFC_NMSOFSMRY_CONTCNSGN_STNDRCNSGN_PRICEQLT_MSRM_RSLTPHOTO_INFO_ESSN_IDRN
041317-Sep-2015 00:00:00마산수협공판장연체류 해물모둠오징어오징어무표60000무표data/1607816286_hoxG2
141417-Sep-2015 00:00:00마산수협공판장연체류 해물모둠오징어오징어3단파420000하data/1607816286_hoxG3
241517-Sep-2015 00:00:00여수수협공판장연체류 해물모둠오징어냉오징어무표30728500무표data/1607816286_hoxG4
341617-Sep-2015 00:00:00여수수협공판장연체류 해물모둠오징어냉오징어무표43524000무표data/1607816286_hoxG5
441717-Sep-2015 00:00:00여수수협공판장연체류 해물모둠오징어냉오징어무표43416000무표data/1607816286_hoxG6
541817-Sep-2015 00:00:00여수수협공판장연체류 해물모둠오징어오징어무표3300000무표data/1607816286_hoxG7
641918-Sep-2015 00:00:00마산수협공판장연체류 해물모둠오징어오징어3단6847500상data/1607816286_hoxG8
742018-Sep-2015 00:00:00마산수협공판장연체류 해물모둠오징어오징어2단1245000상data/1607816286_hoxG9
842118-Sep-2015 00:00:00마산수협공판장연체류 해물모둠오징어오징어2단415000상data/1607816286_hoxG10
942218-Sep-2015 00:00:00여수수협공판장연체류 해물모둠오징어냉오징어무표15015000무표data/1607816286_hoxG11
SEQ_NOCNSGN_YMDMCS_NMCTGRY_MLSFC_NMSOFSMRY_CONTCNSGN_STNDRCNSGN_PRICEQLT_MSRM_RSLTPHOTO_INFO_ESSN_IDRN
3945222-Sep-2015 00:00:00여수수협공판장연체류 해물모둠오징어냉오징어무표14157000무표data/1607816286_hoxG41
4045322-Sep-2015 00:00:00여수수협공판장연체류 해물모둠오징어냉오징어무표14157000무표data/1607816286_hoxG42
4145422-Sep-2015 00:00:00여수수협공판장연체류 해물모둠오징어냉오징어무표14157000무표data/1607816286_hoxG43
4245522-Sep-2015 00:00:00여수수협공판장연체류 해물모둠오징어냉오징어무표14157000무표data/1607816286_hoxG44
4345622-Sep-2015 00:00:00여수수협공판장연체류 해물모둠오징어냉오징어무표14157000무표data/1607816286_hoxG45
4445722-Sep-2015 00:00:00여수수협공판장연체류 해물모둠오징어냉오징어무표14157000무표data/1607816286_hoxG46
4545822-Sep-2015 00:00:00여수수협공판장연체류 해물모둠오징어냉오징어무표2178000무표data/1607816286_hoxG47
4645922-Sep-2015 00:00:00여수수협공판장연체류 해물모둠오징어냉오징어무표13845000무표data/1607816286_hoxG48
4746022-Sep-2015 00:00:00여수수협공판장연체류 해물모둠오징어냉오징어무표13845000무표data/1607816286_hoxG49
4846122-Sep-2015 00:00:00여수수협공판장연체류 해물모둠오징어냉오징어무표5183000무표data/1607816286_hoxG50