Overview

Dataset statistics

Number of variables13
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.1 MiB
Average record size in memory117.0 B

Variable types

Numeric2
Categorical8
DateTime3

Dataset

Description광주광역시 서구 주정차단속문자알림서비스시스템에 등록된 회원정보에 대한 등록일자, 탈퇴일자, 이동일자 등에 대한 정보입니다.
Author광주광역시 서구
URLhttps://www.data.go.kr/data/15039687/fileData.do

Alerts

장비타입 has constant value ""Constant
사용여부 has constant value ""Constant
지역코드 has constant value ""Constant
지역코드1 has constant value ""Constant
지역코드2 has constant value ""Constant
푸쉬사용여부 has constant value ""Constant
공지사항사용여부 has constant value ""Constant
고유번호 is highly overall correlated with 일련번호High correlation
일련번호 is highly overall correlated with 고유번호High correlation
일련번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 14:37:11.055709
Analysis finished2023-12-12 14:37:12.262113
Duration1.21 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

고유번호
Real number (ℝ)

HIGH CORRELATION 

Distinct9984
Distinct (%)99.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19423.063
Minimum0
Maximum39118
Zeros1
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T23:37:12.327975image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1968.9
Q19698.75
median19421.5
Q329075
95-th percentile37071.2
Maximum39118
Range39118
Interquartile range (IQR)19376.25

Descriptive statistics

Standard deviation11264.153
Coefficient of variation (CV)0.57993699
Kurtosis-1.1936071
Mean19423.063
Median Absolute Deviation (MAD)9702
Skewness0.0099038384
Sum1.9423063 × 108
Variance1.2688114 × 108
MonotonicityNot monotonic
2023-12-12T23:37:12.543992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
12801 3
 
< 0.1%
4974 3
 
< 0.1%
34149 2
 
< 0.1%
22247 2
 
< 0.1%
24967 2
 
< 0.1%
26336 2
 
< 0.1%
27947 2
 
< 0.1%
12804 2
 
< 0.1%
37446 2
 
< 0.1%
16210 2
 
< 0.1%
Other values (9974) 9978
99.8%
ValueCountFrequency (%)
0 1
< 0.1%
7 1
< 0.1%
13 1
< 0.1%
15 1
< 0.1%
16 1
< 0.1%
28 1
< 0.1%
29 1
< 0.1%
30 1
< 0.1%
31 1
< 0.1%
32 1
< 0.1%
ValueCountFrequency (%)
39118 1
< 0.1%
39112 1
< 0.1%
39111 1
< 0.1%
39107 1
< 0.1%
39094 1
< 0.1%
39093 1
< 0.1%
39089 1
< 0.1%
39080 1
< 0.1%
39079 1
< 0.1%
39077 1
< 0.1%

장비타입
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
cctvcarchk
10000 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
cctvcarchk 10000
100.0%

Length

2023-12-12T23:37:12.726639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:37:12.840734image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
cctvcarchk 10000
100.0%

사용여부
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
1
10000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 10000
100.0%

Length

2023-12-12T23:37:12.934932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:37:13.035304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 10000
100.0%

등록일자
Date

Distinct9549
Distinct (%)95.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2015-03-09 19:18:00
Maximum2019-09-30 16:53:00
2023-12-12T23:37:13.171405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:37:13.333631image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

탈퇴일자
Date

Distinct9764
Distinct (%)97.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2015-03-09 18:59:00
Maximum2019-09-30 16:51:00
2023-12-12T23:37:13.488516image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:37:13.635368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

이동일자
Date

Distinct9549
Distinct (%)95.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2015-03-09 19:18:00
Maximum2019-09-30 16:53:00
2023-12-12T23:37:13.797167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:37:14.002859image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

이동타입
Categorical

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
MOD
8601 
DEL
1399 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowDEL
2nd rowDEL
3rd rowMOD
4th rowMOD
5th rowDEL

Common Values

ValueCountFrequency (%)
MOD 8601
86.0%
DEL 1399
 
14.0%

Length

2023-12-12T23:37:14.170858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:37:14.275658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
mod 8601
86.0%
del 1399
 
14.0%

지역코드
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
gjseogu
10000 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
gjseogu 10000
100.0%

Length

2023-12-12T23:37:14.402288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:37:14.507734image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
gjseogu 10000
100.0%

일련번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19525.603
Minimum1
Maximum39317
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T23:37:14.635107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1971.9
Q19727.75
median19531.5
Q329242
95-th percentile37263.2
Maximum39317
Range39316
Interquartile range (IQR)19514.25

Descriptive statistics

Standard deviation11330.338
Coefficient of variation (CV)0.58028111
Kurtosis-1.1953434
Mean19525.603
Median Absolute Deviation (MAD)9772
Skewness0.0085437524
Sum1.9525602 × 108
Variance1.2837656 × 108
MonotonicityNot monotonic
2023-12-12T23:37:14.802810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20357 1
 
< 0.1%
24448 1
 
< 0.1%
25006 1
 
< 0.1%
22727 1
 
< 0.1%
23691 1
 
< 0.1%
32525 1
 
< 0.1%
38936 1
 
< 0.1%
23711 1
 
< 0.1%
1790 1
 
< 0.1%
4141 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
1 1
< 0.1%
8 1
< 0.1%
14 1
< 0.1%
16 1
< 0.1%
17 1
< 0.1%
29 1
< 0.1%
30 1
< 0.1%
31 1
< 0.1%
32 1
< 0.1%
33 1
< 0.1%
ValueCountFrequency (%)
39317 1
< 0.1%
39311 1
< 0.1%
39310 1
< 0.1%
39306 1
< 0.1%
39293 1
< 0.1%
39292 1
< 0.1%
39288 1
< 0.1%
39279 1
< 0.1%
39278 1
< 0.1%
39276 1
< 0.1%

지역코드1
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
gjseogu
10000 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
gjseogu 10000
100.0%

Length

2023-12-12T23:37:14.946344image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:37:15.031288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
gjseogu 10000
100.0%

지역코드2
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
gjseogu
10000 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
gjseogu 10000
100.0%

Length

2023-12-12T23:37:15.120784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:37:15.205604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
gjseogu 10000
100.0%

푸쉬사용여부
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
10000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 10000
100.0%

Length

2023-12-12T23:37:15.322758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:37:15.417971image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 10000
100.0%

공지사항사용여부
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
10000 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 10000
100.0%

Length

2023-12-12T23:37:15.510237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:37:15.615718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 10000
100.0%

Interactions

2023-12-12T23:37:11.737194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:37:11.544766image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:37:11.832483image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:37:11.639610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:37:15.676538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
고유번호이동타입일련번호
고유번호1.0000.0631.000
이동타입0.0631.0000.061
일련번호1.0000.0611.000
2023-12-12T23:37:15.778368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
고유번호일련번호이동타입
고유번호1.0001.0000.048
일련번호1.0001.0000.047
이동타입0.0480.0471.000

Missing values

2023-12-12T23:37:11.962815image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:37:12.176437image/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

고유번호장비타입사용여부등록일자탈퇴일자이동일자이동타입지역코드일련번호지역코드1지역코드2푸쉬사용여부공지사항사용여부
2035620245cctvcarchk12018-06-18 10:072017-11-27 17:192018-06-18 10:07DELgjseogu20357gjseogugjseogu00
1500014908cctvcarchk12017-12-26 07:392017-11-25 21:402017-12-26 07:39DELgjseogu15001gjseogugjseogu00
2567325517cctvcarchk12018-11-23 19:182016-07-07 15:472018-11-23 19:18MODgjseogu25674gjseogugjseogu00
1160811572cctvcarchk12017-08-23 17:412017-07-27 19:502017-08-23 17:41MODgjseogu11609gjseogugjseogu00
3170931538cctvcarchk12019-04-10 15:592017-02-15 10:382019-04-10 15:59DELgjseogu31710gjseogugjseogu00
46154608cctvcarchk12016-10-21 18:272016-10-21 18:262016-10-21 18:27MODgjseogu4616gjseogugjseogu00
3110130931cctvcarchk12019-03-30 21:192016-11-10 17:082019-03-30 21:19MODgjseogu31102gjseogugjseogu00
1729217187cctvcarchk12018-03-13 18:302018-03-04 23:342018-03-13 18:30MODgjseogu17293gjseogugjseogu00
1859918491cctvcarchk12018-04-19 17:052018-01-31 16:592018-04-19 17:05MODgjseogu18600gjseogugjseogu00
2554725391cctvcarchk12018-11-20 20:332018-06-04 15:142018-11-20 20:33MODgjseogu25548gjseogugjseogu00
고유번호장비타입사용여부등록일자탈퇴일자이동일자이동타입지역코드일련번호지역코드1지역코드2푸쉬사용여부공지사항사용여부
1251212472cctvcarchk12017-09-25 12:182016-05-23 20:522017-09-25 12:18MODgjseogu12513gjseogugjseogu00
3547735289cctvcarchk12019-07-02 21:022019-07-02 21:022019-07-02 21:02MODgjseogu35478gjseogugjseogu00
1566815572cctvcarchk12018-01-17 16:062017-11-27 11:232018-01-17 16:06MODgjseogu15669gjseogugjseogu00
1350613425cctvcarchk12017-11-03 14:002015-04-15 23:552017-11-03 14:00DELgjseogu13507gjseogugjseogu00
3495534773cctvcarchk12019-06-21 20:312019-06-21 19:542019-06-21 20:31MODgjseogu34956gjseogugjseogu00
75597541cctvcarchk12017-03-01 18:562016-09-28 20:442017-03-01 18:56MODgjseogu7560gjseogugjseogu00
75647546cctvcarchk12017-03-02 00:092017-02-20 19:382017-03-02 00:09MODgjseogu7565gjseogugjseogu00
2688926731cctvcarchk12018-12-23 10:492018-12-23 10:492018-12-23 10:49MODgjseogu26890gjseogugjseogu00
61276115cctvcarchk12017-01-02 20:482015-09-24 12:592017-01-02 20:48DELgjseogu6128gjseogugjseogu00
1017810148cctvcarchk12017-06-27 21:562017-02-27 07:132017-06-27 21:56MODgjseogu10179gjseogugjseogu00