Overview

Dataset statistics

Number of variables5
Number of observations24
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.1 KiB
Average record size in memory48.5 B

Variable types

DateTime1
Numeric3
Categorical1

Dataset

Description경기도_김포시_지역화폐발행및이용현황입니다.(기준년월, 모바일상품권이용등록자수, 모바일충전액, 모바일사용액)
URLhttps://www.data.go.kr/data/15038101/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
월별 모바일충전액(원) is highly overall correlated with 월별 모바일사용액(원) High correlation
월별 모바일사용액(원) is highly overall correlated with 월별 모바일충전액(원) High correlation
월별 모바일충전액(원) has unique valuesUnique
월별 모바일사용액(원) has unique valuesUnique

Reproduction

Analysis started2023-12-11 23:13:11.500795
Analysis finished2023-12-11 23:13:12.386452
Duration0.89 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기준년월
Date

Distinct12
Distinct (%)50.0%
Missing0
Missing (%)0.0%
Memory size324.0 B
Minimum2023-01-01 00:00:00
Maximum2023-12-01 00:00:00
2023-12-12T08:13:12.423110image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:13:12.548837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)

월별 모바일상품권 이용 회원수(명)
Real number (ℝ)

Distinct23
Distinct (%)95.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean229317.96
Minimum128369
Maximum316529
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2023-12-12T08:13:12.675317image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum128369
5-th percentile155783.35
Q1185535
median202026
Q3288598
95-th percentile311298.9
Maximum316529
Range188160
Interquartile range (IQR)103063

Descriptive statistics

Standard deviation59157.125
Coefficient of variation (CV)0.25796988
Kurtosis-1.512771
Mean229317.96
Median Absolute Deviation (MAD)42214.5
Skewness0.16648393
Sum5503631
Variance3.4995655 × 109
MonotonicityNot monotonic
2023-12-12T08:13:12.787113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%)
202026 2
 
8.3%
267991 1
 
4.2%
277457 1
 
4.2%
201161 1
 
4.2%
202075 1
 
4.2%
199789 1
 
4.2%
196538 1
 
4.2%
193293 1
 
4.2%
187043 1
 
4.2%
181011 1
 
4.2%
Other values (13) 13
54.2%
ValueCountFrequency (%)
128369 1
4.2%
154057 1
4.2%
165566 1
4.2%
171872 1
4.2%
177636 1
4.2%
181011 1
4.2%
187043 1
4.2%
193293 1
4.2%
196538 1
4.2%
199789 1
4.2%
ValueCountFrequency (%)
316529 1
4.2%
312042 1
4.2%
307088 1
4.2%
301759 1
4.2%
297139 1
4.2%
291913 1
4.2%
287493 1
4.2%
281758 1
4.2%
277457 1
4.2%
267991 1
4.2%

월별 모바일충전액(원)
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct24
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.3753561 × 1010
Minimum1.0570214 × 1010
Maximum3.7645045 × 1010
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2023-12-12T08:13:12.902130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.0570214 × 1010
5-th percentile1.0718293 × 1010
Q11.4629517 × 1010
median2.514835 × 1010
Q33.0459636 × 1010
95-th percentile3.7121918 × 1010
Maximum3.7645045 × 1010
Range2.7074831 × 1010
Interquartile range (IQR)1.5830119 × 1010

Descriptive statistics

Standard deviation9.0932008 × 109
Coefficient of variation (CV)0.38281422
Kurtosis-1.3112428
Mean2.3753561 × 1010
Median Absolute Deviation (MAD)6.5354073 × 109
Skewness-0.13595779
Sum5.7008546 × 1011
Variance8.2686301 × 1019
MonotonicityNot monotonic
2023-12-12T08:13:13.017804image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
27763743680 1
 
4.2%
37152821000 1
 
4.2%
11563750203 1
 
4.2%
10570214268 1
 
4.2%
12333023794 1
 
4.2%
13871105789 1
 
4.2%
11448382327 1
 
4.2%
10589453776 1
 
4.2%
14882320094 1
 
4.2%
36946802510 1
 
4.2%
Other values (14) 14
58.3%
ValueCountFrequency (%)
10570214268 1
4.2%
10589453776 1
4.2%
11448382327 1
4.2%
11563750203 1
4.2%
12333023794 1
4.2%
13871105789 1
4.2%
14882320094 1
4.2%
16349002680 1
4.2%
20700778274 1
4.2%
22901630000 1
4.2%
ValueCountFrequency (%)
37645045020 1
4.2%
37152821000 1
4.2%
36946802510 1
4.2%
31684958290 1
4.2%
31682556320 1
4.2%
31325107461 1
4.2%
30171145000 1
4.2%
30032257760 1
4.2%
29895693390 1
4.2%
27763743680 1
4.2%

월별 모바일사용액(원)
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct24
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.3995593 × 1010
Minimum1.1425935 × 1010
Maximum3.3034471 × 1010
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size348.0 B
2023-12-12T08:13:13.133828image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.1425935 × 1010
5-th percentile1.172065 × 1010
Q12.0149323 × 1010
median2.6068501 × 1010
Q32.8901538 × 1010
95-th percentile3.170031 × 1010
Maximum3.3034471 × 1010
Range2.1608535 × 1010
Interquartile range (IQR)8.7522149 × 109

Descriptive statistics

Standard deviation7.0141238 × 109
Coefficient of variation (CV)0.29230883
Kurtosis-0.80352496
Mean2.3995593 × 1010
Median Absolute Deviation (MAD)3.623418 × 109
Skewness-0.79137995
Sum5.7589423 × 1011
Variance4.9197932 × 1019
MonotonicityNot monotonic
2023-12-12T08:13:13.269255image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
25780690537 1
 
4.2%
28778553000 1
 
4.2%
11425935185 1
 
4.2%
11507812703 1
 
4.2%
13151232958 1
 
4.2%
12926729000 1
 
4.2%
13783849000 1
 
4.2%
15272442000 1
 
4.2%
21774950000 1
 
4.2%
28198297000 1
 
4.2%
Other values (14) 14
58.3%
ValueCountFrequency (%)
11425935185 1
4.2%
11507812703 1
4.2%
12926729000 1
4.2%
13151232958 1
4.2%
13783849000 1
4.2%
15272442000 1
4.2%
21774950000 1
4.2%
23479877065 1
4.2%
23848936000 1
4.2%
25460297000 1
4.2%
ValueCountFrequency (%)
33034470581 1
4.2%
31838346099 1
4.2%
30918104722 1
4.2%
30250562798 1
4.2%
30113344611 1
4.2%
29270492670 1
4.2%
28778553000 1
4.2%
28198297000 1
4.2%
28104562545 1
4.2%
28087166934 1
4.2%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size324.0 B
2023-08-16
24 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-08-16
2nd row2023-08-16
3rd row2023-08-16
4th row2023-08-16
5th row2023-08-16

Common Values

ValueCountFrequency (%)
2023-08-16 24
100.0%

Length

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

Common Values (Plot)

2023-12-12T08:13:13.475023image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-08-16 24
100.0%

Interactions

2023-12-12T08:13:12.045336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:13:11.584009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:13:11.813714image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:13:12.126095image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:13:11.670945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:13:11.897156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:13:12.189051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:13:11.743673image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:13:11.968671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T08:13:13.526021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준년월월별 모바일상품권 이용 회원수(명)월별 모바일충전액(원)월별 모바일사용액(원)
기준년월1.0000.0000.4410.201
월별 모바일상품권 이용 회원수(명)0.0001.0000.7020.389
월별 모바일충전액(원)0.4410.7021.0000.658
월별 모바일사용액(원)0.2010.3890.6581.000
2023-12-12T08:13:13.608438image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
월별 모바일상품권 이용 회원수(명)월별 모바일충전액(원)월별 모바일사용액(원)
월별 모바일상품권 이용 회원수(명)1.0000.2380.417
월별 모바일충전액(원)0.2381.0000.876
월별 모바일사용액(원)0.4170.8761.000

Missing values

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

기준년월월별 모바일상품권 이용 회원수(명)월별 모바일충전액(원)월별 모바일사용액(원)데이터기준일자
02023-0826799127763743680257806905372023-08-16
12023-0927745737645045020309181047222023-08-16
22023-1028175816349002680234798770652023-08-16
32023-1128749331682556320281045625452023-08-16
42023-1229191330032257760301133446112023-08-16
52023-0129713927102838630292704926702023-08-16
62023-0230175926467860000263563107772023-08-16
72023-0330708829895693390302505627982023-08-16
82023-0431204231325107461318383460992023-08-16
92023-0531652931684958290330344705812023-08-16
기준년월월별 모바일상품권 이용 회원수(명)월별 모바일충전액(원)월별 모바일사용액(원)데이터기준일자
142023-1017763623176128000269788340002023-08-16
152023-1118101120700778274238489360002023-08-16
162023-1218704336946802510281982970002023-08-16
172023-0119329314882320094217749500002023-08-16
182023-0219653810589453776152724420002023-08-16
192023-0319978911448382327137838490002023-08-16
202023-0420207513871105789129267290002023-08-16
212023-0520202612333023794131512329582023-08-16
222023-0620202610570214268115078127032023-08-16
232023-0720116111563750203114259351852023-08-16