Overview

Dataset statistics

Number of variables5
Number of observations186
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.9 KiB
Average record size in memory43.7 B

Variable types

Categorical1
DateTime1
Numeric3

Dataset

Description지역화폐 발행 및 이용 현황
Author경기도
URLhttps://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=6FEDD6KGEJWYCY2G15OY29527318&infSeq=1

Alerts

월별신규가입자수(명) 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 2 other fieldsHigh correlation
시군명 is highly overall correlated with 월별신규가입자수(명) and 1 other fieldsHigh correlation
월별신규가입자수(명) has 3 (1.6%) zerosZeros

Reproduction

Analysis started2024-03-16 04:40:04.570771
Analysis finished2024-03-16 04:40:08.169856
Duration3.6 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시군명
Categorical

HIGH CORRELATION 

Distinct31
Distinct (%)16.7%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
가평군
 
6
고양시
 
6
과천시
 
6
광명시
 
6
광주시
 
6
Other values (26)
156 

Length

Max length4
Median length3
Mean length3.0967742
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row가평군
2nd row가평군
3rd row가평군
4th row가평군
5th row가평군

Common Values

ValueCountFrequency (%)
가평군 6
 
3.2%
고양시 6
 
3.2%
과천시 6
 
3.2%
광명시 6
 
3.2%
광주시 6
 
3.2%
구리시 6
 
3.2%
군포시 6
 
3.2%
김포시 6
 
3.2%
남양주시 6
 
3.2%
동두천시 6
 
3.2%
Other values (21) 126
67.7%

Length

2024-03-16T04:40:08.399747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
가평군 6
 
3.2%
안양시 6
 
3.2%
하남시 6
 
3.2%
포천시 6
 
3.2%
평택시 6
 
3.2%
파주시 6
 
3.2%
이천시 6
 
3.2%
의정부시 6
 
3.2%
의왕시 6
 
3.2%
용인시 6
 
3.2%
Other values (21) 126
67.7%

기준년월
Date

Distinct6
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Memory size1.6 KiB
Minimum2023-07-01 00:00:00
Maximum2023-12-01 00:00:00
2024-03-16T04:40:08.793570image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T04:40:09.166497image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)

월별신규가입자수(명)
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct180
Distinct (%)96.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2648.0753
Minimum0
Maximum16572
Zeros3
Zeros (%)1.6%
Negative0
Negative (%)0.0%
Memory size1.8 KiB
2024-03-16T04:40:09.572583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile475.75
Q1999.5
median1737.5
Q33496.25
95-th percentile7704.5
Maximum16572
Range16572
Interquartile range (IQR)2496.75

Descriptive statistics

Standard deviation2547.907
Coefficient of variation (CV)0.96217318
Kurtosis9.2855994
Mean2648.0753
Median Absolute Deviation (MAD)963.5
Skewness2.5449725
Sum492542
Variance6491830
MonotonicityNot monotonic
2024-03-16T04:40:10.058043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 3
 
1.6%
1569 3
 
1.6%
1507 2
 
1.1%
1424 2
 
1.1%
1326 1
 
0.5%
597 1
 
0.5%
292 1
 
0.5%
217 1
 
0.5%
469 1
 
0.5%
1007 1
 
0.5%
Other values (170) 170
91.4%
ValueCountFrequency (%)
0 3
1.6%
217 1
 
0.5%
292 1
 
0.5%
434 1
 
0.5%
440 1
 
0.5%
458 1
 
0.5%
469 1
 
0.5%
473 1
 
0.5%
484 1
 
0.5%
519 1
 
0.5%
ValueCountFrequency (%)
16572 1
0.5%
16334 1
0.5%
12549 1
0.5%
9606 1
0.5%
8591 1
0.5%
8148 1
0.5%
8026 1
0.5%
7804 1
0.5%
7792 1
0.5%
7717 1
0.5%

월별충전액(백만원)
Real number (ℝ)

HIGH CORRELATION 

Distinct185
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13184.495
Minimum1811
Maximum60072
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.8 KiB
2024-03-16T04:40:10.525865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1811
5-th percentile2254.75
Q15310
median11224
Q318261.25
95-th percentile34899.25
Maximum60072
Range58261
Interquartile range (IQR)12951.25

Descriptive statistics

Standard deviation10408.938
Coefficient of variation (CV)0.78948328
Kurtosis2.7504048
Mean13184.495
Median Absolute Deviation (MAD)6607
Skewness1.469299
Sum2452316
Variance1.0834599 × 108
MonotonicityNot monotonic
2024-03-16T04:40:11.016994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4133 2
 
1.1%
6043 1
 
0.5%
8141 1
 
0.5%
4672 1
 
0.5%
3142 1
 
0.5%
1819 1
 
0.5%
1965 1
 
0.5%
1824 1
 
0.5%
3173 1
 
0.5%
2050 1
 
0.5%
Other values (175) 175
94.1%
ValueCountFrequency (%)
1811 1
0.5%
1819 1
0.5%
1824 1
0.5%
1965 1
0.5%
2001 1
0.5%
2050 1
0.5%
2100 1
0.5%
2101 1
0.5%
2205 1
0.5%
2252 1
0.5%
ValueCountFrequency (%)
60072 1
0.5%
51549 1
0.5%
42298 1
0.5%
40966 1
0.5%
40559 1
0.5%
40087 1
0.5%
37986 1
0.5%
37117 1
0.5%
36869 1
0.5%
34953 1
0.5%

월별사용액(백만원)
Real number (ℝ)

HIGH CORRELATION 

Distinct185
Distinct (%)99.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12352.575
Minimum1197
Maximum38199
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.8 KiB
2024-03-16T04:40:11.537361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1197
5-th percentile1978.5
Q15097.75
median10288.5
Q318793.25
95-th percentile28653.75
Maximum38199
Range37002
Interquartile range (IQR)13695.5

Descriptive statistics

Standard deviation9132.0594
Coefficient of variation (CV)0.73928385
Kurtosis0.049253509
Mean12352.575
Median Absolute Deviation (MAD)6039
Skewness0.88718983
Sum2297579
Variance83394509
MonotonicityNot monotonic
2024-03-16T04:40:12.001971image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2534 2
 
1.1%
2140 1
 
0.5%
4653 1
 
0.5%
1228 1
 
0.5%
1197 1
 
0.5%
1265 1
 
0.5%
1262 1
 
0.5%
2132 1
 
0.5%
5392 1
 
0.5%
5303 1
 
0.5%
Other values (175) 175
94.1%
ValueCountFrequency (%)
1197 1
0.5%
1228 1
0.5%
1262 1
0.5%
1265 1
0.5%
1701 1
0.5%
1802 1
0.5%
1886 1
0.5%
1956 1
0.5%
1969 1
0.5%
1978 1
0.5%
ValueCountFrequency (%)
38199 1
0.5%
36480 1
0.5%
36191 1
0.5%
36188 1
0.5%
35786 1
0.5%
35008 1
0.5%
34381 1
0.5%
33253 1
0.5%
32898 1
0.5%
28716 1
0.5%

Interactions

2024-03-16T04:40:06.673388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T04:40:04.953887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T04:40:05.817521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T04:40:06.943991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T04:40:05.284497image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T04:40:06.071248image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T04:40:07.218848image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T04:40:05.551378image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-16T04:40:06.390177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-16T04:40:12.284006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군명기준년월월별신규가입자수(명)월별충전액(백만원)월별사용액(백만원)
시군명1.0000.0000.8600.7920.915
기준년월0.0001.0000.0000.0000.000
월별신규가입자수(명)0.8600.0001.0000.7750.777
월별충전액(백만원)0.7920.0000.7751.0000.843
월별사용액(백만원)0.9150.0000.7770.8431.000
2024-03-16T04:40:12.563703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
월별신규가입자수(명)월별충전액(백만원)월별사용액(백만원)시군명
월별신규가입자수(명)1.0000.8890.9070.518
월별충전액(백만원)0.8891.0000.9670.414
월별사용액(백만원)0.9070.9671.0000.594
시군명0.5180.4140.5941.000

Missing values

2024-03-16T04:40:07.677119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-16T04:40:08.020020image/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가평군2023-1248440512140
1가평군2023-1145823682187
2가평군2023-1055525962335
3가평군2023-0978231132376
4가평군2023-0847336312392
5가평군2023-0758026822536
6고양시2023-1231031576812994
7고양시2023-1132471438912450
8고양시2023-1045541349911696
9고양시2023-0942071050011022
시군명기준년월월별신규가입자수(명)월별충전액(백만원)월별사용액(백만원)
176하남시2023-1024561268211979
177하남시2023-0933881299111833
178하남시2023-08240994428931
179하남시2023-072107102319659
180화성시2023-1258541789124971
181화성시2023-1168083495332898
182화성시2023-1076673711738199
183화성시2023-0977924055936188
184화성시2023-0878043411635008
185화성시2023-0780263686936480