gimi9 Pandas Profiling

Dataset statistics

Number of variables	19
Number of observations	29
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.9 KiB
Average record size in memory	171.6 B

Variable types

Categorical	5
Numeric	10
DateTime	4

Dataset

Description	인천광역시 부평구 음식물류폐기물 기간별 제작현황(site코드,스티커시작번호,스티커종류번호,상품코드,상품종류,제작상태,수주전표번호,발주업체코드,제조업체코드,제작시작일시,제작종료일시,스티커제작요청수량,제작완료 수량,묶음수량,묶음당 매수,BOX 당 묶음수량,최종제작스티커번호,입력일,업데이트일)
Author	인천광역시 부평구
URL	https://data.incheon.go.kr/findData/publicDataDetail?dataId=15062410&srcSe=7661IVAWM27C61E190

Alerts

`site코드` has constant value ""	Constant
`발주업체코드` has constant value ""	Constant
`스티커시작번호` is highly overall correlated with `스티커종류번호` and 5 other fields	High correlation
`스티커종류번호` is highly overall correlated with `스티커시작번호` and 5 other fields	High correlation
`상품코드` is highly overall correlated with `스티커시작번호` and 5 other fields	High correlation
`상품종류` is highly overall correlated with `스티커시작번호` and 5 other fields	High correlation
`스티커제작요청수량` is highly overall correlated with `제작완료 수량` and 4 other fields	High correlation
`제작완료 수량` is highly overall correlated with `스티커제작요청수량` and 4 other fields	High correlation
`묶음수량` is highly overall correlated with `스티커제작요청수량` and 2 other fields	High correlation
`묶음당 매수` is highly overall correlated with `스티커제작요청수량` and 2 other fields	High correlation
`BOX 당 묶음수량` is highly overall correlated with `상품코드` and 4 other fields	High correlation
`최종제작스티커번호` is highly overall correlated with `스티커시작번호` and 5 other fields	High correlation
`제작상태` is highly overall correlated with `스티커시작번호` and 3 other fields	High correlation
`수주전표번호` is highly overall correlated with `스티커시작번호` and 3 other fields	High correlation
`제조업체코드` is highly overall correlated with `상품코드` and 4 other fields	High correlation
`제작상태` is highly imbalanced (63.8%)	Imbalance

Reproduction

Analysis started	2024-01-28 12:29:12.964256
Analysis finished	2024-01-28 12:29:21.899238
Duration	8.93 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

site코드
Categorical

CONSTANT

Distinct	1
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Memory size	364.0 B

306	29

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
306	29	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
306	29	100.0%

스티커시작번호
Real number (ℝ)

HIGH CORRELATION

Distinct	8
Distinct (%)	27.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.0031997 × 10¹⁶

Minimum	2.00102 × 10¹⁶
Maximum	2.00717 × 10¹⁶
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	393.0 B

Quantile statistics

Minimum	2.00102 × 10¹⁶
5-th percentile	2.00102 × 10¹⁶
Q1	2.0012 × 10¹⁶
median	2.00228 × 10¹⁶
Q3	2.00529 × 10¹⁶
95-th percentile	2.00717 × 10¹⁶
Maximum	2.00717 × 10¹⁶
Range	6.15 × 10¹³
Interquartile range (IQR)	4.09 × 10¹³

Descriptive statistics

Standard deviation	2.283047 × 10¹³
Coefficient of variation (CV)	0.0011397002
Kurtosis	-1.1765784
Mean	2.0031997 × 10¹⁶
Median Absolute Deviation (MAD)	1.26 × 10¹³
Skewness	0.58090917
Sum	5.809279 × 10¹⁷
Variance	5.2123034 × 10²⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
20010200000000000	5	17.2%
20052900000000000	5	17.2%
20012000000000000	4	13.8%
20040300000000000	4	13.8%
20071700000000000	4	13.8%
20022800000000000	3	10.3%
20011700000000000	2	6.9%
20012300000000000	2	6.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20010200000000000	5	17.2%
20011700000000000	2	6.9%
20012000000000000	4	13.8%
20012300000000000	2	6.9%
20022800000000000	3	10.3%
20040300000000000	4	13.8%
20052900000000000	5	17.2%
20071700000000000	4	13.8%

Value	Count	Frequency (%)
20071700000000000	4	13.8%
20052900000000000	5	17.2%
20040300000000000	4	13.8%
20022800000000000	3	10.3%
20012300000000000	2	6.9%
20012000000000000	4	13.8%
20011700000000000	2	6.9%
20010200000000000	5	17.2%

스티커종류번호
Real number (ℝ)

HIGH CORRELATION

Distinct	8
Distinct (%)	27.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.0031997 × 10¹⁶

Minimum	2.00102 × 10¹⁶
Maximum	2.00717 × 10¹⁶
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	393.0 B

Quantile statistics

Minimum	2.00102 × 10¹⁶
5-th percentile	2.00102 × 10¹⁶
Q1	2.0012 × 10¹⁶
median	2.00228 × 10¹⁶
Q3	2.00529 × 10¹⁶
95-th percentile	2.00717 × 10¹⁶
Maximum	2.00717 × 10¹⁶
Range	6.15 × 10¹³
Interquartile range (IQR)	4.09 × 10¹³

Descriptive statistics

Standard deviation	2.283047 × 10¹³
Coefficient of variation (CV)	0.0011397002
Kurtosis	-1.1765784
Mean	2.0031997 × 10¹⁶
Median Absolute Deviation (MAD)	1.26 × 10¹³
Skewness	0.58090917
Sum	5.809279 × 10¹⁷
Variance	5.2123034 × 10²⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
20010200000000000	5	17.2%
20052900000000000	5	17.2%
20012000000000000	4	13.8%
20040300000000000	4	13.8%
20071700000000000	4	13.8%
20022800000000000	3	10.3%
20011700000000000	2	6.9%
20012300000000000	2	6.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20010200000000000	5	17.2%
20011700000000000	2	6.9%
20012000000000000	4	13.8%
20012300000000000	2	6.9%
20022800000000000	3	10.3%
20040300000000000	4	13.8%
20052900000000000	5	17.2%
20071700000000000	4	13.8%

Value	Count	Frequency (%)
20071700000000000	4	13.8%
20052900000000000	5	17.2%
20040300000000000	4	13.8%
20022800000000000	3	10.3%
20012300000000000	2	6.9%
20012000000000000	4	13.8%
20011700000000000	2	6.9%
20010200000000000	5	17.2%

상품코드
Real number (ℝ)

HIGH CORRELATION

Distinct	20
Distinct (%)	69.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4998.5172

Minimum	1003
Maximum	8050
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	393.0 B

Quantile statistics

Minimum	1003
5-th percentile	1011
Q1	2010
median	5100
Q3	8010
95-th percentile	8042
Maximum	8050
Range	7047
Interquartile range (IQR)	6000

Descriptive statistics

Standard deviation	2652.8502
Coefficient of variation (CV)	0.53072743
Kurtosis	-1.3467771
Mean	4998.5172
Median Absolute Deviation (MAD)	2910
Skewness	-0.37032593
Sum	144957
Variance	7037614.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
8010	3	10.3%
6020	3	10.3%
8030	3	10.3%
8050	2	6.9%
5050	2	6.9%
5010	2	6.9%
6125	1	3.4%
6060	1	3.4%
7020	1	3.4%
5005	1	3.4%
Other values (10)	10	34.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1003	1	3.4%
1005	1	3.4%
1020	1	3.4%
1060	1	3.4%
1121	1	3.4%
2003	1	3.4%
2005	1	3.4%
2010	1	3.4%
2020	1	3.4%
5005	1	3.4%

Value	Count	Frequency (%)
8050	2	6.9%
8030	3	10.3%
8010	3	10.3%
7020	1	3.4%
6125	1	3.4%
6060	1	3.4%
6020	3	10.3%
5100	1	3.4%
5050	2	6.9%
5010	2	6.9%

상품종류
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	20.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.9655172

Minimum	1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	393.0 B

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	5
Q3	8
95-th percentile	8
Maximum	8
Range	7
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	2.6522599
Coefficient of variation (CV)	0.53413568
Kurtosis	-1.3406195
Mean	4.9655172
Median Absolute Deviation (MAD)	3
Skewness	-0.36725312
Sum	144
Variance	7.0344828
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
8	8	27.6%
5	6	20.7%
1	5	17.2%
6	5	17.2%
2	4	13.8%
7	1	3.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5	17.2%
2	4	13.8%
5	6	20.7%
6	5	17.2%
7	1	3.4%
8	8	27.6%

Value	Count	Frequency (%)
8	8	27.6%
7	1	3.4%
6	5	17.2%
5	6	20.7%
2	4	13.8%
1	5	17.2%

제작상태
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	6.9%
Missing	0
Missing (%)	0.0%
Memory size	364.0 B

3	27
2	2

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
3	27	93.1%
2	2	6.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
3	27	93.1%
2	2	6.9%

수주전표번호
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	17.2%
Missing	0
Missing (%)	0.0%
Memory size	364.0 B

2020010000000000000	13
2020050000000000000	5
2020040000000000000	4
2020070000000000000	4
2020020000000000000	3

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2020020000000000000
2nd row	2020020000000000000
3rd row	2020020000000000000
4th row	2020010000000000000
5th row	2020010000000000000

Common Values

Value	Count	Frequency (%)
2020010000000000000	13	44.8%
2020050000000000000	5	17.2%
2020040000000000000	4	13.8%
2020070000000000000	4	13.8%
2020020000000000000	3	10.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2020010000000000000	13	44.8%
2020050000000000000	5	17.2%
2020040000000000000	4	13.8%
2020070000000000000	4	13.8%
2020020000000000000	3	10.3%

발주업체코드
Categorical

CONSTANT

Distinct	1
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Memory size	364.0 B

1001	29

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
1001	29	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1001	29	100.0%

제조업체코드
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	13.8%
Missing	0
Missing (%)	0.0%
Memory size	364.0 B

1001	17
1003	5
1002	4
1004	3

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
1001	17	58.6%
1003	5	17.2%
1002	4	13.8%
1004	3	10.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1001	17	58.6%
1003	5	17.2%
1002	4	13.8%
1004	3	10.3%

제작시작일
Date

Distinct	16
Distinct (%)	55.2%
Missing	0
Missing (%)	0.0%
Memory size	364.0 B

Minimum	2020-01-02 00:00:00
Maximum	2020-07-21 00:00:00

Histogram

Histogram with fixed size bins (bins=16)

제작종료일
Date

Distinct	17
Distinct (%)	58.6%
Missing	0
Missing (%)	0.0%
Memory size	364.0 B

Minimum	2020-01-02 00:00:00
Maximum	2020-07-25 00:00:00

Histogram

Histogram with fixed size bins (bins=17)

스티커제작요청수량
Real number (ℝ)

HIGH CORRELATION

Distinct	13
Distinct (%)	44.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	269041.38

Minimum	100
Maximum	1000000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	393.0 B

Quantile statistics

Minimum	100
5-th percentile	460
Q1	30000
median	50000
Q3	300000
95-th percentile	1000000
Maximum	1000000
Range	999900
Interquartile range (IQR)	270000

Descriptive statistics

Standard deviation	362081.65
Coefficient of variation (CV)	1.3458214
Kurtosis	0.18616989
Mean	269041.38
Median Absolute Deviation (MAD)	49000
Skewness	1.2975906
Sum	7802200
Variance	1.3110312 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
30000	8	27.6%
300000	4	13.8%
1000000	4	13.8%
50000	2	6.9%
1000	2	6.9%
100	2	6.9%
250000	1	3.4%
10000	1	3.4%
400000	1	3.4%
900000	1	3.4%
Other values (3)	3	10.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
100	2	6.9%
1000	2	6.9%
10000	1	3.4%
30000	8	27.6%
40000	1	3.4%
50000	2	6.9%
60000	1	3.4%
250000	1	3.4%
300000	4	13.8%
400000	1	3.4%

Value	Count	Frequency (%)
1000000	4	13.8%
900000	1	3.4%
600000	1	3.4%
400000	1	3.4%
300000	4	13.8%
250000	1	3.4%
60000	1	3.4%
50000	2	6.9%
40000	1	3.4%
30000	8	27.6%

제작완료 수량
Real number (ℝ)

HIGH CORRELATION

Distinct	15
Distinct (%)	51.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	268006.9

Minimum	100
Maximum	1000000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	393.0 B

Quantile statistics

Minimum	100
5-th percentile	460
Q1	30000
median	50000
Q3	300000
95-th percentile	1000000
Maximum	1000000
Range	999900
Interquartile range (IQR)	270000

Descriptive statistics

Standard deviation	362823.1
Coefficient of variation (CV)	1.3537827
Kurtosis	0.17920297
Mean	268006.9
Median Absolute Deviation (MAD)	49000
Skewness	1.2942678
Sum	7772200
Variance	1.316406 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
30000	6	20.7%
300000	4	13.8%
1000000	4	13.8%
50000	2	6.9%
1000	2	6.9%
100	2	6.9%
250000	1	3.4%
10000	1	3.4%
400000	1	3.4%
900000	1	3.4%
Other values (5)	5	17.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
100	2	6.9%
1000	2	6.9%
3000	1	3.4%
10000	1	3.4%
27000	1	3.4%
30000	6	20.7%
40000	1	3.4%
50000	2	6.9%
60000	1	3.4%
250000	1	3.4%

Value	Count	Frequency (%)
1000000	4	13.8%
900000	1	3.4%
600000	1	3.4%
400000	1	3.4%
300000	4	13.8%
250000	1	3.4%
60000	1	3.4%
50000	2	6.9%
40000	1	3.4%
30000	6	20.7%

묶음수량
Real number (ℝ)

HIGH CORRELATION

Distinct	13
Distinct (%)	44.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9182.7586

Minimum	100
Maximum	30000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	393.0 B

Quantile statistics

Minimum	100
5-th percentile	140
Q1	1500
median	3000
Q3	20000
95-th percentile	30000
Maximum	30000
Range	29900
Interquartile range (IQR)	18500

Descriptive statistics

Standard deviation	10165.455
Coefficient of variation (CV)	1.1070154
Kurtosis	-0.47893511
Mean	9182.7586
Median Absolute Deviation (MAD)	2800
Skewness	0.99041992
Sum	266300
Variance	1.0333648 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
3000	7	24.1%
20000	5	17.2%
30000	3	10.3%
5000	2	6.9%
1000	2	6.9%
200	2	6.9%
100	2	6.9%
1500	1	3.4%
1200	1	3.4%
18000	1	3.4%
Other values (3)	3	10.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
100	2	6.9%
200	2	6.9%
1000	2	6.9%
1200	1	3.4%
1500	1	3.4%
3000	7	24.1%
4000	1	3.4%
5000	2	6.9%
6000	1	3.4%
12000	1	3.4%

Value	Count	Frequency (%)
30000	3	10.3%
20000	5	17.2%
18000	1	3.4%
12000	1	3.4%
6000	1	3.4%
5000	2	6.9%
4000	1	3.4%
3000	7	24.1%
1500	1	3.4%
1200	1	3.4%

묶음당 매수
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	20.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.551724

Minimum	1
Maximum	250
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	393.0 B

Quantile statistics

Minimum	1
5-th percentile	2.6
Q1	10
median	10
Q3	50
95-th percentile	170
Maximum	250
Range	249
Interquartile range (IQR)	40

Descriptive statistics

Standard deviation	62.028557
Coefficient of variation (CV)	1.7952377
Kurtosis	9.563557
Mean	34.551724
Median Absolute Deviation (MAD)	0
Skewness	3.1612924
Sum	1002
Variance	3847.5419
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
10	15	51.7%
50	6	20.7%
20	2	6.9%
250	2	6.9%
5	2	6.9%
1	2	6.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	6.9%
5	2	6.9%
10	15	51.7%
20	2	6.9%
50	6	20.7%
250	2	6.9%

Value	Count	Frequency (%)
250	2	6.9%
50	6	20.7%
20	2	6.9%
10	15	51.7%
5	2	6.9%
1	2	6.9%

BOX 당 묶음수량
Real number (ℝ)

HIGH CORRELATION

Distinct	7
Distinct (%)	24.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	101.72414

Minimum	5
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	393.0 B

Quantile statistics

Minimum	5
5-th percentile	7
Q1	10
median	20
Q3	20
95-th percentile	800
Maximum	1000
Range	995
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	264.62668
Coefficient of variation (CV)	2.6014148
Kurtosis	8.6429026
Mean	101.72414
Median Absolute Deviation (MAD)	10
Skewness	3.0976813
Sum	2950
Variance	70027.278
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
10	11	37.9%
20	10	34.5%
40	2	6.9%
1000	2	6.9%
5	2	6.9%
500	1	3.4%
50	1	3.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5	2	6.9%
10	11	37.9%
20	10	34.5%
40	2	6.9%
50	1	3.4%
500	1	3.4%
1000	2	6.9%

Value	Count	Frequency (%)
1000	2	6.9%
500	1	3.4%
50	1	3.4%
40	2	6.9%
20	10	34.5%
10	11	37.9%
5	2	6.9%

최종제작스티커번호
Real number (ℝ)

HIGH CORRELATION

Distinct	8
Distinct (%)	27.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.0031997 × 10¹⁶

Minimum	2.00102 × 10¹⁶
Maximum	2.00717 × 10¹⁶
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	393.0 B

Quantile statistics

Minimum	2.00102 × 10¹⁶
5-th percentile	2.00102 × 10¹⁶
Q1	2.0012 × 10¹⁶
median	2.00228 × 10¹⁶
Q3	2.00529 × 10¹⁶
95-th percentile	2.00717 × 10¹⁶
Maximum	2.00717 × 10¹⁶
Range	6.15 × 10¹³
Interquartile range (IQR)	4.09 × 10¹³

Descriptive statistics

Standard deviation	2.283047 × 10¹³
Coefficient of variation (CV)	0.0011397002
Kurtosis	-1.1765784
Mean	2.0031997 × 10¹⁶
Median Absolute Deviation (MAD)	1.26 × 10¹³
Skewness	0.58090917
Sum	5.809279 × 10¹⁷
Variance	5.2123034 × 10²⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
20010200000000000	5	17.2%
20052900000000000	5	17.2%
20012000000000000	4	13.8%
20040300000000000	4	13.8%
20071700000000000	4	13.8%
20022800000000000	3	10.3%
20011700000000000	2	6.9%
20012300000000000	2	6.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20010200000000000	5	17.2%
20011700000000000	2	6.9%
20012000000000000	4	13.8%
20012300000000000	2	6.9%
20022800000000000	3	10.3%
20040300000000000	4	13.8%
20052900000000000	5	17.2%
20071700000000000	4	13.8%

Value	Count	Frequency (%)
20071700000000000	4	13.8%
20052900000000000	5	17.2%
20040300000000000	4	13.8%
20022800000000000	3	10.3%
20012300000000000	2	6.9%
20012000000000000	4	13.8%
20011700000000000	2	6.9%
20010200000000000	5	17.2%

입력일
Date

Distinct	9
Distinct (%)	31.0%
Missing	0
Missing (%)	0.0%
Memory size	364.0 B

Minimum	2019-12-27 00:00:00
Maximum	2020-07-16 00:00:00

Histogram

Histogram with fixed size bins (bins=9)

업데이트일
Date

Distinct	9
Distinct (%)	31.0%
Missing	0
Missing (%)	0.0%
Memory size	364.0 B

Minimum	2019-12-27 00:00:00
Maximum	2020-07-16 00:00:00

Histogram

Histogram with fixed size bins (bins=9)

Heatmap
Table

	스티커시작번호	스티커종류번호	상품코드	상품종류	제작상태	수주전표번호	제조업체코드	제작시작일	제작종료일	스티커제작요청수량	제작완료 수량	묶음수량	묶음당 매수	BOX 당 묶음수량	최종제작스티커번호	입력일	업데이트일
스티커시작번호	1.000	1.000	0.772	0.772	0.484	1.000	0.173	1.000	1.000	0.351	0.351	0.215	0.094	NaN	1.000	1.000	1.000
스티커종류번호	1.000	1.000	0.772	0.772	0.484	1.000	0.173	1.000	1.000	0.351	0.351	0.215	0.094	NaN	1.000	1.000	1.000
상품코드	0.772	0.772	1.000	1.000	0.180	0.553	0.777	0.884	0.859	0.889	0.889	0.920	0.759	0.790	0.772	0.840	0.840
상품종류	0.772	0.772	1.000	1.000	0.227	0.566	0.780	0.891	0.821	0.891	0.891	0.921	0.835	0.668	0.772	0.845	0.845
제작상태	0.484	0.484	0.180	0.227	1.000	0.506	0.000	0.639	0.692	0.000	0.000	0.000	0.000	0.000	0.484	0.507	0.507
수주전표번호	1.000	1.000	0.553	0.566	0.506	1.000	0.241	1.000	1.000	0.432	0.432	0.252	0.000	0.000	1.000	1.000	1.000
제조업체코드	0.173	0.173	0.777	0.780	0.000	0.241	1.000	0.897	0.621	0.814	0.814	0.930	0.480	0.000	0.173	0.699	0.699
제작시작일	1.000	1.000	0.884	0.891	0.639	1.000	0.897	1.000	0.980	0.000	0.000	0.178	0.000	0.821	1.000	0.980	0.980
제작종료일	1.000	1.000	0.859	0.821	0.692	1.000	0.621	0.980	1.000	0.000	0.000	0.000	0.000	1.000	1.000	0.979	0.979
스티커제작요청수량	0.351	0.351	0.889	0.891	0.000	0.432	0.814	0.000	0.000	1.000	1.000	0.984	0.966	0.000	0.351	0.489	0.489
제작완료 수량	0.351	0.351	0.889	0.891	0.000	0.432	0.814	0.000	0.000	1.000	1.000	0.984	0.966	0.000	0.351	0.489	0.489
묶음수량	0.215	0.215	0.920	0.921	0.000	0.252	0.930	0.178	0.000	0.984	0.984	1.000	0.867	0.000	0.215	0.501	0.501
묶음당 매수	0.094	0.094	0.759	0.835	0.000	0.000	0.480	0.000	0.000	0.966	0.966	0.867	1.000	0.000	0.094	0.699	0.699
BOX 당 묶음수량	NaN	NaN	0.790	0.668	0.000	0.000	0.000	0.821	1.000	0.000	0.000	0.000	0.000	1.000	NaN	0.970	0.970
최종제작스티커번호	1.000	1.000	0.772	0.772	0.484	1.000	0.173	1.000	1.000	0.351	0.351	0.215	0.094	NaN	1.000	1.000	1.000
입력일	1.000	1.000	0.840	0.845	0.507	1.000	0.699	0.980	0.979	0.489	0.489	0.501	0.699	0.970	1.000	1.000	1.000
업데이트일	1.000	1.000	0.840	0.845	0.507	1.000	0.699	0.980	0.979	0.489	0.489	0.501	0.699	0.970	1.000	1.000	1.000

Heatmap
Table

	제작상태	수주전표번호	제조업체코드
제작상태	1.000	0.576	0.000
수주전표번호	0.576	1.000	0.181
제조업체코드	0.000	0.181	1.000

Heatmap
Table

	스티커시작번호	스티커종류번호	상품코드	상품종류	스티커제작요청수량	제작완료 수량	묶음수량	묶음당 매수	BOX 당 묶음수량	최종제작스티커번호	제작상태	수주전표번호	제조업체코드
스티커시작번호	1.000	1.000	0.759	0.767	0.076	0.034	0.311	-0.099	-0.445	1.000	0.576	1.000	0.181
스티커종류번호	1.000	1.000	0.759	0.767	0.076	0.034	0.311	-0.099	-0.445	1.000	0.576	1.000	0.181
상품코드	0.759	0.759	1.000	0.981	0.014	-0.016	0.271	-0.132	-0.543	0.759	0.128	0.411	0.595
상품종류	0.767	0.767	0.981	1.000	0.047	0.024	0.260	-0.060	-0.532	0.767	0.128	0.411	0.595
스티커제작요청수량	0.076	0.076	0.014	0.047	1.000	0.992	0.836	0.813	0.567	0.076	0.000	0.293	0.637
제작완료 수량	0.034	0.034	-0.016	0.024	0.992	1.000	0.825	0.812	0.584	0.034	0.000	0.293	0.637
묶음수량	0.311	0.311	0.271	0.260	0.836	0.825	1.000	0.428	0.375	0.311	0.000	0.147	0.789
묶음당 매수	-0.099	-0.099	-0.132	-0.060	0.813	0.812	0.428	1.000	0.659	-0.099	0.000	0.000	0.465
BOX 당 묶음수량	-0.445	-0.445	-0.543	-0.532	0.567	0.584	0.375	0.659	1.000	-0.445	0.000	0.000	0.000
최종제작스티커번호	1.000	1.000	0.759	0.767	0.076	0.034	0.311	-0.099	-0.445	1.000	0.576	1.000	0.181
제작상태	0.576	0.576	0.128	0.128	0.000	0.000	0.000	0.000	0.000	0.576	1.000	0.576	0.000
수주전표번호	1.000	1.000	0.411	0.411	0.293	0.293	0.147	0.000	0.000	1.000	0.576	1.000	0.181
제조업체코드	0.181	0.181	0.595	0.595	0.637	0.637	0.789	0.465	0.000	0.181	0.000	0.181	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	site코드	스티커시작번호	스티커종류번호	상품코드	상품종류	제작상태	수주전표번호	발주업체코드	제조업체코드	제작시작일	제작종료일	스티커제작요청수량	제작완료 수량	묶음수량	묶음당 매수	BOX 당 묶음수량	최종제작스티커번호	입력일	업데이트일
0	306	20022800000000000	20022800000000000	8010	8	3	2020020000000000000	1001	1001	2020-03-20	2020-03-22	30000	30000	3000	10	10	20022800000000000	2020-02-27	2020-02-27
1	306	20022800000000000	20022800000000000	8030	8	3	2020020000000000000	1001	1001	2020-03-22	2020-03-24	30000	30000	3000	10	10	20022800000000000	2020-02-27	2020-02-27
2	306	20022800000000000	20022800000000000	8050	8	3	2020020000000000000	1001	1001	2020-03-03	2020-03-05	50000	50000	5000	10	10	20022800000000000	2020-02-27	2020-02-27
3	306	20010200000000000	20010200000000000	1020	1	3	2020010000000000000	1001	1001	2020-01-02	2020-01-02	30000	30000	1500	20	500	20010200000000000	2019-12-27	2019-12-27
4	306	20010200000000000	20010200000000000	1003	1	3	2020010000000000000	1001	1001	2020-01-16	2020-01-22	300000	300000	1200	250	40	20010200000000000	2020-01-03	2020-01-03
5	306	20010200000000000	20010200000000000	1005	1	3	2020010000000000000	1001	1001	2020-01-15	2020-01-20	250000	250000	1000	250	40	20010200000000000	2020-01-03	2020-01-03
6	306	20010200000000000	20010200000000000	1060	1	3	2020010000000000000	1001	1001	2020-01-16	2020-01-16	10000	10000	1000	10	1000	20010200000000000	2020-01-03	2020-01-03
7	306	20010200000000000	20010200000000000	1121	1	3	2020010000000000000	1001	1001	2020-01-15	2020-01-16	50000	50000	5000	10	1000	20010200000000000	2020-01-03	2020-01-03
8	306	20012000000000000	20012000000000000	2003	2	3	2020010000000000000	1001	1001	2020-02-07	2020-02-07	1000	1000	200	5	10	20012000000000000	2020-01-20	2020-01-20
9	306	20012000000000000	20012000000000000	2005	2	3	2020010000000000000	1001	1001	2020-02-07	2020-02-07	1000	1000	200	5	10	20012000000000000	2020-01-20	2020-01-20

	site코드	스티커시작번호	스티커종류번호	상품코드	상품종류	제작상태	수주전표번호	발주업체코드	제조업체코드	제작시작일	제작종료일	스티커제작요청수량	제작완료 수량	묶음수량	묶음당 매수	BOX 당 묶음수량	최종제작스티커번호	입력일	업데이트일
19	306	20040300000000000	20040300000000000	6060	6	3	2020040000000000000	1001	1003	2020-04-02	2020-04-02	60000	60000	6000	10	20	20040300000000000	2020-04-02	2020-04-02
20	306	20052900000000000	20052900000000000	8010	8	3	2020050000000000000	1001	1001	2020-06-05	2020-06-07	30000	30000	3000	10	10	20052900000000000	2020-06-02	2020-06-02
21	306	20052900000000000	20052900000000000	8030	8	3	2020050000000000000	1001	1001	2020-06-09	2020-06-10	30000	30000	3000	10	10	20052900000000000	2020-06-02	2020-06-02
22	306	20052900000000000	20052900000000000	5010	5	3	2020050000000000000	1001	1003	2020-06-02	2020-06-02	1000000	1000000	20000	50	20	20052900000000000	2020-06-02	2020-06-02
23	306	20052900000000000	20052900000000000	5050	5	3	2020050000000000000	1001	1004	2020-06-02	2020-06-02	300000	300000	30000	10	20	20052900000000000	2020-06-02	2020-06-02
24	306	20052900000000000	20052900000000000	6020	6	3	2020050000000000000	1001	1002	2020-06-09	2020-06-09	1000000	1000000	20000	50	20	20052900000000000	2020-06-09	2020-06-09
25	306	20071700000000000	20071700000000000	8010	8	3	2020070000000000000	1001	1001	2020-07-21	2020-07-24	30000	30000	3000	10	10	20071700000000000	2020-07-16	2020-07-16
26	306	20071700000000000	20071700000000000	8030	8	2	2020070000000000000	1001	1001	2020-07-21	2020-07-24	30000	3000	3000	10	10	20071700000000000	2020-07-16	2020-07-16
27	306	20071700000000000	20071700000000000	8050	8	2	2020070000000000000	1001	1001	2020-07-21	2020-07-25	30000	27000	3000	10	10	20071700000000000	2020-07-16	2020-07-16
28	306	20071700000000000	20071700000000000	6125	6	3	2020070000000000000	1001	1003	2020-07-16	2020-07-16	40000	40000	4000	10	10	20071700000000000	2020-07-16	2020-07-16

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample