Overview

Dataset statistics

Number of variables7
Number of observations48
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.8 KiB
Average record size in memory60.7 B

Variable types

Text3
Numeric2
Categorical1
DateTime1

Dataset

Description충청북도 충주시의 교통관제 CCTV 정보(관리번호, 소재지 지번주소, 설치위치명, 위도, 경도, 관리기관, 데이터 기준일자)
Author충청북도 충주시
URLhttps://www.data.go.kr/data/15042001/fileData.do

Alerts

관리기관 has constant value ""Constant
데이터기준일자 has constant value ""Constant
관리번호 has unique valuesUnique

Reproduction

Analysis started2024-03-14 23:27:20.980355
Analysis finished2024-03-14 23:27:22.610757
Duration1.63 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리번호
Text

UNIQUE 

Distinct48
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size512.0 B
2024-03-15T08:27:23.339840image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

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

Unique

Unique48 ?
Unique (%)100.0%

Sample

1st rowCCTV-교-001
2nd rowCCTV-교-002
3rd rowCCTV-교-003
4th rowCCTV-교-004
5th rowCCTV-교-005
ValueCountFrequency (%)
cctv-교-001 1
 
2.1%
cctv-교-002 1
 
2.1%
cctv-교-036 1
 
2.1%
cctv-교-027 1
 
2.1%
cctv-교-028 1
 
2.1%
cctv-교-029 1
 
2.1%
cctv-교-030 1
 
2.1%
cctv-교-031 1
 
2.1%
cctv-교-032 1
 
2.1%
cctv-교-033 1
 
2.1%
Other values (38) 38
79.2%
2024-03-15T08:27:24.650731image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
C 96
20.0%
- 96
20.0%
0 61
12.7%
T 48
10.0%
V 48
10.0%
교 48
10.0%
1 15
 
3.1%
2 15
 
3.1%
3 15
 
3.1%
4 14
 
2.9%
Other values (5) 24
 
5.0%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 192
40.0%
Decimal Number 144
30.0%
Dash Punctuation 96
20.0%
Other Letter 48
 
10.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 61
42.4%
1 15
 
10.4%
2 15
 
10.4%
3 15
 
10.4%
4 14
 
9.7%
5 5
 
3.5%
6 5
 
3.5%
7 5
 
3.5%
8 5
 
3.5%
9 4
 
2.8%
Uppercase Letter
ValueCountFrequency (%)
C 96
50.0%
T 48
25.0%
V 48
25.0%
Dash Punctuation
ValueCountFrequency (%)
- 96
100.0%
Other Letter
ValueCountFrequency (%)
교 48
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 240
50.0%
Latin 192
40.0%
Hangul 48
 
10.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 96
40.0%
0 61
25.4%
1 15
 
6.2%
2 15
 
6.2%
3 15
 
6.2%
4 14
 
5.8%
5 5
 
2.1%
6 5
 
2.1%
7 5
 
2.1%
8 5
 
2.1%
Latin
ValueCountFrequency (%)
C 96
50.0%
T 48
25.0%
V 48
25.0%
Hangul
ValueCountFrequency (%)
교 48
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 432
90.0%
Hangul 48
 
10.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
C 96
22.2%
- 96
22.2%
0 61
14.1%
T 48
11.1%
V 48
11.1%
1 15
 
3.5%
2 15
 
3.5%
3 15
 
3.5%
4 14
 
3.2%
5 5
 
1.2%
Other values (4) 19
 
4.4%
Hangul
ValueCountFrequency (%)
교 48
100.0%

소재지지번주소
Text

Distinct47
Distinct (%)97.9%
Missing0
Missing (%)0.0%
Memory size512.0 B
2024-03-15T08:27:25.520226image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length18
Mean length15.354167
Min length10

Characters and Unicode

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

Unique

Unique46 ?
Unique (%)95.8%

Sample

1st row충주시 성서동 295번지
2nd row충주시 풍동 118번지
3rd row충주시 살미면 용천리 429-4번지
4th row충주시 호암동 558-18번지
5th row충주시 칠금동 551-1번지
ValueCountFrequency (%)
충주시 49
30.1%
연수동 6
 
3.7%
주덕읍 5
 
3.1%
대소원면 5
 
3.1%
화곡리 4
 
2.5%
칠금동 4
 
2.5%
교현동 3
 
1.8%
안림동 3
 
1.8%
용전리 3
 
1.8%
중앙탑면 3
 
1.8%
Other values (69) 78
47.9%
2024-03-15T08:27:26.788822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
115
15.6%
주 54
 
7.3%
1 51
 
6.9%
충 49
 
6.6%
시 49
 
6.6%
지 33
 
4.5%
번 33
 
4.5%
동 31
 
4.2%
- 23
 
3.1%
2 21
 
2.8%
Other values (59) 278
37.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 417
56.6%
Decimal Number 182
24.7%
Space Separator 115
 
15.6%
Dash Punctuation 23
 
3.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 54
12.9%
충 49
 
11.8%
시 49
 
11.8%
지 33
 
7.9%
번 33
 
7.9%
동 31
 
7.4%
리 18
 
4.3%
면 13
 
3.1%
금 6
 
1.4%
대 6
 
1.4%
Other values (47) 125
30.0%
Decimal Number
ValueCountFrequency (%)
1 51
28.0%
2 21
11.5%
5 19
 
10.4%
8 18
 
9.9%
7 14
 
7.7%
9 13
 
7.1%
0 13
 
7.1%
4 13
 
7.1%
3 10
 
5.5%
6 10
 
5.5%
Space Separator
ValueCountFrequency (%)
115
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 23
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 417
56.6%
Common 320
43.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 54
12.9%
충 49
 
11.8%
시 49
 
11.8%
지 33
 
7.9%
번 33
 
7.9%
동 31
 
7.4%
리 18
 
4.3%
면 13
 
3.1%
금 6
 
1.4%
대 6
 
1.4%
Other values (47) 125
30.0%
Common
ValueCountFrequency (%)
115
35.9%
1 51
15.9%
- 23
 
7.2%
2 21
 
6.6%
5 19
 
5.9%
8 18
 
5.6%
7 14
 
4.4%
9 13
 
4.1%
0 13
 
4.1%
4 13
 
4.1%
Other values (2) 20
 
6.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 417
56.6%
ASCII 320
43.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
115
35.9%
1 51
15.9%
- 23
 
7.2%
2 21
 
6.6%
5 19
 
5.9%
8 18
 
5.6%
7 14
 
4.4%
9 13
 
4.1%
0 13
 
4.1%
4 13
 
4.1%
Other values (2) 20
 
6.2%
Hangul
ValueCountFrequency (%)
주 54
12.9%
충 49
 
11.8%
시 49
 
11.8%
지 33
 
7.9%
번 33
 
7.9%
동 31
 
7.4%
리 18
 
4.3%
면 13
 
3.1%
금 6
 
1.4%
대 6
 
1.4%
Other values (47) 125
30.0%

설치위치명
Text

Distinct46
Distinct (%)95.8%
Missing0
Missing (%)0.0%
Memory size512.0 B
2024-03-15T08:27:27.633016image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length6.2916667
Min length2

Characters and Unicode

Total characters302
Distinct characters104
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

Unique44 ?
Unique (%)91.7%

Sample

1st row제1로터리
2nd row풍동IC
3rd row수안보휴게소
4th row호암사거리
5th row칠금사거리
ValueCountFrequency (%)
기업도시3로 3
 
5.3%
안림사거리 2
 
3.5%
유한킴벌리 2
 
3.5%
임광사거리 2
 
3.5%
기업도시로 2
 
3.5%
사거리 2
 
3.5%
호수사거리 1
 
1.8%
무술공원앞삼거리 1
 
1.8%
코이즈 1
 
1.8%
제1로터리 1
 
1.8%
Other values (40) 40
70.2%
2024-03-15T08:27:29.067629image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
리 34
 
11.3%
거 29
 
9.6%
사 27
 
8.9%
로 10
 
3.3%
9
 
3.0%
도 6
 
2.0%
기 6
 
2.0%
시 6
 
2.0%
업 6
 
2.0%
원 5
 
1.7%
Other values (94) 164
54.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 272
90.1%
Uppercase Letter 11
 
3.6%
Space Separator 9
 
3.0%
Decimal Number 7
 
2.3%
Close Punctuation 1
 
0.3%
Open Punctuation 1
 
0.3%
Math Symbol 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
리 34
 
12.5%
거 29
 
10.7%
사 27
 
9.9%
로 10
 
3.7%
도 6
 
2.2%
기 6
 
2.2%
시 6
 
2.2%
업 6
 
2.2%
원 5
 
1.8%
교 5
 
1.8%
Other values (82) 138
50.7%
Uppercase Letter
ValueCountFrequency (%)
A 3
27.3%
C 2
18.2%
P 2
18.2%
T 2
18.2%
I 2
18.2%
Decimal Number
ValueCountFrequency (%)
1 3
42.9%
3 3
42.9%
4 1
 
14.3%
Space Separator
ValueCountFrequency (%)
9
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Math Symbol
ValueCountFrequency (%)
→ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 272
90.1%
Common 19
 
6.3%
Latin 11
 
3.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
리 34
 
12.5%
거 29
 
10.7%
사 27
 
9.9%
로 10
 
3.7%
도 6
 
2.2%
기 6
 
2.2%
시 6
 
2.2%
업 6
 
2.2%
원 5
 
1.8%
교 5
 
1.8%
Other values (82) 138
50.7%
Common
ValueCountFrequency (%)
9
47.4%
1 3
 
15.8%
3 3
 
15.8%
) 1
 
5.3%
( 1
 
5.3%
→ 1
 
5.3%
4 1
 
5.3%
Latin
ValueCountFrequency (%)
A 3
27.3%
C 2
18.2%
P 2
18.2%
T 2
18.2%
I 2
18.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 272
90.1%
ASCII 29
 
9.6%
Arrows 1
 
0.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
리 34
 
12.5%
거 29
 
10.7%
사 27
 
9.9%
로 10
 
3.7%
도 6
 
2.2%
기 6
 
2.2%
시 6
 
2.2%
업 6
 
2.2%
원 5
 
1.8%
교 5
 
1.8%
Other values (82) 138
50.7%
ASCII
ValueCountFrequency (%)
9
31.0%
1 3
 
10.3%
A 3
 
10.3%
3 3
 
10.3%
C 2
 
6.9%
P 2
 
6.9%
T 2
 
6.9%
I 2
 
6.9%
) 1
 
3.4%
( 1
 
3.4%
Arrows
ValueCountFrequency (%)
→ 1
100.0%

위도
Real number (ℝ)

Distinct47
Distinct (%)97.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean36.987874
Minimum36.8976
Maximum37.080908
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size560.0 B
2024-03-15T08:27:29.575108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum36.8976
5-th percentile36.958548
Q136.971643
median36.982602
Q337.003382
95-th percentile37.03372
Maximum37.080908
Range0.1833078
Interquartile range (IQR)0.031739575

Descriptive statistics

Standard deviation0.030064967
Coefficient of variation (CV)0.00081283307
Kurtosis3.1781618
Mean36.987874
Median Absolute Deviation (MAD)0.01340885
Skewness0.58645276
Sum1775.418
Variance0.00090390227
MonotonicityNot monotonic
2024-03-15T08:27:30.217016image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=47)
ValueCountFrequency (%)
36.9873352 2
 
4.2%
36.9723188 1
 
2.1%
36.9362602 1
 
2.1%
37.0115216 1
 
2.1%
37.0809076 1
 
2.1%
36.9759935 1
 
2.1%
36.9618448 1
 
2.1%
37.0381652 1
 
2.1%
36.9861322 1
 
2.1%
36.9876259 1
 
2.1%
Other values (37) 37
77.1%
ValueCountFrequency (%)
36.8975998 1
2.1%
36.9362602 1
2.1%
36.9576028 1
2.1%
36.960304 1
2.1%
36.9618448 1
2.1%
36.9663539 1
2.1%
36.9671831 1
2.1%
36.9680708 1
2.1%
36.9691806 1
2.1%
36.9692064 1
2.1%
ValueCountFrequency (%)
37.0809076 1
2.1%
37.0728816 1
2.1%
37.0381652 1
2.1%
37.025464 1
2.1%
37.020991 1
2.1%
37.0176882 1
2.1%
37.0121908 1
2.1%
37.0115248 1
2.1%
37.0115216 1
2.1%
37.0066985 1
2.1%

경도
Real number (ℝ)

Distinct47
Distinct (%)97.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.90081
Minimum127.79248
Maximum127.97729
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size560.0 B
2024-03-15T08:27:30.774709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.79248
5-th percentile127.81644
Q1127.84909
median127.92287
Q3127.93233
95-th percentile127.95122
Maximum127.97729
Range0.1848102
Interquartile range (IQR)0.083237475

Descriptive statistics

Standard deviation0.049274433
Coefficient of variation (CV)0.00038525504
Kurtosis-0.73633362
Mean127.90081
Median Absolute Deviation (MAD)0.0162511
Skewness-0.83282517
Sum6139.239
Variance0.0024279698
MonotonicityNot monotonic
2024-03-15T08:27:31.306758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=47)
ValueCountFrequency (%)
127.9285094 2
 
4.2%
127.9330595 1
 
2.1%
127.9245624 1
 
2.1%
127.9156004 1
 
2.1%
127.9535847 1
 
2.1%
127.7924808 1
 
2.1%
127.8815854 1
 
2.1%
127.9277828 1
 
2.1%
127.9039782 1
 
2.1%
127.917774 1
 
2.1%
Other values (37) 37
77.1%
ValueCountFrequency (%)
127.7924808 1
2.1%
127.8149576 1
2.1%
127.8155948 1
2.1%
127.8180006 1
2.1%
127.8183012 1
2.1%
127.822588 1
2.1%
127.8261866 1
2.1%
127.8302759 1
2.1%
127.8311652 1
2.1%
127.8329673 1
2.1%
ValueCountFrequency (%)
127.977291 1
2.1%
127.9630845 1
2.1%
127.9535847 1
2.1%
127.9468389 1
2.1%
127.9466603 1
2.1%
127.9457739 1
2.1%
127.940401 1
2.1%
127.9398351 1
2.1%
127.9393191 1
2.1%
127.9382826 1
2.1%

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Memory size512.0 B
충청북도 충주시청 교통정책과
48 

Length

Max length15
Median length15
Mean length15
Min length15

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row충청북도 충주시청 교통정책과
2nd row충청북도 충주시청 교통정책과
3rd row충청북도 충주시청 교통정책과
4th row충청북도 충주시청 교통정책과
5th row충청북도 충주시청 교통정책과

Common Values

ValueCountFrequency (%)
충청북도 충주시청 교통정책과 48
100.0%

Length

2024-03-15T08:27:31.850813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T08:27:32.273826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
충청북도 48
33.3%
충주시청 48
33.3%
교통정책과 48
33.3%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Memory size512.0 B
Minimum2024-01-01 00:00:00
Maximum2024-01-01 00:00:00
2024-03-15T08:27:32.580224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T08:27:32.818351image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-03-15T08:27:21.717745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T08:27:21.384688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T08:27:21.886618image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T08:27:21.549506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T08:27:33.024200image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리번호소재지지번주소설치위치명위도경도
관리번호1.0001.0001.0001.0001.000
소재지지번주소1.0001.0001.0001.0001.000
설치위치명1.0001.0001.0001.0001.000
위도1.0001.0001.0001.0000.341
경도1.0001.0001.0000.3411.000
2024-03-15T08:27:33.280759image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.000-0.287
경도-0.2871.000

Missing values

2024-03-15T08:27:22.102423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T08:27:22.420259image/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

관리번호소재지지번주소설치위치명위도경도관리기관데이터기준일자
0CCTV-교-001충주시 성서동 295번지제1로터리36.972319127.933059충청북도 충주시청 교통정책과2024-01-01
1CCTV-교-002충주시 풍동 118번지풍동IC36.93626127.924562충청북도 충주시청 교통정책과2024-01-01
2CCTV-교-003충주시 살미면 용천리 429-4번지수안보휴게소36.8976127.977291충청북도 충주시청 교통정책과2024-01-01
3CCTV-교-004충주시 호암동 558-18번지호암사거리36.960304127.926437충청북도 충주시청 교통정책과2024-01-01
4CCTV-교-005충주시 칠금동 551-1번지칠금사거리36.981093127.913137충청북도 충주시청 교통정책과2024-01-01
5CCTV-교-006충주시 교현동 1114번지법원사거리36.982166127.928402충청북도 충주시청 교통정책과2024-01-01
6CCTV-교-007충주시 연수동 1711번지유원 APT사거리36.982246127.939835충청북도 충주시청 교통정책과2024-01-01
7CCTV-교-008충주시 산척면 영덕리 1528-3번지영덕사거리37.072882127.932084충청북도 충주시청 교통정책과2024-01-01
8CCTV-교-009충주시 동량면 용교리 391-1번지공군삼거리37.025464127.922754충청북도 충주시청 교통정책과2024-01-01
9CCTV-교-010충주시 문화동 572번지문화사거리36.972864127.922979충청북도 충주시청 교통정책과2024-01-01
관리번호소재지지번주소설치위치명위도경도관리기관데이터기준일자
38CCTV-교-039충주시 봉방동 86-1봉계사거리36.978394127.918089충청북도 충주시청 교통정책과2024-01-01
39CCTV-교-040충주시 교현동 665대가미사거리36.978219127.928093충청북도 충주시청 교통정책과2024-01-01
40CCTV-교-041충주시 봉방동 13-2삼원로터리사거리36.974968127.924581충청북도 충주시청 교통정책과2024-01-01
41CCTV-교-042충주시 달천동 51-2사과나무사거리36.969206127.913494충청북도 충주시청 교통정책과2024-01-01
42CCTV-교-043충주시 문화동 2653-1호수사거리36.967183127.923611충청북도 충주시청 교통정책과2024-01-01
43CCTV-교-044충주시 교현동 257-1동촌사거리36.969181127.938283충청북도 충주시청 교통정책과2024-01-01
44CCTV-교-045충주시 주덕읍 화곡리 1244화곡교차로37.006698127.818001충청북도 충주시청 교통정책과2024-01-01
45CCTV-교-046충주시 대소원면 완오리 1101유한킴벌리 사거리36.99915127.841863충청북도 충주시청 교통정책과2024-01-01
46CCTV-교-047충주시 대소원면 본리 1102코이즈 앞 사거리36.985285127.831165충청북도 충주시청 교통정책과2024-01-01
47CCTV-교-048충주시 충주시 연수동 1204번지임광사거리36.987335127.928509충청북도 충주시청 교통정책과2024-01-01