Overview

Dataset statistics

Number of variables5
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.3 KiB
Average record size in memory45.4 B

Variable types

Categorical2
Text2
Numeric1

Dataset

Description샘플 데이터
Author경기콘텐츠진흥원
URLhttps://www.bigdata-region.kr/#/dataset/d40c0e0f-d71d-475c-85fc-4d7c3cfe78a4

Alerts

기준년월 has constant value ""Constant
시도명 has constant value ""Constant
시군구명 has unique valuesUnique
사용금액 has unique valuesUnique

Reproduction

Analysis started2023-12-10 13:49:20.816492
Analysis finished2023-12-10 13:49:21.564200
Duration0.75 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기준년월
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
2015-01
30 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2015-01
2nd row2015-01
3rd row2015-01
4th row2015-01
5th row2015-01

Common Values

ValueCountFrequency (%)
2015-01 30
100.0%

Length

2023-12-10T22:49:21.664406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:49:21.832809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2015-01 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-10T22:49:21.973654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

시군구명
Text

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-10T22:49:22.353648image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length7
Mean length5
Min length3

Characters and Unicode

Total characters150
Distinct characters53
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique30 ?
Unique (%)100.0%

Sample

1st row남양주시
2nd row이천시
3rd row성남시 수정구
4th row과천시
5th row안산시 상록구
ValueCountFrequency (%)
수원시 4
 
9.1%
고양시 3
 
6.8%
용인시 3
 
6.8%
성남시 2
 
4.5%
안산시 2
 
4.5%
일산서구 1
 
2.3%
덕양구 1
 
2.3%
일산동구 1
 
2.3%
의정부시 1
 
2.3%
평택시 1
 
2.3%
Other values (25) 25
56.8%
2023-12-10T22:49:22.852495image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
시 28
18.7%
구 15
 
10.0%
14
 
9.3%
수 6
 
4.0%
양 6
 
4.0%
원 5
 
3.3%
산 5
 
3.3%
남 4
 
2.7%
인 4
 
2.7%
천 4
 
2.7%
Other values (43) 59
39.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 136
90.7%
Space Separator 14
 
9.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 28
20.6%
구 15
 
11.0%
수 6
 
4.4%
양 6
 
4.4%
원 5
 
3.7%
산 5
 
3.7%
남 4
 
2.9%
인 4
 
2.9%
천 4
 
2.9%
고 3
 
2.2%
Other values (42) 56
41.2%
Space Separator
ValueCountFrequency (%)
14
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 136
90.7%
Common 14
 
9.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 28
20.6%
구 15
 
11.0%
수 6
 
4.4%
양 6
 
4.4%
원 5
 
3.7%
산 5
 
3.7%
남 4
 
2.9%
인 4
 
2.9%
천 4
 
2.9%
고 3
 
2.2%
Other values (42) 56
41.2%
Common
ValueCountFrequency (%)
14
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 136
90.7%
ASCII 14
 
9.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
시 28
20.6%
구 15
 
11.0%
수 6
 
4.4%
양 6
 
4.4%
원 5
 
3.7%
산 5
 
3.7%
남 4
 
2.9%
인 4
 
2.9%
천 4
 
2.9%
고 3
 
2.2%
Other values (42) 56
41.2%
ASCII
ValueCountFrequency (%)
14
100.0%

국적명
Text

Distinct23
Distinct (%)76.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-10T22:49:23.129601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length7.5
Mean length3.7333333
Min length2

Characters and Unicode

Total characters112
Distinct characters55
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique17 ?
Unique (%)56.7%

Sample

1st row스리랑카
2nd row헝가리
3rd row캐나다
4th row스위스
5th row폴란드
ValueCountFrequency (%)
폴란드 3
 
10.0%
카자흐스탄 2
 
6.7%
네덜란드 2
 
6.7%
헝가리 2
 
6.7%
캐나다 2
 
6.7%
인도네시아 2
 
6.7%
칠레 1
 
3.3%
스리랑카 1
 
3.3%
브루나이드루살렘 1
 
3.3%
라트비아 1
 
3.3%
Other values (13) 13
43.3%
2023-12-10T22:49:23.736234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
아 7
 
6.2%
드 6
 
5.4%
스 5
 
4.5%
란 5
 
4.5%
나 4
 
3.6%
리 4
 
3.6%
네 4
 
3.6%
카 4
 
3.6%
라 3
 
2.7%
폴 3
 
2.7%
Other values (45) 67
59.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 112
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
아 7
 
6.2%
드 6
 
5.4%
스 5
 
4.5%
란 5
 
4.5%
나 4
 
3.6%
리 4
 
3.6%
네 4
 
3.6%
카 4
 
3.6%
라 3
 
2.7%
폴 3
 
2.7%
Other values (45) 67
59.8%

Most occurring scripts

ValueCountFrequency (%)
Hangul 112
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
아 7
 
6.2%
드 6
 
5.4%
스 5
 
4.5%
란 5
 
4.5%
나 4
 
3.6%
리 4
 
3.6%
네 4
 
3.6%
카 4
 
3.6%
라 3
 
2.7%
폴 3
 
2.7%
Other values (45) 67
59.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 112
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
아 7
 
6.2%
드 6
 
5.4%
스 5
 
4.5%
란 5
 
4.5%
나 4
 
3.6%
리 4
 
3.6%
네 4
 
3.6%
카 4
 
3.6%
라 3
 
2.7%
폴 3
 
2.7%
Other values (45) 67
59.8%

사용금액
Real number (ℝ)

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1401105.7
Minimum3800
Maximum15118940
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T22:49:23.950208image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3800
5-th percentile6900
Q145000
median253105
Q3934315
95-th percentile6716316.6
Maximum15118940
Range15115140
Interquartile range (IQR)889315

Descriptive statistics

Standard deviation3120339.1
Coefficient of variation (CV)2.2270547
Kurtosis13.625302
Mean1401105.7
Median Absolute Deviation (MAD)243655
Skewness3.5431963
Sum42033172
Variance9.7365163 × 1012
MonotonicityNot monotonic
2023-12-10T22:49:24.233653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
26110 1
 
3.3%
38000 1
 
3.3%
254210 1
 
3.3%
19000 1
 
3.3%
91600 1
 
3.3%
15118940 1
 
3.3%
10900 1
 
3.3%
2631700 1
 
3.3%
252000 1
 
3.3%
8339742 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
3800 1
3.3%
6000 1
3.3%
8000 1
3.3%
10900 1
3.3%
19000 1
3.3%
26110 1
3.3%
33450 1
3.3%
38000 1
3.3%
66000 1
3.3%
68500 1
3.3%
ValueCountFrequency (%)
15118940 1
3.3%
8339742 1
3.3%
4732130 1
3.3%
2631700 1
3.3%
2132790 1
3.3%
2010500 1
3.3%
1350150 1
3.3%
946420 1
3.3%
898000 1
3.3%
820000 1
3.3%

Interactions

2023-12-10T22:49:21.057266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T22:49:24.758983image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군구명국적명사용금액
시군구명1.0001.0001.000
국적명1.0001.0000.000
사용금액1.0000.0001.000

Missing values

2023-12-10T22:49:21.347250image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T22:49:21.511311image/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

기준년월시도명시군구명국적명사용금액
02015-01경기도남양주시스리랑카26110
12015-01경기도이천시헝가리89900
22015-01경기도성남시 수정구캐나다2132790
32015-01경기도과천시스위스553500
42015-01경기도안산시 상록구폴란드333700
52015-01경기도용인시 수지구인도네시아946420
62015-01경기도파주시바레인820000
72015-01경기도구리시앙골라68500
82015-01경기도김포시파나마2010500
92015-01경기도수원시 장안구네덜란드196620
기준년월시도명시군구명국적명사용금액
202015-01경기도평택시칠레898000
212015-01경기도하남시폴란드3800
222015-01경기도고양시 일산서구홍콩8339742
232015-01경기도광명시카자흐스탄252000
242015-01경기도성남시 분당구헝가리2631700
252015-01경기도안산시 단원구페루10900
262015-01경기도수원시 팔달구인도네시아15118940
272015-01경기도용인시 처인구라트비아91600
282015-01경기도부천시몰도바19000
292015-01경기도수원시 영통구카자흐스탄254210