Dataset statistics
Number of variables | 4 |
---|---|
Number of observations | 10000 |
Missing cells | 0 |
Missing cells (%) | 0.0% |
Duplicate rows | 2 |
Duplicate rows (%) | < 0.1% |
Total size in memory | 410.2 KiB |
Average record size in memory | 42.0 B |
Variable types
Numeric | 2 |
---|---|
Categorical | 2 |
Dataset
Description | 안양시 공간정보시스템 상의 가로수에 대한 현황 데이터 정보등 관리번호와 가로수직경 및 관할지역 과 식재알자 등 데이터 자료입니다 |
---|---|
URL | https://www.data.go.kr/data/15042420/fileData.do |
Dataset has 2 (< 0.1%) duplicate rows | Duplicates |
관리번호 is highly overall correlated with 관할지역 and 1 other fields | High correlation |
가로수직경 is highly overall correlated with 식재일자 | High correlation |
관할지역 is highly overall correlated with 관리번호 and 1 other fields | High correlation |
식재일자 is highly overall correlated with 관리번호 and 2 other fields | High correlation |
식재일자 is highly imbalanced (68.3%) | Imbalance |
관리번호 has 1257 (12.6%) zeros | Zeros |
가로수직경 has 9865 (98.7%) zeros | Zeros |
Reproduction
Analysis started | 2023-12-12 10:22:52.472191 |
---|---|
Analysis finished | 2023-12-12 10:22:53.401631 |
Duration | 0.93 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
관리번호
Real number (ℝ)
HIGH CORRELATION
  ZEROS
 
Distinct | 8708 |
---|---|
Distinct (%) | 87.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 1.6458729 × 109 |
Minimum | 0 |
---|---|
Maximum | 2.1474836 × 109 |
Zeros | 1257 |
Zeros (%) | 12.6% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 2.0221215 × 109 |
median | 2.0221273 × 109 |
Q3 | 2.0221331 × 109 |
95-th percentile | 2.0221377 × 109 |
Maximum | 2.1474836 × 109 |
Range | 2.1474836 × 109 |
Interquartile range (IQR) | 11608 |
Descriptive statistics
Standard deviation | 7.8760245 × 108 |
---|---|
Coefficient of variation (CV) | 0.47853176 |
Kurtosis | 0.59702654 |
Mean | 1.6458729 × 109 |
Median Absolute Deviation (MAD) | 5803.5 |
Skewness | -1.611277 |
Sum | 1.6458729 × 1013 |
Variance | 6.2031762 × 1017 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 1257 | 12.6% |
2147483647 | 37 | 0.4% |
2022126580 | 1 | < 0.1% |
2022128849 | 1 | < 0.1% |
2022120265 | 1 | < 0.1% |
2022132144 | 1 | < 0.1% |
2022138059 | 1 | < 0.1% |
2022136839 | 1 | < 0.1% |
2022124357 | 1 | < 0.1% |
2022120946 | 1 | < 0.1% |
Other values (8698) | 8698 |
Value | Count | Frequency (%) |
0 | 1257 | |
1029 | 1 | < 0.1% |
1031 | 1 | < 0.1% |
1032 | 1 | < 0.1% |
1034 | 1 | < 0.1% |
1039 | 1 | < 0.1% |
1040 | 1 | < 0.1% |
1044 | 1 | < 0.1% |
1046 | 1 | < 0.1% |
1047 | 1 | < 0.1% |
Value | Count | Frequency (%) |
2147483647 | 37 | |
2023040019 | 1 | < 0.1% |
2023040018 | 1 | < 0.1% |
2023040014 | 1 | < 0.1% |
2023040013 | 1 | < 0.1% |
2023040012 | 1 | < 0.1% |
2023040009 | 1 | < 0.1% |
2023040007 | 1 | < 0.1% |
2023040006 | 1 | < 0.1% |
2023040005 | 1 | < 0.1% |
가로수직경
Real number (ℝ)
HIGH CORRELATION
  ZEROS
 
Distinct | 10 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 0.002456 |
Minimum | 0 |
---|---|
Maximum | 0.5 |
Zeros | 9865 |
Zeros (%) | 98.7% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 166.0 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 0 |
95-th percentile | 0 |
Maximum | 0.5 |
Range | 0.5 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 0.024773967 |
---|---|
Coefficient of variation (CV) | 10.08712 |
Kurtosis | 179.01574 |
Mean | 0.002456 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 12.651597 |
Sum | 24.56 |
Variance | 0.00061374944 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0.0 | 9865 | |
0.1 | 68 | 0.7% |
0.4 | 18 | 0.2% |
0.12 | 13 | 0.1% |
0.2 | 12 | 0.1% |
0.3 | 11 | 0.1% |
0.15 | 5 | 0.1% |
0.25 | 4 | < 0.1% |
0.35 | 3 | < 0.1% |
0.5 | 1 | < 0.1% |
Value | Count | Frequency (%) |
0.0 | 9865 | |
0.1 | 68 | 0.7% |
0.12 | 13 | 0.1% |
0.15 | 5 | 0.1% |
0.2 | 12 | 0.1% |
0.25 | 4 | < 0.1% |
0.3 | 11 | 0.1% |
0.35 | 3 | < 0.1% |
0.4 | 18 | 0.2% |
0.5 | 1 | < 0.1% |
Value | Count | Frequency (%) |
0.5 | 1 | < 0.1% |
0.4 | 18 | 0.2% |
0.35 | 3 | < 0.1% |
0.3 | 11 | 0.1% |
0.25 | 4 | < 0.1% |
0.2 | 12 | 0.1% |
0.15 | 5 | 0.1% |
0.12 | 13 | 0.1% |
0.1 | 68 | 0.7% |
0.0 | 9865 |
관할지역
Categorical
HIGH CORRELATION
 
Distinct | 32 |
---|---|
Distinct (%) | 0.3% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
안양시 | |
---|---|
석수2동 | |
부림동 | |
관양2동 | 528 |
안양2동 | 463 |
Other values (27) |
Length
Max length | 7 |
---|---|
Median length | 4 |
Mean length | 3.6188 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 평안동 |
---|---|
2nd row | 안양7동 |
3rd row | 신촌동 |
4th row | 범계동 |
5th row | 석수1동 |
Common Values
Value | Count | Frequency (%) |
안양시 | 1783 | |
석수2동 | 937 | 9.4% |
부림동 | 572 | 5.7% |
관양2동 | 528 | 5.3% |
안양2동 | 463 | 4.6% |
관양1동 | 459 | 4.6% |
호계1동 | 425 | 4.2% |
안양7동 | 391 | 3.9% |
석수1동 | 372 | 3.7% |
석수3동 | 350 | 3.5% |
Other values (22) | 3720 |
Length
Value | Count | Frequency (%) |
안양시 | 1783 | |
석수2동 | 937 | 9.3% |
부림동 | 572 | 5.7% |
관양2동 | 528 | 5.3% |
안양2동 | 463 | 4.6% |
관양1동 | 459 | 4.6% |
호계1동 | 425 | 4.2% |
안양7동 | 391 | 3.9% |
석수1동 | 372 | 3.7% |
석수3동 | 350 | 3.5% |
Other values (23) | 3744 |
식재일자
Categorical
HIGH CORRELATION
  IMBALANCE
 
Distinct | 6 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 156.2 KiB |
2022-12-07 | |
---|---|
2012-09-01 | |
2022-01-01 | 47 |
2016-12-06 | 40 |
2019-01-01 | 18 |
Length
Max length | 10 |
---|---|
Median length | 10 |
Mean length | 10 |
Min length | 10 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2022-12-07 |
---|---|
2nd row | 2022-12-07 |
3rd row | 2022-12-07 |
4th row | 2022-12-07 |
5th row | 2022-12-07 |
Common Values
Value | Count | Frequency (%) |
2022-12-07 | 7950 | |
2012-09-01 | 1932 | 19.3% |
2022-01-01 | 47 | 0.5% |
2016-12-06 | 40 | 0.4% |
2019-01-01 | 18 | 0.2% |
2017-12-30 | 13 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2022-12-07 | 7950 | |
2012-09-01 | 1932 | 19.3% |
2022-01-01 | 47 | 0.5% |
2016-12-06 | 40 | 0.4% |
2019-01-01 | 18 | 0.2% |
2017-12-30 | 13 | 0.1% |
관리번호 | 가로수직경 | 관할지역 | 식재일자 | |
---|---|---|---|---|
관리번호 | 1.000 | 0.145 | 1.000 | 0.998 |
가로수직경 | 0.145 | 1.000 | 0.560 | 0.849 |
관할지역 | 1.000 | 0.560 | 1.000 | 0.865 |
식재일자 | 0.998 | 0.849 | 0.865 | 1.000 |
관할지역 | 식재일자 | |
---|---|---|
관할지역 | 1.000 | 0.606 |
식재일자 | 0.606 | 1.000 |
관리번호 | 가로수직경 | 관할지역 | 식재일자 | |
---|---|---|---|---|
관리번호 | 1.000 | -0.014 | 0.981 | 0.956 |
가로수직경 | -0.014 | 1.000 | 0.225 | 0.685 |
관할지역 | 0.981 | 0.225 | 1.000 | 0.606 |
식재일자 | 0.956 | 0.685 | 0.606 | 1.000 |
관리번호 | 가로수직경 | 관할지역 | 식재일자 | |
---|---|---|---|---|
1009 | 2022120946 | 0.0 | 평안동 | 2022-12-07 |
11702 | 2022132234 | 0.0 | 안양7동 | 2022-12-07 |
12833 | 2022133365 | 0.0 | 신촌동 | 2022-12-07 |
13437 | 2022134031 | 0.0 | 범계동 | 2022-12-07 |
6444 | 2022126408 | 0.0 | 석수1동 | 2022-12-07 |
17003 | 2022136589 | 0.0 | 호계1동 | 2022-12-07 |
5133 | 2022125071 | 0.0 | 안양4동 | 2022-12-07 |
22514 | 4372 | 0.0 | 안양시 | 2012-09-01 |
12428 | 2022133022 | 0.0 | 신촌동 | 2022-12-07 |
21868 | 0 | 0.0 | 안양시 | 2012-09-01 |
관리번호 | 가로수직경 | 관할지역 | 식재일자 | |
---|---|---|---|---|
15255 | 2022135219 | 0.0 | 부림동 | 2022-12-07 |
10071 | 2022129657 | 0.0 | 석수3동 | 2022-12-07 |
8167 | 2022127752 | 0.0 | 석수2동 | 2022-12-07 |
5018 | 2022124956 | 0.0 | 안양4동 | 2022-12-07 |
19091 | 4701 | 0.0 | 안양시 | 2012-09-01 |
21679 | 0 | 0.0 | 안양시 | 2012-09-01 |
21807 | 0 | 0.0 | 안양시 | 2012-09-01 |
3223 | 2022123161 | 0.0 | 관양2동 | 2022-12-07 |
4102 | 2022124040 | 0.0 | 관양1동 | 2022-12-07 |
4621 | 2022125533 | 0.0 | 안양2동 | 2022-12-07 |
Most frequently occurring
관리번호 | 가로수직경 | 관할지역 | 식재일자 | # duplicates | |
---|---|---|---|---|---|
0 | 0 | 0.0 | 안양시 | 2012-09-01 | 1257 |
1 | 2147483647 | 0.1 | 안양2동 | 2022-01-01 | 37 |