Overview

Dataset statistics

Number of variables10
Number of observations37
Missing cells2
Missing cells (%)0.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.2 KiB
Average record size in memory88.5 B

Variable types

Categorical8
Numeric2

Dataset

Description전북특별자치도 진안군 지역화폐 발행 및 업종별 이용현황에 대한 정보입니다. 지역화폐명, 발행연도, 발행액, 판매액, 업종, 건수 등에 대한 정보를 제공합니다.
Author전북특별자치도 진안군
URLhttps://www.data.go.kr/data/15101756/fileData.do

Alerts

시도명 has constant value ""Constant
시군구 has constant value ""Constant
발행액 is highly overall correlated with 건수 and 6 other fieldsHigh correlation
발행연도 is highly overall correlated with 건수 and 4 other fieldsHigh correlation
판매액 is highly overall correlated with 건수 and 6 other fieldsHigh 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 2 other fieldsHigh correlation
건수 is highly overall correlated with 금액 and 3 other fieldsHigh correlation
금액 is highly overall correlated with 건수 and 2 other fieldsHigh correlation
발행연도 is highly imbalanced (61.1%)Imbalance
발행액 is highly imbalanced (65.8%)Imbalance
판매액 is highly imbalanced (65.8%)Imbalance
건수 has 1 (2.7%) missing valuesMissing
금액 has 1 (2.7%) missing valuesMissing
건수 has 3 (8.1%) zerosZeros
금액 has 3 (8.1%) zerosZeros

Reproduction

Analysis started2024-03-14 14:31:12.667152
Analysis finished2024-03-14 14:31:15.425178
Duration2.76 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시도명
Categorical

CONSTANT 

Distinct1
Distinct (%)2.7%
Missing0
Missing (%)0.0%
Memory size424.0 B
전북특별자치도
37 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row전북특별자치도
2nd row전북특별자치도
3rd row전북특별자치도
4th row전북특별자치도
5th row전북특별자치도

Common Values

ValueCountFrequency (%)
전북특별자치도 37
100.0%

Length

2024-03-14T23:31:15.637562image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T23:31:15.953107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전북특별자치도 37
100.0%

시군구
Categorical

CONSTANT 

Distinct1
Distinct (%)2.7%
Missing0
Missing (%)0.0%
Memory size424.0 B
진안군
37 

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 (%)
진안군 37
100.0%

Length

2024-03-14T23:31:16.285107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T23:31:16.596280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
진안군 37
100.0%

지역화폐명
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)5.4%
Missing0
Missing (%)0.0%
Memory size424.0 B
진안고원행복상품권(지류형)
19 
진안고원행복상품권(카드형)
18 

Length

Max length14
Median length14
Mean length14
Min length14

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row진안고원행복상품권(지류형)
2nd row진안고원행복상품권(지류형)
3rd row진안고원행복상품권(지류형)
4th row진안고원행복상품권(지류형)
5th row진안고원행복상품권(지류형)

Common Values

ValueCountFrequency (%)
진안고원행복상품권(지류형) 19
51.4%
진안고원행복상품권(카드형) 18
48.6%

Length

2024-03-14T23:31:16.930262image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T23:31:17.251747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
진안고원행복상품권(지류형 19
51.4%
진안고원행복상품권(카드형 18
48.6%

발행연도
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct4
Distinct (%)10.8%
Missing0
Missing (%)0.0%
Memory size424.0 B
<NA>
32 
2021
 
2
2022
 
2
2020
 
1

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique1 ?
Unique (%)2.7%

Sample

1st row2020
2nd row2021
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 32
86.5%
2021 2
 
5.4%
2022 2
 
5.4%
2020 1
 
2.7%

Length

2024-03-14T23:31:17.608310image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T23:31:17.937435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 32
86.5%
2021 2
 
5.4%
2022 2
 
5.4%
2020 1
 
2.7%

발행액
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct6
Distinct (%)16.2%
Missing0
Missing (%)0.0%
Memory size424.0 B
<NA>
32 
10000000000
 
1
8000000000
 
1
2000000000
 
1
5000000000
 
1

Length

Max length11
Median length4
Mean length4.8378378
Min length4

Unique

Unique5 ?
Unique (%)13.5%

Sample

1st row10000000000
2nd row8000000000
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 32
86.5%
10000000000 1
 
2.7%
8000000000 1
 
2.7%
2000000000 1
 
2.7%
5000000000 1
 
2.7%
1000000000 1
 
2.7%

Length

2024-03-14T23:31:18.325759image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T23:31:18.681366image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 32
86.5%
10000000000 1
 
2.7%
8000000000 1
 
2.7%
2000000000 1
 
2.7%
5000000000 1
 
2.7%
1000000000 1
 
2.7%

판매액
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct6
Distinct (%)16.2%
Missing0
Missing (%)0.0%
Memory size424.0 B
<NA>
32 
8688080000
 
1
6399446000
 
1
735240000
 
1
3756780000
 
1

Length

Max length10
Median length4
Mean length4.7567568
Min length4

Unique

Unique5 ?
Unique (%)13.5%

Sample

1st row8688080000
2nd row6399446000
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 32
86.5%
8688080000 1
 
2.7%
6399446000 1
 
2.7%
735240000 1
 
2.7%
3756780000 1
 
2.7%
893317500 1
 
2.7%

Length

2024-03-14T23:31:19.079799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T23:31:19.430349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 32
86.5%
8688080000 1
 
2.7%
6399446000 1
 
2.7%
735240000 1
 
2.7%
3756780000 1
 
2.7%
893317500 1
 
2.7%

업종
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)27.0%
Missing0
Missing (%)0.0%
Memory size424.0 B
소매업
4 
보건업
4 
숙박업
4 
개인서비스업
4 
음식
4 
Other values (5)
17 

Length

Max length6
Median length4
Mean length3.7837838
Min length2

Unique

Unique1 ?
Unique (%)2.7%

Sample

1st row<NA>
2nd row소매업
3rd row보건업
4th row숙박업
5th row개인서비스업

Common Values

ValueCountFrequency (%)
소매업 4
10.8%
보건업 4
10.8%
숙박업 4
10.8%
개인서비스업 4
10.8%
음식 4
10.8%
교육서비스업 4
10.8%
제조업 4
10.8%
기타 4
10.8%
스포츠서비스 4
10.8%
<NA> 1
 
2.7%

Length

2024-03-14T23:31:19.848074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T23:31:20.239093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
소매업 4
10.8%
보건업 4
10.8%
숙박업 4
10.8%
개인서비스업 4
10.8%
음식 4
10.8%
교육서비스업 4
10.8%
제조업 4
10.8%
기타 4
10.8%
스포츠서비스 4
10.8%
na 1
 
2.7%

건수
Real number (ℝ)

HIGH CORRELATION  MISSING  ZEROS 

Distinct32
Distinct (%)88.9%
Missing1
Missing (%)2.7%
Infinite0
Infinite (%)0.0%
Mean1550.4444
Minimum0
Maximum16342
Zeros3
Zeros (%)8.1%
Negative0
Negative (%)0.0%
Memory size461.0 B
2024-03-14T23:31:20.869826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q122.75
median132
Q3370.25
95-th percentile8298.25
Maximum16342
Range16342
Interquartile range (IQR)347.5

Descriptive statistics

Standard deviation3632.6572
Coefficient of variation (CV)2.342978
Kurtosis8.9711915
Mean1550.4444
Median Absolute Deviation (MAD)129.5
Skewness2.9732023
Sum55816
Variance13196198
MonotonicityNot monotonic
2024-03-14T23:31:21.280067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=32)
ValueCountFrequency (%)
0 3
 
8.1%
120 2
 
5.4%
22 2
 
5.4%
6153 1
 
2.7%
323 1
 
2.7%
648 1
 
2.7%
20 1
 
2.7%
276 1
 
2.7%
80 1
 
2.7%
16342 1
 
2.7%
Other values (22) 22
59.5%
ValueCountFrequency (%)
0 3
8.1%
2 1
 
2.7%
3 1
 
2.7%
4 1
 
2.7%
20 1
 
2.7%
22 2
5.4%
23 1
 
2.7%
25 1
 
2.7%
28 1
 
2.7%
56 1
 
2.7%
ValueCountFrequency (%)
16342 1
2.7%
12307 1
2.7%
6962 1
2.7%
6153 1
2.7%
5080 1
2.7%
3978 1
2.7%
757 1
2.7%
648 1
2.7%
437 1
2.7%
348 1
2.7%

금액
Real number (ℝ)

HIGH CORRELATION  MISSING  ZEROS 

Distinct34
Distinct (%)94.4%
Missing1
Missing (%)2.7%
Infinite0
Infinite (%)0.0%
Mean2.6747391 × 108
Minimum0
Maximum3.39628 × 109
Zeros3
Zeros (%)8.1%
Negative0
Negative (%)0.0%
Memory size461.0 B
2024-03-14T23:31:21.684940image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q12550000
median14919145
Q31.3539285 × 108
95-th percentile1.2075939 × 109
Maximum3.39628 × 109
Range3.39628 × 109
Interquartile range (IQR)1.3284285 × 108

Descriptive statistics

Standard deviation7.3567065 × 108
Coefficient of variation (CV)2.7504389
Kurtosis13.699257
Mean2.6747391 × 108
Median Absolute Deviation (MAD)14312645
Skewness3.7443173
Sum9.6290608 × 109
Variance5.4121131 × 1017
MonotonicityNot monotonic
2024-03-14T23:31:22.107803image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=34)
ValueCountFrequency (%)
0 3
 
8.1%
3396280000 1
 
2.7%
6767300 1
 
2.7%
85630000 1
 
2.7%
212640000 1
 
2.7%
7180000 1
 
2.7%
462670000 1
 
2.7%
19760000 1
 
2.7%
631910219 1
 
2.7%
1494000 1
 
2.7%
Other values (24) 24
64.9%
ValueCountFrequency (%)
0 3
8.1%
262000 1
 
2.7%
485000 1
 
2.7%
728000 1
 
2.7%
981000 1
 
2.7%
1494000 1
 
2.7%
2040000 1
 
2.7%
2720000 1
 
2.7%
3129980 1
 
2.7%
5775485 1
 
2.7%
ValueCountFrequency (%)
3396280000 1
2.7%
2934645000 1
2.7%
631910219 1
2.7%
620150000 1
2.7%
468160144 1
2.7%
462670000 1
2.7%
212640000 1
2.7%
206385000 1
2.7%
174584626 1
2.7%
122328930 1
2.7%

참고사항
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)8.1%
Missing0
Missing (%)0.0%
Memory size424.0 B
21년 5월부터 12월 결제 내역
18 
22년 1월부터 5월 결제 내역
18 
상품권 통합관리시스템 21년 5월 도입으로 이전 자료 추출 불가
 
1

Length

Max length35
Median length18
Mean length17.972973
Min length17

Unique

Unique1 ?
Unique (%)2.7%

Sample

1st row상품권 통합관리시스템 21년 5월 도입으로 이전 자료 추출 불가
2nd row21년 5월부터 12월 결제 내역
3rd row21년 5월부터 12월 결제 내역
4th row21년 5월부터 12월 결제 내역
5th row21년 5월부터 12월 결제 내역

Common Values

ValueCountFrequency (%)
21년 5월부터 12월 결제 내역 18
48.6%
22년 1월부터 5월 결제 내역 18
48.6%
상품권 통합관리시스템 21년 5월 도입으로 이전 자료 추출 불가 1
 
2.7%

Length

2024-03-14T23:31:22.555253image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T23:31:22.947382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
결제 36
19.0%
내역 36
19.0%
21년 19
10.1%
5월 19
10.1%
5월부터 18
9.5%
12월 18
9.5%
22년 18
9.5%
1월부터 18
9.5%
상품권 1
 
0.5%
통합관리시스템 1
 
0.5%
Other values (5) 5
 
2.6%

Interactions

2024-03-14T23:31:13.766978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T23:31:13.230066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T23:31:14.033720image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T23:31:13.500926image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T23:31:23.186423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지역화폐명발행연도발행액판매액업종건수금액참고사항
지역화폐명1.0000.0001.0001.0000.0000.0000.0000.000
발행연도0.0001.0001.0001.000NaN1.0000.0001.000
발행액1.0001.0001.0001.000NaN1.0001.0001.000
판매액1.0001.0001.0001.000NaN1.0001.0001.000
업종0.000NaNNaNNaN1.0000.3200.5180.000
건수0.0001.0001.0001.0000.3201.0000.8920.250
금액0.0000.0001.0001.0000.5180.8921.0000.000
참고사항0.0001.0001.0001.0000.0000.2500.0001.000
2024-03-14T23:31:23.393020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
발행액발행연도판매액업종지역화폐명참고사항
발행액1.0001.0001.0001.0001.0001.000
발행연도1.0001.0001.0001.0000.0001.000
판매액1.0001.0001.0001.0001.0001.000
업종1.0001.0001.0001.0000.0000.000
지역화폐명1.0000.0001.0000.0001.0000.000
참고사항1.0001.0001.0000.0000.0001.000
2024-03-14T23:31:23.576537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
건수금액지역화폐명발행연도발행액판매액업종참고사항
건수1.0000.8970.0001.0001.0001.0000.1310.157
금액0.8971.0000.0000.0001.0001.0000.3200.000
지역화폐명0.0000.0001.0000.0001.0001.0000.0000.000
발행연도1.0000.0000.0001.0001.0001.0001.0001.000
발행액1.0001.0001.0001.0001.0001.0001.0001.000
판매액1.0001.0001.0001.0001.0001.0001.0001.000
업종0.1310.3200.0001.0001.0001.0001.0000.000
참고사항0.1570.0000.0001.0001.0001.0000.0001.000

Missing values

2024-03-14T23:31:14.397973image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T23:31:14.870064image/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.
2024-03-14T23:31:15.223087image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

시도명시군구지역화폐명발행연도발행액판매액업종건수금액참고사항
0전북특별자치도진안군진안고원행복상품권(지류형)2020100000000008688080000<NA><NA><NA>상품권 통합관리시스템 21년 5월 도입으로 이전 자료 추출 불가
1전북특별자치도진안군진안고원행복상품권(지류형)202180000000006399446000소매업6153339628000021년 5월부터 12월 결제 내역
2전북특별자치도진안군진안고원행복상품권(지류형)<NA><NA><NA>보건업1422093500021년 5월부터 12월 결제 내역
3전북특별자치도진안군진안고원행복상품권(지류형)<NA><NA><NA>숙박업2204000021년 5월부터 12월 결제 내역
4전북특별자치도진안군진안고원행복상품권(지류형)<NA><NA><NA>개인서비스업2899287500021년 5월부터 12월 결제 내역
5전북특별자치도진안군진안고원행복상품권(지류형)<NA><NA><NA>음식75720638500021년 5월부터 12월 결제 내역
6전북특별자치도진안군진안고원행복상품권(지류형)<NA><NA><NA>교육서비스업25756500021년 5월부터 12월 결제 내역
7전북특별자치도진안군진안고원행복상품권(지류형)<NA><NA><NA>제조업43762015000021년 5월부터 12월 결제 내역
8전북특별자치도진안군진안고원행복상품권(지류형)<NA><NA><NA>기타1202744000021년 5월부터 12월 결제 내역
9전북특별자치도진안군진안고원행복상품권(지류형)<NA><NA><NA>스포츠서비스0021년 5월부터 12월 결제 내역
시도명시군구지역화폐명발행연도발행액판매액업종건수금액참고사항
27전북특별자치도진안군진안고원행복상품권(지류형)<NA><NA><NA>스포츠서비스0022년 1월부터 5월 결제 내역
28전북특별자치도진안군진안고원행복상품권(카드형)20221000000000893317500소매업1634263191021922년 1월부터 5월 결제 내역
29전북특별자치도진안군진안고원행복상품권(카드형)<NA><NA><NA>보건업323676730022년 1월부터 5월 결제 내역
30전북특별자치도진안군진안고원행복상품권(카드형)<NA><NA><NA>숙박업23149400022년 1월부터 5월 결제 내역
31전북특별자치도진안군진안고원행복상품권(카드형)<NA><NA><NA>개인서비스업3482533660022년 1월부터 5월 결제 내역
32전북특별자치도진안군진안고원행복상품권(카드형)<NA><NA><NA>음식696217458462622년 1월부터 5월 결제 내역
33전북특별자치도진안군진안고원행복상품권(카드형)<NA><NA><NA>교육서비스업28674800022년 1월부터 5월 결제 내역
34전북특별자치도진안군진안고원행복상품권(카드형)<NA><NA><NA>제조업2461007829022년 1월부터 5월 결제 내역
35전북특별자치도진안군진안고원행복상품권(카드형)<NA><NA><NA>기타120312998022년 1월부터 5월 결제 내역
36전북특별자치도진안군진안고원행복상품권(카드형)<NA><NA><NA>스포츠서비스5672800022년 1월부터 5월 결제 내역