Overview

Dataset statistics

Number of variables4
Number of observations89
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.0 KiB
Average record size in memory34.5 B

Variable types

Categorical3
Numeric1

Dataset

Description인천광역시 연수구 개인서비스 요금 현황에 대한 데이터로서 구분, 품목, 규격 및 단위, 금주가격 등의 항목으로 이루어져 있습니다.
Author인천광역시 연수구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=3068235&srcSe=7661IVAWM27C61E190

Alerts

규격 및 단위 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
금주가격 (평균_원) has 2 (2.2%) zerosZeros

Reproduction

Analysis started2024-04-20 18:49:38.954379
Analysis finished2024-04-20 18:49:40.323459
Duration1.37 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구 분
Categorical

Distinct3
Distinct (%)3.4%
Missing0
Missing (%)0.0%
Memory size844.0 B
대형마트
31 
기업형슈퍼마켓
31 
옥련시장
27 

Length

Max length7
Median length4
Mean length5.0449438
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대형마트
2nd row대형마트
3rd row대형마트
4th row대형마트
5th row대형마트

Common Values

ValueCountFrequency (%)
대형마트 31
34.8%
기업형슈퍼마켓 31
34.8%
옥련시장 27
30.3%

Length

2024-04-21T03:49:40.392325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T03:49:40.486307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대형마트 31
34.8%
기업형슈퍼마켓 31
34.8%
옥련시장 27
30.3%

품 목
Categorical

HIGH CORRELATION 

Distinct31
Distinct (%)34.8%
Missing0
Missing (%)0.0%
Memory size844.0 B
쌀
 
3
달 걀
 
3
화 장 지
 
3
돼지고기
 
3
쇠 고 기
 
3
Other values (26)
74 

Length

Max length8
Median length8
Mean length6.2134831
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row쌀
2nd row콩 나 물
3rd row마 늘
4th row양 파
5th row대 파

Common Values

ValueCountFrequency (%)
쌀 3
 
3.4%
달 걀 3
 
3.4%
화 장 지 3
 
3.4%
돼지고기 3
 
3.4%
쇠 고 기 3
 
3.4%
멸 치 3
 
3.4%
고 등 어 3
 
3.4%
배 추 3
 
3.4%
닭 고 기 3
 
3.4%
무 3
 
3.4%
Other values (21) 59
66.3%

Length

2024-04-21T03:49:40.582495image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
고 12
 
6.6%
유 8
 
4.4%
추 6
 
3.3%
콩 6
 
3.3%
장 6
 
3.3%
기 6
 
3.3%
파 6
 
3.3%
쌀 3
 
1.7%
나 3
 
1.7%
물 3
 
1.7%
Other values (43) 122
67.4%

규격 및 단위
Categorical

HIGH CORRELATION 

Distinct32
Distinct (%)36.0%
Missing0
Missing (%)0.0%
Memory size844.0 B
1 kg
 
6
백태/1kg
 
3
통배추/3kg
 
3
특란/1판(30개)
 
3
재래종, 잎없음1 kg
 
3
Other values (27)
71 

Length

Max length14
Median length12
Mean length8.2022472
Min length4

Unique

Unique2 ?
Unique (%)2.2%

Sample

1st row쌀/20kg
2nd row400g
3rd row깐마늘 1kg
4th row1 kg
5th row1 kg

Common Values

ValueCountFrequency (%)
1 kg 6
 
6.7%
백태/1kg 3
 
3.4%
통배추/3kg 3
 
3.4%
특란/1판(30개) 3
 
3.4%
재래종, 잎없음1 kg 3
 
3.4%
1마리/35∼38cm 3
 
3.4%
다시멸치/400g 3
 
3.4%
깐마늘 1kg 3
 
3.4%
생삼겹살/500g 3
 
3.4%
쌀/20kg 3
 
3.4%
Other values (22) 56
62.9%

Length

2024-04-21T03:49:40.683615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
kg 9
 
8.0%
1 6
 
5.3%
중품/1kg 3
 
2.7%
백설탕(제일)/3kg 3
 
2.7%
cj/0.9ℓ 3
 
2.7%
새우깡(소)/1봉지 3
 
2.7%
신라면/1개 3
 
2.7%
엠보싱/30롤 3
 
2.7%
네추럴 3
 
2.7%
뽀삐 3
 
2.7%
Other values (28) 74
65.5%

금주가격 (평균_원)
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct83
Distinct (%)93.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean9151.2921
Minimum0
Maximum51900
Zeros2
Zeros (%)2.2%
Negative0
Negative (%)0.0%
Memory size933.0 B
2024-04-21T03:49:40.785378image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile746.8
Q11655
median4950
Q310790
95-th percentile36700
Maximum51900
Range51900
Interquartile range (IQR)9135

Descriptive statistics

Standard deviation11736.665
Coefficient of variation (CV)1.2825145
Kurtosis4.5653271
Mean9151.2921
Median Absolute Deviation (MAD)3667
Skewness2.1859991
Sum814465
Variance1.377493 × 108
MonotonicityNot monotonic
2024-04-21T03:49:40.908650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4450 2
 
2.2%
0 2
 
2.2%
1190 2
 
2.2%
3000 2
 
2.2%
5000 2
 
2.2%
2000 2
 
2.2%
1250 1
 
1.1%
4950 1
 
1.1%
11800 1
 
1.1%
49450 1
 
1.1%
Other values (73) 73
82.0%
ValueCountFrequency (%)
0 2
2.2%
650 1
1.1%
705 1
1.1%
734 1
1.1%
766 1
1.1%
836 1
1.1%
850 1
1.1%
950 1
1.1%
990 1
1.1%
1000 1
1.1%
ValueCountFrequency (%)
51900 1
1.1%
49450 1
1.1%
48500 1
1.1%
45000 1
1.1%
42500 1
1.1%
28000 1
1.1%
27900 1
1.1%
25930 1
1.1%
25033 1
1.1%
25000 1
1.1%

Interactions

2024-04-21T03:49:39.974855image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-21T03:49:40.980930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구 분품 목규격 및 단위금주가격 (평균_원)
구 분1.0000.0000.0000.000
품 목0.0001.0000.9990.897
규격 및 단위0.0000.9991.0000.927
금주가격 (평균_원)0.0000.8970.9271.000
2024-04-21T03:49:41.058341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구 분규격 및 단위품 목
구 분1.0000.0000.000
규격 및 단위0.0001.0000.965
품 목0.0000.9651.000
2024-04-21T03:49:41.131010image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
금주가격 (평균_원)구 분품 목규격 및 단위
금주가격 (평균_원)1.0000.0000.5280.531
구 분0.0001.0000.0000.000
품 목0.5280.0001.0000.965
규격 및 단위0.5310.0000.9651.000

Missing values

2024-04-21T03:49:40.224522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T03:49:40.290298image/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대형마트쌀쌀/20kg51900
1대형마트콩 나 물400g2380
2대형마트마 늘깐마늘 1kg15800
3대형마트양 파1 kg3230
4대형마트대 파1 kg5200
5대형마트무재래종, 잎없음1 kg1480
6대형마트배 추통배추/3kg0
7대형마트사 과개당/250∼300g1655
8대형마트고 등 어1마리/35∼38cm3745
9대형마트멸 치다시멸치/400g7950
구 분품 목규격 및 단위금주가격 (평균_원)
79기업형슈퍼마켓스넥과자새우깡(소)/1봉지950
80기업형슈퍼마켓라 면신라면/1개836
81기업형슈퍼마켓빵샤니식빵(소)/1개1700
82기업형슈퍼마켓분 유남양XO/800g/1단계25033
83기업형슈퍼마켓두 부포장두부300g1397
84기업형슈퍼마켓고 추 장해찬들/1kg11790
85기업형슈퍼마켓소 주참이슬/1병1190
86기업형슈퍼마켓세 제비트(리필)/3kg8567
87기업형슈퍼마켓샴 푸엘라스틴/780g10933
88기업형슈퍼마켓화 장 지뽀삐 네추럴 엠보싱/30롤15400