Overview

Dataset statistics

Number of variables6
Number of observations1134
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory56.6 KiB
Average record size in memory51.1 B

Variable types

Categorical2
Numeric3
DateTime1

Dataset

Description파일 다운로드
Author서울특별시
URLhttps://data.seoul.go.kr/dataList/OA-15979/S/1/datasetView.do

Alerts

기관 명 has constant value ""Constant
모델명 has constant value ""Constant
고유장치수 has 565 (49.8%) zerosZeros

Reproduction

Analysis started2024-05-04 05:50:40.724507
Analysis finished2024-05-04 05:50:43.820652
Duration3.1 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기관 명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size9.0 KiB
마포구
1134 

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 (%)
마포구 1134
100.0%

Length

2024-05-04T05:50:43.939494image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-04T05:50:44.111004image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
마포구 1134
100.0%

모델명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size9.0 KiB
WIFI-SENSOR
1134 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowWIFI-SENSOR
2nd rowWIFI-SENSOR
3rd rowWIFI-SENSOR
4th rowWIFI-SENSOR
5th rowWIFI-SENSOR

Common Values

ValueCountFrequency (%)
WIFI-SENSOR 1134
100.0%

Length

2024-05-04T05:50:44.347870image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-04T05:50:44.586750image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
wifi-sensor 1134
100.0%

시리얼
Real number (ℝ)

Distinct13
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.114671 × 1011
Minimum1.114671 × 1011
Maximum1.114671 × 1011
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.1 KiB
2024-05-04T05:50:44.859206image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.114671 × 1011
5-th percentile1.114671 × 1011
Q11.114671 × 1011
median1.114671 × 1011
Q31.114671 × 1011
95-th percentile1.114671 × 1011
Maximum1.114671 × 1011
Range13
Interquartile range (IQR)6

Descriptive statistics

Standard deviation4.0516109
Coefficient of variation (CV)3.6348042 × 10-11
Kurtosis-1.127607
Mean1.114671 × 1011
Median Absolute Deviation (MAD)3
Skewness-0.13120986
Sum1.2640369 × 1014
Variance16.415551
MonotonicityNot monotonic
2024-05-04T05:50:45.230036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
111467101301 98
8.6%
111467101304 98
8.6%
111467101314 98
8.6%
111467101305 97
8.6%
111467101313 93
8.2%
111467101310 92
8.1%
111467101311 90
 
7.9%
111467101308 87
 
7.7%
111467101306 78
 
6.9%
111467101309 78
 
6.9%
Other values (3) 225
19.8%
ValueCountFrequency (%)
111467101301 98
8.6%
111467101302 76
6.7%
111467101304 98
8.6%
111467101305 97
8.6%
111467101306 78
6.9%
111467101307 77
6.8%
111467101308 87
7.7%
111467101309 78
6.9%
111467101310 92
8.1%
111467101311 90
7.9%
ValueCountFrequency (%)
111467101314 98
8.6%
111467101313 93
8.2%
111467101312 72
6.3%
111467101311 90
7.9%
111467101310 92
8.1%
111467101309 78
6.9%
111467101308 87
7.7%
111467101307 77
6.8%
111467101306 78
6.9%
111467101305 97
8.6%

데이터요청일시
Real number (ℝ)

Distinct98
Distinct (%)8.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0240125 × 109
Minimum2.0240122 × 109
Maximum2.0240128 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.1 KiB
2024-05-04T05:50:45.629560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0240122 × 109
5-th percentile2.0240122 × 109
Q12.0240123 × 109
median2.0240125 × 109
Q32.0240127 × 109
95-th percentile2.0240128 × 109
Maximum2.0240128 × 109
Range613
Interquartile range (IQR)391

Descriptive statistics

Standard deviation193.94395
Coefficient of variation (CV)9.5821518 × 10-8
Kurtosis-1.2148014
Mean2.0240125 × 109
Median Absolute Deviation (MAD)196
Skewness-0.014086908
Sum2.2952302 × 1012
Variance37614.257
MonotonicityIncreasing
2024-05-04T05:50:46.073736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2024012516 13
 
1.1%
2024012515 13
 
1.1%
2024012522 13
 
1.1%
2024012521 13
 
1.1%
2024012520 13
 
1.1%
2024012519 13
 
1.1%
2024012518 13
 
1.1%
2024012517 13
 
1.1%
2024012820 13
 
1.1%
2024012713 13
 
1.1%
Other values (88) 1004
88.5%
ValueCountFrequency (%)
2024012209 6
0.5%
2024012210 7
0.6%
2024012211 7
0.6%
2024012212 7
0.6%
2024012213 7
0.6%
2024012214 7
0.6%
2024012215 8
0.7%
2024012216 9
0.8%
2024012217 9
0.8%
2024012218 10
0.9%
ValueCountFrequency (%)
2024012822 13
1.1%
2024012821 13
1.1%
2024012820 13
1.1%
2024012819 13
1.1%
2024012818 13
1.1%
2024012817 13
1.1%
2024012816 13
1.1%
2024012815 13
1.1%
2024012814 13
1.1%
2024012813 13
1.1%

고유장치수
Real number (ℝ)

ZEROS 

Distinct27
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.3677249
Minimum0
Maximum31
Zeros565
Zeros (%)49.8%
Negative0
Negative (%)0.0%
Memory size10.1 KiB
2024-05-04T05:50:46.392115image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q33
95-th percentile10
Maximum31
Range31
Interquartile range (IQR)3

Descriptive statistics

Standard deviation4.0573622
Coefficient of variation (CV)1.7136122
Kurtosis9.7043248
Mean2.3677249
Median Absolute Deviation (MAD)1
Skewness2.7924016
Sum2685
Variance16.462188
MonotonicityNot monotonic
2024-05-04T05:50:46.624317image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
0 565
49.8%
2 195
 
17.2%
1 87
 
7.7%
4 67
 
5.9%
3 36
 
3.2%
10 33
 
2.9%
6 27
 
2.4%
5 26
 
2.3%
8 18
 
1.6%
7 16
 
1.4%
Other values (17) 64
 
5.6%
ValueCountFrequency (%)
0 565
49.8%
1 87
 
7.7%
2 195
 
17.2%
3 36
 
3.2%
4 67
 
5.9%
5 26
 
2.3%
6 27
 
2.4%
7 16
 
1.4%
8 18
 
1.6%
9 11
 
1.0%
ValueCountFrequency (%)
31 1
 
0.1%
28 1
 
0.1%
26 1
 
0.1%
24 2
0.2%
22 1
 
0.1%
21 4
0.4%
20 3
0.3%
19 2
0.2%
18 4
0.4%
17 1
 
0.1%

등록일자
Date

Distinct235
Distinct (%)20.7%
Missing0
Missing (%)0.0%
Memory size9.0 KiB
Minimum2024-01-22 09:09:05
Maximum2024-01-28 22:08:46
2024-05-04T05:50:47.031381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T05:50:47.445021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-05-04T05:50:42.351271image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T05:50:40.968945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T05:50:41.687781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T05:50:42.629208image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T05:50:41.239081image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T05:50:41.873234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T05:50:42.899599image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T05:50:41.510063image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T05:50:42.077160image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-04T05:50:47.672097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시리얼데이터요청일시고유장치수
시리얼1.0000.0000.331
데이터요청일시0.0001.0000.117
고유장치수0.3310.1171.000
2024-05-04T05:50:47.848727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시리얼데이터요청일시고유장치수
시리얼1.000-0.009-0.157
데이터요청일시-0.0091.0000.025
고유장치수-0.1570.0251.000

Missing values

2024-05-04T05:50:43.377060image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-04T05:50:43.596422image/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

기관 명모델명시리얼데이터요청일시고유장치수등록일자
0마포구WIFI-SENSOR1114671013052024012209102024-01-22 09:09:05
1마포구WIFI-SENSOR111467101301202401220922024-01-22 09:09:05
2마포구WIFI-SENSOR1114671013042024012209102024-01-22 09:09:05
3마포구WIFI-SENSOR1114671013142024012209102024-01-22 09:09:06
4마포구WIFI-SENSOR111467101310202401220922024-01-22 09:09:06
5마포구WIFI-SENSOR1114671013112024012209102024-01-22 09:09:06
6마포구WIFI-SENSOR111467101301202401221022024-01-22 10:09:00
7마포구WIFI-SENSOR111467101304202401221002024-01-22 10:09:00
8마포구WIFI-SENSOR111467101305202401221002024-01-22 10:09:00
9마포구WIFI-SENSOR111467101310202401221002024-01-22 10:09:00
기관 명모델명시리얼데이터요청일시고유장치수등록일자
1124마포구WIFI-SENSOR111467101304202401282202024-01-28 22:08:45
1125마포구WIFI-SENSOR111467101305202401282202024-01-28 22:08:45
1126마포구WIFI-SENSOR111467101306202401282202024-01-28 22:08:45
1127마포구WIFI-SENSOR111467101307202401282222024-01-28 22:08:45
1128마포구WIFI-SENSOR111467101312202401282202024-01-28 22:08:46
1129마포구WIFI-SENSOR111467101313202401282202024-01-28 22:08:46
1130마포구WIFI-SENSOR111467101314202401282202024-01-28 22:08:46
1131마포구WIFI-SENSOR111467101309202401282222024-01-28 22:08:46
1132마포구WIFI-SENSOR111467101311202401282202024-01-28 22:08:46
1133마포구WIFI-SENSOR111467101310202401282202024-01-28 22:08:46