Overview

Dataset statistics

Number of variables9
Number of observations2244
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory168.9 KiB
Average record size in memory77.1 B

Variable types

Numeric4
Categorical4
DateTime1

Dataset

Description대전광역시 서구 상권별 영업상태별 업소현황(상권코드, 상권명, 행정동코드, 행정동명, 영업상태코드, 영업상태, 인허가업소수 등) 데이터를 제공합니다.
Author대전광역시 서구
URLhttps://www.data.go.kr/data/15109025/fileData.do

Alerts

데이터생성일자 has constant value ""Constant
영업상태명 is highly overall correlated with 순번 and 1 other fieldsHigh correlation
영업상태코드 is highly overall correlated with 순번 and 1 other fieldsHigh correlation
순번 is highly overall correlated with 영업상태코드 and 1 other fieldsHigh correlation
상권코드 is highly overall correlated with 상권명 and 1 other fieldsHigh correlation
행정동코드 is highly overall correlated with 상권명 and 1 other fieldsHigh correlation
상권명 is highly overall correlated with 상권코드 and 2 other fieldsHigh correlation
행정동명 is highly overall correlated with 상권코드 and 2 other fieldsHigh correlation
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 15:58:09.325369
Analysis finished2023-12-12 15:58:12.022689
Duration2.7 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct2244
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1122.5
Minimum1
Maximum2244
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size19.9 KiB
2023-12-13T00:58:12.101171image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile113.15
Q1561.75
median1122.5
Q31683.25
95-th percentile2131.85
Maximum2244
Range2243
Interquartile range (IQR)1121.5

Descriptive statistics

Standard deviation647.93132
Coefficient of variation (CV)0.57722167
Kurtosis-1.2
Mean1122.5
Median Absolute Deviation (MAD)561
Skewness0
Sum2518890
Variance419815
MonotonicityStrictly increasing
2023-12-13T00:58:12.240499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
1501 1
 
< 0.1%
1495 1
 
< 0.1%
1496 1
 
< 0.1%
1497 1
 
< 0.1%
1498 1
 
< 0.1%
1499 1
 
< 0.1%
1500 1
 
< 0.1%
1502 1
 
< 0.1%
1493 1
 
< 0.1%
Other values (2234) 2234
99.6%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
ValueCountFrequency (%)
2244 1
< 0.1%
2243 1
< 0.1%
2242 1
< 0.1%
2241 1
< 0.1%
2240 1
< 0.1%
2239 1
< 0.1%
2238 1
< 0.1%
2237 1
< 0.1%
2236 1
< 0.1%
2235 1
< 0.1%

상권코드
Real number (ℝ)

HIGH CORRELATION 

Distinct14
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7.3324421
Minimum1
Maximum14
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size19.9 KiB
2023-12-13T00:58:12.356273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q14
median7
Q311
95-th percentile14
Maximum14
Range13
Interquartile range (IQR)7

Descriptive statistics

Standard deviation4.1191569
Coefficient of variation (CV)0.56177149
Kurtosis-1.387267
Mean7.3324421
Median Absolute Deviation (MAD)4
Skewness0.1166293
Sum16454
Variance16.967454
MonotonicityNot monotonic
2023-12-13T00:58:12.479261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%)
3 262
11.7%
12 224
10.0%
5 218
9.7%
13 187
8.3%
2 187
8.3%
4 184
8.2%
9 163
 
7.3%
11 144
 
6.4%
14 131
 
5.8%
6 119
 
5.3%
Other values (4) 425
18.9%
ValueCountFrequency (%)
1 110
4.9%
2 187
8.3%
3 262
11.7%
4 184
8.2%
5 218
9.7%
6 119
5.3%
7 110
4.9%
8 90
 
4.0%
9 163
7.3%
10 115
5.1%
ValueCountFrequency (%)
14 131
5.8%
13 187
8.3%
12 224
10.0%
11 144
6.4%
10 115
5.1%
9 163
7.3%
8 90
4.0%
7 110
4.9%
6 119
5.3%
5 218
9.7%

상권명
Categorical

HIGH CORRELATION 

Distinct14
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size17.7 KiB
롯데백화점 주변 상권
262 
세이디에스탄방점 주변 상권
224 
이마트 둔산점 주변 상권
218 
대전시청역 주변 상권
187 
한민시장 주변 상권
187 
Other values (9)
1166 

Length

Max length23
Median length19
Mean length13.177362
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row세이디에스탄방점 주변 상권
2nd row대주프라자 주변 상권
3rd row도마큰시장 주변 상권
4th row둔산3동상점가 주변 상권
5th row가수원상점가 주변 상권

Common Values

ValueCountFrequency (%)
롯데백화점 주변 상권 262
11.7%
세이디에스탄방점 주변 상권 224
10.0%
이마트 둔산점 주변 상권 218
9.7%
대전시청역 주변 상권 187
8.3%
한민시장 주변 상권 187
8.3%
갤러리아백화점 주변 상권 184
8.2%
둔산3동상점가 주변 상권 163
 
7.3%
이마트 트레이더스 월평점 주변 상권 144
 
6.4%
서구 보건소 주변 상권 131
 
5.8%
사학연금회관 뒤편(토요코인호텔) 주변 상권 119
 
5.3%
Other values (4) 425
18.9%

Length

2023-12-13T00:58:12.626395image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
상권 2244
30.0%
주변 2244
30.0%
이마트 362
 
4.8%
롯데백화점 262
 
3.5%
세이디에스탄방점 224
 
3.0%
둔산점 218
 
2.9%
대전시청역 187
 
2.5%
한민시장 187
 
2.5%
갤러리아백화점 184
 
2.5%
둔산3동상점가 163
 
2.2%
Other values (10) 1213
16.2%

행정동코드
Real number (ℝ)

HIGH CORRELATION 

Distinct18
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.0170593 × 109
Minimum3.017051 × 109
Maximum3.017066 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size19.9 KiB
2023-12-13T00:58:12.737288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3.017051 × 109
5-th percentile3.017052 × 109
Q13.017056 × 109
median3.017059 × 109
Q33.017063 × 109
95-th percentile3.017065 × 109
Maximum3.017066 × 109
Range15000
Interquartile range (IQR)7000

Descriptive statistics

Standard deviation3638.8347
Coefficient of variation (CV)1.2060866 × 10-6
Kurtosis-1.1138368
Mean3.0170593 × 109
Median Absolute Deviation (MAD)3500
Skewness-0.14945136
Sum6.7702811 × 1012
Variance13241118
MonotonicityNot monotonic
2023-12-13T00:58:12.932694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
3017063000 731
32.6%
3017055500 323
14.4%
3017058600 227
 
10.1%
3017056000 212
 
9.4%
3017059600 203
 
9.0%
3017065000 123
 
5.5%
3017052000 114
 
5.1%
3017059000 114
 
5.1%
3017057000 75
 
3.3%
3017055000 64
 
2.9%
Other values (8) 58
 
2.6%
ValueCountFrequency (%)
3017051000 1
 
< 0.1%
3017052000 114
 
5.1%
3017053500 3
 
0.1%
3017054000 8
 
0.4%
3017055000 64
 
2.9%
3017055500 323
14.4%
3017056000 212
9.4%
3017057000 75
 
3.3%
3017057500 21
 
0.9%
3017058100 12
 
0.5%
ValueCountFrequency (%)
3017066000 9
 
0.4%
3017065000 123
 
5.5%
3017064000 2
 
0.1%
3017063000 731
32.6%
3017059600 203
 
9.0%
3017059000 114
 
5.1%
3017058800 2
 
0.1%
3017058600 227
 
10.1%
3017058100 12
 
0.5%
3017057500 21
 
0.9%

행정동명
Categorical

HIGH CORRELATION 

Distinct18
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size17.7 KiB
둔산1동
731 
탄방동
323 
월평1동
227 
괴정동
212 
관저1동
203 
Other values (13)
548 

Length

Max length4
Median length4
Mean length3.6172014
Min length2

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row둔산1동
2nd row관저1동
3rd row도마1동
4th row둔산1동
5th row가수원동

Common Values

ValueCountFrequency (%)
둔산1동 731
32.6%
탄방동 323
14.4%
월평1동 227
 
10.1%
괴정동 212
 
9.4%
관저1동 203
 
9.0%
만년동 123
 
5.5%
도마1동 114
 
5.1%
가수원동 114
 
5.1%
가장동 75
 
3.3%
용문동 64
 
2.9%
Other values (8) 58
 
2.6%

Length

2023-12-13T00:58:13.099838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
둔산1동 731
32.6%
탄방동 323
14.4%
월평1동 227
 
10.1%
괴정동 212
 
9.4%
관저1동 203
 
9.0%
만년동 123
 
5.5%
도마1동 114
 
5.1%
가수원동 114
 
5.1%
가장동 75
 
3.3%
용문동 64
 
2.9%
Other values (8) 58
 
2.6%

영업상태코드
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size17.7 KiB
1
1043 
3
975 
4
201 
2
 
25

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 1043
46.5%
3 975
43.4%
4 201
 
9.0%
2 25
 
1.1%

Length

2023-12-13T00:58:13.250733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:58:13.411282image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 1043
46.5%
3 975
43.4%
4 201
 
9.0%
2 25
 
1.1%

영업상태명
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size17.7 KiB
영업/정상
1043 
폐업
975 
취소/말소/만료/정지/중지
201 
휴업
 
25

Length

Max length14
Median length5
Mean length4.4692513
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row영업/정상
2nd row영업/정상
3rd row영업/정상
4th row영업/정상
5th row영업/정상

Common Values

ValueCountFrequency (%)
영업/정상 1043
46.5%
폐업 975
43.4%
취소/말소/만료/정지/중지 201
 
9.0%
휴업 25
 
1.1%

Length

2023-12-13T00:58:13.593698image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:58:13.747391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업/정상 1043
46.5%
폐업 975
43.4%
취소/말소/만료/정지/중지 201
 
9.0%
휴업 25
 
1.1%

인허가업소수
Real number (ℝ)

Distinct93
Distinct (%)4.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7.6434938
Minimum1
Maximum294
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size19.9 KiB
2023-12-13T00:58:13.918149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median2
Q36
95-th percentile32
Maximum294
Range293
Interquartile range (IQR)5

Descriptive statistics

Standard deviation18.670272
Coefficient of variation (CV)2.4426358
Kurtosis74.249138
Mean7.6434938
Median Absolute Deviation (MAD)1
Skewness7.220423
Sum17152
Variance348.57904
MonotonicityNot monotonic
2023-12-13T00:58:14.106021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 854
38.1%
2 368
16.4%
3 195
 
8.7%
4 147
 
6.6%
5 93
 
4.1%
6 74
 
3.3%
7 63
 
2.8%
9 43
 
1.9%
8 36
 
1.6%
10 30
 
1.3%
Other values (83) 341
 
15.2%
ValueCountFrequency (%)
1 854
38.1%
2 368
16.4%
3 195
 
8.7%
4 147
 
6.6%
5 93
 
4.1%
6 74
 
3.3%
7 63
 
2.8%
8 36
 
1.6%
9 43
 
1.9%
10 30
 
1.3%
ValueCountFrequency (%)
294 1
< 0.1%
284 1
< 0.1%
209 1
< 0.1%
200 1
< 0.1%
190 1
< 0.1%
169 1
< 0.1%
155 1
< 0.1%
142 1
< 0.1%
139 1
< 0.1%
138 1
< 0.1%

데이터생성일자
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size17.7 KiB
Minimum2022-11-21 00:00:00
Maximum2022-11-21 00:00:00
2023-12-13T00:58:14.292101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:14.408601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T00:58:11.395736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:09.806434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:10.271283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:10.833560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:11.495273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:09.894828image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:10.391461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:10.967225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:11.592282image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:09.996943image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:10.540247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:11.104130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:11.711295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:10.104315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:10.689161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:58:11.260617image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T00:58:14.496583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번상권코드상권명행정동코드행정동명영업상태코드영업상태명인허가업소수
순번1.0000.0280.0000.0000.0400.7700.7700.014
상권코드0.0281.0001.0000.7810.8970.0000.0000.000
상권명0.0001.0001.0000.8920.9280.0000.0000.000
행정동코드0.0000.7810.8921.0001.0000.0000.0000.000
행정동명0.0400.8970.9281.0001.0000.0890.0890.000
영업상태코드0.7700.0000.0000.0000.0891.0001.0000.083
영업상태명0.7700.0000.0000.0000.0891.0001.0000.083
인허가업소수0.0140.0000.0000.0000.0000.0830.0831.000
2023-12-13T00:58:14.634823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
영업상태명행정동명상권명영업상태코드
영업상태명1.0000.0480.0001.000
행정동명0.0481.0000.6560.048
상권명0.0000.6561.0000.000
영업상태코드1.0000.0480.0001.000
2023-12-13T00:58:14.749799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번상권코드행정동코드인허가업소수상권명행정동명영업상태코드영업상태명
순번1.0000.0300.0090.0310.0000.0150.5830.583
상권코드0.0301.0000.2300.0280.9990.6290.0000.000
행정동코드0.0090.2301.0000.0610.6580.9980.0000.000
인허가업소수0.0310.0280.0611.0000.0000.0000.0530.053
상권명0.0000.9990.6580.0001.0000.6560.0000.000
행정동명0.0150.6290.9980.0000.6561.0000.0480.048
영업상태코드0.5830.0000.0000.0530.0000.0481.0001.000
영업상태명0.5830.0000.0000.0530.0000.0481.0001.000

Missing values

2023-12-13T00:58:11.838101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T00:58:11.964443image/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

순번상권코드상권명행정동코드행정동명영업상태코드영업상태명인허가업소수데이터생성일자
0112세이디에스탄방점 주변 상권3017063000둔산1동1영업/정상12022-11-21
127대주프라자 주변 상권3017059600관저1동1영업/정상52022-11-21
2310도마큰시장 주변 상권3017052000도마1동1영업/정상342022-11-21
349둔산3동상점가 주변 상권3017063000둔산1동1영업/정상42022-11-21
451가수원상점가 주변 상권3017059000가수원동1영업/정상62022-11-21
563롯데백화점 주변 상권3017055000용문동1영업/정상12022-11-21
679둔산3동상점가 주변 상권3017063000둔산1동1영업/정상52022-11-21
785이마트 둔산점 주변 상권3017058600월평1동1영업/정상42022-11-21
8911이마트 트레이더스 월평점 주변 상권3017058600월평1동1영업/정상22022-11-21
91014서구 보건소 주변 상권3017065000만년동1영업/정상42022-11-21
순번상권코드상권명행정동코드행정동명영업상태코드영업상태명인허가업소수데이터생성일자
2234223514서구 보건소 주변 상권3017065000만년동3폐업302022-11-21
223522365이마트 둔산점 주변 상권3017058600월평1동3폐업12022-11-21
223622375이마트 둔산점 주변 상권3017058600월평1동4취소/말소/만료/정지/중지12022-11-21
223722387대주프라자 주변 상권3017059600관저1동4취소/말소/만료/정지/중지22022-11-21
223822396사학연금회관 뒤편(토요코인호텔) 주변 상권3017063000둔산1동3폐업12022-11-21
223922409둔산3동상점가 주변 상권3017055500탄방동3폐업122022-11-21
224022412한민시장 주변 상권3017057000가장동3폐업12022-11-21
224122423롯데백화점 주변 상권3017056000괴정동3폐업12022-11-21
224222439둔산3동상점가 주변 상권3017063000둔산1동3폐업292022-11-21
224322442한민시장 주변 상권3017057500내동3폐업12022-11-21