Overview

Dataset statistics

Number of variables6
Number of observations311
Missing cells31
Missing cells (%)1.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory15.6 KiB
Average record size in memory51.4 B

Variable types

Numeric2
DateTime2
Categorical2

Dataset

Description한국콘텐츠진흥원의 광화문 CKL기업지원센터에 관한 투어정보를 나타내고 있는 데이터 자료를 제공하는 자료입니다.
Author한국콘텐츠진흥원
URLhttps://www.data.go.kr/data/15041596/fileData.do

Alerts

상태 is highly imbalanced (57.3%)Imbalance
수정일시 has 31 (10.0%) missing valuesMissing
일련번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 00:54:51.673779
Analysis finished2023-12-12 00:54:52.450219
Duration0.78 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

일련번호
Real number (ℝ)

UNIQUE 

Distinct311
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean161.12862
Minimum1
Maximum321
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.9 KiB
2023-12-12T09:54:52.545660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile16.5
Q180.5
median160
Q3241.5
95-th percentile305.5
Maximum321
Range320
Interquartile range (IQR)161

Descriptive statistics

Standard deviation93.071683
Coefficient of variation (CV)0.57762355
Kurtosis-1.2050325
Mean161.12862
Median Absolute Deviation (MAD)81
Skewness0.0032278659
Sum50111
Variance8662.3382
MonotonicityNot monotonic
2023-12-12T09:54:52.696802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
13 1
 
0.3%
233 1
 
0.3%
240 1
 
0.3%
239 1
 
0.3%
251 1
 
0.3%
237 1
 
0.3%
236 1
 
0.3%
235 1
 
0.3%
234 1
 
0.3%
232 1
 
0.3%
Other values (301) 301
96.8%
ValueCountFrequency (%)
1 1
0.3%
2 1
0.3%
3 1
0.3%
4 1
0.3%
5 1
0.3%
6 1
0.3%
7 1
0.3%
8 1
0.3%
9 1
0.3%
10 1
0.3%
ValueCountFrequency (%)
321 1
0.3%
320 1
0.3%
319 1
0.3%
318 1
0.3%
317 1
0.3%
316 1
0.3%
315 1
0.3%
314 1
0.3%
313 1
0.3%
312 1
0.3%

등록일시
Date

Distinct257
Distinct (%)82.6%
Missing0
Missing (%)0.0%
Memory size2.6 KiB
Minimum2016-07-28 00:00:00
Maximum2020-01-23 00:00:00
2023-12-12T09:54:52.934922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:54:53.068050image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

상태
Categorical

IMBALANCE 

Distinct4
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size2.6 KiB
종료
250 
취소
52 
마감
 
7
신규
 
2

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row종료
2nd row종료
3rd row종료
4th row종료
5th row종료

Common Values

ValueCountFrequency (%)
종료 250
80.4%
취소 52
 
16.7%
마감 7
 
2.3%
신규 2
 
0.6%

Length

2023-12-12T09:54:53.260077image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T09:54:53.414474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
종료 250
80.4%
취소 52
 
16.7%
마감 7
 
2.3%
신규 2
 
0.6%

수정일시
Date

MISSING 

Distinct217
Distinct (%)77.5%
Missing31
Missing (%)10.0%
Memory size2.6 KiB
Minimum2016-10-13 00:00:00
Maximum2020-05-25 00:00:00
2023-12-12T09:54:53.570816image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:54:53.746294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

투어번호
Real number (ℝ)

Distinct16
Distinct (%)5.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.511254
Minimum1
Maximum20
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.9 KiB
2023-12-12T09:54:53.900720image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median2
Q35.5
95-th percentile20
Maximum20
Range19
Interquartile range (IQR)4.5

Descriptive statistics

Standard deviation6.6151611
Coefficient of variation (CV)1.2003005
Kurtosis0.55121937
Mean5.511254
Median Absolute Deviation (MAD)1
Skewness1.4710806
Sum1714
Variance43.760357
MonotonicityNot monotonic
2023-12-12T09:54:54.042861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)
ValueCountFrequency (%)
1 101
32.5%
2 68
21.9%
20 43
13.8%
3 30
 
9.6%
4 18
 
5.8%
5 16
 
5.1%
10 9
 
2.9%
6 5
 
1.6%
8 4
 
1.3%
12 4
 
1.3%
Other values (6) 13
 
4.2%
ValueCountFrequency (%)
1 101
32.5%
2 68
21.9%
3 30
 
9.6%
4 18
 
5.8%
5 16
 
5.1%
6 5
 
1.6%
7 3
 
1.0%
8 4
 
1.3%
10 9
 
2.9%
11 1
 
0.3%
ValueCountFrequency (%)
20 43
13.8%
19 1
 
0.3%
18 2
 
0.6%
15 4
 
1.3%
14 2
 
0.6%
12 4
 
1.3%
11 1
 
0.3%
10 9
 
2.9%
8 4
 
1.3%
7 3
 
1.0%

채널
Categorical

Distinct5
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Memory size2.6 KiB
1
121 
5
100 
4
67 
3
14 
2
 
9

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 121
38.9%
5 100
32.2%
4 67
21.5%
3 14
 
4.5%
2 9
 
2.9%

Length

2023-12-12T09:54:54.183237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T09:54:54.299717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 121
38.9%
5 100
32.2%
4 67
21.5%
3 14
 
4.5%
2 9
 
2.9%

Interactions

2023-12-12T09:54:52.058735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:54:51.829907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:54:52.146643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T09:54:51.932068image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T09:54:54.387873image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호상태투어번호채널
일련번호1.0000.4530.3630.000
상태0.4531.0000.0000.052
투어번호0.3630.0001.0000.363
채널0.0000.0520.3631.000
2023-12-12T09:54:54.481566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상태채널
상태1.0000.042
채널0.0421.000
2023-12-12T09:54:54.564751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호투어번호상태채널
일련번호1.000-0.1360.2810.040
투어번호-0.1361.0000.0000.157
상태0.2810.0001.0000.042
채널0.0400.1570.0421.000

Missing values

2023-12-12T09:54:52.270437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T09:54:52.409407image/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

일련번호등록일시상태수정일시투어번호채널
0132016-08-19종료<NA>205
1142016-08-19종료<NA>205
2162016-09-01종료<NA>155
3172016-09-05종료<NA>55
4192016-09-22종료<NA>11
5202016-09-26종료<NA>64
6402016-10-20종료2016-10-20204
7412016-10-21종료2016-10-2435
8422016-10-24종료2016-10-26205
9722017-02-18종료2017-02-2011
일련번호등록일시상태수정일시투어번호채널
3013002019-11-10취소2019-11-1231
3023012019-11-11종료2019-11-1111
3032902019-10-16취소2019-10-1634
3042842019-09-22취소2019-09-2331
3052922019-10-17종료2019-10-1734
3062932019-10-17종료2019-10-2114
3072982019-11-04종료2019-11-0811
3083032019-11-16종료2019-11-1821
3093102019-12-15취소2019-12-17104
3103212020-01-23종료2020-01-2321