Dataset statistics
Number of variables | 16 |
---|---|
Number of observations | 22 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 3.1 KiB |
Average record size in memory | 143.0 B |
Variable types
Numeric | 4 |
---|---|
Text | 2 |
Categorical | 10 |
Dataset
Description | 인천광역시 중구 관내에 위치한 쓰레기종량제봉투 발주정보에 대한 데이터 입니다.<br/><br/>파일명 인천광역시_중구_쓰레기종량제봉투_발주정보<br/>파일내용 전표번호, 발주일자, 협회코드, 제작업체, 수량, 수수료, 단가 등 |
---|---|
Author | 인천광역시 중구 |
URL | https://data.incheon.go.kr/findData/publicDataDetail?dataId=15060083&srcSe=7661IVAWM27C61E190 |
조달수수료 has constant value "" | Constant |
미입고수량 has constant value "" | Constant |
로트(LOT)발생구분 has constant value "" | Constant |
전송구분 has constant value "" | Constant |
데이터기준일자 has constant value "" | Constant |
연번 is highly overall correlated with 수량 | High correlation |
수량 is highly overall correlated with 연번 and 1 other fields | High correlation |
금액 is highly overall correlated with 수량 | High correlation |
발주일자 is highly overall correlated with 협회코드 and 3 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 |
수정구분 is highly overall correlated with 발주일자 | High correlation |
수정일자 is highly overall correlated with 발주일자 and 2 other fields | High correlation |
협회코드 is highly imbalanced (56.1%) | Imbalance |
제작업체 is highly imbalanced (56.1%) | Imbalance |
수정구분 is highly imbalanced (56.1%) | Imbalance |
연번 has unique values | Unique |
전표번호 has unique values | Unique |
Reproduction
Analysis started | 2024-03-18 04:35:52.302082 |
---|---|
Analysis finished | 2024-03-18 04:35:54.170098 |
Duration | 1.87 second |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
연번
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 22 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 11.5 |
Minimum | 1 |
---|---|
Maximum | 22 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 330.0 B |
Quantile statistics
Minimum | 1 |
---|---|
5-th percentile | 2.05 |
Q1 | 6.25 |
median | 11.5 |
Q3 | 16.75 |
95-th percentile | 20.95 |
Maximum | 22 |
Range | 21 |
Interquartile range (IQR) | 10.5 |
Descriptive statistics
Standard deviation | 6.4935866 |
---|---|
Coefficient of variation (CV) | 0.5646597 |
Kurtosis | -1.2 |
Mean | 11.5 |
Median Absolute Deviation (MAD) | 5.5 |
Skewness | 0 |
Sum | 253 |
Variance | 42.166667 |
Monotonicity | Strictly increasing |
Value | Count | Frequency (%) |
1 | 1 | 4.5% |
13 | 1 | 4.5% |
22 | 1 | 4.5% |
21 | 1 | 4.5% |
20 | 1 | 4.5% |
19 | 1 | 4.5% |
18 | 1 | 4.5% |
17 | 1 | 4.5% |
16 | 1 | 4.5% |
15 | 1 | 4.5% |
Other values (12) | 12 |
Value | Count | Frequency (%) |
1 | 1 | |
2 | 1 | |
3 | 1 | |
4 | 1 | |
5 | 1 | |
6 | 1 | |
7 | 1 | |
8 | 1 | |
9 | 1 | |
10 | 1 |
Value | Count | Frequency (%) |
22 | 1 | |
21 | 1 | |
20 | 1 | |
19 | 1 | |
18 | 1 | |
17 | 1 | |
16 | 1 | |
15 | 1 | |
14 | 1 | |
13 | 1 |
전표번호
Text
UNIQUE
 
Distinct | 22 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 308.0 B |
Value | Count | Frequency (%) |
a00001915 | 1 | 4.5% |
a00001916 | 1 | 4.5% |
a00001960 | 1 | 4.5% |
a00001959 | 1 | 4.5% |
a00001958 | 1 | 4.5% |
a00001957 | 1 | 4.5% |
a00001956 | 1 | 4.5% |
a00001955 | 1 | 4.5% |
a00001950 | 1 | 4.5% |
a00001946 | 1 | 4.5% |
Other values (12) | 12 |
Most occurring characters
Value | Count | Frequency (%) |
0 | 92 | |
1 | 28 | 14.1% |
9 | 24 | 12.1% |
A | 22 | 11.1% |
5 | 8 | 4.0% |
6 | 5 | 2.5% |
3 | 5 | 2.5% |
2 | 4 | 2.0% |
4 | 4 | 2.0% |
7 | 3 | 1.5% |
Most occurring categories
Value | Count | Frequency (%) |
Decimal Number | 176 | |
Uppercase Letter | 22 | 11.1% |
Most frequent character per category
Decimal Number
Value | Count | Frequency (%) |
0 | 92 | |
1 | 28 | 15.9% |
9 | 24 | 13.6% |
5 | 8 | 4.5% |
6 | 5 | 2.8% |
3 | 5 | 2.8% |
2 | 4 | 2.3% |
4 | 4 | 2.3% |
7 | 3 | 1.7% |
8 | 3 | 1.7% |
Uppercase Letter
Value | Count | Frequency (%) |
A | 22 |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 176 | |
Latin | 22 | 11.1% |
Most frequent character per script
Common
Value | Count | Frequency (%) |
0 | 92 | |
1 | 28 | 15.9% |
9 | 24 | 13.6% |
5 | 8 | 4.5% |
6 | 5 | 2.8% |
3 | 5 | 2.8% |
2 | 4 | 2.3% |
4 | 4 | 2.3% |
7 | 3 | 1.7% |
8 | 3 | 1.7% |
Latin
Value | Count | Frequency (%) |
A | 22 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 198 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
0 | 92 | |
1 | 28 | 14.1% |
9 | 24 | 12.1% |
A | 22 | 11.1% |
5 | 8 | 4.0% |
6 | 5 | 2.5% |
3 | 5 | 2.5% |
2 | 4 | 2.0% |
4 | 4 | 2.0% |
7 | 3 | 1.5% |
발주일자
Categorical
HIGH CORRELATION
 
Distinct | 7 |
---|---|
Distinct (%) | 31.8% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 308.0 B |
2023-01-31 | |
---|---|
2023-02-22 | |
2023-01-25 | |
2023-04-10 | |
2023-05-26 | |
Other values (2) |
Length
Max length | 10 |
---|---|
Median length | 10 |
Mean length | 10 |
Min length | 10 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | 4.5% |
Sample
1st row | 2023-01-25 |
---|---|
2nd row | 2023-01-25 |
3rd row | 2023-01-30 |
4th row | 2023-01-31 |
5th row | 2023-01-31 |
Common Values
Value | Count | Frequency (%) |
2023-01-31 | 7 | |
2023-02-22 | 6 | |
2023-01-25 | 2 | 9.1% |
2023-04-10 | 2 | 9.1% |
2023-05-26 | 2 | 9.1% |
2023-08-08 | 2 | 9.1% |
2023-01-30 | 1 | 4.5% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2023-01-31 | 7 | |
2023-02-22 | 6 | |
2023-01-25 | 2 | 9.1% |
2023-04-10 | 2 | 9.1% |
2023-05-26 | 2 | 9.1% |
2023-08-08 | 2 | 9.1% |
2023-01-30 | 1 | 4.5% |
봉투 종류
Text
Distinct | 17 |
---|---|
Distinct (%) | 77.3% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 308.0 B |
Length
Max length | 15 |
---|---|
Median length | 11 |
Mean length | 9.4090909 |
Min length | 6 |
Characters and Unicode
Total characters | 207 |
---|---|
Distinct characters | 32 |
Distinct categories | 6 ? |
Distinct scripts | 3 ? |
Distinct blocks | 2 ? |
Unique
Unique | 13 ? |
---|---|
Unique (%) | 59.1% |
Sample
1st row | 대형폐기물스티커 1000원권 |
---|---|
2nd row | 대형폐기물스티커 5000원권 |
3rd row | 일반용 75L |
4th row | 일반용 5L |
5th row | 일반용 10L |
Value | Count | Frequency (%) |
일반용 | 8 | |
음식물 | 8 | |
필증 | 6 | |
대형폐기물스티커 | 4 | |
75l | 4 | |
20l | 3 | 6.0% |
5l | 2 | 4.0% |
10l | 2 | 4.0% |
1000원권 | 2 | 4.0% |
5000원권 | 2 | 4.0% |
Other values (8) | 9 |
Most occurring characters
Value | Count | Frequency (%) |
28 | 13.5% | |
0 | 20 | 9.7% |
L | 18 | 8.7% |
물 | 12 | 5.8% |
용 | 10 | 4.8% |
5 | 10 | 4.8% |
일 | 8 | 3.9% |
반 | 8 | 3.9% |
식 | 8 | 3.9% |
음 | 8 | 3.9% |
Other values (22) | 77 |
Most occurring categories
Value | Count | Frequency (%) |
Other Letter | 110 | |
Decimal Number | 47 | |
Space Separator | 28 | 13.5% |
Uppercase Letter | 18 | 8.7% |
Open Punctuation | 2 | 1.0% |
Close Punctuation | 2 | 1.0% |
Most frequent character per category
Other Letter
Value | Count | Frequency (%) |
물 | 12 | 10.9% |
용 | 10 | 9.1% |
일 | 8 | 7.3% |
반 | 8 | 7.3% |
식 | 8 | 7.3% |
음 | 8 | 7.3% |
증 | 6 | 5.5% |
필 | 6 | 5.5% |
권 | 4 | 3.6% |
원 | 4 | 3.6% |
Other values (12) | 36 |
Decimal Number
Value | Count | Frequency (%) |
0 | 20 | |
5 | 10 | |
2 | 6 | 12.8% |
1 | 5 | 10.6% |
7 | 4 | 8.5% |
3 | 2 | 4.3% |
Space Separator
Value | Count | Frequency (%) |
28 |
Uppercase Letter
Value | Count | Frequency (%) |
L | 18 |
Open Punctuation
Value | Count | Frequency (%) |
( | 2 |
Close Punctuation
Value | Count | Frequency (%) |
) | 2 |
Most occurring scripts
Value | Count | Frequency (%) |
Hangul | 110 | |
Common | 79 | |
Latin | 18 | 8.7% |
Most frequent character per script
Hangul
Value | Count | Frequency (%) |
물 | 12 | 10.9% |
용 | 10 | 9.1% |
일 | 8 | 7.3% |
반 | 8 | 7.3% |
식 | 8 | 7.3% |
음 | 8 | 7.3% |
증 | 6 | 5.5% |
필 | 6 | 5.5% |
권 | 4 | 3.6% |
원 | 4 | 3.6% |
Other values (12) | 36 |
Common
Value | Count | Frequency (%) |
28 | ||
0 | 20 | |
5 | 10 | 12.7% |
2 | 6 | 7.6% |
1 | 5 | 6.3% |
7 | 4 | 5.1% |
( | 2 | 2.5% |
) | 2 | 2.5% |
3 | 2 | 2.5% |
Latin
Value | Count | Frequency (%) |
L | 18 |
Most occurring blocks
Value | Count | Frequency (%) |
Hangul | 110 | |
ASCII | 97 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
28 | ||
0 | 20 | |
L | 18 | |
5 | 10 | 10.3% |
2 | 6 | 6.2% |
1 | 5 | 5.2% |
7 | 4 | 4.1% |
( | 2 | 2.1% |
) | 2 | 2.1% |
3 | 2 | 2.1% |
Hangul
Value | Count | Frequency (%) |
물 | 12 | 10.9% |
용 | 10 | 9.1% |
일 | 8 | 7.3% |
반 | 8 | 7.3% |
식 | 8 | 7.3% |
음 | 8 | 7.3% |
증 | 6 | 5.5% |
필 | 6 | 5.5% |
권 | 4 | 3.6% |
원 | 4 | 3.6% |
Other values (12) | 36 |
협회코드
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | 9.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 308.0 B |
1 | |
---|---|
3 | 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 | 1 |
4th row | 1 |
5th row | 1 |
Common Values
Value | Count | Frequency (%) |
1 | 20 | |
3 | 2 | 9.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
1 | 20 | |
3 | 2 | 9.1% |
제작업체
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | 9.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 308.0 B |
영광산업 | |
---|---|
(주)제임스케미칼 | 2 |
Length
Max length | 9 |
---|---|
Median length | 4 |
Mean length | 4.4545455 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | (주)제임스케미칼 |
---|---|
2nd row | (주)제임스케미칼 |
3rd row | 영광산업 |
4th row | 영광산업 |
5th row | 영광산업 |
Common Values
Value | Count | Frequency (%) |
영광산업 | 20 | |
(주)제임스케미칼 | 2 | 9.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
영광산업 | 20 | |
주)제임스케미칼 | 2 | 9.1% |
수량
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 16 |
---|---|
Distinct (%) | 72.7% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 328118.18 |
Minimum | 100 |
---|---|
Maximum | 1450000 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 330.0 B |
Quantile statistics
Minimum | 100 |
---|---|
5-th percentile | 790 |
Q1 | 35000 |
median | 159900 |
Q3 | 525000 |
95-th percentile | 1277495 |
Maximum | 1450000 |
Range | 1449900 |
Interquartile range (IQR) | 490000 |
Descriptive statistics
Standard deviation | 421224.59 |
---|---|
Coefficient of variation (CV) | 1.2837588 |
Kurtosis | 1.8775359 |
Mean | 328118.18 |
Median Absolute Deviation (MAD) | 140100 |
Skewness | 1.5962745 |
Sum | 7218600 |
Variance | 1.7743016 × 1011 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
50000 | 3 | |
300000 | 3 | |
649800 | 2 | 9.1% |
30000 | 2 | 9.1% |
200000 | 1 | 4.5% |
600000 | 1 | 4.5% |
1450000 | 1 | 4.5% |
849900 | 1 | 4.5% |
139800 | 1 | 4.5% |
1300000 | 1 | 4.5% |
Other values (6) | 6 |
Value | Count | Frequency (%) |
100 | 1 | 4.5% |
200 | 1 | 4.5% |
12000 | 1 | 4.5% |
17000 | 1 | 4.5% |
30000 | 2 | |
50000 | 3 | |
60000 | 1 | 4.5% |
139800 | 1 | 4.5% |
180000 | 1 | 4.5% |
200000 | 1 | 4.5% |
Value | Count | Frequency (%) |
1450000 | 1 | 4.5% |
1300000 | 1 | 4.5% |
849900 | 1 | 4.5% |
649800 | 2 | |
600000 | 1 | 4.5% |
300000 | 3 | |
200000 | 1 | 4.5% |
180000 | 1 | 4.5% |
139800 | 1 | 4.5% |
60000 | 1 | 4.5% |
조달수수료
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 4.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 308.0 B |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 22 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 22 |
조달단가
Real number (ℝ)
Distinct | 11 |
---|---|
Distinct (%) | 50.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 63.730455 |
Minimum | 1 |
---|---|
Maximum | 134 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 330.0 B |
Quantile statistics
Minimum | 1 |
---|---|
5-th percentile | 1 |
Q1 | 1 |
median | 51.875 |
Q3 | 124.91 |
95-th percentile | 133.7865 |
Maximum | 134 |
Range | 133 |
Interquartile range (IQR) | 123.91 |
Descriptive statistics
Standard deviation | 56.892269 |
---|---|
Coefficient of variation (CV) | 0.89270145 |
Kurtosis | -1.8937409 |
Mean | 63.730455 |
Median Absolute Deviation (MAD) | 50.875 |
Skewness | 0.12445674 |
Sum | 1402.07 |
Variance | 3236.7303 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
1.0 | 7 | |
124.91 | 3 | |
120.0 | 2 | 9.1% |
134.0 | 2 | 9.1% |
129.73 | 2 | 9.1% |
31.42 | 1 | 4.5% |
41.64 | 1 | 4.5% |
62.11 | 1 | 4.5% |
64.13 | 1 | 4.5% |
24.26 | 1 | 4.5% |
Value | Count | Frequency (%) |
1.0 | 7 | |
24.26 | 1 | 4.5% |
29.32 | 1 | 4.5% |
31.42 | 1 | 4.5% |
41.64 | 1 | 4.5% |
62.11 | 1 | 4.5% |
64.13 | 1 | 4.5% |
120.0 | 2 | 9.1% |
124.91 | 3 | |
129.73 | 2 | 9.1% |
Value | Count | Frequency (%) |
134.0 | 2 | |
129.73 | 2 | |
124.91 | 3 | |
120.0 | 2 | |
64.13 | 1 | 4.5% |
62.11 | 1 | 4.5% |
41.64 | 1 | 4.5% |
31.42 | 1 | 4.5% |
29.32 | 1 | 4.5% |
24.26 | 1 | 4.5% |
금액
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 21 |
---|---|
Distinct (%) | 95.5% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 23162401 |
Minimum | 12491 |
---|---|
Maximum | 1.0616101 × 108 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 330.0 B |
Quantile statistics
Minimum | 12491 |
---|---|
5-th percentile | 26148.7 |
Q1 | 79950 |
median | 4020000 |
Q3 | 20937000 |
95-th percentile | 89771453 |
Maximum | 1.0616101 × 108 |
Range | 1.0614852 × 108 |
Interquartile range (IQR) | 20857050 |
Descriptive statistics
Standard deviation | 37227997 |
---|---|
Coefficient of variation (CV) | 1.6072599 |
Kurtosis | 0.12410176 |
Mean | 23162401 |
Median Absolute Deviation (MAD) | 3980000 |
Skewness | 1.382528 |
Sum | 5.0957282 × 108 |
Variance | 1.3859238 × 1015 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
30000 | 2 | 9.1% |
6000000 | 1 | 4.5% |
6700000 | 1 | 4.5% |
1608000 | 1 | 4.5% |
2040000 | 1 | 4.5% |
8796000 | 1 | 4.5% |
7278000 | 1 | 4.5% |
12491 | 1 | 4.5% |
25946 | 1 | 4.5% |
60000 | 1 | 4.5% |
Other values (11) | 11 |
Value | Count | Frequency (%) |
12491 | 1 | |
25946 | 1 | |
30000 | 2 | |
50000 | 1 | |
60000 | 1 | |
139800 | 1 | |
180000 | 1 | |
300000 | 1 | |
1608000 | 1 | |
2040000 | 1 |
Value | Count | Frequency (%) |
106161009 | 1 | |
90059500 | 1 | |
84298554 | 1 | |
83369000 | 1 | |
81166518 | 1 | |
24984000 | 1 | |
8796000 | 1 | |
7278000 | 1 | |
6700000 | 1 | |
6284000 | 1 |
미입고수량
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 4.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 308.0 B |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 22 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 22 |
수정구분
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 2 |
---|---|
Distinct (%) | 9.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 308.0 B |
M | |
---|---|
D | 2 |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | M |
---|---|
2nd row | M |
3rd row | D |
4th row | M |
5th row | M |
Common Values
Value | Count | Frequency (%) |
M | 20 | |
D | 2 | 9.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
m | 20 | |
d | 2 | 9.1% |
수정일자
Categorical
HIGH CORRELATION
 
Distinct | 7 |
---|---|
Distinct (%) | 31.8% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 308.0 B |
2023-01-31 | |
---|---|
2023-02-22 | |
2023-01-25 | |
2023-04-10 | |
2023-05-26 | |
Other values (2) |
Length
Max length | 10 |
---|---|
Median length | 10 |
Mean length | 10 |
Min length | 10 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | 4.5% |
Sample
1st row | 2023-01-25 |
---|---|
2nd row | 2023-01-25 |
3rd row | 2023-01-31 |
4th row | 2023-08-16 |
5th row | 2023-01-31 |
Common Values
Value | Count | Frequency (%) |
2023-01-31 | 7 | |
2023-02-22 | 6 | |
2023-01-25 | 2 | 9.1% |
2023-04-10 | 2 | 9.1% |
2023-05-26 | 2 | 9.1% |
2023-08-08 | 2 | 9.1% |
2023-08-16 | 1 | 4.5% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2023-01-31 | 7 | |
2023-02-22 | 6 | |
2023-01-25 | 2 | 9.1% |
2023-04-10 | 2 | 9.1% |
2023-05-26 | 2 | 9.1% |
2023-08-08 | 2 | 9.1% |
2023-08-16 | 1 | 4.5% |
로트(LOT)발생구분
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 4.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 308.0 B |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 22 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 22 |
전송구분
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 4.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 308.0 B |
0 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 0 |
---|---|
2nd row | 0 |
3rd row | 0 |
4th row | 0 |
5th row | 0 |
Common Values
Value | Count | Frequency (%) |
0 | 22 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
0 | 22 |
데이터기준일자
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 4.5% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 308.0 B |
2023-08-30 |
---|
Length
Max length | 10 |
---|---|
Median length | 10 |
Mean length | 10 |
Min length | 10 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2023-08-30 |
---|---|
2nd row | 2023-08-30 |
3rd row | 2023-08-30 |
4th row | 2023-08-30 |
5th row | 2023-08-30 |
Common Values
Value | Count | Frequency (%) |
2023-08-30 | 22 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2023-08-30 | 22 |
연번 | 전표번호 | 발주일자 | 봉투 종류 | 협회코드 | 제작업체 | 수량 | 조달단가 | 금액 | 수정구분 | 수정일자 | |
---|---|---|---|---|---|---|---|---|---|---|---|
연번 | 1.000 | 1.000 | 0.744 | 0.742 | 0.780 | 0.780 | 0.413 | 0.327 | 0.432 | 0.000 | 0.744 |
전표번호 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 |
발주일자 | 0.744 | 1.000 | 1.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.788 | 0.000 | 0.552 | 0.994 |
봉투 종류 | 0.742 | 1.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.810 | 1.000 | 0.521 | 0.000 | 0.000 |
협회코드 | 0.780 | 1.000 | 1.000 | 0.000 | 1.000 | 0.898 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 |
제작업체 | 0.780 | 1.000 | 1.000 | 0.000 | 0.898 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 |
수량 | 0.413 | 1.000 | 0.000 | 0.810 | 0.000 | 0.000 | 1.000 | 0.779 | 0.891 | 0.000 | 0.647 |
조달단가 | 0.327 | 1.000 | 0.788 | 1.000 | 0.000 | 0.000 | 0.779 | 1.000 | 0.687 | 0.000 | 0.870 |
금액 | 0.432 | 1.000 | 0.000 | 0.521 | 0.000 | 0.000 | 0.891 | 0.687 | 1.000 | 0.000 | 0.000 |
수정구분 | 0.000 | 1.000 | 0.552 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 |
수정일자 | 0.744 | 1.000 | 0.994 | 0.000 | 1.000 | 1.000 | 0.647 | 0.870 | 0.000 | 0.000 | 1.000 |
제작업체 | 수정일자 | 발주일자 | 수정구분 | 협회코드 | |
---|---|---|---|---|---|
제작업체 | 1.000 | 0.866 | 0.866 | 0.000 | 0.708 |
수정일자 | 0.866 | 1.000 | 0.878 | 0.000 | 0.866 |
발주일자 | 0.866 | 0.878 | 1.000 | 0.505 | 0.866 |
수정구분 | 0.000 | 0.000 | 0.505 | 1.000 | 0.000 |
협회코드 | 0.708 | 0.866 | 0.866 | 0.000 | 1.000 |
연번 | 수량 | 조달단가 | 금액 | 발주일자 | 협회코드 | 제작업체 | 수정구분 | 수정일자 | |
---|---|---|---|---|---|---|---|---|---|
연번 | 1.000 | -0.504 | -0.143 | -0.473 | 0.425 | 0.464 | 0.464 | 0.000 | 0.425 |
수량 | -0.504 | 1.000 | -0.059 | 0.851 | 0.000 | 0.000 | 0.000 | 0.000 | 0.241 |
조달단가 | -0.143 | -0.059 | 1.000 | 0.361 | 0.364 | 0.000 | 0.000 | 0.000 | 0.472 |
금액 | -0.473 | 0.851 | 0.361 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
발주일자 | 0.425 | 0.000 | 0.364 | 0.000 | 1.000 | 0.866 | 0.866 | 0.505 | 0.878 |
협회코드 | 0.464 | 0.000 | 0.000 | 0.000 | 0.866 | 1.000 | 0.708 | 0.000 | 0.866 |
제작업체 | 0.464 | 0.000 | 0.000 | 0.000 | 0.866 | 0.708 | 1.000 | 0.000 | 0.866 |
수정구분 | 0.000 | 0.000 | 0.000 | 0.000 | 0.505 | 0.000 | 0.000 | 1.000 | 0.000 |
수정일자 | 0.425 | 0.241 | 0.472 | 0.000 | 0.878 | 0.866 | 0.866 | 0.000 | 1.000 |
연번 | 전표번호 | 발주일자 | 봉투 종류 | 협회코드 | 제작업체 | 수량 | 조달수수료 | 조달단가 | 금액 | 미입고수량 | 수정구분 | 수정일자 | 로트(LOT)발생구분 | 전송구분 | 데이터기준일자 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 1 | A00001915 | 2023-01-25 | 대형폐기물스티커 1000원권 | 3 | (주)제임스케미칼 | 50000 | 0 | 120.0 | 6000000 | 0 | M | 2023-01-25 | 0 | 0 | 2023-08-30 |
1 | 2 | A00001916 | 2023-01-25 | 대형폐기물스티커 5000원권 | 3 | (주)제임스케미칼 | 50000 | 0 | 134.0 | 6700000 | 0 | M | 2023-01-25 | 0 | 0 | 2023-08-30 |
2 | 3 | A00001927 | 2023-01-30 | 일반용 75L | 1 | 영광산업 | 649800 | 0 | 124.91 | 81166518 | 0 | D | 2023-01-31 | 0 | 0 | 2023-08-30 |
3 | 4 | A00001917 | 2023-01-31 | 일반용 5L | 1 | 영광산업 | 200000 | 0 | 31.42 | 6284000 | 0 | M | 2023-08-16 | 0 | 0 | 2023-08-30 |
4 | 5 | A00001918 | 2023-01-31 | 일반용 10L | 1 | 영광산업 | 600000 | 0 | 41.64 | 24984000 | 0 | M | 2023-01-31 | 0 | 0 | 2023-08-30 |
5 | 6 | A00001920 | 2023-01-31 | 일반용 20L | 1 | 영광산업 | 1450000 | 0 | 62.11 | 90059500 | 0 | M | 2023-01-31 | 0 | 0 | 2023-08-30 |
6 | 7 | A00001923 | 2023-01-31 | 일반용 50L | 1 | 영광산업 | 649800 | 0 | 129.73 | 84298554 | 0 | M | 2023-01-31 | 0 | 0 | 2023-08-30 |
7 | 8 | A00001939 | 2023-01-31 | 일반용 75L | 1 | 영광산업 | 849900 | 0 | 124.91 | 106161009 | 0 | M | 2023-01-31 | 0 | 0 | 2023-08-30 |
8 | 9 | A00001932 | 2023-01-31 | 공공용 75L | 1 | 영광산업 | 139800 | 0 | 1.0 | 139800 | 0 | D | 2023-01-31 | 0 | 0 | 2023-08-30 |
9 | 10 | A00001938 | 2023-01-31 | 재사용 20L | 1 | 영광산업 | 1300000 | 0 | 64.13 | 83369000 | 0 | M | 2023-01-31 | 0 | 0 | 2023-08-30 |
연번 | 전표번호 | 발주일자 | 봉투 종류 | 협회코드 | 제작업체 | 수량 | 조달수수료 | 조달단가 | 금액 | 미입고수량 | 수정구분 | 수정일자 | 로트(LOT)발생구분 | 전송구분 | 데이터기준일자 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12 | 13 | A00001943 | 2023-02-22 | 음식물 필증 5L | 1 | 영광산업 | 30000 | 0 | 1.0 | 30000 | 0 | M | 2023-02-22 | 0 | 0 | 2023-08-30 |
13 | 14 | A00001946 | 2023-02-22 | 음식물 필증 10L | 1 | 영광산업 | 50000 | 0 | 1.0 | 50000 | 0 | M | 2023-02-22 | 0 | 0 | 2023-08-30 |
14 | 15 | A00001950 | 2023-02-22 | 음식물 필증 20L | 1 | 영광산업 | 60000 | 0 | 1.0 | 60000 | 0 | M | 2023-02-22 | 0 | 0 | 2023-08-30 |
15 | 16 | A00001955 | 2023-02-22 | 음식물 필증 120L | 1 | 영광산업 | 30000 | 0 | 1.0 | 30000 | 0 | M | 2023-02-22 | 0 | 0 | 2023-08-30 |
16 | 17 | A00001956 | 2023-04-10 | 일반용 50L | 1 | 영광산업 | 200 | 0 | 129.73 | 25946 | 0 | M | 2023-04-10 | 0 | 0 | 2023-08-30 |
17 | 18 | A00001957 | 2023-04-10 | 일반용 75L | 1 | 영광산업 | 100 | 0 | 124.91 | 12491 | 0 | M | 2023-04-10 | 0 | 0 | 2023-08-30 |
18 | 19 | A00001958 | 2023-05-26 | 음식물 2L(영종) | 1 | 영광산업 | 300000 | 0 | 24.26 | 7278000 | 0 | M | 2023-05-26 | 0 | 0 | 2023-08-30 |
19 | 20 | A00001959 | 2023-05-26 | 음식물 3L(영종) | 1 | 영광산업 | 300000 | 0 | 29.32 | 8796000 | 0 | M | 2023-05-26 | 0 | 0 | 2023-08-30 |
20 | 21 | A00001960 | 2023-08-08 | 대형폐기물스티커 1000원권 | 1 | 영광산업 | 17000 | 0 | 120.0 | 2040000 | 0 | M | 2023-08-08 | 0 | 0 | 2023-08-30 |
21 | 22 | A00001961 | 2023-08-08 | 대형폐기물스티커 5000원권 | 1 | 영광산업 | 12000 | 0 | 134.0 | 1608000 | 0 | M | 2023-08-08 | 0 | 0 | 2023-08-30 |