Overview

Dataset statistics

Number of variables4
Number of observations10000
Missing cells11
Missing cells (%)< 0.1%
Duplicate rows22
Duplicate rows (%)0.2%
Total size in memory390.6 KiB
Average record size in memory40.0 B

Variable types

Text2
Categorical1
DateTime1

Dataset

Description아산시 생활민원처리시스템을 통해 접수된 민원의 처리 내용에 관한 정보(민원인의 개인정보 및 민원내용 제외)로서 처리과, 처리팀, 분류명, 처리일시를 표현합니다.
Author충청남도 아산시
URLhttps://www.data.go.kr/data/15063409/fileData.do

Alerts

Dataset has 22 (0.2%) duplicate rowsDuplicates

Reproduction

Analysis started2024-04-21 01:29:03.965517
Analysis finished2024-04-21 01:29:05.588656
Duration1.62 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

처리부서
Text

Distinct75
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-04-21T10:29:05.760819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length5
Mean length4.8328
Min length3

Characters and Unicode

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

Unique

Unique3 ?
Unique (%)< 0.1%

Sample

1st row도로관리과
2nd row도로관리과
3rd row기후변화대책과
4th row축산과
5th row교통행정과
ValueCountFrequency (%)
도로관리과 2183
21.8%
교통행정과 1053
 
10.5%
대중교통과 874
 
8.7%
기후변화대책과 826
 
8.3%
자원순환과 771
 
7.7%
도로시설과 358
 
3.6%
상수도과 337
 
3.4%
공원녹지과 280
 
2.8%
환경보전과 218
 
2.2%
배방읍 205
 
2.1%
Other values (65) 2895
28.9%
2024-04-21T10:29:06.143244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
과 9051
18.7%
도 3317
 
6.9%
로 2577
 
5.3%
관 2273
 
4.7%
리 2200
 
4.6%
통 1991
 
4.1%
교 1936
 
4.0%
대 1700
 
3.5%
정 1602
 
3.3%
행 1306
 
2.7%
Other values (115) 20375
42.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 48157
99.6%
Decimal Number 171
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
과 9051
18.8%
도 3317
 
6.9%
로 2577
 
5.4%
관 2273
 
4.7%
리 2200
 
4.6%
통 1991
 
4.1%
교 1936
 
4.0%
대 1700
 
3.5%
정 1602
 
3.3%
행 1306
 
2.7%
Other values (109) 20204
42.0%
Decimal Number
ValueCountFrequency (%)
1 38
22.2%
3 32
18.7%
4 32
18.7%
5 29
17.0%
6 23
13.5%
2 17
9.9%

Most occurring scripts

ValueCountFrequency (%)
Hangul 48157
99.6%
Common 171
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
과 9051
18.8%
도 3317
 
6.9%
로 2577
 
5.4%
관 2273
 
4.7%
리 2200
 
4.6%
통 1991
 
4.1%
교 1936
 
4.0%
대 1700
 
3.5%
정 1602
 
3.3%
행 1306
 
2.7%
Other values (109) 20204
42.0%
Common
ValueCountFrequency (%)
1 38
22.2%
3 32
18.7%
4 32
18.7%
5 29
17.0%
6 23
13.5%
2 17
9.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 48157
99.6%
ASCII 171
 
0.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
과 9051
18.8%
도 3317
 
6.9%
로 2577
 
5.4%
관 2273
 
4.7%
리 2200
 
4.6%
통 1991
 
4.1%
교 1936
 
4.0%
대 1700
 
3.5%
정 1602
 
3.3%
행 1306
 
2.7%
Other values (109) 20204
42.0%
ASCII
ValueCountFrequency (%)
1 38
22.2%
3 32
18.7%
4 32
18.7%
5 29
17.0%
6 23
13.5%
2 17
9.9%

처리팀
Text

Distinct193
Distinct (%)1.9%
Missing11
Missing (%)0.1%
Memory size156.2 KiB
2024-04-21T10:29:06.391743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length5
Mean length4.9928922
Min length2

Characters and Unicode

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

Unique

Unique35 ?
Unique (%)0.4%

Sample

1st row도로관리팀
2nd row도로관리팀
3rd row생활환경팀
4th row동물보호팀
5th row자동차관리팀
ValueCountFrequency (%)
도로관리팀 1849
18.5%
생활환경팀 769
 
7.7%
운수지도팀 631
 
6.3%
청소행정팀 595
 
6.0%
산업개발팀 514
 
5.1%
교통시설팀 471
 
4.7%
교통지도팀 450
 
4.5%
누수관리팀 281
 
2.8%
가로등팀 255
 
2.6%
요금관리팀 199
 
2.0%
Other values (183) 3975
39.8%
2024-04-21T10:29:06.780485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
팀 9957
20.0%
도 3611
 
7.2%
관 3134
 
6.3%
리 3076
 
6.2%
로 2471
 
5.0%
지 1821
 
3.7%
통 1250
 
2.5%
교 1239
 
2.5%
정 1204
 
2.4%
수 1188
 
2.4%
Other values (172) 20923
42.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 49729
99.7%
Decimal Number 126
 
0.3%
Uppercase Letter 19
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
팀 9957
20.0%
도 3611
 
7.3%
관 3134
 
6.3%
리 3076
 
6.2%
로 2471
 
5.0%
지 1821
 
3.7%
통 1250
 
2.5%
교 1239
 
2.5%
정 1204
 
2.4%
수 1188
 
2.4%
Other values (166) 20778
41.8%
Uppercase Letter
ValueCountFrequency (%)
F 8
42.1%
T 8
42.1%
S 2
 
10.5%
N 1
 
5.3%
Decimal Number
ValueCountFrequency (%)
2 69
54.8%
1 57
45.2%

Most occurring scripts

ValueCountFrequency (%)
Hangul 49729
99.7%
Common 126
 
0.3%
Latin 19
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
팀 9957
20.0%
도 3611
 
7.3%
관 3134
 
6.3%
리 3076
 
6.2%
로 2471
 
5.0%
지 1821
 
3.7%
통 1250
 
2.5%
교 1239
 
2.5%
정 1204
 
2.4%
수 1188
 
2.4%
Other values (166) 20778
41.8%
Latin
ValueCountFrequency (%)
F 8
42.1%
T 8
42.1%
S 2
 
10.5%
N 1
 
5.3%
Common
ValueCountFrequency (%)
2 69
54.8%
1 57
45.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 49729
99.7%
ASCII 145
 
0.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
팀 9957
20.0%
도 3611
 
7.3%
관 3134
 
6.3%
리 3076
 
6.2%
로 2471
 
5.0%
지 1821
 
3.7%
통 1250
 
2.5%
교 1239
 
2.5%
정 1204
 
2.4%
수 1188
 
2.4%
Other values (166) 20778
41.8%
ASCII
ValueCountFrequency (%)
2 69
47.6%
1 57
39.3%
F 8
 
5.5%
T 8
 
5.5%
S 2
 
1.4%
N 1
 
0.7%

민원유형-중
Categorical

Distinct20
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
05.도로관리
3342 
01.교통관리
1992 
10.환경관리
1706 
08.상하수도
724 
01.건축건설
464 
Other values (15)
1772 

Length

Max length9
Median length7
Mean length7.0496
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row05.도로관리
2nd row05.도로관리
3rd row10.환경관리
4th row04.농축수산업
5th row01.교통관리

Common Values

ValueCountFrequency (%)
05.도로관리 3342
33.4%
01.교통관리 1992
19.9%
10.환경관리 1706
17.1%
08.상하수도 724
 
7.2%
01.건축건설 464
 
4.6%
10.공원/녹지 453
 
4.5%
09.행정관리 214
 
2.1%
04.농축수산업 151
 
1.5%
07.보건의료 150
 
1.5%
07.식품공중위생 137
 
1.4%
Other values (10) 667
 
6.7%

Length

2024-04-21T10:29:06.936359image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
05.도로관리 3342
33.4%
01.교통관리 1992
19.9%
10.환경관리 1706
17.1%
08.상하수도 724
 
7.2%
01.건축건설 464
 
4.6%
10.공원/녹지 453
 
4.5%
09.행정관리 214
 
2.1%
04.농축수산업 151
 
1.5%
07.보건의료 150
 
1.5%
07.식품공중위생 137
 
1.4%
Other values (10) 667
 
6.7%

접수일시
Date

Distinct9757
Distinct (%)97.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-03-27 08:48:00
Maximum2024-04-09 13:40:00
2024-04-21T10:29:07.068318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:29:07.221018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Correlations

2024-04-21T10:29:07.325725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
처리부서민원유형-중
처리부서1.0000.994
민원유형-중0.9941.000

Missing values

2024-04-21T10:29:05.421126image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T10:29:05.530859image/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

처리부서처리팀민원유형-중접수일시
2423도로관리과도로관리팀05.도로관리2024-02-28 14:35
2288도로관리과도로관리팀05.도로관리2024-02-23 11:08
19253기후변화대책과생활환경팀10.환경관리2023-06-14 23:31
12726축산과동물보호팀04.농축수산업2023-09-11 09:39
1560교통행정과자동차관리팀01.교통관리2024-03-06 16:04
3170수도행정과요금관리팀08.상하수도2024-02-13 11:52
17935도로관리과도로관리팀05.도로관리2023-06-30 12:06
19371도로시설과도로계획팀05.도로관리2023-06-13 16:50
21100교통행정과교통시설팀01.교통관리2023-05-10 15:21
8159관광진흥과충효애사업TF팀06.문화관광2023-11-18 10:50
처리부서처리팀민원유형-중접수일시
7684영인면총무팀10.환경관리2023-11-28 14:31
6203온양2동총무팀05.도로관리2023-12-21 15:09
17884염치읍산업개발팀10.환경관리2023-07-04 09:23
127환경보전과오수관리팀10.환경관리2024-04-04 16:09
3903자원순환과청소행정팀10.환경관리2024-01-29 15:37
12819자원순환과청소행정팀10.환경관리2023-09-01 09:59
14043기후변화대책과생활환경팀10.환경관리2023-08-24 17:40
12771도로시설과가로등팀05.도로관리2023-09-07 14:08
22468교통행정과교통지도팀01.교통관리2023-04-23 13:50
2726시민소통담당관민원콜센터팀09.행정관리2024-02-23 07:47

Duplicate rows

Most frequently occurring

처리부서처리팀민원유형-중접수일시# duplicates
14생태하천과곡교천개발팀10.공원/녹지2023-06-29 12:303
0기후변화대책과생활환경팀10.환경관리2023-09-11 09:382
1대중교통과운수지도팀01.교통관리2023-04-07 18:002
2도로관리과도로관리팀05.도로관리2023-06-09 18:172
3도로관리과도로관리팀05.도로관리2023-07-18 13:052
4도로관리과도로관리팀05.도로관리2023-08-23 18:102
5도로관리과도로관리팀05.도로관리2023-12-21 09:292
6도로관리과도로관리팀05.도로관리2024-01-23 08:442
7도로관리과도로관리팀05.도로관리2024-01-23 09:452
8도로관리과도로관리팀05.도로관리2024-01-23 12:242