E-COMMERCE PROJECT DONE AT CDAM CHUKA UNIVERSITY-EXERCISE
LYDIAH NYAWIRA
3/03/2025
/new page
Loading libraries
Load the following libraries
Importing Data
TransactionID CustomerID ProductID Quantity PaymentMethod TransactionDate
1 1 207 14 5 UPI 12/28/2023
2 2 253 15 1 Cash on Delivery 4/17/2023
3 3 110 19 5 Cash on Delivery 1/17/2023
4 4 256 1 3 Debit Card 10/23/2023
5 5 274 2 5 Debit Card 6/30/2023
6 6 52 15 2 Credit Card 6/14/2023
ProductCategory Price Rating TotalAmount Age Gender Location
1 Clothing 33.36 4.2 166.80 50 Male Houston
2 Electronics 389.03 2.2 389.03 19 Female Chicago
3 Clothing 145.89 1.7 729.45 37 Female Houston
4 Home Appliances 215.02 2.7 645.06 50 Male Los Angeles
5 Home Appliances 325.48 3.4 1627.40 24 Male New York
6 Electronics 389.03 2.2 778.06 50 Male Houston
MembershipStatus
1 Basic
2 Premium
3 Basic
4 Premium
5 Premium
6 PremiumIdentifying Missing Values
[1] 8Handling missing values
By imputation
TransactionID CustomerID ProductID Quantity PaymentMethod
1 1 207 14 5 UPI
2 2 253 15 1 Cash on Delivery
3 3 110 19 5 Cash on Delivery
4 4 256 1 3 Debit Card
5 5 274 2 5 Debit Card
6 6 52 15 2 Credit Card
7 7 191 10 1 Cash on Delivery
8 8 165 5 5 Debit Card
9 9 18 5 4 UPI
10 10 169 17 2 Credit Card
11 11 295 17 3 Debit Card
12 12 271 18 3 UPI
13 13 177 2 4 Credit Card
14 14 18 11 2 UPI
15 15 35 5 4 UPI
16 16 198 17 1 UPI
17 17 54 14 3 Credit Card
18 18 171 3 1 Credit Card
19 19 252 10 3 UPI
20 20 73 13 2 Debit Card
21 21 278 19 1 Cash on Delivery
22 22 20 2 4 UPI
23 23 175 17 3 Credit Card
24 24 114 9 2 Credit Card
25 25 169 19 3 Cash on Delivery
26 26 29 18 4 Cash on Delivery
27 27 267 9 1 Cash on Delivery
28 28 20 14 5 Credit Card
29 29 236 15 2 Credit Card
30 30 179 6 5 Credit Card
31 31 269 8 5 Cash on Delivery
32 32 76 20 1 UPI
33 33 92 2 3 UPI
34 34 267 1 5 Cash on Delivery
35 35 19 18 4 Cash on Delivery
36 36 11 7 2 UPI
37 37 63 7 3 Cash on Delivery
38 38 155 4 3 UPI
39 39 258 5 3 Debit Card
40 40 252 11 5 UPI
41 41 231 10 3 UPI
42 42 228 11 5 Credit Card
43 43 48 1 5 Credit Card
44 44 255 10 2 Cash on Delivery
45 45 156 12 4 Debit Card
46 46 285 7 2 Credit Card
47 47 196 5 5 UPI
48 48 169 18 4 Debit Card
49 49 112 8 4 Credit Card
50 50 95 15 3 UPI
51 51 251 7 3 Credit Card
52 52 107 14 2 Credit Card
53 53 137 10 1 UPI
54 54 156 16 5 Cash on Delivery
55 55 271 3 3 Cash on Delivery
56 56 60 11 3 UPI
57 57 203 3 5 Debit Card
58 58 221 8 5 Cash on Delivery
59 59 17 17 1 Credit Card
60 60 41 13 1 Cash on Delivery
61 61 25 15 5 UPI
62 62 239 12 4 UPI
63 63 275 9 2 Debit Card
64 64 52 19 1 Cash on Delivery
65 65 199 19 2 UPI
66 66 267 6 2 Cash on Delivery
67 67 143 13 3 Cash on Delivery
68 68 201 9 5 UPI
69 69 139 11 5 UPI
70 70 33 14 4 Credit Card
71 71 105 19 5 Debit Card
72 72 279 18 2 UPI
73 73 248 13 1 Cash on Delivery
74 74 17 12 3 UPI
75 75 138 19 1 Debit Card
76 76 18 12 2 UPI
77 77 102 20 2 Credit Card
78 78 71 4 4 Credit Card
79 79 80 16 4 Cash on Delivery
80 80 131 17 1 UPI
81 81 227 12 4 Debit Card
82 82 21 2 4 Debit Card
83 83 238 5 1 Credit Card
84 84 162 19 3 Credit Card
85 85 28 13 2 Credit Card
86 86 154 7 3 Cash on Delivery
87 87 129 5 3 Cash on Delivery
88 88 90 7 5 UPI
89 89 277 16 1 Cash on Delivery
90 90 121 12 5 Credit Card
91 91 163 11 5 Credit Card
92 92 94 19 2 UPI
93 93 12 6 1 Debit Card
94 94 249 12 4 UPI
95 95 141 13 5 Debit Card
96 96 33 6 2 UPI
97 97 152 10 5 UPI
98 98 9 8 5 UPI
99 99 159 10 1 Credit Card
100 100 194 6 2 Cash on Delivery
101 101 287 19 5 Cash on Delivery
102 102 60 17 3 Debit Card
103 103 91 2 4 UPI
104 104 99 19 5 Credit Card
105 105 225 19 3 UPI
106 106 202 20 1 UPI
107 107 171 13 3 UPI
108 108 147 1 2 Credit Card
109 109 239 6 4 Cash on Delivery
110 110 167 5 4 UPI
111 111 96 18 5 Credit Card
112 112 240 7 1 UPI
113 113 132 17 4 Cash on Delivery
114 114 179 15 4 UPI
115 115 163 5 1 Cash on Delivery
116 116 290 5 4 UPI
117 117 77 13 3 Credit Card
118 118 230 8 3 Credit Card
119 119 213 19 5 UPI
120 120 133 1 5 Credit Card
121 121 261 4 1 Debit Card
122 122 71 18 4 UPI
123 123 145 4 1 Credit Card
124 124 256 8 3 Credit Card
125 125 98 4 4 Cash on Delivery
126 126 17 18 2 Credit Card
127 127 189 14 1 Cash on Delivery
128 128 267 12 2 UPI
129 129 270 11 5 UPI
130 130 161 11 3 UPI
131 131 162 17 1 Cash on Delivery
132 132 138 2 4 Cash on Delivery
133 133 226 10 5 Debit Card
134 134 38 4 4 Cash on Delivery
135 135 205 6 4 Credit Card
136 136 268 10 2 Debit Card
137 137 291 19 1 Cash on Delivery
138 138 104 6 3 Debit Card
139 139 187 9 3 UPI
140 140 33 16 5 UPI
141 141 238 13 3 Debit Card
142 142 118 9 5 UPI
143 143 267 7 2 Credit Card
144 144 81 19 1 Cash on Delivery
145 145 260 10 2 Cash on Delivery
146 146 76 18 5 UPI
147 147 184 8 4 Credit Card
148 148 14 16 2 Cash on Delivery
149 149 51 15 4 Debit Card
150 150 155 18 3 Cash on Delivery
151 151 75 17 4 Cash on Delivery
152 152 236 16 3 Credit Card
153 153 275 5 1 Debit Card
154 154 277 3 3 UPI
155 155 49 6 5 Credit Card
156 156 262 19 5 Credit Card
157 157 241 11 2 Credit Card
158 158 216 11 5 Credit Card
159 159 254 12 1 UPI
160 160 144 1 4 Credit Card
161 161 229 8 1 Debit Card
162 162 127 7 3 Credit Card
163 163 190 15 2 UPI
164 164 69 5 3 UPI
165 165 120 3 2 UPI
166 166 30 7 1 UPI
167 167 116 13 3 Credit Card
168 168 68 20 5 Cash on Delivery
169 169 68 9 5 Debit Card
170 170 96 12 3 Credit Card
171 171 92 14 5 Debit Card
172 172 180 7 1 Debit Card
173 173 70 9 1 Cash on Delivery
174 174 298 4 1 UPI
175 175 276 19 1 Debit Card
176 176 251 9 5 Credit Card
177 177 75 2 5 UPI
178 178 296 17 5 Credit Card
179 179 229 12 4 UPI
180 180 224 14 4 Cash on Delivery
181 181 58 10 4 Credit Card
182 182 83 7 5 Debit Card
183 183 299 16 1 UPI
184 184 257 2 2 Cash on Delivery
185 185 162 10 3 Debit Card
186 186 76 19 3 UPI
187 187 67 2 5 Cash on Delivery
188 188 20 8 4 Cash on Delivery
189 189 256 1 5 Debit Card
190 190 90 1 2 Cash on Delivery
191 191 132 15 4 Debit Card
192 192 4 18 1 Debit Card
193 193 218 3 2 UPI
194 194 217 16 4 Cash on Delivery
195 195 253 4 1 Cash on Delivery
196 196 81 7 1 Debit Card
197 197 213 2 5 Debit Card
198 198 36 14 1 Cash on Delivery
199 199 145 4 1 UPI
200 200 249 17 2 Cash on Delivery
201 201 59 19 5 UPI
202 202 69 8 5 UPI
203 203 221 19 3 Cash on Delivery
204 204 137 7 3 Debit Card
205 205 287 12 4 UPI
206 206 198 2 1 Credit Card
207 207 297 18 5 Debit Card
208 208 35 16 2 Debit Card
209 209 73 17 5 Debit Card
210 210 251 11 4 Cash on Delivery
211 211 82 2 1 UPI
212 212 175 14 5 Credit Card
213 213 93 17 5 Cash on Delivery
214 214 234 13 2 Credit Card
215 215 272 9 5 Cash on Delivery
216 216 143 15 3 UPI
217 217 150 3 3 Credit Card
218 218 136 6 5 Debit Card
219 219 214 10 1 Credit Card
220 220 198 12 5 Cash on Delivery
221 221 261 15 1 Credit Card
222 222 9 9 5 UPI
223 223 287 15 5 Credit Card
224 224 67 4 2 Credit Card
225 225 32 9 4 Debit Card
226 226 23 5 4 Cash on Delivery
227 227 82 14 3 Debit Card
228 228 115 17 1 UPI
229 229 281 2 5 UPI
230 230 294 19 2 Cash on Delivery
231 231 30 5 1 UPI
232 232 166 11 4 Cash on Delivery
233 233 132 1 1 UPI
234 234 209 7 5 UPI
235 235 70 15 2 Debit Card
236 236 154 5 5 Credit Card
237 237 39 11 1 Cash on Delivery
238 238 126 16 5 Cash on Delivery
239 239 231 10 5 Cash on Delivery
240 240 149 2 1 Cash on Delivery
241 241 115 6 4 Debit Card
242 242 17 12 4 Cash on Delivery
243 243 135 19 2 UPI
244 244 195 12 5 UPI
245 245 216 3 2 Debit Card
246 246 207 8 4 Cash on Delivery
247 247 280 13 2 Debit Card
248 248 87 16 1 Debit Card
249 249 46 2 1 Debit Card
250 250 27 13 3 Debit Card
251 251 49 13 2 UPI
252 252 136 6 4 UPI
253 253 225 19 2 Debit Card
254 254 98 11 1 UPI
255 255 77 12 5 Credit Card
256 256 211 11 3 Cash on Delivery
257 257 95 1 3 Credit Card
258 258 20 8 2 Cash on Delivery
259 259 157 1 5 UPI
260 260 184 8 5 Debit Card
261 261 246 12 4 Credit Card
262 262 137 8 1 Cash on Delivery
263 263 208 16 3 UPI
264 264 213 10 2 Debit Card
265 265 225 15 3 Cash on Delivery
266 266 255 10 1 UPI
267 267 49 8 3 Credit Card
268 268 42 8 5 Debit Card
269 269 139 2 2 Debit Card
270 270 65 14 3 UPI
271 271 203 18 1 Debit Card
272 272 113 11 4 Cash on Delivery
273 273 242 2 3 UPI
274 274 223 19 2 UPI
275 275 14 16 3 UPI
276 276 232 2 5 Debit Card
277 277 37 9 3 Cash on Delivery
278 278 93 5 5 UPI
279 279 138 6 4 Debit Card
280 280 49 18 3 Cash on Delivery
281 281 52 17 4 UPI
282 282 150 12 4 UPI
283 283 172 15 5 Cash on Delivery
284 284 255 2 5 Credit Card
285 285 267 14 2 Cash on Delivery
286 286 274 2 4 Credit Card
287 287 127 16 1 Cash on Delivery
288 288 140 15 2 Debit Card
289 289 199 10 2 Debit Card
290 290 174 3 3 UPI
291 291 191 2 4 Cash on Delivery
292 292 30 11 2 Cash on Delivery
293 293 198 8 3 Debit Card
294 294 292 16 2 Cash on Delivery
295 295 181 9 5 Cash on Delivery
296 296 157 15 5 Cash on Delivery
297 297 293 13 5 Debit Card
298 298 189 18 4 Debit Card
299 299 182 15 2 Debit Card
300 300 183 12 3 Debit Card
TransactionDate ProductCategory Price Rating TotalAmount Age Gender
1 12/28/2023 Clothing 33.36 4.2 166.80 50.0000 Male
2 4/17/2023 Electronics 389.03 2.2 389.03 19.0000 Female
3 1/17/2023 Clothing 145.89 1.7 729.45 37.0000 Female
4 10/23/2023 Home Appliances 215.02 2.7 645.06 50.0000 Male
5 6/30/2023 Home Appliances 325.48 3.4 1627.40 24.0000 Male
6 6/14/2023 Electronics 389.03 2.2 778.06 50.0000 Male
7 7/26/2023 Electronics 193.15 3.7 193.15 40.0000 Male
8 5/23/2023 Clothing 350.44 1.4 1752.20 37.0000 Male
9 11/1/2023 Clothing 350.44 1.4 1401.76 25.0000 Female
10 12/3/2023 Electronics 280.91 1.9 561.82 53.0000 Female
11 5/29/2023 Electronics 280.91 1.9 842.73 65.0000 Male
12 6/7/2023 Home Appliances 341.40 3.0 1024.20 62.0000 Male
13 6/13/2023 Home Appliances 325.48 3.4 1301.92 41.7911 Male
14 3/7/2023 Electronics 123.63 2.1 247.26 41.7911 Female
15 1/12/2023 Clothing 350.44 1.4 1401.76 41.7911 Male
16 10/10/2023 Electronics 280.91 1.9 280.91 41.7911 Female
17 3/8/2023 Clothing 33.36 4.2 100.08 41.7911 Male
18 10/2/2023 Clothing 117.70 4.9 117.70 41.7911 Male
19 1/24/2023 Electronics 193.15 3.7 579.45 41.7911 Male
20 6/13/2023 Clothing 243.41 5.0 486.82 41.7911 Female
21 11/30/2023 Clothing 145.89 1.7 145.89 34.0000 Female
22 2/9/2023 Home Appliances 325.48 3.4 1301.92 24.0000 Male
23 6/26/2023 Electronics 280.91 1.9 842.73 25.0000 Male
24 3/26/2023 Electronics 132.51 2.3 265.02 52.0000 Male
25 7/9/2023 Clothing 145.89 1.7 437.67 53.0000 Female
26 5/30/2023 Home Appliances 341.40 3.0 1365.60 29.0000 Male
27 4/27/2023 Electronics 132.51 2.3 132.51 24.0000 Male
28 8/3/2023 Clothing 33.36 4.2 166.80 24.0000 Male
29 6/1/2023 Electronics 389.03 2.2 778.06 44.0000 Female
30 2/6/2023 Home Appliances 450.57 3.0 2252.85 19.0000 Male
31 12/21/2023 Electronics 211.39 2.6 1056.95 65.0000 Female
32 4/11/2023 Clothing 35.90 1.5 35.90 22.0000 Female
33 2/5/2023 Home Appliances 325.48 3.4 976.44 52.0000 Male
34 2/14/2023 Home Appliances 215.02 2.7 1075.10 24.0000 Male
35 9/13/2023 Home Appliances 341.40 3.0 1365.60 43.0000 Female
36 4/28/2023 Clothing 212.98 2.6 425.96 44.0000 Male
37 11/29/2023 Clothing 212.98 2.6 638.94 47.0000 Male
38 5/12/2023 Clothing 418.39 4.9 1255.17 21.0000 Male
39 7/10/2023 Clothing 350.44 1.4 1051.32 42.0000 Male
40 1/16/2023 Electronics 123.63 2.1 618.15 50.0000 Female
41 8/22/2023 Electronics 193.15 3.7 579.45 43.0000 Male
42 7/9/2023 Electronics 123.63 2.1 618.15 23.0000 Male
43 10/15/2023 Home Appliances 215.02 2.7 1075.10 25.0000 Female
44 10/6/2023 Electronics 193.15 3.7 386.30 27.0000 Female
45 9/6/2023 Home Appliances 466.49 2.6 1865.96 18.0000 Female
46 9/2/2023 Clothing 212.98 2.6 425.96 35.0000 Female
47 8/31/2023 Clothing 350.44 1.4 1752.20 42.0000
48 3/17/2023 Home Appliances 341.40 3.0 1365.60 53.0000
49 5/2/2023 Electronics 211.39 2.6 845.56 34.0000
50 12/5/2023 Electronics 389.03 2.2 1167.09 49.0000
51 2/27/2023 Clothing 212.98 2.6 638.94 63.0000
52 12/25/2023 Clothing 33.36 4.2 66.72 27.0000
53 9/8/2023 Electronics 193.15 3.7 193.15 49.0000
54 8/20/2023 Home Appliances 172.25 4.3 861.25 18.0000
55 1/16/2023 Clothing 117.70 4.9 353.10 62.0000
56 9/23/2023 Electronics 123.63 2.1 370.89 43.0000
57 11/11/2023 Clothing 117.70 4.9 588.50 41.0000
58 11/15/2023 Electronics 211.39 2.6 1056.95 41.0000
59 5/28/2023 Electronics 280.91 1.9 280.91 52.0000
60 1/18/2023 Clothing 243.41 5.0 243.41 44.0000 Female
61 2/7/2023 Electronics 389.03 2.2 1945.15 31.0000 Male
62 8/19/2023 Home Appliances 466.49 2.6 1865.96 43.0000 Female
63 10/14/2023 Electronics 132.51 2.3 265.02 37.0000 Female
64 10/17/2023 Clothing 145.89 1.7 145.89 50.0000 Male
65 4/27/2023 Clothing 145.89 1.7 291.78 26.0000 Female
66 3/17/2023 Home Appliances 450.57 3.0 901.14 24.0000 Female
67 11/29/2023 Clothing 243.41 5.0 730.23 36.0000 Female
68 1/28/2023 Electronics 132.51 2.3 662.55 24.0000 Male
69 6/27/2023 Electronics 123.63 2.1 618.15 28.0000 Female
70 6/5/2023 Clothing 33.36 4.2 133.44 62.0000 Female
71 6/21/2023 Clothing 145.89 1.7 729.45 61.0000 Female
72 1/7/2023 Home Appliances 341.40 3.0 682.80 50.0000 Female
73 8/22/2023 Clothing 243.41 5.0 243.41 37.0000 Female
74 8/19/2023 Home Appliances 466.49 2.6 1399.47 52.0000 Female
75 4/3/2023 Clothing 145.89 1.7 145.89 38.0000 Female
76 3/15/2023 Home Appliances 466.49 2.6 932.98 25.0000 Female
77 11/24/2023 Clothing 35.90 1.5 71.80 25.0000 Male
78 2/15/2023 Clothing 418.39 4.9 1673.56 65.0000 Female
79 2/1/2023 Home Appliances 172.25 4.3 689.00 49.0000 Female
80 3/26/2023 Electronics 280.91 1.9 280.91 44.0000 Female
81 4/5/2023 Home Appliances 466.49 2.6 1865.96 63.0000 Female
82 7/5/2023 Home Appliances 325.48 3.4 1301.92 59.0000 Male
83 5/27/2023 Clothing 350.44 1.4 350.44 24.0000 Male
84 8/19/2023 Clothing 145.89 1.7 437.67 41.0000 Male
85 12/10/2023 Clothing 243.41 5.0 486.82 56.0000 Male
86 3/14/2023 Clothing 212.98 2.6 638.94 56.0000 Female
87 5/16/2023 Clothing 350.44 1.4 1051.32 49.0000 Male
88 4/8/2023 Clothing 212.98 2.6 1064.90 63.0000 Female
89 8/6/2023 Home Appliances 172.25 4.3 172.25 46.0000 Female
90 2/10/2023 Home Appliances 466.49 2.6 2332.45 60.0000 Female
91 2/11/2023 Electronics 123.63 2.1 618.15 28.0000 Female
92 10/22/2023 Clothing 145.89 1.7 291.78 46.0000 Female
93 10/6/2023 Home Appliances 450.57 3.0 450.57 22.0000 Female
94 6/4/2023 Home Appliances 466.49 2.6 1865.96 52.0000 Male
95 9/17/2023 Clothing 243.41 5.0 1217.05 61.0000 Male
96 10/17/2023 Home Appliances 450.57 3.0 901.14 62.0000 Female
97 2/16/2023 Electronics 193.15 3.7 965.75 36.0000 Male
98 7/11/2023 Electronics 211.39 2.6 1056.95 42.0000 Female
99 11/17/2023 Electronics 193.15 3.7 193.15 47.0000 Male
100 7/18/2023 Home Appliances 450.57 3.0 901.14 57.0000 Male
101 5/25/2023 Clothing 145.89 1.7 729.45 54.0000 Male
102 5/7/2023 Electronics 280.91 1.9 842.73 43.0000 Male
103 8/11/2023 Home Appliances 325.48 3.4 1301.92 47.0000 Female
104 8/16/2023 Clothing 145.89 1.7 729.45 32.0000 Female
105 6/15/2023 Clothing 145.89 1.7 437.67 40.0000 Female
106 12/6/2023 Clothing 35.90 1.5 35.90 27.0000 Male
107 3/1/2023 Clothing 243.41 5.0 730.23 39.0000 Male
108 1/17/2023 Home Appliances 215.02 2.7 430.04 26.0000 Male
109 7/11/2023 Home Appliances 450.57 3.0 1802.28 43.0000 Female
110 12/27/2023 Clothing 350.44 1.4 1401.76 20.0000 Female
111 8/26/2023 Home Appliances 341.40 3.0 1707.00 24.0000 Female
112 2/28/2023 Clothing 212.98 2.6 212.98 58.0000 Male
113 6/3/2023 Electronics 280.91 1.9 1123.64 59.0000 Male
114 3/22/2023 Electronics 389.03 2.2 1556.12 19.0000 Male
115 8/29/2023 Clothing 350.44 1.4 350.44 28.0000 Female
116 2/1/2023 Clothing 350.44 1.4 1401.76 59.0000 Male
117 8/6/2023 Clothing 243.41 5.0 730.23 42.0000 Male
118 11/23/2023 Electronics 211.39 2.6 634.17 18.0000 Male
119 11/21/2023 Clothing 145.89 1.7 729.45 42.0000 Male
120 4/23/2023 Home Appliances 215.02 2.7 1075.10 22.0000 Male
121 6/6/2023 Clothing 418.39 4.9 418.39 38.0000 Male
122 12/10/2023 Home Appliances 341.40 3.0 1365.60 65.0000 Male
123 10/4/2023 Clothing 418.39 4.9 418.39 56.0000 Male
124 2/17/2023 Electronics 211.39 2.6 634.17 50.0000 Male
125 12/7/2023 Clothing 418.39 4.9 1673.56 40.0000 Male
126 8/29/2023 Home Appliances 341.40 3.0 682.80 52.0000 Female
127 7/5/2023 Clothing 33.36 4.2 33.36 31.0000 Male
128 8/3/2023 Home Appliances 466.49 2.6 932.98 24.0000 Male
129 1/11/2023 Electronics 123.63 2.1 618.15 34.0000 Female
130 3/28/2023 Electronics 123.63 2.1 370.89 33.0000 Female
131 5/30/2023 Electronics 280.91 1.9 280.91 41.0000 Male
132 4/2/2023 Home Appliances 325.48 3.4 1301.92 38.0000 Male
133 9/30/2023 Electronics 193.15 3.7 965.75 31.0000 Female
134 12/1/2023 Clothing 418.39 4.9 1673.56 40.0000 Female
135 2/3/2023 Home Appliances 450.57 3.0 1802.28 43.0000 Male
136 4/7/2023 Electronics 193.15 3.7 386.30 58.0000 Male
137 11/25/2023 Clothing 145.89 1.7 145.89 23.0000 Male
138 10/18/2023 Home Appliances 450.57 3.0 1351.71 59.0000 Male
139 1/4/2023 Electronics 132.51 2.3 397.53 53.0000 Male
140 9/3/2023 Home Appliances 172.25 4.3 861.25 62.0000 Male
141 4/28/2023 Clothing 243.41 5.0 730.23 24.0000 Male
142 2/10/2023 Electronics 132.51 2.3 662.55 32.0000 Male
143 11/27/2023 Clothing 212.98 2.6 425.96 24.0000 Male
144 10/24/2023 Clothing 145.89 1.7 145.89 63.0000 Female
145 9/29/2023 Electronics 193.15 3.7 386.30 42.0000 Male
146 4/18/2023 Home Appliances 341.40 3.0 1707.00 22.0000 Female
147 1/13/2023 Electronics 211.39 2.6 845.56 25.0000 Male
148 12/8/2023 Home Appliances 172.25 4.3 344.50 45.0000 Male
149 9/4/2023 Electronics 389.03 2.2 1556.12 35.0000 Female
150 9/17/2023 Home Appliances 341.40 3.0 1024.20 21.0000 Male
151 7/19/2023 Electronics 280.91 1.9 1123.64 30.0000 Male
152 2/6/2023 Home Appliances 172.25 4.3 516.75 44.0000 Female
153 10/1/2023 Clothing 350.44 1.4 350.44 37.0000 Female
154 3/19/2023 Clothing 117.70 4.9 353.10 46.0000 Female
155 4/12/2023 Home Appliances 450.57 3.0 2252.85 29.0000 Female
156 9/6/2023 Clothing 145.89 1.7 729.45 62.0000 Female
157 5/30/2023 Electronics 123.63 2.1 247.26 37.0000 Male
158 12/15/2023 Electronics 123.63 2.1 618.15 42.0000 Male
159 9/12/2023 Home Appliances 466.49 2.6 466.49 21.0000 Male
160 4/30/2023 Home Appliances 215.02 2.7 860.08 42.0000 Male
161 7/30/2023 Electronics 211.39 2.6 211.39 44.0000 Male
162 10/21/2023 Clothing 212.98 2.6 638.94 55.0000 Female
163 6/17/2023 Electronics 389.03 2.2 778.06 33.0000 Male
164 5/15/2023 Clothing 350.44 1.4 1051.32 56.0000 Male
165 12/17/2023 Clothing 117.70 4.9 235.40 40.0000 Male
166 8/24/2023 Clothing 212.98 2.6 212.98 32.0000 Female
167 2/5/2023 Clothing 243.41 5.0 730.23 63.0000 Male
168 9/25/2023 Clothing 35.90 1.5 179.50 39.0000 Male
169 4/23/2023 Electronics 132.51 2.3 662.55 39.0000 Male
170 5/18/2023 Home Appliances 466.49 2.6 1399.47 24.0000 Female
171 8/20/2023 Clothing 33.36 4.2 166.80 52.0000 Male
172 7/7/2023 Clothing 212.98 2.6 212.98 60.0000 Male
173 5/18/2023 Electronics 132.51 2.3 132.51 48.0000 Female
174 11/26/2023 Clothing 418.39 4.9 418.39 53.0000 Female
175 4/3/2023 Clothing 145.89 1.7 145.89 35.0000 Female
176 11/27/2023 Electronics 132.51 2.3 662.55 63.0000 Male
177 8/30/2023 Home Appliances 325.48 3.4 1627.40 30.0000 Male
178 11/13/2023 Electronics 280.91 1.9 1404.55 33.0000 Male
179 5/5/2023 Home Appliances 466.49 2.6 1865.96 44.0000 Male
180 2/23/2023 Clothing 33.36 4.2 133.44 54.0000 Female
181 7/13/2023 Electronics 193.15 3.7 772.60 58.0000 Male
182 6/10/2023 Clothing 212.98 2.6 1064.90 40.0000 Male
183 10/4/2023 Home Appliances 172.25 4.3 172.25 44.0000 Female
184 5/27/2023 Home Appliances 325.48 3.4 650.96 22.0000 Male
185 2/14/2023 Electronics 193.15 3.7 579.45 41.0000 Male
186 5/14/2023 Clothing 145.89 1.7 437.67 22.0000 Female
187 7/14/2023 Home Appliances 325.48 3.4 1627.40 39.0000 Male
188 3/31/2023 Electronics 211.39 2.6 845.56 24.0000 Male
189 6/13/2023 Home Appliances 215.02 2.7 1075.10 50.0000 Female
190 3/15/2023 Home Appliances 215.02 2.7 430.04 63.0000 Female
191 11/19/2023 Electronics 389.03 2.2 1556.12 59.0000 Male
192 9/17/2023 Home Appliances 341.40 3.0 341.40 20.0000 Female
193 10/21/2023 Clothing 117.70 4.9 235.40 43.0000 Female
194 3/20/2023 Home Appliances 172.25 4.3 689.00 40.0000 Female
195 9/3/2023 Clothing 418.39 4.9 418.39 19.0000 Female
196 9/1/2023 Clothing 212.98 2.6 212.98 63.0000 Female
197 1/13/2023 Home Appliances 325.48 3.4 1627.40 42.0000 Female
198 11/15/2023 Clothing 33.36 4.2 33.36 58.0000 Female
199 4/5/2023 Clothing 418.39 4.9 418.39 56.0000 Female
200 11/22/2023 Electronics 280.91 1.9 561.82 52.0000 Male
201 11/18/2023 Clothing 145.89 1.7 729.45 64.0000 Female
202 6/7/2023 Electronics 211.39 2.6 1056.95 56.0000 Female
203 5/20/2023 Clothing 145.89 1.7 437.67 41.0000 Female
204 12/12/2023 Clothing 212.98 2.6 638.94 49.0000 Male
205 9/7/2023 Home Appliances 466.49 2.6 1865.96 54.0000 Male
206 10/24/2023 Home Appliances 325.48 3.4 325.48 35.0000 Female
207 5/8/2023 Home Appliances 341.40 3.0 1707.00 52.0000 Male
208 8/21/2023 Home Appliances 172.25 4.3 344.50 26.0000 Female
209 7/6/2023 Electronics 280.91 1.9 1404.55 51.0000 Female
210 10/27/2023 Electronics 123.63 2.1 494.52 63.0000 Female
211 4/12/2023 Home Appliances 325.48 3.4 325.48 42.0000 Female
212 7/7/2023 Clothing 33.36 4.2 166.80 25.0000 Female
213 6/20/2023 Electronics 280.91 1.9 1404.55 31.0000 Male
214 4/25/2023 Clothing 243.41 5.0 486.82 46.0000 Female
215 4/20/2023 Electronics 132.51 2.3 662.55 45.0000 Female
216 7/3/2023 Electronics 389.03 2.2 1167.09 36.0000 Female
217 11/28/2023 Clothing 117.70 4.9 353.10 65.0000 Female
218 11/17/2023 Home Appliances 450.57 3.0 2252.85 41.0000 Male
219 6/27/2023 Electronics 193.15 3.7 193.15 43.0000 Female
220 2/8/2023 Home Appliances 466.49 2.6 2332.45 35.0000 Female
221 6/5/2023 Electronics 389.03 2.2 389.03 38.0000 Male
222 11/21/2023 Electronics 132.51 2.3 662.55 42.0000 Female
223 7/1/2023 Electronics 389.03 2.2 1945.15 54.0000 Male
224 1/21/2023 Clothing 418.39 4.9 836.78 39.0000 Male
225 7/16/2023 Electronics 132.51 2.3 530.04 59.0000 Male
226 1/12/2023 Clothing 350.44 1.4 1401.76 36.0000 Female
227 2/5/2023 Clothing 33.36 4.2 100.08 42.0000 Female
228 12/15/2023 Electronics 280.91 1.9 280.91 57.0000 Female
229 8/20/2023 Home Appliances 325.48 3.4 1627.40 19.0000 Male
230 5/9/2023 Clothing 145.89 1.7 291.78 55.0000 Male
231 6/3/2023 Clothing 350.44 1.4 350.44 32.0000 Female
232 11/4/2023 Electronics 123.63 2.1 494.52 57.0000 Female
233 3/20/2023 Home Appliances 215.02 2.7 215.02 59.0000 Male
234 12/14/2023 Clothing 212.98 2.6 1064.90 27.0000 Female
235 6/25/2023 Electronics 389.03 2.2 778.06 48.0000 Female
236 9/27/2023 Clothing 350.44 1.4 1752.20 56.0000 Male
237 3/2/2023 Electronics 123.63 2.1 123.63 44.0000 Male
238 1/8/2023 Home Appliances 172.25 4.3 861.25 43.0000 Male
239 12/13/2023 Electronics 193.15 3.7 965.75 43.0000 Male
240 10/1/2023 Home Appliances 325.48 3.4 325.48 51.0000 Male
241 9/5/2023 Home Appliances 450.57 3.0 1802.28 57.0000 Female
242 1/15/2023 Home Appliances 466.49 2.6 1865.96 52.0000 Female
243 11/7/2023 Clothing 145.89 1.7 291.78 33.0000 Female
244 8/1/2023 Home Appliances 466.49 2.6 2332.45 27.0000 Female
245 1/25/2023 Clothing 117.70 4.9 235.40 42.0000 Male
246 7/5/2023 Electronics 211.39 2.6 845.56 50.0000 Male
247 7/22/2023 Clothing 243.41 5.0 486.82 19.0000 Male
248 1/1/2023 Home Appliances 172.25 4.3 172.25 47.0000 Male
249 2/23/2023 Home Appliances 325.48 3.4 325.48 46.0000 Female
250 7/24/2023 Clothing 243.41 5.0 730.23 60.0000 Male
251 2/9/2023 Clothing 243.41 5.0 486.82 29.0000 Female
252 11/24/2023 Home Appliances 450.57 3.0 1802.28 41.0000 Male
253 10/1/2023 Clothing 145.89 1.7 291.78 40.0000 Female
254 8/4/2023 Electronics 123.63 2.1 123.63 40.0000 Male
255 6/22/2023 Home Appliances 466.49 2.6 2332.45 42.0000 Male
256 12/1/2023 Electronics 123.63 2.1 370.89 60.0000 Female
257 12/26/2023 Home Appliances 215.02 2.7 645.06 49.0000 Male
258 3/31/2023 Electronics 211.39 2.6 422.78 24.0000 Male
259 3/21/2023 Home Appliances 215.02 2.7 1075.10 57.0000 Male
260 1/24/2023 Electronics 211.39 2.6 1056.95 25.0000 Male
261 4/22/2023 Home Appliances 466.49 2.6 1865.96 34.0000 Male
262 6/21/2023 Electronics 211.39 2.6 211.39 49.0000 Male
263 12/18/2023 Home Appliances 172.25 4.3 516.75 46.0000 Female
264 12/2/2023 Electronics 193.15 3.7 386.30 42.0000 Male
265 6/20/2023 Electronics 389.03 2.2 1167.09 40.0000 Female
266 7/16/2023 Electronics 193.15 3.7 193.15 27.0000 Male
267 5/12/2023 Electronics 211.39 2.6 634.17 29.0000 Female
268 6/3/2023 Electronics 211.39 2.6 1056.95 49.0000 Male
269 7/4/2023 Home Appliances 325.48 3.4 650.96 28.0000 Male
270 3/19/2023 Clothing 33.36 4.2 100.08 60.0000 Female
271 6/7/2023 Home Appliances 341.40 3.0 341.40 41.0000 Male
272 2/25/2023 Electronics 123.63 2.1 494.52 63.0000 Male
273 4/5/2023 Home Appliances 325.48 3.4 976.44 23.0000 Female
274 6/29/2023 Clothing 145.89 1.7 291.78 58.0000 Female
275 11/26/2023 Home Appliances 172.25 4.3 516.75 45.0000 Male
276 3/24/2023 Home Appliances 325.48 3.4 1627.40 59.0000 Male
277 4/6/2023 Electronics 132.51 2.3 397.53 27.0000 Male
278 5/13/2023 Clothing 350.44 1.4 1752.20 31.0000 Male
279 5/9/2023 Home Appliances 450.57 3.0 1802.28 38.0000 Male
280 3/17/2023 Home Appliances 341.40 3.0 1024.20 29.0000 Female
281 5/26/2023 Electronics 280.91 1.9 1123.64 50.0000 Male
282 5/14/2023 Home Appliances 466.49 2.6 1865.96 65.0000 Male
283 11/16/2023 Electronics 389.03 2.2 1945.15 59.0000 Male
284 7/26/2023 Home Appliances 325.48 3.4 1627.40 27.0000 Male
285 12/17/2023 Clothing 33.36 4.2 66.72 24.0000 Male
286 6/27/2023 Home Appliances 325.48 3.4 1301.92 24.0000 Male
287 6/19/2023 Home Appliances 172.25 4.3 172.25 55.0000 Female
288 12/16/2023 Electronics 389.03 2.2 778.06 53.0000 Male
289 1/29/2023 Electronics 193.15 3.7 386.30 26.0000 Male
290 1/6/2023 Clothing 117.70 4.9 353.10 28.0000 Male
291 8/20/2023 Home Appliances 325.48 3.4 1301.92 40.0000 Male
292 11/11/2023 Electronics 123.63 2.1 247.26 32.0000 Female
293 10/8/2023 Electronics 211.39 2.6 634.17 35.0000 Female
294 4/15/2023 Home Appliances 172.25 4.3 344.50 59.0000 Female
295 9/28/2023 Electronics 132.51 2.3 662.55 30.0000 Male
296 3/13/2023 Electronics 389.03 2.2 1945.15 57.0000 Male
297 10/5/2023 Clothing 243.41 5.0 1217.05 59.0000 Male
298 8/2/2023 Home Appliances 341.40 3.0 1365.60 31.0000 Male
299 11/12/2023 Electronics 389.03 2.2 778.06 63.0000 Female
300 2/19/2023 Home Appliances 466.49 2.6 1399.47 23.0000 Female
Location MembershipStatus
1 Houston Basic
2 Chicago Premium
3 Houston Basic
4 Los Angeles Premium
5 New York Premium
6 Houston Premium
7 Los Angeles Gold
8 Houston Premium
9 Houston Premium
10 Chicago Basic
11 Los Angeles Gold
12 Chicago Basic
13 Chicago Premium
14 Houston Premium
15 Houston Gold
16 Houston Basic
17 Chicago Basic
18 New York Basic
19 Houston Gold
20 Houston Premium
21 New York Premium
22 New York Gold
23 Chicago Gold
24 Houston Basic
25 Chicago Basic
26 New York Basic
27 New York Premium
28 New York Gold
29 New York Basic
30 Chicago Basic
31 New York Gold
32 Chicago Basic
33 Houston Basic
34 New York Premium
35 Los Angeles Basic
36 Chicago Gold
37 Houston Gold
38 Los Angeles Basic
39 Houston Gold
40 Houston Gold
41 Los Angeles Basic
42 New York Basic
43 Los Angeles Gold
44 New York Gold
45 Chicago Basic
46 Chicago Premium
47 Los Angeles Premium
48 Chicago Basic
49 Chicago Basic
50 New York Premium
51 Houston Basic
52 Chicago Gold
53 Chicago Premium
54 Chicago Basic
55 Chicago Basic
56 New York Basic
57 Chicago Gold
58 New York Basic
59 Chicago Gold
60 New York Gold
61 Houston Gold
62 Chicago Premium
63 Los Angeles Premium
64 Houston Premium
65 Houston Basic
66 New York Premium
67 New York Basic
68 Houston Premium
69 New York Gold
70 New York Premium
71 Los Angeles Gold
72 Los Angeles Basic
73 New York Gold
74 Chicago Gold
75 Los Angeles Basic
76 Houston Premium
77 New York Gold
78 Los Angeles Basic
79 Houston Gold
80 Houston Gold
81 Chicago Premium
82 Houston Gold
83 New York Premium
84 Chicago Premium
85 Los Angeles Basic
86 Los Angeles Basic
87 Los Angeles Gold
88 Chicago Gold
89 Chicago Gold
90 Houston Gold
91 Los Angeles Premium
92 New York Premium
93 Chicago Premium
94 New York Gold
95 Houston Gold
96 New York Premium
97 Chicago Premium
98 Chicago Premium
99 New York Premium
100 Chicago Gold
101 Chicago Basic
102 New York Basic
103 Houston Gold
104 Houston Premium
105 Los Angeles Gold
106 Los Angeles Gold
107 New York Basic
108 Los Angeles Premium
109 Chicago Premium
110 New York Gold
111 Houston Premium
112 Chicago Gold
113 Houston Basic
114 Chicago Basic
115 Los Angeles Premium
116 Chicago Premium
117 Los Angeles Basic
118 Los Angeles Gold
119 Chicago Basic
120 Houston Premium
121 New York Basic
122 Los Angeles Basic
123 New York Premium
124 Los Angeles Premium
125 Chicago Basic
126 Chicago Gold
127 Los Angeles Gold
128 New York Premium
129 Los Angeles Basic
130 New York Basic
131 Chicago Premium
132 Los Angeles Basic
133 Los Angeles Premium
134 Chicago Premium
135 Chicago Premium
136 Chicago Gold
137 Los Angeles Gold
138 Houston Gold
139 Houston Premium
140 New York Premium
141 New York Premium
142 Los Angeles Basic
143 New York Premium
144 Chicago Gold
145 Houston Gold
146 Chicago Basic
147 Los Angeles Gold
148 Los Angeles Premium
149 Los Angeles Premium
150 Los Angeles Basic
151 Chicago Basic
152 New York Basic
153 Los Angeles Premium
154 Chicago Gold
155 Chicago Premium
156 Chicago Basic
157 Chicago Premium
158 Chicago Premium
159 Los Angeles Basic
160 Los Angeles Gold
161 New York Premium
162 Houston Gold
163 New York Premium
164 Houston Basic
165 Chicago Basic
166 Los Angeles Basic
167 New York Premium
168 Houston Gold
169 Houston Gold
170 Houston Premium
171 Houston Basic
172 Houston Premium
173 Los Angeles Gold
174 Houston Basic
175 Houston Gold
176 Houston Basic
177 Chicago Basic
178 Los Angeles Basic
179 New York Premium
180 Los Angeles Basic
181 New York Basic
182 Chicago Basic
183 Los Angeles Basic
184 Los Angeles Premium
185 Chicago Premium
186 Chicago Basic
187 Houston Gold
188 New York Gold
189 Los Angeles Premium
190 Chicago Gold
191 Houston Basic
192 Chicago Premium
193 Houston Gold
194 Chicago Gold
195 Chicago Premium
196 Chicago Gold
197 Chicago Basic
198 Los Angeles Gold
199 New York Premium
200 New York Gold
201 Chicago Gold
202 Houston Basic
203 New York Basic
204 Chicago Premium
205 Chicago Basic
206 Houston Basic
207 Chicago Premium
208 Houston Gold
209 Houston Premium
210 Houston Basic
211 New York Basic
212 Chicago Gold
213 New York Premium
214 Los Angeles Basic
215 Houston Basic
216 New York Basic
217 Chicago Premium
218 Chicago Premium
219 Los Angeles Gold
220 Houston Basic
221 New York Basic
222 Chicago Premium
223 Chicago Basic
224 Houston Gold
225 Los Angeles Basic
226 New York Gold
227 New York Basic
228 Houston Basic
229 New York Gold
230 Chicago Gold
231 Los Angeles Basic
232 New York Premium
233 Houston Basic
234 Chicago Premium
235 Los Angeles Gold
236 Los Angeles Basic
237 New York Premium
238 Houston Basic
239 Los Angeles Basic
240 Chicago Gold
241 Houston Basic
242 Chicago Gold
243 Houston Premium
244 Chicago Gold
245 Chicago Premium
246 Houston Basic
247 Houston Basic
248 Houston Gold
249 Chicago Premium
250 New York Basic
251 Chicago Premium
252 Chicago Premium
253 Los Angeles Gold
254 Chicago Basic
255 Los Angeles Basic
256 Houston Gold
257 New York Premium
258 New York Gold
259 Chicago Gold
260 Los Angeles Gold
261 Houston Gold
262 Chicago Premium
263 Los Angeles Gold
264 Chicago Basic
265 Los Angeles Gold
266 New York Gold
267 Chicago Premium
268 Houston Gold
269 New York Gold
270 New York Premium
271 Chicago Gold
272 New York Gold
273 Chicago Premium
274 Chicago Basic
275 Los Angeles Premium
276 Houston Basic
277 Houston Basic
278 New York Premium
279 Los Angeles Basic
280 Chicago Premium
281 Houston Premium
282 Chicago Premium
283 Los Angeles Gold
284 New York Gold
285 New York Premium
286 New York Premium
287 Houston Gold
288 Houston Premium
289 Houston Basic
290 New York Premium
291 Los Angeles Gold
292 Los Angeles Basic
293 Houston Basic
294 Chicago Premium
295 Los Angeles Premium
296 Chicago Gold
297 Los Angeles Basic
298 Los Angeles Gold
299 Houston Basic
300 Chicago BasicHandling by removal of missing values
TransactionID CustomerID ProductID Quantity PaymentMethod TransactionDate
1 1 207 14 5 UPI 12/28/2023
2 2 253 15 1 Cash on Delivery 4/17/2023
3 3 110 19 5 Cash on Delivery 1/17/2023
4 4 256 1 3 Debit Card 10/23/2023
5 5 274 2 5 Debit Card 6/30/2023
6 6 52 15 2 Credit Card 6/14/2023
ProductCategory Price Rating TotalAmount Age Gender Location
1 Clothing 33.36 4.2 166.80 50 Male Houston
2 Electronics 389.03 2.2 389.03 19 Female Chicago
3 Clothing 145.89 1.7 729.45 37 Female Houston
4 Home Appliances 215.02 2.7 645.06 50 Male Los Angeles
5 Home Appliances 325.48 3.4 1627.40 24 Male New York
6 Electronics 389.03 2.2 778.06 50 Male Houston
MembershipStatus
1 Basic
2 Premium
3 Basic
4 Premium
5 Premium
6 Premium TransactionID CustomerID ProductID Quantity PaymentMethod
1 1 207 14 5 UPI
2 2 253 15 1 Cash on Delivery
3 3 110 19 5 Cash on Delivery
4 4 256 1 3 Debit Card
5 5 274 2 5 Debit Card
6 6 52 15 2 Credit Card
7 7 191 10 1 Cash on Delivery
8 8 165 5 5 Debit Card
9 9 18 5 4 UPI
10 10 169 17 2 Credit Card
11 11 295 17 3 Debit Card
12 12 271 18 3 UPI
13 13 177 2 4 Credit Card
14 14 18 11 2 UPI
15 15 35 5 4 UPI
16 16 198 17 1 UPI
17 17 54 14 3 Credit Card
18 18 171 3 1 Credit Card
19 19 252 10 3 UPI
20 20 73 13 2 Debit Card
21 21 278 19 1 Cash on Delivery
22 22 20 2 4 UPI
23 23 175 17 3 Credit Card
24 24 114 9 2 Credit Card
25 25 169 19 3 Cash on Delivery
26 26 29 18 4 Cash on Delivery
27 27 267 9 1 Cash on Delivery
28 28 20 14 5 Credit Card
29 29 236 15 2 Credit Card
30 30 179 6 5 Credit Card
31 31 269 8 5 Cash on Delivery
32 32 76 20 1 UPI
33 33 92 2 3 UPI
34 34 267 1 5 Cash on Delivery
35 35 19 18 4 Cash on Delivery
36 36 11 7 2 UPI
37 37 63 7 3 Cash on Delivery
38 38 155 4 3 UPI
39 39 258 5 3 Debit Card
40 40 252 11 5 UPI
41 41 231 10 3 UPI
42 42 228 11 5 Credit Card
43 43 48 1 5 Credit Card
44 44 255 10 2 Cash on Delivery
45 45 156 12 4 Debit Card
46 46 285 7 2 Credit Card
47 47 196 5 5 UPI
48 48 169 18 4 Debit Card
49 49 112 8 4 Credit Card
50 50 95 15 3 UPI
51 51 251 7 3 Credit Card
52 52 107 14 2 Credit Card
53 53 137 10 1 UPI
54 54 156 16 5 Cash on Delivery
55 55 271 3 3 Cash on Delivery
56 56 60 11 3 UPI
57 57 203 3 5 Debit Card
58 58 221 8 5 Cash on Delivery
59 59 17 17 1 Credit Card
60 60 41 13 1 Cash on Delivery
61 61 25 15 5 UPI
62 62 239 12 4 UPI
63 63 275 9 2 Debit Card
64 64 52 19 1 Cash on Delivery
65 65 199 19 2 UPI
66 66 267 6 2 Cash on Delivery
67 67 143 13 3 Cash on Delivery
68 68 201 9 5 UPI
69 69 139 11 5 UPI
70 70 33 14 4 Credit Card
71 71 105 19 5 Debit Card
72 72 279 18 2 UPI
73 73 248 13 1 Cash on Delivery
74 74 17 12 3 UPI
75 75 138 19 1 Debit Card
76 76 18 12 2 UPI
77 77 102 20 2 Credit Card
78 78 71 4 4 Credit Card
79 79 80 16 4 Cash on Delivery
80 80 131 17 1 UPI
81 81 227 12 4 Debit Card
82 82 21 2 4 Debit Card
83 83 238 5 1 Credit Card
84 84 162 19 3 Credit Card
85 85 28 13 2 Credit Card
86 86 154 7 3 Cash on Delivery
87 87 129 5 3 Cash on Delivery
88 88 90 7 5 UPI
89 89 277 16 1 Cash on Delivery
90 90 121 12 5 Credit Card
91 91 163 11 5 Credit Card
92 92 94 19 2 UPI
93 93 12 6 1 Debit Card
94 94 249 12 4 UPI
95 95 141 13 5 Debit Card
96 96 33 6 2 UPI
97 97 152 10 5 UPI
98 98 9 8 5 UPI
99 99 159 10 1 Credit Card
100 100 194 6 2 Cash on Delivery
101 101 287 19 5 Cash on Delivery
102 102 60 17 3 Debit Card
103 103 91 2 4 UPI
104 104 99 19 5 Credit Card
105 105 225 19 3 UPI
106 106 202 20 1 UPI
107 107 171 13 3 UPI
108 108 147 1 2 Credit Card
109 109 239 6 4 Cash on Delivery
110 110 167 5 4 UPI
111 111 96 18 5 Credit Card
112 112 240 7 1 UPI
113 113 132 17 4 Cash on Delivery
114 114 179 15 4 UPI
115 115 163 5 1 Cash on Delivery
116 116 290 5 4 UPI
117 117 77 13 3 Credit Card
118 118 230 8 3 Credit Card
119 119 213 19 5 UPI
120 120 133 1 5 Credit Card
121 121 261 4 1 Debit Card
122 122 71 18 4 UPI
123 123 145 4 1 Credit Card
124 124 256 8 3 Credit Card
125 125 98 4 4 Cash on Delivery
126 126 17 18 2 Credit Card
127 127 189 14 1 Cash on Delivery
128 128 267 12 2 UPI
129 129 270 11 5 UPI
130 130 161 11 3 UPI
131 131 162 17 1 Cash on Delivery
132 132 138 2 4 Cash on Delivery
133 133 226 10 5 Debit Card
134 134 38 4 4 Cash on Delivery
135 135 205 6 4 Credit Card
136 136 268 10 2 Debit Card
137 137 291 19 1 Cash on Delivery
138 138 104 6 3 Debit Card
139 139 187 9 3 UPI
140 140 33 16 5 UPI
141 141 238 13 3 Debit Card
142 142 118 9 5 UPI
143 143 267 7 2 Credit Card
144 144 81 19 1 Cash on Delivery
145 145 260 10 2 Cash on Delivery
146 146 76 18 5 UPI
147 147 184 8 4 Credit Card
148 148 14 16 2 Cash on Delivery
149 149 51 15 4 Debit Card
150 150 155 18 3 Cash on Delivery
151 151 75 17 4 Cash on Delivery
152 152 236 16 3 Credit Card
153 153 275 5 1 Debit Card
154 154 277 3 3 UPI
155 155 49 6 5 Credit Card
156 156 262 19 5 Credit Card
157 157 241 11 2 Credit Card
158 158 216 11 5 Credit Card
159 159 254 12 1 UPI
160 160 144 1 4 Credit Card
161 161 229 8 1 Debit Card
162 162 127 7 3 Credit Card
163 163 190 15 2 UPI
164 164 69 5 3 UPI
165 165 120 3 2 UPI
166 166 30 7 1 UPI
167 167 116 13 3 Credit Card
168 168 68 20 5 Cash on Delivery
169 169 68 9 5 Debit Card
170 170 96 12 3 Credit Card
171 171 92 14 5 Debit Card
172 172 180 7 1 Debit Card
173 173 70 9 1 Cash on Delivery
174 174 298 4 1 UPI
175 175 276 19 1 Debit Card
176 176 251 9 5 Credit Card
177 177 75 2 5 UPI
178 178 296 17 5 Credit Card
179 179 229 12 4 UPI
180 180 224 14 4 Cash on Delivery
181 181 58 10 4 Credit Card
182 182 83 7 5 Debit Card
183 183 299 16 1 UPI
184 184 257 2 2 Cash on Delivery
185 185 162 10 3 Debit Card
186 186 76 19 3 UPI
187 187 67 2 5 Cash on Delivery
188 188 20 8 4 Cash on Delivery
189 189 256 1 5 Debit Card
190 190 90 1 2 Cash on Delivery
191 191 132 15 4 Debit Card
192 192 4 18 1 Debit Card
193 193 218 3 2 UPI
194 194 217 16 4 Cash on Delivery
195 195 253 4 1 Cash on Delivery
196 196 81 7 1 Debit Card
197 197 213 2 5 Debit Card
198 198 36 14 1 Cash on Delivery
199 199 145 4 1 UPI
200 200 249 17 2 Cash on Delivery
201 201 59 19 5 UPI
202 202 69 8 5 UPI
203 203 221 19 3 Cash on Delivery
204 204 137 7 3 Debit Card
205 205 287 12 4 UPI
206 206 198 2 1 Credit Card
207 207 297 18 5 Debit Card
208 208 35 16 2 Debit Card
209 209 73 17 5 Debit Card
210 210 251 11 4 Cash on Delivery
211 211 82 2 1 UPI
212 212 175 14 5 Credit Card
213 213 93 17 5 Cash on Delivery
214 214 234 13 2 Credit Card
215 215 272 9 5 Cash on Delivery
216 216 143 15 3 UPI
217 217 150 3 3 Credit Card
218 218 136 6 5 Debit Card
219 219 214 10 1 Credit Card
220 220 198 12 5 Cash on Delivery
221 221 261 15 1 Credit Card
222 222 9 9 5 UPI
223 223 287 15 5 Credit Card
224 224 67 4 2 Credit Card
225 225 32 9 4 Debit Card
226 226 23 5 4 Cash on Delivery
227 227 82 14 3 Debit Card
228 228 115 17 1 UPI
229 229 281 2 5 UPI
230 230 294 19 2 Cash on Delivery
231 231 30 5 1 UPI
232 232 166 11 4 Cash on Delivery
233 233 132 1 1 UPI
234 234 209 7 5 UPI
235 235 70 15 2 Debit Card
236 236 154 5 5 Credit Card
237 237 39 11 1 Cash on Delivery
238 238 126 16 5 Cash on Delivery
239 239 231 10 5 Cash on Delivery
240 240 149 2 1 Cash on Delivery
241 241 115 6 4 Debit Card
242 242 17 12 4 Cash on Delivery
243 243 135 19 2 UPI
244 244 195 12 5 UPI
245 245 216 3 2 Debit Card
246 246 207 8 4 Cash on Delivery
247 247 280 13 2 Debit Card
248 248 87 16 1 Debit Card
249 249 46 2 1 Debit Card
250 250 27 13 3 Debit Card
251 251 49 13 2 UPI
252 252 136 6 4 UPI
253 253 225 19 2 Debit Card
254 254 98 11 1 UPI
255 255 77 12 5 Credit Card
256 256 211 11 3 Cash on Delivery
257 257 95 1 3 Credit Card
258 258 20 8 2 Cash on Delivery
259 259 157 1 5 UPI
260 260 184 8 5 Debit Card
261 261 246 12 4 Credit Card
262 262 137 8 1 Cash on Delivery
263 263 208 16 3 UPI
264 264 213 10 2 Debit Card
265 265 225 15 3 Cash on Delivery
266 266 255 10 1 UPI
267 267 49 8 3 Credit Card
268 268 42 8 5 Debit Card
269 269 139 2 2 Debit Card
270 270 65 14 3 UPI
271 271 203 18 1 Debit Card
272 272 113 11 4 Cash on Delivery
273 273 242 2 3 UPI
274 274 223 19 2 UPI
275 275 14 16 3 UPI
276 276 232 2 5 Debit Card
277 277 37 9 3 Cash on Delivery
278 278 93 5 5 UPI
279 279 138 6 4 Debit Card
280 280 49 18 3 Cash on Delivery
281 281 52 17 4 UPI
282 282 150 12 4 UPI
283 283 172 15 5 Cash on Delivery
284 284 255 2 5 Credit Card
285 285 267 14 2 Cash on Delivery
286 286 274 2 4 Credit Card
287 287 127 16 1 Cash on Delivery
288 288 140 15 2 Debit Card
289 289 199 10 2 Debit Card
290 290 174 3 3 UPI
291 291 191 2 4 Cash on Delivery
292 292 30 11 2 Cash on Delivery
293 293 198 8 3 Debit Card
294 294 292 16 2 Cash on Delivery
295 295 181 9 5 Cash on Delivery
296 296 157 15 5 Cash on Delivery
297 297 293 13 5 Debit Card
298 298 189 18 4 Debit Card
299 299 182 15 2 Debit Card
300 300 183 12 3 Debit Card
TransactionDate ProductCategory Price Rating TotalAmount Age Gender
1 12/28/2023 Clothing 33.36 4.2 166.80 50.0000 Male
2 4/17/2023 Electronics 389.03 2.2 389.03 19.0000 Female
3 1/17/2023 Clothing 145.89 1.7 729.45 37.0000 Female
4 10/23/2023 Home Appliances 215.02 2.7 645.06 50.0000 Male
5 6/30/2023 Home Appliances 325.48 3.4 1627.40 24.0000 Male
6 6/14/2023 Electronics 389.03 2.2 778.06 50.0000 Male
7 7/26/2023 Electronics 193.15 3.7 193.15 40.0000 Male
8 5/23/2023 Clothing 350.44 1.4 1752.20 37.0000 Male
9 11/1/2023 Clothing 350.44 1.4 1401.76 25.0000 Female
10 12/3/2023 Electronics 280.91 1.9 561.82 53.0000 Female
11 5/29/2023 Electronics 280.91 1.9 842.73 65.0000 Male
12 6/7/2023 Home Appliances 341.40 3.0 1024.20 62.0000 Male
13 6/13/2023 Home Appliances 325.48 3.4 1301.92 41.7911 Male
14 3/7/2023 Electronics 123.63 2.1 247.26 41.7911 Female
15 1/12/2023 Clothing 350.44 1.4 1401.76 41.7911 Male
16 10/10/2023 Electronics 280.91 1.9 280.91 41.7911 Female
17 3/8/2023 Clothing 33.36 4.2 100.08 41.7911 Male
18 10/2/2023 Clothing 117.70 4.9 117.70 41.7911 Male
19 1/24/2023 Electronics 193.15 3.7 579.45 41.7911 Male
20 6/13/2023 Clothing 243.41 5.0 486.82 41.7911 Female
21 11/30/2023 Clothing 145.89 1.7 145.89 34.0000 Female
22 2/9/2023 Home Appliances 325.48 3.4 1301.92 24.0000 Male
23 6/26/2023 Electronics 280.91 1.9 842.73 25.0000 Male
24 3/26/2023 Electronics 132.51 2.3 265.02 52.0000 Male
25 7/9/2023 Clothing 145.89 1.7 437.67 53.0000 Female
26 5/30/2023 Home Appliances 341.40 3.0 1365.60 29.0000 Male
27 4/27/2023 Electronics 132.51 2.3 132.51 24.0000 Male
28 8/3/2023 Clothing 33.36 4.2 166.80 24.0000 Male
29 6/1/2023 Electronics 389.03 2.2 778.06 44.0000 Female
30 2/6/2023 Home Appliances 450.57 3.0 2252.85 19.0000 Male
31 12/21/2023 Electronics 211.39 2.6 1056.95 65.0000 Female
32 4/11/2023 Clothing 35.90 1.5 35.90 22.0000 Female
33 2/5/2023 Home Appliances 325.48 3.4 976.44 52.0000 Male
34 2/14/2023 Home Appliances 215.02 2.7 1075.10 24.0000 Male
35 9/13/2023 Home Appliances 341.40 3.0 1365.60 43.0000 Female
36 4/28/2023 Clothing 212.98 2.6 425.96 44.0000 Male
37 11/29/2023 Clothing 212.98 2.6 638.94 47.0000 Male
38 5/12/2023 Clothing 418.39 4.9 1255.17 21.0000 Male
39 7/10/2023 Clothing 350.44 1.4 1051.32 42.0000 Male
40 1/16/2023 Electronics 123.63 2.1 618.15 50.0000 Female
41 8/22/2023 Electronics 193.15 3.7 579.45 43.0000 Male
42 7/9/2023 Electronics 123.63 2.1 618.15 23.0000 Male
43 10/15/2023 Home Appliances 215.02 2.7 1075.10 25.0000 Female
44 10/6/2023 Electronics 193.15 3.7 386.30 27.0000 Female
45 9/6/2023 Home Appliances 466.49 2.6 1865.96 18.0000 Female
46 9/2/2023 Clothing 212.98 2.6 425.96 35.0000 Female
47 8/31/2023 Clothing 350.44 1.4 1752.20 42.0000
48 3/17/2023 Home Appliances 341.40 3.0 1365.60 53.0000
49 5/2/2023 Electronics 211.39 2.6 845.56 34.0000
50 12/5/2023 Electronics 389.03 2.2 1167.09 49.0000
51 2/27/2023 Clothing 212.98 2.6 638.94 63.0000
52 12/25/2023 Clothing 33.36 4.2 66.72 27.0000
53 9/8/2023 Electronics 193.15 3.7 193.15 49.0000
54 8/20/2023 Home Appliances 172.25 4.3 861.25 18.0000
55 1/16/2023 Clothing 117.70 4.9 353.10 62.0000
56 9/23/2023 Electronics 123.63 2.1 370.89 43.0000
57 11/11/2023 Clothing 117.70 4.9 588.50 41.0000
58 11/15/2023 Electronics 211.39 2.6 1056.95 41.0000
59 5/28/2023 Electronics 280.91 1.9 280.91 52.0000
60 1/18/2023 Clothing 243.41 5.0 243.41 44.0000 Female
61 2/7/2023 Electronics 389.03 2.2 1945.15 31.0000 Male
62 8/19/2023 Home Appliances 466.49 2.6 1865.96 43.0000 Female
63 10/14/2023 Electronics 132.51 2.3 265.02 37.0000 Female
64 10/17/2023 Clothing 145.89 1.7 145.89 50.0000 Male
65 4/27/2023 Clothing 145.89 1.7 291.78 26.0000 Female
66 3/17/2023 Home Appliances 450.57 3.0 901.14 24.0000 Female
67 11/29/2023 Clothing 243.41 5.0 730.23 36.0000 Female
68 1/28/2023 Electronics 132.51 2.3 662.55 24.0000 Male
69 6/27/2023 Electronics 123.63 2.1 618.15 28.0000 Female
70 6/5/2023 Clothing 33.36 4.2 133.44 62.0000 Female
71 6/21/2023 Clothing 145.89 1.7 729.45 61.0000 Female
72 1/7/2023 Home Appliances 341.40 3.0 682.80 50.0000 Female
73 8/22/2023 Clothing 243.41 5.0 243.41 37.0000 Female
74 8/19/2023 Home Appliances 466.49 2.6 1399.47 52.0000 Female
75 4/3/2023 Clothing 145.89 1.7 145.89 38.0000 Female
76 3/15/2023 Home Appliances 466.49 2.6 932.98 25.0000 Female
77 11/24/2023 Clothing 35.90 1.5 71.80 25.0000 Male
78 2/15/2023 Clothing 418.39 4.9 1673.56 65.0000 Female
79 2/1/2023 Home Appliances 172.25 4.3 689.00 49.0000 Female
80 3/26/2023 Electronics 280.91 1.9 280.91 44.0000 Female
81 4/5/2023 Home Appliances 466.49 2.6 1865.96 63.0000 Female
82 7/5/2023 Home Appliances 325.48 3.4 1301.92 59.0000 Male
83 5/27/2023 Clothing 350.44 1.4 350.44 24.0000 Male
84 8/19/2023 Clothing 145.89 1.7 437.67 41.0000 Male
85 12/10/2023 Clothing 243.41 5.0 486.82 56.0000 Male
86 3/14/2023 Clothing 212.98 2.6 638.94 56.0000 Female
87 5/16/2023 Clothing 350.44 1.4 1051.32 49.0000 Male
88 4/8/2023 Clothing 212.98 2.6 1064.90 63.0000 Female
89 8/6/2023 Home Appliances 172.25 4.3 172.25 46.0000 Female
90 2/10/2023 Home Appliances 466.49 2.6 2332.45 60.0000 Female
91 2/11/2023 Electronics 123.63 2.1 618.15 28.0000 Female
92 10/22/2023 Clothing 145.89 1.7 291.78 46.0000 Female
93 10/6/2023 Home Appliances 450.57 3.0 450.57 22.0000 Female
94 6/4/2023 Home Appliances 466.49 2.6 1865.96 52.0000 Male
95 9/17/2023 Clothing 243.41 5.0 1217.05 61.0000 Male
96 10/17/2023 Home Appliances 450.57 3.0 901.14 62.0000 Female
97 2/16/2023 Electronics 193.15 3.7 965.75 36.0000 Male
98 7/11/2023 Electronics 211.39 2.6 1056.95 42.0000 Female
99 11/17/2023 Electronics 193.15 3.7 193.15 47.0000 Male
100 7/18/2023 Home Appliances 450.57 3.0 901.14 57.0000 Male
101 5/25/2023 Clothing 145.89 1.7 729.45 54.0000 Male
102 5/7/2023 Electronics 280.91 1.9 842.73 43.0000 Male
103 8/11/2023 Home Appliances 325.48 3.4 1301.92 47.0000 Female
104 8/16/2023 Clothing 145.89 1.7 729.45 32.0000 Female
105 6/15/2023 Clothing 145.89 1.7 437.67 40.0000 Female
106 12/6/2023 Clothing 35.90 1.5 35.90 27.0000 Male
107 3/1/2023 Clothing 243.41 5.0 730.23 39.0000 Male
108 1/17/2023 Home Appliances 215.02 2.7 430.04 26.0000 Male
109 7/11/2023 Home Appliances 450.57 3.0 1802.28 43.0000 Female
110 12/27/2023 Clothing 350.44 1.4 1401.76 20.0000 Female
111 8/26/2023 Home Appliances 341.40 3.0 1707.00 24.0000 Female
112 2/28/2023 Clothing 212.98 2.6 212.98 58.0000 Male
113 6/3/2023 Electronics 280.91 1.9 1123.64 59.0000 Male
114 3/22/2023 Electronics 389.03 2.2 1556.12 19.0000 Male
115 8/29/2023 Clothing 350.44 1.4 350.44 28.0000 Female
116 2/1/2023 Clothing 350.44 1.4 1401.76 59.0000 Male
117 8/6/2023 Clothing 243.41 5.0 730.23 42.0000 Male
118 11/23/2023 Electronics 211.39 2.6 634.17 18.0000 Male
119 11/21/2023 Clothing 145.89 1.7 729.45 42.0000 Male
120 4/23/2023 Home Appliances 215.02 2.7 1075.10 22.0000 Male
121 6/6/2023 Clothing 418.39 4.9 418.39 38.0000 Male
122 12/10/2023 Home Appliances 341.40 3.0 1365.60 65.0000 Male
123 10/4/2023 Clothing 418.39 4.9 418.39 56.0000 Male
124 2/17/2023 Electronics 211.39 2.6 634.17 50.0000 Male
125 12/7/2023 Clothing 418.39 4.9 1673.56 40.0000 Male
126 8/29/2023 Home Appliances 341.40 3.0 682.80 52.0000 Female
127 7/5/2023 Clothing 33.36 4.2 33.36 31.0000 Male
128 8/3/2023 Home Appliances 466.49 2.6 932.98 24.0000 Male
129 1/11/2023 Electronics 123.63 2.1 618.15 34.0000 Female
130 3/28/2023 Electronics 123.63 2.1 370.89 33.0000 Female
131 5/30/2023 Electronics 280.91 1.9 280.91 41.0000 Male
132 4/2/2023 Home Appliances 325.48 3.4 1301.92 38.0000 Male
133 9/30/2023 Electronics 193.15 3.7 965.75 31.0000 Female
134 12/1/2023 Clothing 418.39 4.9 1673.56 40.0000 Female
135 2/3/2023 Home Appliances 450.57 3.0 1802.28 43.0000 Male
136 4/7/2023 Electronics 193.15 3.7 386.30 58.0000 Male
137 11/25/2023 Clothing 145.89 1.7 145.89 23.0000 Male
138 10/18/2023 Home Appliances 450.57 3.0 1351.71 59.0000 Male
139 1/4/2023 Electronics 132.51 2.3 397.53 53.0000 Male
140 9/3/2023 Home Appliances 172.25 4.3 861.25 62.0000 Male
141 4/28/2023 Clothing 243.41 5.0 730.23 24.0000 Male
142 2/10/2023 Electronics 132.51 2.3 662.55 32.0000 Male
143 11/27/2023 Clothing 212.98 2.6 425.96 24.0000 Male
144 10/24/2023 Clothing 145.89 1.7 145.89 63.0000 Female
145 9/29/2023 Electronics 193.15 3.7 386.30 42.0000 Male
146 4/18/2023 Home Appliances 341.40 3.0 1707.00 22.0000 Female
147 1/13/2023 Electronics 211.39 2.6 845.56 25.0000 Male
148 12/8/2023 Home Appliances 172.25 4.3 344.50 45.0000 Male
149 9/4/2023 Electronics 389.03 2.2 1556.12 35.0000 Female
150 9/17/2023 Home Appliances 341.40 3.0 1024.20 21.0000 Male
151 7/19/2023 Electronics 280.91 1.9 1123.64 30.0000 Male
152 2/6/2023 Home Appliances 172.25 4.3 516.75 44.0000 Female
153 10/1/2023 Clothing 350.44 1.4 350.44 37.0000 Female
154 3/19/2023 Clothing 117.70 4.9 353.10 46.0000 Female
155 4/12/2023 Home Appliances 450.57 3.0 2252.85 29.0000 Female
156 9/6/2023 Clothing 145.89 1.7 729.45 62.0000 Female
157 5/30/2023 Electronics 123.63 2.1 247.26 37.0000 Male
158 12/15/2023 Electronics 123.63 2.1 618.15 42.0000 Male
159 9/12/2023 Home Appliances 466.49 2.6 466.49 21.0000 Male
160 4/30/2023 Home Appliances 215.02 2.7 860.08 42.0000 Male
161 7/30/2023 Electronics 211.39 2.6 211.39 44.0000 Male
162 10/21/2023 Clothing 212.98 2.6 638.94 55.0000 Female
163 6/17/2023 Electronics 389.03 2.2 778.06 33.0000 Male
164 5/15/2023 Clothing 350.44 1.4 1051.32 56.0000 Male
165 12/17/2023 Clothing 117.70 4.9 235.40 40.0000 Male
166 8/24/2023 Clothing 212.98 2.6 212.98 32.0000 Female
167 2/5/2023 Clothing 243.41 5.0 730.23 63.0000 Male
168 9/25/2023 Clothing 35.90 1.5 179.50 39.0000 Male
169 4/23/2023 Electronics 132.51 2.3 662.55 39.0000 Male
170 5/18/2023 Home Appliances 466.49 2.6 1399.47 24.0000 Female
171 8/20/2023 Clothing 33.36 4.2 166.80 52.0000 Male
172 7/7/2023 Clothing 212.98 2.6 212.98 60.0000 Male
173 5/18/2023 Electronics 132.51 2.3 132.51 48.0000 Female
174 11/26/2023 Clothing 418.39 4.9 418.39 53.0000 Female
175 4/3/2023 Clothing 145.89 1.7 145.89 35.0000 Female
176 11/27/2023 Electronics 132.51 2.3 662.55 63.0000 Male
177 8/30/2023 Home Appliances 325.48 3.4 1627.40 30.0000 Male
178 11/13/2023 Electronics 280.91 1.9 1404.55 33.0000 Male
179 5/5/2023 Home Appliances 466.49 2.6 1865.96 44.0000 Male
180 2/23/2023 Clothing 33.36 4.2 133.44 54.0000 Female
181 7/13/2023 Electronics 193.15 3.7 772.60 58.0000 Male
182 6/10/2023 Clothing 212.98 2.6 1064.90 40.0000 Male
183 10/4/2023 Home Appliances 172.25 4.3 172.25 44.0000 Female
184 5/27/2023 Home Appliances 325.48 3.4 650.96 22.0000 Male
185 2/14/2023 Electronics 193.15 3.7 579.45 41.0000 Male
186 5/14/2023 Clothing 145.89 1.7 437.67 22.0000 Female
187 7/14/2023 Home Appliances 325.48 3.4 1627.40 39.0000 Male
188 3/31/2023 Electronics 211.39 2.6 845.56 24.0000 Male
189 6/13/2023 Home Appliances 215.02 2.7 1075.10 50.0000 Female
190 3/15/2023 Home Appliances 215.02 2.7 430.04 63.0000 Female
191 11/19/2023 Electronics 389.03 2.2 1556.12 59.0000 Male
192 9/17/2023 Home Appliances 341.40 3.0 341.40 20.0000 Female
193 10/21/2023 Clothing 117.70 4.9 235.40 43.0000 Female
194 3/20/2023 Home Appliances 172.25 4.3 689.00 40.0000 Female
195 9/3/2023 Clothing 418.39 4.9 418.39 19.0000 Female
196 9/1/2023 Clothing 212.98 2.6 212.98 63.0000 Female
197 1/13/2023 Home Appliances 325.48 3.4 1627.40 42.0000 Female
198 11/15/2023 Clothing 33.36 4.2 33.36 58.0000 Female
199 4/5/2023 Clothing 418.39 4.9 418.39 56.0000 Female
200 11/22/2023 Electronics 280.91 1.9 561.82 52.0000 Male
201 11/18/2023 Clothing 145.89 1.7 729.45 64.0000 Female
202 6/7/2023 Electronics 211.39 2.6 1056.95 56.0000 Female
203 5/20/2023 Clothing 145.89 1.7 437.67 41.0000 Female
204 12/12/2023 Clothing 212.98 2.6 638.94 49.0000 Male
205 9/7/2023 Home Appliances 466.49 2.6 1865.96 54.0000 Male
206 10/24/2023 Home Appliances 325.48 3.4 325.48 35.0000 Female
207 5/8/2023 Home Appliances 341.40 3.0 1707.00 52.0000 Male
208 8/21/2023 Home Appliances 172.25 4.3 344.50 26.0000 Female
209 7/6/2023 Electronics 280.91 1.9 1404.55 51.0000 Female
210 10/27/2023 Electronics 123.63 2.1 494.52 63.0000 Female
211 4/12/2023 Home Appliances 325.48 3.4 325.48 42.0000 Female
212 7/7/2023 Clothing 33.36 4.2 166.80 25.0000 Female
213 6/20/2023 Electronics 280.91 1.9 1404.55 31.0000 Male
214 4/25/2023 Clothing 243.41 5.0 486.82 46.0000 Female
215 4/20/2023 Electronics 132.51 2.3 662.55 45.0000 Female
216 7/3/2023 Electronics 389.03 2.2 1167.09 36.0000 Female
217 11/28/2023 Clothing 117.70 4.9 353.10 65.0000 Female
218 11/17/2023 Home Appliances 450.57 3.0 2252.85 41.0000 Male
219 6/27/2023 Electronics 193.15 3.7 193.15 43.0000 Female
220 2/8/2023 Home Appliances 466.49 2.6 2332.45 35.0000 Female
221 6/5/2023 Electronics 389.03 2.2 389.03 38.0000 Male
222 11/21/2023 Electronics 132.51 2.3 662.55 42.0000 Female
223 7/1/2023 Electronics 389.03 2.2 1945.15 54.0000 Male
224 1/21/2023 Clothing 418.39 4.9 836.78 39.0000 Male
225 7/16/2023 Electronics 132.51 2.3 530.04 59.0000 Male
226 1/12/2023 Clothing 350.44 1.4 1401.76 36.0000 Female
227 2/5/2023 Clothing 33.36 4.2 100.08 42.0000 Female
228 12/15/2023 Electronics 280.91 1.9 280.91 57.0000 Female
229 8/20/2023 Home Appliances 325.48 3.4 1627.40 19.0000 Male
230 5/9/2023 Clothing 145.89 1.7 291.78 55.0000 Male
231 6/3/2023 Clothing 350.44 1.4 350.44 32.0000 Female
232 11/4/2023 Electronics 123.63 2.1 494.52 57.0000 Female
233 3/20/2023 Home Appliances 215.02 2.7 215.02 59.0000 Male
234 12/14/2023 Clothing 212.98 2.6 1064.90 27.0000 Female
235 6/25/2023 Electronics 389.03 2.2 778.06 48.0000 Female
236 9/27/2023 Clothing 350.44 1.4 1752.20 56.0000 Male
237 3/2/2023 Electronics 123.63 2.1 123.63 44.0000 Male
238 1/8/2023 Home Appliances 172.25 4.3 861.25 43.0000 Male
239 12/13/2023 Electronics 193.15 3.7 965.75 43.0000 Male
240 10/1/2023 Home Appliances 325.48 3.4 325.48 51.0000 Male
241 9/5/2023 Home Appliances 450.57 3.0 1802.28 57.0000 Female
242 1/15/2023 Home Appliances 466.49 2.6 1865.96 52.0000 Female
243 11/7/2023 Clothing 145.89 1.7 291.78 33.0000 Female
244 8/1/2023 Home Appliances 466.49 2.6 2332.45 27.0000 Female
245 1/25/2023 Clothing 117.70 4.9 235.40 42.0000 Male
246 7/5/2023 Electronics 211.39 2.6 845.56 50.0000 Male
247 7/22/2023 Clothing 243.41 5.0 486.82 19.0000 Male
248 1/1/2023 Home Appliances 172.25 4.3 172.25 47.0000 Male
249 2/23/2023 Home Appliances 325.48 3.4 325.48 46.0000 Female
250 7/24/2023 Clothing 243.41 5.0 730.23 60.0000 Male
251 2/9/2023 Clothing 243.41 5.0 486.82 29.0000 Female
252 11/24/2023 Home Appliances 450.57 3.0 1802.28 41.0000 Male
253 10/1/2023 Clothing 145.89 1.7 291.78 40.0000 Female
254 8/4/2023 Electronics 123.63 2.1 123.63 40.0000 Male
255 6/22/2023 Home Appliances 466.49 2.6 2332.45 42.0000 Male
256 12/1/2023 Electronics 123.63 2.1 370.89 60.0000 Female
257 12/26/2023 Home Appliances 215.02 2.7 645.06 49.0000 Male
258 3/31/2023 Electronics 211.39 2.6 422.78 24.0000 Male
259 3/21/2023 Home Appliances 215.02 2.7 1075.10 57.0000 Male
260 1/24/2023 Electronics 211.39 2.6 1056.95 25.0000 Male
261 4/22/2023 Home Appliances 466.49 2.6 1865.96 34.0000 Male
262 6/21/2023 Electronics 211.39 2.6 211.39 49.0000 Male
263 12/18/2023 Home Appliances 172.25 4.3 516.75 46.0000 Female
264 12/2/2023 Electronics 193.15 3.7 386.30 42.0000 Male
265 6/20/2023 Electronics 389.03 2.2 1167.09 40.0000 Female
266 7/16/2023 Electronics 193.15 3.7 193.15 27.0000 Male
267 5/12/2023 Electronics 211.39 2.6 634.17 29.0000 Female
268 6/3/2023 Electronics 211.39 2.6 1056.95 49.0000 Male
269 7/4/2023 Home Appliances 325.48 3.4 650.96 28.0000 Male
270 3/19/2023 Clothing 33.36 4.2 100.08 60.0000 Female
271 6/7/2023 Home Appliances 341.40 3.0 341.40 41.0000 Male
272 2/25/2023 Electronics 123.63 2.1 494.52 63.0000 Male
273 4/5/2023 Home Appliances 325.48 3.4 976.44 23.0000 Female
274 6/29/2023 Clothing 145.89 1.7 291.78 58.0000 Female
275 11/26/2023 Home Appliances 172.25 4.3 516.75 45.0000 Male
276 3/24/2023 Home Appliances 325.48 3.4 1627.40 59.0000 Male
277 4/6/2023 Electronics 132.51 2.3 397.53 27.0000 Male
278 5/13/2023 Clothing 350.44 1.4 1752.20 31.0000 Male
279 5/9/2023 Home Appliances 450.57 3.0 1802.28 38.0000 Male
280 3/17/2023 Home Appliances 341.40 3.0 1024.20 29.0000 Female
281 5/26/2023 Electronics 280.91 1.9 1123.64 50.0000 Male
282 5/14/2023 Home Appliances 466.49 2.6 1865.96 65.0000 Male
283 11/16/2023 Electronics 389.03 2.2 1945.15 59.0000 Male
284 7/26/2023 Home Appliances 325.48 3.4 1627.40 27.0000 Male
285 12/17/2023 Clothing 33.36 4.2 66.72 24.0000 Male
286 6/27/2023 Home Appliances 325.48 3.4 1301.92 24.0000 Male
287 6/19/2023 Home Appliances 172.25 4.3 172.25 55.0000 Female
288 12/16/2023 Electronics 389.03 2.2 778.06 53.0000 Male
289 1/29/2023 Electronics 193.15 3.7 386.30 26.0000 Male
290 1/6/2023 Clothing 117.70 4.9 353.10 28.0000 Male
291 8/20/2023 Home Appliances 325.48 3.4 1301.92 40.0000 Male
292 11/11/2023 Electronics 123.63 2.1 247.26 32.0000 Female
293 10/8/2023 Electronics 211.39 2.6 634.17 35.0000 Female
294 4/15/2023 Home Appliances 172.25 4.3 344.50 59.0000 Female
295 9/28/2023 Electronics 132.51 2.3 662.55 30.0000 Male
296 3/13/2023 Electronics 389.03 2.2 1945.15 57.0000 Male
297 10/5/2023 Clothing 243.41 5.0 1217.05 59.0000 Male
298 8/2/2023 Home Appliances 341.40 3.0 1365.60 31.0000 Male
299 11/12/2023 Electronics 389.03 2.2 778.06 63.0000 Female
300 2/19/2023 Home Appliances 466.49 2.6 1399.47 23.0000 Female
Location MembershipStatus
1 Houston Basic
2 Chicago Premium
3 Houston Basic
4 Los Angeles Premium
5 New York Premium
6 Houston Premium
7 Los Angeles Gold
8 Houston Premium
9 Houston Premium
10 Chicago Basic
11 Los Angeles Gold
12 Chicago Basic
13 Chicago Premium
14 Houston Premium
15 Houston Gold
16 Houston Basic
17 Chicago Basic
18 New York Basic
19 Houston Gold
20 Houston Premium
21 New York Premium
22 New York Gold
23 Chicago Gold
24 Houston Basic
25 Chicago Basic
26 New York Basic
27 New York Premium
28 New York Gold
29 New York Basic
30 Chicago Basic
31 New York Gold
32 Chicago Basic
33 Houston Basic
34 New York Premium
35 Los Angeles Basic
36 Chicago Gold
37 Houston Gold
38 Los Angeles Basic
39 Houston Gold
40 Houston Gold
41 Los Angeles Basic
42 New York Basic
43 Los Angeles Gold
44 New York Gold
45 Chicago Basic
46 Chicago Premium
47 Los Angeles Premium
48 Chicago Basic
49 Chicago Basic
50 New York Premium
51 Houston Basic
52 Chicago Gold
53 Chicago Premium
54 Chicago Basic
55 Chicago Basic
56 New York Basic
57 Chicago Gold
58 New York Basic
59 Chicago Gold
60 New York Gold
61 Houston Gold
62 Chicago Premium
63 Los Angeles Premium
64 Houston Premium
65 Houston Basic
66 New York Premium
67 New York Basic
68 Houston Premium
69 New York Gold
70 New York Premium
71 Los Angeles Gold
72 Los Angeles Basic
73 New York Gold
74 Chicago Gold
75 Los Angeles Basic
76 Houston Premium
77 New York Gold
78 Los Angeles Basic
79 Houston Gold
80 Houston Gold
81 Chicago Premium
82 Houston Gold
83 New York Premium
84 Chicago Premium
85 Los Angeles Basic
86 Los Angeles Basic
87 Los Angeles Gold
88 Chicago Gold
89 Chicago Gold
90 Houston Gold
91 Los Angeles Premium
92 New York Premium
93 Chicago Premium
94 New York Gold
95 Houston Gold
96 New York Premium
97 Chicago Premium
98 Chicago Premium
99 New York Premium
100 Chicago Gold
101 Chicago Basic
102 New York Basic
103 Houston Gold
104 Houston Premium
105 Los Angeles Gold
106 Los Angeles Gold
107 New York Basic
108 Los Angeles Premium
109 Chicago Premium
110 New York Gold
111 Houston Premium
112 Chicago Gold
113 Houston Basic
114 Chicago Basic
115 Los Angeles Premium
116 Chicago Premium
117 Los Angeles Basic
118 Los Angeles Gold
119 Chicago Basic
120 Houston Premium
121 New York Basic
122 Los Angeles Basic
123 New York Premium
124 Los Angeles Premium
125 Chicago Basic
126 Chicago Gold
127 Los Angeles Gold
128 New York Premium
129 Los Angeles Basic
130 New York Basic
131 Chicago Premium
132 Los Angeles Basic
133 Los Angeles Premium
134 Chicago Premium
135 Chicago Premium
136 Chicago Gold
137 Los Angeles Gold
138 Houston Gold
139 Houston Premium
140 New York Premium
141 New York Premium
142 Los Angeles Basic
143 New York Premium
144 Chicago Gold
145 Houston Gold
146 Chicago Basic
147 Los Angeles Gold
148 Los Angeles Premium
149 Los Angeles Premium
150 Los Angeles Basic
151 Chicago Basic
152 New York Basic
153 Los Angeles Premium
154 Chicago Gold
155 Chicago Premium
156 Chicago Basic
157 Chicago Premium
158 Chicago Premium
159 Los Angeles Basic
160 Los Angeles Gold
161 New York Premium
162 Houston Gold
163 New York Premium
164 Houston Basic
165 Chicago Basic
166 Los Angeles Basic
167 New York Premium
168 Houston Gold
169 Houston Gold
170 Houston Premium
171 Houston Basic
172 Houston Premium
173 Los Angeles Gold
174 Houston Basic
175 Houston Gold
176 Houston Basic
177 Chicago Basic
178 Los Angeles Basic
179 New York Premium
180 Los Angeles Basic
181 New York Basic
182 Chicago Basic
183 Los Angeles Basic
184 Los Angeles Premium
185 Chicago Premium
186 Chicago Basic
187 Houston Gold
188 New York Gold
189 Los Angeles Premium
190 Chicago Gold
191 Houston Basic
192 Chicago Premium
193 Houston Gold
194 Chicago Gold
195 Chicago Premium
196 Chicago Gold
197 Chicago Basic
198 Los Angeles Gold
199 New York Premium
200 New York Gold
201 Chicago Gold
202 Houston Basic
203 New York Basic
204 Chicago Premium
205 Chicago Basic
206 Houston Basic
207 Chicago Premium
208 Houston Gold
209 Houston Premium
210 Houston Basic
211 New York Basic
212 Chicago Gold
213 New York Premium
214 Los Angeles Basic
215 Houston Basic
216 New York Basic
217 Chicago Premium
218 Chicago Premium
219 Los Angeles Gold
220 Houston Basic
221 New York Basic
222 Chicago Premium
223 Chicago Basic
224 Houston Gold
225 Los Angeles Basic
226 New York Gold
227 New York Basic
228 Houston Basic
229 New York Gold
230 Chicago Gold
231 Los Angeles Basic
232 New York Premium
233 Houston Basic
234 Chicago Premium
235 Los Angeles Gold
236 Los Angeles Basic
237 New York Premium
238 Houston Basic
239 Los Angeles Basic
240 Chicago Gold
241 Houston Basic
242 Chicago Gold
243 Houston Premium
244 Chicago Gold
245 Chicago Premium
246 Houston Basic
247 Houston Basic
248 Houston Gold
249 Chicago Premium
250 New York Basic
251 Chicago Premium
252 Chicago Premium
253 Los Angeles Gold
254 Chicago Basic
255 Los Angeles Basic
256 Houston Gold
257 New York Premium
258 New York Gold
259 Chicago Gold
260 Los Angeles Gold
261 Houston Gold
262 Chicago Premium
263 Los Angeles Gold
264 Chicago Basic
265 Los Angeles Gold
266 New York Gold
267 Chicago Premium
268 Houston Gold
269 New York Gold
270 New York Premium
271 Chicago Gold
272 New York Gold
273 Chicago Premium
274 Chicago Basic
275 Los Angeles Premium
276 Houston Basic
277 Houston Basic
278 New York Premium
279 Los Angeles Basic
280 Chicago Premium
281 Houston Premium
282 Chicago Premium
283 Los Angeles Gold
284 New York Gold
285 New York Premium
286 New York Premium
287 Houston Gold
288 Houston Premium
289 Houston Basic
290 New York Premium
291 Los Angeles Gold
292 Los Angeles Basic
293 Houston Basic
294 Chicago Premium
295 Los Angeles Premium
296 Chicago Gold
297 Los Angeles Basic
298 Los Angeles Gold
299 Houston Basic
300 Chicago BasicOutlier Detection
Removing Outliers Using IQR
TransactionID CustomerID ProductID Quantity PaymentMethod TransactionDate
1 1 207 14 5 UPI 12/28/2023
2 2 253 15 1 Cash on Delivery 4/17/2023
3 3 110 19 5 Cash on Delivery 1/17/2023
4 4 256 1 3 Debit Card 10/23/2023
5 5 274 2 5 Debit Card 6/30/2023
6 6 52 15 2 Credit Card 6/14/2023
ProductCategory Price Rating TotalAmount Age Gender Location
1 Clothing 33.36 4.2 166.80 50 Male Houston
2 Electronics 389.03 2.2 389.03 19 Female Chicago
3 Clothing 145.89 1.7 729.45 37 Female Houston
4 Home Appliances 215.02 2.7 645.06 50 Male Los Angeles
5 Home Appliances 325.48 3.4 1627.40 24 Male New York
6 Electronics 389.03 2.2 778.06 50 Male Houston
MembershipStatus
1 Basic
2 Premium
3 Basic
4 Premium
5 Premium
6 Premium TransactionID CustomerID ProductID Quantity PaymentMethod TransactionDate
1 1 207 14 5 UPI 12/28/2023
2 2 253 15 1 Cash on Delivery 4/17/2023
3 3 110 19 5 Cash on Delivery 1/17/2023
4 4 256 1 3 Debit Card 10/23/2023
5 5 274 2 5 Debit Card 6/30/2023
6 6 52 15 2 Credit Card 6/14/2023
ProductCategory Price Rating TotalAmount Age Gender Location
1 Clothing 33.36 4.2 166.80 50 Male Houston
2 Electronics 389.03 2.2 389.03 19 Female Chicago
3 Clothing 145.89 1.7 729.45 37 Female Houston
4 Home Appliances 215.02 2.7 645.06 50 Male Los Angeles
5 Home Appliances 325.48 3.4 1627.40 24 Male New York
6 Electronics 389.03 2.2 778.06 50 Male Houston
MembershipStatus
1 Basic
2 Premium
3 Basic
4 Premium
5 Premium
6 Premium TransactionID CustomerID ProductID Quantity PaymentMethod TransactionDate
1 1 207 14 5 UPI 12/28/2023
2 2 253 15 1 Cash on Delivery 4/17/2023
3 3 110 19 5 Cash on Delivery 1/17/2023
4 4 256 1 3 Debit Card 10/23/2023
5 5 274 2 5 Debit Card 6/30/2023
6 6 52 15 2 Credit Card 6/14/2023
ProductCategory Price Rating TotalAmount Age Gender Location
1 Clothing 33.36 4.2 166.80 50 Male Houston
2 Electronics 389.03 2.2 389.03 19 Female Chicago
3 Clothing 145.89 1.7 729.45 37 Female Houston
4 Home Appliances 215.02 2.7 645.06 50 Male Los Angeles
5 Home Appliances 325.48 3.4 1627.40 24 Male New York
6 Electronics 389.03 2.2 778.06 50 Male Houston
MembershipStatus
1 Basic
2 Premium
3 Basic
4 Premium
5 Premium
6 PremiumExploratory Data Analysis
Univariate Analysis
TransactionID CustomerID ProductID Quantity
Min. : 1.00 Min. : 4.0 Min. : 1.00 Min. :1.000
1st Qu.: 75.75 1st Qu.: 77.0 1st Qu.: 6.00 1st Qu.:2.000
Median :150.50 Median :156.5 Median :11.00 Median :3.000
Mean :150.50 Mean :154.8 Mean :10.66 Mean :3.127
3rd Qu.:225.25 3rd Qu.:229.2 3rd Qu.:15.00 3rd Qu.:5.000
Max. :300.00 Max. :299.0 Max. :20.00 Max. :5.000
PaymentMethod TransactionDate ProductCategory Price
Length:300 Length:300 Length:300 Min. : 33.36
Class :character Class :character Class :character 1st Qu.:145.89
Mode :character Mode :character Mode :character Median :215.02
Mean :253.52
3rd Qu.:350.44
Max. :466.49
Rating TotalAmount Age Gender
Min. :1.400 Min. : 33.36 Min. :18.00 Length:300
1st Qu.:2.100 1st Qu.: 350.44 1st Qu.:31.00 Class :character
Median :2.600 Median : 662.55 Median :42.00 Mode :character
Mean :2.928 Mean : 803.12 Mean :41.79
3rd Qu.:3.700 3rd Qu.:1134.50 3rd Qu.:52.00
Max. :5.000 Max. :2332.45 Max. :65.00
Location MembershipStatus
Length:300 Length:300
Class :character Class :character
Mode :character Mode :character
Bivariate Analysis
Compute correlation matrix
[1] "Correlation Matrix:" Age Price
Age 1.0000000 -0.0443366
Price -0.0443366 1.0000000[1] "Correlation Matrix:" Age Quantity
Age 1.00000000 0.02081234
Quantity 0.02081234 1.00000000Regression Model
Multiple Regression model
Identify all variable names
Define the variables
Fit the regression model
Call:
lm(formula = formula, clean_datae = clean_datae)
Residuals:
Min 1Q Median 3Q Max
-151.635 -0.109 0.000 3.064 151.635
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 1.162e+02 1.389e+02 0.837 0.40584
CustomerID 1.001e-01 1.039e-01 0.963 0.33893
ProductID -1.231e+00 1.778e+00 -0.692 0.49133
Quantity -7.408e+00 1.486e+01 -0.498 0.61984
PaymentMethodCredit Card 1.715e+01 2.727e+01 0.629 0.53161
PaymentMethodDebit Card 3.337e+01 2.685e+01 1.243 0.21842
PaymentMethodUPI -1.449e+01 2.558e+01 -0.566 0.57305
TransactionDate1/11/2023 -1.570e+02 1.316e+02 -1.193 0.23731
TransactionDate1/12/2023 -3.389e+01 1.187e+02 -0.285 0.77620
TransactionDate1/13/2023 -1.176e+02 1.102e+02 -1.067 0.29009
TransactionDate1/15/2023 8.465e+00 1.293e+02 0.065 0.94801
TransactionDate1/16/2023 -1.335e+02 1.139e+02 -1.172 0.24538
TransactionDate1/17/2023 -1.932e+02 1.093e+02 -1.768 0.08178 .
TransactionDate1/18/2023 -1.647e+02 1.239e+02 -1.329 0.18845
TransactionDate1/21/2023 5.651e+01 1.241e+02 0.455 0.65039
TransactionDate1/24/2023 -9.946e+01 1.077e+02 -0.924 0.35909
TransactionDate1/25/2023 -6.295e+01 1.230e+02 -0.512 0.61049
TransactionDate1/28/2023 -1.659e+02 1.271e+02 -1.305 0.19648
TransactionDate1/29/2023 1.108e+01 1.197e+02 0.093 0.92658
TransactionDate1/4/2023 -1.138e+02 1.237e+02 -0.920 0.36115
TransactionDate1/6/2023 5.670e+01 1.261e+02 0.450 0.65447
TransactionDate1/7/2023 -2.047e+02 1.273e+02 -1.608 0.11259
TransactionDate1/8/2023 3.319e+01 1.214e+02 0.273 0.78543
TransactionDate10/1/2023 -6.837e+01 1.033e+02 -0.662 0.51047
TransactionDate10/10/2023 -2.409e+02 1.247e+02 -1.932 0.05772 .
TransactionDate10/14/2023 -3.187e+02 1.268e+02 -2.513 0.01445 *
TransactionDate10/15/2023 -2.293e+02 1.298e+02 -1.766 0.08208 .
TransactionDate10/17/2023 -1.583e+02 1.098e+02 -1.442 0.15408
TransactionDate10/18/2023 -8.154e+01 1.178e+02 -0.692 0.49126
TransactionDate10/2/2023 -2.422e+02 1.263e+02 -1.918 0.05954 .
TransactionDate10/21/2023 -3.985e+01 1.099e+02 -0.363 0.71801
TransactionDate10/22/2023 -1.528e+02 1.294e+02 -1.181 0.24208
TransactionDate10/23/2023 -3.290e+02 1.231e+02 -2.672 0.00952 **
TransactionDate10/24/2023 -9.375e+01 1.081e+02 -0.867 0.38901
TransactionDate10/27/2023 -6.990e+01 1.283e+02 -0.545 0.58766
TransactionDate10/4/2023 -1.263e+02 1.087e+02 -1.162 0.24958
TransactionDate10/5/2023 5.584e+01 1.274e+02 0.438 0.66258
TransactionDate10/6/2023 -2.466e+02 1.081e+02 -2.282 0.02580 *
TransactionDate10/8/2023 -1.369e+01 1.236e+02 -0.111 0.91218
TransactionDate11/1/2023 -1.793e+02 1.341e+02 -1.337 0.18579
TransactionDate11/11/2023 -3.200e+01 1.117e+02 -0.286 0.77546
TransactionDate11/12/2023 7.534e+00 1.257e+02 0.060 0.95239
TransactionDate11/13/2023 -8.243e+01 1.321e+02 -0.624 0.53480
TransactionDate11/15/2023 -5.721e+01 1.145e+02 -0.500 0.61909
TransactionDate11/16/2023 7.349e+01 1.339e+02 0.549 0.58511
TransactionDate11/17/2023 -1.413e+02 1.081e+02 -1.307 0.19575
TransactionDate11/18/2023 6.874e+00 1.321e+02 0.052 0.95867
TransactionDate11/19/2023 -4.251e+01 1.247e+02 -0.341 0.73438
TransactionDate11/21/2023 -6.967e+01 1.164e+02 -0.598 0.55164
TransactionDate11/22/2023 -4.288e+01 1.266e+02 -0.339 0.73601
TransactionDate11/23/2023 -1.502e+02 1.262e+02 -1.190 0.23833
TransactionDate11/24/2023 -6.007e+01 1.085e+02 -0.554 0.58166
TransactionDate11/25/2023 -7.470e+01 1.239e+02 -0.603 0.54879
TransactionDate11/26/2023 -1.130e+01 1.078e+02 -0.105 0.91687
TransactionDate11/27/2023 -9.993e+01 1.102e+02 -0.907 0.36782
TransactionDate11/28/2023 -1.005e+02 1.305e+02 -0.770 0.44398
TransactionDate11/29/2023 -1.438e+02 1.089e+02 -1.321 0.19111
TransactionDate11/30/2023 -2.623e+02 1.278e+02 -2.053 0.04411 *
TransactionDate11/4/2023 -8.680e+01 1.316e+02 -0.660 0.51172
TransactionDate11/7/2023 2.275e+01 1.263e+02 0.180 0.85759
TransactionDate12/1/2023 -6.069e+01 1.132e+02 -0.536 0.59359
TransactionDate12/10/2023 -1.104e+02 1.111e+02 -0.994 0.32406
TransactionDate12/12/2023 -7.192e+01 1.235e+02 -0.582 0.56233
TransactionDate12/13/2023 -1.971e+01 1.283e+02 -0.154 0.87839
TransactionDate12/14/2023 -1.798e+01 1.328e+02 -0.135 0.89268
TransactionDate12/15/2023 -8.623e+01 1.113e+02 -0.775 0.44139
TransactionDate12/16/2023 1.651e+01 1.225e+02 0.135 0.89319
TransactionDate12/17/2023 -1.781e+01 1.090e+02 -0.163 0.87074
TransactionDate12/18/2023 -1.009e+00 1.234e+02 -0.008 0.99350
TransactionDate12/2/2023 -5.706e+01 1.242e+02 -0.460 0.64734
TransactionDate12/21/2023 -2.476e+02 1.330e+02 -1.861 0.06720 .
TransactionDate12/25/2023 -5.008e+01 1.331e+02 -0.376 0.70793
TransactionDate12/26/2023 -3.860e+01 1.244e+02 -0.310 0.75736
TransactionDate12/27/2023 -7.896e+01 1.347e+02 -0.586 0.55992
TransactionDate12/28/2023 -1.696e+02 1.257e+02 -1.350 0.18176
TransactionDate12/3/2023 -3.086e+02 1.324e+02 -2.331 0.02286 *
TransactionDate12/5/2023 -5.696e+01 1.451e+02 -0.393 0.69592
TransactionDate12/6/2023 -9.178e+01 1.253e+02 -0.733 0.46649
TransactionDate12/7/2023 -6.912e+01 1.313e+02 -0.526 0.60051
TransactionDate12/8/2023 -1.224e+02 1.216e+02 -1.006 0.31806
TransactionDate2/1/2023 -1.283e+02 1.092e+02 -1.175 0.24431
TransactionDate2/10/2023 -1.097e+02 1.112e+02 -0.987 0.32739
TransactionDate2/11/2023 -2.369e+02 1.329e+02 -1.783 0.07928 .
TransactionDate2/14/2023 -1.934e+02 1.086e+02 -1.781 0.07965 .
TransactionDate2/15/2023 -1.632e+02 1.368e+02 -1.193 0.23721
TransactionDate2/16/2023 -1.678e+02 1.290e+02 -1.301 0.19786
TransactionDate2/17/2023 -1.921e+02 1.279e+02 -1.502 0.13790
TransactionDate2/19/2023 -4.596e+00 1.253e+02 -0.037 0.97085
TransactionDate2/23/2023 -9.670e+01 1.090e+02 -0.887 0.37830
TransactionDate2/25/2023 3.337e+01 1.271e+02 0.263 0.79372
TransactionDate2/27/2023 -3.171e+01 1.376e+02 -0.230 0.81848
TransactionDate2/28/2023 -1.037e+02 1.250e+02 -0.830 0.40984
TransactionDate2/3/2023 -1.463e+02 1.256e+02 -1.165 0.24840
TransactionDate2/5/2023 -1.002e+02 1.009e+02 -0.993 0.32449
TransactionDate2/6/2023 -1.867e+02 1.119e+02 -1.669 0.10001
TransactionDate2/7/2023 -8.322e+01 1.306e+02 -0.637 0.52636
TransactionDate2/8/2023 6.760e-01 1.294e+02 0.005 0.99585
TransactionDate2/9/2023 -8.672e+01 1.096e+02 -0.791 0.43167
TransactionDate3/1/2023 -8.147e+01 1.256e+02 -0.649 0.51881
TransactionDate3/13/2023 8.063e+01 1.330e+02 0.606 0.54643
TransactionDate3/14/2023 -1.658e+02 1.299e+02 -1.277 0.20624
TransactionDate3/15/2023 -1.314e+02 1.089e+02 -1.207 0.23184
TransactionDate3/17/2023 -1.131e+02 1.049e+02 -1.078 0.28519
TransactionDate3/19/2023 -4.454e+01 1.132e+02 -0.393 0.69533
TransactionDate3/2/2023 -5.367e+01 1.260e+02 -0.426 0.67164
TransactionDate3/20/2023 -4.394e+01 1.045e+02 -0.420 0.67555
TransactionDate3/21/2023 3.030e+01 1.261e+02 0.240 0.81084
TransactionDate3/22/2023 -1.085e+02 1.325e+02 -0.819 0.41585
TransactionDate3/24/2023 2.409e+01 1.210e+02 0.199 0.84290
TransactionDate3/26/2023 -1.957e+02 1.075e+02 -1.821 0.07327 .
TransactionDate3/28/2023 -1.553e+02 1.293e+02 -1.202 0.23391
TransactionDate3/31/2023 -3.150e+00 1.138e+02 -0.028 0.97800
TransactionDate3/7/2023 -2.617e+02 1.267e+02 -2.066 0.04282 *
TransactionDate3/8/2023 -2.225e+02 1.243e+02 -1.790 0.07810 .
TransactionDate4/11/2023 -2.139e+02 1.313e+02 -1.629 0.10816
TransactionDate4/12/2023 -1.028e+02 1.124e+02 -0.915 0.36376
TransactionDate4/15/2023 -5.039e+01 1.255e+02 -0.402 0.68930
TransactionDate4/17/2023 -3.248e+02 1.312e+02 -2.476 0.01590 *
TransactionDate4/18/2023 -8.924e+01 1.287e+02 -0.693 0.49067
TransactionDate4/2/2023 -1.128e+02 1.247e+02 -0.905 0.36899
TransactionDate4/20/2023 -5.816e+01 1.293e+02 -0.450 0.65447
TransactionDate4/22/2023 6.553e+01 1.233e+02 0.531 0.59697
TransactionDate4/23/2023 -9.748e+01 1.070e+02 -0.911 0.36573
TransactionDate4/25/2023 -6.240e+01 1.282e+02 -0.487 0.62813
TransactionDate4/27/2023 -2.117e+02 1.088e+02 -1.945 0.05609 .
TransactionDate4/28/2023 -1.340e+02 1.068e+02 -1.255 0.21389
TransactionDate4/3/2023 -1.433e+02 1.073e+02 -1.335 0.18654
TransactionDate4/30/2023 -9.655e+01 1.247e+02 -0.774 0.44156
TransactionDate4/5/2023 -1.152e+02 1.071e+02 -1.075 0.28617
TransactionDate4/6/2023 5.124e+01 1.242e+02 0.413 0.68131
TransactionDate4/7/2023 -1.755e+02 1.225e+02 -1.433 0.15671
TransactionDate4/8/2023 -1.184e+02 1.321e+02 -0.897 0.37325
TransactionDate5/12/2023 -1.065e+02 1.125e+02 -0.947 0.34722
TransactionDate5/13/2023 9.883e+01 1.347e+02 0.734 0.46580
TransactionDate5/14/2023 3.938e+00 1.131e+02 0.035 0.97234
TransactionDate5/15/2023 1.531e+01 1.276e+02 0.120 0.90486
TransactionDate5/16/2023 -9.445e+01 1.315e+02 -0.718 0.47515
TransactionDate5/18/2023 -1.087e+02 1.100e+02 -0.988 0.32693
TransactionDate5/2/2023 -9.803e+01 1.379e+02 -0.711 0.47969
TransactionDate5/20/2023 -3.846e+01 1.289e+02 -0.298 0.76642
TransactionDate5/23/2023 -2.008e+02 1.277e+02 -1.573 0.12055
TransactionDate5/25/2023 -1.105e+02 1.320e+02 -0.837 0.40565
TransactionDate5/26/2023 7.508e+01 1.266e+02 0.593 0.55510
TransactionDate5/27/2023 -1.406e+02 1.105e+02 -1.272 0.20776
TransactionDate5/28/2023 -6.848e+01 1.407e+02 -0.487 0.62805
TransactionDate5/29/2023 -2.690e+02 1.271e+02 -2.116 0.03817 *
TransactionDate5/30/2023 -1.720e+02 1.039e+02 -1.656 0.10257
TransactionDate5/5/2023 -5.109e+01 1.271e+02 -0.402 0.68898
TransactionDate5/7/2023 -1.637e+02 1.269e+02 -1.289 0.20182
TransactionDate5/8/2023 -8.932e+01 1.246e+02 -0.717 0.47608
TransactionDate5/9/2023 1.562e+01 1.073e+02 0.146 0.88471
TransactionDate6/1/2023 -2.748e+02 1.340e+02 -2.051 0.04428 *
TransactionDate6/10/2023 -4.937e+01 1.270e+02 -0.389 0.69881
TransactionDate6/13/2023 -2.314e+02 1.023e+02 -2.263 0.02701 *
TransactionDate6/14/2023 -2.400e+02 1.265e+02 -1.897 0.06225 .
TransactionDate6/15/2023 -1.093e+02 1.282e+02 -0.852 0.39709
TransactionDate6/17/2023 -8.863e+01 1.287e+02 -0.689 0.49355
TransactionDate6/19/2023 3.092e+01 1.177e+02 0.263 0.79356
TransactionDate6/20/2023 -1.279e+01 1.168e+02 -0.110 0.91311
TransactionDate6/21/2023 -1.077e+02 1.095e+02 -0.984 0.32883
TransactionDate6/22/2023 3.422e+01 1.308e+02 0.262 0.79449
TransactionDate6/25/2023 -5.615e+01 1.285e+02 -0.437 0.66368
TransactionDate6/26/2023 -2.297e+02 1.275e+02 -1.801 0.07642 .
TransactionDate6/27/2023 -9.630e+01 1.054e+02 -0.914 0.36425
TransactionDate6/29/2023 2.367e+01 1.301e+02 0.182 0.85617
TransactionDate6/3/2023 -1.468e+01 1.042e+02 -0.141 0.88840
TransactionDate6/30/2023 -2.935e+02 1.236e+02 -2.374 0.02056 *
TransactionDate6/4/2023 -9.964e+01 1.268e+02 -0.786 0.43480
TransactionDate6/5/2023 -1.326e+02 1.125e+02 -1.179 0.24289
TransactionDate6/6/2023 -1.343e+02 1.262e+02 -1.065 0.29096
TransactionDate6/7/2023 -8.927e+01 1.016e+02 -0.878 0.38302
TransactionDate7/1/2023 -3.984e+01 1.364e+02 -0.292 0.77110
TransactionDate7/10/2023 -1.562e+02 1.240e+02 -1.261 0.21199
TransactionDate7/11/2023 -1.916e+02 1.165e+02 -1.645 0.10483
TransactionDate7/13/2023 -8.300e+01 1.283e+02 -0.647 0.51998
TransactionDate7/14/2023 6.221e+00 1.235e+02 0.050 0.95998
TransactionDate7/16/2023 -2.448e+01 1.072e+02 -0.228 0.82003
TransactionDate7/18/2023 -1.420e+02 1.257e+02 -1.130 0.26280
TransactionDate7/19/2023 -8.525e+01 1.301e+02 -0.655 0.51476
TransactionDate7/22/2023 2.177e+01 1.202e+02 0.181 0.85688
TransactionDate7/24/2023 2.448e+01 1.241e+02 0.197 0.84423
TransactionDate7/26/2023 -1.087e+02 1.072e+02 -1.014 0.31428
TransactionDate7/3/2023 -3.739e+01 1.327e+02 -0.282 0.77910
TransactionDate7/30/2023 -1.783e+02 1.232e+02 -1.447 0.15259
TransactionDate7/4/2023 -8.466e-01 1.192e+02 -0.007 0.99436
TransactionDate7/5/2023 -7.410e+01 9.839e+01 -0.753 0.45411
TransactionDate7/6/2023 -7.521e+01 1.271e+02 -0.592 0.55622
TransactionDate7/7/2023 -6.335e+01 1.061e+02 -0.597 0.55251
TransactionDate7/9/2023 -2.272e+02 1.138e+02 -1.997 0.04998 *
TransactionDate8/1/2023 1.966e+01 1.310e+02 0.150 0.88115
TransactionDate8/11/2023 -1.111e+02 1.236e+02 -0.899 0.37184
TransactionDate8/16/2023 -1.211e+02 1.297e+02 -0.934 0.35394
TransactionDate8/19/2023 -1.794e+02 1.075e+02 -1.668 0.10007
TransactionDate8/2/2023 5.562e+01 1.207e+02 0.461 0.64638
TransactionDate8/20/2023 -4.589e+00 9.866e+01 -0.047 0.96304
TransactionDate8/21/2023 -5.954e+01 1.151e+02 -0.517 0.60669
TransactionDate8/22/2023 -1.950e+02 1.083e+02 -1.801 0.07636 .
TransactionDate8/24/2023 -7.035e+01 1.272e+02 -0.553 0.58226
TransactionDate8/26/2023 -1.412e+02 1.268e+02 -1.114 0.26932
TransactionDate8/29/2023 -1.523e+02 1.127e+02 -1.352 0.18114
TransactionDate8/3/2023 -1.393e+02 1.092e+02 -1.276 0.20640
TransactionDate8/30/2023 -4.535e+01 1.266e+02 -0.358 0.72129
TransactionDate8/31/2023 -1.944e+01 1.508e+02 -0.129 0.89782
TransactionDate8/4/2023 -1.796e+01 1.265e+02 -0.142 0.88757
TransactionDate8/6/2023 -1.593e+02 1.059e+02 -1.504 0.13737
TransactionDate9/1/2023 -8.852e+01 1.243e+02 -0.712 0.47903
TransactionDate9/12/2023 -7.721e+01 1.280e+02 -0.603 0.54850
TransactionDate9/13/2023 -2.129e+02 1.274e+02 -1.671 0.09943 .
TransactionDate9/17/2023 -9.984e+01 9.834e+01 -1.015 0.31373
TransactionDate9/2/2023 -2.700e+02 1.292e+02 -2.090 0.04051 *
TransactionDate9/23/2023 -5.504e+01 1.388e+02 -0.396 0.69307
TransactionDate9/25/2023 2.826e+01 1.286e+02 0.220 0.82668
TransactionDate9/27/2023 3.194e+01 1.351e+02 0.236 0.81383
TransactionDate9/28/2023 1.630e+01 1.301e+02 0.125 0.90070
TransactionDate9/29/2023 -9.060e+01 1.199e+02 -0.755 0.45276
TransactionDate9/3/2023 -9.314e+01 1.106e+02 -0.842 0.40279
TransactionDate9/30/2023 -2.146e+02 1.292e+02 -1.661 0.10150
TransactionDate9/4/2023 -1.616e+02 1.314e+02 -1.230 0.22323
TransactionDate9/5/2023 -2.497e+01 1.231e+02 -0.203 0.83989
TransactionDate9/6/2023 -1.777e+02 1.152e+02 -1.542 0.12787
TransactionDate9/7/2023 -2.317e+01 1.285e+02 -0.180 0.85744
TransactionDate9/8/2023 -1.138e+02 1.370e+02 -0.831 0.40929
ProductCategoryElectronics 5.308e+01 2.522e+01 2.105 0.03918 *
ProductCategoryHome Appliances 4.534e+01 2.346e+01 1.933 0.05765 .
Price -9.209e-02 1.964e-01 -0.469 0.64077
Rating 1.525e+00 1.023e+01 0.149 0.88196
TotalAmount -1.779e-03 5.654e-02 -0.031 0.97499
Age 1.717e-01 6.954e-01 0.247 0.80577
GenderFemale 1.659e+02 5.494e+01 3.019 0.00362 **
GenderMale 1.298e+02 5.776e+01 2.247 0.02802 *
LocationHouston -3.899e+01 2.766e+01 -1.409 0.16347
LocationLos Angeles -7.705e+00 2.727e+01 -0.283 0.77838
LocationNew York -1.257e+01 2.350e+01 -0.535 0.59440
MembershipStatusGold -1.781e+01 2.304e+01 -0.773 0.44233
MembershipStatusPremium 2.201e+01 2.512e+01 0.877 0.38398
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 79.41 on 65 degrees of freedom
Multiple R-squared: 0.8178, Adjusted R-squared: 0.1621
F-statistic: 1.247 on 234 and 65 DF, p-value: 0.1466Regression model for some variables
Call:
lm(formula = Price ~ Age + Quantity + Rating, clean_datae = model_clean_datae)
Residuals:
Min 1Q Median 3Q Max
-237.21 -109.52 -32.97 87.19 215.96
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 276.8268 34.0466 8.131 1.18e-14 ***
Age -0.3970 0.5334 -0.744 0.457
Quantity 4.4734 4.8145 0.929 0.354
Rating -7.0699 6.6415 -1.064 0.288
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 120.7 on 296 degrees of freedom
Multiple R-squared: 0.009415, Adjusted R-squared: -0.0006244
F-statistic: 0.9378 on 3 and 296 DF, p-value: 0.4227Correlation Analysis
[1] "pearson correlation: 0.0595410291939671"[1] "pearson correlation: -0.0160950499419378"Statistical Tests
T test
Run t-test to compare means
Frequencies
clean_datae$Gender
Type: Character
Freq % Valid % Valid Cum. % Total % Total Cum.
-------------------- ------ --------- -------------- --------- --------------
(Empty string) 13 4.33 4.33 4.33 4.33
Female 128 42.67 47.00 42.67 47.00
Male 159 53.00 100.00 53.00 100.00
<NA> 0 0.00 100.00
Total 300 100.00 100.00 100.00 100.00
Welch Two Sample t-test
data: TotalAmount by Gender
t = -1.9191, df = 273.08, p-value = 0.05601
alternative hypothesis: true difference in means between group Female and group Male is not equal to 0
95 percent confidence interval:
-262.772102 3.349799
sample estimates:
mean in group Female mean in group Male
734.3905 864.1017 Chi-square test to check association between product category and payment method
Create a contingency table
Cash on Delivery Credit Card Debit Card UPI
Clothing 26 24 22 34
Electronics 30 22 20 27
Home Appliances 24 19 23 29Perform Chi-Square test
Pearson's Chi-squared test
data: table_data
X-squared = 1.7541, df = 6, p-value = 0.9409ANOVA to compare the average total amount across different membership status levels
Df Sum Sq Mean Sq F value Pr(>F)
clean_datae$MembershipStatus 2 265150 132575 0.408 0.665
Residuals 297 96508828 324946 Tukey multiple comparisons of means
95% family-wise confidence level
Fit: aov(formula = clean_datae$TotalAmount ~ clean_datae$MembershipStatus, clean_datae = clean_datae)
$`clean_datae$MembershipStatus`
diff lwr upr p adj
Gold-Basic -67.957193 -258.0876 122.1732 0.6772566
Premium-Basic -9.426467 -197.0448 178.1919 0.9923081
Premium-Gold 58.530726 -133.8442 250.9057 0.7538209
Data Visualization
Histogram
Pie Chart for proportion of customers by gender``
Pie chart with percentages
Female Male
0.04333333 0.42666667 0.53000000 
## Bar Chart ## Compare the average TotalAmount spent by customers in
different Location or ProductCategory
Donut Chart
Display the distribution of PaymentMethod used by customers.
Scatter Plot
Visualize the relationship between price and total amount
Box Plot
Identify Outliers in Price
## Identify Outliers in Price and Total amount
