Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 100 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 9.7 KiB |
| Average record size in memory | 99.3 B |
Variable types
| Text | 1 |
|---|---|
| Numeric | 10 |
Dataset
| Description | 샘플 데이터 |
|---|---|
| Author | 신한은행 |
| URL | https://bigdata.seoul.go.kr/data/selectSampleData.do?sample_data_seq=320 |
총수신평잔_총액(DEP_TOT_AVJN_TOT) has unique values | Unique |
유동성급여_가맹점매출_유동성연금_입금_건수(I_TOT_AMT_N) has 27 (27.0%) zeros | Zeros |
유동성급여_가맹점매출_유동성연금_입금총액(I_TOT_AMT_TOT) has 21 (21.0%) zeros | Zeros |
유동성급여_유동성연금_입금_건수(I_PAY_PENS_AMT_N) has 33 (33.0%) zeros | Zeros |
유동성급여_유동성연금_입금_총액(I_PAY_PENS_AMT_TOT) has 26 (26.0%) zeros | Zeros |
신용카드_체크카드_현금소비_현금인출_건수(C_TOT_AMT_N) has 7 (7.0%) zeros | Zeros |
신용카드_체크카드_현금소비_현금인출_총액(C_TOT_AMT_TOT) has 8 (8.0%) zeros | Zeros |
신용카드_체크카드_건수(C_CARDSUM_AMT_N) has 12 (12.0%) zeros | Zeros |
신용카드_체크카드_총액(C_CARDSUM_AMT_TOT) has 10 (10.0%) zeros | Zeros |
Reproduction
| Analysis started | 2023-12-10 14:56:32.998043 |
|---|---|
| Analysis finished | 2023-12-10 14:56:53.465409 |
| Duration | 20.47 seconds |
| Software version | ydata-profiling vv4.5.1 |
| Download configuration | config.json |
그리드코드(GRID50_ID)
Text
| Distinct | 80 |
|---|---|
| Distinct (%) | 80.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 932.0 B |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 1000 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 62 ? |
|---|---|
| Unique (%) | 62.0% |
Sample
| 1st row | G*0*2*8*3* |
|---|---|
| 2nd row | G*0*0*3*0* |
| 3rd row | G*0*1*7*6* |
| 4th row | G*0*0*9*2* |
| 5th row | G*0*1*6*5* |
| Value | Count | Frequency (%) |
| g*0*1*4*9 | 3 | 3.0% |
| g*0*1*0*0 | 3 | 3.0% |
| g*0*2*1*0 | 2 | 2.0% |
| g*0*1*5*5 | 2 | 2.0% |
| g*0*1*7*3 | 2 | 2.0% |
| g*0*0*3*0 | 2 | 2.0% |
| g*0*0*1*7 | 2 | 2.0% |
| g*0*2*5*8 | 2 | 2.0% |
| g*0*2*8*3 | 2 | 2.0% |
| g*0*1*3*0 | 2 | 2.0% |
| Other values (70) | 78 |
Most occurring characters
| Value | Count | Frequency (%) |
| * | 500 | |
| 0 | 159 | 15.9% |
| G | 100 | 10.0% |
| 1 | 64 | 6.4% |
| 2 | 43 | 4.3% |
| 3 | 25 | 2.5% |
| 9 | 22 | 2.2% |
| 5 | 22 | 2.2% |
| 7 | 19 | 1.9% |
| 8 | 18 | 1.8% |
| Other values (2) | 28 | 2.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Other Punctuation | 500 | |
| Decimal Number | 400 | |
| Uppercase Letter | 100 | 10.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 159 | |
| 1 | 64 | |
| 2 | 43 | 10.8% |
| 3 | 25 | 6.2% |
| 9 | 22 | 5.5% |
| 5 | 22 | 5.5% |
| 7 | 19 | 4.8% |
| 8 | 18 | 4.5% |
| 6 | 16 | 4.0% |
| 4 | 12 | 3.0% |
Other Punctuation
| Value | Count | Frequency (%) |
| * | 500 |
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 100 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 900 | |
| Latin | 100 | 10.0% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| * | 500 | |
| 0 | 159 | 17.7% |
| 1 | 64 | 7.1% |
| 2 | 43 | 4.8% |
| 3 | 25 | 2.8% |
| 9 | 22 | 2.4% |
| 5 | 22 | 2.4% |
| 7 | 19 | 2.1% |
| 8 | 18 | 2.0% |
| 6 | 16 | 1.8% |
Latin
| Value | Count | Frequency (%) |
| G | 100 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1000 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| * | 500 | |
| 0 | 159 | 15.9% |
| G | 100 | 10.0% |
| 1 | 64 | 6.4% |
| 2 | 43 | 4.3% |
| 3 | 25 | 2.5% |
| 9 | 22 | 2.2% |
| 5 | 22 | 2.2% |
| 7 | 19 | 1.9% |
| 8 | 18 | 1.8% |
| Other values (2) | 28 | 2.8% |
총수신평잔_건수(DEP_TOT_AVJN_N)
Real number (ℝ)
| Distinct | 98 |
|---|---|
| Distinct (%) | 98.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 844.94 |
| Minimum | 8 |
|---|---|
| Maximum | 5177 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 8 |
|---|---|
| 5-th percentile | 55.2 |
| Q1 | 365.5 |
| median | 759.5 |
| Q3 | 1068 |
| 95-th percentile | 2040.55 |
| Maximum | 5177 |
| Range | 5169 |
| Interquartile range (IQR) | 702.5 |
Descriptive statistics
| Standard deviation | 724.31405 |
|---|---|
| Coefficient of variation (CV) | 0.85723726 |
| Kurtosis | 12.25646 |
| Mean | 844.94 |
| Median Absolute Deviation (MAD) | 365 |
| Skewness | 2.6018616 |
| Sum | 84494 |
| Variance | 524630.84 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 796 | 2 | 2.0% |
| 623 | 2 | 2.0% |
| 963 | 1 | 1.0% |
| 878 | 1 | 1.0% |
| 826 | 1 | 1.0% |
| 752 | 1 | 1.0% |
| 487 | 1 | 1.0% |
| 1762 | 1 | 1.0% |
| 8 | 1 | 1.0% |
| 478 | 1 | 1.0% |
| Other values (88) | 88 |
| Value | Count | Frequency (%) |
| 8 | 1 | |
| 27 | 1 | |
| 30 | 1 | |
| 32 | 1 | |
| 40 | 1 | |
| 56 | 1 | |
| 60 | 1 | |
| 74 | 1 | |
| 103 | 1 | |
| 112 | 1 |
| Value | Count | Frequency (%) |
| 5177 | 1 | |
| 2895 | 1 | |
| 2229 | 1 | |
| 2224 | 1 | |
| 2203 | 1 | |
| 2032 | 1 | |
| 1935 | 1 | |
| 1765 | 1 | |
| 1762 | 1 | |
| 1648 | 1 |
총수신평잔_총액(DEP_TOT_AVJN_TOT)
Real number (ℝ)
UNIQUE
| Distinct | 100 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.771694 × 109 |
| Minimum | 395959.68 |
|---|---|
| Maximum | 2.6657437 × 1010 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 395959.68 |
|---|---|
| 5-th percentile | 89947530 |
| Q1 | 7.8117109 × 108 |
| median | 2.3389246 × 109 |
| Q3 | 4.121897 × 109 |
| 95-th percentile | 1.3598601 × 1010 |
| Maximum | 2.6657437 × 1010 |
| Range | 2.6657041 × 1010 |
| Interquartile range (IQR) | 3.3407259 × 109 |
Descriptive statistics
| Standard deviation | 5.1559163 × 109 |
|---|---|
| Coefficient of variation (CV) | 1.3670028 |
| Kurtosis | 7.77522 |
| Mean | 3.771694 × 109 |
| Median Absolute Deviation (MAD) | 1.6440481 × 109 |
| Skewness | 2.724241 |
| Sum | 3.771694 × 1011 |
| Variance | 2.6583473 × 1019 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 259583140.088 | 1 | 1.0% |
| 10096213465.414 | 1 | 1.0% |
| 594943143.792 | 1 | 1.0% |
| 2130565073.548 | 1 | 1.0% |
| 4673410186.253 | 1 | 1.0% |
| 2590697277.681 | 1 | 1.0% |
| 1257065473.304 | 1 | 1.0% |
| 26657437113.0 | 1 | 1.0% |
| 91445073.3829 | 1 | 1.0% |
| 2933827092.694 | 1 | 1.0% |
| Other values (90) | 90 |
| Value | Count | Frequency (%) |
| 395959.67996 | 1 | |
| 48838115.464 | 1 | |
| 56456812.28 | 1 | |
| 59048729.2204 | 1 | |
| 61494208.719 | 1 | |
| 91445073.3829 | 1 | |
| 105351482.0 | 1 | |
| 129397122.4 | 1 | |
| 158145452.66 | 1 | |
| 185103952.555 | 1 |
| Value | Count | Frequency (%) |
| 26657437113.0 | 1 | |
| 22781927990.42 | 1 | |
| 22360931387.918 | 1 | |
| 22225139792.633 | 1 | |
| 18703235868.13 | 1 | |
| 13329936403.22 | 1 | |
| 11931308214.866 | 1 | |
| 11906975477.74 | 1 | |
| 10096213465.414 | 1 | |
| 9236857704.211 | 1 |
유동성급여_가맹점매출_유동성연금_입금_건수(I_TOT_AMT_N)
Real number (ℝ)
ZEROS
| Distinct | 69 |
|---|---|
| Distinct (%) | 69.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 138.25 |
| Minimum | 0 |
|---|---|
| Maximum | 1552 |
| Zeros | 27 |
| Zeros (%) | 27.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 87.5 |
| Q3 | 175 |
| 95-th percentile | 377.15 |
| Maximum | 1552 |
| Range | 1552 |
| Interquartile range (IQR) | 175 |
Descriptive statistics
| Standard deviation | 224.54184 |
|---|---|
| Coefficient of variation (CV) | 1.6241724 |
| Kurtosis | 22.725447 |
| Mean | 138.25 |
| Median Absolute Deviation (MAD) | 87.5 |
| Skewness | 4.2473521 |
| Sum | 13825 |
| Variance | 50419.038 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 27 | |
| 6 | 3 | 3.0% |
| 66 | 2 | 2.0% |
| 222 | 2 | 2.0% |
| 103 | 2 | 2.0% |
| 178 | 1 | 1.0% |
| 97 | 1 | 1.0% |
| 157 | 1 | 1.0% |
| 161 | 1 | 1.0% |
| 203 | 1 | 1.0% |
| Other values (59) | 59 |
| Value | Count | Frequency (%) |
| 0 | 27 | |
| 6 | 3 | 3.0% |
| 7 | 1 | 1.0% |
| 12 | 1 | 1.0% |
| 13 | 1 | 1.0% |
| 24 | 1 | 1.0% |
| 26 | 1 | 1.0% |
| 27 | 1 | 1.0% |
| 30 | 1 | 1.0% |
| 31 | 1 | 1.0% |
| Value | Count | Frequency (%) |
| 1552 | 1 | |
| 1330 | 1 | |
| 637 | 1 | |
| 439 | 1 | |
| 437 | 1 | |
| 374 | 1 | |
| 366 | 1 | |
| 352 | 1 | |
| 336 | 1 | |
| 312 | 1 |
유동성급여_가맹점매출_유동성연금_입금총액(I_TOT_AMT_TOT)
Real number (ℝ)
ZEROS
| Distinct | 80 |
|---|---|
| Distinct (%) | 80.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.028114 × 108 |
| Minimum | 0 |
|---|---|
| Maximum | 3.0325355 × 109 |
| Zeros | 21 |
| Zeros (%) | 21.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 76441803 |
| median | 2.5460939 × 108 |
| Q3 | 5.1117194 × 108 |
| 95-th percentile | 1.4533029 × 109 |
| Maximum | 3.0325355 × 109 |
| Range | 3.0325355 × 109 |
| Interquartile range (IQR) | 4.3473013 × 108 |
Descriptive statistics
| Standard deviation | 5.3853223 × 108 |
|---|---|
| Coefficient of variation (CV) | 1.336934 |
| Kurtosis | 9.5710259 |
| Mean | 4.028114 × 108 |
| Median Absolute Deviation (MAD) | 2.255706 × 108 |
| Skewness | 2.8578486 |
| Sum | 4.028114 × 1010 |
| Variance | 2.9001697 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.0 | 21 | 21.0% |
| 312663329.993 | 1 | 1.0% |
| 743786670.006 | 1 | 1.0% |
| 206065546.0 | 1 | 1.0% |
| 320618251.009 | 1 | 1.0% |
| 187375197.006 | 1 | 1.0% |
| 358533218.0 | 1 | 1.0% |
| 169529269.0 | 1 | 1.0% |
| 83656994.0 | 1 | 1.0% |
| 125534388.0 | 1 | 1.0% |
| Other values (70) | 70 |
| Value | Count | Frequency (%) |
| 0.0 | 21 | |
| 11967565.998 | 1 | 1.0% |
| 35688782.003 | 1 | 1.0% |
| 48793226.004 | 1 | 1.0% |
| 54796231.998 | 1 | 1.0% |
| 83656994.0 | 1 | 1.0% |
| 84448881.0009 | 1 | 1.0% |
| 96697817.998 | 1 | 1.0% |
| 125534388.0 | 1 | 1.0% |
| 128840544.001 | 1 | 1.0% |
| Value | Count | Frequency (%) |
| 3032535517.959 | 1 | |
| 2707452375.055 | 1 | |
| 2223737797.941 | 1 | |
| 1921055949.087 | 1 | |
| 1867543322.053 | 1 | |
| 1431500736.99 | 1 | |
| 993746018.009 | 1 | |
| 955343037.999 | 1 | |
| 906781606.007 | 1 | |
| 905633744.999 | 1 |
유동성급여_유동성연금_입금_건수(I_PAY_PENS_AMT_N)
Real number (ℝ)
ZEROS
| Distinct | 62 |
|---|---|
| Distinct (%) | 62.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 114.26 |
| Minimum | 0 |
|---|---|
| Maximum | 619 |
| Zeros | 33 |
| Zeros (%) | 33.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 90.5 |
| Q3 | 174.25 |
| 95-th percentile | 364.8 |
| Maximum | 619 |
| Range | 619 |
| Interquartile range (IQR) | 174.25 |
Descriptive statistics
| Standard deviation | 126.88606 |
|---|---|
| Coefficient of variation (CV) | 1.1105029 |
| Kurtosis | 2.7879494 |
| Mean | 114.26 |
| Median Absolute Deviation (MAD) | 90.5 |
| Skewness | 1.5059914 |
| Sum | 11426 |
| Variance | 16100.073 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 33 | |
| 178 | 2 | 2.0% |
| 56 | 2 | 2.0% |
| 174 | 2 | 2.0% |
| 44 | 2 | 2.0% |
| 161 | 2 | 2.0% |
| 151 | 2 | 2.0% |
| 230 | 1 | 1.0% |
| 175 | 1 | 1.0% |
| 85 | 1 | 1.0% |
| Other values (52) | 52 |
| Value | Count | Frequency (%) |
| 0 | 33 | |
| 12 | 1 | 1.0% |
| 22 | 1 | 1.0% |
| 30 | 1 | 1.0% |
| 31 | 1 | 1.0% |
| 34 | 1 | 1.0% |
| 44 | 2 | 2.0% |
| 56 | 2 | 2.0% |
| 57 | 1 | 1.0% |
| 63 | 1 | 1.0% |
| Value | Count | Frequency (%) |
| 619 | 1 | |
| 531 | 1 | |
| 468 | 1 | |
| 430 | 1 | |
| 380 | 1 | |
| 364 | 1 | |
| 338 | 1 | |
| 278 | 1 | |
| 270 | 1 | |
| 256 | 1 |
유동성급여_유동성연금_입금_총액(I_PAY_PENS_AMT_TOT)
Real number (ℝ)
ZEROS
| Distinct | 75 |
|---|---|
| Distinct (%) | 75.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.5401814 × 108 |
| Minimum | 0 |
|---|---|
| Maximum | 1.3957391 × 109 |
| Zeros | 26 |
| Zeros (%) | 26.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1.5726766 × 108 |
| Q3 | 3.7109051 × 108 |
| 95-th percentile | 9.1663697 × 108 |
| Maximum | 1.3957391 × 109 |
| Range | 1.3957391 × 109 |
| Interquartile range (IQR) | 3.7109051 × 108 |
Descriptive statistics
| Standard deviation | 2.9447122 × 108 |
|---|---|
| Coefficient of variation (CV) | 1.1592527 |
| Kurtosis | 2.3011384 |
| Mean | 2.5401814 × 108 |
| Median Absolute Deviation (MAD) | 1.5726766 × 108 |
| Skewness | 1.5343284 |
| Sum | 2.5401814 × 1010 |
| Variance | 8.6713298 × 1016 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.0 | 26 | 26.0% |
| 67185168.004 | 1 | 1.0% |
| 347730841.0 | 1 | 1.0% |
| 922123336.009 | 1 | 1.0% |
| 1040590870.99 | 1 | 1.0% |
| 77950071.999 | 1 | 1.0% |
| 466748681.028 | 1 | 1.0% |
| 1395739143.048 | 1 | 1.0% |
| 21677980.0 | 1 | 1.0% |
| 544322403.034 | 1 | 1.0% |
| Other values (65) | 65 |
| Value | Count | Frequency (%) |
| 0.0 | 26 | |
| 9112000.0002 | 1 | 1.0% |
| 17884736.001 | 1 | 1.0% |
| 21067791.0 | 1 | 1.0% |
| 21677980.0 | 1 | 1.0% |
| 23635330.998 | 1 | 1.0% |
| 28999123.002 | 1 | 1.0% |
| 46372650.998 | 1 | 1.0% |
| 60261221.997 | 1 | 1.0% |
| 62050072.996 | 1 | 1.0% |
| Value | Count | Frequency (%) |
| 1395739143.048 | 1 | |
| 1079563849.943 | 1 | |
| 1040590870.99 | 1 | |
| 1027701486.0 | 1 | |
| 922123336.009 | 1 | |
| 916348212.965 | 1 | |
| 827257204.008 | 1 | |
| 763844579.984 | 1 | |
| 706237123.957 | 1 | |
| 701734211.028 | 1 |
신용카드_체크카드_현금소비_현금인출_건수(C_TOT_AMT_N)
Real number (ℝ)
ZEROS
| Distinct | 89 |
|---|---|
| Distinct (%) | 89.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 412.68 |
| Minimum | 0 |
|---|---|
| Maximum | 3482 |
| Zeros | 7 |
| Zeros (%) | 7.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 125.75 |
| median | 295.5 |
| Q3 | 557.5 |
| 95-th percentile | 1015.3 |
| Maximum | 3482 |
| Range | 3482 |
| Interquartile range (IQR) | 431.75 |
Descriptive statistics
| Standard deviation | 498.47158 |
|---|---|
| Coefficient of variation (CV) | 1.2078889 |
| Kurtosis | 19.1887 |
| Mean | 412.68 |
| Median Absolute Deviation (MAD) | 178.5 |
| Skewness | 3.8017922 |
| Sum | 41268 |
| Variance | 248473.92 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 7 | 7.0% |
| 320 | 2 | 2.0% |
| 674 | 2 | 2.0% |
| 177 | 2 | 2.0% |
| 125 | 2 | 2.0% |
| 117 | 2 | 2.0% |
| 52 | 1 | 1.0% |
| 559 | 1 | 1.0% |
| 560 | 1 | 1.0% |
| 254 | 1 | 1.0% |
| Other values (79) | 79 |
| Value | Count | Frequency (%) |
| 0 | 7 | |
| 37 | 1 | 1.0% |
| 45 | 1 | 1.0% |
| 48 | 1 | 1.0% |
| 50 | 1 | 1.0% |
| 52 | 1 | 1.0% |
| 64 | 1 | 1.0% |
| 68 | 1 | 1.0% |
| 70 | 1 | 1.0% |
| 73 | 1 | 1.0% |
| Value | Count | Frequency (%) |
| 3482 | 1 | |
| 2851 | 1 | |
| 1678 | 1 | |
| 1266 | 1 | |
| 1021 | 1 | |
| 1015 | 1 | |
| 879 | 1 | |
| 877 | 1 | |
| 809 | 1 | |
| 787 | 1 |
신용카드_체크카드_현금소비_현금인출_총액(C_TOT_AMT_TOT)
Real number (ℝ)
ZEROS
| Distinct | 93 |
|---|---|
| Distinct (%) | 93.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.9303996 × 108 |
| Minimum | 0 |
|---|---|
| Maximum | 5.7428166 × 109 |
| Zeros | 8 |
| Zeros (%) | 8.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1.8143751 × 108 |
| median | 4.7199242 × 108 |
| Q3 | 8.3264174 × 108 |
| 95-th percentile | 1.6559905 × 109 |
| Maximum | 5.7428166 × 109 |
| Range | 5.7428166 × 109 |
| Interquartile range (IQR) | 6.5120424 × 108 |
Descriptive statistics
| Standard deviation | 6.9972619 × 108 |
|---|---|
| Coefficient of variation (CV) | 1.1798972 |
| Kurtosis | 29.422667 |
| Mean | 5.9303996 × 108 |
| Median Absolute Deviation (MAD) | 2.9789599 × 108 |
| Skewness | 4.435643 |
| Sum | 5.9303996 × 1010 |
| Variance | 4.8961673 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.0 | 8 | 8.0% |
| 34272752.0015 | 1 | 1.0% |
| 633235163.9912 | 1 | 1.0% |
| 923753859.0 | 1 | 1.0% |
| 1202581972.062 | 1 | 1.0% |
| 243025409.9836 | 1 | 1.0% |
| 528242223.023 | 1 | 1.0% |
| 109338036.997 | 1 | 1.0% |
| 183412180.998 | 1 | 1.0% |
| 913691803.0 | 1 | 1.0% |
| Other values (83) | 83 |
| Value | Count | Frequency (%) |
| 0.0 | 8 | |
| 19408519.002 | 1 | 1.0% |
| 34272752.0015 | 1 | 1.0% |
| 45693733.002 | 1 | 1.0% |
| 48828305.0 | 1 | 1.0% |
| 86159281.998 | 1 | 1.0% |
| 86524296.9865 | 1 | 1.0% |
| 96885182.004 | 1 | 1.0% |
| 108048295.0004 | 1 | 1.0% |
| 109338036.997 | 1 | 1.0% |
| Value | Count | Frequency (%) |
| 5742816575.527 | 1 | |
| 2247778352.0 | 1 | |
| 2090279006.948 | 1 | |
| 1931808242.893 | 1 | |
| 1921188868.01 | 1 | |
| 1642032690.985 | 1 | |
| 1202581972.062 | 1 | |
| 1149500487.0 | 1 | |
| 1142348291.012 | 1 | |
| 1110554749.993 | 1 |
신용카드_체크카드_건수(C_CARDSUM_AMT_N)
Real number (ℝ)
ZEROS
| Distinct | 84 |
|---|---|
| Distinct (%) | 84.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 380.92 |
| Minimum | 0 |
|---|---|
| Maximum | 2545 |
| Zeros | 12 |
| Zeros (%) | 12.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 103 |
| median | 249 |
| Q3 | 466.5 |
| 95-th percentile | 1304.9 |
| Maximum | 2545 |
| Range | 2545 |
| Interquartile range (IQR) | 363.5 |
Descriptive statistics
| Standard deviation | 453.93144 |
|---|---|
| Coefficient of variation (CV) | 1.1916713 |
| Kurtosis | 6.7505548 |
| Mean | 380.92 |
| Median Absolute Deviation (MAD) | 161 |
| Skewness | 2.377075 |
| Sum | 38092 |
| Variance | 206053.75 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 12 | 12.0% |
| 103 | 3 | 3.0% |
| 106 | 2 | 2.0% |
| 157 | 2 | 2.0% |
| 224 | 2 | 2.0% |
| 1075 | 1 | 1.0% |
| 389 | 1 | 1.0% |
| 410 | 1 | 1.0% |
| 369 | 1 | 1.0% |
| 206 | 1 | 1.0% |
| Other values (74) | 74 |
| Value | Count | Frequency (%) |
| 0 | 12 | |
| 14 | 1 | 1.0% |
| 25 | 1 | 1.0% |
| 30 | 1 | 1.0% |
| 38 | 1 | 1.0% |
| 54 | 1 | 1.0% |
| 57 | 1 | 1.0% |
| 69 | 1 | 1.0% |
| 75 | 1 | 1.0% |
| 88 | 1 | 1.0% |
| Value | Count | Frequency (%) |
| 2545 | 1 | |
| 2041 | 1 | |
| 1821 | 1 | |
| 1437 | 1 | |
| 1398 | 1 | |
| 1300 | 1 | |
| 1250 | 1 | |
| 1140 | 1 | |
| 1088 | 1 | |
| 1075 | 1 |
신용카드_체크카드_총액(C_CARDSUM_AMT_TOT)
Real number (ℝ)
ZEROS
| Distinct | 91 |
|---|---|
| Distinct (%) | 91.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.5928467 × 108 |
| Minimum | 0 |
|---|---|
| Maximum | 1.8603387 × 109 |
| Zeros | 10 |
| Zeros (%) | 10.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1.1056789 × 108 |
| median | 2.9885719 × 108 |
| Q3 | 4.6582742 × 108 |
| 95-th percentile | 1.0446252 × 109 |
| Maximum | 1.8603387 × 109 |
| Range | 1.8603387 × 109 |
| Interquartile range (IQR) | 3.5525953 × 108 |
Descriptive statistics
| Standard deviation | 3.5725925 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.99436263 |
| Kurtosis | 5.0059407 |
| Mean | 3.5928467 × 108 |
| Median Absolute Deviation (MAD) | 1.7764913 × 108 |
| Skewness | 1.9310173 |
| Sum | 3.5928467 × 1010 |
| Variance | 1.2763417 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.0 | 10 | 10.0% |
| 165059946.0066 | 1 | 1.0% |
| 198627299.9991 | 1 | 1.0% |
| 200865070.992 | 1 | 1.0% |
| 943077967.014 | 1 | 1.0% |
| 102044554.0004 | 1 | 1.0% |
| 889429650.015 | 1 | 1.0% |
| 460959982.984 | 1 | 1.0% |
| 1844421589.155 | 1 | 1.0% |
| 435896187.0 | 1 | 1.0% |
| Other values (81) | 81 |
| Value | Count | Frequency (%) |
| 0.0 | 10 | |
| 18033754.0 | 1 | 1.0% |
| 18525621.0021 | 1 | 1.0% |
| 27808222.9978 | 1 | 1.0% |
| 35692169.0006 | 1 | 1.0% |
| 45460339.0 | 1 | 1.0% |
| 47088907.0032 | 1 | 1.0% |
| 48810165.0002 | 1 | 1.0% |
| 54090378.0006 | 1 | 1.0% |
| 55166240.0 | 1 | 1.0% |
| Value | Count | Frequency (%) |
| 1860338732.035 | 1 | |
| 1844421589.155 | 1 | |
| 1244308586.0 | 1 | |
| 1099828153.0 | 1 | |
| 1052493706.936 | 1 | |
| 1044211098.911 | 1 | |
| 1022371314.993 | 1 | |
| 1010349569.0 | 1 | |
| 943077967.014 | 1 | |
| 889429650.015 | 1 |
| 그리드코드(GRID50_ID) | 총수신평잔_건수(DEP_TOT_AVJN_N) | 총수신평잔_총액(DEP_TOT_AVJN_TOT) | 유동성급여_가맹점매출_유동성연금_입금_건수(I_TOT_AMT_N) | 유동성급여_가맹점매출_유동성연금_입금총액(I_TOT_AMT_TOT) | 유동성급여_유동성연금_입금_건수(I_PAY_PENS_AMT_N) | 유동성급여_유동성연금_입금_총액(I_PAY_PENS_AMT_TOT) | 신용카드_체크카드_현금소비_현금인출_건수(C_TOT_AMT_N) | 신용카드_체크카드_현금소비_현금인출_총액(C_TOT_AMT_TOT) | 신용카드_체크카드_건수(C_CARDSUM_AMT_N) | 신용카드_체크카드_총액(C_CARDSUM_AMT_TOT) | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 그리드코드(GRID50_ID) | 1.000 | 0.570 | 0.000 | 0.626 | 0.000 | 0.000 | 0.929 | 0.843 | 0.929 | 0.000 | 0.000 |
| 총수신평잔_건수(DEP_TOT_AVJN_N) | 0.570 | 1.000 | 0.000 | 0.000 | 0.126 | 0.050 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
| 총수신평잔_총액(DEP_TOT_AVJN_TOT) | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.440 |
| 유동성급여_가맹점매출_유동성연금_입금_건수(I_TOT_AMT_N) | 0.626 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.352 | 0.000 | 0.000 | 0.516 | 0.000 |
| 유동성급여_가맹점매출_유동성연금_입금총액(I_TOT_AMT_TOT) | 0.000 | 0.126 | 0.000 | 0.000 | 1.000 | 0.000 | 0.404 | 0.000 | 0.000 | 0.000 | 0.618 |
| 유동성급여_유동성연금_입금_건수(I_PAY_PENS_AMT_N) | 0.000 | 0.050 | 0.000 | 0.000 | 0.000 | 1.000 | 0.052 | 0.000 | 0.000 | 0.000 | 0.349 |
| 유동성급여_유동성연금_입금_총액(I_PAY_PENS_AMT_TOT) | 0.929 | 0.000 | 0.000 | 0.352 | 0.404 | 0.052 | 1.000 | 0.000 | 0.368 | 0.215 | 0.000 |
| 신용카드_체크카드_현금소비_현금인출_건수(C_TOT_AMT_N) | 0.843 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.172 | 0.083 | 0.000 |
| 신용카드_체크카드_현금소비_현금인출_총액(C_TOT_AMT_TOT) | 0.929 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.368 | 0.172 | 1.000 | 0.000 | 0.000 |
| 신용카드_체크카드_건수(C_CARDSUM_AMT_N) | 0.000 | 0.000 | 0.000 | 0.516 | 0.000 | 0.000 | 0.215 | 0.083 | 0.000 | 1.000 | 0.000 |
| 신용카드_체크카드_총액(C_CARDSUM_AMT_TOT) | 0.000 | 0.000 | 0.440 | 0.000 | 0.618 | 0.349 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 |
| 총수신평잔_건수(DEP_TOT_AVJN_N) | 총수신평잔_총액(DEP_TOT_AVJN_TOT) | 유동성급여_가맹점매출_유동성연금_입금_건수(I_TOT_AMT_N) | 유동성급여_가맹점매출_유동성연금_입금총액(I_TOT_AMT_TOT) | 유동성급여_유동성연금_입금_건수(I_PAY_PENS_AMT_N) | 유동성급여_유동성연금_입금_총액(I_PAY_PENS_AMT_TOT) | 신용카드_체크카드_현금소비_현금인출_건수(C_TOT_AMT_N) | 신용카드_체크카드_현금소비_현금인출_총액(C_TOT_AMT_TOT) | 신용카드_체크카드_건수(C_CARDSUM_AMT_N) | 신용카드_체크카드_총액(C_CARDSUM_AMT_TOT) | |
|---|---|---|---|---|---|---|---|---|---|---|
| 총수신평잔_건수(DEP_TOT_AVJN_N) | 1.000 | -0.063 | -0.207 | -0.044 | -0.013 | 0.067 | -0.251 | 0.043 | -0.022 | -0.106 |
| 총수신평잔_총액(DEP_TOT_AVJN_TOT) | -0.063 | 1.000 | 0.053 | -0.038 | -0.140 | 0.006 | 0.090 | -0.010 | 0.011 | -0.141 |
| 유동성급여_가맹점매출_유동성연금_입금_건수(I_TOT_AMT_N) | -0.207 | 0.053 | 1.000 | 0.137 | 0.030 | -0.059 | 0.184 | -0.105 | -0.002 | -0.238 |
| 유동성급여_가맹점매출_유동성연금_입금총액(I_TOT_AMT_TOT) | -0.044 | -0.038 | 0.137 | 1.000 | -0.105 | 0.128 | -0.089 | -0.047 | -0.120 | 0.024 |
| 유동성급여_유동성연금_입금_건수(I_PAY_PENS_AMT_N) | -0.013 | -0.140 | 0.030 | -0.105 | 1.000 | 0.085 | 0.057 | -0.014 | 0.161 | -0.050 |
| 유동성급여_유동성연금_입금_총액(I_PAY_PENS_AMT_TOT) | 0.067 | 0.006 | -0.059 | 0.128 | 0.085 | 1.000 | 0.014 | -0.048 | 0.158 | -0.115 |
| 신용카드_체크카드_현금소비_현금인출_건수(C_TOT_AMT_N) | -0.251 | 0.090 | 0.184 | -0.089 | 0.057 | 0.014 | 1.000 | 0.199 | 0.088 | -0.144 |
| 신용카드_체크카드_현금소비_현금인출_총액(C_TOT_AMT_TOT) | 0.043 | -0.010 | -0.105 | -0.047 | -0.014 | -0.048 | 0.199 | 1.000 | -0.016 | 0.040 |
| 신용카드_체크카드_건수(C_CARDSUM_AMT_N) | -0.022 | 0.011 | -0.002 | -0.120 | 0.161 | 0.158 | 0.088 | -0.016 | 1.000 | 0.173 |
| 신용카드_체크카드_총액(C_CARDSUM_AMT_TOT) | -0.106 | -0.141 | -0.238 | 0.024 | -0.050 | -0.115 | -0.144 | 0.040 | 0.173 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| 그리드코드(GRID50_ID) | 총수신평잔_건수(DEP_TOT_AVJN_N) | 총수신평잔_총액(DEP_TOT_AVJN_TOT) | 유동성급여_가맹점매출_유동성연금_입금_건수(I_TOT_AMT_N) | 유동성급여_가맹점매출_유동성연금_입금총액(I_TOT_AMT_TOT) | 유동성급여_유동성연금_입금_건수(I_PAY_PENS_AMT_N) | 유동성급여_유동성연금_입금_총액(I_PAY_PENS_AMT_TOT) | 신용카드_체크카드_현금소비_현금인출_건수(C_TOT_AMT_N) | 신용카드_체크카드_현금소비_현금인출_총액(C_TOT_AMT_TOT) | 신용카드_체크카드_건수(C_CARDSUM_AMT_N) | 신용카드_체크카드_총액(C_CARDSUM_AMT_TOT) | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | G*0*2*8*3* | 963 | 259583140.088 | 66 | 312663329.993 | 619 | 67185168.004 | 320 | 34272752.0015 | 172 | 165059946.0066 |
| 1 | G*0*0*3*0* | 237 | 747144431.54 | 0 | 203387746.006 | 69 | 0.0 | 786 | 2247778352.0 | 464 | 1099828153.0 |
| 2 | G*0*1*7*6* | 191 | 2970120422.128 | 352 | 322823101.998 | 174 | 464152276.991 | 471 | 271516023.007 | 2545 | 123753060.9992 |
| 3 | G*0*0*9*2* | 2224 | 3046520777.702 | 147 | 1431500736.99 | 0 | 583060679.003 | 360 | 96885182.004 | 406 | 264846240.9938 |
| 4 | G*0*1*6*5* | 2203 | 1893509167.627 | 242 | 522449947.025 | 134 | 384361581.026 | 74 | 0.0 | 0 | 130854773.9978 |
| 5 | G*0*0*6*7* | 470 | 2095754911.644 | 158 | 54796231.998 | 116 | 60261221.997 | 50 | 175513489.001 | 1821 | 621686349.9005 |
| 6 | G*0*1*5*8* | 297 | 572097387.537 | 146 | 3032535517.959 | 0 | 0.0 | 213 | 561387576.989 | 157 | 1244308586.0 |
| 7 | G*0*2*7*5* | 1112 | 2658757561.619 | 0 | 344487324.99 | 0 | 429593649.011 | 177 | 190838011.982 | 0 | 0.0 |
| 8 | G*0*1*3*4* | 74 | 642621812.8452 | 169 | 581467962.019 | 0 | 763844579.984 | 0 | 480478687.03 | 103 | 317330819.9828 |
| 9 | G*0*1*2*4* | 1586 | 1726126589.414 | 0 | 236207070.0186 | 156 | 701734211.028 | 125 | 979046541.0 | 90 | 120424029.001 |
| 그리드코드(GRID50_ID) | 총수신평잔_건수(DEP_TOT_AVJN_N) | 총수신평잔_총액(DEP_TOT_AVJN_TOT) | 유동성급여_가맹점매출_유동성연금_입금_건수(I_TOT_AMT_N) | 유동성급여_가맹점매출_유동성연금_입금총액(I_TOT_AMT_TOT) | 유동성급여_유동성연금_입금_건수(I_PAY_PENS_AMT_N) | 유동성급여_유동성연금_입금_총액(I_PAY_PENS_AMT_TOT) | 신용카드_체크카드_현금소비_현금인출_건수(C_TOT_AMT_N) | 신용카드_체크카드_현금소비_현금인출_총액(C_TOT_AMT_TOT) | 신용카드_체크카드_건수(C_CARDSUM_AMT_N) | 신용카드_체크카드_총액(C_CARDSUM_AMT_TOT) | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 90 | G*0*0*2*0* | 2895 | 4620872282.279 | 54 | 505528967.001 | 0 | 232118251.009 | 0 | 153010018.0074 | 124 | 18525621.0021 |
| 91 | G*0*1*9*6* | 271 | 2028792642.845 | 49 | 328862708.993 | 125 | 257997784.999 | 383 | 268324606.0 | 932 | 110892100.01 |
| 92 | G*0*0*4*9* | 971 | 6761404239.261 | 0 | 232765285.0142 | 22 | 248725151.0 | 287 | 228225370.0113 | 224 | 295740225.005 |
| 93 | G*0*1*0*7* | 1765 | 312512019.12 | 159 | 539752420.988 | 468 | 170111726.003 | 358 | 594505099.0331 | 180 | 814833179.9934 |
| 94 | G*0*0*3*0* | 623 | 22225139792.632999 | 437 | 343375403.995 | 115 | 0.0 | 809 | 323611425.011 | 30 | 69411412.9958 |
| 95 | G*0*2*1*0* | 859 | 3878744904.05 | 439 | 1867543322.053 | 178 | 108861122.002 | 1015 | 716083240.925 | 1398 | 341210757.0 |
| 96 | G*0*0*1*9* | 1087 | 9228342471.382999 | 6 | 259977830.001 | 0 | 154233580.0002 | 117 | 476671460.0 | 106 | 1044211098.911 |
| 97 | G*0*1*4*9* | 631 | 56456812.28 | 0 | 905633744.999 | 0 | 127790790.002 | 135 | 919978143.983 | 275 | 345381209.026 |
| 98 | G*0*2*8*3* | 1201 | 4930475505.517 | 27 | 149869025.9901 | 0 | 17884736.001 | 77 | 1142348291.012 | 211 | 251801764.9895 |
| 99 | G*0*0*2*2* | 677 | 2864999496.805 | 308 | 0.0 | 278 | 827257204.008 | 556 | 306531187.0232 | 387 | 0.0 |