Overview

Dataset statistics

Number of variables6
Number of observations155
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.7 KiB
Average record size in memory50.9 B

Variable types

Categorical3
Numeric2
DateTime1

Dataset

Description광주광역시 고시 제 2023-9 호 "2023년 건설공사 품질시험 수수료 및 현장시험 경비 고시"에 해당하는 내용이며, 광주광역시 종합건설본부 총무부 품질시험과(국ㆍ공립시험기관)에서 운영 중인 품질시험 검사의 종류 및 수수료에 관한 안내사항임. □ 현장시험경비(차량경비 + 인건) : 105,000원 ○ 장비운반차량 소요 경비(화물자동차 1톤급 10km이내 기준) : 65,000원 ○ 출장요원 인건비 : 40,000원(20,000원 × 2인) □ 수수료 적용시기 : 2023. 1. 16일부터
URLhttps://www.data.go.kr/data/15095274/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
수수료(원) 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 시료량High correlation
시험종목 is highly overall correlated with 수수료(원) and 2 other fieldsHigh correlation
시료량 is highly overall correlated with 수수료(원) and 3 other fieldsHigh correlation

Reproduction

Analysis started2023-12-12 18:50:57.974473
Analysis finished2023-12-12 18:50:59.147756
Duration1.17 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

종별
Categorical

HIGH CORRELATION 

Distinct26
Distinct (%)16.8%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
입도조정기층 (12종목)
12 
구조물 뒷채움 : 선택층 (11종목)
11 
동상방지층 (11종목)
11 
보조기층 (11종목)
11 
성토용 흙 (9종목)
 
9
Other values (21)
101 

Length

Max length27
Median length21
Mean length14.529032
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row성토용 흙 (9종목)
2nd row성토용 흙 (9종목)
3rd row성토용 흙 (9종목)
4th row성토용 흙 (9종목)
5th row성토용 흙 (9종목)

Common Values

ValueCountFrequency (%)
입도조정기층 (12종목) 12
 
7.7%
구조물 뒷채움 : 선택층 (11종목) 11
 
7.1%
동상방지층 (11종목) 11
 
7.1%
보조기층 (11종목) 11
 
7.1%
성토용 흙 (9종목) 9
 
5.8%
되메우기 (9종목) 9
 
5.8%
구조물 뒷채움 : 양질의 토사 (9종목) 9
 
5.8%
노체 (9종목) 9
 
5.8%
노상 (9종목) 9
 
5.8%
아스팔트 혼합물용 굵은골재 (7종목) 7
 
4.5%
Other values (16) 58
37.4%

Length

2023-12-13T03:50:59.268666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
9종목 45
 
9.1%
11종목 33
 
6.7%
25
 
5.1%
구조물 20
 
4.1%
뒷채움 20
 
4.1%
5종목 20
 
4.1%
콘크리트 17
 
3.5%
4종목 16
 
3.3%
아스팔트 12
 
2.4%
12종목 12
 
2.4%
Other values (40) 272
55.3%

시험종목
Categorical

HIGH CORRELATION 

Distinct43
Distinct (%)27.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
함수비
 
9
현장밀도
 
9
액성한계
 
9
소성한계
 
9
다짐
 
9
Other values (38)
110 

Length

Max length13
Median length12
Mean length4.5612903
Min length2

Unique

Unique13 ?
Unique (%)8.4%

Sample

1st row함수비
2nd row입도
3rd row세립토비율
4th row밀도
5th row액성한계

Common Values

ValueCountFrequency (%)
함수비 9
 
5.8%
현장밀도 9
 
5.8%
액성한계 9
 
5.8%
소성한계 9
 
5.8%
다짐 9
 
5.8%
노상토지지력비(CBR) 9
 
5.8%
흡수율 8
 
5.2%
압축강도 8
 
5.2%
입도 7
 
4.5%
세립토비율 5
 
3.2%
Other values (33) 73
47.1%

Length

2023-12-13T03:50:59.531585image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
함수비 9
 
5.8%
액성한계 9
 
5.8%
소성한계 9
 
5.8%
다짐 9
 
5.8%
노상토지지력비(cbr 9
 
5.8%
현장밀도 9
 
5.8%
흡수율 8
 
5.2%
압축강도 8
 
5.2%
입도 7
 
4.5%
체가름 5
 
3.2%
Other values (33) 73
47.1%

수수료(원)
Real number (ℝ)

HIGH CORRELATION 

Distinct48
Distinct (%)31.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean81522.581
Minimum6000
Maximum374000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2023-12-13T03:50:59.769446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum6000
5-th percentile11700
Q128000
median43000
Q382000
95-th percentile339000
Maximum374000
Range368000
Interquartile range (IQR)54000

Descriptive statistics

Standard deviation88748.685
Coefficient of variation (CV)1.0886393
Kurtosis3.3728167
Mean81522.581
Median Absolute Deviation (MAD)22000
Skewness1.9921942
Sum12636000
Variance7.876329 × 109
MonotonicityNot monotonic
2023-12-13T03:50:59.976693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=48)
ValueCountFrequency (%)
42000 15
 
9.7%
82000 11
 
7.1%
65000 9
 
5.8%
28000 8
 
5.2%
40000 6
 
3.9%
14000 6
 
3.9%
41000 6
 
3.9%
62000 5
 
3.2%
11000 5
 
3.2%
374000 5
 
3.2%
Other values (38) 79
51.0%
ValueCountFrequency (%)
6000 2
 
1.3%
9000 1
 
0.6%
11000 5
3.2%
12000 2
 
1.3%
13000 2
 
1.3%
14000 6
3.9%
15000 4
2.6%
16000 1
 
0.6%
17000 1
 
0.6%
22000 5
3.2%
ValueCountFrequency (%)
374000 5
3.2%
339000 4
2.6%
223000 5
3.2%
207000 1
 
0.6%
203000 1
 
0.6%
201000 3
1.9%
195000 2
 
1.3%
185000 2
 
1.3%
183000 4
2.6%
135000 1
 
0.6%

처리기간(일)
Real number (ℝ)

HIGH CORRELATION 

Distinct7
Distinct (%)4.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.4645161
Minimum3
Maximum13
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2023-12-13T03:51:00.168992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile3
Q15
median5
Q35
95-th percentile10
Maximum13
Range10
Interquartile range (IQR)0

Descriptive statistics

Standard deviation2.02349
Coefficient of variation (CV)0.37029629
Kurtosis5.3290487
Mean5.4645161
Median Absolute Deviation (MAD)0
Skewness2.2865039
Sum847
Variance4.0945119
MonotonicityNot monotonic
2023-12-13T03:51:00.332650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
5 91
58.7%
4 23
 
14.8%
6 11
 
7.1%
10 10
 
6.5%
3 9
 
5.8%
7 6
 
3.9%
13 5
 
3.2%
ValueCountFrequency (%)
3 9
 
5.8%
4 23
 
14.8%
5 91
58.7%
6 11
 
7.1%
7 6
 
3.9%
10 10
 
6.5%
13 5
 
3.2%
ValueCountFrequency (%)
13 5
 
3.2%
10 10
 
6.5%
7 6
 
3.9%
6 11
 
7.1%
5 91
58.7%
4 23
 
14.8%
3 9
 
5.8%

시료량
Categorical

HIGH CORRELATION 

Distinct13
Distinct (%)8.4%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
3㎏이상
45 
10㎏이상
19 
80㎏이상
18 
1조10개
14 
1공당
12 
Other values (8)
47 

Length

Max length20
Median length13
Mean length5.2903226
Min length3

Unique

Unique1 ?
Unique (%)0.6%

Sample

1st row3㎏이상
2nd row6㎏이상
3rd row3㎏이상
4th row3㎏이상
5th row3㎏이상

Common Values

ValueCountFrequency (%)
3㎏이상 45
29.0%
10㎏이상 19
12.3%
80㎏이상 18
 
11.6%
1조10개 14
 
9.0%
1공당 12
 
7.7%
5㎏이상 12
 
7.7%
20㎏이상 10
 
6.5%
1조3개 (각60㎝) 9
 
5.8%
6㎏이상 5
 
3.2%
1조10(20)개 4
 
2.6%
Other values (3) 7
 
4.5%

Length

2023-12-13T03:51:00.551708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
3㎏이상 45
26.5%
10㎏이상 19
11.2%
80㎏이상 18
 
10.6%
1조10개 14
 
8.2%
1공당 12
 
7.1%
5㎏이상 12
 
7.1%
20㎏이상 10
 
5.9%
1조3개 10
 
5.9%
각60㎝ 9
 
5.3%
6㎏이상 5
 
2.9%
Other values (5) 16
 
9.4%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
Minimum2023-01-16 00:00:00
Maximum2023-01-16 00:00:00
2023-12-13T03:51:00.751016image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:51:00.927142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T03:50:58.602754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:50:58.346786image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:50:58.732208image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:50:58.480038image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T03:51:01.049640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
종별시험종목수수료(원)처리기간(일)시료량
종별1.0000.6910.0000.0000.967
시험종목0.6911.0000.9860.9930.963
수수료(원)0.0000.9861.0000.8850.807
처리기간(일)0.0000.9930.8851.0000.832
시료량0.9670.9630.8070.8321.000
2023-12-13T03:51:01.203000image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시험종목종별시료량
시험종목1.0000.1940.653
종별0.1941.0000.648
시료량0.6530.6481.000
2023-12-13T03:51:01.403651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
수수료(원)처리기간(일)종별시험종목시료량
수수료(원)1.0000.3650.0000.7350.537
처리기간(일)0.3651.0000.0000.8080.637
종별0.0000.0001.0000.1940.648
시험종목0.7350.8080.1941.0000.653
시료량0.5370.6370.6480.6531.000

Missing values

2023-12-13T03:50:58.920142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T03:50:59.084941image/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성토용 흙 (9종목)함수비1500033㎏이상2023-01-16
1성토용 흙 (9종목)입도22300076㎏이상2023-01-16
2성토용 흙 (9종목)세립토비율4000053㎏이상2023-01-16
3성토용 흙 (9종목)밀도6200043㎏이상2023-01-16
4성토용 흙 (9종목)액성한계6500043㎏이상2023-01-16
5성토용 흙 (9종목)소성한계4200043㎏이상2023-01-16
6성토용 흙 (9종목)다짐207000580㎏이상2023-01-16
7성토용 흙 (9종목)노상토지지력비(CBR)3740001080㎏이상2023-01-16
8성토용 흙 (9종목)현장밀도8200051공당2023-01-16
9되메우기 (9종목)함수비1500033㎏이상2023-01-16
종별시험종목수수료(원)처리기간(일)시료량데이터기준일자
145점토 벽돌 (4종목)치수1100051조10개2023-01-16
146점토 벽돌 (4종목)압축강도4200051조10개2023-01-16
147점토 벽돌 (4종목)흡수율5100051조10개2023-01-16
148연소재 벽돌 (3종목)겉모양및치수1100051조10개2023-01-16
149연소재 벽돌 (3종목)압축강도3000051조10개2023-01-16
150연소재 벽돌 (3종목)흡수율4200051조10개2023-01-16
151경계석 (2종목)비중및흡수율5100051조5개 (5×5×5㎝)2023-01-16
152경계석 (2종목)압축강도2900051조5개 (5×5×5㎝)2023-01-16
153석재 (2종목)밀도및흡수율5100051조5개 (5×5×5㎝)2023-01-16
154석재 (2종목)압축강도2900051조5개 (5×5×5㎝)2023-01-16