Overview

Dataset statistics

Number of variables5
Number of observations223
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.5 KiB
Average record size in memory43.6 B

Variable types

Text2
Numeric3

Dataset

Description세라믹산업 對 일본 수출 현황 관련 자료입니다. (세라믹 분류, 무역수지 / 단위:천달러 등)(기준연도 : 2014년도)
Author한국세라믹기술원
URLhttps://www.data.go.kr/data/15051228/fileData.do

Alerts

무역수지(2012 / 천달러) is highly overall correlated with 무역수지(2013 / 천달러) and 1 other fieldsHigh correlation
무역수지(2013 / 천달러) is highly overall correlated with 무역수지(2012 / 천달러) and 1 other fieldsHigh correlation
무역수지(2014 / 천달러) is highly overall correlated with 무역수지(2012 / 천달러) and 1 other fieldsHigh correlation
분 류 has unique valuesUnique
무역수지(2012 / 천달러) has 72 (32.3%) zerosZeros
무역수지(2013 / 천달러) has 74 (33.2%) zerosZeros
무역수지(2014 / 천달러) has 81 (36.3%) zerosZeros

Reproduction

Analysis started2023-12-12 09:39:52.025913
Analysis finished2023-12-12 09:39:53.710814
Duration1.68 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

분 류
Text

UNIQUE 

Distinct223
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
2023-12-12T18:39:54.055651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length5
Median length5
Mean length4.5067265
Min length1

Characters and Unicode

Total characters1005
Distinct characters15
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique223 ?
Unique (%)100.0%

Sample

1st rowA
2nd rowA01
3rd rowA0101
4th rowA0102
5th rowA02
ValueCountFrequency (%)
a 1
 
0.4%
d0104 1
 
0.4%
d0201 1
 
0.4%
d0202 1
 
0.4%
d0203 1
 
0.4%
d0204 1
 
0.4%
d03 1
 
0.4%
d0301 1
 
0.4%
d0302 1
 
0.4%
d0303 1
 
0.4%
Other values (213) 213
95.5%
2023-12-12T18:39:54.608030image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 376
37.4%
1 90
 
9.0%
2 76
 
7.6%
3 61
 
6.1%
D 53
 
5.3%
4 52
 
5.2%
B 52
 
5.2%
A 50
 
5.0%
5 47
 
4.7%
E 35
 
3.5%
Other values (5) 113
 
11.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 782
77.8%
Uppercase Letter 223
 
22.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 376
48.1%
1 90
 
11.5%
2 76
 
9.7%
3 61
 
7.8%
4 52
 
6.6%
5 47
 
6.0%
6 30
 
3.8%
7 23
 
2.9%
8 17
 
2.2%
9 10
 
1.3%
Uppercase Letter
ValueCountFrequency (%)
D 53
23.8%
B 52
23.3%
A 50
22.4%
E 35
15.7%
C 33
14.8%

Most occurring scripts

ValueCountFrequency (%)
Common 782
77.8%
Latin 223
 
22.2%

Most frequent character per script

Common
ValueCountFrequency (%)
0 376
48.1%
1 90
 
11.5%
2 76
 
9.7%
3 61
 
7.8%
4 52
 
6.6%
5 47
 
6.0%
6 30
 
3.8%
7 23
 
2.9%
8 17
 
2.2%
9 10
 
1.3%
Latin
ValueCountFrequency (%)
D 53
23.8%
B 52
23.3%
A 50
22.4%
E 35
15.7%
C 33
14.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1005
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 376
37.4%
1 90
 
9.0%
2 76
 
7.6%
3 61
 
6.1%
D 53
 
5.3%
4 52
 
5.2%
B 52
 
5.2%
A 50
 
5.0%
5 47
 
4.7%
E 35
 
3.5%
Other values (5) 113
 
11.2%

광물
Text

Distinct212
Distinct (%)95.1%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
2023-12-12T18:39:54.893694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length33
Median length19
Mean length6.3497758
Min length2

Characters and Unicode

Total characters1416
Distinct characters221
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique206 ?
Unique (%)92.4%

Sample

1st row광물
2nd row규산질 원료
3rd row규사
4th row규조토
5th row규산알루미늄 원료
ValueCountFrequency (%)
기타 26
 
7.1%
부품 22
 
6.0%
원료 15
 
4.1%
및 13
 
3.6%
세라믹 12
 
3.3%
제품 6
 
1.6%
반도체 4
 
1.1%
도자기 4
 
1.1%
4
 
1.1%
복합산화물 4
 
1.1%
Other values (226) 254
69.8%
2023-12-12T18:39:55.333895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
141
 
10.0%
기 50
 
3.5%
산 46
 
3.2%
품 45
 
3.2%
화 43
 
3.0%
부 35
 
2.5%
물 33
 
2.3%
용 32
 
2.3%
타 31
 
2.2%
라 28
 
2.0%
Other values (211) 932
65.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1237
87.4%
Space Separator 141
 
10.0%
Other Punctuation 10
 
0.7%
Uppercase Letter 10
 
0.7%
Close Punctuation 6
 
0.4%
Open Punctuation 6
 
0.4%
Lowercase Letter 5
 
0.4%
Decimal Number 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 50
 
4.0%
산 46
 
3.7%
품 45
 
3.6%
화 43
 
3.5%
부 35
 
2.8%
물 33
 
2.7%
용 32
 
2.6%
타 31
 
2.5%
라 28
 
2.3%
석 24
 
1.9%
Other values (196) 870
70.3%
Lowercase Letter
ValueCountFrequency (%)
e 1
20.0%
l 1
20.0%
u 1
20.0%
d 1
20.0%
o 1
20.0%
Uppercase Letter
ValueCountFrequency (%)
L 3
30.0%
E 3
30.0%
D 3
30.0%
M 1
 
10.0%
Other Punctuation
ValueCountFrequency (%)
/ 9
90.0%
· 1
 
10.0%
Space Separator
ValueCountFrequency (%)
141
100.0%
Close Punctuation
ValueCountFrequency (%)
) 6
100.0%
Open Punctuation
ValueCountFrequency (%)
( 6
100.0%
Decimal Number
ValueCountFrequency (%)
1 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1237
87.4%
Common 164
 
11.6%
Latin 15
 
1.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 50
 
4.0%
산 46
 
3.7%
품 45
 
3.6%
화 43
 
3.5%
부 35
 
2.8%
물 33
 
2.7%
용 32
 
2.6%
타 31
 
2.5%
라 28
 
2.3%
석 24
 
1.9%
Other values (196) 870
70.3%
Latin
ValueCountFrequency (%)
L 3
20.0%
E 3
20.0%
D 3
20.0%
e 1
 
6.7%
l 1
 
6.7%
u 1
 
6.7%
d 1
 
6.7%
o 1
 
6.7%
M 1
 
6.7%
Common
ValueCountFrequency (%)
141
86.0%
/ 9
 
5.5%
) 6
 
3.7%
( 6
 
3.7%
· 1
 
0.6%
1 1
 
0.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1237
87.4%
ASCII 178
 
12.6%
None 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
141
79.2%
/ 9
 
5.1%
) 6
 
3.4%
( 6
 
3.4%
L 3
 
1.7%
E 3
 
1.7%
D 3
 
1.7%
1 1
 
0.6%
e 1
 
0.6%
l 1
 
0.6%
Other values (4) 4
 
2.2%
Hangul
ValueCountFrequency (%)
기 50
 
4.0%
산 46
 
3.7%
품 45
 
3.6%
화 43
 
3.5%
부 35
 
2.8%
물 33
 
2.7%
용 32
 
2.6%
타 31
 
2.5%
라 28
 
2.3%
석 24
 
1.9%
Other values (196) 870
70.3%
None
ValueCountFrequency (%)
· 1
100.0%

무역수지(2012 / 천달러)
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct142
Distinct (%)63.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12672.726
Minimum0
Maximum274614
Zeros72
Zeros (%)32.3%
Negative0
Negative (%)0.0%
Memory size2.1 KiB
2023-12-12T18:39:55.466717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median330
Q36050
95-th percentile62923.5
Maximum274614
Range274614
Interquartile range (IQR)6050

Descriptive statistics

Standard deviation37722.549
Coefficient of variation (CV)2.9766719
Kurtosis23.069843
Mean12672.726
Median Absolute Deviation (MAD)330
Skewness4.5988142
Sum2826018
Variance1.4229907 × 109
MonotonicityNot monotonic
2023-12-12T18:39:55.600643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 72
32.3%
1 2
 
0.9%
2133 2
 
0.9%
11609 2
 
0.9%
636 2
 
0.9%
5 2
 
0.9%
8 2
 
0.9%
35 2
 
0.9%
2851 2
 
0.9%
86 2
 
0.9%
Other values (132) 133
59.6%
ValueCountFrequency (%)
0 72
32.3%
1 2
 
0.9%
4 1
 
0.4%
5 2
 
0.9%
8 2
 
0.9%
9 1
 
0.4%
16 1
 
0.4%
20 1
 
0.4%
27 1
 
0.4%
28 1
 
0.4%
ValueCountFrequency (%)
274614 1
0.4%
231720 1
0.4%
227754 1
0.4%
183098 1
0.4%
170895 1
0.4%
139664 1
0.4%
134457 1
0.4%
134078 1
0.4%
90919 1
0.4%
88494 1
0.4%

무역수지(2013 / 천달러)
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct140
Distinct (%)62.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11711.978
Minimum0
Maximum291002
Zeros74
Zeros (%)33.2%
Negative0
Negative (%)0.0%
Memory size2.1 KiB
2023-12-12T18:39:55.734082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median415
Q35264.5
95-th percentile52999.6
Maximum291002
Range291002
Interquartile range (IQR)5264.5

Descriptive statistics

Standard deviation35352.314
Coefficient of variation (CV)3.0184752
Kurtosis31.314852
Mean11711.978
Median Absolute Deviation (MAD)415
Skewness5.221539
Sum2611771
Variance1.2497861 × 109
MonotonicityNot monotonic
2023-12-12T18:39:55.873750image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 74
33.2%
51 3
 
1.3%
2137 2
 
0.9%
5 2
 
0.9%
30865 2
 
0.9%
716 2
 
0.9%
93 2
 
0.9%
1669 2
 
0.9%
1 2
 
0.9%
2784 2
 
0.9%
Other values (130) 130
58.3%
ValueCountFrequency (%)
0 74
33.2%
1 2
 
0.9%
5 2
 
0.9%
6 1
 
0.4%
11 1
 
0.4%
19 1
 
0.4%
23 1
 
0.4%
24 1
 
0.4%
34 1
 
0.4%
35 1
 
0.4%
ValueCountFrequency (%)
291002 1
0.4%
233738 1
0.4%
217169 1
0.4%
185487 1
0.4%
117492 1
0.4%
112790 1
0.4%
109802 1
0.4%
80800 1
0.4%
72042 1
0.4%
71337 1
0.4%

무역수지(2014 / 천달러)
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct134
Distinct (%)60.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11802.247
Minimum0
Maximum284558
Zeros81
Zeros (%)36.3%
Negative0
Negative (%)0.0%
Memory size2.1 KiB
2023-12-12T18:39:56.023566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median348
Q36211.5
95-th percentile55920.8
Maximum284558
Range284558
Interquartile range (IQR)6211.5

Descriptive statistics

Standard deviation35258.352
Coefficient of variation (CV)2.9874272
Kurtosis29.498437
Mean11802.247
Median Absolute Deviation (MAD)348
Skewness5.0873522
Sum2631901
Variance1.2431514 × 109
MonotonicityNot monotonic
2023-12-12T18:39:56.179379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 81
36.3%
6368 2
 
0.9%
4556 2
 
0.9%
25478 2
 
0.9%
891 2
 
0.9%
524 2
 
0.9%
48 2
 
0.9%
3629 2
 
0.9%
1627 2
 
0.9%
112 2
 
0.9%
Other values (124) 124
55.6%
ValueCountFrequency (%)
0 81
36.3%
3 1
 
0.4%
7 1
 
0.4%
11 1
 
0.4%
17 1
 
0.4%
30 1
 
0.4%
37 1
 
0.4%
48 2
 
0.9%
49 1
 
0.4%
58 1
 
0.4%
ValueCountFrequency (%)
284558 1
0.4%
240604 1
0.4%
203628 1
0.4%
163664 1
0.4%
137870 1
0.4%
132734 1
0.4%
124624 1
0.4%
88040 1
0.4%
79451 1
0.4%
58266 1
0.4%

Interactions

2023-12-12T18:39:52.870582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:39:52.280154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:39:52.599536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:39:52.963038image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:39:52.387927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:39:52.694628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:39:53.060748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:39:52.490963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:39:52.786772image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T18:39:56.292690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
무역수지(2012 / 천달러)무역수지(2013 / 천달러)무역수지(2014 / 천달러)
무역수지(2012 / 천달러)1.0000.9820.969
무역수지(2013 / 천달러)0.9821.0000.993
무역수지(2014 / 천달러)0.9690.9931.000
2023-12-12T18:39:56.466818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
무역수지(2012 / 천달러)무역수지(2013 / 천달러)무역수지(2014 / 천달러)
무역수지(2012 / 천달러)1.0000.9720.943
무역수지(2013 / 천달러)0.9721.0000.972
무역수지(2014 / 천달러)0.9430.9721.000

Missing values

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

분 류광물무역수지(2012 / 천달러)무역수지(2013 / 천달러)무역수지(2014 / 천달러)
0A광물248211888123886
1A01규산질 원료778617858
2A0101규사677472764
3A0102규조토10114594
4A02규산알루미늄 원료520752135243
5A0201실리마나이트족 광물000
6A0202카올린족 광물473495558
7A0203엽납석410241834296
8A0204점토632536389
9A03알루미나 원료550
분 류광물무역수지(2012 / 천달러)무역수지(2013 / 천달러)무역수지(2014 / 천달러)
213E0601필터133211691106
214E0602촉매담체4570204
215E0603기타000
216E07열적 세라믹 부품428045085082
217E0701내열세라믹 부품000
218E0702발열용 부품376440934490
219E0703금속제조용 부품516415592
220E08방탄 세라믹 부품000
221E0801방탄용 부품000
222E0802기타000