Overview

Dataset statistics

Number of variables4
Number of observations5791
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory192.4 KiB
Average record size in memory34.0 B

Variable types

Categorical1
Text1
Numeric2

Dataset

Description경상남도 김해시 지역사랑상품권 업종별 결제금액 현황에 대한 데이터로 연월, 업종, 결제건수, 결제금액의 항목으로 구성되어 있습니다.
Author경상남도 김해시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15104972

Alerts

결제건수 is highly overall correlated with 결제금액High correlation
결제금액 is highly overall correlated with 결제건수High correlation

Reproduction

Analysis started2024-03-13 00:13:16.314406
Analysis finished2024-03-13 00:13:17.025744
Duration0.71 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연월
Categorical

Distinct18
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size45.4 KiB
Nov-22
 
337
Mar-23
 
337
Oct-22
 
330
Jul-22
 
328
Apr-23
 
328
Other values (13)
4131 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowJul-22
2nd rowJul-22
3rd rowJul-22
4th rowJul-22
5th rowJul-22

Common Values

ValueCountFrequency (%)
Nov-22 337
 
5.8%
Mar-23 337
 
5.8%
Oct-22 330
 
5.7%
Jul-22 328
 
5.7%
Apr-23 328
 
5.7%
Feb-23 327
 
5.6%
May-23 327
 
5.6%
Oct-23 324
 
5.6%
Sep-22 323
 
5.6%
Dec-22 323
 
5.6%
Other values (8) 2507
43.3%

Length

2024-03-13T09:13:17.073535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
nov-22 337
 
5.8%
mar-23 337
 
5.8%
oct-22 330
 
5.7%
jul-22 328
 
5.7%
apr-23 328
 
5.7%
feb-23 327
 
5.6%
may-23 327
 
5.6%
oct-23 324
 
5.6%
dec-22 323
 
5.6%
sep-22 323
 
5.6%
Other values (8) 2507
43.3%

업종
Text

Distinct406
Distinct (%)7.0%
Missing0
Missing (%)0.0%
Memory size45.4 KiB
2024-03-13T09:13:17.313261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length20
Mean length10.843032
Min length2

Characters and Unicode

Total characters62792
Distinct characters304
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique22 ?
Unique (%)0.4%

Sample

1st row가구 소매업
2nd row가발 및 유사 제품 제조업
3rd row가방 및 기타 가죽제품 소매업
4th row가방 및 기타 보호용 케이스 제조업
5th row가전제품 소매업
ValueCountFrequency (%)
및 1717
 
8.9%
기타 1387
 
7.2%
소매업 814
 
4.2%
제조업 703
 
3.6%
도매업 702
 
3.6%
외 499
 
2.6%
그 499
 
2.6%
운영업 446
 
2.3%
서비스업 374
 
1.9%
자동차 175
 
0.9%
Other values (532) 12030
62.2%
2024-03-13T09:13:17.707682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
13555
21.6%
업 4668
 
7.4%
기 2028
 
3.2%
및 1717
 
2.7%
매 1677
 
2.7%
타 1418
 
2.3%
품 1385
 
2.2%
제 1202
 
1.9%
용 1128
 
1.8%
소 979
 
1.6%
Other values (294) 33035
52.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 49187
78.3%
Space Separator 13555
 
21.6%
Open Punctuation 25
 
< 0.1%
Close Punctuation 25
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
업 4668
 
9.5%
기 2028
 
4.1%
및 1717
 
3.5%
매 1677
 
3.4%
타 1418
 
2.9%
품 1385
 
2.8%
제 1202
 
2.4%
용 1128
 
2.3%
소 979
 
2.0%
조 949
 
1.9%
Other values (291) 32036
65.1%
Space Separator
ValueCountFrequency (%)
13555
100.0%
Open Punctuation
ValueCountFrequency (%)
( 25
100.0%
Close Punctuation
ValueCountFrequency (%)
) 25
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 49187
78.3%
Common 13605
 
21.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
업 4668
 
9.5%
기 2028
 
4.1%
및 1717
 
3.5%
매 1677
 
3.4%
타 1418
 
2.9%
품 1385
 
2.8%
제 1202
 
2.4%
용 1128
 
2.3%
소 979
 
2.0%
조 949
 
1.9%
Other values (291) 32036
65.1%
Common
ValueCountFrequency (%)
13555
99.6%
( 25
 
0.2%
) 25
 
0.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 48980
78.0%
ASCII 13605
 
21.7%
Compat Jamo 207
 
0.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
13555
99.6%
( 25
 
0.2%
) 25
 
0.2%
Hangul
ValueCountFrequency (%)
업 4668
 
9.5%
기 2028
 
4.1%
및 1717
 
3.5%
매 1677
 
3.4%
타 1418
 
2.9%
품 1385
 
2.8%
제 1202
 
2.5%
용 1128
 
2.3%
소 979
 
2.0%
조 949
 
1.9%
Other values (290) 31829
65.0%
Compat Jamo
ValueCountFrequency (%)
ㆍ 207
100.0%

결제건수
Real number (ℝ)

HIGH CORRELATION 

Distinct1310
Distinct (%)22.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean888.29874
Minimum0
Maximum49014
Zeros1
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size51.0 KiB
2024-03-13T09:13:17.822937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q16
median31
Q3212
95-th percentile4069.5
Maximum49014
Range49014
Interquartile range (IQR)206

Descriptive statistics

Standard deviation3742.9145
Coefficient of variation (CV)4.2135762
Kurtosis71.207099
Mean888.29874
Median Absolute Deviation (MAD)30
Skewness7.8069626
Sum5144138
Variance14009409
MonotonicityNot monotonic
2024-03-13T09:13:17.926514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 558
 
9.6%
2 336
 
5.8%
3 209
 
3.6%
4 185
 
3.2%
5 158
 
2.7%
6 136
 
2.3%
7 112
 
1.9%
8 100
 
1.7%
10 90
 
1.6%
9 82
 
1.4%
Other values (1300) 3825
66.1%
ValueCountFrequency (%)
0 1
 
< 0.1%
1 558
9.6%
2 336
5.8%
3 209
 
3.6%
4 185
 
3.2%
5 158
 
2.7%
6 136
 
2.3%
7 112
 
1.9%
8 100
 
1.7%
9 82
 
1.4%
ValueCountFrequency (%)
49014 1
< 0.1%
47126 1
< 0.1%
46428 1
< 0.1%
46089 1
< 0.1%
45261 1
< 0.1%
45129 1
< 0.1%
44887 1
< 0.1%
44726 1
< 0.1%
40750 1
< 0.1%
40058 1
< 0.1%

결제금액
Real number (ℝ)

HIGH CORRELATION 

Distinct4694
Distinct (%)81.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean30783902
Minimum-93600
Maximum1.9704473 × 109
Zeros3
Zeros (%)0.1%
Negative1
Negative (%)< 0.1%
Memory size51.0 KiB
2024-03-13T09:13:18.030871image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-93600
5-th percentile29750
Q1249450
median1418800
Q311002344
95-th percentile1.454494 × 108
Maximum1.9704473 × 109
Range1.9705409 × 109
Interquartile range (IQR)10752894

Descriptive statistics

Standard deviation1.3458396 × 108
Coefficient of variation (CV)4.371894
Kurtosis100.03164
Mean30783902
Median Absolute Deviation (MAD)1353800
Skewness9.2239372
Sum1.7826958 × 1011
Variance1.8112841 × 1016
MonotonicityNot monotonic
2024-03-13T09:13:18.147011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
200000 27
 
0.5%
30000 24
 
0.4%
10000 23
 
0.4%
50000 22
 
0.4%
110000 22
 
0.4%
40000 22
 
0.4%
20000 19
 
0.3%
15000 19
 
0.3%
100000 18
 
0.3%
300000 17
 
0.3%
Other values (4684) 5578
96.3%
ValueCountFrequency (%)
-93600 1
 
< 0.1%
0 3
0.1%
500 1
 
< 0.1%
600 1
 
< 0.1%
880 1
 
< 0.1%
1100 1
 
< 0.1%
1500 2
 
< 0.1%
2000 6
0.1%
2500 4
0.1%
2800 1
 
< 0.1%
ValueCountFrequency (%)
1970447270 1
< 0.1%
1957153404 1
< 0.1%
1902834787 1
< 0.1%
1902067225 1
< 0.1%
1884277079 1
< 0.1%
1855591893 1
< 0.1%
1841759540 1
< 0.1%
1827737602 1
< 0.1%
1762286407 1
< 0.1%
1710399076 1
< 0.1%

Interactions

2024-03-13T09:13:16.723367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T09:13:16.577540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T09:13:16.817424image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T09:13:16.643610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T09:13:18.221857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연월결제건수결제금액
연월1.0000.0000.000
결제건수0.0001.0000.882
결제금액0.0000.8821.000
2024-03-13T09:13:18.288261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
결제건수결제금액연월
결제건수1.0000.8960.000
결제금액0.8961.0000.000
연월0.0000.0001.000

Missing values

2024-03-13T09:13:16.936589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T09:13:16.997782image/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

연월업종결제건수결제금액
0Jul-22가구 소매업10425656900
1Jul-22가발 및 유사 제품 제조업21618000
2Jul-22가방 및 기타 가죽제품 소매업451301600
3Jul-22가방 및 기타 보호용 케이스 제조업25373900
4Jul-22가전제품 소매업707019750
5Jul-22가전제품 수리업131311000
6Jul-22가정용 및 장식용 도자기 제조업5177000
7Jul-22가정용 세탁업154118703331
8Jul-22가정용 직물제품 소매업796704150
9Jul-22가죽 및 모피 의복 소매업364000
연월업종결제건수결제금액
5781Dec-23한식 면 요리 전문점147925818950
5782Dec-23한식 육류 요리 전문점1548103017390
5783Dec-23한식 일반 음식점업448871452715648
5784Dec-23한식 해산물 요리 전문점29113871150
5785Dec-23한의원147645476026
5786Dec-23화장품43529444720
5787Dec-23화장품 및 화장용품 도매업8714851120
5788Dec-23화초 및 식물 소매업41114641425
5789Dec-23화훼류 및 식물 도매업1234455210
5790Dec-23화훼작물 재배업9408000