Overview

Dataset statistics

Number of variables6
Number of observations25
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.4 KiB
Average record size in memory56.1 B

Variable types

Categorical3
Numeric2
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 11 (44.0%) zerosZeros

Reproduction

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

Variables

기관 명
Categorical

CONSTANT 

Distinct1
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size328.0 B
마포구
25 

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

Length

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

Common Values (Plot)

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

모델명
Categorical

CONSTANT 

Distinct1
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size328.0 B
WIFI-SENSOR
25 

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

Length

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

Common Values (Plot)

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

시리얼
Real number (ℝ)

Distinct13
Distinct (%)52.0%
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 size353.0 B
2024-05-12T01:17:18.489062image/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.9572718
Coefficient of variation (CV)3.5501702 × 10-11
Kurtosis-0.91797744
Mean1.114671 × 1011
Median Absolute Deviation (MAD)3
Skewness-0.2267139
Sum2.7866775 × 1012
Variance15.66
MonotonicityNot monotonic
2024-05-12T01:17:18.873524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
111467101304 2
 
8.0%
111467101301 2
 
8.0%
111467101305 2
 
8.0%
111467101312 2
 
8.0%
111467101309 2
 
8.0%
111467101310 2
 
8.0%
111467101311 2
 
8.0%
111467101308 2
 
8.0%
111467101306 2
 
8.0%
111467101307 2
 
8.0%
Other values (3) 5
20.0%
ValueCountFrequency (%)
111467101301 2
8.0%
111467101302 1
4.0%
111467101304 2
8.0%
111467101305 2
8.0%
111467101306 2
8.0%
111467101307 2
8.0%
111467101308 2
8.0%
111467101309 2
8.0%
111467101310 2
8.0%
111467101311 2
8.0%
ValueCountFrequency (%)
111467101314 2
8.0%
111467101313 2
8.0%
111467101312 2
8.0%
111467101311 2
8.0%
111467101310 2
8.0%
111467101309 2
8.0%
111467101308 2
8.0%
111467101307 2
8.0%
111467101306 2
8.0%
111467101305 2
8.0%

데이터요청일시
Categorical

Distinct2
Distinct (%)8.0%
Missing0
Missing (%)0.0%
Memory size328.0 B
2023122612
13 
2023122611
12 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023122611
2nd row2023122611
3rd row2023122611
4th row2023122611
5th row2023122611

Common Values

ValueCountFrequency (%)
2023122612 13
52.0%
2023122611 12
48.0%

Length

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

Common Values (Plot)

2024-05-12T01:17:19.570199image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023122612 13
52.0%
2023122611 12
48.0%

고유장치수
Real number (ℝ)

ZEROS 

Distinct7
Distinct (%)28.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.04
Minimum0
Maximum11
Zeros11
Zeros (%)44.0%
Negative0
Negative (%)0.0%
Memory size353.0 B
2024-05-12T01:17:19.864537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q32
95-th percentile9.8
Maximum11
Range11
Interquartile range (IQR)2

Descriptive statistics

Standard deviation3.1685959
Coefficient of variation (CV)1.5532333
Kurtosis3.487876
Mean2.04
Median Absolute Deviation (MAD)1
Skewness2.0871756
Sum51
Variance10.04
MonotonicityNot monotonic
2024-05-12T01:17:20.212318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
0 11
44.0%
2 8
32.0%
1 2
 
8.0%
11 1
 
4.0%
10 1
 
4.0%
3 1
 
4.0%
9 1
 
4.0%
ValueCountFrequency (%)
0 11
44.0%
1 2
 
8.0%
2 8
32.0%
3 1
 
4.0%
9 1
 
4.0%
10 1
 
4.0%
11 1
 
4.0%
ValueCountFrequency (%)
11 1
 
4.0%
10 1
 
4.0%
9 1
 
4.0%
3 1
 
4.0%
2 8
32.0%
1 2
 
8.0%
0 11
44.0%

등록일자
Date

Distinct6
Distinct (%)24.0%
Missing0
Missing (%)0.0%
Memory size328.0 B
Minimum2023-12-26 11:10:07
Maximum2023-12-26 12:10:08
2024-05-12T01:17:20.535286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:20.875367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)

Interactions

2024-05-12T01:17:15.995506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:15.491083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:16.244900image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-12T01:17:15.753705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-12T01:17:21.118958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시리얼데이터요청일시고유장치수등록일자
시리얼1.0000.0000.5920.573
데이터요청일시0.0001.0000.2921.000
고유장치수0.5920.2921.0000.430
등록일자0.5731.0000.4301.000
2024-05-12T01:17:21.378093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시리얼고유장치수데이터요청일시
시리얼1.000-0.1950.000
고유장치수-0.1951.0000.323
데이터요청일시0.0000.3231.000

Missing values

2024-05-12T01:17:16.569018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-12T01:17:16.928606image/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-SENSOR111467101304202312261122023-12-26 11:10:07
1마포구WIFI-SENSOR111467101301202312261102023-12-26 11:10:07
2마포구WIFI-SENSOR111467101305202312261102023-12-26 11:10:07
3마포구WIFI-SENSOR111467101312202312261102023-12-26 11:10:08
4마포구WIFI-SENSOR111467101309202312261102023-12-26 11:10:08
5마포구WIFI-SENSOR1114671013102023122611112023-12-26 11:10:08
6마포구WIFI-SENSOR111467101311202312261122023-12-26 11:10:08
7마포구WIFI-SENSOR1114671013082023122611102023-12-26 11:10:08
8마포구WIFI-SENSOR111467101306202312261102023-12-26 11:10:08
9마포구WIFI-SENSOR111467101307202312261112023-12-26 11:10:08
기관 명모델명시리얼데이터요청일시고유장치수등록일자
15마포구WIFI-SENSOR111467101310202312261222023-12-26 12:10:07
16마포구WIFI-SENSOR111467101305202312261222023-12-26 12:10:07
17마포구WIFI-SENSOR111467101306202312261222023-12-26 12:10:07
18마포구WIFI-SENSOR111467101307202312261222023-12-26 12:10:07
19마포구WIFI-SENSOR111467101308202312261292023-12-26 12:10:07
20마포구WIFI-SENSOR111467101309202312261222023-12-26 12:10:07
21마포구WIFI-SENSOR111467101313202312261202023-12-26 12:10:08
22마포구WIFI-SENSOR111467101311202312261222023-12-26 12:10:08
23마포구WIFI-SENSOR111467101312202312261202023-12-26 12:10:08
24마포구WIFI-SENSOR111467101314202312261202023-12-26 12:10:08