gimi9 Pandas Profiling

Dataset statistics

Number of variables	6
Number of observations	100
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	5.4 KiB
Average record size in memory	55.3 B

Variable types

Categorical	2
Numeric	4

Dataset

Description	샘플 데이터
Author	강원대학교
URL	https://www.bigdata-environment.kr/user/data_market/detail.do?id=7a408870-47ac-11ed-b0ac-c5c89495dffa

Alerts

`연도` has constant value ""	Constant
`최고기온` is highly overall correlated with `최저기온`	High correlation
`최저기온` is highly overall correlated with `최고기온`	High correlation
`최고기온` has unique values	Unique
`강수량` has 91 (91.0%) zeros	Zeros

Reproduction

Analysis started	2023-12-10 11:11:16.018244
Analysis finished	2023-12-10 11:11:18.555789
Duration	2.54 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

연도
Categorical

CONSTANT

Distinct	1
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	932.0 B

1981	100

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1981
2nd row	1981
3rd row	1981
4th row	1981
5th row	1981

Common Values

Value	Count	Frequency (%)
1981	100	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1981	100	100.0%

월
Categorical

Distinct	4
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Memory size	932.0 B

1	31
3	31
2	28
4	10

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
1	31	31.0%
3	31	31.0%
2	28	28.0%
4	10	10.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	31	31.0%
3	31	31.0%
2	28	28.0%
4	10	10.0%

일
Real number (ℝ)

Distinct	31
Distinct (%)	31.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.53

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	7
median	14
Q3	22
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.8870067
Coefficient of variation (CV)	0.61163157
Kurtosis	-1.2002711
Mean	14.53
Median Absolute Deviation (MAD)	8
Skewness	0.18074292
Sum	1453
Variance	78.978889
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
1	4	4.0%
7	4	4.0%
2	4	4.0%
9	4	4.0%
8	4	4.0%
10	4	4.0%
6	4	4.0%
5	4	4.0%
4	4	4.0%
3	4	4.0%
Other values (21)	60	60.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4	4.0%
2	4	4.0%
3	4	4.0%
4	4	4.0%
5	4	4.0%
6	4	4.0%
7	4	4.0%
8	4	4.0%
9	4	4.0%
10	4	4.0%

Value	Count	Frequency (%)
31	2	2.0%
30	2	2.0%
29	2	2.0%
28	3	3.0%
27	3	3.0%
26	3	3.0%
25	3	3.0%
24	3	3.0%
23	3	3.0%
22	3	3.0%

강수량
Real number (ℝ)

ZEROS

Distinct	9
Distinct (%)	9.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.35527268

Minimum	0
Maximum	20.726247
Zeros	91
Zeros (%)	91.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	20.726247
Range	20.726247
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.1764267
Coefficient of variation (CV)	6.126074
Kurtosis	79.677504
Mean	0.35527268
Median Absolute Deviation (MAD)	0
Skewness	8.6304765
Sum	35.527268
Variance	4.7368334
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
0.0	91	91.0%
1.0	2	2.0%
0.5	1	1.0%
3.99333462307346	1	1.0%
20.7262466407883	1	1.0%
5.41827187671987	1	1.0%
0.588147510951812	1	1.0%
2.0	1	1.0%
0.301267605633803	1	1.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	91	91.0%
0.301267605633803	1	1.0%
0.5	1	1.0%
0.588147510951812	1	1.0%
1.0	2	2.0%
2.0	1	1.0%
3.99333462307346	1	1.0%
5.41827187671987	1	1.0%
20.7262466407883	1	1.0%

Value	Count	Frequency (%)
20.7262466407883	1	1.0%
5.41827187671987	1	1.0%
3.99333462307346	1	1.0%
2.0	1	1.0%
1.0	2	2.0%
0.588147510951812	1	1.0%
0.5	1	1.0%
0.301267605633803	1	1.0%
0.0	91	91.0%

최고기온
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	100
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.6823671

Minimum	-13
Maximum	7.4143082
Zeros	1
Zeros (%)	1.0%
Negative	52
Negative (%)	52.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	-13
5-th percentile	-8.383656
Q1	-3.6646389
median	-0.15070847
Q3	2.2035645
95-th percentile	6.2401068
Maximum	7.4143082
Range	20.414308
Interquartile range (IQR)	5.8682034

Descriptive statistics

Standard deviation	4.699381
Coefficient of variation (CV)	-6.886881
Kurtosis	0.0055722435
Mean	-0.6823671
Median Absolute Deviation (MAD)	3.2493979
Skewness	-0.48442963
Sum	-68.23671
Variance	22.084182
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.0125856577797563	1	1.0%
2.08608791420754	1	1.0%
3.89881441581343	1	1.0%
3.956604696371	1	1.0%
4.49955865348455	1	1.0%
4.35870721128771	1	1.0%
3.7	1	1.0%
1.62342171919488	1	1.0%
0.0018617563285785	1	1.0%
0.896076606004403	1	1.0%
Other values (90)	90	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-13.0	1	1.0%
-12.7380436115462	1	1.0%
-12.7056987763684	1	1.0%
-11.5055992414727	1	1.0%
-8.83581936221654	1	1.0%
-8.35985794547247	1	1.0%
-8.27845171339024	1	1.0%
-7.64556305433801	1	1.0%
-7.51045906526171	1	1.0%
-7.23171599356805	1	1.0%

Value	Count	Frequency (%)
7.41430819538865	1	1.0%
7.0630027258428	1	1.0%
6.9160819649957	1	1.0%
6.89554595089376	1	1.0%
6.50484997934569	1	1.0%
6.22617295873573	1	1.0%
6.02551145694597	1	1.0%
6.01011332365571	1	1.0%
5.94236175121515	1	1.0%
5.83068964710637	1	1.0%

최저기온
Real number (ℝ)

HIGH CORRELATION

Distinct	99
Distinct (%)	99.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-7.1964954

Minimum	-19.015703
Maximum	3.0265432
Zeros	0
Zeros (%)	0.0%
Negative	94
Negative (%)	94.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	-19.015703
5-th percentile	-14.021794
Q1	-10.789314
median	-7.1938559
Q3	-4.1155178
95-th percentile	0.683301
Maximum	3.0265432
Range	22.042246
Interquartile range (IQR)	6.673796

Descriptive statistics

Standard deviation	4.6095516
Coefficient of variation (CV)	-0.64052727
Kurtosis	-0.49805627
Mean	-7.1964954
Median Absolute Deviation (MAD)	3.2158109
Skewness	-0.032327988
Sum	-719.64954
Variance	21.247965
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-8.07314401622718	2	2.0%
-5.9648	1	1.0%
-6.81007109004739	1	1.0%
-2.5	1	1.0%
-2.29869163054649	1	1.0%
0.681617748109597	1	1.0%
-1.69975803295022	1	1.0%
-4.08395916879329	1	1.0%
-6.3294498381877	1	1.0%
-6.07272727272727	1	1.0%
Other values (89)	89	89.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-19.0157026096372	1	1.0%
-17.1068087395696	1	1.0%
-15.2205487501695	1	1.0%
-14.4153829644534	1	1.0%
-14.1402281766799	1	1.0%
-14.0155610270841	1	1.0%
-13.8780911062907	1	1.0%
-13.5628270699433	1	1.0%
-13.561653174265	1	1.0%
-13.3797831819514	1	1.0%

Value	Count	Frequency (%)
3.026543248024	1	1.0%
2.1387596041007	1	1.0%
1.40676064867047	1	1.0%
1.10100435254019	1	1.0%
0.715282734554683	1	1.0%
0.681617748109597	1	1.0%
-0.0034730538922153	1	1.0%
-0.187427144046628	1	1.0%
-0.584794593633292	1	1.0%
-1.15203810925427	1	1.0%

Phik (φk)
Auto

Heatmap
Table

	월	일	강수량	최고기온	최저기온
월	1.000	0.000	0.000	0.671	0.711
일	0.000	1.000	0.000	0.131	0.000
강수량	0.000	0.000	1.000	0.000	0.000
최고기온	0.671	0.131	0.000	1.000	0.783
최저기온	0.711	0.000	0.000	0.783	1.000

Heatmap
Table

	일	강수량	최고기온	최저기온	월
일	1.000	-0.043	0.019	-0.041	0.000
강수량	-0.043	1.000	0.151	0.182	0.000
최고기온	0.019	0.151	1.000	0.910	0.488
최저기온	-0.041	0.182	0.910	1.000	0.497
월	0.000	0.000	0.488	0.497	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	연도	월	일	최고기온	최저기온
0	1981	1	1	-0.012586	-5.05296
1	1981	1	2	1.610546	-4.768751
2	1981	1	3	-1.2	-9.912146
3	1981	1	4	-4.8	-11.168427
4	1981	1	5	-8.278452	-12.271264
5	1981	1	6	-7.231716	-14.415383
6	1981	1	7	-7.510459	-13.561653
7	1981	1	8	-7.645563	-13.878091
8	1981	1	9	-7.002081	-13.000918
9	1981	1	10	-5.127151	-9.492686

	연도	월	일	강수량	최고기온	최저기온
90	1981	4	1	0.0	1.788295	-4.126037
91	1981	4	2	0.0	4.143918	-2.58958
92	1981	4	3	0.0	5.760898	0.715283
93	1981	4	4	0.0	7.414308	3.026543
94	1981	4	5	0.0	7.063003	-2.115395
95	1981	4	6	0.0	5.942362	-0.584795
96	1981	4	7	0.0	5.160029	-0.003473
97	1981	4	8	0.0	6.025511	-1.152038
98	1981	4	9	0.301268	6.895546	2.13876
99	1981	4	10	0.0	6.916082	1.406761

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample