Overview

Dataset statistics

Number of variables12
Number of observations99
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.9 KiB
Average record size in memory102.3 B

Variable types

Categorical9
Numeric2
Text1

Dataset

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

Alerts

MT has constant value ""Constant
201802 has constant value ""Constant
탄산음료 has constant value ""Constant
전체 has constant value ""Constant
전체.1 has constant value ""Constant
2 has constant value ""Constant
롯데칠성음료 밀키스 has constant value ""Constant
50 is highly overall correlated with 강원도High correlation
강원도 is highly overall correlated with 50High correlation
5 has 3 (3.0%) zerosZeros

Reproduction

Analysis started2023-12-10 06:26:15.648688
Analysis finished2023-12-10 06:26:19.887237
Duration4.24 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

MT
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
MT
99 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
MT 99
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:26:20.147826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
mt 99
100.0%

201802
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
201802
99 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
201802 99
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:26:20.478533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
201802 99
100.0%

101
Real number (ℝ)

Distinct69
Distinct (%)69.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean86.858586
Minimum10
Maximum243
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-10T15:26:20.715866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10
5-th percentile30.5
Q168
median86
Q3102.5
95-th percentile142.1
Maximum243
Range233
Interquartile range (IQR)34.5

Descriptive statistics

Standard deviation34.639546
Coefficient of variation (CV)0.39880394
Kurtosis3.4299788
Mean86.858586
Median Absolute Deviation (MAD)18
Skewness0.86934381
Sum8599
Variance1199.8982
MonotonicityNot monotonic
2023-12-10T15:26:21.024224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
80 4
 
4.0%
98 3
 
3.0%
68 3
 
3.0%
70 3
 
3.0%
100 3
 
3.0%
72 2
 
2.0%
123 2
 
2.0%
117 2
 
2.0%
90 2
 
2.0%
86 2
 
2.0%
Other values (59) 73
73.7%
ValueCountFrequency (%)
10 1
1.0%
19 1
1.0%
22 1
1.0%
25 1
1.0%
26 1
1.0%
31 1
1.0%
37 1
1.0%
39 1
1.0%
44 2
2.0%
47 1
1.0%
ValueCountFrequency (%)
243 1
1.0%
169 1
1.0%
153 1
1.0%
145 1
1.0%
143 1
1.0%
142 1
1.0%
140 1
1.0%
136 1
1.0%
132 1
1.0%
127 1
1.0%

5
Real number (ℝ)

ZEROS 

Distinct19
Distinct (%)19.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7.0505051
Minimum0
Maximum100
Zeros3
Zeros (%)3.0%
Negative0
Negative (%)0.0%
Memory size1023.0 B
2023-12-10T15:26:21.269650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q13
median4
Q37
95-th percentile20.3
Maximum100
Range100
Interquartile range (IQR)4

Descriptive statistics

Standard deviation10.99478
Coefficient of variation (CV)1.5594315
Kurtosis53.237231
Mean7.0505051
Median Absolute Deviation (MAD)2
Skewness6.6410694
Sum698
Variance120.88518
MonotonicityNot monotonic
2023-12-10T15:26:21.482012image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
4 23
23.2%
3 15
15.2%
7 8
 
8.1%
5 8
 
8.1%
6 7
 
7.1%
2 7
 
7.1%
9 5
 
5.1%
8 5
 
5.1%
11 5
 
5.1%
1 4
 
4.0%
Other values (9) 12
12.1%
ValueCountFrequency (%)
0 3
 
3.0%
1 4
 
4.0%
2 7
 
7.1%
3 15
15.2%
4 23
23.2%
5 8
 
8.1%
6 7
 
7.1%
7 8
 
8.1%
8 5
 
5.1%
9 5
 
5.1%
ValueCountFrequency (%)
100 1
 
1.0%
37 1
 
1.0%
29 1
 
1.0%
24 1
 
1.0%
23 1
 
1.0%
20 1
 
1.0%
12 1
 
1.0%
11 5
5.1%
10 2
 
2.0%
9 5
5.1%

탄산음료
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
탄산음료
99 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row탄산음료
2nd row탄산음료
3rd row탄산음료
4th row탄산음료
5th row탄산음료

Common Values

ValueCountFrequency (%)
탄산음료 99
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:26:21.856423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
탄산음료 99
100.0%

전체
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
전체
99 

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 (%)
전체 99
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:26:22.156455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전체 99
100.0%

전체.1
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
전체
99 

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 (%)
전체 99
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:26:22.514513image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전체 99
100.0%

2
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
2
99 

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 99
100.0%

Length

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

Common Values (Plot)

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

50
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
60
65 
50
34 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
60 65
65.7%
50 34
34.3%

Length

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

Common Values (Plot)

2023-12-10T15:26:23.221762image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
60 65
65.7%
50 34
34.3%

강원도
Categorical

HIGH CORRELATION 

Distinct18
Distinct (%)18.2%
Missing0
Missing (%)0.0%
Memory size924.0 B
경기도
16 
서울특별시
13 
강원도
12 
경상북도
8 
경상남도
6 
Other values (13)
44 

Length

Max length7
Median length5
Mean length4.1515152
Min length2

Unique

Unique2 ?
Unique (%)2.0%

Sample

1st row강원도
2nd row강원도
3rd row강원도
4th row충청북도
5th row충청북도

Common Values

ValueCountFrequency (%)
경기도 16
16.2%
서울특별시 13
13.1%
강원도 12
12.1%
경상북도 8
 
8.1%
경상남도 6
 
6.1%
전라남도 5
 
5.1%
충청북도 5
 
5.1%
광주광역시 5
 
5.1%
충청남도 5
 
5.1%
대구광역시 4
 
4.0%
Other values (8) 20
20.2%

Length

2023-12-10T15:26:23.397621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
경기도 16
16.2%
서울특별시 13
13.1%
강원도 12
12.1%
경상북도 8
 
8.1%
경상남도 6
 
6.1%
전라남도 5
 
5.1%
충청북도 5
 
5.1%
광주광역시 5
 
5.1%
충청남도 5
 
5.1%
부산광역시 4
 
4.0%
Other values (8) 20
20.2%

춘천시
Text

Distinct71
Distinct (%)71.7%
Missing0
Missing (%)0.0%
Memory size924.0 B
2023-12-10T15:26:23.768308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length3
Mean length2.8282828
Min length2

Characters and Unicode

Total characters280
Distinct characters68
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique53 ?
Unique (%)53.5%

Sample

1st row원주시
2nd row속초시
3rd row철원군
4th row옥천군
5th row음성군
ValueCountFrequency (%)
전체 10
 
10.1%
북구 4
 
4.0%
동구 2
 
2.0%
원주시 2
 
2.0%
남구 2
 
2.0%
광양시 2
 
2.0%
속초시 2
 
2.0%
서구 2
 
2.0%
중구 2
 
2.0%
포항시 2
 
2.0%
Other values (61) 69
69.7%
2023-12-10T15:26:24.562292image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
시 46
 
16.4%
구 31
 
11.1%
군 17
 
6.1%
전 12
 
4.3%
천 12
 
4.3%
주 12
 
4.3%
체 10
 
3.6%
양 9
 
3.2%
동 7
 
2.5%
성 7
 
2.5%
Other values (58) 117
41.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 280
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 46
 
16.4%
구 31
 
11.1%
군 17
 
6.1%
전 12
 
4.3%
천 12
 
4.3%
주 12
 
4.3%
체 10
 
3.6%
양 9
 
3.2%
동 7
 
2.5%
성 7
 
2.5%
Other values (58) 117
41.8%

Most occurring scripts

ValueCountFrequency (%)
Hangul 280
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 46
 
16.4%
구 31
 
11.1%
군 17
 
6.1%
전 12
 
4.3%
천 12
 
4.3%
주 12
 
4.3%
체 10
 
3.6%
양 9
 
3.2%
동 7
 
2.5%
성 7
 
2.5%
Other values (58) 117
41.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 280
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
시 46
 
16.4%
구 31
 
11.1%
군 17
 
6.1%
전 12
 
4.3%
천 12
 
4.3%
주 12
 
4.3%
체 10
 
3.6%
양 9
 
3.2%
동 7
 
2.5%
성 7
 
2.5%
Other values (58) 117
41.8%

롯데칠성음료 밀키스
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size924.0 B
롯데칠성음료 밀키스
99 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row롯데칠성음료 밀키스
2nd row롯데칠성음료 밀키스
3rd row롯데칠성음료 밀키스
4th row롯데칠성음료 밀키스
5th row롯데칠성음료 밀키스

Common Values

ValueCountFrequency (%)
롯데칠성음료 밀키스 99
100.0%

Length

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

Common Values (Plot)

2023-12-10T15:26:24.933526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
롯데칠성음료 99
50.0%
밀키스 99
50.0%

Interactions

2023-12-10T15:26:19.120717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:26:18.773469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:26:19.252253image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:26:18.987113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:26:25.069417image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
101550강원도춘천시
1011.0000.2360.1500.0000.859
50.2361.0000.2950.0000.988
500.1500.2951.0000.8810.000
강원도0.0000.0000.8811.0000.000
춘천시0.8590.9880.0000.0001.000
2023-12-10T15:26:25.239959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
강원도50
강원도1.0000.675
500.6751.000
2023-12-10T15:26:25.381184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
101550강원도
1011.0000.3290.1050.000
50.3291.0000.2610.000
500.1050.2611.0000.675
강원도0.0000.0000.6751.000

Missing values

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

MT2018021015탄산음료전체전체.1250강원도춘천시롯데칠성음료 밀키스
0MT201802987탄산음료전체전체250강원도원주시롯데칠성음료 밀키스
1MT201802865탄산음료전체전체250강원도속초시롯데칠성음료 밀키스
2MT2018021036탄산음료전체전체250강원도철원군롯데칠성음료 밀키스
3MT20180268100탄산음료전체전체250충청북도옥천군롯데칠성음료 밀키스
4MT201802709탄산음료전체전체250충청북도음성군롯데칠성음료 밀키스
5MT2018021207탄산음료전체전체250충청남도천안시롯데칠성음료 밀키스
6MT2018021009탄산음료전체전체250충청남도보령시롯데칠성음료 밀키스
7MT201802199탄산음료전체전체250충청남도논산시롯데칠성음료 밀키스
8MT201802855탄산음료전체전체250전라북도전주시롯데칠성음료 밀키스
9MT201802942탄산음료전체전체250전라북도군산시롯데칠성음료 밀키스
MT2018021015탄산음료전체전체.1250강원도춘천시롯데칠성음료 밀키스
89MT2018021024탄산음료전체전체260경기도수원시롯데칠성음료 밀키스
90MT201802804탄산음료전체전체260경기도성남시롯데칠성음료 밀키스
91MT201802793탄산음료전체전체260경기도고양시롯데칠성음료 밀키스
92MT2018029211탄산음료전체전체260경기도과천시롯데칠성음료 밀키스
93MT201802543탄산음료전체전체260경기도시흥시롯데칠성음료 밀키스
94MT2018021026탄산음료전체전체260경기도하남시롯데칠성음료 밀키스
95MT2018021177탄산음료전체전체260경기도이천시롯데칠성음료 밀키스
96MT201802446탄산음료전체전체260강원도평창군롯데칠성음료 밀키스
97MT201802914탄산음료전체전체260충청북도전체롯데칠성음료 밀키스
98MT201802807탄산음료전체전체260전라남도광양시롯데칠성음료 밀키스