Overview

Dataset statistics

Number of variables7
Number of observations365
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory21.5 KiB
Average record size in memory60.4 B

Variable types

Numeric4
Categorical1
DateTime2

Dataset

Description광주광역시 광산구청 통합문자메시징 시스템을 통한 일일 문자메시지 전송 내역 현황 정보(사용기관, 날짜, 단문, 장문, 성공갯수 등)를 제공합니다.
URLhttps://www.data.go.kr/data/15087047/fileData.do

Alerts

사용기관 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
날짜 has unique valuesUnique
단문 has 24 (6.6%) zerosZeros

Reproduction

Analysis started2023-12-12 09:51:50.864041
Analysis finished2023-12-12 09:51:53.011695
Duration2.15 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct365
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean183
Minimum1
Maximum365
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.3 KiB
2023-12-12T18:51:53.110886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile19.2
Q192
median183
Q3274
95-th percentile346.8
Maximum365
Range364
Interquartile range (IQR)182

Descriptive statistics

Standard deviation105.51066
Coefficient of variation (CV)0.576561
Kurtosis-1.2
Mean183
Median Absolute Deviation (MAD)91
Skewness0
Sum66795
Variance11132.5
MonotonicityStrictly increasing
2023-12-12T18:51:53.314785image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.3%
252 1
 
0.3%
250 1
 
0.3%
249 1
 
0.3%
248 1
 
0.3%
247 1
 
0.3%
246 1
 
0.3%
245 1
 
0.3%
244 1
 
0.3%
243 1
 
0.3%
Other values (355) 355
97.3%
ValueCountFrequency (%)
1 1
0.3%
2 1
0.3%
3 1
0.3%
4 1
0.3%
5 1
0.3%
6 1
0.3%
7 1
0.3%
8 1
0.3%
9 1
0.3%
10 1
0.3%
ValueCountFrequency (%)
365 1
0.3%
364 1
0.3%
363 1
0.3%
362 1
0.3%
361 1
0.3%
360 1
0.3%
359 1
0.3%
358 1
0.3%
357 1
0.3%
356 1
0.3%

사용기관
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
광주광역시 광산구청
365 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row광주광역시 광산구청
2nd row광주광역시 광산구청
3rd row광주광역시 광산구청
4th row광주광역시 광산구청
5th row광주광역시 광산구청

Common Values

ValueCountFrequency (%)
광주광역시 광산구청 365
100.0%

Length

2023-12-12T18:51:53.474598image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:51:53.582797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
광주광역시 365
50.0%
광산구청 365
50.0%

날짜
Date

UNIQUE 

Distinct365
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
Minimum2022-01-01 00:00:00
Maximum2022-12-31 00:00:00
2023-12-12T18:51:53.719285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:51:53.886922image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

단문
Real number (ℝ)

ZEROS 

Distinct211
Distinct (%)57.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean198.14521
Minimum0
Maximum2122
Zeros24
Zeros (%)6.6%
Negative0
Negative (%)0.0%
Memory size3.3 KiB
2023-12-12T18:51:54.064573image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q146
median212
Q3269
95-th percentile443
Maximum2122
Range2122
Interquartile range (IQR)223

Descriptive statistics

Standard deviation181.42384
Coefficient of variation (CV)0.91561052
Kurtosis34.331835
Mean198.14521
Median Absolute Deviation (MAD)109
Skewness3.7006042
Sum72323
Variance32914.608
MonotonicityNot monotonic
2023-12-12T18:51:54.202479image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 24
 
6.6%
1 10
 
2.7%
215 7
 
1.9%
158 6
 
1.6%
246 6
 
1.6%
27 6
 
1.6%
218 5
 
1.4%
2 5
 
1.4%
213 5
 
1.4%
4 5
 
1.4%
Other values (201) 286
78.4%
ValueCountFrequency (%)
0 24
6.6%
1 10
2.7%
2 5
 
1.4%
3 1
 
0.3%
4 5
 
1.4%
6 1
 
0.3%
13 1
 
0.3%
16 2
 
0.5%
18 1
 
0.3%
21 1
 
0.3%
ValueCountFrequency (%)
2122 1
0.3%
930 1
0.3%
721 1
0.3%
672 1
0.3%
655 1
0.3%
608 1
0.3%
573 1
0.3%
568 1
0.3%
546 1
0.3%
535 1
0.3%

장문
Real number (ℝ)

HIGH CORRELATION 

Distinct358
Distinct (%)98.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8714.7452
Minimum233
Maximum75339
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.3 KiB
2023-12-12T18:51:54.346485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum233
5-th percentile691
Q13403
median5638
Q39862
95-th percentile24878.4
Maximum75339
Range75106
Interquartile range (IQR)6459

Descriptive statistics

Standard deviation10281.235
Coefficient of variation (CV)1.1797517
Kurtosis17.647484
Mean8714.7452
Median Absolute Deviation (MAD)3003
Skewness3.6815454
Sum3180882
Variance1.057038 × 108
MonotonicityNot monotonic
2023-12-12T18:51:54.539148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2636 2
 
0.5%
5530 2
 
0.5%
3964 2
 
0.5%
4434 2
 
0.5%
5197 2
 
0.5%
352 2
 
0.5%
7456 2
 
0.5%
7800 1
 
0.3%
1382 1
 
0.3%
3103 1
 
0.3%
Other values (348) 348
95.3%
ValueCountFrequency (%)
233 1
0.3%
346 1
0.3%
352 2
0.5%
354 1
0.3%
444 1
0.3%
448 1
0.3%
454 1
0.3%
495 1
0.3%
504 1
0.3%
516 1
0.3%
ValueCountFrequency (%)
75339 1
0.3%
72187 1
0.3%
70207 1
0.3%
69017 1
0.3%
66019 1
0.3%
48642 1
0.3%
43452 1
0.3%
40144 1
0.3%
36100 1
0.3%
34519 1
0.3%

성공갯수
Real number (ℝ)

HIGH CORRELATION 

Distinct359
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8912.8904
Minimum233
Maximum75602
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.3 KiB
2023-12-12T18:51:54.702280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum233
5-th percentile743.8
Q13567
median5945
Q310305
95-th percentile24963.8
Maximum75602
Range75369
Interquartile range (IQR)6738

Descriptive statistics

Standard deviation10311.298
Coefficient of variation (CV)1.1568972
Kurtosis17.524336
Mean8912.8904
Median Absolute Deviation (MAD)3080
Skewness3.6642456
Sum3253205
Variance1.0632287 × 108
MonotonicityNot monotonic
2023-12-12T18:51:54.853082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
569 2
 
0.5%
2402 2
 
0.5%
3818 2
 
0.5%
6237 2
 
0.5%
4505 2
 
0.5%
5233 2
 
0.5%
6766 1
 
0.3%
26505 1
 
0.3%
1383 1
 
0.3%
3104 1
 
0.3%
Other values (349) 349
95.6%
ValueCountFrequency (%)
233 1
0.3%
352 1
0.3%
454 1
0.3%
526 1
0.3%
554 1
0.3%
561 1
0.3%
569 2
0.5%
582 1
0.3%
587 1
0.3%
620 1
0.3%
ValueCountFrequency (%)
75602 1
0.3%
72449 1
0.3%
70476 1
0.3%
69263 1
0.3%
66409 1
0.3%
48822 1
0.3%
43489 1
0.3%
40552 1
0.3%
36543 1
0.3%
34834 1
0.3%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
Minimum2022-12-31 00:00:00
Maximum2022-12-31 00:00:00
2023-12-12T18:51:54.981137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:51:55.089402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T18:51:52.343210image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:51:51.035070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:51:51.432444image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:51:51.860215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:51:52.449772image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:51:51.130307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:51:51.521763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:51:52.015974image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:51:52.564612image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:51:51.227876image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:51:51.624751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:51:52.127873image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:51:52.678002image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:51:51.329748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:51:51.739037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:51:52.245680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T18:51:55.167696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번단문장문성공갯수
연번1.0000.6000.4000.417
단문0.6001.0000.2670.263
장문0.4000.2671.0001.000
성공갯수0.4170.2631.0001.000
2023-12-12T18:51:55.282992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번단문장문성공갯수
연번1.0000.020-0.353-0.345
단문0.0201.0000.3290.360
장문-0.3530.3291.0000.999
성공갯수-0.3450.3600.9991.000

Missing values

2023-12-12T18:51:52.817021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:51:52.964710image/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

연번사용기관날짜단문장문성공갯수데이터기준일자
01광주광역시 광산구청2022-01-01156661067662022-12-31
12광주광역시 광산구청2022-01-02158357337312022-12-31
23광주광역시 광산구청2022-01-0393025681266112022-12-31
34광주광역시 광산구청2022-01-04220581260322022-12-31
45광주광역시 광산구청2022-01-05240498752272022-12-31
56광주광역시 광산구청2022-01-06277513654132022-12-31
67광주광역시 광산구청2022-01-07182625964412022-12-31
78광주광역시 광산구청2022-01-08160828584452022-12-31
89광주광역시 광산구청2022-01-09177391340902022-12-31
910광주광역시 광산구청2022-01-10208881790252022-12-31
연번사용기관날짜단문장문성공갯수데이터기준일자
355356광주광역시 광산구청2022-12-22410563860482022-12-31
356357광주광역시 광산구청2022-12-23395771881132022-12-31
357358광주광역시 광산구청2022-12-24379240327822022-12-31
358359광주광역시 광산구청2022-12-25381396743482022-12-31
359360광주광역시 광산구청2022-12-26401745678572022-12-31
360361광주광역시 광산구청2022-12-272122407061922022-12-31
361362광주광역시 광산구청2022-12-28476618266582022-12-31
362363광주광역시 광산구청2022-12-29469493254012022-12-31
363364광주광역시 광산구청2022-12-3067231743324152022-12-31
364365광주광역시 광산구청2022-12-31378375241302022-12-31