Overview

Dataset statistics

Number of variables7
Number of observations3293
Missing cells3293
Missing cells (%)14.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory186.6 KiB
Average record size in memory58.0 B

Variable types

Numeric1
DateTime2
Boolean1
Categorical2
Unsupported1

Dataset

Description충청북도 농업기술원 농가경영기록장(농가의 소득을 증진시킬 수 있는 회원전용 농가경영 관리 프로그램)의 수입지출관련 이용자 접속기록, 거래, 거래처 등의 관리시스템으로 일련번호, 등록일시, 수정일시, 상태, 플랫폼종류, 앱종류, 해제유형일련번호, 등록일시, 수정일시, 상태, 플랫폼종류, 앱종류, 해제유형을 제공합니다.
Author충청북도
URLhttps://www.data.go.kr/data/15050320/fileData.do

Alerts

상태 has constant value ""Constant
플랫폼종류 has constant value ""Constant
앱종류 has constant value ""Constant
해제유형 has 3293 (100.0%) missing valuesMissing
일련번호 has unique valuesUnique
해제유형 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 14:03:44.761516
Analysis finished2023-12-12 14:03:45.252030
Duration0.49 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

일련번호
Real number (ℝ)

UNIQUE 

Distinct3293
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean88626.349
Minimum361
Maximum173212
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size29.1 KiB
2023-12-12T23:03:45.321238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum361
5-th percentile1550.2
Q135201
median98141
Q3137475
95-th percentile167272.4
Maximum173212
Range172851
Interquartile range (IQR)102274

Descriptive statistics

Standard deviation56779.192
Coefficient of variation (CV)0.64065814
Kurtosis-1.3566846
Mean88626.349
Median Absolute Deviation (MAD)49795
Skewness-0.18083125
Sum2.9184657 × 108
Variance3.2238767 × 109
MonotonicityStrictly increasing
2023-12-12T23:03:45.483053image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
361 1
 
< 0.1%
124437 1
 
< 0.1%
124407 1
 
< 0.1%
124411 1
 
< 0.1%
124413 1
 
< 0.1%
124421 1
 
< 0.1%
124422 1
 
< 0.1%
124424 1
 
< 0.1%
124425 1
 
< 0.1%
124426 1
 
< 0.1%
Other values (3283) 3283
99.7%
ValueCountFrequency (%)
361 1
< 0.1%
371 1
< 0.1%
379 1
< 0.1%
386 1
< 0.1%
390 1
< 0.1%
405 1
< 0.1%
409 1
< 0.1%
428 1
< 0.1%
436 1
< 0.1%
441 1
< 0.1%
ValueCountFrequency (%)
173212 1
< 0.1%
173201 1
< 0.1%
173175 1
< 0.1%
173156 1
< 0.1%
173081 1
< 0.1%
173073 1
< 0.1%
173060 1
< 0.1%
173054 1
< 0.1%
173036 1
< 0.1%
173000 1
< 0.1%

등록일시
Date

Distinct3290
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Memory size25.9 KiB
Minimum2017-03-09 15:22:24
Maximum2019-11-11 11:02:40
2023-12-12T23:03:45.684522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:03:45.839303image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

수정일시
Date

Distinct3083
Distinct (%)93.6%
Missing0
Missing (%)0.0%
Memory size25.9 KiB
Minimum2017-03-10 10:49:45
Maximum2019-11-11 11:38:51
2023-12-12T23:03:45.989088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:03:46.109357image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

상태
Boolean

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
False
3293 
ValueCountFrequency (%)
False 3293
100.0%
2023-12-12T23:03:46.216685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

플랫폼종류
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size25.9 KiB
A
3293 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowA
2nd rowA
3rd rowA
4th rowA
5th rowA

Common Values

ValueCountFrequency (%)
A 3293
100.0%

Length

2023-12-12T23:03:46.328637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:03:46.428368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
a 3293
100.0%

앱종류
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size25.9 KiB
B
3293 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowB
2nd rowB
3rd rowB
4th rowB
5th rowB

Common Values

ValueCountFrequency (%)
B 3293
100.0%

Length

2023-12-12T23:03:46.556151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:03:46.648430image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
b 3293
100.0%

해제유형
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3293
Missing (%)100.0%
Memory size29.1 KiB

Interactions

2023-12-12T23:03:44.911244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-12T23:03:45.080023image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:03:45.206141image/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

일련번호등록일시수정일시상태플랫폼종류앱종류해제유형
03612017-03-10 02:30:122017-07-13 22:10:52NAB<NA>
13712017-03-09 15:22:242017-06-13 21:14:48NAB<NA>
23792017-03-09 16:09:182018-11-01 19:30:22NAB<NA>
33862017-03-09 16:54:482017-06-22 11:33:10NAB<NA>
43902017-03-09 17:06:412018-06-19 15:20:18NAB<NA>
54052017-03-09 17:31:262018-02-09 15:16:54NAB<NA>
64092017-03-09 17:41:592018-09-10 09:53:19NAB<NA>
74282017-03-09 19:07:392017-07-07 08:11:09NAB<NA>
84362017-03-09 19:51:362017-04-09 11:27:48NAB<NA>
94412017-03-09 20:23:222017-10-08 23:33:05NAB<NA>
일련번호등록일시수정일시상태플랫폼종류앱종류해제유형
32831730002019-11-09 21:14:042019-11-09 21:14:04NAB<NA>
32841730362019-11-10 08:54:212019-11-10 08:54:21NAB<NA>
32851730542019-11-10 11:17:462019-11-10 11:17:46NAB<NA>
32861730602019-11-10 12:35:292019-11-10 12:35:29NAB<NA>
32871730732019-11-10 15:20:042019-11-10 15:20:04NAB<NA>
32881730812019-11-10 16:44:132019-11-10 16:44:13NAB<NA>
32891731562019-11-11 04:57:112019-11-11 07:09:56NAB<NA>
32901731752019-11-11 07:48:132019-11-11 07:48:13NAB<NA>
32911732012019-11-11 10:19:182019-11-11 10:35:12NAB<NA>
32921732122019-11-11 11:02:402019-11-11 11:02:40NAB<NA>