Overview

Dataset statistics

Number of variables10
Number of observations199
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory17.6 KiB
Average record size in memory90.7 B

Variable types

Categorical9
Numeric1

Dataset

DescriptionSample
Author오픈메이트
URLhttps://www.bigdata-telecom.kr/invoke/SOKBP2603/?goodsCode=OPMFAMILYESTA

Alerts

2 has constant value ""Constant
2020 has constant value ""Constant
1 has constant value ""Constant
1.1 is highly overall correlated with 1.2High correlation
1.2 is highly overall correlated with 1.1 and 1 other fieldsHigh correlation
3 is highly overall correlated with 1.2High correlation
11215710 has unique valuesUnique

Reproduction

Analysis started2023-12-10 06:39:10.798861
Analysis finished2023-12-10 06:39:12.125736
Duration1.33 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

2
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2
199 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2 199
100.0%

Length

2023-12-10T15:39:12.230234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:39:12.407006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 199
100.0%

2020
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2020
199 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2020 199
100.0%

Length

2023-12-10T15:39:12.556491image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:39:12.708544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020 199
100.0%

11215710
Real number (ℝ)

UNIQUE 

Distinct199
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean31542214
Minimum11110650
Maximum50110630
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:39:12.906684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum11110650
5-th percentile11230544
Q118910590
median30200540
Q343122438
95-th percentile47290250
Maximum50110630
Range38999980
Interquartile range (IQR)24211848

Descriptive statistics

Standard deviation13460541
Coefficient of variation (CV)0.42674688
Kurtosis-1.3159249
Mean31542214
Median Absolute Deviation (MAD)12929795
Skewness-0.443152
Sum6.2769005 × 109
Variance1.8118617 × 1014
MonotonicityNot monotonic
2023-12-10T15:39:13.611674image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
11410585 1
 
0.5%
44800250 1
 
0.5%
29110630 1
 
0.5%
48250590 1
 
0.5%
41550350 1
 
0.5%
36110350 1
 
0.5%
44133250 1
 
0.5%
47190680 1
 
0.5%
47190670 1
 
0.5%
36110250 1
 
0.5%
Other values (189) 189
95.0%
ValueCountFrequency (%)
11110650 1
0.5%
11110710 1
0.5%
11140580 1
0.5%
11140590 1
0.5%
11170555 1
0.5%
11200550 1
0.5%
11215730 1
0.5%
11215780 1
0.5%
11215847 1
0.5%
11230536 1
0.5%
ValueCountFrequency (%)
50110630 1
0.5%
48250590 1
0.5%
48170740 1
0.5%
48170515 1
0.5%
48123520 1
0.5%
48121540 1
0.5%
47290560 1
0.5%
47290550 1
0.5%
47290256 1
0.5%
47290253 1
0.5%

1
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
1
199 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 199
100.0%

Length

2023-12-10T15:39:13.846071image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:39:14.004146image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 199
100.0%

1.1
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
1
152 
2
38 
3
 
9

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 152
76.4%
2 38
 
19.1%
3 9
 
4.5%

Length

2023-12-10T15:39:14.183378image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:39:14.353212image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 152
76.4%
2 38
 
19.1%
3 9
 
4.5%

1.2
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
1
78 
2
57 
3
37 
4
26 
5
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)0.5%

Sample

1st row2
2nd row1
3rd row3
4th row2
5th row3

Common Values

ValueCountFrequency (%)
1 78
39.2%
2 57
28.6%
3 37
18.6%
4 26
 
13.1%
5 1
 
0.5%

Length

2023-12-10T15:39:14.532212image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:39:14.725400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 78
39.2%
2 57
28.6%
3 37
18.6%
4 26
 
13.1%
5 1
 
0.5%

4
Categorical

Distinct5
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
1
58 
3
55 
2
47 
4
28 
5
11 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2
2nd row1
3rd row2
4th row3
5th row4

Common Values

ValueCountFrequency (%)
1 58
29.1%
3 55
27.6%
2 47
23.6%
4 28
14.1%
5 11
 
5.5%

Length

2023-12-10T15:39:14.928421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:39:15.142131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 58
29.1%
3 55
27.6%
2 47
23.6%
4 28
14.1%
5 11
 
5.5%

2.1
Categorical

Distinct5
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2
67 
1
57 
3
47 
4
27 
5
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)0.5%

Sample

1st row3
2nd row1
3rd row2
4th row1
5th row2

Common Values

ValueCountFrequency (%)
2 67
33.7%
1 57
28.6%
3 47
23.6%
4 27
13.6%
5 1
 
0.5%

Length

2023-12-10T15:39:15.363506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:39:15.553399image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 67
33.7%
1 57
28.6%
3 47
23.6%
4 27
13.6%
5 1
 
0.5%

3
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
1
55 
2
55 
3
50 
4
26 
5
13 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row4
2nd row1
3rd row3
4th row2
5th row4

Common Values

ValueCountFrequency (%)
1 55
27.6%
2 55
27.6%
3 50
25.1%
4 26
13.1%
5 13
 
6.5%

Length

2023-12-10T15:39:15.751346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:39:15.962538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 55
27.6%
2 55
27.6%
3 50
25.1%
4 26
13.1%
5 13
 
6.5%

2.2
Categorical

Distinct5
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
1
66 
2
47 
3
34 
5
28 
4
24 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2
2nd row1
3rd row2
4th row1
5th row3

Common Values

ValueCountFrequency (%)
1 66
33.2%
2 47
23.6%
3 34
17.1%
5 28
14.1%
4 24
 
12.1%

Length

2023-12-10T15:39:16.266416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:39:16.573697image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 66
33.2%
2 47
23.6%
3 34
17.1%
5 28
14.1%
4 24
 
12.1%

Interactions

2023-12-10T15:39:11.480579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:39:16.733720image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
112157101.11.242.132.2
112157101.0000.3640.1830.0520.1530.0590.192
1.10.3641.0000.5770.3250.4370.4970.452
1.20.1830.5771.0000.7360.8210.8640.710
40.0520.3250.7361.0000.7310.7300.557
2.10.1530.4370.8210.7311.0000.7630.666
30.0590.4970.8640.7300.7631.0000.818
2.20.1920.4520.7100.5570.6660.8181.000
2023-12-10T15:39:16.928385image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
1.232.12.241.1
1.21.0000.5080.4480.3370.3590.522
30.5081.0000.3840.4440.3540.430
2.10.4480.3841.0000.3040.3550.366
2.20.3370.4440.3041.0000.2360.382
40.3590.3540.3550.2361.0000.258
1.10.5220.4300.3660.3820.2581.000
2023-12-10T15:39:17.152294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
112157101.11.242.132.2
112157101.0000.2470.1050.0450.0950.0250.114
1.10.2471.0000.5220.2580.3660.4300.382
1.20.1050.5221.0000.3590.4480.5080.337
40.0450.2580.3591.0000.3550.3540.236
2.10.0950.3660.4480.3551.0000.3840.304
30.0250.4300.5080.3540.3841.0000.444
2.20.1140.3820.3370.2360.3040.4441.000

Missing values

2023-12-10T15:39:11.751751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T15:39:12.025983image/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

220201121571011.11.242.132.2
022020114105851122342
122020302005401111111
222020264106001132232
322020112307401123121
422020112005501134243
522020114106151111111
622020116207351111221
722020262905301111211
822020116206651114121
922020451307031111122
220201121571011.11.242.132.2
18922020112906401122331
19022020421105801233333
19122020451303301344455
19222020301106401122322
19322020421106101233233
19422020116505101113122
19522020431145401111111
19622020301705551111112
19722020411116001122212
19822020291106851134533