Overview

Dataset statistics

Number of variables10
Number of observations3477
Missing cells5272
Missing cells (%)15.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory288.7 KiB
Average record size in memory85.0 B

Variable types

Numeric4
Text1
Categorical4
Boolean1

Dataset

Description전북특별자치도 전주시에 위치한 식당의 품질정보를 제공하며 식당명, 어워드정보, RTI지수, 온라인화진행여부, 수용태세지수, 인기도 등을 제공합니다.항목 : 식당명, 지역명, 어워드정보, RTI 지수, 온라인화진행여부, 트립어드바이저평점, 씨트립평점, 네이버평점 등담당부서: 환경위생과
Author전북특별자치도 전주시
URLhttps://www.data.go.kr/data/15099652/fileData.do

Alerts

온라인화진행여부 is highly overall correlated with 식당(ID) and 4 other fieldsHigh correlation
어워드정보설명 is highly overall correlated with 지역명High correlation
씨트립평점 is highly overall correlated with 식당(ID) and 5 other fieldsHigh correlation
지역명 is highly overall correlated with 식당(ID) and 7 other fieldsHigh correlation
식당상태 is highly overall correlated with 식당(ID) and 4 other fieldsHigh correlation
식당(ID) is highly overall correlated with 지역명 and 3 other fieldsHigh correlation
임대업이자상환비율(RTI) is highly overall correlated with 트립어드바이저평점 and 3 other fieldsHigh correlation
트립어드바이저평점 is highly overall correlated with 임대업이자상환비율(RTI) and 3 other fieldsHigh correlation
네이버평점 is highly overall correlated with 임대업이자상환비율(RTI) and 2 other fieldsHigh correlation
지역명 is highly imbalanced (99.6%)Imbalance
어워드정보설명 is highly imbalanced (85.8%)Imbalance
씨트립평점 is highly imbalanced (99.3%)Imbalance
임대업이자상환비율(RTI) has 1031 (29.7%) missing valuesMissing
트립어드바이저평점 has 3302 (95.0%) missing valuesMissing
네이버평점 has 939 (27.0%) missing valuesMissing
식당(ID) has unique valuesUnique

Reproduction

Analysis started2024-03-14 15:09:23.637247
Analysis finished2024-03-14 15:09:29.167233
Duration5.53 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

식당(ID)
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct3477
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean591389.67
Minimum1606
Maximum971513
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size30.7 KiB
2024-03-15T00:09:29.410122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1606
5-th percentile92399.6
Q1368562
median631329
Q3863712
95-th percentile954266.2
Maximum971513
Range969907
Interquartile range (IQR)495150

Descriptive statistics

Standard deviation282690.59
Coefficient of variation (CV)0.47801071
Kurtosis-1.1037317
Mean591389.67
Median Absolute Deviation (MAD)233323
Skewness-0.39100456
Sum2.0562619 × 109
Variance7.9913971 × 1010
MonotonicityNot monotonic
2024-03-15T00:09:29.867223image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2691 1
 
< 0.1%
831519 1
 
< 0.1%
825712 1
 
< 0.1%
826349 1
 
< 0.1%
827149 1
 
< 0.1%
827365 1
 
< 0.1%
827774 1
 
< 0.1%
829910 1
 
< 0.1%
830091 1
 
< 0.1%
830801 1
 
< 0.1%
Other values (3467) 3467
99.7%
ValueCountFrequency (%)
1606 1
< 0.1%
1681 1
< 0.1%
2691 1
< 0.1%
2999 1
< 0.1%
3101 1
< 0.1%
3103 1
< 0.1%
4121 1
< 0.1%
4124 1
< 0.1%
4465 1
< 0.1%
4995 1
< 0.1%
ValueCountFrequency (%)
971513 1
< 0.1%
971502 1
< 0.1%
971476 1
< 0.1%
971435 1
< 0.1%
971407 1
< 0.1%
971250 1
< 0.1%
970889 1
< 0.1%
970671 1
< 0.1%
970502 1
< 0.1%
970402 1
< 0.1%

식당명
Text

Distinct3440
Distinct (%)98.9%
Missing0
Missing (%)0.0%
Memory size27.3 KiB
2024-03-15T00:09:31.039948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length18
Mean length7.1012367
Min length1

Characters and Unicode

Total characters24691
Distinct characters862
Distinct categories12 ?
Distinct scripts4 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique3403 ?
Unique (%)97.9%

Sample

1st row한국식당
2nd rowPNB풍년제과 본점
3rd row태봉집
4th row한미반점
5th row메르밀 진미집
ValueCountFrequency (%)
송천점 73
 
1.5%
전북대점 70
 
1.4%
효자점 37
 
0.8%
전주효자점 35
 
0.7%
서신점 34
 
0.7%
전주송천점 31
 
0.6%
삼천점 30
 
0.6%
전주대점 28
 
0.6%
이디야커피 27
 
0.6%
전주점 26
 
0.5%
Other values (3385) 4489
92.0%
2024-03-15T00:09:32.621432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1446
 
5.9%
점 1347
 
5.5%
전 744
 
3.0%
주 616
 
2.5%
이 477
 
1.9%
스 341
 
1.4%
리 341
 
1.4%
피 320
 
1.3%
가 310
 
1.3%
천 300
 
1.2%
Other values (852) 18449
74.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 22266
90.2%
Space Separator 1446
 
5.9%
Decimal Number 342
 
1.4%
Uppercase Letter 342
 
1.4%
Lowercase Letter 171
 
0.7%
Other Punctuation 58
 
0.2%
Open Punctuation 20
 
0.1%
Close Punctuation 20
 
0.1%
Control 14
 
0.1%
Dash Punctuation 8
 
< 0.1%
Other values (2) 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 1347
 
6.0%
전 744
 
3.3%
주 616
 
2.8%
이 477
 
2.1%
스 341
 
1.5%
리 341
 
1.5%
피 320
 
1.4%
가 310
 
1.4%
천 300
 
1.3%
자 292
 
1.3%
Other values (781) 17178
77.1%
Uppercase Letter
ValueCountFrequency (%)
C 43
12.6%
E 42
12.3%
B 28
 
8.2%
F 27
 
7.9%
O 26
 
7.6%
A 23
 
6.7%
N 14
 
4.1%
L 14
 
4.1%
S 13
 
3.8%
T 12
 
3.5%
Other values (14) 100
29.2%
Lowercase Letter
ValueCountFrequency (%)
e 24
14.0%
o 21
12.3%
a 20
11.7%
f 15
 
8.8%
c 14
 
8.2%
s 12
 
7.0%
t 8
 
4.7%
r 6
 
3.5%
n 6
 
3.5%
i 6
 
3.5%
Other values (14) 39
22.8%
Decimal Number
ValueCountFrequency (%)
1 83
24.3%
2 54
15.8%
0 38
11.1%
9 34
9.9%
3 33
 
9.6%
5 30
 
8.8%
4 22
 
6.4%
8 17
 
5.0%
6 17
 
5.0%
7 14
 
4.1%
Other Punctuation
ValueCountFrequency (%)
& 36
62.1%
, 10
 
17.2%
. 5
 
8.6%
# 4
 
6.9%
; 2
 
3.4%
? 1
 
1.7%
Space Separator
ValueCountFrequency (%)
1446
100.0%
Open Punctuation
ValueCountFrequency (%)
( 20
100.0%
Close Punctuation
ValueCountFrequency (%)
) 20
100.0%
Control
ValueCountFrequency (%)
14
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%
Final Punctuation
ValueCountFrequency (%)
’ 3
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 22262
90.2%
Common 1912
 
7.7%
Latin 513
 
2.1%
Han 4
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 1347
 
6.1%
전 744
 
3.3%
주 616
 
2.8%
이 477
 
2.1%
스 341
 
1.5%
리 341
 
1.5%
피 320
 
1.4%
가 310
 
1.4%
천 300
 
1.3%
자 292
 
1.3%
Other values (777) 17174
77.1%
Latin
ValueCountFrequency (%)
C 43
 
8.4%
E 42
 
8.2%
B 28
 
5.5%
F 27
 
5.3%
O 26
 
5.1%
e 24
 
4.7%
A 23
 
4.5%
o 21
 
4.1%
a 20
 
3.9%
f 15
 
2.9%
Other values (38) 244
47.6%
Common
ValueCountFrequency (%)
1446
75.6%
1 83
 
4.3%
2 54
 
2.8%
0 38
 
2.0%
& 36
 
1.9%
9 34
 
1.8%
3 33
 
1.7%
5 30
 
1.6%
4 22
 
1.2%
( 20
 
1.0%
Other values (13) 116
 
6.1%
Han
ValueCountFrequency (%)
愛 1
25.0%
眞 1
25.0%
酒 1
25.0%
熟 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 22262
90.2%
ASCII 2422
 
9.8%
CJK 4
 
< 0.1%
Punctuation 3
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1446
59.7%
1 83
 
3.4%
2 54
 
2.2%
C 43
 
1.8%
E 42
 
1.7%
0 38
 
1.6%
& 36
 
1.5%
9 34
 
1.4%
3 33
 
1.4%
5 30
 
1.2%
Other values (60) 583
24.1%
Hangul
ValueCountFrequency (%)
점 1347
 
6.1%
전 744
 
3.3%
주 616
 
2.8%
이 477
 
2.1%
스 341
 
1.5%
리 341
 
1.5%
피 320
 
1.4%
가 310
 
1.4%
천 300
 
1.3%
자 292
 
1.3%
Other values (777) 17174
77.1%
Punctuation
ValueCountFrequency (%)
’ 3
100.0%
CJK
ValueCountFrequency (%)
愛 1
25.0%
眞 1
25.0%
酒 1
25.0%
熟 1
25.0%

지역명
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size27.3 KiB
전북특별자치도 전주시
3476 
<NA>
 
1

Length

Max length11
Median length11
Mean length10.997987
Min length4

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row전북특별자치도 전주시
2nd row전북특별자치도 전주시
3rd row전북특별자치도 전주시
4th row전북특별자치도 전주시
5th row전북특별자치도 전주시

Common Values

ValueCountFrequency (%)
전북특별자치도 전주시 3476
> 99.9%
<NA> 1
 
< 0.1%

Length

2024-03-15T00:09:33.071734image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T00:09:33.408757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전북특별자치도 3476
50.0%
전주시 3476
50.0%
na 1
 
< 0.1%

어워드정보설명
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct4
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size27.3 KiB
<NA>
3347 
안심식당
 
67
모범음식점,안심식당
 
41
모범음식점
 
22

Length

Max length10
Median length4
Mean length4.0770779
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row안심식당
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 3347
96.3%
안심식당 67
 
1.9%
모범음식점,안심식당 41
 
1.2%
모범음식점 22
 
0.6%

Length

2024-03-15T00:09:33.767003image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T00:09:34.111650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 3347
96.3%
안심식당 67
 
1.9%
모범음식점,안심식당 41
 
1.2%
모범음식점 22
 
0.6%

임대업이자상환비율(RTI)
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct14
Distinct (%)0.6%
Missing1031
Missing (%)29.7%
Infinite0
Infinite (%)0.0%
Mean0.10401881
Minimum0.07
Maximum0.28
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size30.7 KiB
2024-03-15T00:09:34.423393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.07
5-th percentile0.09
Q10.1
median0.1
Q30.1
95-th percentile0.18
Maximum0.28
Range0.21
Interquartile range (IQR)0

Descriptive statistics

Standard deviation0.024085695
Coefficient of variation (CV)0.23155135
Kurtosis10.168732
Mean0.10401881
Median Absolute Deviation (MAD)0
Skewness3.2558708
Sum254.43
Variance0.00058012071
MonotonicityNot monotonic
2024-03-15T00:09:34.764012image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%)
0.1 1558
44.8%
0.09 560
 
16.1%
0.11 113
 
3.2%
0.19 44
 
1.3%
0.18 40
 
1.2%
0.08 34
 
1.0%
0.21 28
 
0.8%
0.2 25
 
0.7%
0.16 22
 
0.6%
0.17 10
 
0.3%
Other values (4) 12
 
0.3%
(Missing) 1031
29.7%
ValueCountFrequency (%)
0.07 6
 
0.2%
0.08 34
 
1.0%
0.09 560
 
16.1%
0.1 1558
44.8%
0.11 113
 
3.2%
0.14 3
 
0.1%
0.15 2
 
0.1%
0.16 22
 
0.6%
0.17 10
 
0.3%
0.18 40
 
1.2%
ValueCountFrequency (%)
0.28 1
 
< 0.1%
0.21 28
 
0.8%
0.2 25
 
0.7%
0.19 44
 
1.3%
0.18 40
 
1.2%
0.17 10
 
0.3%
0.16 22
 
0.6%
0.15 2
 
0.1%
0.14 3
 
0.1%
0.11 113
3.2%

온라인화진행여부
Boolean

HIGH CORRELATION 

Distinct2
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size3.5 KiB
True
2149 
False
1328 
ValueCountFrequency (%)
True 2149
61.8%
False 1328
38.2%
2024-03-15T00:09:35.067670image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

트립어드바이저평점
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct8
Distinct (%)4.6%
Missing3302
Missing (%)95.0%
Infinite0
Infinite (%)0.0%
Mean4.0142857
Minimum1
Maximum5
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size30.7 KiB
2024-03-15T00:09:35.372186image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3
Q14
median4
Q34.5
95-th percentile5
Maximum5
Range4
Interquartile range (IQR)0.5

Descriptive statistics

Standard deviation0.71403937
Coefficient of variation (CV)0.17787458
Kurtosis1.148559
Mean4.0142857
Median Absolute Deviation (MAD)0.5
Skewness-0.69748442
Sum702.5
Variance0.50985222
MonotonicityNot monotonic
2024-03-15T00:09:35.752629image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
4.0 76
 
2.2%
5.0 33
 
0.9%
3.0 28
 
0.8%
4.5 23
 
0.7%
3.5 11
 
0.3%
2.0 2
 
0.1%
1.0 1
 
< 0.1%
2.5 1
 
< 0.1%
(Missing) 3302
95.0%
ValueCountFrequency (%)
1.0 1
 
< 0.1%
2.0 2
 
0.1%
2.5 1
 
< 0.1%
3.0 28
 
0.8%
3.5 11
 
0.3%
4.0 76
2.2%
4.5 23
 
0.7%
5.0 33
0.9%
ValueCountFrequency (%)
5.0 33
0.9%
4.5 23
 
0.7%
4.0 76
2.2%
3.5 11
 
0.3%
3.0 28
 
0.8%
2.5 1
 
< 0.1%
2.0 2
 
0.1%
1.0 1
 
< 0.1%

씨트립평점
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size27.3 KiB
<NA>
3475 
4.3
 
2

Length

Max length4
Median length4
Mean length3.9994248
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 3475
99.9%
4.3 2
 
0.1%

Length

2024-03-15T00:09:36.181744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T00:09:36.508495image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 3475
99.9%
4.3 2
 
0.1%

네이버평점
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct166
Distinct (%)6.5%
Missing939
Missing (%)27.0%
Infinite0
Infinite (%)0.0%
Mean4.2996493
Minimum0.1
Maximum5
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size30.7 KiB
2024-03-15T00:09:36.856138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.1
5-th percentile3.9485
Q14.25
median4.36
Q34.47
95-th percentile4.73
Maximum5
Range4.9
Interquartile range (IQR)0.22

Descriptive statistics

Standard deviation0.52491822
Coefficient of variation (CV)0.12208396
Kurtosis34.121366
Mean4.2996493
Median Absolute Deviation (MAD)0.11
Skewness-5.3289742
Sum10912.51
Variance0.27553914
MonotonicityNot monotonic
2024-03-15T00:09:37.301657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4.29 75
 
2.2%
4.4 67
 
1.9%
4.39 67
 
1.9%
4.37 66
 
1.9%
4.44 65
 
1.9%
4.5 65
 
1.9%
4.32 65
 
1.9%
4.36 63
 
1.8%
4.3 62
 
1.8%
4.35 62
 
1.8%
Other values (156) 1881
54.1%
(Missing) 939
27.0%
ValueCountFrequency (%)
0.1 1
 
< 0.1%
0.15 2
 
0.1%
0.21 7
0.2%
0.33 1
 
< 0.1%
0.39 1
 
< 0.1%
0.5 2
 
0.1%
0.56 2
 
0.1%
0.62 2
 
0.1%
0.68 1
 
< 0.1%
0.79 2
 
0.1%
ValueCountFrequency (%)
5.0 51
1.5%
4.97 1
 
< 0.1%
4.94 1
 
< 0.1%
4.93 2
 
0.1%
4.92 2
 
0.1%
4.91 1
 
< 0.1%
4.9 2
 
0.1%
4.89 1
 
< 0.1%
4.88 1
 
< 0.1%
4.87 2
 
0.1%

식당상태
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size27.3 KiB
운영중
2644 
신규
505 
미확인
 
235
폐업
 
93

Length

Max length3
Median length3
Mean length2.8280127
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row운영중
2nd row운영중
3rd row운영중
4th row운영중
5th row운영중

Common Values

ValueCountFrequency (%)
운영중 2644
76.0%
신규 505
 
14.5%
미확인 235
 
6.8%
폐업 93
 
2.7%

Length

2024-03-15T00:09:37.940410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T00:09:38.268470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
운영중 2644
76.0%
신규 505
 
14.5%
미확인 235
 
6.8%
폐업 93
 
2.7%

Interactions

2024-03-15T00:09:27.214569image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T00:09:24.769126image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T00:09:25.722390image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T00:09:26.443370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T00:09:27.375719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T00:09:25.028931image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T00:09:25.946728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T00:09:26.603819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T00:09:27.539280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T00:09:25.277491image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T00:09:26.088278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T00:09:26.775875image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T00:09:27.740570image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T00:09:25.543794image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T00:09:26.268490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T00:09:27.010559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T00:09:38.487343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
식당(ID)어워드정보설명임대업이자상환비율(RTI)온라인화진행여부트립어드바이저평점네이버평점식당상태
식당(ID)1.0000.2620.2040.8270.4820.2600.727
어워드정보설명0.2621.0000.0000.0500.0000.0000.073
임대업이자상환비율(RTI)0.2040.0001.0000.1000.9160.3420.101
온라인화진행여부0.8270.0500.1001.000NaN0.5580.889
트립어드바이저평점0.4820.0000.916NaN1.0000.7480.868
네이버평점0.2600.0000.3420.5580.7481.0000.686
식당상태0.7270.0730.1010.8890.8680.6861.000
2024-03-15T00:09:38.796820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
온라인화진행여부어워드정보설명씨트립평점지역명식당상태
온라인화진행여부1.0000.0821.0001.0000.698
어워드정보설명0.0821.000NaN1.0000.120
씨트립평점1.000NaN1.0001.0001.000
지역명1.0001.0001.0001.0001.000
식당상태0.6980.1201.0001.0001.000
2024-03-15T00:09:39.087570image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
식당(ID)임대업이자상환비율(RTI)트립어드바이저평점네이버평점지역명어워드정보설명온라인화진행여부씨트립평점식당상태
식당(ID)1.0000.0050.0170.1851.0000.1560.6591.0000.531
임대업이자상환비율(RTI)0.0051.0000.9360.6471.0000.0000.1071.0000.108
트립어드바이저평점0.0170.9361.0000.1901.0000.0001.000NaN0.678
네이버평점0.1850.6470.1901.0001.0000.0000.4341.0000.488
지역명1.0001.0001.0001.0001.0001.0001.0001.0001.000
어워드정보설명0.1560.0000.0000.0001.0001.0000.082NaN0.120
온라인화진행여부0.6590.1071.0000.4341.0000.0821.0001.0000.698
씨트립평점1.0001.000NaN1.0001.000NaN1.0001.0001.000
식당상태0.5310.1080.6780.4881.0000.1200.6981.0001.000

Missing values

2024-03-15T00:09:28.099203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T00:09:28.590584image/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.
2024-03-15T00:09:28.964202image/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

식당(ID)식당명지역명어워드정보설명임대업이자상환비율(RTI)온라인화진행여부트립어드바이저평점씨트립평점네이버평점식당상태
02691한국식당전북특별자치도 전주시안심식당0.18Y4.0<NA>4.18운영중
13101PNB풍년제과 본점전북특별자치도 전주시<NA>0.2Y4.5<NA>4.37운영중
24121태봉집전북특별자치도 전주시<NA>0.14Y2.0<NA>4.17운영중
34997한미반점전북특별자치도 전주시<NA>0.16Y3.0<NA>4.0운영중
47242메르밀 진미집전북특별자치도 전주시<NA>0.18Y4.0<NA>4.3운영중
58797성미당전북특별자치도 전주시안심식당0.19Y4.5<NA>4.09운영중
68799또순이네집전북특별자치도 전주시<NA>0.18Y3.5<NA>4.41운영중
78805덕천식당전북특별자치도 전주시<NA>0.21Y5.0<NA>4.59운영중
810455반야돌솥밥전북특별자치도 전주시모범음식점0.18Y4.0<NA>4.13운영중
912144계수나무전북특별자치도 전주시<NA>0.19Y4.0<NA>4.53운영중
식당(ID)식당명지역명어워드정보설명임대업이자상환비율(RTI)온라인화진행여부트립어드바이저평점씨트립평점네이버평점식당상태
3467970402한잔어때 가맥전북특별자치도 전주시<NA><NA>N<NA><NA><NA>신규
3468970502다원밥상전북특별자치도 전주시<NA><NA>N<NA><NA><NA>신규
3469970671티엠씨(TMC)전북특별자치도 전주시<NA><NA>N<NA><NA><NA>신규
34709708891도씨맥주 우아점전북특별자치도 전주시<NA>0.08N<NA><NA>3.68신규
3471971250피자컴퍼니 효자점전북특별자치도 전주시<NA>0.1N<NA><NA>4.69신규
3472971407동쿡전북특별자치도 전주시<NA>0.11N<NA><NA>5.0신규
3473971435윤이네낙곱새전북특별자치도 전주시<NA>0.1N<NA><NA>4.5신규
3474971476만계치킨 완산구점전북특별자치도 전주시<NA>0.09N<NA><NA>4.13신규
3475971502일미리 금계찜닭 효자효천점전북특별자치도 전주시<NA>0.1N<NA><NA>4.72신규
3476971513피슈마라홍탕 효자점전북특별자치도 전주시<NA>0.11N<NA><NA>4.85신규