hidden cell
hidden cell
# Write and run code here
hidden cell
hidden cell
hidden cell
# Write and run code here
ID Year_Birth Education Marital_Status Income Kidhome Teenhome
0 5524 1957 Graduation Single 58138.0 0 0 \
1 2174 1954 Graduation Single 46344.0 1 1
2 4141 1965 Graduation Together 71613.0 0 0
3 6182 1984 Graduation Together 26646.0 1 0
4 5324 1981 PhD Married 58293.0 1 0
Dt_Customer Recency MntWines MntFruits MntMeatProducts MntFishProducts
0 04-09-2012 58 635 88 546 172 \
1 08-03-2014 38 11 1 6 2
2 21-08-2013 26 426 49 127 111
3 10-02-2014 26 11 4 20 10
4 19-01-2014 94 173 43 118 46
MntSweetProducts MntGoldProds NumDealsPurchases NumWebPurchases
0 88 88 3 8 \
1 1 6 2 1
2 21 42 1 8
3 3 5 2 2
4 27 15 5 5
NumCatalogPurchases NumStorePurchases NumWebVisitsMonth AcceptedCmp3
0 10 4 7 0 \
1 1 2 5 0
2 2 10 4 0
3 0 4 6 0
4 3 6 5 0
AcceptedCmp4 AcceptedCmp5 AcceptedCmp1 AcceptedCmp2 Complain
0 0 0 0 0 0 \
1 0 0 0 0 0
2 0 0 0 0 0
3 0 0 0 0 0
4 0 0 0 0 0
Z_CostContact Z_Revenue Response
0 3 11 1
1 3 11 0
2 3 11 0
3 3 11 0
4 3 11 0 --------------------------------------------------------------------------------
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 2240 entries, 0 to 2239
Data columns (total 29 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 ID 2240 non-null int64
1 Year_Birth 2240 non-null int64
2 Education 2240 non-null object
3 Marital_Status 2240 non-null object
4 Income 2216 non-null float64
5 Kidhome 2240 non-null int64
6 Teenhome 2240 non-null int64
7 Dt_Customer 2240 non-null object
8 Recency 2240 non-null int64
9 MntWines 2240 non-null int64
10 MntFruits 2240 non-null int64
11 MntMeatProducts 2240 non-null int64
12 MntFishProducts 2240 non-null int64
13 MntSweetProducts 2240 non-null int64
14 MntGoldProds 2240 non-null int64
15 NumDealsPurchases 2240 non-null int64
16 NumWebPurchases 2240 non-null int64
17 NumCatalogPurchases 2240 non-null int64
18 NumStorePurchases 2240 non-null int64
19 NumWebVisitsMonth 2240 non-null int64
20 AcceptedCmp3 2240 non-null int64
21 AcceptedCmp4 2240 non-null int64
22 AcceptedCmp5 2240 non-null int64
23 AcceptedCmp1 2240 non-null int64
24 AcceptedCmp2 2240 non-null int64
25 Complain 2240 non-null int64
26 Z_CostContact 2240 non-null int64
27 Z_Revenue 2240 non-null int64
28 Response 2240 non-null int64
dtypes: float64(1), int64(25), object(3)
memory usage: 507.6+ KB
None--------------------------------------------------------------------------------
ID 0
Year_Birth 0
Education 0
Marital_Status 0
Income 24
Kidhome 0
Teenhome 0
Dt_Customer 0
Recency 0
MntWines 0
MntFruits 0
MntMeatProducts 0
MntFishProducts 0
MntSweetProducts 0
MntGoldProds 0
NumDealsPurchases 0
NumWebPurchases 0
NumCatalogPurchases 0
NumStorePurchases 0
NumWebVisitsMonth 0
AcceptedCmp3 0
AcceptedCmp4 0
AcceptedCmp5 0
AcceptedCmp1 0
AcceptedCmp2 0
Complain 0
Z_CostContact 0
Z_Revenue 0
Response 0
dtype: int64
hidden cell
hidden cell
hidden cell
# Write and run code here
ID Year_Birth Income Kidhome Teenhome
count 2240.000000 2240.000000 2216.000000 2240.000000 2240.000000 \
mean 5592.159821 1968.805804 52247.251354 0.444196 0.506250
std 3246.662198 11.984069 25173.076661 0.538398 0.544538
min 0.000000 1893.000000 1730.000000 0.000000 0.000000
25% 2828.250000 1959.000000 35303.000000 0.000000 0.000000
50% 5458.500000 1970.000000 51381.500000 0.000000 0.000000
75% 8427.750000 1977.000000 68522.000000 1.000000 1.000000
max 11191.000000 1996.000000 666666.000000 2.000000 2.000000
Recency MntWines MntFruits MntMeatProducts
count 2240.000000 2240.000000 2240.000000 2240.000000 \
mean 49.109375 303.935714 26.302232 166.950000
std 28.962453 336.597393 39.773434 225.715373
min 0.000000 0.000000 0.000000 0.000000
25% 24.000000 23.750000 1.000000 16.000000
50% 49.000000 173.500000 8.000000 67.000000
75% 74.000000 504.250000 33.000000 232.000000
max 99.000000 1493.000000 199.000000 1725.000000
MntFishProducts MntSweetProducts MntGoldProds NumDealsPurchases
count 2240.000000 2240.000000 2240.000000 2240.000000 \
mean 37.525446 27.062946 44.021875 2.325000
std 54.628979 41.280498 52.167439 1.932238
min 0.000000 0.000000 0.000000 0.000000
25% 3.000000 1.000000 9.000000 1.000000
50% 12.000000 8.000000 24.000000 2.000000
75% 50.000000 33.000000 56.000000 3.000000
max 259.000000 263.000000 362.000000 15.000000
NumWebPurchases NumCatalogPurchases NumStorePurchases
count 2240.000000 2240.000000 2240.000000 \
mean 4.084821 2.662054 5.790179
std 2.778714 2.923101 3.250958
min 0.000000 0.000000 0.000000
25% 2.000000 0.000000 3.000000
50% 4.000000 2.000000 5.000000
75% 6.000000 4.000000 8.000000
max 27.000000 28.000000 13.000000
NumWebVisitsMonth AcceptedCmp3 AcceptedCmp4 AcceptedCmp5
count 2240.000000 2240.000000 2240.000000 2240.000000 \
mean 5.316518 0.072768 0.074554 0.072768
std 2.426645 0.259813 0.262728 0.259813
min 0.000000 0.000000 0.000000 0.000000
25% 3.000000 0.000000 0.000000 0.000000
50% 6.000000 0.000000 0.000000 0.000000
75% 7.000000 0.000000 0.000000 0.000000
max 20.000000 1.000000 1.000000 1.000000
AcceptedCmp1 AcceptedCmp2 Complain Z_CostContact Z_Revenue
count 2240.000000 2240.000000 2240.000000 2240.0 2240.0 \
mean 0.064286 0.013393 0.009375 3.0 11.0
std 0.245316 0.114976 0.096391 0.0 0.0
min 0.000000 0.000000 0.000000 3.0 11.0
25% 0.000000 0.000000 0.000000 3.0 11.0
50% 0.000000 0.000000 0.000000 3.0 11.0
75% 0.000000 0.000000 0.000000 3.0 11.0
max 1.000000 1.000000 1.000000 3.0 11.0
Response
count 2240.000000
mean 0.149107
std 0.356274
min 0.000000
25% 0.000000
50% 0.000000
75% 0.000000
max 1.000000
hidden cell
hidden cell
hidden cell
# Write and run code here
hidden cell
hidden cell
# Write and run code here
hidden cell
hidden cell
# Write and run code here
hidden cell
hidden cell
hidden cell
# Write and run code here
ID Year_Birth Education Marital_Status Income Kidhome Teenhome
0 5524 1957 Graduation Single 58138.0 0 0 \
29 1966 1965 PhD Married 84618.0 0 0
45 1371 1976 Graduation Single 79941.0 0 0
53 2225 1977 Graduation Divorced 82582.0 0 0
72 6312 1959 Graduation Married 65031.0 0 1
... ... ... ... ... ... ... ...
2172 4084 1975 Graduation Together 60934.0 0 1
2185 9723 1960 Graduation Married 67716.0 0 1
2203 2736 1978 Graduation Married 73807.0 0 1
2206 1092 1980 Graduation Married 61014.0 0 1
2217 9589 1948 PhD Widow 82032.0 0 0
Dt_Customer Recency MntWines MntFruits MntMeatProducts
0 04-09-2012 58 635 88 546 \
29 22-11-2013 96 684 100 801
45 28-06-2014 72 123 164 266
53 07-06-2014 54 510 120 550
72 17-03-2013 29 258 107 291
... ... ... ... ... ...
2172 17-01-2014 41 224 155 155
2185 10-01-2013 8 530 142 217
2203 02-01-2013 88 366 124 156
2206 11-08-2012 17 269 129 495
2217 05-04-2014 54 332 194 377
MntFishProducts MntSweetProducts MntGoldProds NumDealsPurchases
0 172 88 88 3 \
29 21 66 0 1
45 227 30 174 1
53 156 40 241 1
72 84 37 86 4
... ... ... ... ...
2172 192 93 54 2
2185 62 9 56 4
2203 71 78 54 2
2206 182 43 29 4
2217 149 125 57 0
NumWebPurchases NumCatalogPurchases NumStorePurchases
0 8 10 4 \
29 6 9 10
45 2 4 9
53 4 9 7
72 10 3 13
... ... ... ...
2172 6 4 11
2185 7 4 13
2203 5 5 11
2206 9 3 4
2217 4 6 7
NumWebVisitsMonth AcceptedCmp3 AcceptedCmp4 AcceptedCmp5
0 7 0 0 0 \
29 2 0 0 1
45 1 0 0 0
53 1 1 0 0
72 7 0 0 0
... ... ... ... ...
2172 4 0 0 0
2185 5 0 1 0
2203 2 0 0 0
2206 7 0 0 0
2217 1 0 0 0
AcceptedCmp1 AcceptedCmp2 Complain Z_CostContact Z_Revenue Response
0 0 0 0 3 11 1
29 0 0 0 3 11 0
45 0 0 0 3 11 0
53 1 0 0 3 11 1
72 0 0 0 3 11 0
... ... ... ... ... ... ...
2172 0 0 0 3 11 0
2185 0 0 0 3 11 0
2203 0 0 0 3 11 0
2206 0 0 0 3 11 0
2217 0 0 0 3 11 0
[227 rows x 29 columns]
hidden cell
hidden cell
hidden cell
hidden cell
# Write and run code here
hidden cell