Overview

Dataset statistics

Number of variables3
Number of observations76
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.0 KiB
Average record size in memory26.7 B

Variable types

Numeric1
Categorical1
Text1

Dataset

Description한국세라믹기술원 세라믹소재정보은행의 물성 요청 정보입니다.
Author한국세라믹기술원
URLhttps://www.data.go.kr/data/15072075/fileData.do

Alerts

일련번호 is highly overall correlated with 요구일자High correlation
요구일자 is highly overall correlated with 일련번호High correlation
일련번호 has unique valuesUnique
요구내용 has unique valuesUnique

Reproduction

Analysis started2023-12-12 17:08:58.352858
Analysis finished2023-12-12 17:08:58.729804
Duration0.38 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

일련번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct76
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.0000001 × 109
Minimum1.0000001 × 109
Maximum1.0000002 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size816.0 B
2023-12-13T02:08:58.800208image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.0000001 × 109
5-th percentile1.0000001 × 109
Q11.0000001 × 109
median1.0000001 × 109
Q31.0000001 × 109
95-th percentile1.0000002 × 109
Maximum1.0000002 × 109
Range95
Interquartile range (IQR)37.5

Descriptive statistics

Standard deviation22.710949
Coefficient of variation (CV)2.2710946 × 10-8
Kurtosis-0.89611754
Mean1.0000001 × 109
Median Absolute Deviation (MAD)19
Skewness-0.1331756
Sum7.6000009 × 1010
Variance515.78719
MonotonicityNot monotonic
2023-12-13T02:08:58.937449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1000000139 1
 
1.3%
1000000088 1
 
1.3%
1000000124 1
 
1.3%
1000000123 1
 
1.3%
1000000118 1
 
1.3%
1000000117 1
 
1.3%
1000000115 1
 
1.3%
1000000099 1
 
1.3%
1000000094 1
 
1.3%
1000000085 1
 
1.3%
Other values (66) 66
86.8%
ValueCountFrequency (%)
1000000061 1
1.3%
1000000081 1
1.3%
1000000082 1
1.3%
1000000083 1
1.3%
1000000085 1
1.3%
1000000086 1
1.3%
1000000087 1
1.3%
1000000088 1
1.3%
1000000089 1
1.3%
1000000090 1
1.3%
ValueCountFrequency (%)
1000000156 1
1.3%
1000000155 1
1.3%
1000000154 1
1.3%
1000000153 1
1.3%
1000000152 1
1.3%
1000000151 1
1.3%
1000000150 1
1.3%
1000000149 1
1.3%
1000000148 1
1.3%
1000000147 1
1.3%

요구일자
Categorical

HIGH CORRELATION 

Distinct26
Distinct (%)34.2%
Missing0
Missing (%)0.0%
Memory size740.0 B
2010-11-02
29 
2010-11-01
11 
2010-10-19
5 
2010-11-03
3 
2010-10-18
3 
Other values (21)
25 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique18 ?
Unique (%)23.7%

Sample

1st row2011-02-22
2nd row2011-02-23
3rd row2011-06-27
4th row2010-09-07
5th row2010-10-19

Common Values

ValueCountFrequency (%)
2010-11-02 29
38.2%
2010-11-01 11
 
14.5%
2010-10-19 5
 
6.6%
2010-11-03 3
 
3.9%
2010-10-18 3
 
3.9%
2011-02-23 3
 
3.9%
2011-02-22 2
 
2.6%
2011-06-27 2
 
2.6%
2011-04-29 1
 
1.3%
2010-09-07 1
 
1.3%
Other values (16) 16
21.1%

Length

2023-12-13T02:08:59.089446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2010-11-02 29
38.2%
2010-11-01 11
 
14.5%
2010-10-19 5
 
6.6%
2010-11-03 3
 
3.9%
2010-10-18 3
 
3.9%
2011-02-23 3
 
3.9%
2011-02-22 2
 
2.6%
2011-06-27 2
 
2.6%
2011-07-07 1
 
1.3%
2011-06-07 1
 
1.3%
Other values (16) 16
21.1%

요구내용
Text

UNIQUE 

Distinct76
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size740.0 B
2023-12-13T02:08:59.415819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length1024
Median length96.5
Mean length98.684211
Min length12

Characters and Unicode

Total characters7500
Distinct characters289
Distinct categories13 ?
Distinct scripts4 ?
Distinct blocks7 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique76 ?
Unique (%)100.0%

Sample

1st rowbending (mm)
2nd rowlinear setting expansion(%) 추가요청 바랍니다
3rd rowJournal of the Korean Society of Analytical Sciences 도 추가 부탁드립니다.
4th row무슨 무슨 코드가 필요하고 왜
5th rowChemicla Composition부분에 unspecified 추가 부탁드립니다
ValueCountFrequency (%)
부탁드립니다 50
 
4.5%
추가 49
 
4.4%
1 41
 
3.7%
materials 40
 
3.6%
name 39
 
3.5%
분류에 30
 
2.7%
19
 
1.7%
calcium 16
 
1.5%
없습니다 15
 
1.4%
가 15
 
1.4%
Other values (508) 788
71.5%
2023-12-13T02:08:59.968219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
875
 
11.7%
a 405
 
5.4%
e 382
 
5.1%
i 349
 
4.7%
327
 
4.4%
t 317
 
4.2%
r 252
 
3.4%
m 232
 
3.1%
n 203
 
2.7%
l 195
 
2.6%
Other values (279) 3963
52.8%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 3391
45.2%
Other Letter 1446
19.3%
Space Separator 877
 
11.7%
Uppercase Letter 659
 
8.8%
Control 327
 
4.4%
Decimal Number 245
 
3.3%
Other Punctuation 230
 
3.1%
Close Punctuation 108
 
1.4%
Open Punctuation 108
 
1.4%
Dash Punctuation 68
 
0.9%
Other values (3) 41
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
다 96
 
6.6%
니 92
 
6.4%
가 87
 
6.0%
에 71
 
4.9%
부 65
 
4.5%
추 59
 
4.1%
드 58
 
4.0%
탁 54
 
3.7%
립 51
 
3.5%
분 41
 
2.8%
Other values (189) 772
53.4%
Uppercase Letter
ValueCountFrequency (%)
M 82
12.4%
O 73
11.1%
S 73
11.1%
C 61
 
9.3%
N 44
 
6.7%
P 41
 
6.2%
B 35
 
5.3%
L 32
 
4.9%
F 32
 
4.9%
A 24
 
3.6%
Other values (18) 162
24.6%
Lowercase Letter
ValueCountFrequency (%)
a 405
11.9%
e 382
11.3%
i 349
10.3%
t 317
9.3%
r 252
 
7.4%
m 232
 
6.8%
n 203
 
6.0%
l 195
 
5.8%
o 192
 
5.7%
s 171
 
5.0%
Other values (16) 693
20.4%
Decimal Number
ValueCountFrequency (%)
1 62
25.3%
2 59
24.1%
3 44
18.0%
4 32
13.1%
5 14
 
5.7%
7 9
 
3.7%
0 9
 
3.7%
6 8
 
3.3%
9 4
 
1.6%
8 4
 
1.6%
Other Punctuation
ValueCountFrequency (%)
. 161
70.0%
, 38
 
16.5%
/ 13
 
5.7%
% 9
 
3.9%
: 3
 
1.3%
" 2
 
0.9%
． 2
 
0.9%
? 1
 
0.4%
! 1
 
0.4%
Math Symbol
ValueCountFrequency (%)
> 19
70.4%
~ 6
 
22.2%
= 1
 
3.7%
≤ 1
 
3.7%
Other Symbol
ValueCountFrequency (%)
℃ 6
75.0%
㎠ 1
 
12.5%
㎲ 1
 
12.5%
Space Separator
ValueCountFrequency (%)
875
99.8%
　 2
 
0.2%
Close Punctuation
ValueCountFrequency (%)
) 106
98.1%
] 2
 
1.9%
Open Punctuation
ValueCountFrequency (%)
( 106
98.1%
[ 2
 
1.9%
Other Number
ValueCountFrequency (%)
² 4
66.7%
³ 2
33.3%
Control
ValueCountFrequency (%)
327
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 68
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 4043
53.9%
Common 2004
26.7%
Hangul 1446
 
19.3%
Greek 7
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
다 96
 
6.6%
니 92
 
6.4%
가 87
 
6.0%
에 71
 
4.9%
부 65
 
4.5%
추 59
 
4.1%
드 58
 
4.0%
탁 54
 
3.7%
립 51
 
3.5%
분 41
 
2.8%
Other values (189) 772
53.4%
Latin
ValueCountFrequency (%)
a 405
 
10.0%
e 382
 
9.4%
i 349
 
8.6%
t 317
 
7.8%
r 252
 
6.2%
m 232
 
5.7%
n 203
 
5.0%
l 195
 
4.8%
o 192
 
4.7%
s 171
 
4.2%
Other values (40) 1345
33.3%
Common
ValueCountFrequency (%)
875
43.7%
327
 
16.3%
. 161
 
8.0%
) 106
 
5.3%
( 106
 
5.3%
- 68
 
3.4%
1 62
 
3.1%
2 59
 
2.9%
3 44
 
2.2%
, 38
 
1.9%
Other values (26) 158
 
7.9%
Greek
ValueCountFrequency (%)
μ 3
42.9%
Ω 2
28.6%
Δ 1
 
14.3%
Ω 1
 
14.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 6028
80.4%
Hangul 1444
 
19.3%
None 16
 
0.2%
Letterlike Symbols 7
 
0.1%
Compat Jamo 2
 
< 0.1%
CJK Compat 2
 
< 0.1%
Math Operators 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
875
 
14.5%
a 405
 
6.7%
e 382
 
6.3%
i 349
 
5.8%
327
 
5.4%
t 317
 
5.3%
r 252
 
4.2%
m 232
 
3.8%
n 203
 
3.4%
l 195
 
3.2%
Other values (68) 2491
41.3%
Hangul
ValueCountFrequency (%)
다 96
 
6.6%
니 92
 
6.4%
가 87
 
6.0%
에 71
 
4.9%
부 65
 
4.5%
추 59
 
4.1%
드 58
 
4.0%
탁 54
 
3.7%
립 51
 
3.5%
분 41
 
2.8%
Other values (188) 770
53.3%
Letterlike Symbols
ValueCountFrequency (%)
℃ 6
85.7%
Ω 1
 
14.3%
None
ValueCountFrequency (%)
² 4
25.0%
μ 3
18.8%
Ω 2
12.5%
　 2
12.5%
³ 2
12.5%
． 2
12.5%
Δ 1
 
6.2%
Compat Jamo
ValueCountFrequency (%)
ㅣ 2
100.0%
Math Operators
ValueCountFrequency (%)
≤ 1
100.0%
CJK Compat
ValueCountFrequency (%)
㎠ 1
50.0%
㎲ 1
50.0%

Interactions

2023-12-13T02:08:58.538297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T02:09:00.068323image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호요구일자요구내용
일련번호1.0000.8871.000
요구일자0.8871.0001.000
요구내용1.0001.0001.000
2023-12-13T02:09:00.165797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호요구일자
일련번호1.0000.576
요구일자0.5761.000

Missing values

2023-12-13T02:08:58.635550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T02:08:58.703022image/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

일련번호요구일자요구내용
010000001392011-02-22bending (mm)
110000001432011-02-23linear setting expansion(%) 추가요청 바랍니다
210000001542011-06-27Journal of the Korean Society of Analytical Sciences 도 추가 부탁드립니다.
310000000612010-09-07무슨 무슨 코드가 필요하고 왜
410000000902010-10-19Chemicla Composition부분에 unspecified 추가 부탁드립니다
510000000972010-11-01기계적물성중에 경도를 표현하는 단위에 관하여 문제점 : 비커스 경도를 표현함에 있어 Hv 또는 GPa 단위롤 표현할 수 있습니다. 현재 저희 서버에서 사용할 수 있는 단위는 GPa로 고정되어 있습니다. 문제는 이러한 비커스 경도를 표현함에 있어 두가지 표현을 모두 쓴다는 것입니다. 다만 단위를 환산하여 Hv 값을 GPa로 표현이 가능하지만 데이터 하나당 일일히 단위변경을 해주어야 하기때문에 입력 작업의 효율이 현저히 저하됩니다. 요청사항 : 열적-기계적물성 ->> hardness(Hv)를 추가하여 주십시요.
610000001012010-11-01Materials Name 1 에서 SrBaSiO2 (Strontium Barium Silicate) 가 없습니다... 추가 부탁드립니다.
710000001072010-11-02Materials Name 1 분류에 MgBaP2O7 (Magnesium Barium Phosphate) 가 없습니다. 추가 부탁드립니다.
810000001092010-11-02Materials Name 1 에 LaPO4 (Lanthanium Phosphate) 가 없습니다. 추가 부탁드립니다.
910000001102010-11-02Materials Name 1 분류에 Sr3(PO4)2 (Strontium Phosphate) 가 없습니다. 그리고, (Ca, Sr)3(PO4)2 (Calcium Strontium Phosphate) 가 없습니다. 추가 부탁드립니다.
일련번호요구일자요구내용
6610000001052010-11-02Materials Name 1 의 분류에 Oxychloride 계열이 없습니다. 추가 부탁드립니다. LaSiO3Cl (Lanthanum Silicon Oxychloride) 추가 부탁드립니다.
6710000001062010-11-02Materials Name 1 분류에 CaB2P2O9 (Calcium Boron Phosphate) 가 없습니다. 추가 부탁드립니다.
6810000001442011-02-25[chemical etching] 코드가 있음에도 선택이 되지 않습니다. 사용중 이와 같이 선택이 되지 않는 코드가 다수 존재합니다.
6910000001482011-03-10Material 분류에서 sulfate 에 Strontium Sulfate 추가 부탁드립니다.
7010000000912010-10-20최민호 연구원님께 자부연 박종혁입니다. 물성명 Code 부탁드립니다. 감사합니다. --------------------------------------------- 구분 ㅣ 물성명 ㅣ 단위 1. cross-section area, cm² 2. cross-section area of 1 segmnet, cm² 3. Volume, L 4. Weight, g 5. Number of segment, EA 6. Cell Density, CPSI 7. SEM(Scanning Electron Microscope) 8. EDS(energy dispersive spectroscopy) 9. Density, g/cm³ 10. XRD 11. Porosity, % 12. Median Pore Diameter(volume), μm 13. Cell distance, mm 14. Wall Thickness, mm 15. Flexural Strength, kg/mm² 16. Normalized Strength, kg/mm² 17. Chemical resistance 18. X-ray Scanning Image 19. TEM(Transmission Xlectron Microscope) 20. Pattern of Diffraction 21. EDAX(Mapping) 22. EDAX(Spectrum) 23. Detecting element distances, mm 24. Resistivity, Ωcm 25. B constant(K) 26. Resistance to acid(weight change,%) 27. Resistance to metal compunds 28. Mean Pore Size, μm 29. CTE (T≤100℃), x10-6/℃ 30. compresives Strength ,Mpa 31. Intrinsic Density, g/cm³ 32. T melt, ℃ 33. "Thermal conductivity(500℃), w/mk" 34. O.F.A(Open Frontal Area), % 35. Hydraulic
7110000001382011-01-20AlTaO4 Materials Name 요청합니다 Aluminium tetraoxotantalate
7210000001452011-02-28electircal>Resistivity(키로옴.cm) 현재 옴.cm만 있는데 키로옴.cm 추가 부탁드립니다.
7310000001462011-03-02입력 중에 sintering 분위기가 H2/N2=3%로 진행하는 조건이 있습니다.
7410000001472011-03-03Property 중에 crack 유무를 추가할 수 있는지요. 또한 이때, Value를 어떻게 입력해야 하는지요? value에는 숫자만 입력이 가능하게 되었어서 입력 방법이 궁금합니다.
7510000001522011-06-23안녕하세요. 자부연의 박종혁입니다. 물성명 요청합니다. 1. etc>Theoretical temperature(온도) 2. etc>Reaction temperature(온도) 3. etc>Propagqtion velocity(cm/sec)