Overview

Dataset statistics

Number of variables11
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.3 KiB
Average record size in memory95.3 B

Variable types

Categorical7
Numeric4

Dataset

Description샘플 데이터
Author지디에스컨설팅그룹
URLhttps://www.bigdata-environment.kr/user/data_market/detail.do?id=5bdb5540-2e00-11ea-9713-eb3e5186fb38

Alerts

생태관광지번호 has constant value ""Constant
생태관광지그룹명 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

Reproduction

Analysis started2023-12-10 10:56:04.021428
Analysis finished2023-12-10 10:56:07.909666
Duration3.89 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

생태관광지번호
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
1
100 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row1
3rd row1
4th row1
5th row1

Common Values

ValueCountFrequency (%)
1 100
100.0%

Length

2023-12-10T19:56:08.032302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:56:08.219977image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 100
100.0%

생태관광지그룹명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
제주 동백동산습지
100 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row제주 동백동산습지
2nd row제주 동백동산습지
3rd row제주 동백동산습지
4th row제주 동백동산습지
5th row제주 동백동산습지

Common Values

ValueCountFrequency (%)
제주 동백동산습지 100
100.0%

Length

2023-12-10T19:56:08.401132image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:56:08.580360image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제주 100
50.0%
동백동산습지 100
50.0%

생태관광지명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
동백동산습지센터
100 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row동백동산습지센터
2nd row동백동산습지센터
3rd row동백동산습지센터
4th row동백동산습지센터
5th row동백동산습지센터

Common Values

ValueCountFrequency (%)
동백동산습지센터 100
100.0%

Length

2023-12-10T19:56:08.777905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:56:08.965893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동백동산습지센터 100
100.0%

사용년월코드
Categorical

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2008
49 
2007
28 
2009
23 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2007
2nd row2007
3rd row2007
4th row2007
5th row2007

Common Values

ValueCountFrequency (%)
2008 49
49.0%
2007 28
28.0%
2009 23
23.0%

Length

2023-12-10T19:56:09.130563image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:56:09.329661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2008 49
49.0%
2007 28
28.0%
2009 23
23.0%

업종명
Categorical

Distinct14
Distinct (%)14.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
편의점
23 
한식
23 
일반음식점 기타
13 
농．수．축협직판장
9 
주유소
9 
Other values (9)
23 

Length

Max length10
Median length9
Mean length4.68
Min length2

Unique

Unique4 ?
Unique (%)4.0%

Sample

1st row농．수．축협직판장
2nd row슈퍼마켓
3rd row슈퍼마켓
4th row일반음식점 기타
5th row일반음식점 기타

Common Values

ValueCountFrequency (%)
편의점 23
23.0%
한식 23
23.0%
일반음식점 기타 13
13.0%
농．수．축협직판장 9
 
9.0%
주유소 9
 
9.0%
커피전문점 6
 
6.0%
제과점/아이스크림점 5
 
5.0%
슈퍼마켓 4
 
4.0%
기타관광호텔 2
 
2.0%
휴게음식점 2
 
2.0%
Other values (4) 4
 
4.0%

Length

2023-12-10T19:56:09.613598image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
편의점 23
20.0%
한식 23
20.0%
기타 14
12.2%
일반음식점 13
11.3%
농．수．축협직판장 9
 
7.8%
주유소 9
 
7.8%
커피전문점 6
 
5.2%
제과점/아이스크림점 5
 
4.3%
슈퍼마켓 4
 
3.5%
기타관광호텔 2
 
1.7%
Other values (6) 7
 
6.1%

성별명
Categorical

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2.여성
58 
1.남성
42 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2.여성
2nd row2.여성
3rd row2.여성
4th row1.남성
5th row1.남성

Common Values

ValueCountFrequency (%)
2.여성 58
58.0%
1.남성 42
42.0%

Length

2023-12-10T19:56:10.094704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:56:10.280021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2.여성 58
58.0%
1.남성 42
42.0%

연령대명
Categorical

Distinct10
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
08.45세미만
27 
07.40세미만
16 
10.55세미만
12 
06.35세미만
11 
09.50세미만
10 
Other values (5)
24 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique1 ?
Unique (%)1.0%

Sample

1st row10.55세미만
2nd row07.40세미만
3rd row08.45세미만
4th row08.45세미만
5th row10.55세미만

Common Values

ValueCountFrequency (%)
08.45세미만 27
27.0%
07.40세미만 16
16.0%
10.55세미만 12
12.0%
06.35세미만 11
11.0%
09.50세미만 10
 
10.0%
05.30세미만 10
 
10.0%
12.65세미만 7
 
7.0%
11.60세미만 4
 
4.0%
04.25세미만 2
 
2.0%
13.70세미만 1
 
1.0%

Length

2023-12-10T19:56:10.507329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:56:10.753246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
08.45세미만 27
27.0%
07.40세미만 16
16.0%
10.55세미만 12
12.0%
06.35세미만 11
11.0%
09.50세미만 10
 
10.0%
05.30세미만 10
 
10.0%
12.65세미만 7
 
7.0%
11.60세미만 4
 
4.0%
04.25세미만 2
 
2.0%
13.70세미만 1
 
1.0%

사용금액
Real number (ℝ)

HIGH CORRELATION 

Distinct99
Distinct (%)99.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1057943.5
Minimum22479
Maximum3897124
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:56:11.040561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum22479
5-th percentile225506.6
Q1451080
median787142.5
Q31404942.5
95-th percentile2730605
Maximum3897124
Range3874645
Interquartile range (IQR)953862.5

Descriptive statistics

Standard deviation843566.25
Coefficient of variation (CV)0.79736417
Kurtosis1.7463292
Mean1057943.5
Median Absolute Deviation (MAD)420359
Skewness1.4336622
Sum1.0579435 × 108
Variance7.1160401 × 1011
MonotonicityNot monotonic
2023-12-10T19:56:11.759254image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
545492 2
 
2.0%
1427871 1
 
1.0%
3897124 1
 
1.0%
816740 1
 
1.0%
1543564 1
 
1.0%
1644720 1
 
1.0%
1416182 1
 
1.0%
1749622 1
 
1.0%
891670 1
 
1.0%
1431168 1
 
1.0%
Other values (89) 89
89.0%
ValueCountFrequency (%)
22479 1
1.0%
93663 1
1.0%
142368 1
1.0%
150610 1
1.0%
217747 1
1.0%
225915 1
1.0%
261507 1
1.0%
265253 1
1.0%
271248 1
1.0%
272746 1
1.0%
ValueCountFrequency (%)
3897124 1
1.0%
3559937 1
1.0%
3539032 1
1.0%
3323907 1
1.0%
3001032 1
1.0%
2716372 1
1.0%
2674336 1
1.0%
2637546 1
1.0%
2603827 1
1.0%
2259972 1
1.0%

사용고객수
Real number (ℝ)

HIGH CORRELATION 

Distinct8
Distinct (%)8.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean29.68
Minimum22
Maximum75
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:56:12.138029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum22
5-th percentile22
Q122
median30
Q330
95-th percentile52
Maximum75
Range53
Interquartile range (IQR)8

Descriptive statistics

Standard deviation10.5341
Coefficient of variation (CV)0.35492252
Kurtosis4.1719652
Mean29.68
Median Absolute Deviation (MAD)8
Skewness1.8832597
Sum2968
Variance110.96727
MonotonicityNot monotonic
2023-12-10T19:56:12.379457image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
22 49
49.0%
30 27
27.0%
37 11
 
11.0%
45 7
 
7.0%
52 3
 
3.0%
75 1
 
1.0%
60 1
 
1.0%
67 1
 
1.0%
ValueCountFrequency (%)
22 49
49.0%
30 27
27.0%
37 11
 
11.0%
45 7
 
7.0%
52 3
 
3.0%
60 1
 
1.0%
67 1
 
1.0%
75 1
 
1.0%
ValueCountFrequency (%)
75 1
 
1.0%
67 1
 
1.0%
60 1
 
1.0%
52 3
 
3.0%
45 7
 
7.0%
37 11
 
11.0%
30 27
27.0%
22 49
49.0%

사용건수
Real number (ℝ)

HIGH CORRELATION 

Distinct17
Distinct (%)17.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean53.69
Minimum22
Maximum367
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:56:12.593452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum22
5-th percentile22
Q130
median37
Q352
95-th percentile113.15
Maximum367
Range345
Interquartile range (IQR)22

Descriptive statistics

Standard deviation54.932593
Coefficient of variation (CV)1.0231438
Kurtosis19.448202
Mean53.69
Median Absolute Deviation (MAD)15
Skewness4.0811204
Sum5369
Variance3017.5898
MonotonicityNot monotonic
2023-12-10T19:56:12.784163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%)
22 23
23.0%
30 19
19.0%
37 14
14.0%
52 12
12.0%
45 9
 
9.0%
82 3
 
3.0%
60 3
 
3.0%
112 3
 
3.0%
67 3
 
3.0%
75 2
 
2.0%
Other values (7) 9
 
9.0%
ValueCountFrequency (%)
22 23
23.0%
30 19
19.0%
37 14
14.0%
45 9
 
9.0%
52 12
12.0%
60 3
 
3.0%
67 3
 
3.0%
75 2
 
2.0%
82 3
 
3.0%
90 1
 
1.0%
ValueCountFrequency (%)
367 1
 
1.0%
352 1
 
1.0%
247 1
 
1.0%
135 2
2.0%
112 3
3.0%
105 2
2.0%
97 1
 
1.0%
90 1
 
1.0%
82 3
3.0%
75 2
2.0%

건당사용금액
Real number (ℝ)

HIGH CORRELATION 

Distinct99
Distinct (%)99.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean24501.337
Minimum1021.77
Maximum96214.51
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:56:13.037533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1021.77
5-th percentile4555.885
Q19918.13
median21374.95
Q332343.217
95-th percentile58129.239
Maximum96214.51
Range95192.74
Interquartile range (IQR)22425.087

Descriptive statistics

Standard deviation18275.89
Coefficient of variation (CV)0.74591397
Kurtosis2.7264262
Mean24501.337
Median Absolute Deviation (MAD)11273.295
Skewness1.4074118
Sum2450133.7
Variance3.3400815 × 108
MonotonicityNot monotonic
2023-12-10T19:56:13.307042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
5020.33 2
 
2.0%
10576.82 1
 
1.0%
10328.22 1
 
1.0%
18149.78 1
 
1.0%
51452.13 1
 
1.0%
31629.23 1
 
1.0%
31470.71 1
 
1.0%
38880.49 1
 
1.0%
24099.19 1
 
1.0%
21360.72 1
 
1.0%
Other values (89) 89
89.0%
ValueCountFrequency (%)
1021.77 1
1.0%
3765.78 1
1.0%
4187.44 1
1.0%
4257.41 1
1.0%
4273.45 1
1.0%
4570.75 1
1.0%
5020.33 2
2.0%
5028.98 1
1.0%
5045.3 1
1.0%
6391.91 1
1.0%
ValueCountFrequency (%)
96214.51 1
1.0%
90545.73 1
1.0%
63921.29 1
1.0%
63690.73 1
1.0%
63191.2 1
1.0%
57862.82 1
1.0%
56878.91 1
1.0%
51452.13 1
1.0%
51438.62 1
1.0%
51429.41 1
1.0%

Interactions

2023-12-10T19:56:06.700933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:56:04.689533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:56:05.369552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:56:06.025263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:56:06.899906image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:56:04.875585image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:56:05.539333image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:56:06.203330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:56:07.081755image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:56:05.030481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:56:05.685849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:56:06.390266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:56:07.251343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:56:05.202027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:56:05.857493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:56:06.522928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T19:56:13.481197image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사용년월코드업종명성별명연령대명사용금액사용고객수사용건수건당사용금액
사용년월코드1.0000.0000.0480.1970.2170.0000.0000.226
업종명0.0001.0000.0000.0000.1230.0000.0000.780
성별명0.0480.0001.0000.3120.0000.0000.4850.000
연령대명0.1970.0000.3121.0000.0000.0000.3600.228
사용금액0.2170.1230.0000.0001.0000.6760.6240.642
사용고객수0.0000.0000.0000.0000.6761.0000.6670.000
사용건수0.0000.0000.4850.3600.6240.6671.0000.000
건당사용금액0.2260.7800.0000.2280.6420.0000.0001.000
2023-12-10T19:56:13.714579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
성별명연령대명사용년월코드업종명
성별명1.0000.2280.0790.000
연령대명0.2281.0000.1110.000
사용년월코드0.0790.1111.0000.000
업종명0.0000.0000.0001.000
2023-12-10T19:56:13.940292image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사용금액사용고객수사용건수건당사용금액사용년월코드업종명성별명연령대명
사용금액1.0000.2000.3590.7100.1170.0000.0000.000
사용고객수0.2001.0000.625-0.1690.0000.0000.0000.000
사용건수0.3590.6251.000-0.3160.0000.0000.3420.192
건당사용금액0.710-0.169-0.3161.0000.1310.4780.0000.102
사용년월코드0.1170.0000.0000.1311.0000.0000.0790.111
업종명0.0000.0000.0000.4780.0001.0000.0000.000
성별명0.0000.0000.3420.0000.0790.0001.0000.228
연령대명0.0000.0000.1920.1020.1110.0000.2281.000

Missing values

2023-12-10T19:56:07.464239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T19:56:07.798294image/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

생태관광지번호생태관광지그룹명생태관광지명사용년월코드업종명성별명연령대명사용금액사용고객수사용건수건당사용금액
01제주 동백동산습지동백동산습지센터2007농．수．축협직판장2.여성10.55세미만14278713013510576.82
11제주 동백동산습지동백동산습지센터2007슈퍼마켓2.여성07.40세미만812019222236909.95
21제주 동백동산습지동백동산습지센터2007슈퍼마켓2.여성08.45세미만870165223029005.5
31제주 동백동산습지동백동산습지센터2007일반음식점 기타1.남성08.45세미만470562222221389.18
41제주 동백동산습지동백동산습지센터2007일반음식점 기타1.남성10.55세미만947868223031595.6
51제주 동백동산습지동백동산습지센터2007일반음식점 기타2.여성06.35세미만610682225211743.88
61제주 동백동산습지동백동산습지센터2007일반음식점 기타2.여성10.55세미만648147222229461.23
71제주 동백동산습지동백동산습지센터2007일반주점2.여성06.35세미만626417222228473.5
81제주 동백동산습지동백동산습지센터2007제과점/아이스크림점1.남성08.45세미만265253222212056.95
91제주 동백동산습지동백동산습지센터2007주유소1.남성07.40세미만1948187226032469.78
생태관광지번호생태관광지그룹명생태관광지명사용년월코드업종명성별명연령대명사용금액사용고객수사용건수건당사용금액
901제주 동백동산습지동백동산습지센터2009편의점1.남성07.40세미만3539032453679643.14
911제주 동백동산습지동백동산습지센터2009편의점1.남성09.50세미만11917664511210640.77
921제주 동백동산습지동백동산습지센터2009편의점2.여성05.30세미만31021130456893.58
931제주 동백동산습지동백동산습지센터2009편의점2.여성07.40세미만33726130526485.79
941제주 동백동산습지동백동산습지센터2009편의점2.여성08.45세미만52413737826391.91
951제주 동백동산습지동백동산습지센터2009한식1.남성05.30세미만1195138303732301.03
961제주 동백동산습지동백동산습지센터2009한식1.남성07.40세미만1813313306727064.37
971제주 동백동산습지동백동산습지센터2009한식1.남성09.50세미만1895736223063191.2
981제주 동백동산습지동백동산습지센터2009한식1.남성12.65세미만1129949223037664.97
991제주 동백동산습지동백동산습지센터2007농．수．축협직판장1.남성08.45세미만762266223025408.87