Overview

Dataset statistics

Number of variables6
Number of observations1126
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory56.2 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 535 (47.5%) zerosZeros

Reproduction

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

Variables

기관 명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
마포구
1126 

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

Length

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

Common Values (Plot)

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

모델명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
WIFI-SENSOR
1126 

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

Length

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

Common Values (Plot)

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

시리얼
Real number (ℝ)

Distinct13
Distinct (%)1.2%
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.0 KiB
2024-05-12T01:17:43.441370image/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.9753597
Coefficient of variation (CV)3.5663973 × 10-11
Kurtosis-1.1079762
Mean1.114671 × 1011
Median Absolute Deviation (MAD)3
Skewness-0.09305941
Sum1.2551196 × 1014
Variance15.803485
MonotonicityNot monotonic
2024-05-12T01:17:43.829844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
111467101311 98
8.7%
111467101304 98
8.7%
111467101305 95
8.4%
111467101310 94
8.3%
111467101302 91
8.1%
111467101301 91
8.1%
111467101307 88
 
7.8%
111467101314 84
 
7.5%
111467101308 82
 
7.3%
111467101306 81
 
7.2%
Other values (3) 224
19.9%
ValueCountFrequency (%)
111467101301 91
8.1%
111467101302 91
8.1%
111467101304 98
8.7%
111467101305 95
8.4%
111467101306 81
7.2%
111467101307 88
7.8%
111467101308 82
7.3%
111467101309 78
6.9%
111467101310 94
8.3%
111467101311 98
8.7%
ValueCountFrequency (%)
111467101314 84
7.5%
111467101313 72
6.4%
111467101312 74
6.6%
111467101311 98
8.7%
111467101310 94
8.3%
111467101309 78
6.9%
111467101308 82
7.3%
111467101307 88
7.8%
111467101306 81
7.2%
111467101305 95
8.4%

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

Distinct98
Distinct (%)8.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0240173 × 109
Minimum2.0240129 × 109
Maximum2.0240204 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.0 KiB
2024-05-12T01:17:44.236170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0240129 × 109
5-th percentile2.0240129 × 109
Q12.024013 × 109
median2.0240201 × 109
Q32.0240203 × 109
95-th percentile2.0240204 × 109
Maximum2.0240204 × 109
Range7513
Interquartile range (IQR)7291

Descriptive statistics

Standard deviation3559.0839
Coefficient of variation (CV)1.7584256 × 10-6
Kurtosis-1.8534815
Mean2.0240173 × 109
Median Absolute Deviation (MAD)296
Skewness-0.38284203
Sum2.2790435 × 1012
Variance12667078
MonotonicityIncreasing
2024-05-12T01:17:44.694370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2024020221 13
 
1.2%
2024013117 13
 
1.2%
2024020218 13
 
1.2%
2024020217 13
 
1.2%
2024020216 13
 
1.2%
2024020215 13
 
1.2%
2024020214 13
 
1.2%
2024020213 13
 
1.2%
2024020212 13
 
1.2%
2024020211 13
 
1.2%
Other values (88) 996
88.5%
ValueCountFrequency (%)
2024012909 6
0.5%
2024012910 7
0.6%
2024012911 9
0.8%
2024012912 10
0.9%
2024012913 10
0.9%
2024012914 10
0.9%
2024012915 10
0.9%
2024012916 10
0.9%
2024012917 10
0.9%
2024012918 11
1.0%
ValueCountFrequency (%)
2024020422 12
1.1%
2024020421 12
1.1%
2024020420 12
1.1%
2024020419 12
1.1%
2024020418 12
1.1%
2024020417 12
1.1%
2024020416 12
1.1%
2024020415 12
1.1%
2024020414 12
1.1%
2024020413 12
1.1%

고유장치수
Real number (ℝ)

ZEROS 

Distinct26
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.2806394
Minimum0
Maximum40
Zeros535
Zeros (%)47.5%
Negative0
Negative (%)0.0%
Memory size10.0 KiB
2024-05-12T01:17:45.099131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q32
95-th percentile10
Maximum40
Range40
Interquartile range (IQR)2

Descriptive statistics

Standard deviation4.0725987
Coefficient of variation (CV)1.7857267
Kurtosis17.883862
Mean2.2806394
Median Absolute Deviation (MAD)1
Skewness3.5745378
Sum2568
Variance16.58606
MonotonicityNot monotonic
2024-05-12T01:17:45.649055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%)
0 535
47.5%
2 220
19.5%
1 103
 
9.1%
4 63
 
5.6%
3 41
 
3.6%
6 37
 
3.3%
10 27
 
2.4%
8 18
 
1.6%
7 16
 
1.4%
5 16
 
1.4%
Other values (16) 50
 
4.4%
ValueCountFrequency (%)
0 535
47.5%
1 103
 
9.1%
2 220
19.5%
3 41
 
3.6%
4 63
 
5.6%
5 16
 
1.4%
6 37
 
3.3%
7 16
 
1.4%
8 18
 
1.6%
9 5
 
0.4%
ValueCountFrequency (%)
40 1
 
0.1%
30 2
 
0.2%
28 2
 
0.2%
26 1
 
0.1%
24 2
 
0.2%
22 1
 
0.1%
20 8
0.7%
19 1
 
0.1%
18 1
 
0.1%
16 4
0.4%

등록일자
Date

Distinct231
Distinct (%)20.5%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
Minimum2024-01-29 09:08:44
Maximum2024-02-04 22:08:31
2024-05-12T01:17:46.043177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:46.462552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-05-12T01:17:40.640083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:38.968714image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:39.796757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:40.917388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:39.238103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:40.074273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:41.199833image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:39.518167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:40.355557image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-12T01:17:46.727892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시리얼데이터요청일시고유장치수
시리얼1.0000.0000.423
데이터요청일시0.0001.0000.101
고유장치수0.4230.1011.000
2024-05-12T01:17:46.969608image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시리얼데이터요청일시고유장치수
시리얼1.000-0.007-0.114
데이터요청일시-0.0071.0000.042
고유장치수-0.1140.0421.000

Missing values

2024-05-12T01:17:41.567755image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-12T01:17:41.919199image/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-SENSOR1114671013022024012909202024-01-29 09:08:44
1마포구WIFI-SENSOR1114671013142024012909102024-01-29 09:08:44
2마포구WIFI-SENSOR1114671013122024012909102024-01-29 09:08:44
3마포구WIFI-SENSOR1114671013112024012909112024-01-29 09:08:44
4마포구WIFI-SENSOR111467101307202401290912024-01-29 09:08:44
5마포구WIFI-SENSOR1114671013042024012909302024-01-29 09:08:44
6마포구WIFI-SENSOR111467101310202401291012024-01-29 10:08:44
7마포구WIFI-SENSOR111467101307202401291012024-01-29 10:08:44
8마포구WIFI-SENSOR111467101304202401291022024-01-29 10:08:44
9마포구WIFI-SENSOR111467101302202401291002024-01-29 10:08:44
기관 명모델명시리얼데이터요청일시고유장치수등록일자
1116마포구WIFI-SENSOR111467101302202402042202024-02-04 22:08:29
1117마포구WIFI-SENSOR111467101305202402042202024-02-04 22:08:29
1118마포구WIFI-SENSOR111467101310202402042202024-02-04 22:08:30
1119마포구WIFI-SENSOR111467101312202402042202024-02-04 22:08:30
1120마포구WIFI-SENSOR111467101306202402042202024-02-04 22:08:30
1121마포구WIFI-SENSOR111467101307202402042232024-02-04 22:08:30
1122마포구WIFI-SENSOR111467101308202402042202024-02-04 22:08:30
1123마포구WIFI-SENSOR111467101309202402042212024-02-04 22:08:30
1124마포구WIFI-SENSOR111467101311202402042202024-02-04 22:08:30
1125마포구WIFI-SENSOR111467101313202402042202024-02-04 22:08:31