Overview

Dataset statistics

Number of variables3
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows1966
Duplicate rows (%)19.7%
Total size in memory312.5 KiB
Average record size in memory32.0 B

Variable types

DateTime2
Text1

Dataset

Description전라남도 나주시 관내 불법주정차 단속내역(단속일자, 단속위치 등) 정보를 제공하며단속기간은 2023년 1월 1일부터 12월 31일까지입니다.
Author전라남도 나주시
URLhttps://www.data.go.kr/data/15111783/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
Dataset has 1966 (19.7%) duplicate rowsDuplicates

Reproduction

Analysis started2024-03-14 16:38:56.607086
Analysis finished2024-03-14 16:38:57.299742
Duration0.69 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

위반일자
Date

Distinct364
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-01-01 00:00:00
Maximum2023-12-31 00:00:00
2024-03-15T01:38:57.739966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T01:38:58.056776image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

위반장소명
Text

Distinct682
Distinct (%)6.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-03-15T01:38:59.172062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length17
Mean length7.8293
Min length3

Characters and Unicode

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

Unique

Unique398 ?
Unique (%)4.0%

Sample

1st row증흥 1차 아파트
2nd row빛가람동196-1 황색복선
3rd row(구)광주은행
4th row나주초등학교
5th rowKDN사거리
ValueCountFrequency (%)
도원빌딩앞 836
 
5.1%
kdn사거리 737
 
4.5%
빛가람동 698
 
4.3%
증흥 678
 
4.2%
아파트 678
 
4.2%
횡단보도 655
 
4.0%
나주터미널 516
 
3.2%
1차 467
 
2.9%
영산포초등학교 427
 
2.6%
중앙로 407
 
2.5%
Other values (451) 10164
62.5%
2024-03-15T01:39:00.564811image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6263
 
8.0%
동 3120
 
4.0%
빛 2425
 
3.1%
가 2333
 
3.0%
람 2333
 
3.0%
주 2080
 
2.7%
1 2047
 
2.6%
도 1585
 
2.0%
리 1537
 
2.0%
교 1492
 
1.9%
Other values (140) 53078
67.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 60674
77.5%
Decimal Number 7674
 
9.8%
Space Separator 6263
 
8.0%
Uppercase Letter 2211
 
2.8%
Dash Punctuation 651
 
0.8%
Close Punctuation 524
 
0.7%
Open Punctuation 296
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 3120
 
5.1%
빛 2425
 
4.0%
가 2333
 
3.8%
람 2333
 
3.8%
주 2080
 
3.4%
도 1585
 
2.6%
리 1537
 
2.5%
교 1492
 
2.5%
사 1345
 
2.2%
등 1320
 
2.2%
Other values (123) 41104
67.7%
Decimal Number
ValueCountFrequency (%)
1 2047
26.7%
2 1030
13.4%
3 823
10.7%
6 822
10.7%
9 806
 
10.5%
4 715
 
9.3%
0 501
 
6.5%
8 381
 
5.0%
5 330
 
4.3%
7 219
 
2.9%
Uppercase Letter
ValueCountFrequency (%)
K 737
33.3%
D 737
33.3%
N 737
33.3%
Space Separator
ValueCountFrequency (%)
6263
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 651
100.0%
Close Punctuation
ValueCountFrequency (%)
) 524
100.0%
Open Punctuation
ValueCountFrequency (%)
( 296
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 60674
77.5%
Common 15408
 
19.7%
Latin 2211
 
2.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 3120
 
5.1%
빛 2425
 
4.0%
가 2333
 
3.8%
람 2333
 
3.8%
주 2080
 
3.4%
도 1585
 
2.6%
리 1537
 
2.5%
교 1492
 
2.5%
사 1345
 
2.2%
등 1320
 
2.2%
Other values (123) 41104
67.7%
Common
ValueCountFrequency (%)
6263
40.6%
1 2047
 
13.3%
2 1030
 
6.7%
3 823
 
5.3%
6 822
 
5.3%
9 806
 
5.2%
4 715
 
4.6%
- 651
 
4.2%
) 524
 
3.4%
0 501
 
3.3%
Other values (4) 1226
 
8.0%
Latin
ValueCountFrequency (%)
K 737
33.3%
D 737
33.3%
N 737
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 60674
77.5%
ASCII 17619
 
22.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6263
35.5%
1 2047
 
11.6%
2 1030
 
5.8%
3 823
 
4.7%
6 822
 
4.7%
9 806
 
4.6%
K 737
 
4.2%
D 737
 
4.2%
N 737
 
4.2%
4 715
 
4.1%
Other values (7) 2902
16.5%
Hangul
ValueCountFrequency (%)
동 3120
 
5.1%
빛 2425
 
4.0%
가 2333
 
3.8%
람 2333
 
3.8%
주 2080
 
3.4%
도 1585
 
2.6%
리 1537
 
2.5%
교 1492
 
2.5%
사 1345
 
2.2%
등 1320
 
2.2%
Other values (123) 41104
67.7%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2024-02-08 00:00:00
Maximum2024-02-08 00:00:00
2024-03-15T01:39:00.755364image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T01:39:01.060094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2024-03-15T01:38:56.919724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T01:38:57.178728image/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

위반일자위반장소명데이터기준일자
15072023-01-13증흥 1차 아파트2024-02-08
235942023-10-12빛가람동196-1 황색복선2024-02-08
229092023-09-30(구)광주은행2024-02-08
123882023-05-01나주초등학교2024-02-08
42982023-02-13KDN사거리2024-02-08
149682023-06-02KDN사거리2024-02-08
17362023-01-15구)금성파출소 앞2024-02-08
67842023-03-03공산면 홀짝제2024-02-08
118552023-04-22도원빌딩앞2024-02-08
218062023-09-13빛가람 주민센터2024-02-08
위반일자위반장소명데이터기준일자
89522023-03-21빛가람동 중야2길2024-02-08
50262023-02-18빛가람동345 불법주정차2024-02-08
236432023-10-13빛가람동344 소화전2024-02-08
126012023-05-04금성관2024-02-08
28752023-01-28(구)광주은행2024-02-08
42432023-02-13나주터미널2024-02-08
250492023-11-06KDN사거리2024-02-08
172112023-07-04대호동1061 황색복선2024-02-08
170942023-07-03빛가람동196 교차로모퉁이2024-02-08
10482023-01-09(구)광주은행2024-02-08

Duplicate rows

Most frequently occurring

위반일자위반장소명데이터기준일자# duplicates
162023-01-02영산포초등학교2024-02-0819
8892023-04-26빛가람동 중야2길2024-02-0816
1302023-01-16빛가람동 상야1길2024-02-0815
1722023-01-19영산포초등학교2024-02-0815
12402023-06-28빛가람동 중야2길2024-02-0815
12672023-07-03빛가람동 상야1길2024-02-0815
1372023-01-16영산포초등학교2024-02-0814
13172023-07-14빛가람동 상야1길2024-02-0814
272023-01-03영산포초등학교2024-02-0813
3432023-02-16나주초등학교2024-02-0813