Overview

Dataset statistics

Number of variables5
Number of observations36
Missing cells72
Missing cells (%)40.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.7 KiB
Average record size in memory47.7 B

Variable types

Numeric2
DateTime1
Unsupported2

Dataset

Description2019년부터 2021년까지 3년간 치과의원에서 인천e음 카드로 결제된 결제액에 대한 월별 데이터를 붙임과 같이 공개하고자 함.
Author인천광역시
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15103378&srcSe=7661IVAWM27C61E190

Alerts

연번 is highly overall correlated with 인천e음 결제액(치과의원)High correlation
인천e음 결제액(치과의원) is highly overall correlated with 연번High correlation
Unnamed: 3 has 36 (100.0%) missing valuesMissing
Unnamed: 4 has 36 (100.0%) missing valuesMissing
연번 has unique valuesUnique
해당년월 has unique valuesUnique
인천e음 결제액(치과의원) has unique valuesUnique
Unnamed: 3 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 4 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-01-28 16:46:03.593713
Analysis finished2024-01-28 16:46:04.327425
Duration0.73 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct36
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean18.5
Minimum1
Maximum36
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size456.0 B
2024-01-29T01:46:04.397870image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.75
Q19.75
median18.5
Q327.25
95-th percentile34.25
Maximum36
Range35
Interquartile range (IQR)17.5

Descriptive statistics

Standard deviation10.535654
Coefficient of variation (CV)0.5694948
Kurtosis-1.2
Mean18.5
Median Absolute Deviation (MAD)9
Skewness0
Sum666
Variance111
MonotonicityStrictly increasing
2024-01-29T01:46:04.572474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=36)
ValueCountFrequency (%)
1 1
 
2.8%
20 1
 
2.8%
22 1
 
2.8%
23 1
 
2.8%
24 1
 
2.8%
25 1
 
2.8%
26 1
 
2.8%
27 1
 
2.8%
28 1
 
2.8%
29 1
 
2.8%
Other values (26) 26
72.2%
ValueCountFrequency (%)
1 1
2.8%
2 1
2.8%
3 1
2.8%
4 1
2.8%
5 1
2.8%
6 1
2.8%
7 1
2.8%
8 1
2.8%
9 1
2.8%
10 1
2.8%
ValueCountFrequency (%)
36 1
2.8%
35 1
2.8%
34 1
2.8%
33 1
2.8%
32 1
2.8%
31 1
2.8%
30 1
2.8%
29 1
2.8%
28 1
2.8%
27 1
2.8%

해당년월
Date

UNIQUE 

Distinct36
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size420.0 B
Minimum2019-01-01 00:00:00
Maximum2021-12-01 00:00:00
2024-01-29T01:46:04.733497image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-29T01:46:04.877487image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=36)

인천e음 결제액(치과의원)
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct36
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.0698169 × 109
Minimum872600
Maximum1.0551274 × 1010
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size456.0 B
2024-01-29T01:46:05.031195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum872600
5-th percentile7513725
Q13.0779546 × 109
median5.5866465 × 109
Q37.0958831 × 109
95-th percentile7.96697 × 109
Maximum1.0551274 × 1010
Range1.0550402 × 1010
Interquartile range (IQR)4.0179286 × 109

Descriptive statistics

Standard deviation2.6682811 × 109
Coefficient of variation (CV)0.52630719
Kurtosis-0.29402201
Mean5.0698169 × 109
Median Absolute Deviation (MAD)1.5425185 × 109
Skewness-0.5392205
Sum1.8251341 × 1011
Variance7.1197239 × 1018
MonotonicityNot monotonic
2024-01-29T01:46:05.225767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=36)
ValueCountFrequency (%)
872600 1
 
2.8%
5602704407 1
 
2.8%
5570588507 1
 
2.8%
5523904347 1
 
2.8%
6487953192 1
 
2.8%
6196428012 1
 
2.8%
6150607094 1
 
2.8%
7149398496 1
 
2.8%
7108931343 1
 
2.8%
6708828800 1
 
2.8%
Other values (26) 26
72.2%
ValueCountFrequency (%)
872600 1
2.8%
2858400 1
2.8%
9065500 1
2.8%
85402850 1
2.8%
1209855050 1
2.8%
2059876746 1
2.8%
2109276630 1
2.8%
2208457916 1
2.8%
2679274829 1
2.8%
3210847795 1
2.8%
ValueCountFrequency (%)
10551274137 1
2.8%
9004435677 1
2.8%
7621148144 1
2.8%
7551509538 1
2.8%
7546462970 1
2.8%
7197365388 1
2.8%
7168588205 1
2.8%
7149398496 1
2.8%
7108931343 1
2.8%
7091533702 1
2.8%

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing36
Missing (%)100.0%
Memory size456.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing36
Missing (%)100.0%
Memory size456.0 B

Interactions

2024-01-29T01:46:03.924963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-29T01:46:03.694672image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-29T01:46:04.030270image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-29T01:46:03.804723image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-29T01:46:05.347100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번해당년월인천e음 결제액(치과의원)
연번1.0001.0000.860
해당년월1.0001.0001.000
인천e음 결제액(치과의원)0.8601.0001.000
2024-01-29T01:46:05.459853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번인천e음 결제액(치과의원)
연번1.0000.828
인천e음 결제액(치과의원)0.8281.000

Missing values

2024-01-29T01:46:04.169188image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-29T01:46:04.278939image/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

연번해당년월인천e음 결제액(치과의원)Unnamed: 3Unnamed: 4
012019-01872600<NA><NA>
122019-022858400<NA><NA>
232019-039065500<NA><NA>
342019-0485402850<NA><NA>
452019-051209855050<NA><NA>
562019-063210847795<NA><NA>
672019-077551509538<NA><NA>
782019-085791036862<NA><NA>
892019-095182777643<NA><NA>
9102019-105548347383<NA><NA>
연번해당년월인천e음 결제액(치과의원)Unnamed: 3Unnamed: 4
26272021-037149398496<NA><NA>
27282021-047108931343<NA><NA>
28292021-056708828800<NA><NA>
29302021-067091533702<NA><NA>
30312021-077546462970<NA><NA>
31322021-087621148144<NA><NA>
32332021-097197365388<NA><NA>
33342021-107168588205<NA><NA>
34352021-1110551274137<NA><NA>
35362021-129004435677<NA><NA>