Overview

Dataset statistics

Number of variables8
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.1 KiB
Average record size in memory72.4 B

Variable types

Numeric4
Categorical3
DateTime1

Dataset

Description샘플 데이터
Author경기도경제과학진흥원
URLhttps://bigdata-region.kr/#/dataset/0f11d6b2-e35e-4323-8700-36e6c77f9d82

Alerts

시도명 has constant value ""Constant
시군구명 has constant value ""Constant
분석인덱스 is highly overall correlated with 행정동명High correlation
결제금액 is highly overall correlated with 전월결제금액High correlation
전월결제금액 is highly overall correlated with 결제금액High correlation
행정동명 is highly overall correlated with 분석인덱스High correlation
분석인덱스 has unique valuesUnique
결제금액 has unique valuesUnique
분석인덱스 has 1 (3.3%) zerosZeros
결제변화비율 has 4 (13.3%) zerosZeros

Reproduction

Analysis started2023-12-10 14:03:03.003869
Analysis finished2023-12-10 14:03:05.958939
Duration2.96 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

분석인덱스
Real number (ℝ)

HIGH CORRELATION  UNIQUE  ZEROS 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14.5
Minimum0
Maximum29
Zeros1
Zeros (%)3.3%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:03:06.067143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1.45
Q17.25
median14.5
Q321.75
95-th percentile27.55
Maximum29
Range29
Interquartile range (IQR)14.5

Descriptive statistics

Standard deviation8.8034084
Coefficient of variation (CV)0.60713162
Kurtosis-1.2
Mean14.5
Median Absolute Deviation (MAD)7.5
Skewness0
Sum435
Variance77.5
MonotonicityStrictly increasing
2023-12-10T23:03:06.269366image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
0 1
 
3.3%
16 1
 
3.3%
29 1
 
3.3%
28 1
 
3.3%
27 1
 
3.3%
26 1
 
3.3%
25 1
 
3.3%
24 1
 
3.3%
23 1
 
3.3%
22 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
0 1
3.3%
1 1
3.3%
2 1
3.3%
3 1
3.3%
4 1
3.3%
5 1
3.3%
6 1
3.3%
7 1
3.3%
8 1
3.3%
9 1
3.3%
ValueCountFrequency (%)
29 1
3.3%
28 1
3.3%
27 1
3.3%
26 1
3.3%
25 1
3.3%
24 1
3.3%
23 1
3.3%
22 1
3.3%
21 1
3.3%
20 1
3.3%

시도명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
경기도
30 

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 (%)
경기도 30
100.0%

Length

2023-12-10T23:03:06.477580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:03:06.627786image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 30
100.0%

시군구명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
가평군
30 

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 (%)
가평군 30
100.0%

Length

2023-12-10T23:03:06.781701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:03:06.934959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가평군 30
100.0%

행정동명
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)13.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
가평읍
9 
북면
8 
상면
8 
설악면
5 

Length

Max length3
Median length2
Mean length2.4666667
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
가평읍 9
30.0%
북면 8
26.7%
상면 8
26.7%
설악면 5
16.7%

Length

2023-12-10T23:03:07.117829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:03:07.340677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가평읍 9
30.0%
북면 8
26.7%
상면 8
26.7%
설악면 5
16.7%

일반결제년월
Date

Distinct9
Distinct (%)30.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2019-09-01 00:00:00
Maximum2020-06-01 00:00:00
2023-12-10T23:03:07.533223image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:07.694902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)

결제금액
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean18548204
Minimum1850
Maximum1.1803364 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:03:07.963013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1850
5-th percentile134664
Q11055220
median2654785
Q34427241.5
95-th percentile86777386
Maximum1.1803364 × 108
Range1.1803179 × 108
Interquartile range (IQR)3372021.5

Descriptive statistics

Standard deviation33613459
Coefficient of variation (CV)1.8122217
Kurtosis2.0675279
Mean18548204
Median Absolute Deviation (MAD)1748452
Skewness1.8323147
Sum5.5644613 × 108
Variance1.1298646 × 1015
MonotonicityNot monotonic
2023-12-10T23:03:08.173603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
19073066 1
 
3.3%
1850 1
 
3.3%
4451246 1
 
3.3%
4355228 1
 
3.3%
3627936 1
 
3.3%
4033890 1
 
3.3%
1054320 1
 
3.3%
180820 1
 
3.3%
2937460 1
 
3.3%
2282720 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
1850 1
3.3%
96900 1
3.3%
180820 1
3.3%
186650 1
3.3%
423100 1
3.3%
536860 1
3.3%
619400 1
3.3%
1054320 1
3.3%
1057920 1
3.3%
1423400 1
3.3%
ValueCountFrequency (%)
118033641 1
3.3%
88133670 1
3.3%
85119706 1
3.3%
77461979 1
3.3%
68118300 1
3.3%
54758044 1
3.3%
19073066 1
3.3%
4451246 1
3.3%
4355228 1
3.3%
4033890 1
3.3%

전월결제금액
Real number (ℝ)

HIGH CORRELATION 

Distinct26
Distinct (%)86.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19093422
Minimum186650
Maximum1.1803364 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:03:08.438953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum186650
5-th percentile423100
Q11055220
median2654785
Q315393606
95-th percentile86777386
Maximum1.1803364 × 108
Range1.1784699 × 108
Interquartile range (IQR)14338386

Descriptive statistics

Standard deviation33474588
Coefficient of variation (CV)1.7532
Kurtosis2.0179029
Mean19093422
Median Absolute Deviation (MAD)1650454
Skewness1.8072964
Sum5.7280266 × 108
Variance1.120548 × 1015
MonotonicityNot monotonic
2023-12-10T23:03:08.624375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%)
19073066 2
 
6.7%
1054320 2
 
6.7%
536860 2
 
6.7%
423100 2
 
6.7%
3489751 1
 
3.3%
4355228 1
 
3.3%
3627936 1
 
3.3%
4033890 1
 
3.3%
2937460 1
 
3.3%
2282720 1
 
3.3%
Other values (16) 16
53.3%
ValueCountFrequency (%)
186650 1
3.3%
423100 2
6.7%
536860 2
6.7%
619400 1
3.3%
1054320 2
6.7%
1057920 1
3.3%
1423400 1
3.3%
1765250 1
3.3%
1940940 1
3.3%
2191140 1
3.3%
ValueCountFrequency (%)
118033641 1
3.3%
88133670 1
3.3%
85119706 1
3.3%
77461979 1
3.3%
68118300 1
3.3%
54758044 1
3.3%
19073066 2
6.7%
4355228 1
3.3%
4033890 1
3.3%
3756196 1
3.3%

결제변화비율
Real number (ℝ)

ZEROS 

Distinct27
Distinct (%)90.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean31.859
Minimum-99.95
Maximum282.61
Zeros4
Zeros (%)13.3%
Negative11
Negative (%)36.7%
Memory size402.0 B
2023-12-10T23:03:08.811315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-99.95
5-th percentile-97.14
Q1-9.8075
median1.1
Q340.7625
95-th percentile259.56
Maximum282.61
Range382.56
Interquartile range (IQR)50.57

Descriptive statistics

Standard deviation96.884809
Coefficient of variation (CV)3.0410499
Kurtosis1.7438459
Mean31.859
Median Absolute Deviation (MAD)25.305
Skewness1.3757239
Sum955.77
Variance9386.6661
MonotonicityNot monotonic
2023-12-10T23:03:09.002277image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
0.0 4
 
13.3%
257.14 1
 
3.3%
2.2 1
 
3.3%
20.05 1
 
3.3%
-10.06 1
 
3.3%
282.61 1
 
3.3%
-93.84 1
 
3.3%
28.68 1
 
3.3%
-3.77 1
 
3.3%
66.65 1
 
3.3%
Other values (17) 17
56.7%
ValueCountFrequency (%)
-99.95 1
3.3%
-99.84 1
3.3%
-93.84 1
3.3%
-48.08 1
3.3%
-41.45 1
3.3%
-21.13 1
3.3%
-19.61 1
3.3%
-10.06 1
3.3%
-9.05 1
3.3%
-3.77 1
3.3%
ValueCountFrequency (%)
282.61 1
3.3%
261.54 1
3.3%
257.14 1
3.3%
150.04 1
3.3%
129.8 1
3.3%
71.43 1
3.3%
66.65 1
3.3%
41.46 1
3.3%
38.67 1
3.3%
28.68 1
3.3%

Interactions

2023-12-10T23:03:04.653193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:03.242575image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:03.686620image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:04.116722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:04.786005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:03.337729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:03.791067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:04.235827image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:05.367460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:03.450756image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:03.890970image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:04.371403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:05.497636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:03.572101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:04.002230image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:03:04.488114image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T23:03:09.132252image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
분석인덱스행정동명일반결제년월결제금액전월결제금액결제변화비율
분석인덱스1.0000.9650.0000.5610.6660.280
행정동명0.9651.0000.0000.2730.5360.000
일반결제년월0.0000.0001.0000.0000.5330.818
결제금액0.5610.2730.0001.0000.9830.000
전월결제금액0.6660.5360.5330.9831.0000.000
결제변화비율0.2800.0000.8180.0000.0001.000
2023-12-10T23:03:09.258909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
분석인덱스결제금액전월결제금액결제변화비율행정동명
분석인덱스1.000-0.305-0.3860.0240.792
결제금액-0.3051.0000.6500.4270.182
전월결제금액-0.3860.6501.000-0.2170.291
결제변화비율0.0240.427-0.2171.0000.000
행정동명0.7920.1820.2910.0001.000

Missing values

2023-12-10T23:03:05.684531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T23:03:05.884278image/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

분석인덱스시도명시군구명행정동명일반결제년월결제금액전월결제금액결제변화비율
00경기도가평군가평읍2019-0919073066190730660.0
11경기도가평군가평읍2019-106811830019073066257.14
22경기도가평군가평읍2019-115475804468118300-19.61
33경기도가평군가평읍2019-12774619795475804441.46
44경기도가평군가평읍2020-01881336707746197913.78
55경기도가평군가평읍2020-028511970688133670-3.42
66경기도가평군가평읍2020-031180336418511970638.67
77경기도가평군가평읍2020-05186650118033641-99.84
88경기도가평군가평읍2020-0696900186650-48.08
99경기도가평군북면2019-095368605368600.0
분석인덱스시도명시군구명행정동명일반결제년월결제금액전월결제금액결제변화비율
2020경기도가평군상면2019-121423400619400129.8
2121경기도가평군상면2020-012372110142340066.65
2222경기도가평군상면2020-0222827202372110-3.77
2323경기도가평군상면2020-032937460228272028.68
2424경기도가평군상면2020-061808202937460-93.84
2525경기도가평군설악면2019-09105432010543200.0
2626경기도가평군설악면2019-1040338901054320282.61
2727경기도가평군설악면2019-1136279364033890-10.06
2828경기도가평군설악면2019-124355228362793620.05
2929경기도가평군설악면2020-01445124643552282.2