Overview

Dataset statistics

Number of variables5
Number of observations1056
Missing cells21
Missing cells (%)0.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory43.4 KiB
Average record size in memory42.1 B

Variable types

Categorical3
Numeric2

Dataset

Description2021년도 계룡시 관내 지역물가 정보에 대한 데이터로서 개인서비스에 관한 업종별 물가 정보에 대한 공공데이터를 제공합니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=310&beforeMenuCd=DOM_000000201001001000&publicdatapk=15093854

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 21 (2.0%) missing valuesMissing

Reproduction

Analysis started2024-01-09 22:17:53.401100
Analysis finished2024-01-09 22:17:53.994328
Duration0.59 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

품목
Categorical

HIGH CORRELATION 

Distinct44
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size8.4 KiB
설렁탕
 
24
냉면
 
24
생선초밥
 
24
삼계탕
 
24
갈비탕
 
24
Other values (39)
936 

Length

Max length10
Median length7
Mean length4.8181818
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row설렁탕
2nd row설렁탕
3rd row설렁탕
4th row설렁탕
5th row설렁탕

Common Values

ValueCountFrequency (%)
설렁탕 24
 
2.3%
냉면 24
 
2.3%
생선초밥 24
 
2.3%
삼계탕 24
 
2.3%
갈비탕 24
 
2.3%
불고기(공기밥제외) 24
 
2.3%
등심구이 24
 
2.3%
삼겹살(외식) 24
 
2.3%
된장찌개백반 24
 
2.3%
김치찌개백반 24
 
2.3%
Other values (34) 816
77.3%

Length

2024-01-10T07:17:54.056309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
설렁탕 24
 
2.2%
다방커피 24
 
2.2%
다방 24
 
2.2%
국산차 24
 
2.2%
pc방이용료 24
 
2.2%
택배수수료 24
 
2.2%
양복세탁료 24
 
2.2%
골프연습장이용료 24
 
2.2%
당구장이용료 24
 
2.2%
노래방이용료 24
 
2.2%
Other values (35) 840
77.8%

품목 기준
Categorical

HIGH CORRELATION 

Distinct33
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Memory size8.4 KiB
대중식당 1그릇
96 
성인 중급 1회
96 
쇠고기 200∼250g정도
 
48
대중식당 1인분
 
48
일반대중탕 1회
 
48
Other values (28)
720 

Length

Max length23
Median length15
Mean length10.113636
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대중식당 1그릇
2nd row대중식당 1그릇
3rd row대중식당 1그릇
4th row대중식당 1그릇
5th row대중식당 1그릇

Common Values

ValueCountFrequency (%)
대중식당 1그릇 96
 
9.1%
성인 중급 1회 96
 
9.1%
쇠고기 200∼250g정도 48
 
4.5%
대중식당 1인분 48
 
4.5%
일반대중탕 1회 48
 
4.5%
중화요리집 1그릇 48
 
4.5%
성인 오후 60분 48
 
4.5%
분식집, 1인분 24
 
2.3%
생갈비200-250g 24
 
2.3%
경양식집 1인분 24
 
2.3%
Other values (23) 552
52.3%

Length

2024-01-10T07:17:54.177130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
성인 168
 
7.5%
1회 168
 
7.5%
1그릇 168
 
7.5%
대중식당 144
 
6.5%
1인분 120
 
5.4%
중급 96
 
4.3%
전문점 96
 
4.3%
60분 72
 
3.2%
200∼250g정도 72
 
3.2%
중화요리집 72
 
3.2%
Other values (40) 1056
47.3%

조사연월
Real number (ℝ)

Distinct8
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean203354.5
Minimum202101
Maximum212103
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size9.4 KiB
2024-01-10T07:17:54.272906image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum202101
5-th percentile202101
Q1202103.5
median202105.5
Q3202107.25
95-th percentile212103
Maximum212103
Range10002
Interquartile range (IQR)3.75

Descriptive statistics

Standard deviation3308.1897
Coefficient of variation (CV)0.016268092
Kurtosis3.1634872
Mean203354.5
Median Absolute Deviation (MAD)2
Skewness2.2710119
Sum2.1474235 × 108
Variance10944119
MonotonicityNot monotonic
2024-01-10T07:17:54.354158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
202101 132
12.5%
202102 132
12.5%
212103 132
12.5%
202104 132
12.5%
202105 132
12.5%
202106 132
12.5%
202107 132
12.5%
202108 132
12.5%
ValueCountFrequency (%)
202101 132
12.5%
202102 132
12.5%
202104 132
12.5%
202105 132
12.5%
202106 132
12.5%
202107 132
12.5%
202108 132
12.5%
212103 132
12.5%
ValueCountFrequency (%)
212103 132
12.5%
202108 132
12.5%
202107 132
12.5%
202106 132
12.5%
202105 132
12.5%
202104 132
12.5%
202102 132
12.5%
202101 132
12.5%

조사시기
Categorical

Distinct3
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size8.4 KiB
초순
352 
중순
352 
하순
352 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row초순
2nd row중순
3rd row하순
4th row초순
5th row중순

Common Values

ValueCountFrequency (%)
초순 352
33.3%
중순 352
33.3%
하순 352
33.3%

Length

2024-01-10T07:17:54.449795image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:17:54.522774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
초순 352
33.3%
중순 352
33.3%
하순 352
33.3%

금액
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct37
Distinct (%)3.6%
Missing21
Missing (%)2.0%
Infinite0
Infinite (%)0.0%
Mean17324.348
Minimum300
Maximum250000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size9.4 KiB
2024-01-10T07:17:54.606198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum300
5-th percentile3000
Q15000
median8000
Q312000
95-th percentile60000
Maximum250000
Range249700
Interquartile range (IQR)7000

Descriptive statistics

Standard deviation37736.923
Coefficient of variation (CV)2.1782593
Kurtosis28.323135
Mean17324.348
Median Absolute Deviation (MAD)4000
Skewness5.2071313
Sum17930700
Variance1.4240753 × 109
MonotonicityNot monotonic
2024-01-10T07:17:54.702014image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=37)
ValueCountFrequency (%)
10000 105
 
9.9%
12000 84
 
8.0%
5000 84
 
8.0%
6000 81
 
7.7%
3000 63
 
6.0%
15000 51
 
4.8%
3500 51
 
4.8%
8000 45
 
4.3%
5500 39
 
3.7%
9000 39
 
3.7%
Other values (27) 393
37.2%
ValueCountFrequency (%)
300 24
 
2.3%
1000 21
 
2.0%
2500 6
 
0.6%
3000 63
6.0%
3100 3
 
0.3%
3400 6
 
0.6%
3500 51
4.8%
3900 18
 
1.7%
4000 21
 
2.0%
4500 12
 
1.1%
ValueCountFrequency (%)
250000 21
2.0%
200000 3
 
0.3%
80000 24
2.3%
60000 9
 
0.9%
55000 3
 
0.3%
40000 24
2.3%
35000 24
2.3%
25000 18
1.7%
23000 21
2.0%
20000 6
 
0.6%

Interactions

2024-01-10T07:17:53.736037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:17:53.598960image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:17:53.807074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:17:53.666180image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T07:17:54.767903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
품목품목 기준조사연월조사시기금액
품목1.0001.0000.0000.0000.982
품목 기준1.0001.0000.0000.0000.966
조사연월0.0000.0001.0000.0000.000
조사시기0.0000.0000.0001.0000.000
금액0.9820.9660.0000.0001.000
2024-01-10T07:17:54.852931image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
품목 기준조사시기품목
품목 기준1.0000.0000.995
조사시기0.0001.0000.000
품목0.9950.0001.000
2024-01-10T07:17:54.928420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
조사연월금액품목품목 기준조사시기
조사연월1.0000.0110.0000.0000.000
금액0.0111.0000.8730.8330.000
품목0.0000.8731.0000.9950.000
품목 기준0.0000.8330.9951.0000.000
조사시기0.0000.0000.0000.0001.000

Missing values

2024-01-10T07:17:53.894176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T07:17:53.965089image/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설렁탕대중식당 1그릇202101초순10000
1설렁탕대중식당 1그릇202101중순10000
2설렁탕대중식당 1그릇202101하순10000
3설렁탕대중식당 1그릇202102초순10000
4설렁탕대중식당 1그릇202102중순10000
5설렁탕대중식당 1그릇202102하순10000
6설렁탕대중식당 1그릇212103초순10000
7설렁탕대중식당 1그릇212103중순10000
8설렁탕대중식당 1그릇212103하순10000
9설렁탕대중식당 1그릇202104초순10000
품목품목 기준조사연월조사시기금액
1046의복수선료남자신사복하의수선(밑단줄임)202105하순3000
1047의복수선료남자신사복하의수선(밑단줄임)202106초순3000
1048의복수선료남자신사복하의수선(밑단줄임)202106중순3000
1049의복수선료남자신사복하의수선(밑단줄임)202106하순3000
1050의복수선료남자신사복하의수선(밑단줄임)202107초순3000
1051의복수선료남자신사복하의수선(밑단줄임)202107중순3000
1052의복수선료남자신사복하의수선(밑단줄임)202107하순3000
1053의복수선료남자신사복하의수선(밑단줄임)202108초순3000
1054의복수선료남자신사복하의수선(밑단줄임)202108중순3000
1055의복수선료남자신사복하의수선(밑단줄임)202108하순3000