Overview

Dataset statistics

Number of variables8
Number of observations49
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.4 KiB
Average record size in memory71.6 B

Variable types

Categorical1
DateTime2
Numeric5

Dataset

Description경기도 평택시 지역 화폐 발행 및 이용 현황입니다.(기준년월, 월별 카드발행수량, 월별 카드충전액, 월별 카드사용액, 월별 지류상품권판매액, 월별 지류상품권회수액 등)※ 문의 : 평택시청 일자리경제과(031-8024-3542)
Author경기도 평택시
URLhttps://www.data.go.kr/data/15039663/fileData.do

Alerts

시군명 has constant value ""Constant
월별 카드충전액(천원) is highly overall correlated with 월별 카드사용액(천원)High correlation
월별 카드사용액(천원) is highly overall correlated with 월별 카드충전액(천원) and 2 other fieldsHigh correlation
월별 지류상품권판매액(천원) is highly overall correlated with 월별 카드사용액(천원) and 1 other fieldsHigh correlation
월별 지류상품권회수액(천원) is highly overall correlated with 월별 카드사용액(천원) and 1 other fieldsHigh correlation
시작일자 has unique valuesUnique
종료일자 has unique valuesUnique
월별 카드발행수량 has unique valuesUnique
월별 카드충전액(천원) has unique valuesUnique
월별 카드사용액(천원) has unique valuesUnique
월별 지류상품권판매액(천원) has unique valuesUnique
월별 지류상품권회수액(천원) has unique valuesUnique

Reproduction

Analysis started2024-03-14 09:49:01.601820
Analysis finished2024-03-14 09:49:06.815887
Duration5.21 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시군명
Categorical

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size520.0 B
평택시
49 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row평택시
2nd row평택시
3rd row평택시
4th row평택시
5th row평택시

Common Values

ValueCountFrequency (%)
평택시 49
100.0%

Length

2024-03-14T18:49:07.017055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T18:49:07.311997image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
평택시 49
100.0%

시작일자
Date

UNIQUE 

Distinct49
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size520.0 B
Minimum2020-01-01 00:00:00
Maximum2024-01-01 00:00:00
2024-03-14T18:49:07.636177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:08.091688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=49)

종료일자
Date

UNIQUE 

Distinct49
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size520.0 B
Minimum2020-01-31 00:00:00
Maximum2024-01-31 00:00:00
2024-03-14T18:49:08.710920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:09.157687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=49)

월별 카드발행수량
Real number (ℝ)

UNIQUE 

Distinct49
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8098.9388
Minimum55
Maximum43823
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size569.0 B
2024-03-14T18:49:09.576070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum55
5-th percentile940
Q13531
median5889
Q38414
95-th percentile26693
Maximum43823
Range43768
Interquartile range (IQR)4883

Descriptive statistics

Standard deviation8335.4183
Coefficient of variation (CV)1.0291988
Kurtosis7.0668969
Mean8098.9388
Median Absolute Deviation (MAD)2525
Skewness2.4613667
Sum396848
Variance69479199
MonotonicityNot monotonic
2024-03-14T18:49:10.001737image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=49)
ValueCountFrequency (%)
256 1
 
2.0%
4355 1
 
2.0%
3532 1
 
2.0%
2892 1
 
2.0%
4693 1
 
2.0%
4351 1
 
2.0%
7054 1
 
2.0%
6259 1
 
2.0%
6519 1
 
2.0%
5068 1
 
2.0%
Other values (39) 39
79.6%
ValueCountFrequency (%)
55 1
2.0%
67 1
2.0%
256 1
2.0%
1966 1
2.0%
2442 1
2.0%
2492 1
2.0%
2535 1
2.0%
2634 1
2.0%
2640 1
2.0%
2892 1
2.0%
ValueCountFrequency (%)
43823 1
2.0%
29088 1
2.0%
28441 1
2.0%
24071 1
2.0%
17949 1
2.0%
15500 1
2.0%
14014 1
2.0%
13822 1
2.0%
13566 1
2.0%
13317 1
2.0%

월별 카드충전액(천원)
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct49
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean10237463
Minimum18000
Maximum25337565
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size569.0 B
2024-03-14T18:49:10.411999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum18000
5-th percentile1070274
Q18733934
median10391575
Q313004797
95-th percentile15580924
Maximum25337565
Range25319565
Interquartile range (IQR)4270863

Descriptive statistics

Standard deviation4727230.2
Coefficient of variation (CV)0.46175797
Kurtosis1.9910916
Mean10237463
Median Absolute Deviation (MAD)2613222
Skewness0.16350779
Sum5.016357 × 108
Variance2.2346705 × 1013
MonotonicityNot monotonic
2024-03-14T18:49:10.870461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=49)
ValueCountFrequency (%)
59712 1
 
2.0%
14544816 1
 
2.0%
10178404 1
 
2.0%
10389595 1
 
2.0%
10185991 1
 
2.0%
10161837 1
 
2.0%
13227497 1
 
2.0%
13004797 1
 
2.0%
13287848 1
 
2.0%
13512613 1
 
2.0%
Other values (39) 39
79.6%
ValueCountFrequency (%)
18000 1
2.0%
23760 1
2.0%
59712 1
2.0%
2586117 1
2.0%
2857550 1
2.0%
4603556 1
2.0%
5099945 1
2.0%
6133641 1
2.0%
6531356 1
2.0%
6897027 1
2.0%
ValueCountFrequency (%)
25337565 1
2.0%
21028644 1
2.0%
16271663 1
2.0%
14544816 1
2.0%
14407555 1
2.0%
13681523 1
2.0%
13561730 1
2.0%
13512613 1
2.0%
13287848 1
2.0%
13258976 1
2.0%

월별 카드사용액(천원)
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct49
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean9474295.8
Minimum130667
Maximum20169763
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size569.0 B
2024-03-14T18:49:11.300712image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum130667
5-th percentile532690.2
Q17283404
median10502529
Q312180674
95-th percentile14134630
Maximum20169763
Range20039096
Interquartile range (IQR)4897270

Descriptive statistics

Standard deviation4474477.4
Coefficient of variation (CV)0.47227546
Kurtosis0.19014484
Mean9474295.8
Median Absolute Deviation (MAD)1833182
Skewness-0.59073167
Sum4.642405 × 108
Variance2.0020948 × 1013
MonotonicityNot monotonic
2024-03-14T18:49:11.769196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=49)
ValueCountFrequency (%)
502911 1
 
2.0%
11827582 1
 
2.0%
10502529 1
 
2.0%
10560533 1
 
2.0%
10070306 1
 
2.0%
9989323 1
 
2.0%
11749772 1
 
2.0%
12785839 1
 
2.0%
13397577 1
 
2.0%
13325050 1
 
2.0%
Other values (39) 39
79.6%
ValueCountFrequency (%)
130667 1
2.0%
203131 1
2.0%
502911 1
2.0%
577359 1
2.0%
1768949 1
2.0%
1834371 1
2.0%
2905083 1
2.0%
3150905 1
2.0%
4846441 1
2.0%
5954365 1
2.0%
ValueCountFrequency (%)
20169763 1
2.0%
16900861 1
2.0%
14403063 1
2.0%
13731981 1
2.0%
13397577 1
2.0%
13325050 1
2.0%
13104253 1
2.0%
12934602 1
2.0%
12914251 1
2.0%
12785839 1
2.0%

월별 지류상품권판매액(천원)
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct49
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2159461.7
Minimum575070
Maximum5808200
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size569.0 B
2024-03-14T18:49:12.213250image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum575070
5-th percentile602500
Q11291625
median1658530
Q33015560
95-th percentile4883997
Maximum5808200
Range5233130
Interquartile range (IQR)1723935

Descriptive statistics

Standard deviation1390476.7
Coefficient of variation (CV)0.6438997
Kurtosis0.15546833
Mean2159461.7
Median Absolute Deviation (MAD)692105
Skewness1.0389834
Sum1.0581362 × 108
Variance1.9334255 × 1012
MonotonicityNot monotonic
2024-03-14T18:49:12.665540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=49)
ValueCountFrequency (%)
3015560 1
 
2.0%
1611900 1
 
2.0%
1600630 1
 
2.0%
1678790 1
 
2.0%
1420435 1
 
2.0%
1387125 1
 
2.0%
2199770 1
 
2.0%
1596290 1
 
2.0%
1155850 1
 
2.0%
1167295 1
 
2.0%
Other values (39) 39
79.6%
ValueCountFrequency (%)
575070 1
2.0%
583360 1
2.0%
602460 1
2.0%
602560 1
2.0%
612060 1
2.0%
639960 1
2.0%
717080 1
2.0%
765315 1
2.0%
904725 1
2.0%
1155850 1
2.0%
ValueCountFrequency (%)
5808200 1
2.0%
5334135 1
2.0%
4953025 1
2.0%
4780455 1
2.0%
4770880 1
2.0%
4137880 1
2.0%
3882065 1
2.0%
3801585 1
2.0%
3658720 1
2.0%
3605750 1
2.0%

월별 지류상품권회수액(천원)
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct49
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2124895.1
Minimum692730
Maximum5101120
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size569.0 B
2024-03-14T18:49:13.094003image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum692730
5-th percentile829479
Q11364645
median1687960
Q32357130
95-th percentile4630240
Maximum5101120
Range4408390
Interquartile range (IQR)992485

Descriptive statistics

Standard deviation1241319.9
Coefficient of variation (CV)0.58417938
Kurtosis0.046895888
Mean2124895.1
Median Absolute Deviation (MAD)483525
Skewness1.1233238
Sum1.0411986 × 108
Variance1.5408751 × 1012
MonotonicityNot monotonic
2024-03-14T18:49:13.520958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=49)
ValueCountFrequency (%)
1805115 1
 
2.0%
1298350 1
 
2.0%
1586845 1
 
2.0%
1459055 1
 
2.0%
1486200 1
 
2.0%
1365110 1
 
2.0%
1560995 1
 
2.0%
2013185 1
 
2.0%
1390945 1
 
2.0%
1364645 1
 
2.0%
Other values (39) 39
79.6%
ValueCountFrequency (%)
692730 1
2.0%
802850 1
2.0%
806225 1
2.0%
864360 1
2.0%
872050 1
2.0%
914195 1
2.0%
935360 1
2.0%
1034285 1
2.0%
1053955 1
2.0%
1079065 1
2.0%
ValueCountFrequency (%)
5101120 1
2.0%
4683160 1
2.0%
4639920 1
2.0%
4615720 1
2.0%
4492495 1
2.0%
4446415 1
2.0%
4129395 1
2.0%
3990520 1
2.0%
3813405 1
2.0%
3310620 1
2.0%

Interactions

2024-03-14T18:49:05.328682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:01.839902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:02.895102image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:03.647758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:04.505313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:05.460541image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:02.070645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:03.030852image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:03.859758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:04.641107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:05.616920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:02.312571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:03.175391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:04.015855image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:04.788977image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:05.778326image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:02.601064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:03.340011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:04.192140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:05.042135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:05.921081image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:02.758691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:03.487773image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:04.350594image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T18:49:05.184689image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T18:49:13.782207image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시작일자종료일자월별 카드발행수량월별 카드충전액(천원)월별 카드사용액(천원)월별 지류상품권판매액(천원)월별 지류상품권회수액(천원)
시작일자1.0001.0001.0001.0001.0001.0001.000
종료일자1.0001.0001.0001.0001.0001.0001.000
월별 카드발행수량1.0001.0001.0000.6770.5070.6300.431
월별 카드충전액(천원)1.0001.0000.6771.0000.9020.8610.693
월별 카드사용액(천원)1.0001.0000.5070.9021.0000.6490.594
월별 지류상품권판매액(천원)1.0001.0000.6300.8610.6491.0000.875
월별 지류상품권회수액(천원)1.0001.0000.4310.6930.5940.8751.000
2024-03-14T18:49:14.079285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
월별 카드발행수량월별 카드충전액(천원)월별 카드사용액(천원)월별 지류상품권판매액(천원)월별 지류상품권회수액(천원)
월별 카드발행수량1.0000.2600.1480.3220.488
월별 카드충전액(천원)0.2601.0000.837-0.497-0.440
월별 카드사용액(천원)0.1480.8371.000-0.619-0.529
월별 지류상품권판매액(천원)0.322-0.497-0.6191.0000.877
월별 지류상품권회수액(천원)0.488-0.440-0.5290.8771.000

Missing values

2024-03-14T18:49:06.204381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T18:49:06.639854image/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

시군명시작일자종료일자월별 카드발행수량월별 카드충전액(천원)월별 카드사용액(천원)월별 지류상품권판매액(천원)월별 지류상품권회수액(천원)
0평택시2020-01-012020-01-312565971250291130155601805115
1평택시2020-02-012020-02-29672376020313117199601549775
2평택시2020-03-012020-03-31551800013066734449052154005
3평택시2020-04-012020-04-301966258611757735932621001687960
4평택시2020-05-012020-05-312407125337565176894927001302102730
5평택시2020-06-012020-06-3060755099945183437136057503310620
6평택시2020-07-012020-07-3179014603556315090547708803990520
7평택시2020-08-012020-08-3137552857550290508336587205101120
8평택시2020-09-012020-09-30138226133641484644158082004492495
9평택시2020-10-012020-10-3160376531356595436538820654683160
시군명시작일자종료일자월별 카드발행수량월별 카드충전액(천원)월별 카드사용액(천원)월별 지류상품권판매액(천원)월별 지류상품권회수액(천원)
39평택시2023-04-012023-04-304382311597633117927567170801079065
40평택시2023-05-012023-05-31822911962116129142517653151053955
41평택시2023-06-012023-06-3036051171487412180674639960864360
42평택시2023-07-012023-07-3124921121837511703693575070872050
43평택시2023-08-012023-08-3125351039157510606054602560806225
44평택시2023-09-012023-09-303627135617301203201315320901034285
45평택시2023-10-012023-10-3132531236523512181145602460935360
46평택시2023-11-012023-11-3024421154936911454576583360914195
47평택시2023-12-012023-12-3126341182066011588758612060692730
48평택시2024-01-012024-01-31333210590657113355971399010802850