Overview

Dataset statistics

Number of variables18
Number of observations57
Missing cells1
Missing cells (%)0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.2 KiB
Average record size in memory147.3 B

Variable types

Categorical4
Numeric1
Unsupported13

Dataset

Description2021년 대전광역시 주요관광지점 입장객 통계 현황에 관한 자료로 각 자치구별 주요관광지점의 월별 입장객수가 제공됩니다.
Author대전광역시
URLhttps://www.data.go.kr/data/15101843/fileData.do

Alerts

내/외국인 is highly overall correlated with 시도High correlation
관광지 is highly overall correlated with 총계(2021.01 ~ 2021.12) and 2 other fieldsHigh correlation
시도 is highly overall correlated with 총계(2021.01 ~ 2021.12) and 3 other fieldsHigh correlation
군구 is highly overall correlated with 시도 and 1 other fieldsHigh correlation
총계(2021.01 ~ 2021.12) is highly overall correlated with 시도 and 1 other fieldsHigh correlation
시도 is highly imbalanced (87.3%)Imbalance
총계(2021.01 ~ 2021.12) has 1 (1.8%) missing valuesMissing
2021년 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 6 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 7 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 9 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 11 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 12 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 13 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 14 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 15 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 16 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 17 is an unsupported type, check if it needs cleaning or further analysisUnsupported
총계(2021.01 ~ 2021.12) has 4 (7.0%) zerosZeros

Reproduction

Analysis started2023-12-12 18:22:00.772754
Analysis finished2023-12-12 18:22:01.462561
Duration0.69 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시도
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)3.5%
Missing0
Missing (%)0.0%
Memory size588.0 B
대전광역시
56 
<NA>
 
1

Length

Max length5
Median length5
Mean length4.9824561
Min length4

Unique

Unique1 ?
Unique (%)1.8%

Sample

1st row<NA>
2nd row대전광역시
3rd row대전광역시
4th row대전광역시
5th row대전광역시

Common Values

ValueCountFrequency (%)
대전광역시 56
98.2%
<NA> 1
 
1.8%

Length

2023-12-13T03:22:01.524161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:22:01.637437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대전광역시 56
98.2%
na 1
 
1.8%

군구
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)10.5%
Missing0
Missing (%)0.0%
Memory size588.0 B
유성구
20 
동구
14 
서구
10 
중구
8 
대덕구
4 

Length

Max length4
Median length2
Mean length2.4561404
Min length2

Unique

Unique1 ?
Unique (%)1.8%

Sample

1st row<NA>
2nd row동구
3rd row동구
4th row동구
5th row동구

Common Values

ValueCountFrequency (%)
유성구 20
35.1%
동구 14
24.6%
서구 10
17.5%
중구 8
 
14.0%
대덕구 4
 
7.0%
<NA> 1
 
1.8%

Length

2023-12-13T03:22:01.759653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:22:01.900646image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
유성구 20
35.1%
동구 14
24.6%
서구 10
17.5%
중구 8
 
14.0%
대덕구 4
 
7.0%
na 1
 
1.8%

관광지
Categorical

HIGH CORRELATION 

Distinct28
Distinct (%)49.1%
Missing0
Missing (%)0.0%
Memory size588.0 B
화폐박물관
 
3
지질박물관
 
3
만인산 자연휴양림
 
2
상소오토캠핑장
 
2
식장산전망대
 
2
Other values (23)
45 

Length

Max length16
Median length11
Mean length7.0526316
Min length4

Unique

Unique1 ?
Unique (%)1.8%

Sample

1st row<NA>
2nd row대동하늘공원
3rd row대동하늘공원
4th row만인산 자연휴양림
5th row만인산 자연휴양림

Common Values

ValueCountFrequency (%)
화폐박물관 3
 
5.3%
지질박물관 3
 
5.3%
만인산 자연휴양림 2
 
3.5%
상소오토캠핑장 2
 
3.5%
식장산전망대 2
 
3.5%
우암사적공원 2
 
3.5%
찬샘마을 2
 
3.5%
한밭교육박물관 2
 
3.5%
대전 아쿠아월드 2
 
3.5%
대전오월드 2
 
3.5%
Other values (18) 35
61.4%

Length

2023-12-13T03:22:02.087313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
화폐박물관 3
 
4.2%
지질박물관 3
 
4.2%
대전예술의전당 2
 
2.8%
대동하늘공원 2
 
2.8%
황톳길 2
 
2.8%
계족산 2
 
2.8%
유성유스호스텔 2
 
2.8%
로파크 2
 
2.8%
솔로몬 2
 
2.8%
장태산자연휴양림 2
 
2.8%
Other values (25) 49
69.0%

내/외국인
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)7.0%
Missing0
Missing (%)0.0%
Memory size588.0 B
내국인
27 
합계
27 
외국인
 
2
<NA>
 
1

Length

Max length4
Median length3
Mean length2.5438596
Min length2

Unique

Unique1 ?
Unique (%)1.8%

Sample

1st row<NA>
2nd row내국인
3rd row합계
4th row내국인
5th row합계

Common Values

ValueCountFrequency (%)
내국인 27
47.4%
합계 27
47.4%
외국인 2
 
3.5%
<NA> 1
 
1.8%

Length

2023-12-13T03:22:02.641754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:22:02.775100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
내국인 27
47.4%
합계 27
47.4%
외국인 2
 
3.5%
na 1
 
1.8%

총계(2021.01 ~ 2021.12)
Real number (ℝ)

HIGH CORRELATION  MISSING  ZEROS 

Distinct27
Distinct (%)48.2%
Missing1
Missing (%)1.8%
Infinite0
Infinite (%)0.0%
Mean256886.36
Minimum0
Maximum1419603
Zeros4
Zeros (%)7.0%
Negative0
Negative (%)0.0%
Memory size645.0 B
2023-12-13T03:22:02.879308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q139648.25
median101173.5
Q3212964.75
95-th percentile1238432
Maximum1419603
Range1419603
Interquartile range (IQR)173316.5

Descriptive statistics

Standard deviation392931.59
Coefficient of variation (CV)1.5295931
Kurtosis3.198847
Mean256886.36
Median Absolute Deviation (MAD)87088
Skewness2.0901356
Sum14385636
Variance1.5439523 × 1011
MonotonicityNot monotonic
2023-12-13T03:22:03.026838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
0 4
 
7.0%
192126 2
 
3.5%
361186 2
 
3.5%
41220 2
 
3.5%
214800 2
 
3.5%
17950 2
 
3.5%
19135 2
 
3.5%
43259 2
 
3.5%
114344 2
 
3.5%
34933 2
 
3.5%
Other values (17) 34
59.6%
ValueCountFrequency (%)
0 4
7.0%
2831 2
3.5%
5814 2
3.5%
17950 2
3.5%
19135 2
3.5%
34933 2
3.5%
41220 2
3.5%
43259 2
3.5%
46624 2
3.5%
75751 2
3.5%
ValueCountFrequency (%)
1419603 2
3.5%
1238432 2
3.5%
1238062 2
3.5%
643548 2
3.5%
453356 2
3.5%
361186 2
3.5%
214800 2
3.5%
212353 2
3.5%
198528 2
3.5%
192126 2
3.5%

2021년
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size588.0 B

Unnamed: 6
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size588.0 B

Unnamed: 7
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size588.0 B

Unnamed: 8
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size588.0 B

Unnamed: 9
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size588.0 B

Unnamed: 10
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size588.0 B

Unnamed: 11
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size588.0 B

Unnamed: 12
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size588.0 B

Unnamed: 13
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size588.0 B

Unnamed: 14
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size588.0 B

Unnamed: 15
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size588.0 B

Unnamed: 16
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size588.0 B

Unnamed: 17
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size588.0 B

Interactions

2023-12-13T03:22:01.004400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T03:22:03.130794image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
군구관광지내/외국인총계(2021.01 ~ 2021.12)
군구1.0001.0000.0000.520
관광지1.0001.0000.0001.000
내/외국인0.0000.0001.0000.000
총계(2021.01 ~ 2021.12)0.5201.0000.0001.000
2023-12-13T03:22:03.230694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
내/외국인관광지시도군구
내/외국인1.0000.0001.0000.000
관광지0.0001.0001.0000.754
시도1.0001.0001.0001.000
군구0.0000.7541.0001.000
2023-12-13T03:22:03.366182image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
총계(2021.01 ~ 2021.12)시도군구관광지내/외국인
총계(2021.01 ~ 2021.12)1.0001.0000.3570.7690.000
시도1.0001.0001.0001.0001.000
군구0.3571.0001.0000.7540.000
관광지0.7691.0000.7541.0000.000
내/외국인0.0001.0000.0000.0001.000

Missing values

2023-12-13T03:22:01.146576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T03:22:01.384732image/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

시도군구관광지내/외국인총계(2021.01 ~ 2021.12)2021년Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17
0<NA><NA><NA><NA><NA>인원계2021년 01월2021년 02월2021년 03월2021년 04월2021년 05월2021년 06월2021년 07월2021년 08월2021년 09월2021년 10월2021년 11월2021년 12월
1대전광역시동구대동하늘공원내국인192126192126169771953318529189081865714899123771356315960165501439611777
2대전광역시동구대동하늘공원합계192126192126169771953318529189081865714899123771356315960165501439611777
3대전광역시동구만인산 자연휴양림내국인361186361186158122262429327512115066434426179763382439936314522050513429
4대전광역시동구만인산 자연휴양림합계361186361186158122262429327512115066434426179763382439936314522050513429
5대전광역시동구상소오토캠핑장내국인46624466240177901718142818272876000034663056
6대전광역시동구상소오토캠핑장합계46624466240177901718142818272876000034663056
7대전광역시동구식장산전망대내국인100196100196319285067452933810352895392641221281946566129753192
8대전광역시동구식장산전망대합계100196100196319285067452933810352895392641221281946566129753192
9대전광역시동구우암사적공원내국인10958610958631403605922810710893268196485702411153174331425110806
시도군구관광지내/외국인총계(2021.01 ~ 2021.12)2021년Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17
47대전광역시유성구지질박물관내국인1913519135141413231944184421231933180701264229516251563
48대전광역시유성구지질박물관외국인00000000000000
49대전광역시유성구지질박물관합계1913519135141413231944184421231933180701264229516251563
50대전광역시유성구화폐박물관내국인1795017950661951227219902011139716001535824161518201274
51대전광역시유성구화폐박물관외국인00000000000000
52대전광역시유성구화폐박물관합계1795017950661951227219902011139716001535824161518201274
53대전광역시대덕구계족산 황톳길내국인2148002148001502918724156122228729837297242760613832141061523685304277
54대전광역시대덕구계족산 황톳길합계2148002148001502918724156122228729837297242760613832141061523685304277
55대전광역시대덕구로하스가족공원 캠핑장내국인4122041220234025812993380542893598338426934081442437013331
56대전광역시대덕구로하스가족공원 캠핑장합계4122041220234025812993380542893598338426934081442437013331