Overview

Dataset statistics

Number of variables3
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory882.0 B
Average record size in memory29.4 B

Variable types

Categorical1
DateTime1
Numeric1

Dataset

Description대전120콜센터에 전화로 민원인이 상담을 요청하는 민원상담건수 데이터로 연도별 상담건수, 월별 상담건수 등의 항목을 제공합니다.
URLhttps://www.data.go.kr/data/15081797/fileData.do

Alerts

구분 has constant value ""Constant
연도(월별) has unique valuesUnique
건수 has unique valuesUnique

Reproduction

Analysis started2023-12-11 23:26:48.477595
Analysis finished2023-12-11 23:26:48.744417
Duration0.27 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
상담처리
30 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row상담처리
2nd row상담처리
3rd row상담처리
4th row상담처리
5th row상담처리

Common Values

ValueCountFrequency (%)
상담처리 30
100.0%

Length

2023-12-12T08:26:48.812462image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T08:26:48.903363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
상담처리 30
100.0%

연도(월별)
Date

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2021-01-31 00:00:00
Maximum2023-06-30 00:00:00
2023-12-12T08:26:48.987365image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:26:49.110294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)

건수
Real number (ℝ)

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean29356.4
Minimum18904
Maximum48303
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-12T08:26:49.263585image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum18904
5-th percentile19889.1
Q120780.25
median27036
Q335330.75
95-th percentile47055.25
Maximum48303
Range29399
Interquartile range (IQR)14550.5

Descriptive statistics

Standard deviation9702.7719
Coefficient of variation (CV)0.33051641
Kurtosis-0.80322406
Mean29356.4
Median Absolute Deviation (MAD)6697.5
Skewness0.70835729
Sum880692
Variance94143782
MonotonicityNot monotonic
2023-12-12T08:26:49.399202image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
20103 1
 
3.3%
20075 1
 
3.3%
45921 1
 
3.3%
35775 1
 
3.3%
34452 1
 
3.3%
47089 1
 
3.3%
48303 1
 
3.3%
47014 1
 
3.3%
37147 1
 
3.3%
43522 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
18904 1
3.3%
19737 1
3.3%
20075 1
3.3%
20103 1
3.3%
20290 1
3.3%
20387 1
3.3%
20565 1
3.3%
20661 1
3.3%
21138 1
3.3%
21598 1
3.3%
ValueCountFrequency (%)
48303 1
3.3%
47089 1
3.3%
47014 1
3.3%
45921 1
3.3%
43522 1
3.3%
37147 1
3.3%
35775 1
3.3%
35479 1
3.3%
34886 1
3.3%
34452 1
3.3%

Interactions

2023-12-12T08:26:48.536078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T08:26:49.492339image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연도(월별)건수
연도(월별)1.0001.000
건수1.0001.000

Missing values

2023-12-12T08:26:48.641419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T08:26:48.715936image/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상담처리2023-01-3120103
1상담처리2023-02-2820290
2상담처리2023-03-3122117
3상담처리2023-04-3018904
4상담처리2023-05-3119737
5상담처리2023-06-3021707
6상담처리2022-01-3129424
7상담처리2022-02-2831866
8상담처리2022-03-3133319
9상담처리2022-04-3024781
구분연도(월별)건수
20상담처리2021-03-3135479
21상담처리2021-04-3030635
22상담처리2021-05-3143522
23상담처리2021-06-3037147
24상담처리2021-07-3147014
25상담처리2021-08-3148303
26상담처리2021-09-3047089
27상담처리2021-10-3134452
28상담처리2021-11-3035775
29상담처리2021-12-3145921