Overview

Dataset statistics

Number of variables5
Number of observations389
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory16.1 KiB
Average record size in memory42.3 B

Variable types

Numeric2
DateTime1
Categorical2

Dataset

Description인천광역시 부평구 중증장애인생산품 구매 세부내역 데이터는 생산품 구매 일자, 판매시설, 구매금액, 세부 구매내역 데이터를 제공하고 있습니다.
Author인천광역시 부평구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15118777&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 unique valuesUnique

Reproduction

Analysis started2024-03-18 03:40:24.427154
Analysis finished2024-03-18 03:40:26.160669
Duration1.73 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct389
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean195
Minimum1
Maximum389
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.5 KiB
2024-03-18T12:40:26.224673image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile20.4
Q198
median195
Q3292
95-th percentile369.6
Maximum389
Range388
Interquartile range (IQR)194

Descriptive statistics

Standard deviation112.43887
Coefficient of variation (CV)0.5766096
Kurtosis-1.2
Mean195
Median Absolute Deviation (MAD)97
Skewness0
Sum75855
Variance12642.5
MonotonicityStrictly increasing
2024-03-18T12:40:26.346052image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.3%
245 1
 
0.3%
267 1
 
0.3%
266 1
 
0.3%
265 1
 
0.3%
264 1
 
0.3%
263 1
 
0.3%
262 1
 
0.3%
261 1
 
0.3%
260 1
 
0.3%
Other values (379) 379
97.4%
ValueCountFrequency (%)
1 1
0.3%
2 1
0.3%
3 1
0.3%
4 1
0.3%
5 1
0.3%
6 1
0.3%
7 1
0.3%
8 1
0.3%
9 1
0.3%
10 1
0.3%
ValueCountFrequency (%)
389 1
0.3%
388 1
0.3%
387 1
0.3%
386 1
0.3%
385 1
0.3%
384 1
0.3%
383 1
0.3%
382 1
0.3%
381 1
0.3%
380 1
0.3%
Distinct114
Distinct (%)29.3%
Missing0
Missing (%)0.0%
Memory size3.2 KiB
Minimum2023-01-03 00:00:00
Maximum2023-07-20 00:00:00
2024-03-18T12:40:26.471915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:40:26.590460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

판매시설
Categorical

HIGH CORRELATION 

Distinct26
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size3.2 KiB
인천광역시립 장애인생산품판매시설
171 
굿프랜드
42 
인천장애인생산품판매시설
36 
아이드림
35 
(사)한국근로장애인진흥회
30 
Other values (21)
75 

Length

Max length26
Median length22
Mean length12.22108
Min length2

Unique

Unique10 ?
Unique (%)2.6%

Sample

1st row(사)한국근로장애인진흥회
2nd row굿프랜드
3rd row인천광역시립 장애인생산품판매시설
4th row인천광역시립 장애인생산품판매시설
5th row인천광역시립 장애인생산품판매시설

Common Values

ValueCountFrequency (%)
인천광역시립 장애인생산품판매시설 171
44.0%
굿프랜드 42
 
10.8%
인천장애인생산품판매시설 36
 
9.3%
아이드림 35
 
9.0%
(사)한국근로장애인진흥회 30
 
7.7%
핸인핸부평 20
 
5.1%
해내기보호작업장 11
 
2.8%
창익 6
 
1.5%
(사)한국근로장애인진흥회 다원디자인프린팅 6
 
1.5%
이후 4
 
1.0%
Other values (16) 28
 
7.2%

Length

2024-03-18T12:40:26.720889image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
인천광역시립 171
29.3%
장애인생산품판매시설 171
29.3%
굿프랜드 42
 
7.2%
인천장애인생산품판매시설 36
 
6.2%
사)한국근로장애인진흥회 36
 
6.2%
아이드림 35
 
6.0%
핸인핸부평 20
 
3.4%
해내기보호작업장 11
 
1.9%
창익 6
 
1.0%
다원디자인프린팅 6
 
1.0%
Other values (25) 50
 
8.6%

구매금액
Real number (ℝ)

HIGH CORRELATION 

Distinct260
Distinct (%)66.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean720013.78
Minimum14520
Maximum45518000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.5 KiB
2024-03-18T12:40:26.876670image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum14520
5-th percentile58200
Q1142500
median242000
Q3480000
95-th percentile1938000
Maximum45518000
Range45503480
Interquartile range (IQR)337500

Descriptive statistics

Standard deviation2668991.3
Coefficient of variation (CV)3.7068614
Kurtosis207.43378
Mean720013.78
Median Absolute Deviation (MAD)127000
Skewness13.008629
Sum2.8008536 × 108
Variance7.1235145 × 1012
MonotonicityNot monotonic
2024-03-18T12:40:27.010314image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
284000 10
 
2.6%
568000 8
 
2.1%
285000 8
 
2.1%
180000 7
 
1.8%
110000 6
 
1.5%
105100 5
 
1.3%
570000 5
 
1.3%
260000 5
 
1.3%
190000 5
 
1.3%
77000 5
 
1.3%
Other values (250) 325
83.5%
ValueCountFrequency (%)
14520 1
 
0.3%
30800 1
 
0.3%
33000 1
 
0.3%
35000 2
0.5%
35600 3
0.8%
38500 1
 
0.3%
40000 2
0.5%
51700 1
 
0.3%
52500 2
0.5%
55000 4
1.0%
ValueCountFrequency (%)
45518000 1
0.3%
12924900 1
0.3%
11000000 1
0.3%
8930900 1
0.3%
8721000 1
0.3%
8713100 1
0.3%
7508600 1
0.3%
7342000 1
0.3%
6789000 1
0.3%
4935700 1
0.3%

세부구매내역
Categorical

HIGH CORRELATION 

Distinct26
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size3.2 KiB
<NA>
171 
장애인직업재활시설 복사용지,문구,전자배터리,복사용지
42 
장애인복지
36 
장애인직업재활시설 현수막 방향제 외
35 
각종 사무용지류, 화장지
30 
Other values (21)
75 

Length

Max length60
Median length56
Mean length12.347044
Min length2

Unique

Unique10 ?
Unique (%)2.6%

Sample

1st row각종 사무용지류, 화장지
2nd row장애인직업재활시설 복사용지,문구,전자배터리,복사용지
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 171
44.0%
장애인직업재활시설 복사용지,문구,전자배터리,복사용지 42
 
10.8%
장애인복지 36
 
9.3%
장애인직업재활시설 현수막 방향제 외 35
 
9.0%
각종 사무용지류, 화장지 30
 
7.7%
카트리지, 전산소모품, 통신판매 20
 
5.1%
면장갑(반코팅 등),화장지(두루마리,점보롤,핸드타올,미용티슈,냅킨,산업용와이퍼)/장애인직업재활시설&사회적기업 11
 
2.8%
가구 6
 
1.5%
인쇄물 6
 
1.5%
장애인직업재활시설/ 침구류, 치약, 비누, 및 기타 세제 제조업/ 린넨류 판매/ 린렌류 대여, 세탁업 4
 
1.0%
Other values (16) 28
 
7.2%

Length

2024-03-18T12:40:27.118959image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 171
23.5%
장애인직업재활시설 81
11.1%
복사용지,문구,전자배터리,복사용지 42
 
5.8%
38
 
5.2%
장애인복지 36
 
4.9%
현수막 35
 
4.8%
방향제 35
 
4.8%
화장지 32
 
4.4%
각종 30
 
4.1%
사무용지류 30
 
4.1%
Other values (46) 198
27.2%

Interactions

2024-03-18T12:40:25.879703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:40:25.516469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:40:25.952925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:40:25.648249image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-18T12:40:27.186864image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번판매시설구매금액세부구매내역
연번1.0000.1110.0730.141
판매시설0.1111.0000.8101.000
구매금액0.0730.8101.0000.891
세부구매내역0.1411.0000.8911.000
2024-03-18T12:40:27.260429image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
세부구매내역판매시설
세부구매내역1.0001.000
판매시설1.0001.000
2024-03-18T12:40:27.328606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구매금액판매시설세부구매내역
연번1.000-0.1380.0370.043
구매금액-0.1381.0000.5590.671
판매시설0.0370.5591.0001.000
세부구매내역0.0430.6711.0001.000

Missing values

2024-03-18T12:40:26.039927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-18T12:40:26.119771image/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

연번구매일자판매시설구매금액세부구매내역
012023-07-20(사)한국근로장애인진흥회375000각종 사무용지류, 화장지
122023-07-10굿프랜드560000장애인직업재활시설 복사용지,문구,전자배터리,복사용지
232023-07-07인천광역시립 장애인생산품판매시설1737000<NA>
342023-07-07인천광역시립 장애인생산품판매시설162000<NA>
452023-07-07인천광역시립 장애인생산품판매시설606000<NA>
562023-07-07인천광역시립 장애인생산품판매시설284000<NA>
672023-07-07인천광역시립 장애인생산품판매시설417000<NA>
782023-07-07춘천시장애인근로사업장268000복사용지,인쇄용지,화장지,마스크
892023-07-07인천광역시립 장애인생산품판매시설142000<NA>
9102023-07-06인천광역시립 장애인생산품판매시설210200<NA>
연번구매일자판매시설구매금액세부구매내역
3793802023-01-09인천광역시립 장애인생산품판매시설110000<NA>
3803812023-01-09(사)한국근로장애인진흥회240000각종 사무용지류, 화장지
3813822023-01-09(사)한국근로장애인진흥회99000각종 사무용지류, 화장지
3823832023-01-06(사)한국근로장애인진흥회270000각종 사무용지류, 화장지
3833842023-01-05인천광역시립 장애인생산품판매시설554300<NA>
3843852023-01-05아이드림937200장애인직업재활시설 현수막 방향제 외
3853862023-01-05아이드림673200장애인직업재활시설 현수막 방향제 외
3863872023-01-04(사)한국근로장애인진흥회 다원디자인프린팅115000인쇄물
3873882023-01-03(사)한국근로장애인진흥회177000각종 사무용지류, 화장지
3883892023-01-03유앤미직업재활원30800종이컵,사무용지류