Overview

Dataset statistics

Number of variables9
Number of observations135
Missing cells6
Missing cells (%)0.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory10.1 KiB
Average record size in memory77.0 B

Variable types

Categorical5
Numeric4

Dataset

Description인천광역시 부평구 기본생활필수품 가격입니다.(구분,품목,규격 및 단위,판매마트,조사자,가격,전주평균,금주평균,증감액,등락률)ex) 농산물,쌀,강화쌀 20kg,부평 깡시장,신진숙,
Author인천광역시 부평구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15051637&srcSe=7661IVAWM27C61E190

Alerts

규격 및 단위 is highly overall correlated with 전주평균 and 5 other fieldsHigh correlation
등락률 is highly overall correlated with 전주평균 and 5 other fieldsHigh correlation
품목 is highly overall correlated with 전주평균 and 5 other fieldsHigh correlation
가격 is highly overall correlated with 전주평균 and 1 other fieldsHigh correlation
전주평균 is highly overall correlated with 가격 and 4 other fieldsHigh correlation
금주평균 is highly overall correlated with 가격 and 4 other fieldsHigh correlation
증감액 is highly overall correlated with 품목 and 2 other fieldsHigh correlation
구분 is highly overall correlated with 품목 and 2 other fieldsHigh correlation
가격 has 6 (4.4%) missing valuesMissing
증감액 has 6 (4.4%) zerosZeros

Reproduction

Analysis started2024-03-18 03:18:30.817451
Analysis finished2024-03-18 03:18:32.700559
Duration1.88 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
공산품
54 
농산물
45 
수산물
21 
축산물
15 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row농산물
2nd row농산물
3rd row농산물
4th row농산물
5th row농산물

Common Values

ValueCountFrequency (%)
공산품 54
40.0%
농산물 45
33.3%
수산물 21
 
15.6%
축산물 15
 
11.1%

Length

2024-03-18T12:18:32.755288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T12:18:32.840036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공산품 54
40.0%
농산물 45
33.3%
수산물 21
 
15.6%
축산물 15
 
11.1%

품목
Categorical

HIGH CORRELATION 

Distinct44
Distinct (%)32.6%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
쌀
 
6
보리쌀
 
3
상추
 
3
배추
 
3
무
 
3
Other values (39)
117 

Length

Max length5
Median length4
Mean length2.4888889
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row쌀
2nd row쌀
3rd row쌀
4th row쌀
5th row쌀

Common Values

ValueCountFrequency (%)
쌀 6
 
4.4%
보리쌀 3
 
2.2%
상추 3
 
2.2%
배추 3
 
2.2%
무 3
 
2.2%
콩나물 3
 
2.2%
시금치 3
 
2.2%
깐마늘 3
 
2.2%
양파 3
 
2.2%
대파 3
 
2.2%
Other values (34) 102
75.6%

Length

2024-03-18T12:18:32.943222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
쌀 6
 
4.4%
보리쌀 3
 
2.2%
밀가루 3
 
2.2%
바지락 3
 
2.2%
홍합 3
 
2.2%
라면 3
 
2.2%
두부 3
 
2.2%
볶음멸치 3
 
2.2%
김 3
 
2.2%
건미역 3
 
2.2%
Other values (34) 102
75.6%

규격 및 단위
Categorical

HIGH CORRELATION 

Distinct44
Distinct (%)32.6%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
25cm정도 1마리 냉동
 
6
100g(껍데기포함상태 물빼고)
 
6
국산 1단
 
3
찰보리쌀 2kg
 
3
국산 1포기 중
 
3
Other values (39)
114 

Length

Max length21
Median length16
Mean length11.288889
Min length4

Unique

Unique1 ?
Unique (%)0.7%

Sample

1st row강화쌀 20kg
2nd row강화쌀 20kg
3rd row강화쌀 20kg
4th row김포쌀 20kg
5th row김포쌀 20kg

Common Values

ValueCountFrequency (%)
25cm정도 1마리 냉동 6
 
4.4%
100g(껍데기포함상태 물빼고) 6
 
4.4%
국산 1단 3
 
2.2%
찰보리쌀 2kg 3
 
2.2%
국산 1포기 중 3
 
2.2%
국산 1개 3
 
2.2%
400g 3
 
2.2%
섬초 1단 3
 
2.2%
국산 400g 3
 
2.2%
국산 1.5kg (망에 든것) 3
 
2.2%
Other values (34) 99
73.3%

Length

2024-03-18T12:18:33.049105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
국산 24
 
7.0%
1개 18
 
5.3%
1마리 15
 
4.4%
백설 12
 
3.5%
냉동 12
 
3.5%
1kg 12
 
3.5%
400g 9
 
2.6%
100g 9
 
2.6%
국내산 9
 
2.6%
중품 9
 
2.6%
Other values (65) 213
62.3%

판매마트
Categorical

Distinct3
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
부평 깡시장
45 
롯데마트 (부평점)
45 
하나로마트 (부평점)
45 

Length

Max length11
Median length10
Mean length9
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row부평 깡시장
2nd row롯데마트 (부평점)
3rd row하나로마트 (부평점)
4th row부평 깡시장
5th row롯데마트 (부평점)

Common Values

ValueCountFrequency (%)
부평 깡시장 45
33.3%
롯데마트 (부평점) 45
33.3%
하나로마트 (부평점) 45
33.3%

Length

2024-03-18T12:18:33.167507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T12:18:33.255480image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
부평점 90
33.3%
부평 45
16.7%
깡시장 45
16.7%
롯데마트 45
16.7%
하나로마트 45
16.7%

가격
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct98
Distinct (%)76.0%
Missing6
Missing (%)4.4%
Infinite0
Infinite (%)0.0%
Mean8091.3411
Minimum300
Maximum66900
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 KiB
2024-03-18T12:18:33.509417image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum300
5-th percentile1057.2
Q12290
median3980
Q37290
95-th percentile31768
Maximum66900
Range66600
Interquartile range (IQR)5000

Descriptive statistics

Standard deviation12782.75
Coefficient of variation (CV)1.5798061
Kurtosis10.763082
Mean8091.3411
Median Absolute Deviation (MAD)2000
Skewness3.2993384
Sum1043783
Variance1.633987 × 108
MonotonicityNot monotonic
2024-03-18T12:18:33.616559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3000 7
 
5.2%
3500 5
 
3.7%
1500 5
 
3.7%
1000 5
 
3.7%
4500 3
 
2.2%
1700 2
 
1.5%
3300 2
 
1.5%
4380 2
 
1.5%
1980 2
 
1.5%
1800 2
 
1.5%
Other values (88) 94
69.6%
(Missing) 6
 
4.4%
ValueCountFrequency (%)
300 1
 
0.7%
550 1
 
0.7%
1000 5
3.7%
1143 1
 
0.7%
1280 1
 
0.7%
1400 1
 
0.7%
1490 1
 
0.7%
1500 5
3.7%
1590 1
 
0.7%
1700 2
 
1.5%
ValueCountFrequency (%)
66900 1
0.7%
63000 1
0.7%
61250 1
0.7%
57000 1
0.7%
55000 1
0.7%
54000 1
0.7%
33000 1
0.7%
29920 1
0.7%
29500 1
0.7%
26500 1
0.7%

전주평균
Real number (ℝ)

HIGH CORRELATION 

Distinct45
Distinct (%)33.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7994.2222
Minimum372
Maximum49950
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 KiB
2024-03-18T12:18:33.727274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum372
5-th percentile1430
Q11953
median3749
Q38240
95-th percentile45800
Maximum49950
Range49578
Interquartile range (IQR)6287

Descriptive statistics

Standard deviation11815.264
Coefficient of variation (CV)1.4779755
Kurtosis6.5280808
Mean7994.2222
Median Absolute Deviation (MAD)2004
Skewness2.7046594
Sum1079220
Variance1.3960047 × 108
MonotonicityNot monotonic
2024-03-18T12:18:33.845579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=45)
ValueCountFrequency (%)
48633 3
 
2.2%
1800 3
 
2.2%
873 3
 
2.2%
372 3
 
2.2%
4063 3
 
2.2%
1663 3
 
2.2%
3749 3
 
2.2%
6430 3
 
2.2%
3107 3
 
2.2%
2803 3
 
2.2%
Other values (35) 105
77.8%
ValueCountFrequency (%)
372 3
2.2%
873 3
2.2%
1430 3
2.2%
1497 3
2.2%
1545 3
2.2%
1593 3
2.2%
1663 3
2.2%
1745 3
2.2%
1760 3
2.2%
1793 3
2.2%
ValueCountFrequency (%)
49950 3
2.2%
48633 3
2.2%
45800 3
2.2%
23250 3
2.2%
19990 3
2.2%
18627 3
2.2%
9777 3
2.2%
9680 3
2.2%
8953 3
2.2%
8550 3
2.2%

금주평균
Real number (ℝ)

HIGH CORRELATION 

Distinct45
Distinct (%)33.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8033.7333
Minimum425
Maximum62300
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 KiB
2024-03-18T12:18:33.972610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum425
5-th percentile1493
Q12400
median3747
Q37653
95-th percentile28173
Maximum62300
Range61875
Interquartile range (IQR)5253

Descriptive statistics

Standard deviation12551.167
Coefficient of variation (CV)1.5623081
Kurtosis10.761275
Mean8033.7333
Median Absolute Deviation (MAD)1957
Skewness3.301191
Sum1084554
Variance1.5753179 × 108
MonotonicityNot monotonic
2024-03-18T12:18:34.089640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=45)
ValueCountFrequency (%)
56750 3
 
2.2%
1693 3
 
2.2%
1830 3
 
2.2%
425 3
 
2.2%
4217 3
 
2.2%
1790 3
 
2.2%
3727 3
 
2.2%
7030 3
 
2.2%
3690 3
 
2.2%
2087 3
 
2.2%
Other values (35) 105
77.8%
ValueCountFrequency (%)
425 3
2.2%
1378 3
2.2%
1493 3
2.2%
1497 3
2.2%
1693 3
2.2%
1697 3
2.2%
1790 3
2.2%
1830 3
2.2%
1860 3
2.2%
1863 3
2.2%
ValueCountFrequency (%)
62300 3
2.2%
56750 3
2.2%
28173 3
2.2%
28000 3
2.2%
14660 3
2.2%
13000 3
2.2%
9883 3
2.2%
9163 3
2.2%
8793 3
2.2%
8083 3
2.2%

증감액
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct44
Distinct (%)32.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean39.511111
Minimum-17627
Maximum12350
Zeros6
Zeros (%)4.4%
Negative60
Negative (%)44.4%
Memory size1.3 KiB
2024-03-18T12:18:34.211538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-17627
5-th percentile-5330
Q1-223
median53
Q3600
95-th percentile4750
Maximum12350
Range29977
Interquartile range (IQR)823

Descriptive statistics

Standard deviation3786.5363
Coefficient of variation (CV)95.834721
Kurtosis11.40626
Mean39.511111
Median Absolute Deviation (MAD)469
Skewness-1.3978662
Sum5334
Variance14337857
MonotonicityNot monotonic
2024-03-18T12:18:34.333959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=44)
ValueCountFrequency (%)
0 6
 
4.4%
8117 3
 
2.2%
53 3
 
2.2%
153 3
 
2.2%
127 3
 
2.2%
-22 3
 
2.2%
600 3
 
2.2%
583 3
 
2.2%
-717 3
 
2.2%
-93 3
 
2.2%
Other values (34) 102
75.6%
ValueCountFrequency (%)
-17627 3
2.2%
-5627 3
2.2%
-5330 3
2.2%
-2020 3
2.2%
-1690 3
2.2%
-1300 3
2.2%
-960 3
2.2%
-717 3
2.2%
-416 3
2.2%
-267 3
2.2%
ValueCountFrequency (%)
12350 3
2.2%
8117 3
2.2%
4750 3
2.2%
2735 3
2.2%
1887 3
2.2%
1218 3
2.2%
1103 3
2.2%
1102 3
2.2%
958 3
2.2%
668 3
2.2%

등락률
Categorical

HIGH CORRELATION 

Distinct44
Distinct (%)32.6%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
0.00%
 
6
16.70%
 
3
-2.50%
 
3
30.40%
 
3
41.70%
 
3
Other values (39)
117 

Length

Max length7
Median length6
Mean length6.0222222
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row16.70%
2nd row16.70%
3rd row16.70%
4th row24.70%
5th row24.70%

Common Values

ValueCountFrequency (%)
0.00% 6
 
4.4%
16.70% 3
 
2.2%
-2.50% 3
 
2.2%
30.40% 3
 
2.2%
41.70% 3
 
2.2%
18.60% 3
 
2.2%
-15.20% 3
 
2.2%
78.90% 3
 
2.2%
1.30% 3
 
2.2%
-6.40% 3
 
2.2%
Other values (34) 102
75.6%

Length

2024-03-18T12:18:34.488464image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
0.00 6
 
4.4%
16.70 3
 
2.2%
4.80 3
 
2.2%
2.90 3
 
2.2%
14.20 3
 
2.2%
3.80 3
 
2.2%
7.60 3
 
2.2%
0.60 3
 
2.2%
9.30 3
 
2.2%
18.80 3
 
2.2%
Other values (34) 102
75.6%

Interactions

2024-03-18T12:18:32.187869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:18:31.273904image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:18:31.556391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:18:31.828407image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:18:32.270941image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:18:31.348287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:18:31.621948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:18:31.901739image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:18:32.357633image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:18:31.419236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:18:31.693775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:18:31.982947image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:18:32.459331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:18:31.489189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:18:31.762794image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:18:32.077104image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-18T12:18:34.598724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분품목규격 및 단위판매마트가격전주평균금주평균증감액등락률
구분1.0001.0001.0000.0000.3950.3850.3800.2760.999
품목1.0001.0001.0000.0000.8551.0001.0000.9701.000
규격 및 단위1.0001.0001.0000.0000.8701.0001.0000.9981.000
판매마트0.0000.0000.0001.0000.0580.0000.0000.0000.000
가격0.3950.8550.8700.0581.0000.8360.9100.8550.870
전주평균0.3851.0001.0000.0000.8361.0000.9920.9151.000
금주평균0.3801.0001.0000.0000.9100.9921.0000.9131.000
증감액0.2760.9700.9980.0000.8550.9150.9131.0001.000
등락률0.9991.0001.0000.0000.8701.0001.0001.0001.000
2024-03-18T12:18:34.703679image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
규격 및 단위등락률구분판매마트품목
규격 및 단위1.0000.9650.8330.0000.965
등락률0.9651.0000.8060.0000.983
구분0.8330.8061.0000.0000.833
판매마트0.0000.0000.0001.0000.000
품목0.9650.9830.8330.0001.000
2024-03-18T12:18:34.790275image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
가격전주평균금주평균증감액구분품목규격 및 단위판매마트등락률
가격1.0000.9220.9590.0680.2800.4670.4870.0350.487
전주평균0.9221.0000.956-0.1300.3270.8370.8370.0000.837
금주평균0.9590.9561.0000.0810.3230.8370.8370.0000.837
증감액0.068-0.1300.0811.0000.2940.7320.8310.0000.843
구분0.2800.3270.3230.2941.0000.8330.8330.0000.806
품목0.4670.8370.8370.7320.8331.0000.9650.0000.983
규격 및 단위0.4870.8370.8370.8310.8330.9651.0000.0000.965
판매마트0.0350.0000.0000.0000.0000.0000.0001.0000.000
등락률0.4870.8370.8370.8430.8060.9830.9650.0001.000

Missing values

2024-03-18T12:18:32.549904image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-18T12:18:32.653513image/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농산물쌀강화쌀 20kg부평 깡시장540004863356750811716.70%
1농산물쌀강화쌀 20kg롯데마트 (부평점)612504863356750811716.70%
2농산물쌀강화쌀 20kg하나로마트 (부평점)550004863356750811716.70%
3농산물쌀김포쌀 20kg부평 깡시장5700049950623001235024.70%
4농산물쌀김포쌀 20kg롯데마트 (부평점)6690049950623001235024.70%
5농산물쌀김포쌀 20kg하나로마트 (부평점)6300049950623001235024.70%
6농산물보리쌀찰보리쌀 2kg부평 깡시장600061978083188730.40%
7농산물보리쌀찰보리쌀 2kg롯데마트 (부평점)1290061978083188730.40%
8농산물보리쌀찰보리쌀 2kg하나로마트 (부평점)535061978083188730.40%
9농산물배추국산 1포기 중부평 깡시장400026453747110241.70%
구분품목규격 및 단위판매마트가격전주평균금주평균증감액등락률
125공산품가루비누비트(리필) 2.5kg하나로마트 (부평점)7480824087935536.70%
126공산품참치캔동원살코기참치 250g 1개부평 깡시장300037703620-150-4.00%
127공산품참치캔동원살코기참치 250g 1개롯데마트 (부평점)398037703620-150-4.00%
128공산품참치캔동원살코기참치 250g 1개하나로마트 (부평점)388037703620-150-4.00%
129공산품햄스팸 340g 1개부평 깡시장4500552058873676.60%
130공산품햄스팸 340g 1개롯데마트 (부평점)7180552058873676.60%
131공산품햄스팸 340g 1개하나로마트 (부평점)5980552058873676.60%
132공산품간장샘표진간장금F-S 930㎖부평 깡시장630065735613-960-14.60%
133공산품간장샘표진간장금F-S 930㎖롯데마트 (부평점)616065735613-960-14.60%
134공산품간장샘표진간장금F-S 930㎖하나로마트 (부평점)438065735613-960-14.60%