Overview

Dataset statistics

Number of variables54
Number of observations398
Missing cells8288
Missing cells (%)38.6%
Duplicate rows45
Duplicate rows (%)11.3%
Total size in memory170.8 KiB
Average record size in memory439.3 B

Variable types

Text5
Categorical3
Unsupported44
Numeric2

Dataset

DescriptionSample
Author차세대융합기술연구원
URLhttps://bigdata-geo.kr/user/dataset/view.do?data_sn=16

Alerts

Unnamed: 50 has constant value ""Constant
Unnamed: 51 has constant value ""Constant
Unnamed: 53 has constant value ""Constant
Dataset has 45 (11.3%) duplicate rowsDuplicates
Unnamed: 0 has 389 (97.7%) missing valuesMissing
Unnamed: 2 has 75 (18.8%) missing valuesMissing
Unnamed: 3 has 76 (19.1%) missing valuesMissing
Unnamed: 4 has 76 (19.1%) missing valuesMissing
Unnamed: 5 has 77 (19.3%) missing valuesMissing
Unnamed: 6 has 78 (19.6%) missing valuesMissing
Unnamed: 7 has 76 (19.1%) missing valuesMissing
Unnamed: 8 has 77 (19.3%) missing valuesMissing
Unnamed: 9 has 77 (19.3%) missing valuesMissing
Unnamed: 10 has 77 (19.3%) missing valuesMissing
Unnamed: 11 has 77 (19.3%) missing valuesMissing
Unnamed: 12 has 77 (19.3%) missing valuesMissing
Unnamed: 14 has 76 (19.1%) missing valuesMissing
Unnamed: 15 has 77 (19.3%) missing valuesMissing
Unnamed: 16 has 77 (19.3%) missing valuesMissing
Unnamed: 17 has 77 (19.3%) missing valuesMissing
Unnamed: 18 has 77 (19.3%) missing valuesMissing
Unnamed: 19 has 75 (18.8%) missing valuesMissing
Unnamed: 20 has 74 (18.6%) missing valuesMissing
Unnamed: 21 has 74 (18.6%) missing valuesMissing
안철수연구소 has 73 (18.3%) missing valuesMissing
Unnamed: 23 has 75 (18.8%) missing valuesMissing
Unnamed: 24 has 74 (18.6%) missing valuesMissing
Unnamed: 25 has 333 (83.7%) missing valuesMissing
Unnamed: 26 has 75 (18.8%) missing valuesMissing
Unnamed: 27 has 77 (19.3%) missing valuesMissing
Unnamed: 28 has 77 (19.3%) missing valuesMissing
Unnamed: 29 has 77 (19.3%) missing valuesMissing
Unnamed: 30 has 78 (19.6%) missing valuesMissing
Unnamed: 31 has 76 (19.1%) missing valuesMissing
Unnamed: 32 has 77 (19.3%) missing valuesMissing
Unnamed: 33 has 77 (19.3%) missing valuesMissing
Unnamed: 34 has 77 (19.3%) missing valuesMissing
Unnamed: 35 has 77 (19.3%) missing valuesMissing
Unnamed: 36 has 77 (19.3%) missing valuesMissing
Unnamed: 38 has 398 (100.0%) missing valuesMissing
Unnamed: 39 has 251 (63.1%) missing valuesMissing
Unnamed: 40 has 251 (63.1%) missing valuesMissing
Unnamed: 41 has 253 (63.6%) missing valuesMissing
Unnamed: 42 has 253 (63.6%) missing valuesMissing
Unnamed: 43 has 253 (63.6%) missing valuesMissing
Unnamed: 44 has 253 (63.6%) missing valuesMissing
Unnamed: 45 has 398 (100.0%) missing valuesMissing
Unnamed: 46 has 251 (63.1%) missing valuesMissing
Unnamed: 47 has 251 (63.1%) missing valuesMissing
Unnamed: 48 has 252 (63.3%) missing valuesMissing
Unnamed: 49 has 396 (99.5%) missing valuesMissing
Unnamed: 50 has 397 (99.7%) missing valuesMissing
Unnamed: 51 has 397 (99.7%) missing valuesMissing
Unnamed: 52 has 398 (100.0%) missing valuesMissing
Unnamed: 53 has 397 (99.7%) missing valuesMissing
Unnamed: 2 is an unsupported type, check if it needs cleaning or further analysisUnsupported
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: 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: 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
Unnamed: 21 is an unsupported type, check if it needs cleaning or further analysisUnsupported
안철수연구소 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 23 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 24 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 25 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 26 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 27 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 28 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 29 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 31 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 32 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 33 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 34 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 35 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 36 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 38 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 39 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 40 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 41 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 42 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 43 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 44 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 45 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 46 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 47 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 48 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 52 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 6 has 279 (70.1%) zerosZeros
Unnamed: 30 has 283 (71.1%) zerosZeros

Reproduction

Analysis started2023-12-10 13:17:09.575162
Analysis finished2023-12-10 13:17:10.729468
Duration1.15 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Unnamed: 0
Text

MISSING 

Distinct9
Distinct (%)100.0%
Missing389
Missing (%)97.7%
Memory size3.2 KiB
2023-12-10T22:17:10.870071image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length30
Median length8
Mean length7.6666667
Min length1

Characters and Unicode

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

Unique

Unique9 ?
Unique (%)100.0%

Sample

1st row< 부표 2 - 2 > 교차로의 방향별 6시간 교통량
2nd row교차로명
3rd row
4th row
5th row
ValueCountFrequency (%)
3
16.7%
2 2
 
11.1%
부표 1
 
5.6%
교차로의 1
 
5.6%
방향별 1
 
5.6%
6시간 1
 
5.6%
교통량 1
 
5.6%
교차로명 1
 
5.6%
1
 
5.6%
1
 
5.6%
Other values (5) 5
27.8%
2023-12-10T22:17:11.631438image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
10
14.5%
6
 
8.7%
5
 
7.2%
5
 
7.2%
) 4
 
5.8%
4
 
5.8%
( 4
 
5.8%
2 3
 
4.3%
3
 
4.3%
2
 
2.9%
Other values (22) 23
33.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 37
53.6%
Space Separator 10
 
14.5%
Decimal Number 7
 
10.1%
Math Symbol 6
 
8.7%
Close Punctuation 4
 
5.8%
Open Punctuation 4
 
5.8%
Dash Punctuation 1
 
1.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
6
16.2%
5
13.5%
5
13.5%
4
10.8%
3
8.1%
2
 
5.4%
2
 
5.4%
1
 
2.7%
1
 
2.7%
1
 
2.7%
Other values (7) 7
18.9%
Math Symbol
ValueCountFrequency (%)
1
16.7%
1
16.7%
1
16.7%
< 1
16.7%
> 1
16.7%
1
16.7%
Decimal Number
ValueCountFrequency (%)
2 3
42.9%
3 1
 
14.3%
1 1
 
14.3%
4 1
 
14.3%
6 1
 
14.3%
Space Separator
ValueCountFrequency (%)
10
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 37
53.6%
Common 32
46.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
6
16.2%
5
13.5%
5
13.5%
4
10.8%
3
8.1%
2
 
5.4%
2
 
5.4%
1
 
2.7%
1
 
2.7%
1
 
2.7%
Other values (7) 7
18.9%
Common
ValueCountFrequency (%)
10
31.2%
) 4
 
12.5%
( 4
 
12.5%
2 3
 
9.4%
1
 
3.1%
1
 
3.1%
3 1
 
3.1%
1 1
 
3.1%
1
 
3.1%
4 1
 
3.1%
Other values (5) 5
15.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 37
53.6%
ASCII 28
40.6%
Arrows 4
 
5.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
10
35.7%
) 4
 
14.3%
( 4
 
14.3%
2 3
 
10.7%
3 1
 
3.6%
1 1
 
3.6%
4 1
 
3.6%
< 1
 
3.6%
6 1
 
3.6%
> 1
 
3.6%
Hangul
ValueCountFrequency (%)
6
16.2%
5
13.5%
5
13.5%
4
10.8%
3
8.1%
2
 
5.4%
2
 
5.4%
1
 
2.7%
1
 
2.7%
1
 
2.7%
Other values (7) 7
18.9%
Arrows
ValueCountFrequency (%)
1
25.0%
1
25.0%
1
25.0%
1
25.0%

Unnamed: 1
Categorical

Distinct50
Distinct (%)12.6%
Missing0
Missing (%)0.0%
Memory size3.2 KiB
<NA>
77 
소계
64 
17:00-17:15
 
12
13:45-14:00
 
8
12:15-12:30
 
8
Other values (45)
229 

Length

Max length11
Median length11
Mean length8.178392
Min length2

Unique

Unique1 ?
Unique (%)0.3%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 77
19.3%
소계 64
 
16.1%
17:00-17:15 12
 
3.0%
13:45-14:00 8
 
2.0%
12:15-12:30 8
 
2.0%
12:30-12:45 8
 
2.0%
18:30-18:45 8
 
2.0%
13:00-13:15 8
 
2.0%
13:15-13:30 8
 
2.0%
13:30-13:45 8
 
2.0%
Other values (40) 189
47.5%

Length

2023-12-10T22:17:11.988701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 77
19.3%
소계 64
 
16.1%
17:00-17:15 12
 
3.0%
12:00-12:15 8
 
2.0%
17:30-17:45 8
 
2.0%
18:15-18:30 8
 
2.0%
18:00-18:15 8
 
2.0%
17:45-18:00 8
 
2.0%
12:45-13:00 8
 
2.0%
17:15-17:30 8
 
2.0%
Other values (40) 189
47.5%

Unnamed: 2
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing75
Missing (%)18.8%
Memory size3.2 KiB

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing76
Missing (%)19.1%
Memory size3.2 KiB

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing76
Missing (%)19.1%
Memory size3.2 KiB

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing77
Missing (%)19.3%
Memory size3.2 KiB

Unnamed: 6
Real number (ℝ)

MISSING  ZEROS 

Distinct19
Distinct (%)5.9%
Missing78
Missing (%)19.6%
Infinite0
Infinite (%)0.0%
Mean1.5375
Minimum0
Maximum90
Zeros279
Zeros (%)70.1%
Negative0
Negative (%)0.0%
Memory size3.6 KiB
2023-12-10T22:17:12.302972image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile8.1
Maximum90
Range90
Interquartile range (IQR)0

Descriptive statistics

Standard deviation7.8890325
Coefficient of variation (CV)5.1310781
Kurtosis81.806255
Mean1.5375
Median Absolute Deviation (MAD)0
Skewness8.3747039
Sum492
Variance62.236834
MonotonicityNot monotonic
2023-12-10T22:17:12.960376image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
0 279
70.1%
1 13
 
3.3%
4 4
 
1.0%
3 3
 
0.8%
10 3
 
0.8%
2 3
 
0.8%
20 2
 
0.5%
21 2
 
0.5%
17 1
 
0.3%
22 1
 
0.3%
Other values (9) 9
 
2.3%
(Missing) 78
 
19.6%
ValueCountFrequency (%)
0 279
70.1%
1 13
 
3.3%
2 3
 
0.8%
3 3
 
0.8%
4 4
 
1.0%
7 1
 
0.3%
8 1
 
0.3%
10 3
 
0.8%
11 1
 
0.3%
12 1
 
0.3%
ValueCountFrequency (%)
90 1
0.3%
80 1
0.3%
40 1
0.3%
30 1
0.3%
22 1
0.3%
21 2
0.5%
20 2
0.5%
19 1
0.3%
17 1
0.3%
12 1
0.3%

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing76
Missing (%)19.1%
Memory size3.2 KiB

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing77
Missing (%)19.3%
Memory size3.2 KiB

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing77
Missing (%)19.3%
Memory size3.2 KiB

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing77
Missing (%)19.3%
Memory size3.2 KiB

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing77
Missing (%)19.3%
Memory size3.2 KiB

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing77
Missing (%)19.3%
Memory size3.2 KiB

Unnamed: 13
Categorical

Distinct2
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size3.2 KiB
<NA>
334 
0
64 

Length

Max length4
Median length4
Mean length3.5175879
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 334
83.9%
0 64
 
16.1%

Length

2023-12-10T22:17:13.366466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:17:13.614909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 334
83.9%
0 64
 
16.1%

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing76
Missing (%)19.1%
Memory size3.2 KiB

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing77
Missing (%)19.3%
Memory size3.2 KiB

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing77
Missing (%)19.3%
Memory size3.2 KiB

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing77
Missing (%)19.3%
Memory size3.2 KiB

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing77
Missing (%)19.3%
Memory size3.2 KiB

Unnamed: 19
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing75
Missing (%)18.8%
Memory size3.2 KiB

Unnamed: 20
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing74
Missing (%)18.6%
Memory size3.2 KiB

Unnamed: 21
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing74
Missing (%)18.6%
Memory size3.2 KiB

안철수연구소
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing73
Missing (%)18.3%
Memory size3.2 KiB

Unnamed: 23
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing75
Missing (%)18.8%
Memory size3.2 KiB

Unnamed: 24
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing74
Missing (%)18.6%
Memory size3.2 KiB

Unnamed: 25
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing333
Missing (%)83.7%
Memory size3.2 KiB

Unnamed: 26
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing75
Missing (%)18.8%
Memory size3.2 KiB

Unnamed: 27
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing77
Missing (%)19.3%
Memory size3.2 KiB

Unnamed: 28
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing77
Missing (%)19.3%
Memory size3.2 KiB

Unnamed: 29
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing77
Missing (%)19.3%
Memory size3.2 KiB

Unnamed: 30
Real number (ℝ)

MISSING  ZEROS 

Distinct10
Distinct (%)3.1%
Missing78
Missing (%)19.6%
Infinite0
Infinite (%)0.0%
Mean0.43125
Minimum0
Maximum18
Zeros283
Zeros (%)71.1%
Negative0
Negative (%)0.0%
Memory size3.6 KiB
2023-12-10T22:17:13.746117image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile3
Maximum18
Range18
Interquartile range (IQR)0

Descriptive statistics

Standard deviation1.6594816
Coefficient of variation (CV)3.8480734
Kurtosis50.12778
Mean0.43125
Median Absolute Deviation (MAD)0
Skewness6.2218904
Sum138
Variance2.7538793
MonotonicityNot monotonic
2023-12-10T22:17:13.927032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
0 283
71.1%
2 9
 
2.3%
1 8
 
2.0%
3 6
 
1.5%
5 5
 
1.3%
4 4
 
1.0%
11 2
 
0.5%
6 1
 
0.3%
18 1
 
0.3%
7 1
 
0.3%
(Missing) 78
 
19.6%
ValueCountFrequency (%)
0 283
71.1%
1 8
 
2.0%
2 9
 
2.3%
3 6
 
1.5%
4 4
 
1.0%
5 5
 
1.3%
6 1
 
0.3%
7 1
 
0.3%
11 2
 
0.5%
18 1
 
0.3%
ValueCountFrequency (%)
18 1
 
0.3%
11 2
 
0.5%
7 1
 
0.3%
6 1
 
0.3%
5 5
 
1.3%
4 4
 
1.0%
3 6
 
1.5%
2 9
 
2.3%
1 8
 
2.0%
0 283
71.1%

Unnamed: 31
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing76
Missing (%)19.1%
Memory size3.2 KiB

Unnamed: 32
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing77
Missing (%)19.3%
Memory size3.2 KiB

Unnamed: 33
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing77
Missing (%)19.3%
Memory size3.2 KiB

Unnamed: 34
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing77
Missing (%)19.3%
Memory size3.2 KiB

Unnamed: 35
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing77
Missing (%)19.3%
Memory size3.2 KiB

Unnamed: 36
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing77
Missing (%)19.3%
Memory size3.2 KiB

Unnamed: 37
Categorical

Distinct2
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size3.2 KiB
<NA>
334 
0
64 

Length

Max length4
Median length4
Mean length3.5175879
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 334
83.9%
0 64
 
16.1%

Length

2023-12-10T22:17:14.141199image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:17:14.321379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 334
83.9%
0 64
 
16.1%

Unnamed: 38
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing398
Missing (%)100.0%
Memory size3.6 KiB

Unnamed: 39
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing251
Missing (%)63.1%
Memory size3.2 KiB

Unnamed: 40
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing251
Missing (%)63.1%
Memory size3.2 KiB

Unnamed: 41
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing253
Missing (%)63.6%
Memory size3.2 KiB

Unnamed: 42
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing253
Missing (%)63.6%
Memory size3.2 KiB

Unnamed: 43
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing253
Missing (%)63.6%
Memory size3.2 KiB

Unnamed: 44
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing253
Missing (%)63.6%
Memory size3.2 KiB

Unnamed: 45
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing398
Missing (%)100.0%
Memory size3.6 KiB

Unnamed: 46
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing251
Missing (%)63.1%
Memory size3.2 KiB

Unnamed: 47
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing251
Missing (%)63.1%
Memory size3.2 KiB

Unnamed: 48
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing252
Missing (%)63.3%
Memory size3.2 KiB

Unnamed: 49
Text

MISSING 

Distinct2
Distinct (%)100.0%
Missing396
Missing (%)99.5%
Memory size3.2 KiB
2023-12-10T22:17:14.497150image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length4
Mean length4
Min length2

Characters and Unicode

Total characters8
Distinct characters8
Distinct categories3 ?
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참조파일_2
ValueCountFrequency (%)
없음 1
50.0%
참조파일_2 1
50.0%
2023-12-10T22:17:14.927945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1
12.5%
1
12.5%
1
12.5%
1
12.5%
1
12.5%
1
12.5%
_ 1
12.5%
2 1
12.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6
75.0%
Connector Punctuation 1
 
12.5%
Decimal Number 1
 
12.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
1
16.7%
1
16.7%
1
16.7%
1
16.7%
1
16.7%
1
16.7%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%
Decimal Number
ValueCountFrequency (%)
2 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6
75.0%
Common 2
 
25.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
1
16.7%
1
16.7%
1
16.7%
1
16.7%
1
16.7%
1
16.7%
Common
ValueCountFrequency (%)
_ 1
50.0%
2 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6
75.0%
ASCII 2
 
25.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
1
16.7%
1
16.7%
1
16.7%
1
16.7%
1
16.7%
1
16.7%
ASCII
ValueCountFrequency (%)
_ 1
50.0%
2 1
50.0%

Unnamed: 50
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing397
Missing (%)99.7%
Memory size3.2 KiB
2023-12-10T22:17:15.164019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length6
Mean length6
Min length6

Characters and Unicode

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

Unique

Unique1 ?
Unique (%)100.0%

Sample

1st row참조파일_3
ValueCountFrequency (%)
참조파일_3 1
100.0%
2023-12-10T22:17:15.611784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1
16.7%
1
16.7%
1
16.7%
1
16.7%
_ 1
16.7%
3 1
16.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4
66.7%
Connector Punctuation 1
 
16.7%
Decimal Number 1
 
16.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
1
25.0%
1
25.0%
1
25.0%
1
25.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%
Decimal Number
ValueCountFrequency (%)
3 1
100.0%

Most occurring scripts

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

Most frequent character per script

Hangul
ValueCountFrequency (%)
1
25.0%
1
25.0%
1
25.0%
1
25.0%
Common
ValueCountFrequency (%)
_ 1
50.0%
3 1
50.0%

Most occurring blocks

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

Most frequent character per block

Hangul
ValueCountFrequency (%)
1
25.0%
1
25.0%
1
25.0%
1
25.0%
ASCII
ValueCountFrequency (%)
_ 1
50.0%
3 1
50.0%

Unnamed: 51
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing397
Missing (%)99.7%
Memory size3.2 KiB
2023-12-10T22:17:15.863065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length6
Mean length6
Min length6

Characters and Unicode

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

Unique

Unique1 ?
Unique (%)100.0%

Sample

1st row참조파일_4
ValueCountFrequency (%)
참조파일_4 1
100.0%
2023-12-10T22:17:16.337924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1
16.7%
1
16.7%
1
16.7%
1
16.7%
_ 1
16.7%
4 1
16.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4
66.7%
Connector Punctuation 1
 
16.7%
Decimal Number 1
 
16.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
1
25.0%
1
25.0%
1
25.0%
1
25.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%
Decimal Number
ValueCountFrequency (%)
4 1
100.0%

Most occurring scripts

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

Most frequent character per script

Hangul
ValueCountFrequency (%)
1
25.0%
1
25.0%
1
25.0%
1
25.0%
Common
ValueCountFrequency (%)
_ 1
50.0%
4 1
50.0%

Most occurring blocks

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

Most frequent character per block

Hangul
ValueCountFrequency (%)
1
25.0%
1
25.0%
1
25.0%
1
25.0%
ASCII
ValueCountFrequency (%)
_ 1
50.0%
4 1
50.0%

Unnamed: 52
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing398
Missing (%)100.0%
Memory size3.6 KiB

Unnamed: 53
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing397
Missing (%)99.7%
Memory size3.2 KiB
2023-12-10T22:17:16.591696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length4
Mean length4
Min length4

Characters and Unicode

Total characters4
Distinct characters4
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1 ?
Unique (%)100.0%

Sample

1st row조사위치
ValueCountFrequency (%)
조사위치 1
100.0%
2023-12-10T22:17:16.998120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1
25.0%
1
25.0%
1
25.0%
1
25.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
1
25.0%
1
25.0%
1
25.0%
1
25.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
1
25.0%
1
25.0%
1
25.0%
1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
1
25.0%
1
25.0%
1
25.0%
1
25.0%

Sample

Unnamed: 0Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21안철수연구소Unnamed: 23Unnamed: 24Unnamed: 25Unnamed: 26Unnamed: 27Unnamed: 28Unnamed: 29Unnamed: 30Unnamed: 31Unnamed: 32Unnamed: 33Unnamed: 34Unnamed: 35Unnamed: 36Unnamed: 37Unnamed: 38Unnamed: 39Unnamed: 40Unnamed: 41Unnamed: 42Unnamed: 43Unnamed: 44Unnamed: 45Unnamed: 46Unnamed: 47Unnamed: 48Unnamed: 49Unnamed: 50Unnamed: 51Unnamed: 52Unnamed: 53
0<NA><NA>NaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaN3번유입부NaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaN<NA><NA><NA><NA><NA>
1<NA><NA>NaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaN<NA><NA><NA><NA><NA>
2<NA><NA>NaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaN4번\n유입부NaNNaNNaN2번\n유입부NaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaN<NA><NA><NA><NA><NA>
3<NA><NA>NaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaN화랑공원삼거리NaNNaNNaNNaNNaN판교역사거리NaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaN<NA><NA><NA><NA><NA>
4<NA><NA>NaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaN<NA><NA><NA><NA><NA>
5<NA><NA>NaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaN<NA><NA><NA><NA><NA>
6<NA><NA>NaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaN1번유입부NaNNaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaN<NA><NA><NA><NA><NA>
7<NA><NA>NaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaN환승주차장삼거리NaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaN<NA><NA><NA><NA><NA>
8<NA><NA>NaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaN<NA><NA><NA><NA><NA>
9<NA><NA>NaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaN<NA><NA><NA><NA><NA>
Unnamed: 0Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21안철수연구소Unnamed: 23Unnamed: 24Unnamed: 25Unnamed: 26Unnamed: 27Unnamed: 28Unnamed: 29Unnamed: 30Unnamed: 31Unnamed: 32Unnamed: 33Unnamed: 34Unnamed: 35Unnamed: 36Unnamed: 37Unnamed: 38Unnamed: 39Unnamed: 40Unnamed: 41Unnamed: 42Unnamed: 43Unnamed: 44Unnamed: 45Unnamed: 46Unnamed: 47Unnamed: 48Unnamed: 49Unnamed: 50Unnamed: 51Unnamed: 52Unnamed: 53
388<NA>20:15-20:3000000000000<NA>00000000000NaN00000000000<NA><NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaN<NA><NA><NA><NA><NA>
389<NA>20:30-20:4500000000000<NA>00000000000NaN00000000000<NA><NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaN<NA><NA><NA><NA><NA>
390<NA>20:45-21:0000000000000<NA>00000000000NaN00000000000<NA><NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaN<NA><NA><NA><NA><NA>
391<NA>소계000000000000000000000000000000000000<NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaN<NA><NA><NA><NA><NA>
392<NA><NA>NaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<NA>NaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaN<NA><NA><NA><NA><NA>
393<NA>21:00-21:1500000000000<NA>00000000000NaN00000000000<NA><NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaN<NA><NA><NA><NA><NA>
394<NA>21:15-21:3000000000000<NA>00000000000NaN00000000000<NA><NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaN<NA><NA><NA><NA><NA>
395<NA>21:30-21:4500000000000<NA>00000000000NaN00000000000<NA><NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaN<NA><NA><NA><NA><NA>
396<NA>21:45-22:0000000000000<NA>00000000000NaN00000000000<NA><NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaN<NA><NA><NA><NA><NA>
397<NA>소계000000000000000000000000000000000000<NA>NaNNaNNaNNaNNaNNaN<NA>NaNNaNNaN<NA><NA><NA><NA><NA>

Duplicate rows

Most frequently occurring

Unnamed: 0Unnamed: 1Unnamed: 6Unnamed: 13Unnamed: 30Unnamed: 37Unnamed: 49Unnamed: 50Unnamed: 51Unnamed: 53# duplicates
44<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>73
43<NA>소계0000<NA><NA><NA><NA>52
22<NA>17:00-17:150<NA>0<NA><NA><NA><NA><NA>12
8<NA>13:00-13:150<NA>0<NA><NA><NA><NA><NA>8
9<NA>13:15-13:300<NA>0<NA><NA><NA><NA><NA>8
10<NA>13:30-13:450<NA>0<NA><NA><NA><NA><NA>8
11<NA>13:45-14:000<NA>0<NA><NA><NA><NA><NA>8
24<NA>17:15-17:300<NA>0<NA><NA><NA><NA><NA>8
25<NA>17:30-17:450<NA>0<NA><NA><NA><NA><NA>8
26<NA>17:45-18:000<NA>0<NA><NA><NA><NA><NA>8