Overview

Dataset statistics

Number of variables22
Number of observations42
Missing cells243
Missing cells (%)26.3%
Duplicate rows1
Duplicate rows (%)2.4%
Total size in memory7.3 KiB
Average record size in memory179.1 B

Variable types

Text4
Unsupported18

Dataset

Description당진시 관내 시도에 대한 교통량 조사 결과입니다.
Author충청남도 당진시
URLhttps://www.data.go.kr/data/15052040/fileData.do

Alerts

Dataset has 1 (2.4%) duplicate rowsDuplicates
시도(읍면시도) 교통량조사표(평균) has 39 (92.9%) missing valuesMissing
Unnamed: 1 has 40 (95.2%) missing valuesMissing
Unnamed: 2 has 22 (52.4%) missing valuesMissing
Unnamed: 3 has 3 (7.1%) missing valuesMissing
Unnamed: 4 has 3 (7.1%) missing valuesMissing
Unnamed: 5 has 2 (4.8%) missing valuesMissing
Unnamed: 6 has 2 (4.8%) missing valuesMissing
Unnamed: 7 has 2 (4.8%) missing valuesMissing
Unnamed: 8 has 2 (4.8%) missing valuesMissing
Unnamed: 9 has 2 (4.8%) missing valuesMissing
Unnamed: 10 has 2 (4.8%) missing valuesMissing
Unnamed: 11 has 3 (7.1%) missing valuesMissing
Unnamed: 12 has 2 (4.8%) missing valuesMissing
Unnamed: 13 has 1 (2.4%) missing valuesMissing
Unnamed: 14 has 2 (4.8%) missing valuesMissing
Unnamed: 15 has 2 (4.8%) missing valuesMissing
Unnamed: 16 has 3 (7.1%) missing valuesMissing
Unnamed: 17 has 3 (7.1%) missing valuesMissing
Unnamed: 18 has 23 (54.8%) missing valuesMissing
Unnamed: 19 has 23 (54.8%) missing valuesMissing
Unnamed: 20 has 22 (52.4%) missing valuesMissing
Unnamed: 21 has 40 (95.2%) missing valuesMissing
Unnamed: 3 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 4 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 5 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 6 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 7 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 9 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 11 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 12 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 13 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 14 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 15 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 16 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 17 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 18 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 19 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 20 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 03:13:46.849334
Analysis finished2023-12-12 03:13:47.044962
Duration0.2 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct3
Distinct (%)100.0%
Missing39
Missing (%)92.9%
Memory size468.0 B
2023-12-12T12:13:47.127711image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length3
Mean length4
Min length2

Characters and Unicode

Total characters12
Distinct characters11
Distinct categories5 ?
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 (%)100.0%

Sample

1st row[상행+하행]
2nd row도별
3rd row충 남
ValueCountFrequency (%)
상행+하행 1
25.0%
도별 1
25.0%
1
25.0%
1
25.0%
2023-12-12T12:13:47.427387image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2
16.7%
[ 1
8.3%
1
8.3%
+ 1
8.3%
1
8.3%
] 1
8.3%
1
8.3%
1
8.3%
1
8.3%
1
8.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 8
66.7%
Open Punctuation 1
 
8.3%
Math Symbol 1
 
8.3%
Close Punctuation 1
 
8.3%
Control 1
 
8.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
2
25.0%
1
12.5%
1
12.5%
1
12.5%
1
12.5%
1
12.5%
1
12.5%
Open Punctuation
ValueCountFrequency (%)
[ 1
100.0%
Math Symbol
ValueCountFrequency (%)
+ 1
100.0%
Close Punctuation
ValueCountFrequency (%)
] 1
100.0%
Control
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 8
66.7%
Common 4
33.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
2
25.0%
1
12.5%
1
12.5%
1
12.5%
1
12.5%
1
12.5%
1
12.5%
Common
ValueCountFrequency (%)
[ 1
25.0%
+ 1
25.0%
] 1
25.0%
1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 8
66.7%
ASCII 4
33.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
2
25.0%
1
12.5%
1
12.5%
1
12.5%
1
12.5%
1
12.5%
1
12.5%
ASCII
ValueCountFrequency (%)
[ 1
25.0%
+ 1
25.0%
] 1
25.0%
1
25.0%

Unnamed: 1
Text

MISSING 

Distinct2
Distinct (%)100.0%
Missing40
Missing (%)95.2%
Memory size468.0 B
2023-12-12T12:13:47.618529image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length5
Median length3.5
Mean length3.5
Min length2

Characters and Unicode

Total characters7
Distinct characters5
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

Unique2 ?
Unique (%)100.0%

Sample

1st row시군
2nd row당 진 시
ValueCountFrequency (%)
시군 1
25.0%
1
25.0%
1
25.0%
1
25.0%
2023-12-12T12:13:47.948062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2
28.6%
2
28.6%
1
14.3%
1
14.3%
1
14.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5
71.4%
Space Separator 2
 
28.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
2
40.0%
1
20.0%
1
20.0%
1
20.0%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5
71.4%
Common 2
 
28.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
2
40.0%
1
20.0%
1
20.0%
1
20.0%
Common
ValueCountFrequency (%)
2
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5
71.4%
ASCII 2
 
28.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
2
40.0%
1
20.0%
1
20.0%
1
20.0%
ASCII
ValueCountFrequency (%)
2
100.0%

Unnamed: 2
Text

MISSING 

Distinct20
Distinct (%)100.0%
Missing22
Missing (%)52.4%
Memory size468.0 B
2023-12-12T12:13:48.198971image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length8
Mean length7.4
Min length4

Characters and Unicode

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

Unique

Unique20 ?
Unique (%)100.0%

Sample

1st row지점번호
2nd row평균 (18지점)
3rd row34-15-1
4th row34-15-2
5th row34-15-3
ValueCountFrequency (%)
지점번호 1
 
4.8%
34-15-9 1
 
4.8%
34-15-17 1
 
4.8%
34-15-16 1
 
4.8%
34-15-15 1
 
4.8%
34-15-14 1
 
4.8%
34-15-13 1
 
4.8%
34-15-12 1
 
4.8%
34-15-11 1
 
4.8%
34-15-10 1
 
4.8%
Other values (11) 11
52.4%
2023-12-12T12:13:48.584400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 36
24.3%
1 30
20.3%
4 20
13.5%
5 20
13.5%
3 20
13.5%
8 3
 
2.0%
2
 
1.4%
7 2
 
1.4%
6 2
 
1.4%
2 2
 
1.4%
Other values (10) 11
 
7.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 101
68.2%
Dash Punctuation 36
 
24.3%
Other Letter 8
 
5.4%
Close Punctuation 1
 
0.7%
Open Punctuation 1
 
0.7%
Control 1
 
0.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 30
29.7%
4 20
19.8%
5 20
19.8%
3 20
19.8%
8 3
 
3.0%
7 2
 
2.0%
6 2
 
2.0%
2 2
 
2.0%
9 1
 
1.0%
0 1
 
1.0%
Other Letter
ValueCountFrequency (%)
2
25.0%
2
25.0%
1
12.5%
1
12.5%
1
12.5%
1
12.5%
Dash Punctuation
ValueCountFrequency (%)
- 36
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Control
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 140
94.6%
Hangul 8
 
5.4%

Most frequent character per script

Common
ValueCountFrequency (%)
- 36
25.7%
1 30
21.4%
4 20
14.3%
5 20
14.3%
3 20
14.3%
8 3
 
2.1%
7 2
 
1.4%
6 2
 
1.4%
2 2
 
1.4%
9 1
 
0.7%
Other values (4) 4
 
2.9%
Hangul
ValueCountFrequency (%)
2
25.0%
2
25.0%
1
12.5%
1
12.5%
1
12.5%
1
12.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 140
94.6%
Hangul 8
 
5.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 36
25.7%
1 30
21.4%
4 20
14.3%
5 20
14.3%
3 20
14.3%
8 3
 
2.1%
7 2
 
1.4%
6 2
 
1.4%
2 2
 
1.4%
9 1
 
0.7%
Other values (4) 4
 
2.9%
Hangul
ValueCountFrequency (%)
2
25.0%
2
25.0%
1
12.5%
1
12.5%
1
12.5%
1
12.5%

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)7.1%
Memory size468.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)7.1%
Memory size468.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)4.8%
Memory size468.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)4.8%
Memory size468.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)4.8%
Memory size468.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)4.8%
Memory size468.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)4.8%
Memory size468.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)4.8%
Memory size468.0 B

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)7.1%
Memory size468.0 B

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)4.8%
Memory size468.0 B

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)2.4%
Memory size468.0 B

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)4.8%
Memory size468.0 B

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)4.8%
Memory size468.0 B

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)7.1%
Memory size468.0 B

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)7.1%
Memory size468.0 B

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)54.8%
Memory size468.0 B

Unnamed: 19
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)54.8%
Memory size468.0 B

Unnamed: 20
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing22
Missing (%)52.4%
Memory size468.0 B

Unnamed: 21
Text

MISSING 

Distinct2
Distinct (%)100.0%
Missing40
Missing (%)95.2%
Memory size468.0 B
2023-12-12T12:13:48.837677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length19
Mean length19
Min length17

Characters and Unicode

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

Unique

Unique2 ?
Unique (%)100.0%

Sample

1st row증감사유 (20% 변동시 반드시 기재)
2nd row원룸주택단지조성 및 교통량 증가
ValueCountFrequency (%)
증감사유 1
11.1%
20 1
11.1%
변동시 1
11.1%
반드시 1
11.1%
기재 1
11.1%
원룸주택단지조성 1
11.1%
1
11.1%
교통량 1
11.1%
증가 1
11.1%
2023-12-12T12:13:49.244729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5
 
13.2%
2
 
5.3%
2
 
5.3%
2
 
5.3%
1
 
2.6%
1
 
2.6%
1
 
2.6%
1
 
2.6%
1
 
2.6%
1
 
2.6%
Other values (21) 21
55.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 26
68.4%
Space Separator 5
 
13.2%
Control 2
 
5.3%
Decimal Number 2
 
5.3%
Close Punctuation 1
 
2.6%
Other Punctuation 1
 
2.6%
Open Punctuation 1
 
2.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
2
 
7.7%
2
 
7.7%
1
 
3.8%
1
 
3.8%
1
 
3.8%
1
 
3.8%
1
 
3.8%
1
 
3.8%
1
 
3.8%
1
 
3.8%
Other values (14) 14
53.8%
Decimal Number
ValueCountFrequency (%)
0 1
50.0%
2 1
50.0%
Space Separator
ValueCountFrequency (%)
5
100.0%
Control
ValueCountFrequency (%)
2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Other Punctuation
ValueCountFrequency (%)
% 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 26
68.4%
Common 12
31.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
2
 
7.7%
2
 
7.7%
1
 
3.8%
1
 
3.8%
1
 
3.8%
1
 
3.8%
1
 
3.8%
1
 
3.8%
1
 
3.8%
1
 
3.8%
Other values (14) 14
53.8%
Common
ValueCountFrequency (%)
5
41.7%
2
 
16.7%
) 1
 
8.3%
% 1
 
8.3%
0 1
 
8.3%
2 1
 
8.3%
( 1
 
8.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 26
68.4%
ASCII 12
31.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5
41.7%
2
 
16.7%
) 1
 
8.3%
% 1
 
8.3%
0 1
 
8.3%
2 1
 
8.3%
( 1
 
8.3%
Hangul
ValueCountFrequency (%)
2
 
7.7%
2
 
7.7%
1
 
3.8%
1
 
3.8%
1
 
3.8%
1
 
3.8%
1
 
3.8%
1
 
3.8%
1
 
3.8%
1
 
3.8%
Other values (14) 14
53.8%

Sample

시도(읍면시도) 교통량조사표(평균)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21
0[상행+하행]<NA><NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<NA>
1도별시군지점번호시간2012\n교통량2013 교통량NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN도로\n상태차선수증감율\n(%)증감사유 (20% 변동시 반드시 기재)
2<NA><NA><NA>NaNNaN자동차\n계승용차버스소형트럭NaN중형트럭NaNNaN대형트럭NaNNaNNaNNaNNaNNaNNaN<NA>
3<NA><NA><NA>NaNNaNNaN1종2종3종4종5종6종7종8종9종10종11종12종NaNNaNNaN<NA>
4충 남당 진 시평균 (18지점)123096.5555563166.7222222322.33333353559.83333395.22222231.7777783537.7777783.8333331.22222218.2222224.54NaNNaN0.022358<NA>
5<NA><NA><NA>244139.7222224232.2777783212.16666764.388889687.888889112.61111135.61111141.542.5555564.5555561.38888919.8888895.3333334.388889NaNNaNNaN<NA>
6<NA><NA>34-15-1127790829062901361583129592744111910120.018224<NA>
7<NA><NA><NA>24107001089585001611926141622953121910NaNNaNNaN<NA>
8<NA><NA>34-15-212625755394242111906147302541012268120.027843<NA>
9<NA><NA><NA>247650786359661611291277304054012338NaNNaNNaN<NA>
시도(읍면시도) 교통량조사표(평균)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21
32<NA><NA>34-15-1412508617394107938150000000120.177673<NA>
33<NA><NA><NA>246367494991171099150000000NaNNaNNaN<NA>
34<NA><NA>34-15-1512138018161006376447723141500000120.196704<NA>
35<NA><NA><NA>24188122511320487339723151500000NaNNaNNaN<NA>
36<NA><NA>34-15-1612222630581716324361149321713642191725031120.259337원룸주택단지조성 및 교통량 증가
37<NA><NA><NA>242865360820473850414010625615753221935438NaNNaNNaN<NA>
38<NA><NA>34-15-1712802377325803391023219107923071012121812-0.017477<NA>
39<NA><NA><NA>241075710569831253124624511710833510128618NaNNaNNaN<NA>
40<NA><NA>34-15-18123166330526331638212043523890129120.033113<NA>
41<NA><NA><NA>244077421234942041012347554290129NaNNaNNaN<NA>

Duplicate rows

Most frequently occurring

시도(읍면시도) 교통량조사표(평균)Unnamed: 1Unnamed: 2Unnamed: 21# duplicates
0<NA><NA><NA><NA>21