gimi9 Pandas Profiling

Dataset statistics

Number of variables	6
Number of observations	1120
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	58.1 KiB
Average record size in memory	53.1 B

Variable types

Numeric	4
Categorical	2

Dataset

Description	샘플 데이터
Author	롯데카드
URL	https://www.findatamall.or.kr/market/dataProdDetail?gdsSn=8636&gdsSeCd=GENERAL&gdsVer=1

Alerts

`tco_btc_u_ct` is highly overall correlated with `tco_btc_u_am`	High correlation
`tco_btc_u_am` is highly overall correlated with `tco_btc_u_ct`	High correlation
`tco_btc_u_am` has unique values	Unique

Reproduction

Analysis started	2024-03-03 19:56:02.250955
Analysis finished	2024-03-03 19:56:04.823098
Duration	2.57 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

crym
Real number (ℝ)

Distinct	20
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	202216.3

Minimum	202110
Maximum	202305
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	10.0 KiB

Quantile statistics

Minimum	202110
5-th percentile	202110.95
Q1	202202.75
median	202207.5
Q3	202234.25
95-th percentile	202304.05
Maximum	202305
Range	195
Interquartile range (IQR)	31.5

Descriptive statistics

Standard deviation	60.091881
Coefficient of variation (CV)	0.00029716636
Kurtosis	-0.49176595
Mean	202216.3
Median Absolute Deviation (MAD)	5
Skewness	-0.059535514
Sum	2.2648226 × 10⁸
Variance	3611.0341
Monotonicity	Increasing

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
202110	56	5.0%
202209	56	5.0%
202305	56	5.0%
202304	56	5.0%
202303	56	5.0%
202302	56	5.0%
202301	56	5.0%
202212	56	5.0%
202211	56	5.0%
202210	56	5.0%
Other values (10)	560	50.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
202110	56	5.0%
202111	56	5.0%
202112	56	5.0%
202201	56	5.0%
202202	56	5.0%
202203	56	5.0%
202204	56	5.0%
202205	56	5.0%
202206	56	5.0%
202207	56	5.0%

Value	Count	Frequency (%)
202305	56	5.0%
202304	56	5.0%
202303	56	5.0%
202302	56	5.0%
202301	56	5.0%
202212	56	5.0%
202211	56	5.0%
202210	56	5.0%
202209	56	5.0%
202208	56	5.0%

tco_btc_nm
Categorical

Distinct	4
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	8.9 KiB

백화점	280
할인점	280
슈퍼마켓	280
편의점	280

Length

Max length	4
Median length	3
Mean length	3.25
Min length	3

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	백화점
2nd row	백화점
3rd row	백화점
4th row	백화점
5th row	백화점

Common Values

Value	Count	Frequency (%)
백화점	280	25.0%
할인점	280	25.0%
슈퍼마켓	280	25.0%
편의점	280	25.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
백화점	280	25.0%
할인점	280	25.0%
슈퍼마켓	280	25.0%
편의점	280	25.0%

ma_fem_dc
Categorical

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	8.9 KiB

1	560
2	560

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	560	50.0%
2	560	50.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	560	50.0%
2	560	50.0%

agegrp_dc
Real number (ℝ)

Distinct	7
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	10.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	7
Maximum	7
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.0008935
Coefficient of variation (CV)	0.50022336
Kurtosis	-1.250222
Mean	4
Median Absolute Deviation (MAD)	2
Skewness	0
Sum	4480
Variance	4.0035746
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	160	14.3%
2	160	14.3%
3	160	14.3%
4	160	14.3%
5	160	14.3%
6	160	14.3%
7	160	14.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	160	14.3%
2	160	14.3%
3	160	14.3%
4	160	14.3%
5	160	14.3%
6	160	14.3%
7	160	14.3%

Value	Count	Frequency (%)
7	160	14.3%
6	160	14.3%
5	160	14.3%
4	160	14.3%
3	160	14.3%
2	160	14.3%
1	160	14.3%

tco_btc_u_ct
Real number (ℝ)

HIGH CORRELATION

Distinct	1109
Distinct (%)	99.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	467040.63

Minimum	90
Maximum	2038701
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	10.0 KiB

Quantile statistics

Minimum	90
5-th percentile	284.35
Q1	77679.5
median	310920
Q3	750745.75
95-th percentile	1630881.5
Maximum	2038701
Range	2038611
Interquartile range (IQR)	673066.25

Descriptive statistics

Standard deviation	487105.55
Coefficient of variation (CV)	1.0429618
Kurtosis	0.71037242
Mean	467040.63
Median Absolute Deviation (MAD)	253504
Skewness	1.2276888
Sum	5.230855 × 10⁸
Variance	2.3727182 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
233	3	0.3%
152	2	0.2%
176	2	0.2%
162	2	0.2%
221	2	0.2%
177	2	0.2%
262	2	0.2%
190	2	0.2%
218	2	0.2%
183	2	0.2%
Other values (1099)	1099	98.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
90	1	0.1%
95	1	0.1%
98	1	0.1%
106	1	0.1%
118	1	0.1%
120	1	0.1%
127	1	0.1%
141	1	0.1%
151	1	0.1%
152	2	0.2%

Value	Count	Frequency (%)
2038701	1	0.1%
2024195	1	0.1%
1972934	1	0.1%
1931901	1	0.1%
1921209	1	0.1%
1909786	1	0.1%
1907491	1	0.1%
1889547	1	0.1%
1884821	1	0.1%
1862652	1	0.1%

tco_btc_u_am
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	1120
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.6497078 × 10¹⁰

Minimum	7455798
Maximum	1.1820263 × 10¹¹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	10.0 KiB

Quantile statistics

Minimum	7455798
5-th percentile	13834924
Q1	2.6709992 × 10⁹
median	9.3827683 × 10⁹
Q3	2.2144976 × 10¹⁰
95-th percentile	5.8196601 × 10¹⁰
Maximum	1.1820263 × 10¹¹
Range	1.1819518 × 10¹¹
Interquartile range (IQR)	1.9473977 × 10¹⁰

Descriptive statistics

Standard deviation	2.1261371 × 10¹⁰
Coefficient of variation (CV)	1.2887962
Kurtosis	6.1576374
Mean	1.6497078 × 10¹⁰
Median Absolute Deviation (MAD)	7.8326462 × 10⁹
Skewness	2.3302316
Sum	1.8476727 × 10¹³
Variance	4.5204592 × 10²⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17420849	1	0.1%
21815206037	1	0.1%
14828480825	1	0.1%
2763099182	1	0.1%
13569540	1	0.1%
3269447073	1	0.1%
8526930796	1	0.1%
17115430579	1	0.1%
10338753093	1	0.1%
32629822285	1	0.1%
Other values (1110)	1110	99.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7455798	1	0.1%
7607990	1	0.1%
7980090	1	0.1%
8226950	1	0.1%
8435760	1	0.1%
8817980	1	0.1%
9033890	1	0.1%
9063950	1	0.1%
9319290	1	0.1%
9467700	1	0.1%

Value	Count	Frequency (%)
118202633923	1	0.1%
116232760812	1	0.1%
115347663478	1	0.1%
110993623691	1	0.1%
110197300843	1	0.1%
109787742826	1	0.1%
109077006905	1	0.1%
108997218119	1	0.1%
107755988349	1	0.1%
106352041246	1	0.1%

Heatmap
Table

	crym	tco_btc_nm	ma_fem_dc	agegrp_dc	tco_btc_u_ct	tco_btc_u_am
crym	1.000	0.000	0.000	0.000	0.000	0.000
tco_btc_nm	0.000	1.000	0.000	0.000	0.445	0.528
ma_fem_dc	0.000	0.000	1.000	0.000	0.453	0.336
agegrp_dc	0.000	0.000	0.000	1.000	0.666	0.567
tco_btc_u_ct	0.000	0.445	0.453	0.666	1.000	0.732
tco_btc_u_am	0.000	0.528	0.336	0.567	0.732	1.000

Heatmap
Table

	tco_btc_nm	ma_fem_dc
tco_btc_nm	1.000	0.000
ma_fem_dc	0.000	1.000

Heatmap
Table

	crym	agegrp_dc	tco_btc_u_ct	tco_btc_u_am	tco_btc_nm	ma_fem_dc
crym	1.000	0.000	0.017	0.016	0.000	0.000
agegrp_dc	0.000	1.000	0.310	0.372	0.000	0.000
tco_btc_u_ct	0.017	0.310	1.000	0.712	0.281	0.347
tco_btc_u_am	0.016	0.372	0.712	1.000	0.343	0.257
tco_btc_nm	0.000	0.000	0.281	0.343	1.000	0.000
ma_fem_dc	0.000	0.000	0.347	0.257	0.000	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

	crym	tco_btc_nm	ma_fem_dc	agegrp_dc	tco_btc_u_ct	tco_btc_u_am
0	202110	백화점	1	1	151	17420849
1	202110	백화점	1	2	42048	6553138709
2	202110	백화점	1	3	227151	34742769615
3	202110	백화점	1	4	366979	46184888563
4	202110	백화점	1	5	268280	36937831073
5	202110	백화점	1	6	132462	19903281731
6	202110	백화점	1	7	51125	6582689324
7	202110	백화점	2	1	329	31818830
8	202110	백화점	2	2	120005	16372373199
9	202110	백화점	2	3	508021	63611231448

	crym	tco_btc_nm	ma_fem_dc	agegrp_dc	tco_btc_u_ct	tco_btc_u_am
1110	202305	편의점	1	5	1437545	11414103309
1111	202305	편의점	1	6	410424	3369545505
1112	202305	편의점	1	7	77182	604901350
1113	202305	편의점	2	1	2401	16802100
1114	202305	편의점	2	2	425178	2939083198
1115	202305	편의점	2	3	1025509	7653516371
1116	202305	편의점	2	4	1921209	13871480096
1117	202305	편의점	2	5	1436012	10214570071
1118	202305	편의점	2	6	440588	3500242238
1119	202305	편의점	2	7	91688	786963950

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample