Overview

Dataset statistics

Number of variables4
Number of observations409
Missing cells5
Missing cells (%)0.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory12.9 KiB
Average record size in memory32.3 B

Variable types

Text4

Dataset

Description대전광역시 다자녀가정우대 참여업체현황(음식점)에 대한 데이터로 기관 업체, 소재지, 전화번호, 우대 내용 등의 항목을 제공합니다.
Author대전광역시
URLhttps://www.data.go.kr/data/15061166/fileData.do

Alerts

전화번호 has 5 (1.2%) missing valuesMissing

Reproduction

Analysis started2023-12-12 02:42:49.368822
Analysis finished2023-12-12 02:42:49.943945
Duration0.58 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct403
Distinct (%)98.5%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
2023-12-12T11:42:50.218651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length13
Mean length5.4645477
Min length2

Characters and Unicode

Total characters2235
Distinct characters370
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique397 ?
Unique (%)97.1%

Sample

1st row청솔식당
2nd row두원수산(활어회)
3rd row행복오리
4th row이바돔감자탕가양점
5th row맛정원
ValueCountFrequency (%)
식당 8
 
1.6%
김밥천국 4
 
0.8%
카페 3
 
0.6%
칼국수 3
 
0.6%
청운반점 2
 
0.4%
2
 
0.4%
유성갈비 2
 
0.4%
대전도안점 2
 
0.4%
판암점 2
 
0.4%
옥천식당 2
 
0.4%
Other values (457) 461
93.9%
2023-12-12T11:42:50.628007image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
92
 
4.1%
69
 
3.1%
56
 
2.5%
50
 
2.2%
47
 
2.1%
40
 
1.8%
39
 
1.7%
37
 
1.7%
28
 
1.3%
27
 
1.2%
Other values (360) 1750
78.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2112
94.5%
Space Separator 92
 
4.1%
Close Punctuation 9
 
0.4%
Open Punctuation 9
 
0.4%
Uppercase Letter 7
 
0.3%
Other Punctuation 3
 
0.1%
Lowercase Letter 3
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
69
 
3.3%
56
 
2.7%
50
 
2.4%
47
 
2.2%
40
 
1.9%
39
 
1.8%
37
 
1.8%
28
 
1.3%
27
 
1.3%
26
 
1.2%
Other values (349) 1693
80.2%
Uppercase Letter
ValueCountFrequency (%)
A 2
28.6%
N 2
28.6%
F 1
14.3%
O 1
14.3%
K 1
14.3%
Lowercase Letter
ValueCountFrequency (%)
o 2
66.7%
d 1
33.3%
Space Separator
ValueCountFrequency (%)
92
100.0%
Close Punctuation
ValueCountFrequency (%)
) 9
100.0%
Open Punctuation
ValueCountFrequency (%)
( 9
100.0%
Other Punctuation
ValueCountFrequency (%)
& 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2112
94.5%
Common 113
 
5.1%
Latin 10
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
69
 
3.3%
56
 
2.7%
50
 
2.4%
47
 
2.2%
40
 
1.9%
39
 
1.8%
37
 
1.8%
28
 
1.3%
27
 
1.3%
26
 
1.2%
Other values (349) 1693
80.2%
Latin
ValueCountFrequency (%)
o 2
20.0%
A 2
20.0%
N 2
20.0%
d 1
10.0%
F 1
10.0%
O 1
10.0%
K 1
10.0%
Common
ValueCountFrequency (%)
92
81.4%
) 9
 
8.0%
( 9
 
8.0%
& 3
 
2.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2111
94.5%
ASCII 123
 
5.5%
Compat Jamo 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
92
74.8%
) 9
 
7.3%
( 9
 
7.3%
& 3
 
2.4%
o 2
 
1.6%
A 2
 
1.6%
N 2
 
1.6%
d 1
 
0.8%
F 1
 
0.8%
O 1
 
0.8%
Hangul
ValueCountFrequency (%)
69
 
3.3%
56
 
2.7%
50
 
2.4%
47
 
2.2%
40
 
1.9%
39
 
1.8%
37
 
1.8%
28
 
1.3%
27
 
1.3%
26
 
1.2%
Other values (348) 1692
80.2%
Compat Jamo
ValueCountFrequency (%)
1
100.0%
Distinct406
Distinct (%)99.3%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
2023-12-12T11:42:51.006376image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length43
Median length36
Mean length24.190709
Min length16

Characters and Unicode

Total characters9894
Distinct characters185
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique403 ?
Unique (%)98.5%

Sample

1st row대전광역시 동구 가양로 150(가양동)
2nd row대전광역시 동구 가양로 103(가양동)
3rd row대전광역시 동구 가양로 126(가양동)
4th row대전광역시 동구 동서대로 1734(가양동)
5th row대전광역시 동구 흥룡로67(가양동)
ValueCountFrequency (%)
대전광역시 411
23.1%
중구 100
 
5.6%
서구 93
 
5.2%
대덕구 86
 
4.8%
동구 85
 
4.8%
유성구 45
 
2.5%
대전로 14
 
0.8%
도솔로 9
 
0.5%
대종로 8
 
0.5%
옥천로 7
 
0.4%
Other values (739) 918
51.7%
2023-12-12T11:42:51.523045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1383
 
14.0%
624
 
6.3%
521
 
5.3%
454
 
4.6%
413
 
4.2%
411
 
4.2%
411
 
4.2%
411
 
4.2%
( 385
 
3.9%
) 385
 
3.9%
Other values (175) 4496
45.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6055
61.2%
Decimal Number 1561
 
15.8%
Space Separator 1383
 
14.0%
Open Punctuation 385
 
3.9%
Close Punctuation 385
 
3.9%
Dash Punctuation 84
 
0.8%
Other Punctuation 40
 
0.4%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
624
 
10.3%
521
 
8.6%
454
 
7.5%
413
 
6.8%
411
 
6.8%
411
 
6.8%
411
 
6.8%
383
 
6.3%
216
 
3.6%
200
 
3.3%
Other values (159) 2011
33.2%
Decimal Number
ValueCountFrequency (%)
1 349
22.4%
2 197
12.6%
3 161
10.3%
5 144
9.2%
7 144
9.2%
6 136
 
8.7%
4 136
 
8.7%
9 101
 
6.5%
0 99
 
6.3%
8 94
 
6.0%
Space Separator
ValueCountFrequency (%)
1383
100.0%
Open Punctuation
ValueCountFrequency (%)
( 385
100.0%
Close Punctuation
ValueCountFrequency (%)
) 385
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 84
100.0%
Other Punctuation
ValueCountFrequency (%)
, 40
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6055
61.2%
Common 3838
38.8%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
624
 
10.3%
521
 
8.6%
454
 
7.5%
413
 
6.8%
411
 
6.8%
411
 
6.8%
411
 
6.8%
383
 
6.3%
216
 
3.6%
200
 
3.3%
Other values (159) 2011
33.2%
Common
ValueCountFrequency (%)
1383
36.0%
( 385
 
10.0%
) 385
 
10.0%
1 349
 
9.1%
2 197
 
5.1%
3 161
 
4.2%
5 144
 
3.8%
7 144
 
3.8%
6 136
 
3.5%
4 136
 
3.5%
Other values (5) 418
 
10.9%
Latin
ValueCountFrequency (%)
A 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6055
61.2%
ASCII 3839
38.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1383
36.0%
( 385
 
10.0%
) 385
 
10.0%
1 349
 
9.1%
2 197
 
5.1%
3 161
 
4.2%
5 144
 
3.8%
7 144
 
3.8%
6 136
 
3.5%
4 136
 
3.5%
Other values (6) 419
 
10.9%
Hangul
ValueCountFrequency (%)
624
 
10.3%
521
 
8.6%
454
 
7.5%
413
 
6.8%
411
 
6.8%
411
 
6.8%
411
 
6.8%
383
 
6.3%
216
 
3.6%
200
 
3.3%
Other values (159) 2011
33.2%

전화번호
Text

MISSING 

Distinct403
Distinct (%)99.8%
Missing5
Missing (%)1.2%
Memory size3.3 KiB
2023-12-12T11:42:51.754184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.017327
Min length12

Characters and Unicode

Total characters4855
Distinct characters12
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique402 ?
Unique (%)99.5%

Sample

1st row042-626-3189
2nd row042-626-8885
3rd row042-637-9252
4th row042-633-0055
5th row042-283-0863
ValueCountFrequency (%)
042-321-0788 2
 
0.5%
042-487-4443 1
 
0.2%
042-626-3189 1
 
0.2%
042-822-7338 1
 
0.2%
042-476-9968 1
 
0.2%
042-671-6718 1
 
0.2%
042-936-9979 1
 
0.2%
042-523-9273 1
 
0.2%
042-545-1100 1
 
0.2%
042-523-2428 1
 
0.2%
Other values (393) 393
97.3%
2023-12-12T11:42:52.158975image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 892
18.4%
- 808
16.6%
4 628
12.9%
0 601
12.4%
5 388
8.0%
3 347
 
7.1%
8 313
 
6.4%
6 293
 
6.0%
7 216
 
4.4%
9 200
 
4.1%
Other values (2) 169
 
3.5%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 4046
83.3%
Dash Punctuation 808
 
16.6%
Space Separator 1
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 892
22.0%
4 628
15.5%
0 601
14.9%
5 388
9.6%
3 347
 
8.6%
8 313
 
7.7%
6 293
 
7.2%
7 216
 
5.3%
9 200
 
4.9%
1 168
 
4.2%
Dash Punctuation
ValueCountFrequency (%)
- 808
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 4855
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 892
18.4%
- 808
16.6%
4 628
12.9%
0 601
12.4%
5 388
8.0%
3 347
 
7.1%
8 313
 
6.4%
6 293
 
6.0%
7 216
 
4.4%
9 200
 
4.1%
Other values (2) 169
 
3.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 4855
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 892
18.4%
- 808
16.6%
4 628
12.9%
0 601
12.4%
5 388
8.0%
3 347
 
7.1%
8 313
 
6.4%
6 293
 
6.0%
7 216
 
4.4%
9 200
 
4.1%
Other values (2) 169
 
3.5%
Distinct167
Distinct (%)40.8%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
2023-12-12T11:42:52.513790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length40
Median length30
Mean length11.91687
Min length4

Characters and Unicode

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

Unique

Unique146 ?
Unique (%)35.7%

Sample

1st row전체품목 5% 할인
2nd row일부품목 5% 할인
3rd row일부품목 5% 할인
4th row전체품목 10% 할인
5th row일부품목 5% 할인(삼겹살, 오리)
ValueCountFrequency (%)
할인 260
21.6%
전체품목 215
17.9%
5 187
15.5%
10 121
10.0%
일부품목 96
 
8.0%
5%할인 19
 
1.6%
10%할인 13
 
1.1%
제공 11
 
0.9%
제외 11
 
0.9%
음료수 10
 
0.8%
Other values (179) 261
21.7%
2023-12-12T11:42:53.392080image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
805
16.5%
% 378
 
7.8%
376
 
7.7%
364
 
7.5%
345
 
7.1%
338
 
6.9%
235
 
4.8%
225
 
4.6%
5 222
 
4.6%
0 184
 
3.8%
Other values (177) 1402
28.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2888
59.3%
Space Separator 805
 
16.5%
Decimal Number 594
 
12.2%
Other Punctuation 416
 
8.5%
Open Punctuation 82
 
1.7%
Close Punctuation 82
 
1.7%
Math Symbol 4
 
0.1%
Dash Punctuation 3
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
376
13.0%
364
12.6%
345
11.9%
338
11.7%
235
 
8.1%
225
 
7.8%
107
 
3.7%
104
 
3.6%
52
 
1.8%
32
 
1.1%
Other values (160) 710
24.6%
Decimal Number
ValueCountFrequency (%)
5 222
37.4%
0 184
31.0%
1 160
26.9%
3 12
 
2.0%
2 12
 
2.0%
4 2
 
0.3%
6 2
 
0.3%
Other Punctuation
ValueCountFrequency (%)
% 378
90.9%
, 35
 
8.4%
/ 2
 
0.5%
& 1
 
0.2%
Math Symbol
ValueCountFrequency (%)
> 3
75.0%
1
 
25.0%
Space Separator
ValueCountFrequency (%)
805
100.0%
Open Punctuation
ValueCountFrequency (%)
( 82
100.0%
Close Punctuation
ValueCountFrequency (%)
) 82
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2886
59.2%
Common 1986
40.7%
Han 2
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
376
13.0%
364
12.6%
345
12.0%
338
11.7%
235
 
8.1%
225
 
7.8%
107
 
3.7%
104
 
3.6%
52
 
1.8%
32
 
1.1%
Other values (158) 708
24.5%
Common
ValueCountFrequency (%)
805
40.5%
% 378
19.0%
5 222
 
11.2%
0 184
 
9.3%
1 160
 
8.1%
( 82
 
4.1%
) 82
 
4.1%
, 35
 
1.8%
3 12
 
0.6%
2 12
 
0.6%
Other values (7) 14
 
0.7%
Han
ValueCountFrequency (%)
1
50.0%
1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2886
59.2%
ASCII 1985
40.7%
CJK 2
 
< 0.1%
Arrows 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
805
40.6%
% 378
19.0%
5 222
 
11.2%
0 184
 
9.3%
1 160
 
8.1%
( 82
 
4.1%
) 82
 
4.1%
, 35
 
1.8%
3 12
 
0.6%
2 12
 
0.6%
Other values (6) 13
 
0.7%
Hangul
ValueCountFrequency (%)
376
13.0%
364
12.6%
345
12.0%
338
11.7%
235
 
8.1%
225
 
7.8%
107
 
3.7%
104
 
3.6%
52
 
1.8%
32
 
1.1%
Other values (158) 708
24.5%
CJK
ValueCountFrequency (%)
1
50.0%
1
50.0%
Arrows
ValueCountFrequency (%)
1
100.0%

Missing values

2023-12-12T11:42:49.764248image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T11:42:49.891797image/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

기관ㆍ업체명소재지전화번호우대내용
0청솔식당대전광역시 동구 가양로 150(가양동)042-626-3189전체품목 5% 할인
1두원수산(활어회)대전광역시 동구 가양로 103(가양동)042-626-8885일부품목 5% 할인
2행복오리대전광역시 동구 가양로 126(가양동)042-637-9252일부품목 5% 할인
3이바돔감자탕가양점대전광역시 동구 동서대로 1734(가양동)042-633-0055전체품목 10% 할인
4맛정원대전광역시 동구 흥룡로67(가양동)042-283-0863일부품목 5% 할인(삼겹살, 오리)
5우정장터치킨대전광역시 동구 계족로 170(대동)042-282-7165포인트적립 3%
6한국회관대전광역시 동구 동대전로110번길 60(대동)042-673-7585포인트적립 2%
7가야숯불구이대전광역시 동구 용운로 1(대동)042-283-9936전체품목 5% 할인(매장방문시)
8수정식품대전광역시 동구 이화로 43 (대동)042-622-2116전체품목 5% 할인
9평양숨두부대전광역시 동구 대전로 381(대성동)042-284-4141일부품목 5% 할인
기관ㆍ업체명소재지전화번호우대내용
399커 피 보 카대전광역시 대덕구 덕암동 17-10042-933-3306전품목 10% 할인
400태능생삼겹살대전광역시 대덕구 오정로78번길 31(오정동)042-626-0552일부품목 5% 할인
401놀부네설렁탕대전광역시 대덕구 한밭대로1006번길 62 (오정동)042-672-1463전체품목 5% 할인
402오륙도식당대전광역시 대덕구 대화로 35(대화동)042-634-7702전체품목 5% 할인
403베로커피숍대전광역시 대덕구 대전로 1379(읍내동)042-335-3302전체품목 10% 할인
404인생과일대전광역시 대덕구 선비마을로 23번길 67(송촌동)042-633-6667일부품목 5%할인
405오가네 대구왕뽈떼기대전광역시 대덕구 법동 287-6번지(법동)042-622-5080전품목 5%할인
406그리고브런치대전광역시 대덕구 계족로608번길5070-4121-727810%할인(1만원이상결재시)
407더도대전광역시 대덕구 신탄진동로7번안길 3 (신탄진동)042-933-3685일부 품목 10% 할인(식사에 한함)
408장성김밥대전광역시 대덕구 비래서로 23042-639-8870전체품목 10%할인