Overview

Dataset statistics

Number of variables5
Number of observations25
Missing cells1
Missing cells (%)0.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.1 KiB
Average record size in memory46.3 B

Variable types

Numeric1
Text3
Categorical1

Dataset

Description인천광역시 계양구 공정무역 제품판매처 현황에 대한 데이터로, 회사명, 도로명 주소, 전화번호, 판매품목 등을 제공합니다.
Author인천광역시 계양구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15062352&srcSe=7661IVAWM27C61E190

Alerts

전화번호 has 1 (4.0%) missing valuesMissing
연번 has unique valuesUnique
회사명 has unique valuesUnique

Reproduction

Analysis started2024-03-13 06:12:21.251709
Analysis finished2024-03-13 06:12:21.832747
Duration0.58 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct25
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean13
Minimum1
Maximum25
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size357.0 B
2024-03-13T15:12:21.920593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.2
Q17
median13
Q319
95-th percentile23.8
Maximum25
Range24
Interquartile range (IQR)12

Descriptive statistics

Standard deviation7.3598007
Coefficient of variation (CV)0.56613852
Kurtosis-1.2
Mean13
Median Absolute Deviation (MAD)6
Skewness0
Sum325
Variance54.166667
MonotonicityStrictly increasing
2024-03-13T15:12:22.054983image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)
ValueCountFrequency (%)
1 1
 
4.0%
2 1
 
4.0%
25 1
 
4.0%
24 1
 
4.0%
23 1
 
4.0%
22 1
 
4.0%
21 1
 
4.0%
20 1
 
4.0%
19 1
 
4.0%
18 1
 
4.0%
Other values (15) 15
60.0%
ValueCountFrequency (%)
1 1
4.0%
2 1
4.0%
3 1
4.0%
4 1
4.0%
5 1
4.0%
6 1
4.0%
7 1
4.0%
8 1
4.0%
9 1
4.0%
10 1
4.0%
ValueCountFrequency (%)
25 1
4.0%
24 1
4.0%
23 1
4.0%
22 1
4.0%
21 1
4.0%
20 1
4.0%
19 1
4.0%
18 1
4.0%
17 1
4.0%
16 1
4.0%

회사명
Text

UNIQUE 

Distinct25
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2024-03-13T15:12:22.308406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length14
Mean length11.4
Min length4

Characters and Unicode

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

Unique

Unique25 ?
Unique (%)100.0%

Sample

1st row경명대로카페
2nd row도농살림 계양산성 매장
3rd row꽃가람 화원
4th row도농살림
5th row참좋은 두레생협 계양점
ValueCountFrequency (%)
cj 4
 
7.0%
올리브네트웍스㈜ 4
 
7.0%
롯데리아 3
 
5.3%
홈플러스 3
 
5.3%
계양점 3
 
5.3%
엔제리너스 2
 
3.5%
계산점 2
 
3.5%
도농살림 2
 
3.5%
롯데마트 2
 
3.5%
작전점 2
 
3.5%
Other values (26) 30
52.6%
2024-03-13T15:12:22.984400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
33
 
11.6%
18
 
6.3%
16
 
5.6%
10
 
3.5%
10
 
3.5%
10
 
3.5%
9
 
3.2%
6
 
2.1%
6
 
2.1%
C 6
 
2.1%
Other values (84) 161
56.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 230
80.7%
Space Separator 33
 
11.6%
Uppercase Letter 16
 
5.6%
Other Symbol 4
 
1.4%
Open Punctuation 1
 
0.4%
Close Punctuation 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
18
 
7.8%
16
 
7.0%
10
 
4.3%
10
 
4.3%
10
 
4.3%
9
 
3.9%
6
 
2.6%
6
 
2.6%
5
 
2.2%
5
 
2.2%
Other values (75) 135
58.7%
Uppercase Letter
ValueCountFrequency (%)
C 6
37.5%
J 4
25.0%
U 2
 
12.5%
S 2
 
12.5%
G 2
 
12.5%
Space Separator
ValueCountFrequency (%)
33
100.0%
Other Symbol
ValueCountFrequency (%)
4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 234
82.1%
Common 35
 
12.3%
Latin 16
 
5.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
18
 
7.7%
16
 
6.8%
10
 
4.3%
10
 
4.3%
10
 
4.3%
9
 
3.8%
6
 
2.6%
6
 
2.6%
5
 
2.1%
5
 
2.1%
Other values (76) 139
59.4%
Latin
ValueCountFrequency (%)
C 6
37.5%
J 4
25.0%
U 2
 
12.5%
S 2
 
12.5%
G 2
 
12.5%
Common
ValueCountFrequency (%)
33
94.3%
( 1
 
2.9%
) 1
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 230
80.7%
ASCII 51
 
17.9%
None 4
 
1.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
33
64.7%
C 6
 
11.8%
J 4
 
7.8%
U 2
 
3.9%
S 2
 
3.9%
G 2
 
3.9%
( 1
 
2.0%
) 1
 
2.0%
Hangul
ValueCountFrequency (%)
18
 
7.8%
16
 
7.0%
10
 
4.3%
10
 
4.3%
10
 
4.3%
9
 
3.9%
6
 
2.6%
6
 
2.6%
5
 
2.2%
5
 
2.2%
Other values (75) 135
58.7%
None
ValueCountFrequency (%)
4
100.0%

주소
Text

Distinct23
Distinct (%)92.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2024-03-13T15:12:23.217371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length35
Median length34
Mean length20.36
Min length15

Characters and Unicode

Total characters509
Distinct characters58
Distinct categories7 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique21 ?
Unique (%)84.0%

Sample

1st row인천광역시 계양구 경명대로 1143
2nd row인천광역시 계양구 계양산로 101
3rd row인천광역시 계양구 당미2길 3-1
4th row인천광역시 계양구 계양대로205번길 11-3(계산동)
5th row인천광역시 계양구 계수로 21-1
ValueCountFrequency (%)
인천광역시 25
23.6%
계양구 25
23.6%
계양산로 4
 
3.8%
경명대로 4
 
3.8%
장제로 3
 
2.8%
계수로 3
 
2.8%
계양대로 2
 
1.9%
27 2
 
1.9%
822 2
 
1.9%
101 2
 
1.9%
Other values (32) 34
32.1%
2024-03-13T15:12:23.590812image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
81
15.9%
44
 
8.6%
34
 
6.7%
26
 
5.1%
25
 
4.9%
25
 
4.9%
25
 
4.9%
25
 
4.9%
25
 
4.9%
24
 
4.7%
Other values (48) 175
34.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 337
66.2%
Space Separator 81
 
15.9%
Decimal Number 74
 
14.5%
Close Punctuation 6
 
1.2%
Open Punctuation 6
 
1.2%
Dash Punctuation 4
 
0.8%
Other Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
44
13.1%
34
10.1%
26
 
7.7%
25
 
7.4%
25
 
7.4%
25
 
7.4%
25
 
7.4%
25
 
7.4%
24
 
7.1%
14
 
4.2%
Other values (33) 70
20.8%
Decimal Number
ValueCountFrequency (%)
1 19
25.7%
2 12
16.2%
0 8
10.8%
8 7
 
9.5%
3 6
 
8.1%
4 6
 
8.1%
7 6
 
8.1%
9 6
 
8.1%
5 3
 
4.1%
6 1
 
1.4%
Space Separator
ValueCountFrequency (%)
81
100.0%
Close Punctuation
ValueCountFrequency (%)
) 6
100.0%
Open Punctuation
ValueCountFrequency (%)
( 6
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%
Other Punctuation
ValueCountFrequency (%)
, 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 337
66.2%
Common 172
33.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
44
13.1%
34
10.1%
26
 
7.7%
25
 
7.4%
25
 
7.4%
25
 
7.4%
25
 
7.4%
25
 
7.4%
24
 
7.1%
14
 
4.2%
Other values (33) 70
20.8%
Common
ValueCountFrequency (%)
81
47.1%
1 19
 
11.0%
2 12
 
7.0%
0 8
 
4.7%
8 7
 
4.1%
3 6
 
3.5%
) 6
 
3.5%
4 6
 
3.5%
7 6
 
3.5%
9 6
 
3.5%
Other values (5) 15
 
8.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 337
66.2%
ASCII 172
33.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
81
47.1%
1 19
 
11.0%
2 12
 
7.0%
0 8
 
4.7%
8 7
 
4.1%
3 6
 
3.5%
) 6
 
3.5%
4 6
 
3.5%
7 6
 
3.5%
9 6
 
3.5%
Other values (5) 15
 
8.7%
Hangul
ValueCountFrequency (%)
44
13.1%
34
10.1%
26
 
7.7%
25
 
7.4%
25
 
7.4%
25
 
7.4%
25
 
7.4%
25
 
7.4%
24
 
7.1%
14
 
4.2%
Other values (33) 70
20.8%

전화번호
Text

MISSING 

Distinct22
Distinct (%)91.7%
Missing1
Missing (%)4.0%
Memory size332.0 B
2024-03-13T15:12:23.847939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length11.75
Min length9

Characters and Unicode

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

Unique

Unique20 ?
Unique (%)83.3%

Sample

1st row0507-1317-7669
2nd row070-7543-6302
3rd row032-553-3370
4th row032-555-7332
5th row032-541-9600
ValueCountFrequency (%)
1644-5425 2
 
8.3%
1577-8007 2
 
8.3%
0507-1317-7669 1
 
4.2%
032-552-5290 1
 
4.2%
032-541-3828 1
 
4.2%
032-550-2500 1
 
4.2%
032-555-7593 1
 
4.2%
032-547-1644 1
 
4.2%
032-543-3300 1
 
4.2%
032-556-5290 1
 
4.2%
Other values (12) 12
50.0%
2024-03-13T15:12:24.205755image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 48
17.0%
- 44
15.6%
0 44
15.6%
3 33
11.7%
2 29
10.3%
7 21
7.4%
4 20
7.1%
1 16
 
5.7%
6 12
 
4.3%
9 8
 
2.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 238
84.4%
Dash Punctuation 44
 
15.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 48
20.2%
0 44
18.5%
3 33
13.9%
2 29
12.2%
7 21
8.8%
4 20
8.4%
1 16
 
6.7%
6 12
 
5.0%
9 8
 
3.4%
8 7
 
2.9%
Dash Punctuation
ValueCountFrequency (%)
- 44
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 282
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 48
17.0%
- 44
15.6%
0 44
15.6%
3 33
11.7%
2 29
10.3%
7 21
7.4%
4 20
7.1%
1 16
 
5.7%
6 12
 
4.3%
9 8
 
2.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 282
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 48
17.0%
- 44
15.6%
0 44
15.6%
3 33
11.7%
2 29
10.3%
7 21
7.4%
4 20
7.1%
1 16
 
5.7%
6 12
 
4.3%
9 8
 
2.8%

판매품목
Categorical

Distinct9
Distinct (%)36.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
원두를 이용한 전메뉴
벤앤제리스 아이스크림
닥터브로너스 퓨어 캐스틸솝(바디워시)
드립백, 더치커피
공정무역 원두 선택이 가능한 모든 음료
Other values (4)

Length

Max length32
Median length31
Mean length15.2
Min length9

Unique

Unique4 ?
Unique (%)16.0%

Sample

1st row햄스테드 유기농 티 다즐링
2nd row드립백, 더치커피
3rd row원두를 이용한 전메뉴
4th row건과일, 수공예품, 세면타일, 초콜릿 등
5th row공정무역 커피, 올리브유, 설탕, 카카오닙스, 바나나 등

Common Values

ValueCountFrequency (%)
원두를 이용한 전메뉴 7
28.0%
벤앤제리스 아이스크림 5
20.0%
닥터브로너스 퓨어 캐스틸솝(바디워시) 4
16.0%
드립백, 더치커피 3
12.0%
공정무역 원두 선택이 가능한 모든 음료 2
 
8.0%
햄스테드 유기농 티 다즐링 1
 
4.0%
건과일, 수공예품, 세면타일, 초콜릿 등 1
 
4.0%
공정무역 커피, 올리브유, 설탕, 카카오닙스, 바나나 등 1
 
4.0%
공정무역 젤리, 사탕, 초콜릿, 바나나, 커피, 화장솜 등 1
 
4.0%

Length

2024-03-13T15:12:24.354218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T15:12:24.487918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
원두를 7
 
8.2%
전메뉴 7
 
8.2%
이용한 7
 
8.2%
벤앤제리스 5
 
5.9%
아이스크림 5
 
5.9%
공정무역 4
 
4.7%
닥터브로너스 4
 
4.7%
퓨어 4
 
4.7%
캐스틸솝(바디워시 4
 
4.7%
3
 
3.5%
Other values (23) 35
41.2%

Interactions

2024-03-13T15:12:21.559435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T15:12:24.602118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번회사명주소전화번호판매품목
연번1.0001.0000.8661.0000.789
회사명1.0001.0001.0001.0001.000
주소0.8661.0001.0000.9460.942
전화번호1.0001.0000.9461.0001.000
판매품목0.7891.0000.9421.0001.000
2024-03-13T15:12:24.722268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번판매품목
연번1.0000.468
판매품목0.4681.000

Missing values

2024-03-13T15:12:21.690835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T15:12:21.786905image/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

연번회사명주소전화번호판매품목
01경명대로카페인천광역시 계양구 경명대로 11430507-1317-7669햄스테드 유기농 티 다즐링
12도농살림 계양산성 매장인천광역시 계양구 계양산로 101070-7543-6302드립백, 더치커피
23꽃가람 화원인천광역시 계양구 당미2길 3-1032-553-3370원두를 이용한 전메뉴
34도농살림인천광역시 계양구 계양대로205번길 11-3(계산동)032-555-7332건과일, 수공예품, 세면타일, 초콜릿 등
45참좋은 두레생협 계양점인천광역시 계양구 계수로 21-1032-541-9600공정무역 커피, 올리브유, 설탕, 카카오닙스, 바나나 등
56인천계양지역자활센터 뜰엔담인천광역시 계양구 계수로 27(계산동)032-546-3371원두를 이용한 전메뉴
67아모르카페인천광역시 계양구 계산새로 88(계산동)032-545-5376드립백, 더치커피
78아모르카페 계양산성박물관점인천광역시 계양구 계양산로 101 계양산성박물관 2층(계산동)<NA>드립백, 더치커피
89자연드림 계양점(아이쿱)인천광역시 계양구 오조산로 45번길 3032-541-5996공정무역 젤리, 사탕, 초콜릿, 바나나, 커피, 화장솜 등
910인천계양지역자활센터 카페보나 교통연수원점인천광역시 계양구 경명대로 990, 교통연수원 지하1층(계산동)070-5118-1580원두를 이용한 전메뉴
연번회사명주소전화번호판매품목
1516CU 계산중앙점인천광역시 계양구 계수로 61577-8007벤앤제리스 아이스크림
1617CU 쉐이프웍스점인천광역시 계양구 계양산로 1341577-8007벤앤제리스 아이스크림
1718GS 임학서로점인천광역시 계양구 임학서로 281644-5425벤앤제리스 아이스크림
1819GS 계양산시장점인천광역시 계양구 병방시장로 411644-5425벤앤제리스 아이스크림
1920롯데리아 인천계산점인천광역시 계양구 장제로 907032-543-3300원두를 이용한 전메뉴
2021롯데리아 홈플러스 계산점인천광역시 계양구 오조산공원로 14032-547-1644원두를 이용한 전메뉴
2122롯데리아 홈플러스 작전점인천광역시 계양구 계양대로 27032-555-7593원두를 이용한 전메뉴
2223롯데마트 계양점인천광역시 계양구 장제로 822032-550-2500벤앤제리스 아이스크림
2324엔제리너스 계산삼거리점인천광역시 계양구 경명대로 1045번길 3-1032-541-3828공정무역 원두 선택이 가능한 모든 음료
2425엔제리너스 계산점인천광역시 계양구 계양문화로 90032-547-4200공정무역 원두 선택이 가능한 모든 음료