Overview

Dataset statistics

Number of variables4
Number of observations2127
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory72.8 KiB
Average record size in memory35.1 B

Variable types

Numeric2
Categorical2

Dataset

Description경상남도 창원시 도서관사업소 홈페이지의 수강내역 데이터 입니다. 항목은 행번호, 강좌번호, 참가자수, 수강료, 강의실에 대한 데이터를 제공합니다.
Author경상남도 창원시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15088776

Alerts

수강료 has constant value ""Constant
행번호 is highly overall correlated with 강좌번호High correlation
강좌번호 is highly overall correlated with 행번호High correlation
행번호 has unique valuesUnique

Reproduction

Analysis started2023-12-11 00:52:51.197568
Analysis finished2023-12-11 00:52:51.932402
Duration0.73 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

행번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct2127
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1064
Minimum1
Maximum2127
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size18.8 KiB
2023-12-11T09:52:51.994123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile107.3
Q1532.5
median1064
Q31595.5
95-th percentile2020.7
Maximum2127
Range2126
Interquartile range (IQR)1063

Descriptive statistics

Standard deviation614.15633
Coefficient of variation (CV)0.5772146
Kurtosis-1.2
Mean1064
Median Absolute Deviation (MAD)532
Skewness0
Sum2263128
Variance377188
MonotonicityStrictly increasing
2023-12-11T09:52:52.094485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
1415 1
 
< 0.1%
1429 1
 
< 0.1%
1428 1
 
< 0.1%
1427 1
 
< 0.1%
1426 1
 
< 0.1%
1425 1
 
< 0.1%
1424 1
 
< 0.1%
1423 1
 
< 0.1%
1422 1
 
< 0.1%
Other values (2117) 2117
99.5%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
ValueCountFrequency (%)
2127 1
< 0.1%
2126 1
< 0.1%
2125 1
< 0.1%
2124 1
< 0.1%
2123 1
< 0.1%
2122 1
< 0.1%
2121 1
< 0.1%
2120 1
< 0.1%
2119 1
< 0.1%
2118 1
< 0.1%

강좌번호
Real number (ℝ)

HIGH CORRELATION 

Distinct182
Distinct (%)8.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5505.252
Minimum4780
Maximum5803
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size18.8 KiB
2023-12-11T09:52:52.201055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4780
5-th percentile4815
Q15317
median5682
Q35754
95-th percentile5792
Maximum5803
Range1023
Interquartile range (IQR)437

Descriptive statistics

Standard deviation353.92102
Coefficient of variation (CV)0.064287886
Kurtosis-0.53940824
Mean5505.252
Median Absolute Deviation (MAD)78
Skewness-1.0998627
Sum11709671
Variance125260.09
MonotonicityNot monotonic
2023-12-11T09:52:52.321957image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4906 107
 
5.0%
5759 63
 
3.0%
4905 55
 
2.6%
4904 52
 
2.4%
5763 46
 
2.2%
5750 30
 
1.4%
5748 29
 
1.4%
5513 25
 
1.2%
5514 25
 
1.2%
5758 24
 
1.1%
Other values (172) 1671
78.6%
ValueCountFrequency (%)
4780 8
 
0.4%
4809 20
0.9%
4810 17
0.8%
4811 13
0.6%
4812 18
0.8%
4813 16
0.8%
4815 16
0.8%
4816 22
1.0%
4818 20
0.9%
4819 18
0.8%
ValueCountFrequency (%)
5803 2
 
0.1%
5802 3
 
0.1%
5801 8
0.4%
5800 8
0.4%
5799 11
0.5%
5798 15
0.7%
5797 11
0.5%
5796 2
 
0.1%
5795 12
0.6%
5794 13
0.6%

참가자수
Categorical

Distinct8
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size16.7 KiB
<NA>
1284 
1
547 
2
173 
3
 
67
4
 
47
Other values (3)
 
9

Length

Max length4
Median length4
Mean length2.8110014
Min length1

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row1
2nd row1
3rd row1
4th row2
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 1284
60.4%
1 547
25.7%
2 173
 
8.1%
3 67
 
3.1%
4 47
 
2.2%
0 5
 
0.2%
5 3
 
0.1%
1
 
< 0.1%

Length

2023-12-11T09:52:52.433630image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T09:52:52.532670image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 1284
60.4%
1 547
25.7%
2 173
 
8.1%
3 67
 
3.2%
4 47
 
2.2%
0 5
 
0.2%
5 3
 
0.1%

수강료
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size16.7 KiB
0
2127 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 2127
100.0%

Length

2023-12-11T09:52:52.629809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T09:52:52.700314image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 2127
100.0%

Interactions

2023-12-11T09:52:51.682454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:52:51.315813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:52:51.755429image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:52:51.618407image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T09:52:52.756267image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행번호강좌번호참가자수
행번호1.0000.7900.343
강좌번호0.7901.0000.282
참가자수0.3430.2821.000
2023-12-11T09:52:52.845854image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행번호강좌번호참가자수
행번호1.0000.8460.181
강좌번호0.8461.0000.152
참가자수0.1810.1521.000

Missing values

2023-12-11T09:52:51.842185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T09:52:51.905846image/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

행번호강좌번호참가자수수강료
01478010
12478010
23478010
34478020
454780<NA>0
564780<NA>0
674780<NA>0
784780<NA>0
894906<NA>0
910490410
행번호강좌번호참가자수수강료
21172118579920
21182119579920
21192120579920
212021215799<NA>0
21212122579910
212221235799<NA>0
21232124579920
212421255799<NA>0
21252126579910
21262127579910