Overview

Dataset statistics

Number of variables7
Number of observations1267
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory71.9 KiB
Average record size in memory58.1 B

Variable types

Numeric2
Categorical1
Text2
DateTime2

Dataset

Description이 데이터는 2021년 9월 19일을 기준으로 남원시 계약현황에 대하여 관서명, 계약명, 계약금, 계약상대자에 대한 데이터 입니다.
Author전라북도 남원시
URLhttps://www.data.go.kr/data/15089168/fileData.do

Alerts

데이터 기준일자 has constant value ""Constant
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 12:53:12.549361
Analysis finished2023-12-12 12:53:13.869295
Duration1.32 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct1267
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean634
Minimum1
Maximum1267
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size11.3 KiB
2023-12-12T21:53:13.981413image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile64.3
Q1317.5
median634
Q3950.5
95-th percentile1203.7
Maximum1267
Range1266
Interquartile range (IQR)633

Descriptive statistics

Standard deviation365.8957
Coefficient of variation (CV)0.57712256
Kurtosis-1.2
Mean634
Median Absolute Deviation (MAD)317
Skewness0
Sum803278
Variance133879.67
MonotonicityStrictly increasing
2023-12-12T21:53:14.178896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
844 1
 
0.1%
851 1
 
0.1%
850 1
 
0.1%
849 1
 
0.1%
848 1
 
0.1%
847 1
 
0.1%
846 1
 
0.1%
845 1
 
0.1%
843 1
 
0.1%
Other values (1257) 1257
99.2%
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 (%)
1267 1
0.1%
1266 1
0.1%
1265 1
0.1%
1264 1
0.1%
1263 1
0.1%
1262 1
0.1%
1261 1
0.1%
1260 1
0.1%
1259 1
0.1%
1258 1
0.1%

관서명
Categorical

Distinct26
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
본청
719 
주천면
 
38
인월면
 
36
운봉읍
 
36
보절면
 
35
Other values (21)
403 

Length

Max length7
Median length2
Mean length2.5398579
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
본청 719
56.7%
주천면 38
 
3.0%
인월면 36
 
2.8%
운봉읍 36
 
2.8%
보절면 35
 
2.8%
아영면 35
 
2.8%
덕과면 35
 
2.8%
사매면 35
 
2.8%
대산면 35
 
2.8%
송동면 32
 
2.5%
Other values (16) 231
 
18.2%

Length

2023-12-12T21:53:14.342892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
본청 719
56.7%
주천면 38
 
3.0%
인월면 36
 
2.8%
운봉읍 36
 
2.8%
보절면 35
 
2.8%
아영면 35
 
2.8%
덕과면 35
 
2.8%
사매면 35
 
2.8%
대산면 35
 
2.8%
송동면 32
 
2.5%
Other values (16) 231
 
18.2%

계약명
Text

Distinct1255
Distinct (%)99.1%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
2023-12-12T21:53:14.649966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length42
Median length35
Mean length19.819258
Min length8

Characters and Unicode

Total characters25111
Distinct characters450
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1244 ?
Unique (%)98.2%

Sample

1st row2021년 남원시 가로(보안)등 보수공사(시내권역 1차)
2nd row2021년 남원시 가로(보안)등 보수공사(서부권역 1차)
3rd row2021년 남원시 가로(보안)등 보수공사(동부권역 1차)
4th row다산천 지방하천 정비공사(3차분) 시행
5th row2021년 안전속도 5030 교통신호등(기) 설치 및 유지보수공사
ValueCountFrequency (%)
정비공사 281
 
5.8%
2021년 189
 
3.9%
시행 175
 
3.6%
배수로 123
 
2.6%
재해복구사업 92
 
1.9%
농로 87
 
1.8%
용배수로 71
 
1.5%
설치공사 70
 
1.5%
안길 68
 
1.4%
2020년 68
 
1.4%
Other values (1732) 3593
74.6%
2023-12-12T21:53:15.181636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3822
 
15.2%
사 1447
 
5.8%
공 901
 
3.6%
2 687
 
2.7%
업 580
 
2.3%
구 560
 
2.2%
지 552
 
2.2%
정 504
 
2.0%
수 484
 
1.9%
로 470
 
1.9%
Other values (440) 15104
60.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 18500
73.7%
Space Separator 3823
 
15.2%
Decimal Number 1659
 
6.6%
Close Punctuation 490
 
2.0%
Open Punctuation 488
 
1.9%
Dash Punctuation 91
 
0.4%
Other Punctuation 30
 
0.1%
Math Symbol 18
 
0.1%
Uppercase Letter 12
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 1447
 
7.8%
공 901
 
4.9%
업 580
 
3.1%
구 560
 
3.0%
지 552
 
3.0%
정 504
 
2.7%
수 484
 
2.6%
로 470
 
2.5%
비 442
 
2.4%
마 377
 
2.0%
Other values (407) 12183
65.9%
Decimal Number
ValueCountFrequency (%)
2 687
41.4%
0 362
21.8%
1 354
21.3%
3 75
 
4.5%
4 54
 
3.3%
5 42
 
2.5%
8 24
 
1.4%
7 22
 
1.3%
9 20
 
1.2%
6 19
 
1.1%
Uppercase Letter
ValueCountFrequency (%)
I 3
25.0%
C 3
25.0%
E 1
 
8.3%
D 1
 
8.3%
L 1
 
8.3%
U 1
 
8.3%
P 1
 
8.3%
S 1
 
8.3%
Other Punctuation
ValueCountFrequency (%)
, 14
46.7%
· 13
43.3%
. 2
 
6.7%
/ 1
 
3.3%
Close Punctuation
ValueCountFrequency (%)
) 469
95.7%
] 20
 
4.1%
』 1
 
0.2%
Open Punctuation
ValueCountFrequency (%)
( 467
95.7%
[ 20
 
4.1%
『 1
 
0.2%
Space Separator
ValueCountFrequency (%)
3822
> 99.9%
　 1
 
< 0.1%
Math Symbol
ValueCountFrequency (%)
~ 14
77.8%
→ 4
 
22.2%
Dash Punctuation
ValueCountFrequency (%)
- 91
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 18500
73.7%
Common 6599
 
26.3%
Latin 12
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 1447
 
7.8%
공 901
 
4.9%
업 580
 
3.1%
구 560
 
3.0%
지 552
 
3.0%
정 504
 
2.7%
수 484
 
2.6%
로 470
 
2.5%
비 442
 
2.4%
마 377
 
2.0%
Other values (407) 12183
65.9%
Common
ValueCountFrequency (%)
3822
57.9%
2 687
 
10.4%
) 469
 
7.1%
( 467
 
7.1%
0 362
 
5.5%
1 354
 
5.4%
- 91
 
1.4%
3 75
 
1.1%
4 54
 
0.8%
5 42
 
0.6%
Other values (15) 176
 
2.7%
Latin
ValueCountFrequency (%)
I 3
25.0%
C 3
25.0%
E 1
 
8.3%
D 1
 
8.3%
L 1
 
8.3%
U 1
 
8.3%
P 1
 
8.3%
S 1
 
8.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 18500
73.7%
ASCII 6591
 
26.2%
None 16
 
0.1%
Arrows 4
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3822
58.0%
2 687
 
10.4%
) 469
 
7.1%
( 467
 
7.1%
0 362
 
5.5%
1 354
 
5.4%
- 91
 
1.4%
3 75
 
1.1%
4 54
 
0.8%
5 42
 
0.6%
Other values (18) 168
 
2.5%
Hangul
ValueCountFrequency (%)
사 1447
 
7.8%
공 901
 
4.9%
업 580
 
3.1%
구 560
 
3.0%
지 552
 
3.0%
정 504
 
2.7%
수 484
 
2.6%
로 470
 
2.5%
비 442
 
2.4%
마 377
 
2.0%
Other values (407) 12183
65.9%
None
ValueCountFrequency (%)
· 13
81.2%
　 1
 
6.2%
『 1
 
6.2%
』 1
 
6.2%
Arrows
ValueCountFrequency (%)
→ 4
100.0%

계약금
Real number (ℝ)

Distinct1226
Distinct (%)96.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean94653381
Minimum10000000
Maximum3.672969 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size11.3 KiB
2023-12-12T21:53:15.343765image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10000000
5-th percentile10186325
Q114639330
median30489000
Q369314675
95-th percentile3.3506937 × 108
Maximum3.672969 × 109
Range3.662969 × 109
Interquartile range (IQR)54675345

Descriptive statistics

Standard deviation2.8234816 × 108
Coefficient of variation (CV)2.9829697
Kurtosis90.076516
Mean94653381
Median Absolute Deviation (MAD)19575000
Skewness8.6802149
Sum1.1992583 × 1011
Variance7.9720486 × 1016
MonotonicityNot monotonic
2023-12-12T21:53:15.503916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
10310000 4
 
0.3%
10300000 4
 
0.3%
10355000 4
 
0.3%
10250000 3
 
0.2%
10440000 3
 
0.2%
10336000 3
 
0.2%
10350000 3
 
0.2%
10420000 3
 
0.2%
10366000 3
 
0.2%
10115000 3
 
0.2%
Other values (1216) 1234
97.4%
ValueCountFrequency (%)
10000000 1
0.1%
10006360 1
0.1%
10008000 1
0.1%
10010000 2
0.2%
10012000 1
0.1%
10018000 2
0.2%
10021890 1
0.1%
10022000 1
0.1%
10024000 1
0.1%
10025000 1
0.1%
ValueCountFrequency (%)
3672969000 1
0.1%
3560023000 1
0.1%
3467209000 1
0.1%
3320330000 1
0.1%
3291416110 1
0.1%
2231807000 1
0.1%
2216746000 1
0.1%
2053886000 1
0.1%
1927738000 1
0.1%
1725035000 1
0.1%

계약일
Date

Distinct163
Distinct (%)12.9%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
Minimum2021-01-04 00:00:00
Maximum2021-09-16 00:00:00
2023-12-12T21:53:15.648386image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:53:15.806073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

계약상대자
Text

Distinct426
Distinct (%)33.6%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
2023-12-12T21:53:16.068708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length7
Mean length7.5248619
Min length3

Characters and Unicode

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

Unique

Unique175 ?
Unique (%)13.8%

Sample

1st row주식회사 하이쏠라
2nd row(주)광원전력
3rd row(유)도유
4th row새한건설(주)
5th row주식회사 구현전력
ValueCountFrequency (%)
주식회사 160
 
10.2%
유한회사 126
 
8.1%
유)금강건설 19
 
1.2%
주)신림조경건설 15
 
1.0%
남원산림조합 13
 
0.8%
유)대림건설 13
 
0.8%
유)웰빙건설 12
 
0.8%
주)성원나무병원 12
 
0.8%
양지건설 12
 
0.8%
유)금라건설 10
 
0.6%
Other values (419) 1170
74.9%
2023-12-12T21:53:16.445316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
) 923
 
9.7%
( 912
 
9.6%
건 766
 
8.0%
설 704
 
7.4%
유 687
 
7.2%
주 553
 
5.8%
사 308
 
3.2%
295
 
3.1%
회 295
 
3.1%
식 170
 
1.8%
Other values (216) 3921
41.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7402
77.6%
Close Punctuation 923
 
9.7%
Open Punctuation 912
 
9.6%
Space Separator 295
 
3.1%
Other Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
건 766
 
10.3%
설 704
 
9.5%
유 687
 
9.3%
주 553
 
7.5%
사 308
 
4.2%
회 295
 
4.0%
식 170
 
2.3%
한 159
 
2.1%
산 140
 
1.9%
대 117
 
1.6%
Other values (212) 3503
47.3%
Close Punctuation
ValueCountFrequency (%)
) 923
100.0%
Open Punctuation
ValueCountFrequency (%)
( 912
100.0%
Space Separator
ValueCountFrequency (%)
295
100.0%
Other Punctuation
ValueCountFrequency (%)
. 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7402
77.6%
Common 2132
 
22.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
건 766
 
10.3%
설 704
 
9.5%
유 687
 
9.3%
주 553
 
7.5%
사 308
 
4.2%
회 295
 
4.0%
식 170
 
2.3%
한 159
 
2.1%
산 140
 
1.9%
대 117
 
1.6%
Other values (212) 3503
47.3%
Common
ValueCountFrequency (%)
) 923
43.3%
( 912
42.8%
295
 
13.8%
. 2
 
0.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7402
77.6%
ASCII 2132
 
22.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
) 923
43.3%
( 912
42.8%
295
 
13.8%
. 2
 
0.1%
Hangul
ValueCountFrequency (%)
건 766
 
10.3%
설 704
 
9.5%
유 687
 
9.3%
주 553
 
7.5%
사 308
 
4.2%
회 295
 
4.0%
식 170
 
2.3%
한 159
 
2.1%
산 140
 
1.9%
대 117
 
1.6%
Other values (212) 3503
47.3%

데이터 기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
Minimum2021-09-19 00:00:00
Maximum2021-09-19 00:00:00
2023-12-12T21:53:16.552267image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:53:16.645139image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T21:53:13.353397image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:53:13.107061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:53:13.475078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:53:13.226699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T21:53:16.716770image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번관서명계약금
연번1.0000.4510.000
관서명0.4511.0000.000
계약금0.0000.0001.000
2023-12-12T21:53:16.809264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번계약금관서명
연번1.000-0.0500.179
계약금-0.0501.0000.000
관서명0.1790.0001.000

Missing values

2023-12-12T21:53:13.666107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:53:13.804764image/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

연번관서명계약명계약금계약일계약상대자데이터 기준일자
01본청2021년 남원시 가로(보안)등 보수공사(시내권역 1차)388406002021-01-04주식회사 하이쏠라2021-09-19
12본청2021년 남원시 가로(보안)등 보수공사(서부권역 1차)317990002021-01-04(주)광원전력2021-09-19
23본청2021년 남원시 가로(보안)등 보수공사(동부권역 1차)298230002021-01-04(유)도유2021-09-19
34본청다산천 지방하천 정비공사(3차분) 시행32914161102021-01-08새한건설(주)2021-09-19
45본청2021년 안전속도 5030 교통신호등(기) 설치 및 유지보수공사834820002021-01-12주식회사 구현전력2021-09-19
56본청남원 공설시장 방송시설 구축사업115030002021-01-13주식회사 테마이엔씨2021-09-19
67본청2021년 보절지구 횡단보도 및 차선정비공사880520002021-01-14(유)한재건설2021-09-19
78본청2021년 안전속도 5030 교통표지판 정비공사861630002021-01-14유한회사 호완2021-09-19
89본청2021년 수지, 이백지구 횡단보도 및 차선 단가공사880350002021-01-14(유)한재건설2021-09-19
910본청2021년 도통지구 횡단보도 및 차선 정비공사860530002021-01-18창희건설(주)2021-09-19
연번관서명계약명계약금계약일계약상대자데이터 기준일자
12571258아영면하성 솔피골 배수로 정비공사100300002021-09-13(유)대율건설2021-09-19
12581259대산면왈길마을 진입로 재포장공사185600002021-09-13(유)영지건설2021-09-19
12591260아영면당동마을 안길 아스콘 포장공사105090002021-09-14(주)서부개발2021-09-19
12601261대산면하대1 농로 포장공사101780002021-09-14주식회사 태산2021-09-19
12611262관광시설사업소춘향테마파크 초가 이엉 착색 도장공사103720002021-09-14유한회사 시티건설2021-09-19
12621263관광시설사업소춘향테마파크 관아 도장공사104500002021-09-14창희건설(주)2021-09-19
12631264본청부동소하천 수해복구공사359320002021-09-15유한회사 원진건설사2021-09-19
12641265노암동독도랑골 농로 포장공사103030002021-09-15주식회사 신인건설2021-09-19
12651266죽항동죽항13통 무선앰프 설치공사 시행152555602021-09-15드림방송시스템2021-09-19
12661267죽항동죽항1통 무선앰프 설치공사 시행150530002021-09-16(주)원탑이앤티2021-09-19