Overview

Dataset statistics

Number of variables6
Number of observations158
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.0 KiB
Average record size in memory51.8 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 65 (41.1%) zerosZeros

Reproduction

Analysis started2024-05-11 16:17:29.044040
Analysis finished2024-05-11 16:17:32.183563
Duration3.14 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기관 명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
마포구
158 

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

Length

2024-05-12T01:17:32.394709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:17:32.704932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
마포구 158
100.0%

모델명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
WIFI-SENSOR
158 

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 158
100.0%

Length

2024-05-12T01:17:33.032285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-12T01:17:33.345213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
wifi-sensor 158
100.0%

시리얼
Real number (ℝ)

Distinct12
Distinct (%)7.6%
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 size1.5 KiB
2024-05-12T01:17:33.638398image/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 deviation3.9862296
Coefficient of variation (CV)3.576149 × 10-11
Kurtosis-1.0336303
Mean1.114671 × 1011
Median Absolute Deviation (MAD)3.5
Skewness0.0052555505
Sum1.7611802 × 1013
Variance15.890027
MonotonicityNot monotonic
2024-05-12T01:17:34.019800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
111467101304 14
8.9%
111467101311 14
8.9%
111467101313 14
8.9%
111467101314 14
8.9%
111467101305 14
8.9%
111467101307 13
8.2%
111467101308 13
8.2%
111467101301 13
8.2%
111467101306 13
8.2%
111467101302 12
7.6%
Other values (2) 24
15.2%
ValueCountFrequency (%)
111467101301 13
8.2%
111467101302 12
7.6%
111467101304 14
8.9%
111467101305 14
8.9%
111467101306 13
8.2%
111467101307 13
8.2%
111467101308 13
8.2%
111467101309 12
7.6%
111467101310 12
7.6%
111467101311 14
8.9%
ValueCountFrequency (%)
111467101314 14
8.9%
111467101313 14
8.9%
111467101311 14
8.9%
111467101310 12
7.6%
111467101309 12
7.6%
111467101308 13
8.2%
111467101307 13
8.2%
111467101306 13
8.2%
111467101305 14
8.9%
111467101304 14
8.9%

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

Distinct14
Distinct (%)8.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0240113 × 109
Minimum2.0240113 × 109
Maximum2.0240113 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2024-05-12T01:17:34.388347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0240113 × 109
5-th percentile2.0240113 × 109
Q12.0240113 × 109
median2.0240113 × 109
Q32.0240113 × 109
95-th percentile2.0240113 × 109
Maximum2.0240113 × 109
Range13
Interquartile range (IQR)6

Descriptive statistics

Standard deviation3.8434085
Coefficient of variation (CV)1.8989066 × 10-9
Kurtosis-1.1651981
Mean2.0240113 × 109
Median Absolute Deviation (MAD)3
Skewness-0.036157368
Sum3.1979379 × 1011
Variance14.771789
MonotonicityIncreasing
2024-05-12T01:17:34.787246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%)
2024011311 12
 
7.6%
2024011312 12
 
7.6%
2024011313 12
 
7.6%
2024011314 12
 
7.6%
2024011315 12
 
7.6%
2024011316 12
 
7.6%
2024011317 12
 
7.6%
2024011318 12
 
7.6%
2024011319 12
 
7.6%
2024011320 12
 
7.6%
Other values (4) 38
24.1%
ValueCountFrequency (%)
2024011309 5
3.2%
2024011310 9
5.7%
2024011311 12
7.6%
2024011312 12
7.6%
2024011313 12
7.6%
2024011314 12
7.6%
2024011315 12
7.6%
2024011316 12
7.6%
2024011317 12
7.6%
2024011318 12
7.6%
ValueCountFrequency (%)
2024011322 12
7.6%
2024011321 12
7.6%
2024011320 12
7.6%
2024011319 12
7.6%
2024011318 12
7.6%
2024011317 12
7.6%
2024011316 12
7.6%
2024011315 12
7.6%
2024011314 12
7.6%
2024011313 12
7.6%

고유장치수
Real number (ℝ)

ZEROS 

Distinct15
Distinct (%)9.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.5949367
Minimum0
Maximum16
Zeros65
Zeros (%)41.1%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2024-05-12T01:17:35.143481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median2
Q34
95-th percentile10
Maximum16
Range16
Interquartile range (IQR)4

Descriptive statistics

Standard deviation3.4549659
Coefficient of variation (CV)1.3314259
Kurtosis2.8935461
Mean2.5949367
Median Absolute Deviation (MAD)2
Skewness1.7481651
Sum410
Variance11.936789
MonotonicityNot monotonic
2024-05-12T01:17:35.530040image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
0 65
41.1%
2 38
24.1%
6 11
 
7.0%
4 10
 
6.3%
1 8
 
5.1%
5 4
 
2.5%
3 4
 
2.5%
9 4
 
2.5%
10 3
 
1.9%
12 2
 
1.3%
Other values (5) 9
 
5.7%
ValueCountFrequency (%)
0 65
41.1%
1 8
 
5.1%
2 38
24.1%
3 4
 
2.5%
4 10
 
6.3%
5 4
 
2.5%
6 11
 
7.0%
7 2
 
1.3%
8 2
 
1.3%
9 4
 
2.5%
ValueCountFrequency (%)
16 1
 
0.6%
15 2
 
1.3%
12 2
 
1.3%
11 2
 
1.3%
10 3
 
1.9%
9 4
 
2.5%
8 2
 
1.3%
7 2
 
1.3%
6 11
7.0%
5 4
 
2.5%

등록일자
Date

Distinct33
Distinct (%)20.9%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2024-01-13 09:09:20
Maximum2024-01-13 22:09:21
2024-05-12T01:17:35.910926image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:36.296461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=33)

Interactions

2024-05-12T01:17:30.819698image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:29.261556image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:30.037371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:31.079999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:29.515968image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:30.296381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:31.342725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:29.772477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:30.552288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-12T01:17:36.661464image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시리얼데이터요청일시고유장치수등록일자
시리얼1.0000.0000.4640.000
데이터요청일시0.0001.0000.1681.000
고유장치수0.4640.1681.0000.655
등록일자0.0001.0000.6551.000
2024-05-12T01:17:36.910105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시리얼데이터요청일시고유장치수
시리얼1.000-0.024-0.066
데이터요청일시-0.0241.000-0.362
고유장치수-0.066-0.3621.000

Missing values

2024-05-12T01:17:31.694664image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-12T01:17:32.045233image/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-SENSOR1114671013042024011309122024-01-13 09:09:20
1마포구WIFI-SENSOR1114671013112024011309112024-01-13 09:09:21
2마포구WIFI-SENSOR1114671013132024011309102024-01-13 09:09:21
3마포구WIFI-SENSOR1114671013142024011309102024-01-13 09:09:21
4마포구WIFI-SENSOR111467101305202401130942024-01-13 09:09:21
5마포구WIFI-SENSOR111467101307202401131022024-01-13 10:09:21
6마포구WIFI-SENSOR111467101308202401131012024-01-13 10:09:21
7마포구WIFI-SENSOR111467101311202401131052024-01-13 10:09:21
8마포구WIFI-SENSOR111467101313202401131002024-01-13 10:09:21
9마포구WIFI-SENSOR111467101301202401131002024-01-13 10:09:21
기관 명모델명시리얼데이터요청일시고유장치수등록일자
148마포구WIFI-SENSOR111467101304202401132202024-01-13 22:09:19
149마포구WIFI-SENSOR111467101310202401132202024-01-13 22:09:20
150마포구WIFI-SENSOR111467101305202401132202024-01-13 22:09:20
151마포구WIFI-SENSOR111467101306202401132222024-01-13 22:09:20
152마포구WIFI-SENSOR111467101308202401132202024-01-13 22:09:20
153마포구WIFI-SENSOR111467101309202401132222024-01-13 22:09:20
154마포구WIFI-SENSOR111467101311202401132202024-01-13 22:09:20
155마포구WIFI-SENSOR111467101307202401132222024-01-13 22:09:20
156마포구WIFI-SENSOR111467101313202401132202024-01-13 22:09:21
157마포구WIFI-SENSOR111467101314202401132202024-01-13 22:09:21