Overview

Dataset statistics

Number of variables4
Number of observations29
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.1 KiB
Average record size in memory39.6 B

Variable types

Text1
Numeric3

Dataset

Description요구불예금, 당좌예금, 가계당좌예금, 보통예금, 저축성예금 등 중소기업은행의 과목별 예수금 목록을 csv로 제공
URLhttps://www.data.go.kr/data/15042814/fileData.do

Alerts

2021년 말 금액 is highly overall correlated with 2022년 말 금액 High correlation
2022년 말 금액 is highly overall correlated with 2021년 말 금액 High correlation
구분 백만원 단위 has unique valuesUnique
2021년 말 금액 has unique valuesUnique
2022년 말 금액 has unique valuesUnique
증감액 has 2 (6.9%) zerosZeros

Reproduction

Analysis started2023-12-12 06:36:53.771000
Analysis finished2023-12-12 06:36:54.969552
Duration1.2 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct29
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size364.0 B
2023-12-12T15:36:55.124650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length8
Mean length5.3793103
Min length3

Characters and Unicode

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

Unique

Unique29 ?
Unique (%)100.0%

Sample

1st row요구불예금
2nd row당좌예금
3rd row가계당좌예금
4th row별단예금
5th row보통예금
ValueCountFrequency (%)
요구불예금 1
 
3.4%
가계장기저축 1
 
3.4%
ibk플러스외화예금 1
 
3.4%
외화별단예금 1
 
3.4%
외화정기예금 1
 
3.4%
외화통지예금 1
 
3.4%
외화보통예금 1
 
3.4%
외화당좌예금 1
 
3.4%
외화예금 1
 
3.4%
양도성예금증서 1
 
3.4%
Other values (19) 19
65.5%
2023-12-12T15:36:55.556004image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
24
 
15.4%
21
 
13.5%
7
 
4.5%
7
 
4.5%
7
 
4.5%
7
 
4.5%
7
 
4.5%
4
 
2.6%
3
 
1.9%
3
 
1.9%
Other values (46) 66
42.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 153
98.1%
Uppercase Letter 3
 
1.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
24
 
15.7%
21
 
13.7%
7
 
4.6%
7
 
4.6%
7
 
4.6%
7
 
4.6%
7
 
4.6%
4
 
2.6%
3
 
2.0%
3
 
2.0%
Other values (43) 63
41.2%
Uppercase Letter
ValueCountFrequency (%)
I 1
33.3%
B 1
33.3%
K 1
33.3%

Most occurring scripts

ValueCountFrequency (%)
Hangul 153
98.1%
Latin 3
 
1.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
24
 
15.7%
21
 
13.7%
7
 
4.6%
7
 
4.6%
7
 
4.6%
7
 
4.6%
7
 
4.6%
4
 
2.6%
3
 
2.0%
3
 
2.0%
Other values (43) 63
41.2%
Latin
ValueCountFrequency (%)
I 1
33.3%
B 1
33.3%
K 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 153
98.1%
ASCII 3
 
1.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
24
 
15.7%
21
 
13.7%
7
 
4.6%
7
 
4.6%
7
 
4.6%
7
 
4.6%
7
 
4.6%
4
 
2.6%
3
 
2.0%
3
 
2.0%
Other values (43) 63
41.2%
ASCII
ValueCountFrequency (%)
I 1
33.3%
B 1
33.3%
K 1
33.3%

2021년 말 금액
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct29
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean10225813
Minimum19
Maximum66625836
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size393.0 B
2023-12-12T15:36:55.679756image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19
5-th percentile51
Q13320
median1154516
Q310303230
95-th percentile63676452
Maximum66625836
Range66625817
Interquartile range (IQR)10299910

Descriptive statistics

Standard deviation20240747
Coefficient of variation (CV)1.9793778
Kurtosis3.7130566
Mean10225813
Median Absolute Deviation (MAD)1154453
Skewness2.2216599
Sum2.9654857 × 108
Variance4.0968783 × 1014
MonotonicityNot monotonic
2023-12-12T15:36:55.799943image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)
ValueCountFrequency (%)
65942134 1
 
3.4%
4196123 1
 
3.4%
997 1
 
3.4%
238397 1
 
3.4%
854 1
 
3.4%
1154516 1
 
3.4%
43 1
 
3.4%
11371388 1
 
3.4%
4246 1
 
3.4%
12769444 1
 
3.4%
Other values (19) 19
65.5%
ValueCountFrequency (%)
19 1
3.4%
43 1
3.4%
63 1
3.4%
70 1
3.4%
217 1
3.4%
854 1
3.4%
997 1
3.4%
3320 1
3.4%
4246 1
3.4%
5816 1
3.4%
ValueCountFrequency (%)
66625836 1
3.4%
65942134 1
3.4%
60277929 1
3.4%
37738919 1
3.4%
14633302 1
3.4%
12769444 1
3.4%
11371388 1
3.4%
10303230 1
3.4%
4196123 1
3.4%
3201384 1
3.4%

2022년 말 금액
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct29
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean9973141.5
Minimum19
Maximum67462759
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size393.0 B
2023-12-12T15:36:55.922893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19
5-th percentile51.8
Q11160
median1245942
Q38107401
95-th percentile57095575
Maximum67462759
Range67462740
Interquartile range (IQR)8106241

Descriptive statistics

Standard deviation19086399
Coefficient of variation (CV)1.91378
Kurtosis3.7105431
Mean9973141.5
Median Absolute Deviation (MAD)1245880
Skewness2.1889755
Sum2.892211 × 108
Variance3.6429063 × 1014
MonotonicityNot monotonic
2023-12-12T15:36:56.067228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)
ValueCountFrequency (%)
59296799 1
 
3.4%
4157295 1
 
3.4%
865 1
 
3.4%
1245942 1
 
3.4%
1160 1
 
3.4%
3554384 1
 
3.4%
45 1
 
3.4%
10128312 1
 
3.4%
4466 1
 
3.4%
14934309 1
 
3.4%
Other values (19) 19
65.5%
ValueCountFrequency (%)
19 1
3.4%
45 1
3.4%
62 1
3.4%
70 1
3.4%
247 1
3.4%
865 1
3.4%
972 1
3.4%
1160 1
3.4%
4466 1
3.4%
4507 1
3.4%
ValueCountFrequency (%)
67462759 1
3.4%
59296799 1
3.4%
53793739 1
3.4%
36274506 1
3.4%
18828154 1
3.4%
14934309 1
3.4%
10128312 1
3.4%
8107401 1
3.4%
4157295 1
3.4%
3578071 1
3.4%

증감액
Real number (ℝ)

ZEROS 

Distinct28
Distinct (%)96.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-252671.14
Minimum-6645335
Maximum4194852
Zeros2
Zeros (%)6.9%
Negative15
Negative (%)51.7%
Memory size393.0 B
2023-12-12T15:36:56.253833image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-6645335
5-th percentile-4768845.6
Q1-117226
median-1
Q31187
95-th percentile2305866.8
Maximum4194852
Range10840187
Interquartile range (IQR)118413

Descriptive statistics

Standard deviation2101804.1
Coefficient of variation (CV)-8.3183386
Kurtosis4.9855617
Mean-252671.14
Median Absolute Deviation (MAD)117225
Skewness-1.6022122
Sum-7327463
Variance4.4175804 × 1012
MonotonicityNot monotonic
2023-12-12T15:36:56.415888image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=28)
ValueCountFrequency (%)
0 2
 
6.9%
-6645335 1
 
3.4%
-1464413 1
 
3.4%
-132 1
 
3.4%
1007545 1
 
3.4%
306 1
 
3.4%
2399868 1
 
3.4%
2 1
 
3.4%
-1243076 1
 
3.4%
220 1
 
3.4%
Other values (18) 18
62.1%
ValueCountFrequency (%)
-6645335 1
3.4%
-6484190 1
3.4%
-2195829 1
3.4%
-1464413 1
3.4%
-1243076 1
3.4%
-436233 1
3.4%
-415164 1
3.4%
-117226 1
3.4%
-38828 1
3.4%
-4844 1
3.4%
ValueCountFrequency (%)
4194852 1
3.4%
2399868 1
3.4%
2164865 1
3.4%
1007545 1
3.4%
836923 1
3.4%
740855 1
3.4%
376687 1
3.4%
1187 1
3.4%
306 1
3.4%
220 1
3.4%

Interactions

2023-12-12T15:36:54.533767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:36:53.919968image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:36:54.233473image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:36:54.630334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:36:54.025892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:36:54.327311image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:36:54.718216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:36:54.146207image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:36:54.441810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T15:36:56.525798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분 백만원 단위2021년 말 금액2022년 말 금액증감액
구분 백만원 단위1.0001.0001.0001.000
2021년 말 금액1.0001.0000.9230.814
2022년 말 금액1.0000.9231.0000.811
증감액1.0000.8140.8111.000
2023-12-12T15:36:56.630251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2021년 말 금액2022년 말 금액증감액
2021년 말 금액1.0000.989-0.227
2022년 말 금액0.9891.000-0.155
증감액-0.227-0.1551.000

Missing values

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

구분 백만원 단위2021년 말 금액2022년 말 금액증감액
0요구불예금6594213459296799-6645335
1당좌예금41961234157295-38828
2가계당좌예금2270020299-2401
3별단예금14360301318804-117226
4보통예금6027792953793739-6484190
5공금예금5816972-4844
6국고예금332045071187
7투자일임예수부채21724730
8저축성예금6662583667462759836923
9저축예금103032308107401-2195829
구분 백만원 단위2021년 말 금액2022년 말 금액증감액
19주택부금1402913208-821
20양도성예금증서32013843578071376687
21외화예금12769444149343092164865
22외화당좌예금42464466220
23외화보통예금1137138810128312-1243076
24외화통지예금43452
25외화정기예금115451635543842399868
26외화별단예금8541160306
27IBK플러스외화예금23839712459421007545
28금예수997865-132