Overview

Dataset statistics

Number of variables8
Number of observations199
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory13.3 KiB
Average record size in memory68.7 B

Variable types

Text1
Numeric2
Categorical5

Dataset

DescriptionSample
Author(재)인천테크노파크
URLhttps://www.bigdata-telecom.kr/invoke/SOKBP2603/?goodsCode=ICTCONS000001

Alerts

인천 has constant value ""Constant
2020 has constant value ""Constant
20210824 has constant value ""Constant
운서동 is highly overall correlated with 2811062800 and 2 other fieldsHigh correlation
중구 is highly overall correlated with 2811062800 and 2 other fieldsHigh correlation
2811062800 is highly overall correlated with 18323.923099071613 and 2 other fieldsHigh correlation
18323.923099071613 is highly overall correlated with 2811062800 and 2 other fieldsHigh correlation
다사00504150 has unique valuesUnique

Reproduction

Analysis started2023-12-10 06:13:41.464393
Analysis finished2023-12-10 06:13:42.709761
Duration1.25 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

다사00504150
Text

UNIQUE 

Distinct199
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2023-12-10T15:13:42.947324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

Total characters1990
Distinct characters12
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

Unique199 ?
Unique (%)100.0%

Sample

1st row다사00504200
2nd row다사01004100
3rd row다사01004150
4th row다사01004200
5th row다사01504050
ValueCountFrequency (%)
다사00504200 1
 
0.5%
다사23004850 1
 
0.5%
다사22503450 1
 
0.5%
다사22504650 1
 
0.5%
다사22504700 1
 
0.5%
다사22504750 1
 
0.5%
다사22504800 1
 
0.5%
다사22504850 1
 
0.5%
다사22504900 1
 
0.5%
다사22504950 1
 
0.5%
Other values (189) 189
95.0%
2023-12-10T15:13:43.540953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 689
34.6%
5 237
 
11.9%
다 199
 
10.0%
사 199
 
10.0%
4 199
 
10.0%
2 190
 
9.5%
3 134
 
6.7%
1 74
 
3.7%
7 24
 
1.2%
8 19
 
1.0%
Other values (2) 26
 
1.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1592
80.0%
Other Letter 398
 
20.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 689
43.3%
5 237
 
14.9%
4 199
 
12.5%
2 190
 
11.9%
3 134
 
8.4%
1 74
 
4.6%
7 24
 
1.5%
8 19
 
1.2%
9 18
 
1.1%
6 8
 
0.5%
Other Letter
ValueCountFrequency (%)
다 199
50.0%
사 199
50.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1592
80.0%
Hangul 398
 
20.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 689
43.3%
5 237
 
14.9%
4 199
 
12.5%
2 190
 
11.9%
3 134
 
8.4%
1 74
 
4.6%
7 24
 
1.5%
8 19
 
1.2%
9 18
 
1.1%
6 8
 
0.5%
Hangul
ValueCountFrequency (%)
다 199
50.0%
사 199
50.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1592
80.0%
Hangul 398
 
20.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 689
43.3%
5 237
 
14.9%
4 199
 
12.5%
2 190
 
11.9%
3 134
 
8.4%
1 74
 
4.6%
7 24
 
1.5%
8 19
 
1.2%
9 18
 
1.1%
6 8
 
0.5%
Hangul
ValueCountFrequency (%)
다 199
50.0%
사 199
50.0%

2811062800
Real number (ℝ)

HIGH CORRELATION 

Distinct8
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.8177367 × 109
Minimum2.8110622 × 109
Maximum2.8260539 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:13:43.768687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.8110622 × 109
5-th percentile2.8110622 × 109
Q12.8110628 × 109
median2.818583 × 109
Q32.8260537 × 109
95-th percentile2.8260539 × 109
Maximum2.8260539 × 109
Range14991700
Interquartile range (IQR)14990900

Descriptive statistics

Standard deviation6338981.2
Coefficient of variation (CV)0.0022496713
Kurtosis-1.5738353
Mean2.8177367 × 109
Median Absolute Deviation (MAD)7470900
Skewness0.20942827
Sum5.607296 × 1011
Variance4.0182683 × 1013
MonotonicityNot monotonic
2023-12-10T15:13:44.002628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
2811062800 67
33.7%
2826053900 48
24.1%
2818585000 25
 
12.6%
2811062200 16
 
8.0%
2818583000 14
 
7.0%
2826053700 13
 
6.5%
2818582000 12
 
6.0%
2818584000 4
 
2.0%
ValueCountFrequency (%)
2811062200 16
 
8.0%
2811062800 67
33.7%
2818582000 12
 
6.0%
2818583000 14
 
7.0%
2818584000 4
 
2.0%
2818585000 25
 
12.6%
2826053700 13
 
6.5%
2826053900 48
24.1%
ValueCountFrequency (%)
2826053900 48
24.1%
2826053700 13
 
6.5%
2818585000 25
 
12.6%
2818584000 4
 
2.0%
2818583000 14
 
7.0%
2818582000 12
 
6.0%
2811062800 67
33.7%
2811062200 16
 
8.0%

인천
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
인천
199 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row인천
2nd row인천
3rd row인천
4th row인천
5th row인천

Common Values

ValueCountFrequency (%)
인천 199
100.0%

Length

2023-12-10T15:13:44.306272image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:13:44.483359image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
인천 199
100.0%

중구
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
중구
83 
서구
61 
연수구
55 

Length

Max length3
Median length2
Mean length2.2763819
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row중구
2nd row중구
3rd row중구
4th row중구
5th row중구

Common Values

ValueCountFrequency (%)
중구 83
41.7%
서구 61
30.7%
연수구 55
27.6%

Length

2023-12-10T15:13:44.715199image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:13:44.990635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
중구 83
41.7%
서구 61
30.7%
연수구 55
27.6%

운서동
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
운서동
67 
청라3동
48 
송도4동
25 
영종1동
16 
송도2동
14 
Other values (3)
29 

Length

Max length4
Median length4
Mean length3.6633166
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row운서동
2nd row운서동
3rd row운서동
4th row운서동
5th row운서동

Common Values

ValueCountFrequency (%)
운서동 67
33.7%
청라3동 48
24.1%
송도4동 25
 
12.6%
영종1동 16
 
8.0%
송도2동 14
 
7.0%
청라2동 13
 
6.5%
송도1동 12
 
6.0%
송도3동 4
 
2.0%

Length

2023-12-10T15:13:45.279004image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:13:45.612422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
운서동 67
33.7%
청라3동 48
24.1%
송도4동 25
 
12.6%
영종1동 16
 
8.0%
송도2동 14
 
7.0%
청라2동 13
 
6.5%
송도1동 12
 
6.0%
송도3동 4
 
2.0%

2020
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2020
199 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2020
2nd row2020
3rd row2020
4th row2020
5th row2020

Common Values

ValueCountFrequency (%)
2020 199
100.0%

Length

2023-12-10T15:13:45.938355image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:13:46.471413image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020 199
100.0%

18323.923099071613
Real number (ℝ)

HIGH CORRELATION 

Distinct8
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19708.266
Minimum10455.955
Maximum49331.197
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.9 KiB
2023-12-10T15:13:46.615460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10455.955
5-th percentile10455.955
Q111104.525
median18323.923
Q318323.923
95-th percentile49331.197
Maximum49331.197
Range38875.242
Interquartile range (IQR)7219.3979

Descriptive statistics

Standard deviation11462.19
Coefficient of variation (CV)0.58159302
Kurtosis0.66958228
Mean19708.266
Median Absolute Deviation (MAD)7219.3979
Skewness1.3397449
Sum3921945
Variance1.313818 × 108
MonotonicityNot monotonic
2023-12-10T15:13:46.791862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
18323.923099071613 67
33.7%
10455.954501976865 48
24.1%
11210.330712151155 25
 
12.6%
34542.394050454095 16
 
8.0%
38513.68237009556 14
 
7.0%
11104.525174378356 13
 
6.5%
49331.19656608269 12
 
6.0%
20973.757229561365 4
 
2.0%
ValueCountFrequency (%)
10455.954501976865 48
24.1%
11104.525174378356 13
 
6.5%
11210.330712151155 25
 
12.6%
18323.923099071613 67
33.7%
20973.757229561365 4
 
2.0%
34542.394050454095 16
 
8.0%
38513.68237009556 14
 
7.0%
49331.19656608269 12
 
6.0%
ValueCountFrequency (%)
49331.19656608269 12
 
6.0%
38513.68237009556 14
 
7.0%
34542.394050454095 16
 
8.0%
20973.757229561365 4
 
2.0%
18323.923099071613 67
33.7%
11210.330712151155 25
 
12.6%
11104.525174378356 13
 
6.5%
10455.954501976865 48
24.1%

20210824
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
20210824
199 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row20210824
2nd row20210824
3rd row20210824
4th row20210824
5th row20210824

Common Values

ValueCountFrequency (%)
20210824 199
100.0%

Length

2023-12-10T15:13:46.974379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:13:47.116872image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20210824 199
100.0%

Interactions

2023-12-10T15:13:41.982395image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:13:41.712650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:13:42.181319image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:13:41.836406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:13:47.219249image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2811062800중구운서동18323.923099071613
28110628001.0001.0001.0000.688
중구1.0001.0001.0000.730
운서동1.0001.0001.0001.000
18323.9230990716130.6880.7301.0001.000
2023-12-10T15:13:47.367004image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
운서동중구
운서동1.0000.987
중구0.9871.000
2023-12-10T15:13:47.493418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
281106280018323.923099071613중구운서동
28110628001.000-0.7841.0000.987
18323.923099071613-0.7841.0000.7890.992
중구1.0000.7891.0000.987
운서동0.9870.9920.9871.000

Missing values

2023-12-10T15:13:42.436110image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T15:13:42.631928image/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

다사005041502811062800인천중구운서동202018323.92309907161320210824
0다사005042002811062800인천중구운서동202018323.92309920210824
1다사010041002811062800인천중구운서동202018323.92309920210824
2다사010041502811062800인천중구운서동202018323.92309920210824
3다사010042002811062800인천중구운서동202018323.92309920210824
4다사015040502811062800인천중구운서동202018323.92309920210824
5다사015041002811062800인천중구운서동202018323.92309920210824
6다사015041502811062800인천중구운서동202018323.92309920210824
7다사015042002811062800인천중구운서동202018323.92309920210824
8다사015042502811062800인천중구운서동202018323.92309920210824
9다사020040502811062800인천중구운서동202018323.92309920210824
다사005041502811062800인천중구운서동202018323.92309907161320210824
189다사245029502818584000인천연수구송도3동202020973.7572320210824
190다사245030002818584000인천연수구송도3동202020973.7572320210824
191다사245030502818584000인천연수구송도3동202020973.7572320210824
192다사245031002818582000인천연수구송도1동202049331.19656620210824
193다사245031502818582000인천연수구송도1동202049331.19656620210824
194다사245032002818582000인천연수구송도1동202049331.19656620210824
195다사245032502818582000인천연수구송도1동202049331.19656620210824
196다사245033002818583000인천연수구송도2동202038513.6823720210824
197다사245033502818583000인천연수구송도2동202038513.6823720210824
198다사245034002818583000인천연수구송도2동202038513.6823720210824