Overview

Dataset statistics

Number of variables5
Number of observations55
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.3 KiB
Average record size in memory43.4 B

Variable types

Numeric1
Categorical1
Text2
DateTime1

Dataset

Description인천광역시 서구의 구술또는전화 신청가능 민원현황에 관한 데이터입니다. 분야, 민원목록, 세부항목 등의 항목이 제공됩니다.
Author인천광역시
URLhttps://www.incheon.go.kr/data/DATA010201/view?docId=15105617

Alerts

데이터기준일자 has constant value ""Constant
연번 is highly overall correlated with 분야High correlation
분야 is highly overall correlated with 연번High correlation
연번 has unique valuesUnique
민원목록 has unique valuesUnique

Reproduction

Analysis started2024-01-28 06:59:35.083642
Analysis finished2024-01-28 06:59:35.707671
Duration0.62 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct55
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean28
Minimum1
Maximum55
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size627.0 B
2024-01-28T15:59:35.761786image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.7
Q114.5
median28
Q341.5
95-th percentile52.3
Maximum55
Range54
Interquartile range (IQR)27

Descriptive statistics

Standard deviation16.02082
Coefficient of variation (CV)0.57217214
Kurtosis-1.2
Mean28
Median Absolute Deviation (MAD)14
Skewness0
Sum1540
Variance256.66667
MonotonicityStrictly increasing
2024-01-28T15:59:35.864023image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.8%
2 1
 
1.8%
31 1
 
1.8%
32 1
 
1.8%
33 1
 
1.8%
34 1
 
1.8%
35 1
 
1.8%
36 1
 
1.8%
37 1
 
1.8%
38 1
 
1.8%
Other values (45) 45
81.8%
ValueCountFrequency (%)
1 1
1.8%
2 1
1.8%
3 1
1.8%
4 1
1.8%
5 1
1.8%
6 1
1.8%
7 1
1.8%
8 1
1.8%
9 1
1.8%
10 1
1.8%
ValueCountFrequency (%)
55 1
1.8%
54 1
1.8%
53 1
1.8%
52 1
1.8%
51 1
1.8%
50 1
1.8%
49 1
1.8%
48 1
1.8%
47 1
1.8%
46 1
1.8%

분야
Categorical

HIGH CORRELATION 

Distinct12
Distinct (%)21.8%
Missing0
Missing (%)0.0%
Memory size572.0 B
청소
도로
보건
환경
기타
Other values (7)
21 

Length

Max length4
Median length2
Mean length2.5818182
Min length2

Unique

Unique1 ?
Unique (%)1.8%

Sample

1st row교통
2nd row교통
3rd row교통
4th row교통
5th row도로

Common Values

ValueCountFrequency (%)
청소 8
14.5%
도로 7
12.7%
보건 7
12.7%
환경 7
12.7%
기타 5
9.1%
교통 4
7.3%
치수방재 4
7.3%
주택건축 3
 
5.5%
가로정비 3
 
5.5%
공원녹지 3
 
5.5%
Other values (2) 4
7.3%

Length

2024-01-28T15:59:35.977163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
청소 8
14.5%
도로 7
12.7%
보건 7
12.7%
환경 7
12.7%
기타 5
9.1%
교통 4
7.3%
치수방재 4
7.3%
주택건축 3
 
5.5%
가로정비 3
 
5.5%
공원녹지 3
 
5.5%
Other values (2) 4
7.3%

민원목록
Text

UNIQUE 

Distinct55
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size572.0 B
2024-01-28T15:59:36.193688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length13
Mean length7.4363636
Min length2

Characters and Unicode

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

Unique

Unique55 ?
Unique (%)100.0%

Sample

1st row불법주정차
2nd row장애인주차구역위반
3rd row방치차량
4th row교통불편신고
5th row도로시설물
ValueCountFrequency (%)
신고 5
 
5.6%
불편사항 4
 
4.5%
불편신고 2
 
2.2%
관리 2
 
2.2%
집단 2
 
2.2%
미수거 2
 
2.2%
불법주정차 1
 
1.1%
수질관리 1
 
1.1%
1
 
1.1%
공원(약수터 1
 
1.1%
Other values (68) 68
76.4%
2024-01-28T15:59:36.504184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
34
 
8.3%
18
 
4.4%
14
 
3.4%
12
 
2.9%
12
 
2.9%
11
 
2.7%
) 10
 
2.4%
( 10
 
2.4%
10
 
2.4%
9
 
2.2%
Other values (117) 269
65.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 353
86.3%
Space Separator 34
 
8.3%
Close Punctuation 10
 
2.4%
Open Punctuation 10
 
2.4%
Other Punctuation 2
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
18
 
5.1%
14
 
4.0%
12
 
3.4%
12
 
3.4%
11
 
3.1%
10
 
2.8%
9
 
2.5%
8
 
2.3%
7
 
2.0%
7
 
2.0%
Other values (113) 245
69.4%
Space Separator
ValueCountFrequency (%)
34
100.0%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Other Punctuation
ValueCountFrequency (%)
· 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 353
86.3%
Common 56
 
13.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
18
 
5.1%
14
 
4.0%
12
 
3.4%
12
 
3.4%
11
 
3.1%
10
 
2.8%
9
 
2.5%
8
 
2.3%
7
 
2.0%
7
 
2.0%
Other values (113) 245
69.4%
Common
ValueCountFrequency (%)
34
60.7%
) 10
 
17.9%
( 10
 
17.9%
· 2
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 353
86.3%
ASCII 54
 
13.2%
None 2
 
0.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
34
63.0%
) 10
 
18.5%
( 10
 
18.5%
Hangul
ValueCountFrequency (%)
18
 
5.1%
14
 
4.0%
12
 
3.4%
12
 
3.4%
11
 
3.1%
10
 
2.8%
9
 
2.5%
8
 
2.3%
7
 
2.0%
7
 
2.0%
Other values (113) 245
69.4%
None
ValueCountFrequency (%)
· 2
100.0%
Distinct54
Distinct (%)98.2%
Missing0
Missing (%)0.0%
Memory size572.0 B
2024-01-28T15:59:36.691150image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length83
Median length32
Mean length18.672727
Min length6

Characters and Unicode

Total characters1027
Distinct characters181
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique53 ?
Unique (%)96.4%

Sample

1st row불법주정차 단속
2nd row장애인 주차구역 위반차량 단속
3rd row방치차량 견인, 이륜차 단속
4th row교통표지판, 보행자 안내표지판, 교통시설물, 교통표지판 신설, 버스 정류장 신설 요청
5th row교량, 터널, 육교, 축대, 옹벽, 지하도 등 (안전 위해사항은 즉시처리)
ValueCountFrequency (%)
29
 
12.0%
신고 11
 
4.6%
불편사항 5
 
2.1%
미수거 3
 
1.2%
관리 3
 
1.2%
공사장 3
 
1.2%
단속 3
 
1.2%
배출시 2
 
0.8%
불편신고 2
 
0.8%
불법 2
 
0.8%
Other values (162) 178
73.9%
2024-01-28T15:59:36.982441image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
186
 
18.1%
, 48
 
4.7%
33
 
3.2%
25
 
2.4%
23
 
2.2%
18
 
1.8%
18
 
1.8%
18
 
1.8%
17
 
1.7%
17
 
1.7%
Other values (171) 624
60.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 755
73.5%
Space Separator 186
 
18.1%
Other Punctuation 53
 
5.2%
Open Punctuation 14
 
1.4%
Close Punctuation 14
 
1.4%
Uppercase Letter 4
 
0.4%
Decimal Number 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
33
 
4.4%
25
 
3.3%
23
 
3.0%
18
 
2.4%
18
 
2.4%
18
 
2.4%
17
 
2.3%
17
 
2.3%
16
 
2.1%
14
 
1.9%
Other values (161) 556
73.6%
Other Punctuation
ValueCountFrequency (%)
, 48
90.6%
· 4
 
7.5%
/ 1
 
1.9%
Uppercase Letter
ValueCountFrequency (%)
C 2
50.0%
V 1
25.0%
T 1
25.0%
Space Separator
ValueCountFrequency (%)
186
100.0%
Open Punctuation
ValueCountFrequency (%)
( 14
100.0%
Close Punctuation
ValueCountFrequency (%)
) 14
100.0%
Decimal Number
ValueCountFrequency (%)
1 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 755
73.5%
Common 268
 
26.1%
Latin 4
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
33
 
4.4%
25
 
3.3%
23
 
3.0%
18
 
2.4%
18
 
2.4%
18
 
2.4%
17
 
2.3%
17
 
2.3%
16
 
2.1%
14
 
1.9%
Other values (161) 556
73.6%
Common
ValueCountFrequency (%)
186
69.4%
, 48
 
17.9%
( 14
 
5.2%
) 14
 
5.2%
· 4
 
1.5%
/ 1
 
0.4%
1 1
 
0.4%
Latin
ValueCountFrequency (%)
C 2
50.0%
V 1
25.0%
T 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 755
73.5%
ASCII 268
 
26.1%
None 4
 
0.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
186
69.4%
, 48
 
17.9%
( 14
 
5.2%
) 14
 
5.2%
C 2
 
0.7%
V 1
 
0.4%
T 1
 
0.4%
/ 1
 
0.4%
1 1
 
0.4%
Hangul
ValueCountFrequency (%)
33
 
4.4%
25
 
3.3%
23
 
3.0%
18
 
2.4%
18
 
2.4%
18
 
2.4%
17
 
2.3%
17
 
2.3%
16
 
2.1%
14
 
1.9%
Other values (161) 556
73.6%
None
ValueCountFrequency (%)
· 4
100.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size572.0 B
Minimum2023-07-01 00:00:00
Maximum2023-07-01 00:00:00
2024-01-28T15:59:37.065991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T15:59:37.132140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-01-28T15:59:35.326638image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-28T15:59:37.183013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번분야민원목록세부항목
연번1.0000.9431.0000.933
분야0.9431.0001.0001.000
민원목록1.0001.0001.0001.000
세부항목0.9331.0001.0001.000
2024-01-28T15:59:37.256864image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번분야
연번1.0000.765
분야0.7651.000

Missing values

2024-01-28T15:59:35.611788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-28T15:59:35.680098image/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교통불법주정차불법주정차 단속2023-07-01
12교통장애인주차구역위반장애인 주차구역 위반차량 단속2023-07-01
23교통방치차량방치차량 견인, 이륜차 단속2023-07-01
34교통교통불편신고교통표지판, 보행자 안내표지판, 교통시설물, 교통표지판 신설, 버스 정류장 신설 요청2023-07-01
45도로도로시설물교량, 터널, 육교, 축대, 옹벽, 지하도 등 (안전 위해사항은 즉시처리)2023-07-01
56도로보안등고장고장수리 (조도개선, 미점등 등)2023-07-01
67도로가로등고장고장수리 (조도개선, 미점등 등)2023-07-01
78도로제설요청(계절적 업무)2023-07-01
89도로도로불편사항 (구도로)도로파손, 보도블럭 정비 등2023-07-01
910도로자전거전용도로 불편사항자전거 도로이용 불편신고 (도로파손 등 신고, 건의·제안)2023-07-01
연번분야민원목록세부항목데이터기준일자
4546환경환경오염유독물질 유출, 오폐수 방류, 휘발성 유기화합물 배출시설 관리2023-07-01
4647경제산업불법통신 판매업 유해신고불법통신 판매업 유해신고2023-07-01
4748경제산업부동산중개 불편사항부동산중개업 위법행위 신고2023-07-01
4849경제산업대부업 관련 불편사항대부업 피해 신고2023-07-01
4950기타다중이용시설물 이용불편(구)구청사, 동주민센터, 주민자치센터, 구민회관, 구립체육관(구립체육시설) / 구립도서관, 노인복지관, 아동복지시설, 문화시설 등 다중이용시설물 불편신고2023-07-01
5051기타여성불편(구)화장실, 수유시설, 기저귀 교환장소, 휴식공간 등2023-07-01
5152기타관광·복지(구)문화재, 공연장, 전시장, 각종 복지시설 관련 불편사항2023-07-01
5253기타방범시설CCTV(방범용, 쓰레기무단투기 단속용 등) 설치·보수 등 불편사항2023-07-01
5354기타행사(구)행사(단기·장기)장 이용 불편2023-07-01
5455건의건의·제안사항(구)그 밖의 건의·제안사항 등2023-07-01