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
Categorical4
DateTime4

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.6%)Imbalance
번호 has unique valuesUnique

Reproduction

Analysis started2024-01-28 11:19:37.248828
Analysis finished2024-01-28 11:19:38.041580
Duration0.79 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%
Mean46648.706
Minimum14
Maximum93049
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-01-28T20:19:38.106831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum14
5-th percentile4420.95
Q123249.5
median46778
Q370166.5
95-th percentile88123.7
Maximum93049
Range93035
Interquartile range (IQR)46917

Descriptive statistics

Standard deviation26882.357
Coefficient of variation (CV)0.5762723
Kurtosis-1.2054775
Mean46648.706
Median Absolute Deviation (MAD)23459.5
Skewness-0.011524921
Sum4.6648706 × 108
Variance7.2266111 × 108
MonotonicityNot monotonic
2024-01-28T20:19:38.222030image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
86859 1
 
< 0.1%
2692 1
 
< 0.1%
31957 1
 
< 0.1%
4919 1
 
< 0.1%
46042 1
 
< 0.1%
66316 1
 
< 0.1%
91879 1
 
< 0.1%
56008 1
 
< 0.1%
54753 1
 
< 0.1%
71052 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
14 1
< 0.1%
20 1
< 0.1%
23 1
< 0.1%
27 1
< 0.1%
28 1
< 0.1%
52 1
< 0.1%
66 1
< 0.1%
81 1
< 0.1%
89 1
< 0.1%
92 1
< 0.1%
ValueCountFrequency (%)
93049 1
< 0.1%
93040 1
< 0.1%
93037 1
< 0.1%
93036 1
< 0.1%
93017 1
< 0.1%
92990 1
< 0.1%
92985 1
< 0.1%
92969 1
< 0.1%
92961 1
< 0.1%
92956 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:38.325844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T20:19:38.396803image/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:38.463562image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T20:19:38.529967image/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:38.596522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

발송상태
Categorical

IMBALANCE 

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
전송성공
9815 
기타에러
 
93
실패
 
57
메시지유효시간초과
 
17
비가입,결번,서비스정지
 
15

Length

Max length12
Median length4
Mean length4.0115
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
전송성공 9815
98.2%
기타에러 93
 
0.9%
실패 57
 
0.6%
메시지유효시간초과 17
 
0.2%
비가입,결번,서비스정지 15
 
0.1%
단말기전원꺼짐,음영지역 3
 
< 0.1%

Length

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

Common Values (Plot)

2024-01-28T20:19:38.807240image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전송성공 9815
98.2%
기타에러 93
 
0.9%
실패 57
 
0.6%
메시지유효시간초과 17
 
0.2%
비가입,결번,서비스정지 15
 
0.1%
단말기전원꺼짐,음영지역 3
 
< 0.1%

등록일
Date

Distinct9455
Distinct (%)94.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2021-01-04 11:50:00
Maximum2022-08-31 23:26:00
2024-01-28T20:19:38.917707image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T20:19:39.034717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

발송예정일
Date

Distinct9459
Distinct (%)94.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2021-01-04 11:50:00
Maximum2022-08-31 23:26:00
2024-01-28T20:19:39.131622image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T20:19:39.235988image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

발송완료일
Date

Distinct9459
Distinct (%)94.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2021-01-04 11:50:00
Maximum2022-08-31 23:26:00
2024-01-28T20:19:39.337954image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T20:19:39.449083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2022-09-15 00:00:00
Maximum2022-09-15 00:00:00
2024-01-28T20:19:39.548655image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T20:19:39.629296image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

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

Correlations

2024-01-28T20:19:39.681571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호발송상태
번호1.0000.153
발송상태0.1531.000
2024-01-28T20:19:39.742929image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호발송상태
번호1.0000.081
발송상태0.0811.000

Missing values

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

번호발신번호메시지 종류발송건수발송상태등록일발송예정일발송완료일데이터기준일자
8685886859032-560-5940SMS1전송성공2022-07-21 23:062022-07-21 23:062022-07-21 23:062022-09-15
6862168622032-560-5940SMS1전송성공2022-04-12 17:112022-04-12 17:112022-04-12 17:112022-09-15
3658936590032-560-5940SMS1전송성공2021-09-19 14:022021-09-19 14:022021-09-19 14:022022-09-15
6423364234032-560-5940SMS1전송성공2022-03-16 10:452022-03-16 10:452022-03-16 10:452022-09-15
4354243543032-560-5940SMS1전송성공2021-11-03 10:522021-11-03 10:522021-11-03 10:522022-09-15
7356673567032-560-5940SMS1전송성공2022-05-13 18:422022-05-13 18:422022-05-13 18:422022-09-15
7859778598032-560-5940SMS1전송성공2022-06-10 22:582022-06-10 22:582022-06-10 22:582022-09-15
6651066511032-560-5940SMS1전송성공2022-03-29 19:012022-03-29 19:012022-03-29 19:012022-09-15
8763387634032-560-5940SMS1전송성공2022-07-27 09:092022-07-27 09:092022-07-27 09:092022-09-15
7062270623032-560-5940SMS1전송성공2022-04-25 18:092022-04-25 18:092022-04-25 18:092022-09-15
번호발신번호메시지 종류발송건수발송상태등록일발송예정일발송완료일데이터기준일자
8018980190032-560-5940SMS1전송성공2022-06-19 08:552022-06-19 08:552022-06-19 08:552022-09-15
3777837779032-560-5940SMS1전송성공2021-09-28 13:542021-09-28 13:552021-09-28 13:552022-09-15
2278722788032-560-5940SMS1전송성공2021-07-16 16:472021-07-16 16:472021-07-16 16:472022-09-15
3362233623032-560-5940SMS1전송성공2021-08-31 20:232021-08-31 20:232021-08-31 20:232022-09-15
1999119992032-560-5940SMS1전송성공2021-06-25 17:182021-06-25 17:182021-06-25 17:182022-09-15
9006990070032-560-5940SMS1전송성공2022-08-12 15:282022-08-12 15:282022-08-12 15:282022-09-15
1380213803032-560-5940SMS1전송성공2021-05-04 09:542021-05-04 09:542021-05-04 09:542022-09-15
3196331964032-560-5940SMS1전송성공2021-08-21 14:062021-08-21 14:062021-08-21 14:062022-09-15
2845128452032-560-5940SMS1전송성공2021-08-30 15:152021-08-30 15:152021-08-30 15:152022-09-15
7803678037032-560-5940SMS1전송성공2022-06-10 00:042022-06-10 00:042022-06-10 00:042022-09-15