Overview

Dataset statistics

Number of variables4
Number of observations277
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.3 KiB
Average record size in memory34.5 B

Variable types

Numeric1
Text1
DateTime1
Categorical1

Dataset

Description국가기술은행(NTB) 이용자의 통합상담에 대한 데이터로 공공기술 정보 및 기술이전 사업화 관련 문의 등의 현황입니다.
URLhttps://www.data.go.kr/data/15117081/fileData.do

Alerts

상담실 순번 is highly overall correlated with 상태High correlation
상태 is highly overall correlated with 상담실 순번High correlation
상담실 순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 18:43:39.046119
Analysis finished2023-12-12 18:43:39.896694
Duration0.85 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상담실 순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct277
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean139
Minimum1
Maximum277
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.6 KiB
2023-12-13T03:43:40.022176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile14.8
Q170
median139
Q3208
95-th percentile263.2
Maximum277
Range276
Interquartile range (IQR)138

Descriptive statistics

Standard deviation80.10722
Coefficient of variation (CV)0.57631093
Kurtosis-1.2
Mean139
Median Absolute Deviation (MAD)69
Skewness0
Sum38503
Variance6417.1667
MonotonicityStrictly increasing
2023-12-13T03:43:40.213183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.4%
184 1
 
0.4%
190 1
 
0.4%
189 1
 
0.4%
188 1
 
0.4%
187 1
 
0.4%
186 1
 
0.4%
185 1
 
0.4%
183 1
 
0.4%
175 1
 
0.4%
Other values (267) 267
96.4%
ValueCountFrequency (%)
1 1
0.4%
2 1
0.4%
3 1
0.4%
4 1
0.4%
5 1
0.4%
6 1
0.4%
7 1
0.4%
8 1
0.4%
9 1
0.4%
10 1
0.4%
ValueCountFrequency (%)
277 1
0.4%
276 1
0.4%
275 1
0.4%
274 1
0.4%
273 1
0.4%
272 1
0.4%
271 1
0.4%
270 1
0.4%
269 1
0.4%
268 1
0.4%

제목
Text

Distinct245
Distinct (%)88.4%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
2023-12-13T03:43:40.793952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length92
Median length53
Mean length21.527076
Min length3

Characters and Unicode

Total characters5963
Distinct characters454
Distinct categories12 ?
Distinct scripts4 ?
Distinct blocks5 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique229 ?
Unique (%)82.7%

Sample

1st row[에너지/자원] 수소의 흡방출 압력이 제어된 상온 수소 저장 합금 및 이를 이용한 수소 연료 시스템
2nd row특허기술 판매관련 문의
3rd row기술이전 문의 드립니다.
4th row기술이전 관련 문의드립니다.
5th row기술이전 관련 문의드립니다.
ValueCountFrequency (%)
기술이전 87
 
6.0%
문의 70
 
4.9%
및 44
 
3.1%
기술 38
 
2.6%
관련 34
 
2.4%
상담 26
 
1.8%
이전 20
 
1.4%
문의드립니다 17
 
1.2%
대한 16
 
1.1%
신청 15
 
1.0%
Other values (726) 1075
74.5%
2023-12-13T03:43:41.650312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1174
 
19.7%
기 259
 
4.3%
술 224
 
3.8%
이 192
 
3.2%
전 153
 
2.6%
의 149
 
2.5%
문 111
 
1.9%
니 90
 
1.5%
다 89
 
1.5%
. 79
 
1.3%
Other values (444) 3443
57.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4437
74.4%
Space Separator 1174
 
19.7%
Other Punctuation 120
 
2.0%
Decimal Number 79
 
1.3%
Uppercase Letter 77
 
1.3%
Open Punctuation 28
 
0.5%
Close Punctuation 28
 
0.5%
Lowercase Letter 14
 
0.2%
Connector Punctuation 3
 
0.1%
Initial Punctuation 1
 
< 0.1%
Other values (2) 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 259
 
5.8%
술 224
 
5.0%
이 192
 
4.3%
전 153
 
3.4%
의 149
 
3.4%
문 111
 
2.5%
니 90
 
2.0%
다 89
 
2.0%
청 61
 
1.4%
상 61
 
1.4%
Other values (393) 3048
68.7%
Uppercase Letter
ValueCountFrequency (%)
T 13
16.9%
B 12
15.6%
S 12
15.6%
N 11
14.3%
D 6
7.8%
P 5
 
6.5%
C 4
 
5.2%
E 3
 
3.9%
G 2
 
2.6%
L 2
 
2.6%
Other values (5) 7
9.1%
Decimal Number
ValueCountFrequency (%)
0 24
30.4%
2 17
21.5%
3 7
 
8.9%
1 7
 
8.9%
7 5
 
6.3%
8 4
 
5.1%
5 4
 
5.1%
9 4
 
5.1%
4 4
 
5.1%
6 3
 
3.8%
Lowercase Letter
ValueCountFrequency (%)
a 3
21.4%
b 3
21.4%
m 2
14.3%
r 1
 
7.1%
t 1
 
7.1%
n 1
 
7.1%
o 1
 
7.1%
k 1
 
7.1%
e 1
 
7.1%
Other Punctuation
ValueCountFrequency (%)
. 79
65.8%
, 21
 
17.5%
/ 8
 
6.7%
? 6
 
5.0%
: 3
 
2.5%
; 1
 
0.8%
· 1
 
0.8%
& 1
 
0.8%
Open Punctuation
ValueCountFrequency (%)
[ 25
89.3%
( 3
 
10.7%
Close Punctuation
ValueCountFrequency (%)
] 25
89.3%
) 3
 
10.7%
Space Separator
ValueCountFrequency (%)
1174
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 3
100.0%
Initial Punctuation
ValueCountFrequency (%)
“ 1
100.0%
Final Punctuation
ValueCountFrequency (%)
” 1
100.0%
Math Symbol
ValueCountFrequency (%)
+ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4436
74.4%
Common 1435
 
24.1%
Latin 91
 
1.5%
Han 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 259
 
5.8%
술 224
 
5.0%
이 192
 
4.3%
전 153
 
3.4%
의 149
 
3.4%
문 111
 
2.5%
니 90
 
2.0%
다 89
 
2.0%
청 61
 
1.4%
상 61
 
1.4%
Other values (392) 3047
68.7%
Common
ValueCountFrequency (%)
1174
81.8%
. 79
 
5.5%
[ 25
 
1.7%
] 25
 
1.7%
0 24
 
1.7%
, 21
 
1.5%
2 17
 
1.2%
/ 8
 
0.6%
3 7
 
0.5%
1 7
 
0.5%
Other values (17) 48
 
3.3%
Latin
ValueCountFrequency (%)
T 13
14.3%
B 12
13.2%
S 12
13.2%
N 11
12.1%
D 6
 
6.6%
P 5
 
5.5%
C 4
 
4.4%
E 3
 
3.3%
a 3
 
3.3%
b 3
 
3.3%
Other values (14) 19
20.9%
Han
ValueCountFrequency (%)
時 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4436
74.4%
ASCII 1523
 
25.5%
Punctuation 2
 
< 0.1%
CJK 1
 
< 0.1%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1174
77.1%
. 79
 
5.2%
[ 25
 
1.6%
] 25
 
1.6%
0 24
 
1.6%
, 21
 
1.4%
2 17
 
1.1%
T 13
 
0.9%
B 12
 
0.8%
S 12
 
0.8%
Other values (38) 121
 
7.9%
Hangul
ValueCountFrequency (%)
기 259
 
5.8%
술 224
 
5.0%
이 192
 
4.3%
전 153
 
3.4%
의 149
 
3.4%
문 111
 
2.5%
니 90
 
2.0%
다 89
 
2.0%
청 61
 
1.4%
상 61
 
1.4%
Other values (392) 3047
68.7%
CJK
ValueCountFrequency (%)
時 1
100.0%
None
ValueCountFrequency (%)
· 1
100.0%
Punctuation
ValueCountFrequency (%)
“ 1
50.0%
” 1
50.0%

등록일자
Date

Distinct207
Distinct (%)74.7%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
Minimum2015-01-29 00:00:00
Maximum2023-06-11 00:00:00
2023-12-13T03:43:41.886890image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:43:42.108726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

상태
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
1
144 
2
109 
<NA>
24 

Length

Max length4
Median length1
Mean length1.2599278
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row1
3rd row<NA>
4th row1
5th row1

Common Values

ValueCountFrequency (%)
1 144
52.0%
2 109
39.4%
<NA> 24
 
8.7%

Length

2023-12-13T03:43:42.325625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:43:42.488160image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 144
52.0%
2 109
39.4%
na 24
 
8.7%

Interactions

2023-12-13T03:43:39.492922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T03:43:42.611814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상담실 순번상태
상담실 순번1.0000.891
상태0.8911.000
2023-12-13T03:43:42.756173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상담실 순번상태
상담실 순번1.0000.716
상태0.7161.000

Missing values

2023-12-13T03:43:39.680093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T03:43:39.832662image/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

상담실 순번제목등록일자상태
01[에너지/자원] 수소의 흡방출 압력이 제어된 상온 수소 저장 합금 및 이를 이용한 수소 연료 시스템2023-06-111
12특허기술 판매관련 문의2023-05-311
23기술이전 문의 드립니다.2023-05-26<NA>
34기술이전 관련 문의드립니다.2023-05-251
45기술이전 관련 문의드립니다.2023-05-251
56기술이전 관련 문의드립니다.2023-05-251
67기술이전 관련 문의드립니다.2023-05-251
78기술이전 관련 문의드립니다.2023-05-251
89기술이전 관련 문의 드립니다.2023-05-251
910기술이전 관련하여 질문 드립니다.2023-05-251
상담실 순번제목등록일자상태
267268등록기술에 관한 문의 건2018-07-271
268269평가전문가 신청결과에 대한 문의2018-02-281
269270기술은행네트워크(공공연구기관) 등록 요청 : 한국과학기술원 부설 나노종합기술원2017-04-112
270271회원탈퇴관련 질문입니다.2016-01-182
271272안녕하세요 기술평가 관련 질문이 있어서 문의드립니다.2015-11-242
272273기술 판매 時, 자격사항 문의2015-07-091
273274기술거래사 온라인 접수 확인2015-06-101
274275기술거래사 온라인 등록신청 확인?2015-06-101
275276기술사업성평가 결과 해석에 대한 문의2015-02-021
276277NTB 통계 관련 질문 드립니다.2015-01-291