Overview

Dataset statistics

Number of variables4
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory419.9 KiB
Average record size in memory43.0 B

Variable types

Numeric3
DateTime1

Dataset

Description춘천도시공사에서 관리라는 코드별 수입금액(날짜별, 카테고리별) / (코드, 카테고리코드, 날짜, 금액)
Author춘천도시공사
URLhttps://www.data.go.kr/data/15094393/fileData.do

Alerts

코드 has unique valuesUnique
금액 has 505 (5.1%) zerosZeros

Reproduction

Analysis started2023-12-12 22:42:58.498108
Analysis finished2023-12-12 22:43:00.158310
Duration1.66 second
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%
Mean18610.688
Minimum5
Maximum37291
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T07:43:00.252790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum5
5-th percentile1905.85
Q19284.5
median18463
Q327928.5
95-th percentile35374.2
Maximum37291
Range37286
Interquartile range (IQR)18644

Descriptive statistics

Standard deviation10728.716
Coefficient of variation (CV)0.57648144
Kurtosis-1.2030597
Mean18610.688
Median Absolute Deviation (MAD)9310
Skewness0.010400469
Sum1.8610688 × 108
Variance1.1510535 × 108
MonotonicityNot monotonic
2023-12-13T07:43:00.427519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
10572 1
 
< 0.1%
5206 1
 
< 0.1%
1377 1
 
< 0.1%
8272 1
 
< 0.1%
35576 1
 
< 0.1%
25969 1
 
< 0.1%
7959 1
 
< 0.1%
1844 1
 
< 0.1%
10389 1
 
< 0.1%
18890 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
5 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
10 1
< 0.1%
17 1
< 0.1%
18 1
< 0.1%
19 1
< 0.1%
20 1
< 0.1%
23 1
< 0.1%
27 1
< 0.1%
ValueCountFrequency (%)
37291 1
< 0.1%
37287 1
< 0.1%
37286 1
< 0.1%
37283 1
< 0.1%
37278 1
< 0.1%
37273 1
< 0.1%
37272 1
< 0.1%
37270 1
< 0.1%
37268 1
< 0.1%
37261 1
< 0.1%

카테고리코드
Real number (ℝ)

Distinct133
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean70.4334
Minimum0
Maximum169
Zeros15
Zeros (%)0.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T07:43:00.607646image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile10
Q133
median62
Q3104
95-th percentile137.05
Maximum169
Range169
Interquartile range (IQR)71

Descriptive statistics

Standard deviation42.526961
Coefficient of variation (CV)0.60378969
Kurtosis-1.0504012
Mean70.4334
Median Absolute Deviation (MAD)35
Skewness0.30334105
Sum704334
Variance1808.5424
MonotonicityNot monotonic
2023-12-13T07:43:00.769612image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
57 416
 
4.2%
41 411
 
4.1%
38 394
 
3.9%
79 388
 
3.9%
131 366
 
3.7%
62 358
 
3.6%
10 348
 
3.5%
135 340
 
3.4%
117 338
 
3.4%
35 335
 
3.4%
Other values (123) 6306
63.1%
ValueCountFrequency (%)
0 15
 
0.1%
1 181
1.8%
2 2
 
< 0.1%
3 15
 
0.1%
4 6
 
0.1%
5 13
 
0.1%
6 17
 
0.2%
8 6
 
0.1%
9 5
 
0.1%
10 348
3.5%
ValueCountFrequency (%)
169 9
 
0.1%
166 10
 
0.1%
165 2
 
< 0.1%
162 4
 
< 0.1%
159 3
 
< 0.1%
158 176
1.8%
157 8
 
0.1%
156 6
 
0.1%
155 17
 
0.2%
154 2
 
< 0.1%

날짜
Date

Distinct1749
Distinct (%)17.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2015-01-31 00:00:00
Maximum2021-11-09 00:00:00
2023-12-13T07:43:01.261091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:43:01.409070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

금액
Real number (ℝ)

ZEROS 

Distinct5245
Distinct (%)52.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1210269.5
Minimum0
Maximum1.0249968 × 108
Zeros505
Zeros (%)5.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T07:43:01.540701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q170000
median244000
Q3870540
95-th percentile4110340.5
Maximum1.0249968 × 108
Range1.0249968 × 108
Interquartile range (IQR)800540

Descriptive statistics

Standard deviation4958953.1
Coefficient of variation (CV)4.0973956
Kurtosis194.83886
Mean1210269.5
Median Absolute Deviation (MAD)224000
Skewness12.704347
Sum1.2102695 × 1010
Variance2.4591216 × 1013
MonotonicityNot monotonic
2023-12-13T07:43:01.700861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 505
 
5.1%
24000 63
 
0.6%
60000 62
 
0.6%
30000 57
 
0.6%
10000 42
 
0.4%
48000 42
 
0.4%
90000 38
 
0.4%
20000 36
 
0.4%
15000 33
 
0.3%
52000 32
 
0.3%
Other values (5235) 9090
90.9%
ValueCountFrequency (%)
0 505
5.1%
24 1
 
< 0.1%
30 1
 
< 0.1%
42 1
 
< 0.1%
45 1
 
< 0.1%
49 1
 
< 0.1%
50 1
 
< 0.1%
54 2
 
< 0.1%
58 1
 
< 0.1%
66 1
 
< 0.1%
ValueCountFrequency (%)
102499680 1
< 0.1%
98900680 1
< 0.1%
98784520 1
< 0.1%
97589240 1
< 0.1%
91043026 1
< 0.1%
90950526 1
< 0.1%
90437160 1
< 0.1%
88252030 1
< 0.1%
87252950 1
< 0.1%
83364132 1
< 0.1%

Interactions

2023-12-13T07:42:59.581375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:42:58.850598image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:42:59.232620image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:42:59.716928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:42:58.965026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:42:59.353431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:42:59.844104image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:42:59.107542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:42:59.473266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T07:43:01.813610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
코드카테고리코드금액
코드1.0000.7480.263
카테고리코드0.7481.0000.129
금액0.2630.1291.000
2023-12-13T07:43:01.908316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
코드카테고리코드금액
코드1.000-0.012-0.092
카테고리코드-0.0121.000-0.221
금액-0.092-0.2211.000

Missing values

2023-12-13T07:42:59.979093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:43:00.109029image/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

코드카테고리코드날짜금액
1012010572222018-02-201028000
87569141612018-02-1530000
94169830792018-03-04270000
2942630904332020-06-1150000
42014385162017-04-1010000
17410181621232019-02-1316800
2898030436272020-11-0490000
20115210221182020-01-305049300
1355414130412018-05-28287600
1088811383162017-10-155904000
코드카테고리코드날짜금액
2927730742322020-03-290
2801329421572021-02-030
226762389312021-02-27191400
2647327819352021-01-24355000
273928951312017-06-27946300
11241165592017-04-29274550
2712528499682020-08-28204140
2861030046262020-05-12206000
1316213712982018-05-066000
13124136731382018-03-236179000