Overview

Dataset statistics

Number of variables9
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory800.8 KiB
Average record size in memory82.0 B

Variable types

Numeric1
Categorical5
DateTime3

Dataset

Description인천광역시 서구 문자발송시스템 발송 현황에 대한 데이터로 발신번호, 메시지 종류, 발송건수 등의 정보가 포함되어 있습니다.(상담민원 이력 알림 관련문자)
Author인천광역시 서구
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15091238&srcSe=7661IVAWM27C61E190

Alerts

발신번호 has constant value ""Constant
메시지 종류 has constant value ""Constant
발송건수 has constant value ""Constant
데이터기준일자 has constant value ""Constant
발송상태 is highly imbalanced (93.0%)Imbalance
번호 has unique valuesUnique

Reproduction

Analysis started2024-01-28 11:19:33.006014
Analysis finished2024-01-28 11:19:33.567570
Duration0.56 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean46692.899
Minimum4
Maximum93026
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-28T20:19:33.622967image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4
5-th percentile4279.95
Q123935.75
median46827
Q369758.75
95-th percentile88358.25
Maximum93026
Range93022
Interquartile range (IQR)45823

Descriptive statistics

Standard deviation26861.837
Coefficient of variation (CV)0.5752874
Kurtosis-1.1867133
Mean46692.899
Median Absolute Deviation (MAD)22917.5
Skewness-0.019878284
Sum4.66929 × 108
Variance7.2155828 × 108
MonotonicityNot monotonic
2024-01-28T20:19:33.720935image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
79936 1
 
< 0.1%
14951 1
 
< 0.1%
64626 1
 
< 0.1%
20728 1
 
< 0.1%
22924 1
 
< 0.1%
52463 1
 
< 0.1%
86151 1
 
< 0.1%
5503 1
 
< 0.1%
53383 1
 
< 0.1%
58317 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
4 1
< 0.1%
8 1
< 0.1%
12 1
< 0.1%
15 1
< 0.1%
19 1
< 0.1%
20 1
< 0.1%
56 1
< 0.1%
57 1
< 0.1%
71 1
< 0.1%
73 1
< 0.1%
ValueCountFrequency (%)
93026 1
< 0.1%
93025 1
< 0.1%
93020 1
< 0.1%
93018 1
< 0.1%
93015 1
< 0.1%
93014 1
< 0.1%
93008 1
< 0.1%
93007 1
< 0.1%
92990 1
< 0.1%
92989 1
< 0.1%

발신번호
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
032-560-5940
10000 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row032-560-5940
2nd row032-560-5940
3rd row032-560-5940
4th row032-560-5940
5th row032-560-5940

Common Values

ValueCountFrequency (%)
032-560-5940 10000
100.0%

Length

2024-01-28T20:19:33.809967image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T20:19:33.876232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
032-560-5940 10000
100.0%

메시지 종류
Categorical

CONSTANT 

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

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
SMS 10000
100.0%

Length

2024-01-28T20:19:33.945022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T20:19:34.010589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
sms 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

2024-01-28T20:19:34.078522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T20:19:34.143540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 10000
100.0%

발송상태
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
전송성공
9816 
기타에러
 
104
실패
 
46
메시지유효시간초과
 
23
비가입,결번,서비스정지
 
11

Length

Max length12
Median length4
Mean length4.0111
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row전송성공
2nd row전송성공
3rd row전송성공
4th row전송성공
5th row전송성공

Common Values

ValueCountFrequency (%)
전송성공 9816
98.2%
기타에러 104
 
1.0%
실패 46
 
0.5%
메시지유효시간초과 23
 
0.2%
비가입,결번,서비스정지 11
 
0.1%

Length

2024-01-28T20:19:34.219455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T20:19:34.300598image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전송성공 9816
98.2%
기타에러 104
 
1.0%
실패 46
 
0.5%
메시지유효시간초과 23
 
0.2%
비가입,결번,서비스정지 11
 
0.1%

등록일
Date

Distinct9450
Distinct (%)94.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2021-01-01 15:34:00
Maximum2022-08-31 19:58:00
2024-01-28T20:19:34.392555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T20:19:34.495310image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

발송예정일
Date

Distinct9454
Distinct (%)94.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2021-01-01 15:34:00
Maximum2022-08-31 19:58:00
2024-01-28T20:19:34.594752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T20:19:34.704775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

발송완료일
Date

Distinct9454
Distinct (%)94.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2021-01-01 15:34:00
Maximum2022-08-31 19:58:00
2024-01-28T20:19:34.815798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T20:19:34.926854image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2022-09-15
10000 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-09-15
2nd row2022-09-15
3rd row2022-09-15
4th row2022-09-15
5th row2022-09-15

Common Values

ValueCountFrequency (%)
2022-09-15 10000
100.0%

Length

2024-01-28T20:19:35.019346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T20:19:35.090741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-09-15 10000
100.0%

Interactions

2024-01-28T20:19:33.316555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-28T20:19:35.131606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호발송상태
번호1.0000.211
발송상태0.2111.000
2024-01-28T20:19:35.200706image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호발송상태
번호1.0000.089
발송상태0.0891.000

Missing values

2024-01-28T20:19:33.406662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-28T20:19:33.513122image/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

번호발신번호메시지 종류발송건수발송상태등록일발송예정일발송완료일데이터기준일자
7993579936032-560-5940SMS1전송성공2022-06-17 16:502022-06-17 16:502022-06-17 16:502022-09-15
5379653797032-560-5940SMS1전송성공2022-01-08 19:302022-01-08 19:302022-01-08 19:302022-09-15
8099280993032-560-5940SMS1전송성공2022-06-21 11:452022-06-21 11:452022-06-21 11:452022-09-15
48704871032-560-5940SMS1전송성공2021-02-18 09:222021-02-18 09:222021-02-18 09:222022-09-15
88018802032-560-5940SMS1전송성공2021-03-23 10:452021-03-23 10:452021-03-23 10:452022-09-15
4421944220032-560-5940SMS1전송성공2021-11-08 09:492021-11-08 09:492021-11-08 09:492022-09-15
7172871729032-560-5940SMS1전송성공2022-05-01 08:542022-05-01 08:542022-05-01 08:542022-09-15
8646086461032-560-5940SMS1전송성공2022-07-20 12:032022-07-20 12:032022-07-20 12:032022-09-15
2853428535032-560-5940SMS1전송성공2021-08-31 09:002021-08-31 09:002021-08-31 09:002022-09-15
5369053691032-560-5940SMS1전송성공2022-01-08 10:212022-01-08 10:212022-01-08 10:212022-09-15
번호발신번호메시지 종류발송건수발송상태등록일발송예정일발송완료일데이터기준일자
5118151182032-560-5940SMS1전송성공2021-12-23 20:052021-12-23 20:052021-12-23 20:052022-09-15
6944469445032-560-5940SMS1전송성공2022-04-18 13:082022-04-18 13:082022-04-18 13:082022-09-15
2356823569032-560-5940SMS1전송성공2021-07-23 09:582021-07-23 09:582021-07-23 09:582022-09-15
3170231703032-560-5940SMS1전송성공2021-08-19 18:272021-08-19 18:272021-08-19 18:272022-09-15
8430984310032-560-5940SMS1전송성공2022-07-08 08:442022-07-08 08:452022-07-08 08:452022-09-15
2507925080032-560-5940SMS1전송성공2021-08-04 09:232021-08-04 09:232021-08-04 09:232022-09-15
2000120002032-560-5940SMS1전송성공2021-06-28 09:042021-06-28 09:042021-06-28 09:042022-09-15
5893858939032-560-5940SMS1전송성공2022-02-12 09:222022-02-12 09:222022-02-12 09:222022-09-15
7337273373032-560-5940SMS1전송성공2022-05-12 19:482022-05-12 19:482022-05-12 19:482022-09-15
4640846409032-560-5940SMS1전송성공2021-11-23 16:002021-11-23 16:002021-11-23 16:002022-09-15