Overview

Dataset statistics

Number of variables8
Number of observations32
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.2 KiB
Average record size in memory70.1 B

Variable types

Numeric2
Categorical5
Text1

Dataset

Description인천광역시 남동구 지방재정 투자사업 지자체 심사목록에 대한 데이터로 연번, 심사일자, 사업명, 사업비, 심사기관, 심사결과, 사업부서 , 데이터기준일자를 제공합니다.
Author인천광역시 남동구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15088799&srcSe=7661IVAWM27C61E190

Alerts

데이터기준일자 has constant value ""Constant
사업비(억원) is highly overall correlated with 심사일자 and 2 other fieldsHigh correlation
심사일자 is highly overall correlated with 사업비(억원) and 1 other fieldsHigh correlation
심사기관 is highly overall correlated with 사업비(억원) and 2 other fieldsHigh correlation
사업부서 is highly overall correlated with 사업비(억원) and 1 other fieldsHigh correlation
연번 has unique valuesUnique
사업명 has unique valuesUnique

Reproduction

Analysis started2024-01-28 07:11:31.486064
Analysis finished2024-01-28 07:11:32.179774
Duration0.69 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct32
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean16.5
Minimum1
Maximum32
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size420.0 B
2024-01-28T16:11:32.227909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.55
Q18.75
median16.5
Q324.25
95-th percentile30.45
Maximum32
Range31
Interquartile range (IQR)15.5

Descriptive statistics

Standard deviation9.3808315
Coefficient of variation (CV)0.56853524
Kurtosis-1.2
Mean16.5
Median Absolute Deviation (MAD)8
Skewness0
Sum528
Variance88
MonotonicityStrictly increasing
2024-01-28T16:11:32.331903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=32)
ValueCountFrequency (%)
1 1
 
3.1%
18 1
 
3.1%
32 1
 
3.1%
31 1
 
3.1%
30 1
 
3.1%
29 1
 
3.1%
28 1
 
3.1%
27 1
 
3.1%
26 1
 
3.1%
25 1
 
3.1%
Other values (22) 22
68.8%
ValueCountFrequency (%)
1 1
3.1%
2 1
3.1%
3 1
3.1%
4 1
3.1%
5 1
3.1%
6 1
3.1%
7 1
3.1%
8 1
3.1%
9 1
3.1%
10 1
3.1%
ValueCountFrequency (%)
32 1
3.1%
31 1
3.1%
30 1
3.1%
29 1
3.1%
28 1
3.1%
27 1
3.1%
26 1
3.1%
25 1
3.1%
24 1
3.1%
23 1
3.1%

심사일자
Categorical

HIGH CORRELATION 

Distinct15
Distinct (%)46.9%
Missing0
Missing (%)0.0%
Memory size388.0 B
2020-10-29
13 
2021-11-04
4 
2021-03-12
2 
2021-08-12
2 
2020-02-25
 
1
Other values (10)
10 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique11 ?
Unique (%)34.4%

Sample

1st row2020-02-25
2nd row2020-04-02
3rd row2020-05-11
4th row2020-06-24
5th row2020-11-05

Common Values

ValueCountFrequency (%)
2020-10-29 13
40.6%
2021-11-04 4
 
12.5%
2021-03-12 2
 
6.2%
2021-08-12 2
 
6.2%
2020-02-25 1
 
3.1%
2020-04-02 1
 
3.1%
2020-05-11 1
 
3.1%
2020-06-24 1
 
3.1%
2020-11-05 1
 
3.1%
2021-02-19 1
 
3.1%
Other values (5) 5
 
15.6%

Length

2024-01-28T16:11:32.440684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2020-10-29 13
40.6%
2021-11-04 4
 
12.5%
2021-03-12 2
 
6.2%
2021-08-12 2
 
6.2%
2020-02-25 1
 
3.1%
2020-04-02 1
 
3.1%
2020-05-11 1
 
3.1%
2020-06-24 1
 
3.1%
2020-11-05 1
 
3.1%
2021-02-19 1
 
3.1%
Other values (5) 5
 
15.6%

사업명
Text

UNIQUE 

Distinct32
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size388.0 B
2024-01-28T16:11:32.663565image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length52
Median length28
Mean length21.03125
Min length9

Characters and Unicode

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

Unique

Unique32 ?
Unique (%)100.0%

Sample

1st row간석3동 돌산마루 더불어 마을 도시재생사업
2nd row소래지역 수변 야간경관 조성사업
3rd row고잔동 379-24번지 일원(소1-10호선) 도로개설공사
4th row간석1동 복합청사 건립
5th row간석지구 우수저류시설 설치 [재심사]
ValueCountFrequency (%)
도로개설사업 4
 
3.5%
재심사 4
 
3.5%
조성사업 4
 
3.5%
공영주차장 3
 
2.6%
가공배전선로 3
 
2.6%
백범로(만수주공사거리~간석오거리 3
 
2.6%
고잔동 3
 
2.6%
도로개설공사 2
 
1.7%
지중화사업 2
 
1.7%
외 2
 
1.7%
Other values (77) 85
73.9%
2024-01-28T16:11:32.989800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
83
 
12.3%
사 32
 
4.8%
지 21
 
3.1%
업 18
 
2.7%
공 15
 
2.2%
로 13
 
1.9%
선 12
 
1.8%
) 11
 
1.6%
( 11
 
1.6%
도 11
 
1.6%
Other values (151) 446
66.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 508
75.5%
Space Separator 83
 
12.3%
Decimal Number 39
 
5.8%
Close Punctuation 15
 
2.2%
Open Punctuation 15
 
2.2%
Dash Punctuation 9
 
1.3%
Math Symbol 3
 
0.4%
Other Punctuation 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 32
 
6.3%
지 21
 
4.1%
업 18
 
3.5%
공 15
 
3.0%
로 13
 
2.6%
선 12
 
2.4%
도 11
 
2.2%
개 10
 
2.0%
설 10
 
2.0%
동 10
 
2.0%
Other values (134) 356
70.1%
Decimal Number
ValueCountFrequency (%)
1 10
25.6%
2 8
20.5%
3 7
17.9%
7 4
 
10.3%
4 3
 
7.7%
8 2
 
5.1%
6 2
 
5.1%
9 2
 
5.1%
0 1
 
2.6%
Close Punctuation
ValueCountFrequency (%)
) 11
73.3%
] 4
 
26.7%
Open Punctuation
ValueCountFrequency (%)
( 11
73.3%
[ 4
 
26.7%
Space Separator
ValueCountFrequency (%)
83
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 9
100.0%
Math Symbol
ValueCountFrequency (%)
~ 3
100.0%
Other Punctuation
ValueCountFrequency (%)
* 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 508
75.5%
Common 165
 
24.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 32
 
6.3%
지 21
 
4.1%
업 18
 
3.5%
공 15
 
3.0%
로 13
 
2.6%
선 12
 
2.4%
도 11
 
2.2%
개 10
 
2.0%
설 10
 
2.0%
동 10
 
2.0%
Other values (134) 356
70.1%
Common
ValueCountFrequency (%)
83
50.3%
) 11
 
6.7%
( 11
 
6.7%
1 10
 
6.1%
- 9
 
5.5%
2 8
 
4.8%
3 7
 
4.2%
[ 4
 
2.4%
7 4
 
2.4%
] 4
 
2.4%
Other values (7) 14
 
8.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 508
75.5%
ASCII 165
 
24.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
83
50.3%
) 11
 
6.7%
( 11
 
6.7%
1 10
 
6.1%
- 9
 
5.5%
2 8
 
4.8%
3 7
 
4.2%
[ 4
 
2.4%
7 4
 
2.4%
] 4
 
2.4%
Other values (7) 14
 
8.5%
Hangul
ValueCountFrequency (%)
사 32
 
6.3%
지 21
 
4.1%
업 18
 
3.5%
공 15
 
3.0%
로 13
 
2.6%
선 12
 
2.4%
도 11
 
2.2%
개 10
 
2.0%
설 10
 
2.0%
동 10
 
2.0%
Other values (134) 356
70.1%

사업비(억원)
Real number (ℝ)

HIGH CORRELATION 

Distinct26
Distinct (%)81.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean57.790312
Minimum1
Maximum416
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size420.0 B
2024-01-28T16:11:33.087890image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.275
Q124.75
median31.5
Q351
95-th percentile140.25
Maximum416
Range415
Interquartile range (IQR)26.25

Descriptive statistics

Standard deviation76.2634
Coefficient of variation (CV)1.3196572
Kurtosis15.969839
Mean57.790312
Median Absolute Deviation (MAD)8.755
Skewness3.6378403
Sum1849.29
Variance5816.1062
MonotonicityNot monotonic
2024-01-28T16:11:33.187993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%)
28.0 3
 
9.4%
40.0 2
 
6.2%
20.0 2
 
6.2%
30.0 2
 
6.2%
31.0 2
 
6.2%
37.3 1
 
3.1%
22.49 1
 
3.1%
24.0 1
 
3.1%
2.5 1
 
3.1%
60.0 1
 
3.1%
Other values (16) 16
50.0%
ValueCountFrequency (%)
1.0 1
 
3.1%
2.0 1
 
3.1%
2.5 1
 
3.1%
20.0 2
6.2%
22.49 1
 
3.1%
23.0 1
 
3.1%
24.0 1
 
3.1%
25.0 1
 
3.1%
28.0 3
9.4%
30.0 2
6.2%
ValueCountFrequency (%)
416.0 1
3.1%
143.0 1
3.1%
138.0 1
3.1%
130.0 1
3.1%
129.0 1
3.1%
99.0 1
3.1%
81.0 1
3.1%
60.0 1
3.1%
48.0 1
3.1%
42.0 1
3.1%

심사기관
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)9.4%
Missing0
Missing (%)0.0%
Memory size388.0 B
자체
24 
인천시
7 
중앙
 
1

Length

Max length3
Median length2
Mean length2.21875
Min length2

Unique

Unique1 ?
Unique (%)3.1%

Sample

1st row자체
2nd row자체
3rd row자체
4th row인천시
5th row중앙

Common Values

ValueCountFrequency (%)
자체 24
75.0%
인천시 7
 
21.9%
중앙 1
 
3.1%

Length

2024-01-28T16:11:33.290229image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T16:11:33.367501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
자체 24
75.0%
인천시 7
 
21.9%
중앙 1
 
3.1%

심사결과
Categorical

Distinct3
Distinct (%)9.4%
Missing0
Missing (%)0.0%
Memory size388.0 B
조건부
16 
적정
13 
재검토
3 

Length

Max length3
Median length3
Mean length2.59375
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row조건부
2nd row조건부
3rd row적정
4th row조건부
5th row조건부

Common Values

ValueCountFrequency (%)
조건부 16
50.0%
적정 13
40.6%
재검토 3
 
9.4%

Length

2024-01-28T16:11:33.458889image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T16:11:33.540763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
조건부 16
50.0%
적정 13
40.6%
재검토 3
 
9.4%

사업부서
Categorical

HIGH CORRELATION 

Distinct12
Distinct (%)37.5%
Missing0
Missing (%)0.0%
Memory size388.0 B
건설과
10 
공영개발과
5 
공원녹지과
4 
도시재생과
2 
생활경제과
2 
Other values (7)
9 

Length

Max length6
Median length5
Mean length4.28125
Min length3

Unique

Unique5 ?
Unique (%)15.6%

Sample

1st row도시재생과
2nd row공영개발과
3rd row건설과
4th row재무과
5th row방재하수과

Common Values

ValueCountFrequency (%)
건설과 10
31.2%
공영개발과 5
15.6%
공원녹지과 4
 
12.5%
도시재생과 2
 
6.2%
생활경제과 2
 
6.2%
교통행정과 2
 
6.2%
문화관광과 2
 
6.2%
재무과 1
 
3.1%
방재하수과 1
 
3.1%
총무과 1
 
3.1%
Other values (2) 2
 
6.2%

Length

2024-01-28T16:11:33.618586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
건설과 10
31.2%
공영개발과 5
15.6%
공원녹지과 4
 
12.5%
도시재생과 2
 
6.2%
생활경제과 2
 
6.2%
교통행정과 2
 
6.2%
문화관광과 2
 
6.2%
재무과 1
 
3.1%
방재하수과 1
 
3.1%
총무과 1
 
3.1%
Other values (2) 2
 
6.2%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Memory size388.0 B
2023-06-13
32 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-06-13
2nd row2023-06-13
3rd row2023-06-13
4th row2023-06-13
5th row2023-06-13

Common Values

ValueCountFrequency (%)
2023-06-13 32
100.0%

Length

2024-01-28T16:11:33.704374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T16:11:33.771559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-06-13 32
100.0%

Interactions

2024-01-28T16:11:31.907902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T16:11:31.790493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T16:11:31.970201image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T16:11:31.851639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-28T16:11:33.818010image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번심사일자사업명사업비(억원)심사기관심사결과사업부서
연번1.0000.8771.0000.4270.5610.4850.475
심사일자0.8771.0001.0001.0001.0000.8400.793
사업명1.0001.0001.0001.0001.0001.0001.000
사업비(억원)0.4271.0001.0001.0000.9140.3530.856
심사기관0.5611.0001.0000.9141.0000.4890.940
심사결과0.4850.8401.0000.3530.4891.0000.000
사업부서0.4750.7931.0000.8560.9400.0001.000
2024-01-28T16:11:33.897779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사업부서심사일자심사결과심사기관
사업부서1.0000.3830.0000.595
심사일자0.3831.0000.4330.766
심사결과0.0000.4331.0000.191
심사기관0.5950.7660.1911.000
2024-01-28T16:11:33.986514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번사업비(억원)심사일자심사기관심사결과사업부서
연번1.000-0.0650.4850.3410.2750.172
사업비(억원)-0.0651.0000.7930.9300.2680.594
심사일자0.4850.7931.0000.7660.4330.383
심사기관0.3410.9300.7661.0000.1910.595
심사결과0.2750.2680.4330.1911.0000.000
사업부서0.1720.5940.3830.5950.0001.000

Missing values

2024-01-28T16:11:32.053066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-28T16:11:32.143927image/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

연번심사일자사업명사업비(억원)심사기관심사결과사업부서데이터기준일자
012020-02-25간석3동 돌산마루 더불어 마을 도시재생사업40.0자체조건부도시재생과2023-06-13
122020-04-02소래지역 수변 야간경관 조성사업31.0자체조건부공영개발과2023-06-13
232020-05-11고잔동 379-24번지 일원(소1-10호선) 도로개설공사48.0자체적정건설과2023-06-13
342020-06-24간석1동 복합청사 건립99.0인천시조건부재무과2023-06-13
452020-11-05간석지구 우수저류시설 설치 [재심사]416.0중앙조건부방재하수과2023-06-13
562020-10-29동 주민총회 개최1.0자체적정총무과2023-06-13
672020-10-29구월도매전통시장 고객지원센터 신축공사23.0자체적정생활경제과2023-06-13
782020-10-29제3경인고속도로변 미세먼지 차단숲 조성사업20.0자체적정공원녹지과2023-06-13
892020-10-29만수산 무장애나눔길 조성사업35.0자체적정공원녹지과2023-06-13
9102020-10-29간석동 86-2번지 공영주차장 건설공사 [재심사]30.0자체조건부교통행정과2023-06-13
연번심사일자사업명사업비(억원)심사기관심사결과사업부서데이터기준일자
22232021-04-01고잔동 314번지(2-6호선) 도로개설사업 (재심사)42.0자체조건부건설과2023-06-13
23242021-05-26백범로(만수주공사거리~간석오거리) 가공배전선로 지중화사업(재상정)143.0인천시재검토건설과2023-06-13
24252021-06-28지역특화 관광축제(서창별빛거리)2.0자체조건부문화관광과2023-06-13
25262021-08-12구월근린공원 공영주차장 조성129.0인천시조건부공영개발과2023-06-13
26272021-08-12백범로(만수주공사거리~간석오거리) 가공배전선로 지중화사업(재상정)*구비 38억중 19억 지방채138.0인천시조건부건설과2023-06-13
27282021-10-15만수권역 어르신건강문화센터 신축(재심사)60.0인천시조건부노인장애인과2023-06-13
28292021-11-04소래찬 김장한마당2.5자체적정문화관광과2023-06-13
29302021-11-04미세먼지차단숲 조성사업[3단계]20.0자체적정공원녹지과2023-06-13
30312021-11-04녹색복지숲 생태체험관 건립사업24.0자체적정공원녹지과2023-06-13
31322021-11-04소래포구어시장 일원 지중화사업22.49자체적정건설과2023-06-13