Overview

Dataset statistics

Number of variables6
Number of observations33
Missing cells33
Missing cells (%)16.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.7 KiB
Average record size in memory54.0 B

Variable types

Numeric2
Categorical2
DateTime1
Text1

Dataset

Description인천광역시 미추홀구 기부금 접수현황에 대한 데이터로 수탁기관,기부일시, 현금, 물품, 배부대상자 정보를 제공합니다.
Author인천광역시
URLhttps://www.incheon.go.kr/data/DATA010201/view?docId=15088451

Alerts

수탁기관 is highly overall correlated with 배부대상자High correlation
배부대상자 is highly overall correlated with 수탁기관High correlation
배부대상자 is highly imbalanced (50.1%)Imbalance
현금 has 16 (48.5%) missing valuesMissing
물품 has 17 (51.5%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2024-01-28 07:30:09.429287
Analysis finished2024-01-28 07:30:10.237748
Duration0.81 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct33
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17
Minimum1
Maximum33
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size429.0 B
2024-01-28T16:30:10.296574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.6
Q19
median17
Q325
95-th percentile31.4
Maximum33
Range32
Interquartile range (IQR)16

Descriptive statistics

Standard deviation9.6695398
Coefficient of variation (CV)0.56879646
Kurtosis-1.2
Mean17
Median Absolute Deviation (MAD)8
Skewness0
Sum561
Variance93.5
MonotonicityStrictly increasing
2024-01-28T16:30:10.396241image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=33)
ValueCountFrequency (%)
1 1
 
3.0%
26 1
 
3.0%
20 1
 
3.0%
21 1
 
3.0%
22 1
 
3.0%
23 1
 
3.0%
24 1
 
3.0%
25 1
 
3.0%
27 1
 
3.0%
2 1
 
3.0%
Other values (23) 23
69.7%
ValueCountFrequency (%)
1 1
3.0%
2 1
3.0%
3 1
3.0%
4 1
3.0%
5 1
3.0%
6 1
3.0%
7 1
3.0%
8 1
3.0%
9 1
3.0%
10 1
3.0%
ValueCountFrequency (%)
33 1
3.0%
32 1
3.0%
31 1
3.0%
30 1
3.0%
29 1
3.0%
28 1
3.0%
27 1
3.0%
26 1
3.0%
25 1
3.0%
24 1
3.0%

수탁기관
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)9.1%
Missing0
Missing (%)0.0%
Memory size396.0 B
학산
24 
모금회
8 
수와진의 사랑더하기
 
1

Length

Max length10
Median length2
Mean length2.4848485
Min length2

Unique

Unique1 ?
Unique (%)3.0%

Sample

1st row모금회
2nd row학산
3rd row모금회
4th row모금회
5th row모금회

Common Values

ValueCountFrequency (%)
학산 24
72.7%
모금회 8
 
24.2%
수와진의 사랑더하기 1
 
3.0%

Length

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

Common Values (Plot)

2024-01-28T16:30:10.602155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
학산 24
70.6%
모금회 8
 
23.5%
수와진의 1
 
2.9%
사랑더하기 1
 
2.9%

기부일시
Date

Distinct23
Distinct (%)69.7%
Missing0
Missing (%)0.0%
Memory size396.0 B
Minimum2023-01-04 00:00:00
Maximum2023-06-20 00:00:00
2024-01-28T16:30:10.684697image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T16:30:10.775934image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)

현금
Real number (ℝ)

MISSING 

Distinct9
Distinct (%)52.9%
Missing16
Missing (%)48.5%
Infinite0
Infinite (%)0.0%
Mean15812676
Minimum155500
Maximum2 × 108
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size429.0 B
2024-01-28T16:30:10.878227image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum155500
5-th percentile271100
Q11000000
median2000000
Q310000000
95-th percentile48000000
Maximum2 × 108
Range1.998445 × 108
Interquartile range (IQR)9000000

Descriptive statistics

Standard deviation47638495
Coefficient of variation (CV)3.0126775
Kurtosis16.70234
Mean15812676
Median Absolute Deviation (MAD)1700000
Skewness4.0723416
Sum2.688155 × 108
Variance2.2694262 × 1015
MonotonicityNot monotonic
2024-01-28T16:30:10.983905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
10000000 5
 
15.2%
1000000 4
 
12.1%
2000000 2
 
6.1%
3000000 1
 
3.0%
200000000 1
 
3.0%
1100000 1
 
3.0%
6260000 1
 
3.0%
300000 1
 
3.0%
155500 1
 
3.0%
(Missing) 16
48.5%
ValueCountFrequency (%)
155500 1
 
3.0%
300000 1
 
3.0%
1000000 4
12.1%
1100000 1
 
3.0%
2000000 2
 
6.1%
3000000 1
 
3.0%
6260000 1
 
3.0%
10000000 5
15.2%
200000000 1
 
3.0%
ValueCountFrequency (%)
200000000 1
 
3.0%
10000000 5
15.2%
6260000 1
 
3.0%
3000000 1
 
3.0%
2000000 2
 
6.1%
1100000 1
 
3.0%
1000000 4
12.1%
300000 1
 
3.0%
155500 1
 
3.0%

물품
Text

MISSING 

Distinct16
Distinct (%)100.0%
Missing17
Missing (%)51.5%
Memory size396.0 B
2024-01-28T16:30:11.141758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length13.5
Mean length11.8125
Min length6

Characters and Unicode

Total characters189
Distinct characters52
Distinct categories6 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique16 ?
Unique (%)100.0%

Sample

1st row쌀(10kg) 66포
2nd row연탄 2만장
3rd row라면(30개입) 180상자
4th row쌀(10kg) 100포
5th row쌀(10kg) 200포
ValueCountFrequency (%)
쌀(10kg 4
 
11.8%
컵라면(6개입 2
 
5.9%
배즙(40개입 1
 
2.9%
100상자 1
 
2.9%
위생장갑 1
 
2.9%
200개 1
 
2.9%
책가방 1
 
2.9%
저학년 1
 
2.9%
210상자 1
 
2.9%
라면(20개입 1
 
2.9%
Other values (20) 20
58.8%
2024-01-28T16:30:11.428568image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 31
16.4%
21
 
11.1%
1 10
 
5.3%
( 10
 
5.3%
) 10
 
5.3%
2 9
 
4.8%
개 7
 
3.7%
6 5
 
2.6%
입 5
 
2.6%
상 5
 
2.6%
Other values (42) 76
40.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 73
38.6%
Decimal Number 65
34.4%
Space Separator 21
 
11.1%
Open Punctuation 10
 
5.3%
Close Punctuation 10
 
5.3%
Lowercase Letter 10
 
5.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
개 7
 
9.6%
입 5
 
6.8%
상 5
 
6.8%
자 5
 
6.8%
쌀 4
 
5.5%
포 4
 
5.5%
면 4
 
5.5%
라 4
 
5.5%
김 2
 
2.7%
매 2
 
2.7%
Other values (29) 31
42.5%
Decimal Number
ValueCountFrequency (%)
0 31
47.7%
1 10
 
15.4%
2 9
 
13.8%
6 5
 
7.7%
4 4
 
6.2%
3 3
 
4.6%
8 2
 
3.1%
5 1
 
1.5%
Lowercase Letter
ValueCountFrequency (%)
g 5
50.0%
k 5
50.0%
Space Separator
ValueCountFrequency (%)
21
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 106
56.1%
Hangul 73
38.6%
Latin 10
 
5.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
개 7
 
9.6%
입 5
 
6.8%
상 5
 
6.8%
자 5
 
6.8%
쌀 4
 
5.5%
포 4
 
5.5%
면 4
 
5.5%
라 4
 
5.5%
김 2
 
2.7%
매 2
 
2.7%
Other values (29) 31
42.5%
Common
ValueCountFrequency (%)
0 31
29.2%
21
19.8%
1 10
 
9.4%
( 10
 
9.4%
) 10
 
9.4%
2 9
 
8.5%
6 5
 
4.7%
4 4
 
3.8%
3 3
 
2.8%
8 2
 
1.9%
Latin
ValueCountFrequency (%)
g 5
50.0%
k 5
50.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 116
61.4%
Hangul 73
38.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 31
26.7%
21
18.1%
1 10
 
8.6%
( 10
 
8.6%
) 10
 
8.6%
2 9
 
7.8%
6 5
 
4.3%
g 5
 
4.3%
k 5
 
4.3%
4 4
 
3.4%
Other values (3) 6
 
5.2%
Hangul
ValueCountFrequency (%)
개 7
 
9.6%
입 5
 
6.8%
상 5
 
6.8%
자 5
 
6.8%
쌀 4
 
5.5%
포 4
 
5.5%
면 4
 
5.5%
라 4
 
5.5%
김 2
 
2.7%
매 2
 
2.7%
Other values (29) 31
42.5%

배부대상자
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct5
Distinct (%)15.2%
Missing0
Missing (%)0.0%
Memory size396.0 B
미추홀구 저소득 세대
26 
미추홀구 지역복지사업
 
2
미추홀구 사회복지시설 및 저소득 세대
 
2
무료급식소
 
2
미추홀구 사회복지시설
 
1

Length

Max length20
Median length11
Mean length11.181818
Min length5

Unique

Unique1 ?
Unique (%)3.0%

Sample

1st row미추홀구 저소득 세대
2nd row미추홀구 저소득 세대
3rd row미추홀구 지역복지사업
4th row미추홀구 지역복지사업
5th row미추홀구 저소득 세대

Common Values

ValueCountFrequency (%)
미추홀구 저소득 세대 26
78.8%
미추홀구 지역복지사업 2
 
6.1%
미추홀구 사회복지시설 및 저소득 세대 2
 
6.1%
무료급식소 2
 
6.1%
미추홀구 사회복지시설 1
 
3.0%

Length

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

Common Values (Plot)

2024-01-28T16:30:11.644764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
미추홀구 31
32.3%
저소득 28
29.2%
세대 28
29.2%
사회복지시설 3
 
3.1%
지역복지사업 2
 
2.1%
및 2
 
2.1%
무료급식소 2
 
2.1%

Interactions

2024-01-28T16:30:09.812459image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T16:30:09.655554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T16:30:09.892290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T16:30:09.723165image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-28T16:30:11.714838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번수탁기관기부일시현금물품배부대상자
연번1.0000.0000.9160.0001.0000.436
수탁기관0.0001.0000.8480.0001.0000.749
기부일시0.9160.8481.0000.0001.0000.197
현금0.0000.0000.0001.000NaN0.245
물품1.0001.0001.000NaN1.0001.000
배부대상자0.4360.7490.1970.2451.0001.000
2024-01-28T16:30:11.814619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
수탁기관배부대상자
수탁기관1.0000.723
배부대상자0.7231.000
2024-01-28T16:30:11.892208image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번현금수탁기관배부대상자
연번1.000-0.3250.0000.148
현금-0.3251.0000.0000.165
수탁기관0.0000.0001.0000.723
배부대상자0.1480.1650.7231.000

Missing values

2024-01-28T16:30:10.013868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-28T16:30:10.105942image/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.
2024-01-28T16:30:10.190498image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

연번수탁기관기부일시현금물품배부대상자
01모금회2023-01-04<NA>쌀(10kg) 66포미추홀구 저소득 세대
12학산2023-01-04<NA>연탄 2만장미추홀구 저소득 세대
23모금회2023-01-053000000<NA>미추홀구 지역복지사업
34모금회2023-01-05200000000<NA>미추홀구 지역복지사업
45모금회2023-01-1910000000<NA>미추홀구 저소득 세대
56학산2023-01-17<NA>라면(30개입) 180상자미추홀구 사회복지시설 및 저소득 세대
67학산2023-01-122000000<NA>미추홀구 저소득 세대
78학산2023-01-101100000<NA>미추홀구 저소득 세대
89학산2023-01-17<NA>쌀(10kg) 100포무료급식소
910학산2023-01-16<NA>쌀(10kg) 200포미추홀구 저소득 세대
연번수탁기관기부일시현금물품배부대상자
2324학산2023-04-1110000000<NA>미추홀구 저소득 세대
2425학산2023-04-2410000000<NA>미추홀구 저소득 세대
2526모금회2023-04-24<NA>계절김치(4kg) 210통미추홀구 저소득 세대
2627학산2023-05-01<NA>아동의류 200벌미추홀구 저소득 세대
2728모금회2023-05-081000000<NA>미추홀구 저소득 세대
2829학산2023-05-0810000000<NA>미추홀구 저소득 세대
2930학산2023-05-26155500<NA>미추홀구 저소득 세대
3031모금회2023-06-021000000<NA>미추홀구 저소득 세대
3132학산2023-06-15<NA>라면(20개입) 210상자미추홀구 저소득 세대
3233수와진의 사랑더하기2023-06-20<NA>위생장갑 52000매미추홀구 사회복지시설