Overview

Dataset statistics

Number of variables6
Number of observations2726
Missing cells309
Missing cells (%)1.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory127.9 KiB
Average record size in memory48.0 B

Variable types

Categorical6

Dataset

Description대구광역시_안심식당 현황_20230630
Author대구광역시
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=15116731&dataSetDetailId=151167311891ffbefdc47&provdMethod=FILE

Alerts

등록일 has constant value "2023-06-30"Constant
업체명 has a high cardinality: 2631 distinct valuesHigh cardinality
주소 has a high cardinality: 2365 distinct valuesHigh cardinality
전화 has a high cardinality: 2380 distinct valuesHigh cardinality
지정일자 has a high cardinality: 394 distinct valuesHigh cardinality
업태 is highly imbalanced (73.6%)Imbalance
전화 has 309 (11.3%) missing valuesMissing

Reproduction

Analysis started2023-07-22 01:24:39.469744
Analysis finished2023-07-22 01:24:40.654191
Duration1.18 second
Software versionpandas-profiling v3.6.6
Download configurationconfig.json

Variables

업체명
Categorical

Distinct2631
Distinct (%)96.5%
Missing0
Missing (%)0.0%
Memory size21.4 KiB
개정
 
4
시골밥상
 
4
일송정
 
4
대구통닭
 
3
한티재
 
3
Other values (2626)
2708 

Length

Max length23
Median length20
Mean length6.337124
Min length1

Unique

Unique2552 ?
Unique (%)93.6%

Sample

1st row달인의찜닭(태전점)
2nd row돈묵고 가자
3rd row임금님숯불갈비
4th row개방
5th row남원골추어탕

Common Values

ValueCountFrequency (%)
개정 4
 
0.1%
시골밥상 4
 
0.1%
일송정 4
 
0.1%
대구통닭 3
 
0.1%
한티재 3
 
0.1%
대구반야월막창 3
 
0.1%
쪽쪽갈비 3
 
0.1%
부림해물손수제비 3
 
0.1%
부산식당 3
 
0.1%
장수삼계탕 3
 
0.1%
Other values (2621) 2693
98.8%

Length

2023-07-22T10:24:40.857082image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
율하점 5
 
0.2%
신월성점 5
 
0.2%
개정 4
 
0.1%
적돈 4
 
0.1%
본점 4
 
0.1%
동성로점 4
 
0.1%
시골밥상 4
 
0.1%
일송정 4
 
0.1%
부림해물손수제비 3
 
0.1%
대구테크노폴리스점 3
 
0.1%
Other values (2775) 2931
98.7%

주소
Categorical

Distinct2365
Distinct (%)86.8%
Missing0
Missing (%)0.0%
Memory size21.4 KiB
대구광역시 동구 동부로 149
 
41
대구광역시 중구 명덕로 333
 
21
대구광역시 동구 안심로16길 47
 
17
대구광역시 중구 달구벌대로 2077
 
15
대구광역시 북구 태평로 161
 
12
Other values (2360)
2620 

Length

Max length30
Median length27
Mean length18.381878
Min length14

Unique

Unique2204 ?
Unique (%)80.9%

Sample

1st row대구광역시 북구 태전로1길 34
2nd row대구광역시 북구 태전로1길 34
3rd row대구광역시 북구 구암로 211
4th row대구광역시 북구 팔거천동로34길 2-22
5th row대구광역시 북구 대구체육관로 45

Common Values

ValueCountFrequency (%)
대구광역시 동구 동부로 149 41
 
1.5%
대구광역시 중구 명덕로 333 21
 
0.8%
대구광역시 동구 안심로16길 47 17
 
0.6%
대구광역시 중구 달구벌대로 2077 15
 
0.6%
대구광역시 북구 태평로 161 12
 
0.4%
대구광역시 동구 동대구로 550 12
 
0.4%
대구광역시 동구 동대구로 454 10
 
0.4%
대구광역시 북구 옥산로 103 7
 
0.3%
대구광역시 남구 대명로36길 63 7
 
0.3%
대구광역시 동구 팔공로 250 6
 
0.2%
Other values (2355) 2578
94.6%

Length

2023-07-22T10:24:41.390610image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
대구광역시 2726
24.4%
동구 555
 
5.0%
수성구 413
 
3.7%
북구 400
 
3.6%
달서구 389
 
3.5%
서구 273
 
2.4%
달성군 245
 
2.2%
중구 232
 
2.1%
남구 219
 
2.0%
달구벌대로 70
 
0.6%
Other values (1709) 5628
50.5%

전화
Categorical

HIGH CARDINALITY  MISSING 

Distinct2380
Distinct (%)98.5%
Missing309
Missing (%)11.3%
Memory size21.4 KiB
053-941-0019
 
5
053-253-7377
 
4
070-7092-7145
 
3
1577-0001
 
3
053-218-2258
 
3
Other values (2375)
2399 

Length

Max length14
Median length12
Mean length12.073231
Min length8

Unique

Unique2351 ?
Unique (%)97.3%

Sample

1st row053-324-0762
2nd row053-312-9500
3rd row053-958-1878
4th row053-313-3185
5th row053-941-2323

Common Values

ValueCountFrequency (%)
053-941-0019 5
 
0.2%
053-253-7377 4
 
0.1%
070-7092-7145 3
 
0.1%
1577-0001 3
 
0.1%
053-218-2258 3
 
0.1%
053-420-8031 2
 
0.1%
053-743-5687 2
 
0.1%
053-661-6880 2
 
0.1%
053-661-6884 2
 
0.1%
053-585-3622 2
 
0.1%
Other values (2370) 2389
87.6%
(Missing) 309
 
11.3%

Length

2023-07-22T10:24:41.648120image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
053-941-0019 5
 
0.2%
053-253-7377 4
 
0.2%
070-7092-7145 3
 
0.1%
1577-0001 3
 
0.1%
053-218-2258 3
 
0.1%
053-622-2662 2
 
0.1%
053-982-1001 2
 
0.1%
053-982-8099 2
 
0.1%
053-767-5303 2
 
0.1%
053-123-4567 2
 
0.1%
Other values (2370) 2389
98.8%

업태
Categorical

Distinct2
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size21.4 KiB
일반음식점
2604 
일반음식점_외
 
122

Length

Max length7
Median length5
Mean length5.0895084
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row일반음식점
2nd row일반음식점
3rd row일반음식점
4th row일반음식점
5th row일반음식점

Common Values

ValueCountFrequency (%)
일반음식점 2604
95.5%
일반음식점_외 122
 
4.5%

Length

2023-07-22T10:24:41.874233image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-07-22T10:24:42.087368image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
ValueCountFrequency (%)
일반음식점 2604
95.5%
일반음식점_외 122
 
4.5%

지정일자
Categorical

Distinct394
Distinct (%)14.5%
Missing0
Missing (%)0.0%
Memory size21.4 KiB
2021-06-29
 
86
2021-04-12
 
78
2022-08-08
 
71
2022-05-11
 
64
2021-04-28
 
58
Other values (389)
2369 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique87 ?
Unique (%)3.2%

Sample

1st row2023-01-12
2nd row2023-01-12
3rd row2023-01-12
4th row2023-01-09
5th row2023-01-09

Common Values

ValueCountFrequency (%)
2021-06-29 86
 
3.2%
2021-04-12 78
 
2.9%
2022-08-08 71
 
2.6%
2022-05-11 64
 
2.3%
2021-04-28 58
 
2.1%
2021-06-14 51
 
1.9%
2020-08-14 49
 
1.8%
2020-04-03 46
 
1.7%
2020-09-29 45
 
1.7%
2020-07-27 41
 
1.5%
Other values (384) 2137
78.4%

Length

2023-07-22T10:24:42.233709image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2021-06-29 86
 
3.2%
2021-04-12 78
 
2.9%
2022-08-08 71
 
2.6%
2022-05-11 64
 
2.3%
2021-04-28 58
 
2.1%
2021-06-14 51
 
1.9%
2020-08-14 49
 
1.8%
2020-04-03 46
 
1.7%
2020-09-29 45
 
1.7%
2020-07-27 41
 
1.5%
Other values (384) 2137
78.4%

등록일
Categorical

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size21.4 KiB
2023-06-30
2726 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-06-30
2nd row2023-06-30
3rd row2023-06-30
4th row2023-06-30
5th row2023-06-30

Common Values

ValueCountFrequency (%)
2023-06-30 2726
100.0%

Length

2023-07-22T10:24:42.430034image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-07-22T10:24:42.614274image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
ValueCountFrequency (%)
2023-06-30 2726
100.0%

Missing values

2023-07-22T10:24:40.239464image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
A simple visualization of nullity by column.
2023-07-22T10:24:40.541075image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

업체명주소전화업태지정일자등록일
0달인의찜닭(태전점)대구광역시 북구 태전로1길 34<NA>일반음식점2023-01-122023-06-30
1돈묵고 가자대구광역시 북구 태전로1길 34<NA>일반음식점2023-01-122023-06-30
2임금님숯불갈비대구광역시 북구 구암로 211053-324-0762일반음식점2023-01-122023-06-30
3개방대구광역시 북구 팔거천동로34길 2-22053-312-9500일반음식점2023-01-092023-06-30
4남원골추어탕대구광역시 북구 대구체육관로 45053-958-1878일반음식점2023-01-092023-06-30
5장수할매국밥대구광역시 북구 한강로4길 13053-313-3185일반음식점2023-01-112023-06-30
6은성숯불식당대구광역시 북구 대현남로4길 26053-941-2323일반음식점2023-01-112023-06-30
7팔팔회랑물회전문점대구광역시 북구 칠곡중앙대로80길 6053-311-4007일반음식점2023-01-112023-06-30
8박대박식당대구광역시 북구 오봉로 27053-358-0489일반음식점2023-01-102023-06-30
9동천동단지보쌈대구광역시 북구 동천로 128-8053-321-5382일반음식점2023-01-102023-06-30
업체명주소전화업태지정일자등록일
2716바다회참가자미대구광역시 중구 경상감영길 117-12053-255-7712일반음식점2020-04-032023-06-30
2717후쿠오카호르몬대구광역시 중구 동성로1길 47053-253-1844일반음식점2020-04-032023-06-30
2718맨션드방콕대구광역시 중구 동성로1길 67053-257-3020일반음식점2020-04-032023-06-30
2719강산면옥(교동점)대구광역시 중구 교동길 27-8053-425-1199일반음식점2020-04-032023-06-30
2720정담대구광역시 중구 달구벌대로 지하 2100053-427-6555일반음식점2020-04-032023-06-30
2721빈플러스대구광역시 중구 동성로4길 73053-242-3582일반음식점2020-04-032023-06-30
2722본죽앤비빔밥대구광역시 중구 동성로 57053-255-8009일반음식점2020-04-032023-06-30
2723부산해물철판구이대구광역시 중구 동성로 4-6053-423-6624일반음식점2020-04-032023-06-30
2724개정(동성로점)대구광역시 중구 동성로 36-6053-422-0366일반음식점2020-04-032023-06-30
2725애슐리 대구 동성로점대구광역시 중구 동성로 36053-253-1031일반음식점2020-04-032023-06-30