Overview

Dataset statistics

Number of variables5
Number of observations39
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.8 KiB
Average record size in memory47.4 B

Variable types

DateTime1
Numeric4

Dataset

Description통영시 지역사랑삼품권인 통영사랑상품권에 대한 이용연월, 지류상품권판매금액, 지류상품권회수금액 등에 대한 정보를 제공합니다
Author경상남도 통영시
URLhttps://www.data.go.kr/data/15079693/fileData.do

Alerts

지류상품권판매금액 is highly overall correlated with 지류상품권회수금액 and 1 other fieldsHigh correlation
지류상품권회수금액 is highly overall correlated with 지류상품권판매금액 and 1 other fieldsHigh correlation
모바일충전금액 is highly overall correlated with 모바일사용금액High correlation
모바일사용금액 is highly overall correlated with 지류상품권판매금액 and 2 other fieldsHigh correlation
이용연월 has unique valuesUnique
지류상품권판매금액 has unique valuesUnique
지류상품권회수금액 has unique valuesUnique
모바일사용금액 has unique valuesUnique
지류상품권판매금액 has 1 (2.6%) zerosZeros
모바일충전금액 has 3 (7.7%) zerosZeros

Reproduction

Analysis started2024-04-21 01:52:27.594102
Analysis finished2024-04-21 01:52:31.053774
Duration3.46 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

이용연월
Date

UNIQUE 

Distinct39
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size444.0 B
Minimum2021-01-21 00:00:00
Maximum2024-03-21 00:00:00
2024-04-21T10:52:31.120647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:52:31.243577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=39)

지류상품권판매금액
Real number (ℝ)

HIGH CORRELATION  UNIQUE  ZEROS 

Distinct39
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.5563888 × 109
Minimum0
Maximum4.297076 × 109
Zeros1
Zeros (%)2.6%
Negative0
Negative (%)0.0%
Memory size483.0 B
2024-04-21T10:52:31.367415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile27861200
Q16.77815 × 108
median1.22726 × 109
Q32.1377865 × 109
95-th percentile4.0755998 × 109
Maximum4.297076 × 109
Range4.297076 × 109
Interquartile range (IQR)1.4599715 × 109

Descriptive statistics

Standard deviation1.2137334 × 109
Coefficient of variation (CV)0.77983945
Kurtosis-0.11095042
Mean1.5563888 × 109
Median Absolute Deviation (MAD)8.63243 × 108
Skewness0.75994096
Sum6.0699165 × 1010
Variance1.4731488 × 1018
MonotonicityNot monotonic
2024-04-21T10:52:31.489589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=39)
ValueCountFrequency (%)
2090503000 1
 
2.6%
4221938000 1
 
2.6%
29302000 1
 
2.6%
28770000 1
 
2.6%
1841860000 1
 
2.6%
821709000 1
 
2.6%
337730000 1
 
2.6%
1597260000 1
 
2.6%
673480000 1
 
2.6%
1226660000 1
 
2.6%
Other values (29) 29
74.4%
ValueCountFrequency (%)
0 1
2.6%
19682000 1
2.6%
28770000 1
2.6%
29302000 1
2.6%
221510000 1
2.6%
233980000 1
2.6%
337730000 1
2.6%
352676000 1
2.6%
652200000 1
2.6%
673480000 1
2.6%
ValueCountFrequency (%)
4297076000 1
2.6%
4221938000 1
2.6%
4059340000 1
2.6%
3869003000 1
2.6%
2952257000 1
2.6%
2876796000 1
2.6%
2744150000 1
2.6%
2359255000 1
2.6%
2325820000 1
2.6%
2155440000 1
2.6%

지류상품권회수금액
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct39
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.5749811 × 109
Minimum2.98718 × 108
Maximum3.718218 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size483.0 B
2024-04-21T10:52:31.660246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.98718 × 108
5-th percentile4.857057 × 108
Q17.992115 × 108
median1.059005 × 109
Q32.540783 × 109
95-th percentile3.395332 × 109
Maximum3.718218 × 109
Range3.4195 × 109
Interquartile range (IQR)1.7415715 × 109

Descriptive statistics

Standard deviation1.0147043 × 109
Coefficient of variation (CV)0.64426442
Kurtosis-1.112773
Mean1.5749811 × 109
Median Absolute Deviation (MAD)5.10867 × 108
Skewness0.58989451
Sum6.1424262 × 1010
Variance1.0296247 × 1018
MonotonicityNot monotonic
2024-04-21T10:52:31.852090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=39)
ValueCountFrequency (%)
2237105000 1
 
2.6%
3425095000 1
 
2.6%
428355000 1
 
2.6%
298718000 1
 
2.6%
670344000 1
 
2.6%
1001784000 1
 
2.6%
815168000 1
 
2.6%
966148000 1
 
2.6%
1033759000 1
 
2.6%
591746000 1
 
2.6%
Other values (29) 29
74.4%
ValueCountFrequency (%)
298718000 1
2.6%
428355000 1
2.6%
492078000 1
2.6%
548138000 1
2.6%
557987000 1
2.6%
561568000 1
2.6%
591746000 1
2.6%
670344000 1
2.6%
781299000 1
2.6%
794622000 1
2.6%
ValueCountFrequency (%)
3718218000 1
2.6%
3425095000 1
2.6%
3392025000 1
2.6%
2976079000 1
2.6%
2830231000 1
2.6%
2812815000 1
2.6%
2741022000 1
2.6%
2693557000 1
2.6%
2616918000 1
2.6%
2578696000 1
2.6%

모바일충전금액
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct28
Distinct (%)71.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.6008053 × 109
Minimum0
Maximum5.909138 × 109
Zeros3
Zeros (%)7.7%
Negative0
Negative (%)0.0%
Memory size483.0 B
2024-04-21T10:52:32.002461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q19.360205 × 108
median1.5 × 109
Q32.031587 × 109
95-th percentile3.5 × 109
Maximum5.909138 × 109
Range5.909138 × 109
Interquartile range (IQR)1.0955665 × 109

Descriptive statistics

Standard deviation1.1731168 × 109
Coefficient of variation (CV)0.73282919
Kurtosis3.5118305
Mean1.6008053 × 109
Median Absolute Deviation (MAD)5.63174 × 108
Skewness1.3994357
Sum6.2431406 × 1010
Variance1.3762031 × 1018
MonotonicityNot monotonic
2024-04-21T10:52:32.137923image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=28)
ValueCountFrequency (%)
1500000000 8
20.5%
0 3
 
7.7%
2000000000 2
 
5.1%
3500000000 2
 
5.1%
307459000 1
 
2.6%
3074662000 1
 
2.6%
2448776000 1
 
2.6%
3000000000 1
 
2.6%
2500000000 1
 
2.6%
998398000 1
 
2.6%
Other values (18) 18
46.2%
ValueCountFrequency (%)
0 3
7.7%
307459000 1
 
2.6%
373078000 1
 
2.6%
375139000 1
 
2.6%
447437000 1
 
2.6%
567038000 1
 
2.6%
674486500 1
 
2.6%
873643000 1
 
2.6%
998398000 1
 
2.6%
1000000000 1
 
2.6%
ValueCountFrequency (%)
5909138000 1
2.6%
3500000000 2
5.1%
3074662000 1
2.6%
3000000000 1
2.6%
2936746000 1
2.6%
2500000000 1
2.6%
2499000000 1
2.6%
2448776000 1
2.6%
2063174000 1
2.6%
2000000000 2
5.1%

모바일사용금액
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct39
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.5118286 × 109
Minimum92678992
Maximum3.499511 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size483.0 B
2024-04-21T10:52:32.308317image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum92678992
5-th percentile2.4859641 × 108
Q18.740215 × 108
median1.600712 × 109
Q31.9750315 × 109
95-th percentile2.5891374 × 109
Maximum3.499511 × 109
Range3.406832 × 109
Interquartile range (IQR)1.10101 × 109

Descriptive statistics

Standard deviation8.1271456 × 108
Coefficient of variation (CV)0.53757056
Kurtosis-0.013546181
Mean1.5118286 × 109
Median Absolute Deviation (MAD)4.21195 × 108
Skewness0.02198722
Sum5.8961317 × 1010
Variance6.6050496 × 1017
MonotonicityNot monotonic
2024-04-21T10:52:32.644136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=39)
ValueCountFrequency (%)
279971840 1
 
2.6%
260998645 1
 
2.6%
2324503000 1
 
2.6%
1770012000 1
 
2.6%
2518749000 1
 
2.6%
2063098000 1
 
2.6%
1953674000 1
 
2.6%
1724011000 1
 
2.6%
1683590000 1
 
2.6%
1561878000 1
 
2.6%
Other values (29) 29
74.4%
ValueCountFrequency (%)
92678992 1
2.6%
136976260 1
2.6%
260998645 1
2.6%
279971840 1
2.6%
327571000 1
2.6%
406637000 1
2.6%
429748000 1
2.6%
536702000 1
2.6%
621869000 1
2.6%
777907000 1
2.6%
ValueCountFrequency (%)
3499511000 1
2.6%
3222633000 1
2.6%
2518749000 1
2.6%
2356997000 1
2.6%
2324503000 1
2.6%
2124154000 1
2.6%
2063098000 1
2.6%
2050248000 1
2.6%
2021907000 1
2.6%
1979770000 1
2.6%

Interactions

2024-04-21T10:52:30.476053image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:52:29.154137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:52:29.745975image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:52:30.105577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:52:30.571045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:52:29.313258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:52:29.827558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:52:30.188776image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:52:30.682749image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:52:29.559118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:52:29.924055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:52:30.288252image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:52:30.781225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:52:29.656878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:52:30.016154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:52:30.379679image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-21T10:52:32.733073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
이용연월지류상품권판매금액지류상품권회수금액모바일충전금액모바일사용금액
이용연월1.0001.0001.0001.0001.000
지류상품권판매금액1.0001.0000.8460.5790.588
지류상품권회수금액1.0000.8461.0000.6670.553
모바일충전금액1.0000.5790.6671.0000.728
모바일사용금액1.0000.5880.5530.7281.000
2024-04-21T10:52:32.826535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지류상품권판매금액지류상품권회수금액모바일충전금액모바일사용금액
지류상품권판매금액1.0000.852-0.403-0.623
지류상품권회수금액0.8521.000-0.439-0.585
모바일충전금액-0.403-0.4391.0000.868
모바일사용금액-0.623-0.5850.8681.000

Missing values

2024-04-21T10:52:30.903578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T10:52:31.009484image/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

이용연월지류상품권판매금액지류상품권회수금액모바일충전금액모바일사용금액
02021-01-2120905030002237105000307459000279971840
12021-02-2142219380003425095000373078000260998645
22021-03-2140593400003392025000375139000327571000
32021-04-2119998310002693557000447437000406637000
42021-05-2121201330002616918000567038000536702000
52021-06-2123258200002502870000674486500621869000
62021-07-2121554400002282632000873643000777907000
72021-08-21235925500024849300001046642260970136000
82021-09-212876796000274102200013349870001374709000
92021-10-21274415000025786960000429748000
이용연월지류상품권판매금액지류상품권회수금액모바일충전금액모바일사용금액
292023-06-21122666000059174600015068720001561878000
302023-07-21122726000078129900014931280001454075000
312023-08-2165220000080380100015000000001510988000
322023-09-21144676000097051100035000000001925638000
332023-10-21787510000105900500015000000002124154000
342023-11-2168215000082464900010016020001548114000
352023-12-212339800005481380009983980001408888000
362024-01-2171328000056156800025000000001979770000
372024-02-2197538000080572500030000000002050248000
382024-03-2122151000055798700024487760002356997000