Overview

Dataset statistics

Number of variables16
Number of observations865
Missing cells6452
Missing cells (%)46.6%
Duplicate rows2
Duplicate rows (%)0.2%
Total size in memory117.5 KiB
Average record size in memory139.2 B

Variable types

Categorical2
Unsupported6
Numeric5
Text1
DateTime2

Dataset

Description경상남도 사천시 문화관광홈페이지 데이터베이스의 주소, 예약, 평가, 공고 테이블의 자료입니다. 예약테이블은 예약일자 가격 등이며, 주소테이블은 주소, 장소 등에 자료입니다.
Author경상남도 사천시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15092294

Alerts

Dataset has 2 (0.2%) duplicate rowsDuplicates
관리자 텍스트 has 865 (100.0%) missing valuesMissing
비밀 yn has 865 (100.0%) missing valuesMissing
gid has 865 (100.0%) missing valuesMissing
pos has 865 (100.0%) missing valuesMissing
깊이 has 865 (100.0%) missing valuesMissing
조회수 has 865 (100.0%) missing valuesMissing
제목 has 771 (89.1%) missing valuesMissing
내용 has 490 (56.6%) missing valuesMissing
관리자 텍스트 is an unsupported type, check if it needs cleaning or further analysisUnsupported
비밀 yn is an unsupported type, check if it needs cleaning or further analysisUnsupported
gid is an unsupported type, check if it needs cleaning or further analysisUnsupported
pos is an unsupported type, check if it needs cleaning or further analysisUnsupported
깊이 is an unsupported type, check if it needs cleaning or further analysisUnsupported
조회수 is an unsupported type, check if it needs cleaning or further analysisUnsupported
성인 명 수 has 108 (12.5%) zerosZeros
미성년자 명 수 has 712 (82.3%) zerosZeros
기타 명 수 has 647 (74.8%) zerosZeros
가격 has 95 (11.0%) zerosZeros

Reproduction

Analysis started2023-12-11 00:58:20.661427
Analysis finished2023-12-11 00:58:23.739487
Duration3.08 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

예약 구분
Categorical

Distinct3
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
INS
709 
DEL
93 
MOD
 
63

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
INS 709
82.0%
DEL 93
 
10.8%
MOD 63
 
7.3%

Length

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

Common Values (Plot)

2023-12-11T09:58:23.875423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
ins 709
82.0%
del 93
 
10.8%
mod 63
 
7.3%

상태
Categorical

Distinct4
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
RSV
446 
Y
277 
N
94 
<NA>
48 

Length

Max length4
Median length3
Mean length2.1976879
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
RSV 446
51.6%
Y 277
32.0%
N 94
 
10.9%
<NA> 48
 
5.5%

Length

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

Common Values (Plot)

2023-12-11T09:58:24.078227image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
rsv 446
51.6%
y 277
32.0%
n 94
 
10.9%
na 48
 
5.5%

관리자 텍스트
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing865
Missing (%)100.0%
Memory size7.7 KiB

비밀 yn
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing865
Missing (%)100.0%
Memory size7.7 KiB

gid
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing865
Missing (%)100.0%
Memory size7.7 KiB

pos
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing865
Missing (%)100.0%
Memory size7.7 KiB

깊이
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing865
Missing (%)100.0%
Memory size7.7 KiB

조회수
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing865
Missing (%)100.0%
Memory size7.7 KiB

제목
Real number (ℝ)

MISSING 

Distinct9
Distinct (%)9.6%
Missing771
Missing (%)89.1%
Infinite0
Infinite (%)0.0%
Mean11.393617
Minimum9
Maximum17
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.7 KiB
2023-12-11T09:58:24.192955image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum9
5-th percentile9
Q110
median11
Q313
95-th percentile15
Maximum17
Range8
Interquartile range (IQR)3

Descriptive statistics

Standard deviation2.1663015
Coefficient of variation (CV)0.1901329
Kurtosis-0.66038601
Mean11.393617
Median Absolute Deviation (MAD)2
Skewness0.66992001
Sum1071
Variance4.692862
MonotonicityNot monotonic
2023-12-11T09:58:24.283643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
9 22
 
2.5%
11 19
 
2.2%
10 19
 
2.2%
13 11
 
1.3%
14 10
 
1.2%
15 6
 
0.7%
12 3
 
0.3%
16 3
 
0.3%
17 1
 
0.1%
(Missing) 771
89.1%
ValueCountFrequency (%)
9 22
2.5%
10 19
2.2%
11 19
2.2%
12 3
 
0.3%
13 11
1.3%
14 10
1.2%
15 6
 
0.7%
16 3
 
0.3%
17 1
 
0.1%
ValueCountFrequency (%)
17 1
 
0.1%
16 3
 
0.3%
15 6
 
0.7%
14 10
1.2%
13 11
1.3%
12 3
 
0.3%
11 19
2.2%
10 19
2.2%
9 22
2.5%

내용
Text

MISSING 

Distinct280
Distinct (%)74.7%
Missing490
Missing (%)56.6%
Memory size6.9 KiB
2023-12-11T09:58:24.557656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length45
Median length32
Mean length12.568
Min length2

Characters and Unicode

Total characters4713
Distinct characters272
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique245 ?
Unique (%)65.3%

Sample

1st row투어
2nd row시티투어
3rd row박물관, 과학관
4th row박물관,과학관
5th row비토섬.다솔사.와인갤러리,남일대 해수욕장,노산공원(용궁시장)
ValueCountFrequency (%)
사천시 132
 
13.8%
경남 30
 
3.1%
용현면 16
 
1.7%
창원시 13
 
1.4%
경기도 12
 
1.3%
사천읍 12
 
1.3%
곤양면 12
 
1.3%
부산시 11
 
1.1%
정동면 10
 
1.0%
12 9
 
0.9%
Other values (514) 702
73.2%
2023-12-11T09:58:25.049316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
605
 
12.8%
시 255
 
5.4%
1 245
 
5.2%
사 200
 
4.2%
천 197
 
4.2%
0 158
 
3.4%
동 146
 
3.1%
2 129
 
2.7%
3 105
 
2.2%
로 91
 
1.9%
Other values (262) 2582
54.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2991
63.5%
Decimal Number 971
 
20.6%
Space Separator 605
 
12.8%
Dash Punctuation 67
 
1.4%
Other Punctuation 55
 
1.2%
Open Punctuation 11
 
0.2%
Close Punctuation 10
 
0.2%
Lowercase Letter 2
 
< 0.1%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 255
 
8.5%
사 200
 
6.7%
천 197
 
6.6%
동 146
 
4.9%
로 91
 
3.0%
길 86
 
2.9%
산 82
 
2.7%
남 81
 
2.7%
구 81
 
2.7%
면 64
 
2.1%
Other values (240) 1708
57.1%
Decimal Number
ValueCountFrequency (%)
1 245
25.2%
0 158
16.3%
2 129
13.3%
3 105
10.8%
4 81
 
8.3%
5 61
 
6.3%
7 58
 
6.0%
9 53
 
5.5%
8 46
 
4.7%
6 35
 
3.6%
Other Punctuation
ValueCountFrequency (%)
. 24
43.6%
, 21
38.2%
@ 9
 
16.4%
/ 1
 
1.8%
Open Punctuation
ValueCountFrequency (%)
( 10
90.9%
[ 1
 
9.1%
Close Punctuation
ValueCountFrequency (%)
) 9
90.0%
] 1
 
10.0%
Space Separator
ValueCountFrequency (%)
605
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 67
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 2
100.0%
Uppercase Letter
ValueCountFrequency (%)
W 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2991
63.5%
Common 1719
36.5%
Latin 3
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 255
 
8.5%
사 200
 
6.7%
천 197
 
6.6%
동 146
 
4.9%
로 91
 
3.0%
길 86
 
2.9%
산 82
 
2.7%
남 81
 
2.7%
구 81
 
2.7%
면 64
 
2.1%
Other values (240) 1708
57.1%
Common
ValueCountFrequency (%)
605
35.2%
1 245
14.3%
0 158
 
9.2%
2 129
 
7.5%
3 105
 
6.1%
4 81
 
4.7%
- 67
 
3.9%
5 61
 
3.5%
7 58
 
3.4%
9 53
 
3.1%
Other values (10) 157
 
9.1%
Latin
ValueCountFrequency (%)
e 2
66.7%
W 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2984
63.3%
ASCII 1722
36.5%
Compat Jamo 5
 
0.1%
Jamo 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
605
35.1%
1 245
14.2%
0 158
 
9.2%
2 129
 
7.5%
3 105
 
6.1%
4 81
 
4.7%
- 67
 
3.9%
5 61
 
3.5%
7 58
 
3.4%
9 53
 
3.1%
Other values (12) 160
 
9.3%
Hangul
ValueCountFrequency (%)
시 255
 
8.5%
사 200
 
6.7%
천 197
 
6.6%
동 146
 
4.9%
로 91
 
3.0%
길 86
 
2.9%
산 82
 
2.7%
남 81
 
2.7%
구 81
 
2.7%
면 64
 
2.1%
Other values (236) 1701
57.0%
Compat Jamo
ValueCountFrequency (%)
ㅡ 2
40.0%
ㅎ 2
40.0%
ㅗ 1
20.0%
Jamo
ValueCountFrequency (%)
ᆞ 2
100.0%

예약일자
Date

Distinct657
Distinct (%)76.0%
Missing1
Missing (%)0.1%
Memory size6.9 KiB
Minimum2013-09-24 00:00:00
Maximum2021-06-05 00:00:00
2023-12-11T09:58:25.188643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:25.319165image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

성인 명 수
Real number (ℝ)

ZEROS 

Distinct57
Distinct (%)6.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15.186127
Minimum0
Maximum200
Zeros108
Zeros (%)12.5%
Negative0
Negative (%)0.0%
Memory size7.7 KiB
2023-12-11T09:58:25.461486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q11
median4
Q325
95-th percentile44.6
Maximum200
Range200
Interquartile range (IQR)24

Descriptive statistics

Standard deviation22.41344
Coefficient of variation (CV)1.4759155
Kurtosis16.805857
Mean15.186127
Median Absolute Deviation (MAD)4
Skewness3.1708391
Sum13136
Variance502.36231
MonotonicityNot monotonic
2023-12-11T09:58:25.627158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2 149
17.2%
1 124
14.3%
0 108
12.5%
40 104
12.0%
3 44
 
5.1%
20 43
 
5.0%
5 31
 
3.6%
30 30
 
3.5%
4 27
 
3.1%
10 27
 
3.1%
Other values (47) 178
20.6%
ValueCountFrequency (%)
0 108
12.5%
1 124
14.3%
2 149
17.2%
3 44
 
5.1%
4 27
 
3.1%
5 31
 
3.6%
6 7
 
0.8%
7 5
 
0.6%
8 7
 
0.8%
9 4
 
0.5%
ValueCountFrequency (%)
200 2
 
0.2%
174 1
 
0.1%
150 2
 
0.2%
103 2
 
0.2%
100 2
 
0.2%
90 3
 
0.3%
81 1
 
0.1%
80 11
1.3%
75 1
 
0.1%
70 2
 
0.2%

미성년자 명 수
Real number (ℝ)

ZEROS 

Distinct29
Distinct (%)3.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.4
Minimum0
Maximum70
Zeros712
Zeros (%)82.3%
Negative0
Negative (%)0.0%
Memory size7.7 KiB
2023-12-11T09:58:25.749695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile35
Maximum70
Range70
Interquartile range (IQR)0

Descriptive statistics

Standard deviation10.098336
Coefficient of variation (CV)2.9700988
Kurtosis8.6895407
Mean3.4
Median Absolute Deviation (MAD)0
Skewness3.0909274
Sum2941
Variance101.97639
MonotonicityNot monotonic
2023-12-11T09:58:25.866762image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)
ValueCountFrequency (%)
0 712
82.3%
40 37
 
4.3%
2 30
 
3.5%
1 21
 
2.4%
24 11
 
1.3%
20 7
 
0.8%
3 5
 
0.6%
26 4
 
0.5%
33 3
 
0.3%
38 3
 
0.3%
Other values (19) 32
 
3.7%
ValueCountFrequency (%)
0 712
82.3%
1 21
 
2.4%
2 30
 
3.5%
3 5
 
0.6%
4 3
 
0.3%
5 3
 
0.3%
7 1
 
0.1%
8 1
 
0.1%
10 2
 
0.2%
12 3
 
0.3%
ValueCountFrequency (%)
70 1
 
0.1%
40 37
4.3%
38 3
 
0.3%
37 1
 
0.1%
36 1
 
0.1%
35 3
 
0.3%
33 3
 
0.3%
30 2
 
0.2%
29 1
 
0.1%
27 1
 
0.1%

기타 명 수
Real number (ℝ)

ZEROS 

Distinct33
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.7098266
Minimum0
Maximum70
Zeros647
Zeros (%)74.8%
Negative0
Negative (%)0.0%
Memory size7.7 KiB
2023-12-11T09:58:26.009027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q31
95-th percentile30
Maximum70
Range70
Interquartile range (IQR)1

Descriptive statistics

Standard deviation9.4586188
Coefficient of variation (CV)2.5496121
Kurtosis8.3147784
Mean3.7098266
Median Absolute Deviation (MAD)0
Skewness2.8902389
Sum3209
Variance89.46547
MonotonicityNot monotonic
2023-12-11T09:58:26.396744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=33)
ValueCountFrequency (%)
0 647
74.8%
1 51
 
5.9%
20 29
 
3.4%
40 22
 
2.5%
2 21
 
2.4%
30 16
 
1.8%
10 10
 
1.2%
3 8
 
0.9%
5 8
 
0.9%
15 6
 
0.7%
Other values (23) 47
 
5.4%
ValueCountFrequency (%)
0 647
74.8%
1 51
 
5.9%
2 21
 
2.4%
3 8
 
0.9%
4 2
 
0.2%
5 8
 
0.9%
6 3
 
0.3%
7 3
 
0.3%
8 2
 
0.2%
10 10
 
1.2%
ValueCountFrequency (%)
70 1
 
0.1%
40 22
2.5%
38 3
 
0.3%
35 3
 
0.3%
32 1
 
0.1%
30 16
1.8%
28 1
 
0.1%
27 2
 
0.2%
26 1
 
0.1%
25 3
 
0.3%

가격
Real number (ℝ)

ZEROS 

Distinct115
Distinct (%)13.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean74705.78
Minimum0
Maximum450000
Zeros95
Zeros (%)11.0%
Negative0
Negative (%)0.0%
Memory size7.7 KiB
2023-12-11T09:58:26.539503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q110000
median42000
Q3120000
95-th percentile200000
Maximum450000
Range450000
Interquartile range (IQR)110000

Descriptive statistics

Standard deviation81196.702
Coefficient of variation (CV)1.0868865
Kurtosis1.8202741
Mean74705.78
Median Absolute Deviation (MAD)38000
Skewness1.337304
Sum64620500
Variance6.5929044 × 109
MonotonicityNot monotonic
2023-12-11T09:58:26.666937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 95
 
11.0%
200000 79
 
9.1%
10000 65
 
7.5%
5000 49
 
5.7%
100000 34
 
3.9%
40000 25
 
2.9%
80000 25
 
2.9%
15000 23
 
2.7%
7000 21
 
2.4%
20000 20
 
2.3%
Other values (105) 429
49.6%
ValueCountFrequency (%)
0 95
11.0%
2000 8
 
0.9%
4000 6
 
0.7%
5000 49
5.7%
6000 1
 
0.1%
7000 21
 
2.4%
8000 5
 
0.6%
9000 2
 
0.2%
9500 4
 
0.5%
10000 65
7.5%
ValueCountFrequency (%)
450000 1
 
0.1%
400000 8
0.9%
300000 5
0.6%
280000 9
1.0%
275000 1
 
0.1%
250000 2
 
0.2%
241000 1
 
0.1%
225000 3
 
0.3%
215000 2
 
0.2%
210000 11
1.3%

등록일
Date

Distinct837
Distinct (%)96.8%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
Minimum2013-08-30 14:45:00
Maximum2021-06-02 18:32:00
2023-12-11T09:58:26.791458image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:26.929077image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-11T09:58:22.815302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:21.106091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:21.550738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:22.002439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:22.404526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:22.911733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:21.210810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:21.658673image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:22.078674image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:22.479538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:23.003294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:21.305273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:21.750432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:22.163869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:22.565121image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:23.138335image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:21.383070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:21.838876image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:22.245967image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:22.650349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:23.245968image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:21.473183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:21.929809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:22.331051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:58:22.733317image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T09:58:27.014303image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
예약 구분상태제목성인 명 수미성년자 명 수기타 명 수가격
예약 구분1.0000.5250.4710.0000.1340.1790.149
상태0.5251.0000.3290.3220.2510.1870.489
제목0.4710.3291.0000.335NaNNaNNaN
성인 명 수0.0000.3220.3351.0000.0000.1110.852
미성년자 명 수0.1340.251NaN0.0001.0000.0000.610
기타 명 수0.1790.187NaN0.1110.0001.0000.335
가격0.1490.489NaN0.8520.6100.3351.000
2023-12-11T09:58:27.149953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
예약 구분상태
예약 구분1.0000.219
상태0.2191.000
2023-12-11T09:58:27.253322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
제목성인 명 수미성년자 명 수기타 명 수가격예약 구분상태
제목1.0000.114NaNNaNNaN0.2260.144
성인 명 수0.1141.000-0.270-0.4040.3620.0000.156
미성년자 명 수NaN-0.2701.000-0.1340.1790.0910.171
기타 명 수NaN-0.404-0.1341.000-0.0030.1170.122
가격NaN0.3620.179-0.0031.0000.0650.246
예약 구분0.2260.0000.0910.1170.0651.0000.219
상태0.1440.1560.1710.1220.2460.2191.000

Missing values

2023-12-11T09:58:23.376043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T09:58:23.569802image/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.
2023-12-11T09:58:23.686229image/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

예약 구분상태관리자 텍스트비밀 yngidpos깊이조회수제목내용예약일자성인 명 수미성년자 명 수기타 명 수가격등록일
0INSY<NA><NA><NA><NA><NA><NA>14<NA>2013/09/24900002013-08-30 14:45:00
1INSY<NA><NA><NA><NA><NA><NA><NA><NA>2013/10/20220900002013-10-06 19:16:00
2INSY<NA><NA><NA><NA><NA><NA>11<NA>2013/10/251740002013-10-07 14:57:00
3INSY<NA><NA><NA><NA><NA><NA><NA><NA>2013/10/20221840002013-10-15 19:04:00
4INSY<NA><NA><NA><NA><NA><NA>9투어2013/11/30250002013-10-23 11:00:00
5INSY<NA><NA><NA><NA><NA><NA>9시티투어2013/10/25400002013-10-23 13:50:00
6INSY<NA><NA><NA><NA><NA><NA>9박물관, 과학관2013/11/12810002013-11-05 13:04:00
7INSY<NA><NA><NA><NA><NA><NA>11박물관,과학관2013/11/09500002013-11-05 13:04:00
8INSY<NA><NA><NA><NA><NA><NA>14<NA>2013/11/30300002013-11-05 17:26:00
9INSY<NA><NA><NA><NA><NA><NA>15<NA>2013/11/09320002013-11-05 17:27:00
예약 구분상태관리자 텍스트비밀 yngidpos깊이조회수제목내용예약일자성인 명 수미성년자 명 수기타 명 수가격등록일
855MOD<NA><NA><NA><NA><NA><NA><NA><NA>창원시 마산합포구 문화북3길472020/09/0110270002020-08-27 09:29:00
856MOD<NA><NA><NA><NA><NA><NA><NA><NA>마산합포구 문화동2020/09/01202140002020-08-27 10:28:00
857DEL<NA><NA><NA><NA><NA><NA><NA><NA>창원시 마산합포구2020/11/27101140002020-08-27 10:31:00
858INSN<NA><NA><NA><NA><NA><NA><NA><NA>2020/11/08300150002020-10-26 17:59:00
859MODN<NA><NA><NA><NA><NA><NA><NA>마산합포구 문화동2020/11/0410170002020-10-29 19:21:00
860INSN<NA><NA><NA><NA><NA><NA><NA><NA>2020/11/0810050002020-11-02 11:12:00
861INSRSV<NA><NA><NA><NA><NA><NA><NA><NA>2020/11/27400200002020-11-05 21:04:00
862INSRSV<NA><NA><NA><NA><NA><NA><NA><NA>2020/12/12400200002020-11-05 21:07:00
863INSRSV<NA><NA><NA><NA><NA><NA><NA><NA>2020/12/1210170002020-11-19 14:40:00
864INSRSV<NA><NA><NA><NA><NA><NA><NA><NA>2021/06/0510050002021-06-02 18:32:00

Duplicate rows

Most frequently occurring

예약 구분상태제목내용예약일자성인 명 수미성년자 명 수기타 명 수가격등록일# duplicates
1INSRSV<NA><NA>2019/07/1910050002019-07-17 13:29:004
0INSN<NA><NA>2014/11/22201180002014-11-19 17:35:002