Overview

Dataset statistics

Number of variables9
Number of observations53
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.0 KiB
Average record size in memory76.4 B

Variable types

Text2
Categorical1
Boolean3
Numeric1
DateTime2

Dataset

Description부산광역시 중구 계약정보공개시스템 메뉴정보에 대한 데이터로 메뉴명, 메뉴설명, 등록일자, 수정일자 등의 정보를 제공합니다.
Author부산광역시 중구
URLhttps://www.data.go.kr/data/15039607/fileData.do

Alerts

아이피체크여부 has constant value ""Constant
계층 is highly overall correlated with 최하위계층여부High correlation
최하위계층여부 is highly overall correlated with 계층High correlation
사용여부 is highly imbalanced (54.9%)Imbalance
메뉴명 has unique valuesUnique
메뉴설명 has unique valuesUnique

Reproduction

Analysis started2024-03-14 14:53:39.389700
Analysis finished2024-03-14 14:53:40.820740
Duration1.43 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

메뉴명
Text

UNIQUE 

Distinct53
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size552.0 B
2024-03-14T23:53:41.507118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length8
Mean length5.6981132
Min length2

Characters and Unicode

Total characters302
Distinct characters79
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique53 ?
Unique (%)100.0%

Sample

1st row사용자로그인
2nd row물품입찰
3rd row사용자관리
4th row용역입찰
5th row입찰정보
ValueCountFrequency (%)
계약현황 3
 
5.2%
하도급 3
 
5.2%
대금지급 2
 
3.4%
사용자로그인 1
 
1.7%
알림글 1
 
1.7%
대금지급현황 1
 
1.7%
업무안내 1
 
1.7%
용역계약현황 1
 
1.7%
대금지급예고 1
 
1.7%
수의 1
 
1.7%
Other values (43) 43
74.1%
2024-03-14T23:53:42.832109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
계 22
 
7.3%
현 18
 
6.0%
황 18
 
6.0%
약 17
 
5.6%
급 13
 
4.3%
사 11
 
3.6%
찰 9
 
3.0%
공 8
 
2.6%
용 8
 
2.6%
지 8
 
2.6%
Other values (69) 170
56.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 297
98.3%
Space Separator 5
 
1.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
계 22
 
7.4%
현 18
 
6.1%
황 18
 
6.1%
약 17
 
5.7%
급 13
 
4.4%
사 11
 
3.7%
찰 9
 
3.0%
공 8
 
2.7%
용 8
 
2.7%
지 8
 
2.7%
Other values (68) 165
55.6%
Space Separator
ValueCountFrequency (%)
5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 297
98.3%
Common 5
 
1.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
계 22
 
7.4%
현 18
 
6.1%
황 18
 
6.1%
약 17
 
5.7%
급 13
 
4.4%
사 11
 
3.7%
찰 9
 
3.0%
공 8
 
2.7%
용 8
 
2.7%
지 8
 
2.7%
Other values (68) 165
55.6%
Common
ValueCountFrequency (%)
5
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 297
98.3%
ASCII 5
 
1.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
계 22
 
7.4%
현 18
 
6.1%
황 18
 
6.1%
약 17
 
5.7%
급 13
 
4.4%
사 11
 
3.7%
찰 9
 
3.0%
공 8
 
2.7%
용 8
 
2.7%
지 8
 
2.7%
Other values (68) 165
55.6%
ASCII
ValueCountFrequency (%)
5
100.0%

메뉴설명
Text

UNIQUE 

Distinct53
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size552.0 B
2024-03-14T23:53:43.717059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length8
Mean length5.6981132
Min length2

Characters and Unicode

Total characters302
Distinct characters79
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique53 ?
Unique (%)100.0%

Sample

1st row사용자로그인
2nd row물품입찰
3rd row사용자관리
4th row용역입찰
5th row입찰정보
ValueCountFrequency (%)
계약현황 3
 
5.2%
하도급 3
 
5.2%
대금지급 2
 
3.4%
사용자로그인 1
 
1.7%
알림글 1
 
1.7%
대금지급현황 1
 
1.7%
업무안내 1
 
1.7%
용역계약현황 1
 
1.7%
대금지급예고 1
 
1.7%
수의 1
 
1.7%
Other values (43) 43
74.1%
2024-03-14T23:53:45.034814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
계 22
 
7.3%
현 18
 
6.0%
황 18
 
6.0%
약 17
 
5.6%
급 13
 
4.3%
사 11
 
3.6%
찰 9
 
3.0%
공 8
 
2.6%
용 8
 
2.6%
지 8
 
2.6%
Other values (69) 170
56.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 297
98.3%
Space Separator 5
 
1.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
계 22
 
7.4%
현 18
 
6.1%
황 18
 
6.1%
약 17
 
5.7%
급 13
 
4.4%
사 11
 
3.7%
찰 9
 
3.0%
공 8
 
2.7%
용 8
 
2.7%
지 8
 
2.7%
Other values (68) 165
55.6%
Space Separator
ValueCountFrequency (%)
5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 297
98.3%
Common 5
 
1.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
계 22
 
7.4%
현 18
 
6.1%
황 18
 
6.1%
약 17
 
5.7%
급 13
 
4.4%
사 11
 
3.7%
찰 9
 
3.0%
공 8
 
2.7%
용 8
 
2.7%
지 8
 
2.7%
Other values (68) 165
55.6%
Common
ValueCountFrequency (%)
5
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 297
98.3%
ASCII 5
 
1.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
계 22
 
7.4%
현 18
 
6.1%
황 18
 
6.1%
약 17
 
5.7%
급 13
 
4.4%
사 11
 
3.7%
찰 9
 
3.0%
공 8
 
2.7%
용 8
 
2.7%
지 8
 
2.7%
Other values (68) 165
55.6%
ASCII
ValueCountFrequency (%)
5
100.0%

계층
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)7.5%
Missing0
Missing (%)0.0%
Memory size552.0 B
2
25 
3
20 
1
7 
0
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)1.9%

Sample

1st row2
2nd row3
3rd row2
4th row3
5th row1

Common Values

ValueCountFrequency (%)
2 25
47.2%
3 20
37.7%
1 7
 
13.2%
0 1
 
1.9%

Length

2024-03-14T23:53:45.434429image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T23:53:45.750285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 25
47.2%
3 20
37.7%
1 7
 
13.2%
0 1
 
1.9%

최하위계층여부
Boolean

HIGH CORRELATION 

Distinct2
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Memory size181.0 B
True
36 
False
17 
ValueCountFrequency (%)
True 36
67.9%
False 17
32.1%
2024-03-14T23:53:45.940794image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

정렬번호
Real number (ℝ)

Distinct8
Distinct (%)15.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean27.264151
Minimum5
Maximum70
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size605.0 B
2024-03-14T23:53:46.131265image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum5
5-th percentile10
Q120
median30
Q340
95-th percentile54
Maximum70
Range65
Interquartile range (IQR)20

Descriptive statistics

Standard deviation14.694519
Coefficient of variation (CV)0.53896851
Kurtosis0.37978739
Mean27.264151
Median Absolute Deviation (MAD)10
Skewness0.75340691
Sum1445
Variance215.92888
MonotonicityNot monotonic
2024-03-14T23:53:46.493567image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
20 14
26.4%
30 12
22.6%
10 11
20.8%
40 10
18.9%
50 2
 
3.8%
60 2
 
3.8%
5 1
 
1.9%
70 1
 
1.9%
ValueCountFrequency (%)
5 1
 
1.9%
10 11
20.8%
20 14
26.4%
30 12
22.6%
40 10
18.9%
50 2
 
3.8%
60 2
 
3.8%
70 1
 
1.9%
ValueCountFrequency (%)
70 1
 
1.9%
60 2
 
3.8%
50 2
 
3.8%
40 10
18.9%
30 12
22.6%
20 14
26.4%
10 11
20.8%
5 1
 
1.9%

사용여부
Boolean

IMBALANCE 

Distinct2
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Memory size181.0 B
True
48 
False
5 
ValueCountFrequency (%)
True 48
90.6%
False 5
 
9.4%
2024-03-14T23:53:46.827817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

등록일자
Date

Distinct8
Distinct (%)15.1%
Missing0
Missing (%)0.0%
Memory size552.0 B
Minimum2013-10-22 10:37:00
Maximum2013-10-29 00:00:00
2024-03-14T23:53:47.091632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T23:53:47.415997image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)

수정일자
Date

Distinct12
Distinct (%)22.6%
Missing0
Missing (%)0.0%
Memory size552.0 B
Minimum2013-02-27 11:41:00
Maximum2013-10-29 00:00:00
2024-03-14T23:53:47.743627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T23:53:48.053559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)

아이피체크여부
Boolean

CONSTANT 

Distinct1
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Memory size181.0 B
False
53 
ValueCountFrequency (%)
False 53
100.0%
2024-03-14T23:53:48.351675image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Interactions

2024-03-14T23:53:39.838639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T23:53:48.559901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
메뉴명메뉴설명계층최하위계층여부정렬번호사용여부등록일자수정일자
메뉴명1.0001.0001.0001.0001.0001.0001.0001.000
메뉴설명1.0001.0001.0001.0001.0001.0001.0001.000
계층1.0001.0001.0000.8800.3090.3770.0000.930
최하위계층여부1.0001.0000.8801.0000.1640.0000.0000.627
정렬번호1.0001.0000.3090.1641.0000.0000.4180.525
사용여부1.0001.0000.3770.0000.0001.0000.8910.847
등록일자1.0001.0000.0000.0000.4180.8911.0001.000
수정일자1.0001.0000.9300.6270.5250.8471.0001.000
2024-03-14T23:53:48.873410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사용여부최하위계층여부계층
사용여부1.0000.0000.245
최하위계층여부0.0001.0000.672
계층0.2450.6721.000
2024-03-14T23:53:49.121588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
정렬번호계층최하위계층여부사용여부
정렬번호1.0000.2050.1600.000
계층0.2051.0000.6720.245
최하위계층여부0.1600.6721.0000.000
사용여부0.0000.2450.0001.000

Missing values

2024-03-14T23:53:40.190908image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T23:53:40.645535image/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사용자로그인사용자로그인2Y5N2013-10-22 10:372013-02-27 11:42N
1물품입찰물품입찰3Y40Y2013-10-22 10:372013-02-27 11:42N
2사용자관리사용자관리2Y10Y2013-10-22 10:372013-02-27 11:42N
3용역입찰용역입찰3Y30Y2013-10-22 10:372013-02-27 11:42N
4입찰정보입찰정보1N30Y2013-10-22 10:372013-02-27 11:41N
5공사개찰공사개찰3Y20Y2013-10-22 10:372013-02-27 11:42N
6조달청입찰정보조달청입찰정보2N10Y2013-10-22 10:372013-02-27 11:42N
7물품개찰물품개찰3Y40Y2013-10-22 10:372013-02-27 11:42N
8용역개찰용역개찰3Y30Y2013-10-22 10:372013-02-27 11:42N
9계약정보계약정보1N40Y2013-10-22 10:372013-02-27 11:41N
메뉴명메뉴설명계층최하위계층여부정렬번호사용여부등록일자수정일자아이피체크여부
43관리자메뉴관리자메뉴1N10Y2013-10-22 10:372013-02-27 11:42N
44준공검사준공검사2Y60Y2013-10-22 10:372013-10-22 10:37N
45접속통계접속통계2N30Y2013-10-22 10:372013-02-27 11:42N
46공사하도급계약현황공사하도급계약현황3Y20Y2013-10-22 10:372013-02-27 11:42N
47업무별접속현황업무별접속현황3Y20Y2013-10-22 10:372013-02-27 11:42N
48자체발주계획자체발주계획2Y20Y2013-10-22 10:372013-10-22 10:37N
49시스템접속현황시스템접속현황3Y10Y2013-10-22 10:372013-02-27 11:42N
50부서관리부서관리2Y20Y2013-10-22 10:372013-02-27 11:42N
51부정당업자 제재부정당업자 제재2Y50N2013-10-29 00:002013-10-29 00:00N
52공사입찰공사입찰3Y20Y2013-10-22 10:372013-02-27 11:42N