Overview

Dataset statistics

Number of variables4
Number of observations2638
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory85.1 KiB
Average record size in memory33.1 B

Variable types

Numeric1
Text1
Categorical1
DateTime1

Dataset

Description서울교통공사의 입찰공고 현황 데이터입니다. 해당 정보는 연번, 공고명, 계약방법, 공고일자 데이터로 구성되어 있습니다. 2023년 10월 기준입니다.
Author서울교통공사
URLhttps://www.data.go.kr/data/15052322/fileData.do

Alerts

연번 has unique valuesUnique

Reproduction

Analysis started2023-12-16 15:45:54.625231
Analysis finished2023-12-16 15:45:57.139349
Duration2.51 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct2638
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1319.5
Minimum1
Maximum2638
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size23.3 KiB
2023-12-16T15:45:57.408569image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile132.85
Q1660.25
median1319.5
Q31978.75
95-th percentile2506.15
Maximum2638
Range2637
Interquartile range (IQR)1318.5

Descriptive statistics

Standard deviation761.66933
Coefficient of variation (CV)0.57724087
Kurtosis-1.2
Mean1319.5
Median Absolute Deviation (MAD)659.5
Skewness0
Sum3480841
Variance580140.17
MonotonicityStrictly increasing
2023-12-16T15:45:57.957315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
1754 1
 
< 0.1%
1756 1
 
< 0.1%
1757 1
 
< 0.1%
1758 1
 
< 0.1%
1759 1
 
< 0.1%
1760 1
 
< 0.1%
1761 1
 
< 0.1%
1762 1
 
< 0.1%
1763 1
 
< 0.1%
Other values (2628) 2628
99.6%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
ValueCountFrequency (%)
2638 1
< 0.1%
2637 1
< 0.1%
2636 1
< 0.1%
2635 1
< 0.1%
2634 1
< 0.1%
2633 1
< 0.1%
2632 1
< 0.1%
2631 1
< 0.1%
2630 1
< 0.1%
2629 1
< 0.1%

공고명
Text

Distinct2583
Distinct (%)97.9%
Missing0
Missing (%)0.0%
Memory size20.7 KiB
2023-12-16T15:45:58.791260image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length60
Median length44
Mean length26.232752
Min length8

Characters and Unicode

Total characters69202
Distinct characters572
Distinct categories12 ?
Distinct scripts3 ?
Distinct blocks7 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique2529 ?
Unique (%)95.9%

Sample

1st row7호선(남부구간) 에스컬레이터 유지관리 용역
2nd row지하철 통합관제센터 신축공사 설계의도구현 용역
3rd row구산역 승강편의시설 설치공사 소규모 지하안전영향평가 재협의 용역
4th row지하철 3호선 독립문역 3개역 환기시스템 개량 송풍기 제작구매
5th row레일탐상차2호 차축 교체 수선
ValueCountFrequency (%)
등 458
 
3.2%
구매 356
 
2.5%
2023년 271
 
1.9%
및 263
 
1.8%
용역 257
 
1.8%
2022년 241
 
1.7%
설치 238
 
1.7%
제조구매 202
 
1.4%
제작구매 198
 
1.4%
전동차 187
 
1.3%
Other values (3316) 11691
81.4%
2023-12-16T15:46:00.310877image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
11732
 
17.0%
2 2206
 
3.2%
기 1642
 
2.4%
역 1582
 
2.3%
사 1579
 
2.3%
공 1511
 
2.2%
구 1495
 
2.2%
전 1420
 
2.1%
선 1251
 
1.8%
설 1214
 
1.8%
Other values (562) 43570
63.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 47676
68.9%
Space Separator 11732
 
17.0%
Decimal Number 5825
 
8.4%
Uppercase Letter 1330
 
1.9%
Close Punctuation 1011
 
1.5%
Open Punctuation 1011
 
1.5%
Other Punctuation 261
 
0.4%
Math Symbol 253
 
0.4%
Dash Punctuation 89
 
0.1%
Final Punctuation 6
 
< 0.1%
Other values (2) 8
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 1642
 
3.4%
역 1582
 
3.3%
사 1579
 
3.3%
공 1511
 
3.2%
구 1495
 
3.1%
전 1420
 
3.0%
선 1251
 
2.6%
설 1214
 
2.5%
호 1068
 
2.2%
용 1037
 
2.2%
Other values (505) 33877
71.1%
Uppercase Letter
ValueCountFrequency (%)
S 151
11.4%
C 131
 
9.8%
E 109
 
8.2%
P 104
 
7.8%
T 102
 
7.7%
V 100
 
7.5%
A 92
 
6.9%
D 74
 
5.6%
L 74
 
5.6%
B 54
 
4.1%
Other values (15) 339
25.5%
Decimal Number
ValueCountFrequency (%)
2 2206
37.9%
0 736
 
12.6%
3 725
 
12.4%
1 675
 
11.6%
5 408
 
7.0%
4 357
 
6.1%
7 201
 
3.5%
8 195
 
3.3%
6 162
 
2.8%
9 160
 
2.7%
Other Punctuation
ValueCountFrequency (%)
, 189
72.4%
/ 49
 
18.8%
· 11
 
4.2%
. 9
 
3.4%
: 2
 
0.8%
# 1
 
0.4%
Math Symbol
ValueCountFrequency (%)
~ 242
95.7%
+ 9
 
3.6%
= 1
 
0.4%
∼ 1
 
0.4%
Close Punctuation
ValueCountFrequency (%)
) 920
91.0%
] 89
 
8.8%
」 2
 
0.2%
Open Punctuation
ValueCountFrequency (%)
( 919
90.9%
[ 90
 
8.9%
「 2
 
0.2%
Connector Punctuation
ValueCountFrequency (%)
_ 4
80.0%
＿ 1
 
20.0%
Space Separator
ValueCountFrequency (%)
11732
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 89
100.0%
Final Punctuation
ValueCountFrequency (%)
’ 6
100.0%
Other Symbol
ValueCountFrequency (%)
㎟ 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 47676
68.9%
Common 20196
29.2%
Latin 1330
 
1.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 1642
 
3.4%
역 1582
 
3.3%
사 1579
 
3.3%
공 1511
 
3.2%
구 1495
 
3.1%
전 1420
 
3.0%
선 1251
 
2.6%
설 1214
 
2.5%
호 1068
 
2.2%
용 1037
 
2.2%
Other values (505) 33877
71.1%
Common
ValueCountFrequency (%)
11732
58.1%
2 2206
 
10.9%
) 920
 
4.6%
( 919
 
4.6%
0 736
 
3.6%
3 725
 
3.6%
1 675
 
3.3%
5 408
 
2.0%
4 357
 
1.8%
~ 242
 
1.2%
Other values (22) 1276
 
6.3%
Latin
ValueCountFrequency (%)
S 151
11.4%
C 131
 
9.8%
E 109
 
8.2%
P 104
 
7.8%
T 102
 
7.7%
V 100
 
7.5%
A 92
 
6.9%
D 74
 
5.6%
L 74
 
5.6%
B 54
 
4.1%
Other values (15) 339
25.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 47675
68.9%
ASCII 21500
31.1%
None 16
 
< 0.1%
Punctuation 6
 
< 0.1%
CJK Compat 3
 
< 0.1%
Compat Jamo 1
 
< 0.1%
Math Operators 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
11732
54.6%
2 2206
 
10.3%
) 920
 
4.3%
( 919
 
4.3%
0 736
 
3.4%
3 725
 
3.4%
1 675
 
3.1%
5 408
 
1.9%
4 357
 
1.7%
~ 242
 
1.1%
Other values (40) 2580
 
12.0%
Hangul
ValueCountFrequency (%)
기 1642
 
3.4%
역 1582
 
3.3%
사 1579
 
3.3%
공 1511
 
3.2%
구 1495
 
3.1%
전 1420
 
3.0%
선 1251
 
2.6%
설 1214
 
2.5%
호 1068
 
2.2%
용 1037
 
2.2%
Other values (504) 33876
71.1%
None
ValueCountFrequency (%)
· 11
68.8%
「 2
 
12.5%
」 2
 
12.5%
＿ 1
 
6.2%
Punctuation
ValueCountFrequency (%)
’ 6
100.0%
CJK Compat
ValueCountFrequency (%)
㎟ 3
100.0%
Compat Jamo
ValueCountFrequency (%)
ㆍ 1
100.0%
Math Operators
ValueCountFrequency (%)
∼ 1
100.0%

계약방법
Categorical

Distinct7
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size20.7 KiB
제한입찰
889 
일반수의계약(전자시담)
760 
전자공개수의계약
667 
일반입찰
234 
일반수의계약(일반시담)
 
50
Other values (2)
 
38

Length

Max length12
Median length8
Mean length7.4996209
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row전자공개수의계약
2nd row일반수의계약(전자시담)
3rd row일반수의계약(전자시담)
4th row제한입찰
5th row일반수의계약(전자시담)

Common Values

ValueCountFrequency (%)
제한입찰 889
33.7%
일반수의계약(전자시담) 760
28.8%
전자공개수의계약 667
25.3%
일반입찰 234
 
8.9%
일반수의계약(일반시담) 50
 
1.9%
협상에의한계약 23
 
0.9%
2단계입찰 15
 
0.6%

Length

2023-12-16T15:46:01.065837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:46:01.746012image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
제한입찰 889
33.7%
일반수의계약(전자시담 760
28.8%
전자공개수의계약 667
25.3%
일반입찰 234
 
8.9%
일반수의계약(일반시담 50
 
1.9%
협상에의한계약 23
 
0.9%
2단계입찰 15
 
0.6%

공고일자
Date

Distinct426
Distinct (%)16.1%
Missing0
Missing (%)0.0%
Memory size20.7 KiB
Minimum2022-01-03 00:00:00
Maximum2023-10-31 00:00:00
2023-12-16T15:46:02.550063image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:46:03.257756image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-16T15:45:56.182878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-16T15:46:03.921868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번계약방법
연번1.0000.159
계약방법0.1591.000
2023-12-16T15:46:04.296275image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번계약방법
연번1.0000.081
계약방법0.0811.000

Missing values

2023-12-16T15:45:56.685853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-16T15:45:57.039176image/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

연번공고명계약방법공고일자
017호선(남부구간) 에스컬레이터 유지관리 용역전자공개수의계약2022-01-03
12지하철 통합관제센터 신축공사 설계의도구현 용역일반수의계약(전자시담)2022-01-10
23구산역 승강편의시설 설치공사 소규모 지하안전영향평가 재협의 용역일반수의계약(전자시담)2022-01-10
34지하철 3호선 독립문역 3개역 환기시스템 개량 송풍기 제작구매제한입찰2022-01-10
45레일탐상차2호 차축 교체 수선일반수의계약(전자시담)2022-01-10
56지하철 3호선 녹번역 등 3개역 환기시스템 개량 기계공사제한입찰2022-01-10
67지하철 통합관제센터 신축공사 지정폐기물 처리용역(폐석면)전자공개수의계약2022-01-13
78군자기지 후생관 및 창고부지 사업장일반폐기물 처리용역일반수의계약(전자시담)2022-01-14
892022년도 9호선 2,3단계 소방설비 법정점검 용역전자공개수의계약2022-01-14
9102022년 사당별관 및 강동지원반 방역소독 용역전자공개수의계약2022-01-14
연번공고명계약방법공고일자
26282629대형물탱크차 1,2호 매연저감장치 구매 설치일반수의계약(전자시담)2023-10-31
262926302023년 9호선 2,3단계 신호기계실 보드 부품교체(2차)일반수의계약(전자시담)2023-10-31
263026312023년 승무분야 근무환경 개선 전기공사전자공개수의계약2023-10-31
263126322023년 7호선 반포역 캐노피 설치 전기공사전자공개수의계약2023-10-31
26322633도봉차량기지 유류고 시설 보완 전기공사전자공개수의계약2023-10-31
263326342023년도 통신케이블 증설 및 개량공사전자공개수의계약2023-10-31
26342635마포구청 등 3역 방풍문 설치공사전자공개수의계약2023-10-31
263526365호선 광화문역 등 2역 노후 전기실 개량 건축공사전자공개수의계약2023-10-31
263626372호선 잠실역 내부 E/S 보완 전자공사전자공개수의계약2023-10-31
263726382호선 합정역 지하철보안관 근무환경 개선공사전자공개수의계약2023-10-31