Overview

Dataset statistics

Number of variables8
Number of observations2470
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory159.3 KiB
Average record size in memory66.1 B

Variable types

Numeric2
Categorical4
Text1
DateTime1

Dataset

Description광주광역시 온라인 시민소통플랫폼 광주온(ON) 홈페이지에 등록된 시민제안 현황 데이터로 제안명, 등록일, 조회수 등의 항목을 공개합니다.
Author광주광역시
URLhttps://www.data.go.kr/data/15062116/fileData.do

Alerts

순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 17:35:56.160802
Analysis finished2023-12-12 17:35:57.964343
Duration1.8 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct2470
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1235.5
Minimum1
Maximum2470
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size21.8 KiB
2023-12-13T02:35:58.066798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile124.45
Q1618.25
median1235.5
Q31852.75
95-th percentile2346.55
Maximum2470
Range2469
Interquartile range (IQR)1234.5

Descriptive statistics

Standard deviation713.17191
Coefficient of variation (CV)0.57723343
Kurtosis-1.2
Mean1235.5
Median Absolute Deviation (MAD)617.5
Skewness0
Sum3051685
Variance508614.17
MonotonicityStrictly decreasing
2023-12-13T02:35:58.256925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2470 1
 
< 0.1%
820 1
 
< 0.1%
827 1
 
< 0.1%
826 1
 
< 0.1%
825 1
 
< 0.1%
824 1
 
< 0.1%
823 1
 
< 0.1%
822 1
 
< 0.1%
821 1
 
< 0.1%
819 1
 
< 0.1%
Other values (2460) 2460
99.6%
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 (%)
2470 1
< 0.1%
2469 1
< 0.1%
2468 1
< 0.1%
2467 1
< 0.1%
2466 1
< 0.1%
2465 1
< 0.1%
2464 1
< 0.1%
2463 1
< 0.1%
2462 1
< 0.1%
2461 1
< 0.1%

분야
Categorical

Distinct7
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size19.4 KiB
도시재생교통건설
904 
복지환경
604 
일반행정
372 
문화관광체육
305 
일자리경제
149 
Other values (2)
136 

Length

Max length11
Median length8
Mean length5.7048583
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row도시재생교통건설
2nd row일반행정
3rd row문화관광체육
4th row도시재생교통건설
5th row일반행정

Common Values

ValueCountFrequency (%)
도시재생교통건설 904
36.6%
복지환경 604
24.5%
일반행정 372
15.1%
문화관광체육 305
 
12.3%
일자리경제 149
 
6.0%
교육 124
 
5.0%
정책 아이디어(국민) 12
 
0.5%

Length

2023-12-13T02:35:58.429026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:35:58.575274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
도시재생교통건설 904
36.4%
복지환경 604
24.3%
일반행정 372
15.0%
문화관광체육 305
 
12.3%
일자리경제 149
 
6.0%
교육 124
 
5.0%
정책 12
 
0.5%
아이디어(국민 12
 
0.5%

제목
Text

Distinct2405
Distinct (%)97.4%
Missing0
Missing (%)0.0%
Memory size19.4 KiB
2023-12-13T02:35:59.062736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length300
Median length61
Mean length20.204049
Min length2

Characters and Unicode

Total characters49904
Distinct characters894
Distinct categories14 ?
Distinct scripts4 ?
Distinct blocks7 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique2365 ?
Unique (%)95.7%

Sample

1st row일신방직터 복합쇼핑몰 공공기여율 조정
2nd row정율성 공원보다 인프라 시설 확충이 먼저입니다.
3rd row홍범도장군님의 흉상을 민주성지 광주에 유치해주시기 바랍니다.
4th row신속한 복합쇼핑몰 유치 및 지하철 3,4 호선 추가 공사 진행
5th row우리 광주시민과 시민단체, 상인단체랑 토론했음 합니다.
ValueCountFrequency (%)
광주 140
 
1.3%
신설노선 109
 
1.0%
코로나 92
 
0.8%
및 76
 
0.7%
노선 74
 
0.7%
위한 69
 
0.6%
간선버스 65
 
0.6%
제안 64
 
0.6%
버스 59
 
0.5%
57
 
0.5%
Other values (6164) 10373
92.8%
2023-12-13T02:35:59.786504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
8892
 
17.8%
주 1052
 
2.1%
지 758
 
1.5%
광 725
 
1.5%
시 698
 
1.4%
요 618
 
1.2%
로 545
 
1.1%
이 545
 
1.1%
선 544
 
1.1%
스 539
 
1.1%
Other values (884) 34988
70.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 38520
77.2%
Space Separator 8892
 
17.8%
Other Punctuation 1062
 
2.1%
Decimal Number 615
 
1.2%
Uppercase Letter 169
 
0.3%
Math Symbol 156
 
0.3%
Close Punctuation 144
 
0.3%
Open Punctuation 142
 
0.3%
Lowercase Letter 131
 
0.3%
Dash Punctuation 47
 
0.1%
Other values (4) 26
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 1052
 
2.7%
지 758
 
2.0%
광 725
 
1.9%
시 698
 
1.8%
요 618
 
1.6%
로 545
 
1.4%
이 545
 
1.4%
선 544
 
1.4%
스 539
 
1.4%
다 528
 
1.4%
Other values (792) 31968
83.0%
Uppercase Letter
ValueCountFrequency (%)
C 29
17.2%
S 15
 
8.9%
I 14
 
8.3%
T 13
 
7.7%
P 11
 
6.5%
R 10
 
5.9%
D 9
 
5.3%
E 9
 
5.3%
A 7
 
4.1%
V 7
 
4.1%
Other values (14) 45
26.6%
Lowercase Letter
ValueCountFrequency (%)
c 25
19.1%
t 15
11.5%
o 9
 
6.9%
i 8
 
6.1%
r 8
 
6.1%
k 8
 
6.1%
v 7
 
5.3%
s 7
 
5.3%
e 7
 
5.3%
m 5
 
3.8%
Other values (13) 32
24.4%
Other Punctuation
ValueCountFrequency (%)
. 489
46.0%
! 195
 
18.4%
, 133
 
12.5%
? 123
 
11.6%
' 43
 
4.0%
" 38
 
3.6%
/ 17
 
1.6%
: 8
 
0.8%
# 6
 
0.6%
· 4
 
0.4%
Other values (4) 6
 
0.6%
Decimal Number
ValueCountFrequency (%)
1 156
25.4%
2 112
18.2%
0 84
13.7%
9 67
10.9%
5 45
 
7.3%
3 42
 
6.8%
8 36
 
5.9%
7 32
 
5.2%
4 31
 
5.0%
6 10
 
1.6%
Math Symbol
ValueCountFrequency (%)
~ 83
53.2%
> 63
40.4%
< 5
 
3.2%
+ 4
 
2.6%
= 1
 
0.6%
Close Punctuation
ValueCountFrequency (%)
) 131
91.0%
] 11
 
7.6%
」 2
 
1.4%
Open Punctuation
ValueCountFrequency (%)
( 129
90.8%
[ 11
 
7.7%
「 2
 
1.4%
Initial Punctuation
ValueCountFrequency (%)
‘ 7
77.8%
“ 2
 
22.2%
Final Punctuation
ValueCountFrequency (%)
’ 7
77.8%
” 2
 
22.2%
Modifier Symbol
ValueCountFrequency (%)
^ 4
80.0%
` 1
 
20.0%
Other Symbol
ValueCountFrequency (%)
☞ 2
66.7%
★ 1
33.3%
Space Separator
ValueCountFrequency (%)
8892
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 47
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 38517
77.2%
Common 11084
 
22.2%
Latin 300
 
0.6%
Han 3
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 1052
 
2.7%
지 758
 
2.0%
광 725
 
1.9%
시 698
 
1.8%
요 618
 
1.6%
로 545
 
1.4%
이 545
 
1.4%
선 544
 
1.4%
스 539
 
1.4%
다 528
 
1.4%
Other values (789) 31965
83.0%
Latin
ValueCountFrequency (%)
C 29
 
9.7%
c 25
 
8.3%
t 15
 
5.0%
S 15
 
5.0%
I 14
 
4.7%
T 13
 
4.3%
P 11
 
3.7%
R 10
 
3.3%
D 9
 
3.0%
o 9
 
3.0%
Other values (37) 150
50.0%
Common
ValueCountFrequency (%)
8892
80.2%
. 489
 
4.4%
! 195
 
1.8%
1 156
 
1.4%
, 133
 
1.2%
) 131
 
1.2%
( 129
 
1.2%
? 123
 
1.1%
2 112
 
1.0%
0 84
 
0.8%
Other values (35) 640
 
5.8%
Han
ValueCountFrequency (%)
無 1
33.3%
塵 1
33.3%
市 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 38500
77.1%
ASCII 11355
 
22.8%
Punctuation 18
 
< 0.1%
Compat Jamo 17
 
< 0.1%
None 8
 
< 0.1%
Misc Symbols 3
 
< 0.1%
CJK 3
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
8892
78.3%
. 489
 
4.3%
! 195
 
1.7%
1 156
 
1.4%
, 133
 
1.2%
) 131
 
1.2%
( 129
 
1.1%
? 123
 
1.1%
2 112
 
1.0%
0 84
 
0.7%
Other values (73) 911
 
8.0%
Hangul
ValueCountFrequency (%)
주 1052
 
2.7%
지 758
 
2.0%
광 725
 
1.9%
시 698
 
1.8%
요 618
 
1.6%
로 545
 
1.4%
이 545
 
1.4%
선 544
 
1.4%
스 539
 
1.4%
다 528
 
1.4%
Other values (782) 31948
83.0%
Punctuation
ValueCountFrequency (%)
‘ 7
38.9%
’ 7
38.9%
” 2
 
11.1%
“ 2
 
11.1%
Compat Jamo
ValueCountFrequency (%)
ㅠ 5
29.4%
ㆍ 4
23.5%
ㅜ 2
 
11.8%
ㅣ 2
 
11.8%
ㅡ 2
 
11.8%
ㅃ 1
 
5.9%
ㅐ 1
 
5.9%
None
ValueCountFrequency (%)
· 4
50.0%
」 2
25.0%
「 2
25.0%
Misc Symbols
ValueCountFrequency (%)
☞ 2
66.7%
★ 1
33.3%
CJK
ValueCountFrequency (%)
無 1
33.3%
塵 1
33.3%
市 1
33.3%

성별
Categorical

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size19.4 KiB
남성
1768 
<NA>
480 
여성
222 

Length

Max length4
Median length2
Mean length2.388664
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row남성
2nd row<NA>
3rd row남성
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
남성 1768
71.6%
<NA> 480
 
19.4%
여성 222
 
9.0%

Length

2023-12-13T02:35:59.968900image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:36:00.110690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
남성 1768
71.6%
na 480
 
19.4%
여성 222
 
9.0%

연령대
Categorical

Distinct12
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size19.4 KiB
<NA>
785 
20대
474 
40대
414 
30대
366 
50대
233 
Other values (7)
198 

Length

Max length6
Median length3
Mean length3.3190283
Min length3

Unique

Unique3 ?
Unique (%)0.1%

Sample

1st row30대
2nd row<NA>
3rd row50대
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 785
31.8%
20대 474
19.2%
40대 414
16.8%
30대 366
14.8%
50대 233
 
9.4%
60대 100
 
4.0%
10대 74
 
3.0%
70대 18
 
0.7%
80대 3
 
0.1%
15대 1
 
< 0.1%
Other values (2) 2
 
0.1%

Length

2023-12-13T02:36:00.251263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 785
31.8%
20대 474
19.2%
40대 414
16.8%
30대 366
14.8%
50대 233
 
9.4%
60대 100
 
4.0%
10대 75
 
3.0%
70대 18
 
0.7%
80대 3
 
0.1%
15대 1
 
< 0.1%
Other values (2) 2
 
0.1%

시군구
Categorical

Distinct7
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size19.4 KiB
기타
840 
북구
517 
광산구
283 
서구
275 
<NA>
252 
Other values (2)
303 

Length

Max length4
Median length2
Mean length2.3186235
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row광산구
2nd row기타
3rd row광산구
4th row기타
5th row기타

Common Values

ValueCountFrequency (%)
기타 840
34.0%
북구 517
20.9%
광산구 283
 
11.5%
서구 275
 
11.1%
<NA> 252
 
10.2%
남구 182
 
7.4%
동구 121
 
4.9%

Length

2023-12-13T02:36:00.410291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:36:00.586074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기타 840
34.0%
북구 517
20.9%
광산구 283
 
11.5%
서구 275
 
11.1%
na 252
 
10.2%
남구 182
 
7.4%
동구 121
 
4.9%

등록일
Date

Distinct1029
Distinct (%)41.7%
Missing0
Missing (%)0.0%
Memory size19.4 KiB
Minimum2019-03-20 00:00:00
Maximum2023-08-31 00:00:00
2023-12-13T02:36:00.731367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:36:00.904017image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

조회수
Real number (ℝ)

Distinct518
Distinct (%)21.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean280.44858
Minimum1
Maximum34102
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size21.8 KiB
2023-12-13T02:36:01.121256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile12
Q125
median43
Q3100
95-th percentile1532.4
Maximum34102
Range34101
Interquartile range (IQR)75

Descriptive statistics

Standard deviation1138.4978
Coefficient of variation (CV)4.0595599
Kurtosis345.16249
Mean280.44858
Median Absolute Deviation (MAD)23
Skewness14.508097
Sum692708
Variance1296177.3
MonotonicityNot monotonic
2023-12-13T02:36:01.309795image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
21 49
 
2.0%
32 48
 
1.9%
22 46
 
1.9%
24 44
 
1.8%
29 42
 
1.7%
20 41
 
1.7%
25 41
 
1.7%
26 39
 
1.6%
31 38
 
1.5%
15 37
 
1.5%
Other values (508) 2045
82.8%
ValueCountFrequency (%)
1 1
 
< 0.1%
2 4
 
0.2%
3 2
 
0.1%
4 3
 
0.1%
5 4
 
0.2%
6 8
 
0.3%
7 10
 
0.4%
8 12
0.5%
9 17
0.7%
10 27
1.1%
ValueCountFrequency (%)
34102 1
< 0.1%
12859 1
< 0.1%
12640 1
< 0.1%
12580 1
< 0.1%
10386 1
< 0.1%
10044 1
< 0.1%
9797 1
< 0.1%
8693 1
< 0.1%
8661 1
< 0.1%
8480 1
< 0.1%

Interactions

2023-12-13T02:35:57.416687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:35:57.089065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:35:57.516836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:35:57.253190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T02:36:01.421520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번분야성별연령대시군구조회수
순번1.0000.3130.2010.2450.2760.102
분야0.3131.0000.0630.2330.1850.000
성별0.2010.0631.0000.1140.1040.025
연령대0.2450.2330.1141.0000.3020.000
시군구0.2760.1850.1040.3021.0000.000
조회수0.1020.0000.0250.0000.0001.000
2023-12-13T02:36:01.549554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
분야성별시군구연령대
분야1.0000.0670.1110.117
성별0.0671.0000.0750.109
시군구0.1110.0751.0000.164
연령대0.1170.1090.1641.000
2023-12-13T02:36:01.669440image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번조회수분야성별연령대시군구
순번1.0000.0800.1640.1540.1070.149
조회수0.0801.0000.0000.0170.0000.000
분야0.1640.0001.0000.0670.1170.111
성별0.1540.0170.0671.0000.1090.075
연령대0.1070.0000.1170.1091.0000.164
시군구0.1490.0000.1110.0750.1641.000

Missing values

2023-12-13T02:35:57.695307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T02:35:57.891201image/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

순번분야제목성별연령대시군구등록일조회수
02470도시재생교통건설일신방직터 복합쇼핑몰 공공기여율 조정남성30대광산구2023-08-31114
12469일반행정정율성 공원보다 인프라 시설 확충이 먼저입니다.<NA><NA>기타2023-08-319
22468문화관광체육홍범도장군님의 흉상을 민주성지 광주에 유치해주시기 바랍니다.남성50대광산구2023-08-316
32467도시재생교통건설신속한 복합쇼핑몰 유치 및 지하철 3,4 호선 추가 공사 진행<NA><NA>기타2023-08-31397
42466일반행정우리 광주시민과 시민단체, 상인단체랑 토론했음 합니다.<NA><NA>기타2023-08-30561
52465도시재생교통건설일신방직터 공공기여 적당히 40~50% 비율로 했음 합니다. 그리고 부지 먹튀 방지와 이외 요소들의 안전장치가 있으면 합니다.<NA><NA>기타2023-08-29899
62464도시재생교통건설서구 광천동 하이엔드 아파트 용적률 제고 방안 및 기억의 공간 조성남성20대서구2023-08-2931
72463문화관광체육자전거 도로 정비<NA><NA>기타2023-08-2914
82462문화관광체육정율성 공원 추진 없었으면 합니다.<NA><NA>기타2023-08-2935
92461문화관광체육광주월드컵경기장 개방을 제안합니다.남성30대기타2023-08-2830
순번분야제목성별연령대시군구등록일조회수
246010일자리경제여성들의 취업<NA><NA>기타2019-03-2026
24619도시재생교통건설광주시 통계, 알림(?) 광고(?) 홍보(?) 하여튼 그런 전광판 설치남성30대기타2019-03-2045
24628복지환경길거리 담배<NA><NA>기타2019-03-2059
24637일반행정"광주전남 시민-도민 함께소통"을 제안합니다<NA><NA>기타2019-03-20483
24646일반행정바로소통 광주 응원합니다..<NA><NA>기타2019-03-20146
24655도시재생교통건설골목길 안심 CCTV 확대 설치 건의드립니다!남성20대북구2019-03-20834
24664복지환경붐비는 전철역 통행로에 노인일자리 어르신들께 우측보행을 할 수 있도록 어깨띠 착용을 제안 합니다.남성<NA>기타2019-03-2040
24673도시재생교통건설매연뿜는 과적.노후차량 단속위해 언덕길 전.후방카메라 설치제안 합니다.남성20대동구2019-03-2062
24682일자리경제노인일자리 확대<NA><NA>기타2019-03-2039
24691일반행정공원에서의 반려견 관련남성30대동구2019-03-20236