Overview

Dataset statistics

Number of variables4
Number of observations928
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory31.8 KiB
Average record size in memory35.1 B

Variable types

Numeric3
Categorical1

Dataset

DescriptionBC카드 제공한 데이터의 통계 자료로 충남외 거주하는 자의 충남내 소비를 파악할 수 있습니다. 월별, 충남외시군별, 카드이용건수와 이용금액을 확인할 수 있습니다. 본 자료는 상업적 이용금지 및 재배포할 수 없습니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/bigdata/collect/view.chungnam?menuCd=DOM_000000201001001000&apiIdx=2158

Alerts

전체이용건수 is highly overall correlated with 전체이용금액 and 1 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

Reproduction

Analysis started2024-01-09 22:37:31.782555
Analysis finished2024-01-09 22:37:32.886917
Duration1.1 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기준연월
Real number (ℝ)

Distinct58
Distinct (%)6.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean202099.43
Minimum201901
Maximum202310
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.3 KiB
2024-01-10T07:37:32.954866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum201901
5-th percentile201903
Q1202003
median202105.5
Q3202208
95-th percentile202308
Maximum202310
Range409
Interquartile range (IQR)205

Descriptive statistics

Standard deviation138.64913
Coefficient of variation (CV)0.00068604413
Kurtosis-1.2609616
Mean202099.43
Median Absolute Deviation (MAD)102.5
Skewness0.041595556
Sum1.8754827 × 108
Variance19223.581
MonotonicityNot monotonic
2024-01-10T07:37:33.099354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
201901 16
 
1.7%
202209 16
 
1.7%
202109 16
 
1.7%
202110 16
 
1.7%
202111 16
 
1.7%
202112 16
 
1.7%
202201 16
 
1.7%
202202 16
 
1.7%
202203 16
 
1.7%
202204 16
 
1.7%
Other values (48) 768
82.8%
ValueCountFrequency (%)
201901 16
1.7%
201902 16
1.7%
201903 16
1.7%
201904 16
1.7%
201905 16
1.7%
201906 16
1.7%
201907 16
1.7%
201908 16
1.7%
201909 16
1.7%
201910 16
1.7%
ValueCountFrequency (%)
202310 16
1.7%
202309 16
1.7%
202308 16
1.7%
202307 16
1.7%
202306 16
1.7%
202305 16
1.7%
202304 16
1.7%
202303 16
1.7%
202302 16
1.7%
202301 16
1.7%

고객광역시군구명
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size7.4 KiB
세종특별자치시
 
58
서울특별시
 
58
인천광역시
 
58
전라북도
 
58
충청북도
 
58
Other values (12)
638 

Length

Max length7
Median length5
Mean length4.7047414
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row세종특별자치시
2nd row울산광역시
3rd row인천광역시
4th row전라북도
5th row충청북도

Common Values

ValueCountFrequency (%)
세종특별자치시 58
 
6.2%
서울특별시 58
 
6.2%
인천광역시 58
 
6.2%
전라북도 58
 
6.2%
충청북도 58
 
6.2%
경기도 58
 
6.2%
경상북도 58
 
6.2%
울산광역시 58
 
6.2%
부산광역시 58
 
6.2%
대구광역시 58
 
6.2%
Other values (7) 348
37.5%

Length

2024-01-10T07:37:33.284563image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
세종특별자치시 58
 
6.2%
서울특별시 58
 
6.2%
대전광역시 58
 
6.2%
광주광역시 58
 
6.2%
경상남도 58
 
6.2%
제주특별자치도 58
 
6.2%
전라남도 58
 
6.2%
대구광역시 58
 
6.2%
부산광역시 58
 
6.2%
울산광역시 58
 
6.2%
Other values (7) 348
37.5%

전체이용건수
Real number (ℝ)

HIGH CORRELATION 

Distinct926
Distinct (%)99.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean188018.62
Minimum6739
Maximum1470231
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.3 KiB
2024-01-10T07:37:33.478720image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum6739
5-th percentile11636
Q147571.25
median80102
Q3143538.25
95-th percentile996743.85
Maximum1470231
Range1463492
Interquartile range (IQR)95967

Descriptive statistics

Standard deviation293981.19
Coefficient of variation (CV)1.5635749
Kurtosis6.3477715
Mean188018.62
Median Absolute Deviation (MAD)39143
Skewness2.6553069
Sum1.7448128 × 108
Variance8.642494 × 1010
MonotonicityNot monotonic
2024-01-10T07:37:33.622469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
71890 2
 
0.2%
94067 2
 
0.2%
85264 1
 
0.1%
72985 1
 
0.1%
10455 1
 
0.1%
86788 1
 
0.1%
44823 1
 
0.1%
256164 1
 
0.1%
84814 1
 
0.1%
27824 1
 
0.1%
Other values (916) 916
98.7%
ValueCountFrequency (%)
6739 1
0.1%
7266 1
0.1%
7428 1
0.1%
7488 1
0.1%
7658 1
0.1%
7674 1
0.1%
8090 1
0.1%
8348 1
0.1%
8363 1
0.1%
8559 1
0.1%
ValueCountFrequency (%)
1470231 1
0.1%
1423825 1
0.1%
1408788 1
0.1%
1376223 1
0.1%
1370797 1
0.1%
1366312 1
0.1%
1362841 1
0.1%
1356287 1
0.1%
1354575 1
0.1%
1344395 1
0.1%

전체이용금액
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct928
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.9546955 × 109
Minimum1.9373209 × 108
Maximum4.3685745 × 1010
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.3 KiB
2024-01-10T07:37:33.991937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.9373209 × 108
5-th percentile3.1911676 × 108
Q11.454779 × 109
median2.5579354 × 109
Q34.3873284 × 109
95-th percentile3.1539208 × 1010
Maximum4.3685745 × 1010
Range4.3492013 × 1010
Interquartile range (IQR)2.9325495 × 109

Descriptive statistics

Standard deviation9.1251336 × 109
Coefficient of variation (CV)1.5324266
Kurtosis5.5370388
Mean5.9546955 × 109
Median Absolute Deviation (MAD)1.3135061 × 109
Skewness2.518916
Sum5.5259575 × 1012
Variance8.3268064 × 1019
MonotonicityNot monotonic
2024-01-10T07:37:34.121423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3098865139 1
 
0.1%
1974347797 1
 
0.1%
1556133996 1
 
0.1%
264922005 1
 
0.1%
2361618246 1
 
0.1%
1267315825 1
 
0.1%
7953788499 1
 
0.1%
2748084657 1
 
0.1%
786141663 1
 
0.1%
5502134776 1
 
0.1%
Other values (918) 918
98.9%
ValueCountFrequency (%)
193732089 1
0.1%
198645739 1
0.1%
203297848 1
0.1%
216697445 1
0.1%
221922020 1
0.1%
223590420 1
0.1%
229873124 1
0.1%
230771799 1
0.1%
230980964 1
0.1%
234910904 1
0.1%
ValueCountFrequency (%)
43685744968 1
0.1%
43650512674 1
0.1%
42956723225 1
0.1%
42384979294 1
0.1%
42299880298 1
0.1%
42160555714 1
0.1%
41942230752 1
0.1%
41648626024 1
0.1%
41069770859 1
0.1%
40725753040 1
0.1%

Interactions

2024-01-10T07:37:32.465032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:37:31.908337image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:37:32.203156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:37:32.554036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:37:32.004902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:37:32.298183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:37:32.650830image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:37:32.117712image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:37:32.384178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T07:37:34.203561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준연월고객광역시군구명전체이용건수전체이용금액
기준연월1.0000.0000.0000.119
고객광역시군구명0.0001.0000.8560.867
전체이용건수0.0000.8561.0000.969
전체이용금액0.1190.8670.9691.000
2024-01-10T07:37:34.290115image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준연월전체이용건수전체이용금액고객광역시군구명
기준연월1.000-0.0040.0210.000
전체이용건수-0.0041.0000.9910.553
전체이용금액0.0210.9911.0000.574
고객광역시군구명0.0000.5530.5741.000

Missing values

2024-01-10T07:37:32.778736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T07:37:32.854748image/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

기준연월고객광역시군구명전체이용건수전체이용금액
0201901세종특별자치시852643098865139
1201901울산광역시27791991509656
2201901인천광역시1648205082848771
3201901전라북도1174893624541132
4201901충청북도1113993632282615
5201902강원도29011808895610
6201902경기도99950529249465108
7201902경상북도574771798204707
8201903부산광역시859492672626886
9201903서울특별시68098520309482230
기준연월고객광역시군구명전체이용건수전체이용금액
918202307부산광역시826562516529747
919202307서울특별시58127119378461380
920202308대구광역시694272039434983
921202308전라남도572241857170193
922202308제주특별자치도9786298336490
923202309경상남도913512693089015
924202309광주광역시482211437717086
925202309대전광역시2546048962126502
926202310경기도130570141942230752
927202310경상북도729052247602836