Overview

Dataset statistics

Number of variables6
Number of observations378
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory19.0 KiB
Average record size in memory51.3 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 201 (53.2%) zerosZeros

Reproduction

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

Variables

기관 명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
마포구
378 

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

Length

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

Common Values (Plot)

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

모델명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
WIFI-SENSOR
378 

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

Length

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

Common Values (Plot)

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

시리얼
Real number (ℝ)

Distinct13
Distinct (%)3.4%
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 size3.4 KiB
2024-05-12T01:18:00.323809image/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.9917568
Coefficient of variation (CV)3.5811075 × 10-11
Kurtosis-1.1318273
Mean1.114671 × 1011
Median Absolute Deviation (MAD)3
Skewness-0.12077824
Sum4.2134564 × 1013
Variance15.934122
MonotonicityNot monotonic
2024-05-12T01:18:00.532904image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
111467101304 39
10.3%
111467101301 38
10.1%
111467101307 38
10.1%
111467101311 37
9.8%
111467101313 36
9.5%
111467101305 34
9.0%
111467101312 28
7.4%
111467101308 25
6.6%
111467101310 23
 
6.1%
111467101306 22
 
5.8%
Other values (3) 58
15.3%
ValueCountFrequency (%)
111467101301 38
10.1%
111467101302 17
4.5%
111467101304 39
10.3%
111467101305 34
9.0%
111467101306 22
5.8%
111467101307 38
10.1%
111467101308 25
6.6%
111467101309 21
5.6%
111467101310 23
6.1%
111467101311 37
9.8%
ValueCountFrequency (%)
111467101314 20
5.3%
111467101313 36
9.5%
111467101312 28
7.4%
111467101311 37
9.8%
111467101310 23
6.1%
111467101309 21
5.6%
111467101308 25
6.6%
111467101307 38
10.1%
111467101306 22
5.8%
111467101305 34
9.0%

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

Distinct39
Distinct (%)10.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0240206 × 109
Minimum2.0240205 × 109
Maximum2.0240207 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.4 KiB
2024-05-12T01:18:00.766290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0240205 × 109
5-th percentile2.0240205 × 109
Q12.0240205 × 109
median2.0240206 × 109
Q32.0240207 × 109
95-th percentile2.0240207 × 109
Maximum2.0240207 × 109
Range213
Interquartile range (IQR)194

Descriptive statistics

Standard deviation82.993657
Coefficient of variation (CV)4.1004353 × 10-8
Kurtosis-1.5122751
Mean2.0240206 × 109
Median Absolute Deviation (MAD)97
Skewness-0.19489694
Sum7.650798 × 1011
Variance6887.9471
MonotonicityIncreasing
2024-05-12T01:18:01.004470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=39)
ValueCountFrequency (%)
2024020721 12
 
3.2%
2024020722 12
 
3.2%
2024020720 12
 
3.2%
2024020719 12
 
3.2%
2024020718 12
 
3.2%
2024020717 12
 
3.2%
2024020716 12
 
3.2%
2024020715 12
 
3.2%
2024020622 12
 
3.2%
2024020621 12
 
3.2%
Other values (29) 258
68.3%
ValueCountFrequency (%)
2024020509 5
1.3%
2024020510 7
1.9%
2024020511 7
1.9%
2024020512 7
1.9%
2024020513 7
1.9%
2024020514 8
2.1%
2024020515 8
2.1%
2024020516 9
2.4%
2024020517 9
2.4%
2024020518 9
2.4%
ValueCountFrequency (%)
2024020722 12
3.2%
2024020721 12
3.2%
2024020720 12
3.2%
2024020719 12
3.2%
2024020718 12
3.2%
2024020717 12
3.2%
2024020716 12
3.2%
2024020715 12
3.2%
2024020714 11
2.9%
2024020713 11
2.9%

고유장치수
Real number (ℝ)

ZEROS 

Distinct21
Distinct (%)5.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.9814815
Minimum0
Maximum34
Zeros201
Zeros (%)53.2%
Negative0
Negative (%)0.0%
Memory size3.4 KiB
2024-05-12T01:18:01.351200image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q32
95-th percentile9.15
Maximum34
Range34
Interquartile range (IQR)2

Descriptive statistics

Standard deviation4.0444711
Coefficient of variation (CV)2.0411349
Kurtosis21.551126
Mean1.9814815
Median Absolute Deviation (MAD)0
Skewness4.1161058
Sum749
Variance16.357746
MonotonicityNot monotonic
2024-05-12T01:18:01.557799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
0 201
53.2%
2 93
24.6%
1 19
 
5.0%
4 14
 
3.7%
10 8
 
2.1%
3 8
 
2.1%
5 8
 
2.1%
9 5
 
1.3%
6 5
 
1.3%
7 3
 
0.8%
Other values (11) 14
 
3.7%
ValueCountFrequency (%)
0 201
53.2%
1 19
 
5.0%
2 93
24.6%
3 8
 
2.1%
4 14
 
3.7%
5 8
 
2.1%
6 5
 
1.3%
7 3
 
0.8%
8 3
 
0.8%
9 5
 
1.3%
ValueCountFrequency (%)
34 1
0.3%
28 1
0.3%
24 2
0.5%
21 1
0.3%
20 1
0.3%
19 1
0.3%
16 1
0.3%
15 1
0.3%
12 1
0.3%
11 1
0.3%

등록일자
Date

Distinct82
Distinct (%)21.7%
Missing0
Missing (%)0.0%
Memory size3.1 KiB
Minimum2024-02-05 09:08:28
Maximum2024-02-07 22:08:24
2024-05-12T01:18:01.800191image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:18:02.042308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-05-12T01:17:57.752820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:56.223867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:56.997763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:58.018072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:56.484185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:57.253361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:58.268481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:56.732692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:57.495106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-12T01:18:02.192928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시리얼데이터요청일시고유장치수등록일자
시리얼1.0000.3150.3450.000
데이터요청일시0.3151.0000.2581.000
고유장치수0.3450.2581.0000.000
등록일자0.0001.0000.0001.000
2024-05-12T01:18:02.350060image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시리얼데이터요청일시고유장치수
시리얼1.000-0.090-0.108
데이터요청일시-0.0901.0000.205
고유장치수-0.1080.2051.000

Missing values

2024-05-12T01:17:58.617140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-12T01:17:58.976464image/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-SENSOR1114671013042024020509242024-02-05 09:08:28
1마포구WIFI-SENSOR1114671013112024020509102024-02-05 09:08:28
2마포구WIFI-SENSOR1114671013122024020509102024-02-05 09:08:28
3마포구WIFI-SENSOR111467101314202402050982024-02-05 09:08:29
4마포구WIFI-SENSOR1114671013132024020509102024-02-05 09:08:29
5마포구WIFI-SENSOR111467101304202402051002024-02-05 10:08:28
6마포구WIFI-SENSOR111467101301202402051002024-02-05 10:08:28
7마포구WIFI-SENSOR111467101307202402051002024-02-05 10:08:28
8마포구WIFI-SENSOR111467101313202402051002024-02-05 10:08:29
9마포구WIFI-SENSOR111467101311202402051002024-02-05 10:08:29
기관 명모델명시리얼데이터요청일시고유장치수등록일자
368마포구WIFI-SENSOR111467101307202402072222024-02-07 22:08:23
369마포구WIFI-SENSOR111467101302202402072202024-02-07 22:08:23
370마포구WIFI-SENSOR111467101304202402072202024-02-07 22:08:23
371마포구WIFI-SENSOR111467101305202402072202024-02-07 22:08:23
372마포구WIFI-SENSOR111467101310202402072202024-02-07 22:08:23
373마포구WIFI-SENSOR111467101309202402072222024-02-07 22:08:23
374마포구WIFI-SENSOR111467101306202402072202024-02-07 22:08:23
375마포구WIFI-SENSOR111467101313202402072202024-02-07 22:08:24
376마포구WIFI-SENSOR111467101311202402072202024-02-07 22:08:24
377마포구WIFI-SENSOR111467101312202402072222024-02-07 22:08:24