Overview

Dataset statistics

Number of variables6
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory546.9 KiB
Average record size in memory56.0 B

Variable types

Numeric1
Categorical2
Text1
DateTime2

Dataset

Description2022년 ~ 2023년 광주광역시 광산구 행정동별 불법주정차 단속건수에 대한 데이터로 연번, 단속동(행정동), 단속장소, 단속일시, 관리부서, 데이터기준일자 등의 항목을 제공합니다
Author광주광역시 광산구
URLhttps://www.data.go.kr/data/15125138/fileData.do

Alerts

관리부서 has constant value ""Constant
데이터기준일자 has constant value ""Constant
연번 is highly overall correlated with 단속동High correlation
단속동 is highly overall correlated with 연번High correlation
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 21:21:27.918959
Analysis finished2023-12-12 21:22:56.233923
Duration1 minute and 28.31 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean47908.269
Minimum11
Maximum95271
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T06:22:56.327430image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum11
5-th percentile4697.8
Q123926
median48270
Q371989.25
95-th percentile90875.15
Maximum95271
Range95260
Interquartile range (IQR)48063.25

Descriptive statistics

Standard deviation27712.398
Coefficient of variation (CV)0.57844708
Kurtosis-1.2098741
Mean47908.269
Median Absolute Deviation (MAD)24050.5
Skewness-0.010514691
Sum4.7908269 × 108
Variance7.67977 × 108
MonotonicityNot monotonic
2023-12-13T06:22:56.495173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
49814 1
 
< 0.1%
89914 1
 
< 0.1%
40081 1
 
< 0.1%
62048 1
 
< 0.1%
69855 1
 
< 0.1%
77672 1
 
< 0.1%
1077 1
 
< 0.1%
68696 1
 
< 0.1%
7547 1
 
< 0.1%
61305 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
11 1
< 0.1%
15 1
< 0.1%
18 1
< 0.1%
54 1
< 0.1%
69 1
< 0.1%
79 1
< 0.1%
80 1
< 0.1%
83 1
< 0.1%
92 1
< 0.1%
101 1
< 0.1%
ValueCountFrequency (%)
95271 1
< 0.1%
95248 1
< 0.1%
95233 1
< 0.1%
95222 1
< 0.1%
95219 1
< 0.1%
95215 1
< 0.1%
95212 1
< 0.1%
95200 1
< 0.1%
95170 1
< 0.1%
95166 1
< 0.1%

단속동
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
송정동
6558 
수완동
2488 
비아동
 
566
도산동
 
345
동곡동
 
35

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row송정동
2nd row수완동
3rd row송정동
4th row수완동
5th row송정동

Common Values

ValueCountFrequency (%)
송정동 6558
65.6%
수완동 2488
 
24.9%
비아동 566
 
5.7%
도산동 345
 
3.5%
동곡동 35
 
0.4%
삼도동 8
 
0.1%

Length

2023-12-13T06:22:56.641540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:22:56.754296image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
송정동 6558
65.6%
수완동 2488
 
24.9%
비아동 566
 
5.7%
도산동 345
 
3.5%
동곡동 35
 
0.4%
삼도동 8
 
0.1%

단속장소
Text

Distinct719
Distinct (%)7.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-13T06:22:57.000151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length13
Mean length8.6612
Min length4

Characters and Unicode

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

Unique

Unique392 ?
Unique (%)3.9%

Sample

1st row송정로 부근
2nd row풍영로200번길 부근
3rd row1913송정역시장
4th row1767 부근
5th row송도로 부근
ValueCountFrequency (%)
부근 2033
 
11.3%
송정역 1448
 
8.1%
송정역앞삼거리 968
 
5.4%
승차장 862
 
4.8%
새빛콜 862
 
4.8%
사거리 639
 
3.6%
승강장 586
 
3.3%
주변 499
 
2.8%
송정동 403
 
2.2%
광주송정역 379
 
2.1%
Other values (688) 9237
51.6%
2023-12-13T06:22:57.407502image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
7916
 
9.1%
정 4868
 
5.6%
송 4350
 
5.0%
1 3101
 
3.6%
역 2992
 
3.5%
장 2552
 
2.9%
근 2478
 
2.9%
부 2471
 
2.9%
거 2167
 
2.5%
리 2166
 
2.5%
Other values (147) 51551
59.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 67807
78.3%
Decimal Number 9896
 
11.4%
Space Separator 7916
 
9.1%
Dash Punctuation 660
 
0.8%
Uppercase Letter 333
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
정 4868
 
7.2%
송 4350
 
6.4%
역 2992
 
4.4%
장 2552
 
3.8%
근 2478
 
3.7%
부 2471
 
3.6%
거 2167
 
3.2%
리 2166
 
3.2%
로 2056
 
3.0%
동 1636
 
2.4%
Other values (132) 40071
59.1%
Decimal Number
ValueCountFrequency (%)
1 3101
31.3%
3 995
 
10.1%
0 961
 
9.7%
9 903
 
9.1%
2 870
 
8.8%
8 725
 
7.3%
7 686
 
6.9%
5 618
 
6.2%
4 580
 
5.9%
6 457
 
4.6%
Uppercase Letter
ValueCountFrequency (%)
W 187
56.2%
L 73
 
21.9%
G 73
 
21.9%
Space Separator
ValueCountFrequency (%)
7916
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 660
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 67807
78.3%
Common 18472
 
21.3%
Latin 333
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
정 4868
 
7.2%
송 4350
 
6.4%
역 2992
 
4.4%
장 2552
 
3.8%
근 2478
 
3.7%
부 2471
 
3.6%
거 2167
 
3.2%
리 2166
 
3.2%
로 2056
 
3.0%
동 1636
 
2.4%
Other values (132) 40071
59.1%
Common
ValueCountFrequency (%)
7916
42.9%
1 3101
 
16.8%
3 995
 
5.4%
0 961
 
5.2%
9 903
 
4.9%
2 870
 
4.7%
8 725
 
3.9%
7 686
 
3.7%
- 660
 
3.6%
5 618
 
3.3%
Other values (2) 1037
 
5.6%
Latin
ValueCountFrequency (%)
W 187
56.2%
L 73
 
21.9%
G 73
 
21.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 67807
78.3%
ASCII 18805
 
21.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
7916
42.1%
1 3101
 
16.5%
3 995
 
5.3%
0 961
 
5.1%
9 903
 
4.8%
2 870
 
4.6%
8 725
 
3.9%
7 686
 
3.6%
- 660
 
3.5%
5 618
 
3.3%
Other values (5) 1370
 
7.3%
Hangul
ValueCountFrequency (%)
정 4868
 
7.2%
송 4350
 
6.4%
역 2992
 
4.4%
장 2552
 
3.8%
근 2478
 
3.7%
부 2471
 
3.6%
거 2167
 
3.2%
리 2166
 
3.2%
로 2056
 
3.0%
동 1636
 
2.4%
Other values (132) 40071
59.1%

단속일시
Date

Distinct9568
Distinct (%)95.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2022-01-01 08:59:00
Maximum2023-10-31 19:22:00
2023-12-13T06:22:57.548898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:22:57.748469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

관리부서
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
광주광역시광산구교통지도과
10000 

Length

Max length13
Median length13
Mean length13
Min length13

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row광주광역시광산구교통지도과
2nd row광주광역시광산구교통지도과
3rd row광주광역시광산구교통지도과
4th row광주광역시광산구교통지도과
5th row광주광역시광산구교통지도과

Common Values

ValueCountFrequency (%)
광주광역시광산구교통지도과 10000
100.0%

Length

2023-12-13T06:22:57.901805image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:22:57.998039image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
광주광역시광산구교통지도과 10000
100.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-11-27 00:00:00
Maximum2023-11-27 00:00:00
2023-12-13T06:22:58.073055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:22:58.177979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T06:21:28.496745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T06:22:58.237630image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번단속동
연번1.0000.810
단속동0.8101.000
2023-12-13T06:22:58.316525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번단속동
연번1.0001.000
단속동1.0001.000

Missing values

2023-12-13T06:22:56.017451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T06:22:56.163613image/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

연번단속동단속장소단속일시관리부서데이터기준일자
4981349814송정동송정로 부근2023-03-03 14:34광주광역시광산구교통지도과2023-11-27
8747087471수완동풍영로200번길 부근2022-06-07 16:01광주광역시광산구교통지도과2023-11-27
3456134562송정동1913송정역시장2022-10-15 17:49광주광역시광산구교통지도과2023-11-27
7274872749수완동1767 부근2022-01-06 19:58광주광역시광산구교통지도과2023-11-27
6254262543송정동송도로 부근2023-07-12 10:08광주광역시광산구교통지도과2023-11-27
8000580006수완동장신로50번길 부근2022-03-30 10:15광주광역시광산구교통지도과2023-11-27
2656526566송정동송정로부근2022-08-08 19:12광주광역시광산구교통지도과2023-11-27
3430434305송정동광주송정역 버스정류장2022-10-13 15:58광주광역시광산구교통지도과2023-11-27
2386923870송정동평동로1119번길 부근2022-07-18 14:26광주광역시광산구교통지도과2023-11-27
3521135212송정동떡갈비 골목 사거리2022-10-20 16:05광주광역시광산구교통지도과2023-11-27
연번단속동단속장소단속일시관리부서데이터기준일자
16351636도산동814-1 부근2022-12-03 12:59광주광역시광산구교통지도과2023-11-27
2887428875송정동송정로부근2022-08-29 08:57광주광역시광산구교통지도과2023-11-27
4508045081송정동극동마이다스빌 주변2023-01-12 11:58광주광역시광산구교통지도과2023-11-27
1694516946송정동송정역앞삼거리2022-05-19 13:51광주광역시광산구교통지도과2023-11-27
6579465795송정동송정로부근2023-08-11 21:28광주광역시광산구교통지도과2023-11-27
6215862159송정동송정1동 행정복지센터2023-07-08 08:02광주광역시광산구교통지도과2023-11-27
6707067071송정동송정역 승강장2023-08-27 20:53광주광역시광산구교통지도과2023-11-27
6942469425송정동송정역 승강장2023-09-26 18:44광주광역시광산구교통지도과2023-11-27
6639966400송정동떡갈비 골목 사거리2023-08-18 20:10광주광역시광산구교통지도과2023-11-27
8315883159수완동휴먼시아7단지앞사거리2022-04-29 17:31광주광역시광산구교통지도과2023-11-27