Overview

Dataset statistics

Number of variables7
Number of observations49
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.9 KiB
Average record size in memory59.7 B

Variable types

Categorical6
Numeric1

Dataset

DescriptionSample
Author(주)제로투원파트너스
URLhttps://www.bigdata-telecom.kr/invoke/SOKBP2603/?goodsCode=ZTO009DEMO

Alerts

QU has constant value ""Constant
2018Q1 has constant value ""Constant
DIY용품 has constant value ""Constant
강원 has constant value ""Constant

Reproduction

Analysis started2023-12-10 06:56:28.736427
Analysis finished2023-12-10 06:56:29.122163
Duration0.39 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

QU
Categorical

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size524.0 B
QU
49 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
QU 49
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:56:29.254619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
qu 49
100.0%

2018Q1
Categorical

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size524.0 B
2018Q1
49 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2018Q1 49
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:56:29.413291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2018q1 49
100.0%

DIY용품
Categorical

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size524.0 B
DIY용품
49 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowDIY용품
2nd rowDIY용품
3rd rowDIY용품
4th rowDIY용품
5th rowDIY용품

Common Values

ValueCountFrequency (%)
DIY용품 49
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:56:29.562499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
diy용품 49
100.0%

강원
Categorical

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size524.0 B
강원
49 

Length

Max length2
Median length2
Mean length2
Min length2

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-10T15:56:29.646746image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:56:29.726223image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
강원 49
100.0%

강릉시
Categorical

Distinct8
Distinct (%)16.3%
Missing0
Missing (%)0.0%
Memory size524.0 B
속초시
12 
원주시
12 
전체
12 
강릉시
6 
철원군
3 
Other values (3)
4 

Length

Max length3
Median length3
Mean length2.755102
Min length2

Unique

Unique2 ?
Unique (%)4.1%

Sample

1st row강릉시
2nd row강릉시
3rd row강릉시
4th row강릉시
5th row강릉시

Common Values

ValueCountFrequency (%)
속초시 12
24.5%
원주시 12
24.5%
전체 12
24.5%
강릉시 6
12.2%
철원군 3
 
6.1%
동해시 2
 
4.1%
양양군 1
 
2.0%
정선군 1
 
2.0%

Length

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

Common Values (Plot)

2023-12-10T15:56:29.924284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
속초시 12
24.5%
원주시 12
24.5%
전체 12
24.5%
강릉시 6
12.2%
철원군 3
 
6.1%
동해시 2
 
4.1%
양양군 1
 
2.0%
정선군 1
 
2.0%

M20
Categorical

Distinct12
Distinct (%)24.5%
Missing0
Missing (%)0.0%
Memory size524.0 B
F40
6 
M30
5 
M50
5 
M40
5 
F30
4 
Other values (7)
24 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowM30
2nd rowM50
3rd rowM40
4th rowF30
5th rowF50

Common Values

ValueCountFrequency (%)
F40 6
12.2%
M30 5
10.2%
M50 5
10.2%
M40 5
10.2%
F30 4
8.2%
F50 4
8.2%
F20 4
8.2%
F60 4
8.2%
M60 3
6.1%
F70 3
6.1%
Other values (2) 6
12.2%

Length

2023-12-10T15:56:30.036856image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
f40 6
12.2%
m30 5
10.2%
m50 5
10.2%
m40 5
10.2%
f30 4
8.2%
f50 4
8.2%
f20 4
8.2%
f60 4
8.2%
m60 3
6.1%
f70 3
6.1%
Other values (2) 6
12.2%

1.14
Real number (ℝ)

Distinct47
Distinct (%)95.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14.864898
Minimum0.27
Maximum100
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size573.0 B
2023-12-10T15:56:30.155164image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.27
5-th percentile1.174
Q12.08
median8.14
Q315.38
95-th percentile87.096
Maximum100
Range99.73
Interquartile range (IQR)13.3

Descriptive statistics

Standard deviation24.507898
Coefficient of variation (CV)1.6487095
Kurtosis7.5545928
Mean14.864898
Median Absolute Deviation (MAD)6.2
Skewness2.86912
Sum728.38
Variance600.63709
MonotonicityNot monotonic
2023-12-10T15:56:30.294819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=47)
ValueCountFrequency (%)
100.0 2
 
4.1%
0.27 2
 
4.1%
69.51 1
 
2.0%
1.93 1
 
2.0%
1.35 1
 
2.0%
9.42 1
 
2.0%
12.97 1
 
2.0%
1.17 1
 
2.0%
18.18 1
 
2.0%
9.93 1
 
2.0%
Other values (37) 37
75.5%
ValueCountFrequency (%)
0.27 2
4.1%
1.17 1
2.0%
1.18 1
2.0%
1.19 1
2.0%
1.22 1
2.0%
1.25 1
2.0%
1.35 1
2.0%
1.5 1
2.0%
1.86 1
2.0%
1.93 1
2.0%
ValueCountFrequency (%)
100.0 2
4.1%
98.82 1
2.0%
69.51 1
2.0%
27.42 1
2.0%
22.9 1
2.0%
22.42 1
2.0%
19.38 1
2.0%
19.31 1
2.0%
18.18 1
2.0%
18.05 1
2.0%

Interactions

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

Correlations

2023-12-10T15:56:30.383224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
강릉시M201.14
강릉시1.0000.0000.618
M200.0001.0000.309
1.140.6180.3091.000
2023-12-10T15:56:30.466895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
강릉시M20
강릉시1.0000.000
M200.0001.000
2023-12-10T15:56:30.550841image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
1.14강릉시M20
1.141.0000.4220.145
강릉시0.4221.0000.000
M200.1450.0001.000

Missing values

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

QU2018Q1DIY용품강원강릉시M201.14
0QU2018Q1DIY용품강원강릉시M3069.51
1QU2018Q1DIY용품강원강릉시M502.97
2QU2018Q1DIY용품강원강릉시M409.69
3QU2018Q1DIY용품강원강릉시F307.09
4QU2018Q1DIY용품강원강릉시F508.38
5QU2018Q1DIY용품강원강릉시F401.22
6QU2018Q1DIY용품강원동해시F2098.82
7QU2018Q1DIY용품강원동해시M401.18
8QU2018Q1DIY용품강원속초시M5027.42
9QU2018Q1DIY용품강원속초시F201.94
QU2018Q1DIY용품강원강릉시M201.14
39QU2018Q1DIY용품강원전체F701.25
40QU2018Q1DIY용품강원전체F203.75
41QU2018Q1DIY용품강원전체F5018.05
42QU2018Q1DIY용품강원전체M603.96
43QU2018Q1DIY용품강원전체M308.39
44QU2018Q1DIY용품강원전체M507.89
45QU2018Q1DIY용품강원정선군F40100.0
46QU2018Q1DIY용품강원철원군F609.96
47QU2018Q1DIY용품강원철원군M308.88
48QU2018Q1DIY용품강원철원군M5010.7