Overview

Dataset statistics

Number of variables3
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory882.0 B
Average record size in memory29.4 B

Variable types

Numeric1
Categorical1
Text1

Dataset

Description사립학교교직원연금공단 해외주식 위탁운용사 선정 현황과 관련된 데이터로 순번, 구분, 위탁운용사 전체 현황 등의 항목을 제공합니다.
URLhttps://www.data.go.kr/data/15045828/fileData.do

Alerts

순번 is highly overall correlated with 구분High correlation
구분 is highly overall correlated with 순번High correlation
순번 has unique valuesUnique
2023년 상반기 기준 위탁운용사 전체현황 has unique valuesUnique

Reproduction

Analysis started2023-12-12 09:14:40.121834
Analysis finished2023-12-12 09:14:40.527001
Duration0.41 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15.5
Minimum1
Maximum30
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-12T18:14:40.614615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.45
Q18.25
median15.5
Q322.75
95-th percentile28.55
Maximum30
Range29
Interquartile range (IQR)14.5

Descriptive statistics

Standard deviation8.8034084
Coefficient of variation (CV)0.56796183
Kurtosis-1.2
Mean15.5
Median Absolute Deviation (MAD)7.5
Skewness0
Sum465
Variance77.5
MonotonicityStrictly increasing
2023-12-12T18:14:40.794416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
1 1
 
3.3%
17 1
 
3.3%
30 1
 
3.3%
29 1
 
3.3%
28 1
 
3.3%
27 1
 
3.3%
26 1
 
3.3%
25 1
 
3.3%
24 1
 
3.3%
23 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
1 1
3.3%
2 1
3.3%
3 1
3.3%
4 1
3.3%
5 1
3.3%
6 1
3.3%
7 1
3.3%
8 1
3.3%
9 1
3.3%
10 1
3.3%
ValueCountFrequency (%)
30 1
3.3%
29 1
3.3%
28 1
3.3%
27 1
3.3%
26 1
3.3%
25 1
3.3%
24 1
3.3%
23 1
3.3%
22 1
3.3%
21 1
3.3%

구분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
해외
24 
국내

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 (%)
해외 24
80.0%
국내 6
 
20.0%

Length

2023-12-12T18:14:40.972420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:14:41.141224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
해외 24
80.0%
국내 6
 
20.0%
Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-12T18:14:41.374318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length14
Mean length8.3666667
Min length3

Characters and Unicode

Total characters251
Distinct characters44
Distinct categories4 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique30 ?
Unique (%)100.0%

Sample

1st row대신자산운용
2nd rowKB자산운용
3rd row미래에셋자산운용
4th row우리자산운용
5th row한화자산운용
ValueCountFrequency (%)
대신자산운용 1
 
2.7%
mercer 1
 
2.7%
morgan 1
 
2.7%
stanley 1
 
2.7%
natixis 1
 
2.7%
pgim 1
 
2.7%
pinebridge 1
 
2.7%
rbc 1
 
2.7%
robeco 1
 
2.7%
russell 1
 
2.7%
Other values (27) 27
73.0%
2023-12-12T18:14:41.909338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
E 21
 
8.4%
I 19
 
7.6%
R 19
 
7.6%
N 17
 
6.8%
A 16
 
6.4%
S 14
 
5.6%
O 13
 
5.2%
T 11
 
4.4%
L 11
 
4.4%
C 9
 
3.6%
Other values (34) 101
40.2%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 205
81.7%
Other Letter 37
 
14.7%
Space Separator 7
 
2.8%
Other Punctuation 2
 
0.8%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
E 21
 
10.2%
I 19
 
9.3%
R 19
 
9.3%
N 17
 
8.3%
A 16
 
7.8%
S 14
 
6.8%
O 13
 
6.3%
T 11
 
5.4%
L 11
 
5.4%
C 9
 
4.4%
Other values (14) 55
26.8%
Other Letter
ValueCountFrequency (%)
6
16.2%
6
16.2%
6
16.2%
6
16.2%
1
 
2.7%
1
 
2.7%
1
 
2.7%
1
 
2.7%
1
 
2.7%
1
 
2.7%
Other values (7) 7
18.9%
Other Punctuation
ValueCountFrequency (%)
. 1
50.0%
& 1
50.0%
Space Separator
ValueCountFrequency (%)
7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 205
81.7%
Hangul 37
 
14.7%
Common 9
 
3.6%

Most frequent character per script

Latin
ValueCountFrequency (%)
E 21
 
10.2%
I 19
 
9.3%
R 19
 
9.3%
N 17
 
8.3%
A 16
 
7.8%
S 14
 
6.8%
O 13
 
6.3%
T 11
 
5.4%
L 11
 
5.4%
C 9
 
4.4%
Other values (14) 55
26.8%
Hangul
ValueCountFrequency (%)
6
16.2%
6
16.2%
6
16.2%
6
16.2%
1
 
2.7%
1
 
2.7%
1
 
2.7%
1
 
2.7%
1
 
2.7%
1
 
2.7%
Other values (7) 7
18.9%
Common
ValueCountFrequency (%)
7
77.8%
. 1
 
11.1%
& 1
 
11.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 214
85.3%
Hangul 37
 
14.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
E 21
 
9.8%
I 19
 
8.9%
R 19
 
8.9%
N 17
 
7.9%
A 16
 
7.5%
S 14
 
6.5%
O 13
 
6.1%
T 11
 
5.1%
L 11
 
5.1%
C 9
 
4.2%
Other values (17) 64
29.9%
Hangul
ValueCountFrequency (%)
6
16.2%
6
16.2%
6
16.2%
6
16.2%
1
 
2.7%
1
 
2.7%
1
 
2.7%
1
 
2.7%
1
 
2.7%
1
 
2.7%
Other values (7) 7
18.9%

Interactions

2023-12-12T18:14:40.250242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T18:14:42.036204image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번구분2023년 상반기 기준 위탁운용사 전체현황
순번1.0001.0001.000
구분1.0001.0001.000
2023년 상반기 기준 위탁운용사 전체현황1.0001.0001.000
2023-12-12T18:14:42.148571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번구분
순번1.0000.845
구분0.8451.000

Missing values

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

순번구분2023년 상반기 기준 위탁운용사 전체현황
01국내대신자산운용
12국내KB자산운용
23국내미래에셋자산운용
34국내우리자산운용
45국내한화자산운용
56국내NH아문디자산운용
67해외ALLIANCEBERNSTEIN
78해외AMERICAN CENTURY
89해외ARTISAN
910해외AXIOM
순번구분2023년 상반기 기준 위탁운용사 전체현황
2021해외PINEBRIDGE
2122해외RBC
2223해외ROBECO
2324해외RUSSELL
2425해외SANDS
2526해외SPARINVEST
2627해외SPARX
2728해외T.ROWE PRICE
2829해외TOWERS WATSON
2930해외WELLINGTON