gimi9 Pandas Profiling

Dataset statistics

Number of variables	6
Number of observations	1680
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	87.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=8641&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 14:46:52.429585
Analysis finished	2024-03-03 14:46:57.657524
Duration	5.23 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

crym
Real number (ℝ)

Distinct	20
Distinct (%)	1.2%
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	14.9 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.082933
Coefficient of variation (CV)	0.0002971221
Kurtosis	-0.49282188
Mean	202216.3
Median Absolute Deviation (MAD)	5
Skewness	-0.059508896
Sum	3.3972338 × 10⁸
Variance	3609.9588
Monotonicity	Increasing

Histogram with fixed size bins (bins=20)

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

Minimum 10 values
Maximum 10 values

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

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

tco_btc_nm
Categorical

Distinct	6
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	13.2 KiB

한식	280
일식	280
중식	280
양식	280
패스트푸드점	280

Length

Max length	7
Median length	2
Mean length	3.5
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
한식	280	16.7%
일식	280	16.7%
중식	280	16.7%
양식	280	16.7%
패스트푸드점	280	16.7%
패밀리레스토랑	280	16.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
한식	280	16.7%
일식	280	16.7%
중식	280	16.7%
양식	280	16.7%
패스트푸드점	280	16.7%
패밀리레스토랑	280	16.7%

ma_fem_dc
Categorical

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	13.2 KiB

1	840
2	840

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

Length

Histogram of lengths of the category

Common Values (Plot)

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

agegrp_dc
Real number (ℝ)

Distinct	7
Distinct (%)	0.4%
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	14.9 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.0005955
Coefficient of variation (CV)	0.50014888
Kurtosis	-1.2501483
Mean	4
Median Absolute Deviation (MAD)	2
Skewness	0
Sum	6720
Variance	4.0023824
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

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

Minimum 10 values
Maximum 10 values

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

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

tco_btc_u_ct
Real number (ℝ)

HIGH CORRELATION

Distinct	1595
Distinct (%)	94.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	94318.037

Minimum	5
Maximum	951376
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.9 KiB

Quantile statistics

Minimum	5
5-th percentile	69.95
Q1	6337.75
median	25404.5
Q3	92851.25
95-th percentile	444750.4
Maximum	951376
Range	951371
Interquartile range (IQR)	86513.5

Descriptive statistics

Standard deviation	180177.95
Coefficient of variation (CV)	1.9103234
Kurtosis	9.3246375
Mean	94318.037
Median Absolute Deviation (MAD)	24622.5
Skewness	3.0841178
Sum	1.584543 × 10⁸
Variance	3.2464095 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
69	6	0.4%
17	5	0.3%
154	4	0.2%
15	4	0.2%
83	4	0.2%
93	4	0.2%
66	3	0.2%
139	3	0.2%
52	3	0.2%
65	3	0.2%
Other values (1585)	1641	97.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5	1	0.1%
8	1	0.1%
9	2	0.1%
10	1	0.1%
11	3	0.2%
12	3	0.2%
13	2	0.1%
14	1	0.1%
15	4	0.2%
16	2	0.1%

Value	Count	Frequency (%)
951376	1	0.1%
941206	1	0.1%
931240	1	0.1%
924096	1	0.1%
922744	1	0.1%
920395	1	0.1%
913894	1	0.1%
906928	1	0.1%
900001	1	0.1%
898649	1	0.1%

tco_btc_u_am
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	1680
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.1945913 × 10⁹

Minimum	85608
Maximum	3.8419199 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	14.9 KiB

Quantile statistics

Minimum	85608
5-th percentile	2019452.2
Q1	1.5991348 × 10⁸
median	8.1474166 × 10⁸
Q3	2.3904662 × 10⁹
95-th percentile	1.850484 × 10¹⁰
Maximum	3.8419199 × 10¹⁰
Range	3.8419114 × 10¹⁰
Interquartile range (IQR)	2.2305527 × 10⁹

Descriptive statistics

Standard deviation	6.9234325 × 10⁹
Coefficient of variation (CV)	2.1672358
Kurtosis	10.583115
Mean	3.1945913 × 10⁹
Median Absolute Deviation (MAD)	7.8510216 × 10⁸
Skewness	3.3114884
Sum	5.3669134 × 10¹²
Variance	4.7933918 × 10¹⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27880610	1	0.1%
15736671747	1	0.1%
612659700	1	0.1%
3137745	1	0.1%
324641495	1	0.1%
1052710265	1	0.1%
2971397232	1	0.1%
4009425372	1	0.1%
2107797900	1	0.1%
598494231	1	0.1%
Other values (1670)	1670	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
85608	1	0.1%
214480	1	0.1%
215000	1	0.1%
240720	1	0.1%
262790	1	0.1%
264170	1	0.1%
321850	1	0.1%
341400	1	0.1%
385900	1	0.1%
396660	1	0.1%

Value	Count	Frequency (%)
38419199230	1	0.1%
37585019925	1	0.1%
36975031992	1	0.1%
36885844776	1	0.1%
36363221085	1	0.1%
36316810033	1	0.1%
36190686030	1	0.1%
36136895716	1	0.1%
35995576421	1	0.1%
35862488056	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.040	0.152
tco_btc_nm	0.000	1.000	0.000	0.000	0.621	0.591
ma_fem_dc	0.000	0.000	1.000	0.000	0.087	0.000
agegrp_dc	0.000	0.000	0.000	1.000	0.468	0.413
tco_btc_u_ct	0.040	0.621	0.087	0.468	1.000	0.964
tco_btc_u_am	0.152	0.591	0.000	0.413	0.964	1.000

Heatmap
Table

	ma_fem_dc	tco_btc_nm
ma_fem_dc	1.000	0.000
tco_btc_nm	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.028	0.054	0.000	0.000
agegrp_dc	0.000	1.000	0.223	0.225	0.000	0.000
tco_btc_u_ct	0.028	0.223	1.000	0.948	0.387	0.067
tco_btc_u_am	0.054	0.225	0.948	1.000	0.361	0.000
tco_btc_nm	0.000	0.000	0.387	0.361	1.000	0.000
ma_fem_dc	0.000	0.000	0.067	0.000	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	764	27880610
1	202110	한식	1	2	138452	4858110725
2	202110	한식	1	3	445594	15946682690
3	202110	한식	1	4	823175	29075105693
4	202110	한식	1	5	720851	24985214844
5	202110	한식	1	6	320189	11138525474
6	202110	한식	1	7	92585	3135200079
7	202110	한식	2	1	699	24694590
8	202110	한식	2	2	153245	5292712833
9	202110	한식	2	3	412958	14212490001

	crym	tco_btc_nm	ma_fem_dc	agegrp_dc	tco_btc_u_ct	tco_btc_u_am
1670	202305	패밀리레스토랑	1	5	14404	460632572
1671	202305	패밀리레스토랑	1	6	3944	132796715
1672	202305	패밀리레스토랑	1	7	1053	35420204
1673	202305	패밀리레스토랑	2	1	11	341400
1674	202305	패밀리레스토랑	2	2	3564	136444744
1675	202305	패밀리레스토랑	2	3	10630	415119590
1676	202305	패밀리레스토랑	2	4	24549	903515003
1677	202305	패밀리레스토랑	2	5	20510	637370496
1678	202305	패밀리레스토랑	2	6	6789	224058519
1679	202305	패밀리레스토랑	2	7	1708	59695485

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample