Overview

Dataset statistics

Number of variables6
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory54.4 B

Variable types

Numeric2
Categorical4

Dataset

Description샘플 데이터
Author경기도경제과학진흥원
URLhttps://bigdata-region.kr/#/dataset/6d2818f4-d11e-4453-94d8-0fac417b3bb7

Alerts

시도명 has constant value ""Constant
분석인덱스 is highly overall correlated with 시군구명 and 1 other fieldsHigh correlation
시군구명 is highly overall correlated with 분석인덱스 and 1 other fieldsHigh correlation
행정동명 is highly overall correlated with 분석인덱스 and 1 other fieldsHigh correlation
분석인덱스 has unique valuesUnique
자기자본이익율 has unique valuesUnique
분석인덱스 has 1 (3.3%) zerosZeros

Reproduction

Analysis started2023-12-10 14:16:33.682456
Analysis finished2023-12-10 14:16:35.121703
Duration1.44 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

분석인덱스
Real number (ℝ)

HIGH CORRELATION  UNIQUE  ZEROS 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14.5
Minimum0
Maximum29
Zeros1
Zeros (%)3.3%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:16:35.234242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1.45
Q17.25
median14.5
Q321.75
95-th percentile27.55
Maximum29
Range29
Interquartile range (IQR)14.5

Descriptive statistics

Standard deviation8.8034084
Coefficient of variation (CV)0.60713162
Kurtosis-1.2
Mean14.5
Median Absolute Deviation (MAD)7.5
Skewness0
Sum435
Variance77.5
MonotonicityStrictly increasing
2023-12-10T23:16:35.432642image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
0 1
 
3.3%
16 1
 
3.3%
29 1
 
3.3%
28 1
 
3.3%
27 1
 
3.3%
26 1
 
3.3%
25 1
 
3.3%
24 1
 
3.3%
23 1
 
3.3%
22 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
0 1
3.3%
1 1
3.3%
2 1
3.3%
3 1
3.3%
4 1
3.3%
5 1
3.3%
6 1
3.3%
7 1
3.3%
8 1
3.3%
9 1
3.3%
ValueCountFrequency (%)
29 1
3.3%
28 1
3.3%
27 1
3.3%
26 1
3.3%
25 1
3.3%
24 1
3.3%
23 1
3.3%
22 1
3.3%
21 1
3.3%
20 1
3.3%

시도명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
경기도
30 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경기도
2nd row경기도
3rd row경기도
4th row경기도
5th row경기도

Common Values

ValueCountFrequency (%)
경기도 30
100.0%

Length

2023-12-10T23:16:35.649252image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:16:35.879663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 30
100.0%

시군구명
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
가평군
15 
고양시 덕양구
15 

Length

Max length7
Median length5
Mean length5
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row가평군
2nd row가평군
3rd row가평군
4th row가평군
5th row가평군

Common Values

ValueCountFrequency (%)
가평군 15
50.0%
고양시 덕양구 15
50.0%

Length

2023-12-10T23:16:36.235034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:16:36.510552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가평군 15
33.3%
고양시 15
33.3%
덕양구 15
33.3%

행정동명
Categorical

HIGH CORRELATION 

Distinct11
Distinct (%)36.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
상면
4 
설악면
4 
강매동
4 
대자동
4 
가평읍
3 
Other values (6)
11 

Length

Max length3
Median length3
Mean length2.8333333
Min length2

Unique

Unique2 ?
Unique (%)6.7%

Sample

1st row가평읍
2nd row가평읍
3rd row가평읍
4th row북면
5th row상면

Common Values

ValueCountFrequency (%)
상면 4
13.3%
설악면 4
13.3%
강매동 4
13.3%
대자동 4
13.3%
가평읍 3
10.0%
관산동 3
10.0%
청평면 2
6.7%
내유동 2
6.7%
덕은동 2
6.7%
북면 1
 
3.3%

Length

2023-12-10T23:16:36.683957image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
상면 4
13.3%
설악면 4
13.3%
강매동 4
13.3%
대자동 4
13.3%
가평읍 3
10.0%
관산동 3
10.0%
청평면 2
6.7%
내유동 2
6.7%
덕은동 2
6.7%
북면 1
 
3.3%

업종대분류명
Categorical

Distinct8
Distinct (%)26.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
C제조업
11 
G도매및소매업
9 
F건설업
3 
I숙박및음식점업
2 
J출판;영상;방송통신및정보서비스업
2 
Other values (3)
3 

Length

Max length18
Median length16
Mean length7.1333333
Min length4

Unique

Unique3 ?
Unique (%)10.0%

Sample

1st rowC제조업
2nd rowG도매및소매업
3rd rowI숙박및음식점업
4th rowC제조업
5th rowC제조업

Common Values

ValueCountFrequency (%)
C제조업 11
36.7%
G도매및소매업 9
30.0%
F건설업 3
 
10.0%
I숙박및음식점업 2
 
6.7%
J출판;영상;방송통신및정보서비스업 2
 
6.7%
A농업;임업및어업 1
 
3.3%
S협회및단체;수리및기타개인서비스업 1
 
3.3%
R예술;스포츠및여가관련서비스업 1
 
3.3%

Length

2023-12-10T23:16:36.908572image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T23:16:37.186311image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
c제조업 11
36.7%
g도매및소매업 9
30.0%
f건설업 3
 
10.0%
i숙박및음식점업 2
 
6.7%
j출판;영상;방송통신및정보서비스업 2
 
6.7%
a농업;임업및어업 1
 
3.3%
s협회및단체;수리및기타개인서비스업 1
 
3.3%
r예술;스포츠및여가관련서비스업 1
 
3.3%

자기자본이익율
Real number (ℝ)

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean80.257
Minimum-22.38
Maximum575.56
Zeros0
Zeros (%)0.0%
Negative1
Negative (%)3.3%
Memory size402.0 B
2023-12-10T23:16:37.512652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-22.38
5-th percentile5.562
Q119.0325
median50.24
Q386.465
95-th percentile262.7205
Maximum575.56
Range597.94
Interquartile range (IQR)67.4325

Descriptive statistics

Standard deviation114.06408
Coefficient of variation (CV)1.4212352
Kurtosis12.397175
Mean80.257
Median Absolute Deviation (MAD)33.025
Skewness3.2315599
Sum2407.71
Variance13010.613
MonotonicityNot monotonic
2023-12-10T23:16:37.769904image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
32.31 1
 
3.3%
88.0 1
 
3.3%
32.1 1
 
3.3%
99.33 1
 
3.3%
11.5 1
 
3.3%
62.0 1
 
3.3%
79.36 1
 
3.3%
76.83 1
 
3.3%
83.36 1
 
3.3%
40.85 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
-22.38 1
3.3%
3.96 1
3.3%
7.52 1
3.3%
8.72 1
3.3%
11.5 1
3.3%
15.71 1
3.3%
17.31 1
3.3%
17.71 1
3.3%
23.0 1
3.3%
27.73 1
3.3%
ValueCountFrequency (%)
575.56 1
3.3%
281.31 1
3.3%
240.0 1
3.3%
130.0 1
3.3%
128.89 1
3.3%
99.33 1
3.3%
88.0 1
3.3%
87.5 1
3.3%
83.36 1
3.3%
79.36 1
3.3%

Interactions

2023-12-10T23:16:34.450184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:16:34.095930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:16:34.623310image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:16:34.261297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T23:16:37.960853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
분석인덱스시군구명행정동명업종대분류명자기자본이익율
분석인덱스1.0001.0000.9310.0000.243
시군구명1.0001.0001.0000.2030.441
행정동명0.9311.0001.0000.0000.000
업종대분류명0.0000.2030.0001.0000.000
자기자본이익율0.2430.4410.0000.0001.000
2023-12-10T23:16:38.162330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종대분류명행정동명시군구명
업종대분류명1.0000.0000.101
행정동명0.0001.0000.824
시군구명0.1010.8241.000
2023-12-10T23:16:38.356350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
분석인덱스자기자본이익율시군구명행정동명업종대분류명
분석인덱스1.0000.1790.8450.7280.000
자기자본이익율0.1791.0000.2850.0000.000
시군구명0.8450.2851.0000.8240.101
행정동명0.7280.0000.8241.0000.000
업종대분류명0.0000.0000.1010.0001.000

Missing values

2023-12-10T23:16:34.826558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T23:16:35.039348image/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

분석인덱스시도명시군구명행정동명업종대분류명자기자본이익율
00경기도가평군가평읍C제조업32.31
11경기도가평군가평읍G도매및소매업17.71
22경기도가평군가평읍I숙박및음식점업44.48
33경기도가평군북면C제조업-22.38
44경기도가평군상면C제조업27.73
55경기도가평군상면F건설업130.0
66경기도가평군상면G도매및소매업575.56
77경기도가평군상면I숙박및음식점업35.0
88경기도가평군설악면A농업;임업및어업23.0
99경기도가평군설악면C제조업8.72
분석인덱스시도명시군구명행정동명업종대분류명자기자본이익율
2020경기도고양시 덕양구관산동F건설업57.05
2121경기도고양시 덕양구관산동G도매및소매업240.0
2222경기도고양시 덕양구내유동C제조업40.85
2323경기도고양시 덕양구내유동G도매및소매업83.36
2424경기도고양시 덕양구대자동C제조업76.83
2525경기도고양시 덕양구대자동G도매및소매업79.36
2626경기도고양시 덕양구대자동J출판;영상;방송통신및정보서비스업62.0
2727경기도고양시 덕양구대자동R예술;스포츠및여가관련서비스업11.5
2828경기도고양시 덕양구덕은동C제조업99.33
2929경기도고양시 덕양구덕은동G도매및소매업32.1