E-Commerce Data Analysis Report
Jane Wahome
2025-03-03
Introduction
This report summarizes the analysis of an e-commerce dataset.
Data Cleaning
- Missing values in Age and Gender were handled using imputation.
- Outliers in TotalAmount were detected and removed.
Exploratory Data Analysis
- The distribution of Age is shown below:
##W/D
#Import Data set
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 Male
2 4/17/2023 Electronics 389.03 2.2 389.03 19 Female
3 1/17/2023 Clothing 145.89 1.7 729.45 37 Female
4 10/23/2023 Home Appliances 215.02 2.7 645.06 50 Male
5 6/30/2023 Home Appliances 325.48 3.4 1627.40 24 Male
6 6/14/2023 Electronics 389.03 2.2 778.06 50 Male
7 7/26/2023 Electronics 193.15 3.7 193.15 40 Male
8 5/23/2023 Clothing 350.44 1.4 1752.20 37 Male
9 11/1/2023 Clothing 350.44 1.4 1401.76 25 Female
10 12/3/2023 Electronics 280.91 1.9 561.82 53 Female
11 5/29/2023 Electronics 280.91 1.9 842.73 65 Male
12 6/7/2023 Home Appliances 341.40 3.0 1024.20 62 Male
13 6/13/2023 Home Appliances 325.48 3.4 1301.92 NA Male
14 3/7/2023 Electronics 123.63 2.1 247.26 NA Female
15 1/12/2023 Clothing 350.44 1.4 1401.76 NA Male
16 10/10/2023 Electronics 280.91 1.9 280.91 NA Female
17 3/8/2023 Clothing 33.36 4.2 100.08 NA Male
18 10/2/2023 Clothing 117.70 4.9 117.70 NA Male
19 1/24/2023 Electronics 193.15 3.7 579.45 NA Male
20 6/13/2023 Clothing 243.41 5.0 486.82 NA Female
21 11/30/2023 Clothing 145.89 1.7 145.89 34 Female
22 2/9/2023 Home Appliances 325.48 3.4 1301.92 24 Male
23 6/26/2023 Electronics 280.91 1.9 842.73 25 Male
24 3/26/2023 Electronics 132.51 2.3 265.02 52 Male
25 7/9/2023 Clothing 145.89 1.7 437.67 53 Female
26 5/30/2023 Home Appliances 341.40 3.0 1365.60 29 Male
27 4/27/2023 Electronics 132.51 2.3 132.51 24 Male
28 8/3/2023 Clothing 33.36 4.2 166.80 24 Male
29 6/1/2023 Electronics 389.03 2.2 778.06 44 Female
30 2/6/2023 Home Appliances 450.57 3.0 2252.85 19 Male
31 12/21/2023 Electronics 211.39 2.6 1056.95 65 Female
32 4/11/2023 Clothing 35.90 1.5 35.90 22 Female
33 2/5/2023 Home Appliances 325.48 3.4 976.44 52 Male
34 2/14/2023 Home Appliances 215.02 2.7 1075.10 24 Male
35 9/13/2023 Home Appliances 341.40 3.0 1365.60 43 Female
36 4/28/2023 Clothing 212.98 2.6 425.96 44 Male
37 11/29/2023 Clothing 212.98 2.6 638.94 47 Male
38 5/12/2023 Clothing 418.39 4.9 1255.17 21 Male
39 7/10/2023 Clothing 350.44 1.4 1051.32 42 Male
40 1/16/2023 Electronics 123.63 2.1 618.15 50 Female
41 8/22/2023 Electronics 193.15 3.7 579.45 43 Male
42 7/9/2023 Electronics 123.63 2.1 618.15 23 Male
43 10/15/2023 Home Appliances 215.02 2.7 1075.10 25 Female
44 10/6/2023 Electronics 193.15 3.7 386.30 27 Female
45 9/6/2023 Home Appliances 466.49 2.6 1865.96 18 Female
46 9/2/2023 Clothing 212.98 2.6 425.96 35 Female
47 8/31/2023 Clothing 350.44 1.4 1752.20 42
48 3/17/2023 Home Appliances 341.40 3.0 1365.60 53
49 5/2/2023 Electronics 211.39 2.6 845.56 34
50 12/5/2023 Electronics 389.03 2.2 1167.09 49
51 2/27/2023 Clothing 212.98 2.6 638.94 63
52 12/25/2023 Clothing 33.36 4.2 66.72 27
53 9/8/2023 Electronics 193.15 3.7 193.15 49
54 8/20/2023 Home Appliances 172.25 4.3 861.25 18
55 1/16/2023 Clothing 117.70 4.9 353.10 62
56 9/23/2023 Electronics 123.63 2.1 370.89 43
57 11/11/2023 Clothing 117.70 4.9 588.50 41
58 11/15/2023 Electronics 211.39 2.6 1056.95 41
59 5/28/2023 Electronics 280.91 1.9 280.91 52
60 1/18/2023 Clothing 243.41 5.0 243.41 44 Female
61 2/7/2023 Electronics 389.03 2.2 1945.15 31 Male
62 8/19/2023 Home Appliances 466.49 2.6 1865.96 43 Female
63 10/14/2023 Electronics 132.51 2.3 265.02 37 Female
64 10/17/2023 Clothing 145.89 1.7 145.89 50 Male
65 4/27/2023 Clothing 145.89 1.7 291.78 26 Female
66 3/17/2023 Home Appliances 450.57 3.0 901.14 24 Female
67 11/29/2023 Clothing 243.41 5.0 730.23 36 Female
68 1/28/2023 Electronics 132.51 2.3 662.55 24 Male
69 6/27/2023 Electronics 123.63 2.1 618.15 28 Female
70 6/5/2023 Clothing 33.36 4.2 133.44 62 Female
71 6/21/2023 Clothing 145.89 1.7 729.45 61 Female
72 1/7/2023 Home Appliances 341.40 3.0 682.80 50 Female
73 8/22/2023 Clothing 243.41 5.0 243.41 37 Female
74 8/19/2023 Home Appliances 466.49 2.6 1399.47 52 Female
75 4/3/2023 Clothing 145.89 1.7 145.89 38 Female
76 3/15/2023 Home Appliances 466.49 2.6 932.98 25 Female
77 11/24/2023 Clothing 35.90 1.5 71.80 25 Male
78 2/15/2023 Clothing 418.39 4.9 1673.56 65 Female
79 2/1/2023 Home Appliances 172.25 4.3 689.00 49 Female
80 3/26/2023 Electronics 280.91 1.9 280.91 44 Female
81 4/5/2023 Home Appliances 466.49 2.6 1865.96 63 Female
82 7/5/2023 Home Appliances 325.48 3.4 1301.92 59 Male
83 5/27/2023 Clothing 350.44 1.4 350.44 24 Male
84 8/19/2023 Clothing 145.89 1.7 437.67 41 Male
85 12/10/2023 Clothing 243.41 5.0 486.82 56 Male
86 3/14/2023 Clothing 212.98 2.6 638.94 56 Female
87 5/16/2023 Clothing 350.44 1.4 1051.32 49 Male
88 4/8/2023 Clothing 212.98 2.6 1064.90 63 Female
89 8/6/2023 Home Appliances 172.25 4.3 172.25 46 Female
90 2/10/2023 Home Appliances 466.49 2.6 2332.45 60 Female
91 2/11/2023 Electronics 123.63 2.1 618.15 28 Female
92 10/22/2023 Clothing 145.89 1.7 291.78 46 Female
93 10/6/2023 Home Appliances 450.57 3.0 450.57 22 Female
94 6/4/2023 Home Appliances 466.49 2.6 1865.96 52 Male
95 9/17/2023 Clothing 243.41 5.0 1217.05 61 Male
96 10/17/2023 Home Appliances 450.57 3.0 901.14 62 Female
97 2/16/2023 Electronics 193.15 3.7 965.75 36 Male
98 7/11/2023 Electronics 211.39 2.6 1056.95 42 Female
99 11/17/2023 Electronics 193.15 3.7 193.15 47 Male
100 7/18/2023 Home Appliances 450.57 3.0 901.14 57 Male
101 5/25/2023 Clothing 145.89 1.7 729.45 54 Male
102 5/7/2023 Electronics 280.91 1.9 842.73 43 Male
103 8/11/2023 Home Appliances 325.48 3.4 1301.92 47 Female
104 8/16/2023 Clothing 145.89 1.7 729.45 32 Female
105 6/15/2023 Clothing 145.89 1.7 437.67 40 Female
106 12/6/2023 Clothing 35.90 1.5 35.90 27 Male
107 3/1/2023 Clothing 243.41 5.0 730.23 39 Male
108 1/17/2023 Home Appliances 215.02 2.7 430.04 26 Male
109 7/11/2023 Home Appliances 450.57 3.0 1802.28 43 Female
110 12/27/2023 Clothing 350.44 1.4 1401.76 20 Female
111 8/26/2023 Home Appliances 341.40 3.0 1707.00 24 Female
112 2/28/2023 Clothing 212.98 2.6 212.98 58 Male
113 6/3/2023 Electronics 280.91 1.9 1123.64 59 Male
114 3/22/2023 Electronics 389.03 2.2 1556.12 19 Male
115 8/29/2023 Clothing 350.44 1.4 350.44 28 Female
116 2/1/2023 Clothing 350.44 1.4 1401.76 59 Male
117 8/6/2023 Clothing 243.41 5.0 730.23 42 Male
118 11/23/2023 Electronics 211.39 2.6 634.17 18 Male
119 11/21/2023 Clothing 145.89 1.7 729.45 42 Male
120 4/23/2023 Home Appliances 215.02 2.7 1075.10 22 Male
121 6/6/2023 Clothing 418.39 4.9 418.39 38 Male
122 12/10/2023 Home Appliances 341.40 3.0 1365.60 65 Male
123 10/4/2023 Clothing 418.39 4.9 418.39 56 Male
124 2/17/2023 Electronics 211.39 2.6 634.17 50 Male
125 12/7/2023 Clothing 418.39 4.9 1673.56 40 Male
126 8/29/2023 Home Appliances 341.40 3.0 682.80 52 Female
127 7/5/2023 Clothing 33.36 4.2 33.36 31 Male
128 8/3/2023 Home Appliances 466.49 2.6 932.98 24 Male
129 1/11/2023 Electronics 123.63 2.1 618.15 34 Female
130 3/28/2023 Electronics 123.63 2.1 370.89 33 Female
131 5/30/2023 Electronics 280.91 1.9 280.91 41 Male
132 4/2/2023 Home Appliances 325.48 3.4 1301.92 38 Male
133 9/30/2023 Electronics 193.15 3.7 965.75 31 Female
134 12/1/2023 Clothing 418.39 4.9 1673.56 40 Female
135 2/3/2023 Home Appliances 450.57 3.0 1802.28 43 Male
136 4/7/2023 Electronics 193.15 3.7 386.30 58 Male
137 11/25/2023 Clothing 145.89 1.7 145.89 23 Male
138 10/18/2023 Home Appliances 450.57 3.0 1351.71 59 Male
139 1/4/2023 Electronics 132.51 2.3 397.53 53 Male
140 9/3/2023 Home Appliances 172.25 4.3 861.25 62 Male
141 4/28/2023 Clothing 243.41 5.0 730.23 24 Male
142 2/10/2023 Electronics 132.51 2.3 662.55 32 Male
143 11/27/2023 Clothing 212.98 2.6 425.96 24 Male
144 10/24/2023 Clothing 145.89 1.7 145.89 63 Female
145 9/29/2023 Electronics 193.15 3.7 386.30 42 Male
146 4/18/2023 Home Appliances 341.40 3.0 1707.00 22 Female
147 1/13/2023 Electronics 211.39 2.6 845.56 25 Male
148 12/8/2023 Home Appliances 172.25 4.3 344.50 45 Male
149 9/4/2023 Electronics 389.03 2.2 1556.12 35 Female
150 9/17/2023 Home Appliances 341.40 3.0 1024.20 21 Male
151 7/19/2023 Electronics 280.91 1.9 1123.64 30 Male
152 2/6/2023 Home Appliances 172.25 4.3 516.75 44 Female
153 10/1/2023 Clothing 350.44 1.4 350.44 37 Female
154 3/19/2023 Clothing 117.70 4.9 353.10 46 Female
155 4/12/2023 Home Appliances 450.57 3.0 2252.85 29 Female
156 9/6/2023 Clothing 145.89 1.7 729.45 62 Female
157 5/30/2023 Electronics 123.63 2.1 247.26 37 Male
158 12/15/2023 Electronics 123.63 2.1 618.15 42 Male
159 9/12/2023 Home Appliances 466.49 2.6 466.49 21 Male
160 4/30/2023 Home Appliances 215.02 2.7 860.08 42 Male
161 7/30/2023 Electronics 211.39 2.6 211.39 44 Male
162 10/21/2023 Clothing 212.98 2.6 638.94 55 Female
163 6/17/2023 Electronics 389.03 2.2 778.06 33 Male
164 5/15/2023 Clothing 350.44 1.4 1051.32 56 Male
165 12/17/2023 Clothing 117.70 4.9 235.40 40 Male
166 8/24/2023 Clothing 212.98 2.6 212.98 32 Female
167 2/5/2023 Clothing 243.41 5.0 730.23 63 Male
168 9/25/2023 Clothing 35.90 1.5 179.50 39 Male
169 4/23/2023 Electronics 132.51 2.3 662.55 39 Male
170 5/18/2023 Home Appliances 466.49 2.6 1399.47 24 Female
171 8/20/2023 Clothing 33.36 4.2 166.80 52 Male
172 7/7/2023 Clothing 212.98 2.6 212.98 60 Male
173 5/18/2023 Electronics 132.51 2.3 132.51 48 Female
174 11/26/2023 Clothing 418.39 4.9 418.39 53 Female
175 4/3/2023 Clothing 145.89 1.7 145.89 35 Female
176 11/27/2023 Electronics 132.51 2.3 662.55 63 Male
177 8/30/2023 Home Appliances 325.48 3.4 1627.40 30 Male
178 11/13/2023 Electronics 280.91 1.9 1404.55 33 Male
179 5/5/2023 Home Appliances 466.49 2.6 1865.96 44 Male
180 2/23/2023 Clothing 33.36 4.2 133.44 54 Female
181 7/13/2023 Electronics 193.15 3.7 772.60 58 Male
182 6/10/2023 Clothing 212.98 2.6 1064.90 40 Male
183 10/4/2023 Home Appliances 172.25 4.3 172.25 44 Female
184 5/27/2023 Home Appliances 325.48 3.4 650.96 22 Male
185 2/14/2023 Electronics 193.15 3.7 579.45 41 Male
186 5/14/2023 Clothing 145.89 1.7 437.67 22 Female
187 7/14/2023 Home Appliances 325.48 3.4 1627.40 39 Male
188 3/31/2023 Electronics 211.39 2.6 845.56 24 Male
189 6/13/2023 Home Appliances 215.02 2.7 1075.10 50 Female
190 3/15/2023 Home Appliances 215.02 2.7 430.04 63 Female
191 11/19/2023 Electronics 389.03 2.2 1556.12 59 Male
192 9/17/2023 Home Appliances 341.40 3.0 341.40 20 Female
193 10/21/2023 Clothing 117.70 4.9 235.40 43 Female
194 3/20/2023 Home Appliances 172.25 4.3 689.00 40 Female
195 9/3/2023 Clothing 418.39 4.9 418.39 19 Female
196 9/1/2023 Clothing 212.98 2.6 212.98 63 Female
197 1/13/2023 Home Appliances 325.48 3.4 1627.40 42 Female
198 11/15/2023 Clothing 33.36 4.2 33.36 58 Female
199 4/5/2023 Clothing 418.39 4.9 418.39 56 Female
200 11/22/2023 Electronics 280.91 1.9 561.82 52 Male
201 11/18/2023 Clothing 145.89 1.7 729.45 64 Female
202 6/7/2023 Electronics 211.39 2.6 1056.95 56 Female
203 5/20/2023 Clothing 145.89 1.7 437.67 41 Female
204 12/12/2023 Clothing 212.98 2.6 638.94 49 Male
205 9/7/2023 Home Appliances 466.49 2.6 1865.96 54 Male
206 10/24/2023 Home Appliances 325.48 3.4 325.48 35 Female
207 5/8/2023 Home Appliances 341.40 3.0 1707.00 52 Male
208 8/21/2023 Home Appliances 172.25 4.3 344.50 26 Female
209 7/6/2023 Electronics 280.91 1.9 1404.55 51 Female
210 10/27/2023 Electronics 123.63 2.1 494.52 63 Female
211 4/12/2023 Home Appliances 325.48 3.4 325.48 42 Female
212 7/7/2023 Clothing 33.36 4.2 166.80 25 Female
213 6/20/2023 Electronics 280.91 1.9 1404.55 31 Male
214 4/25/2023 Clothing 243.41 5.0 486.82 46 Female
215 4/20/2023 Electronics 132.51 2.3 662.55 45 Female
216 7/3/2023 Electronics 389.03 2.2 1167.09 36 Female
217 11/28/2023 Clothing 117.70 4.9 353.10 65 Female
218 11/17/2023 Home Appliances 450.57 3.0 2252.85 41 Male
219 6/27/2023 Electronics 193.15 3.7 193.15 43 Female
220 2/8/2023 Home Appliances 466.49 2.6 2332.45 35 Female
221 6/5/2023 Electronics 389.03 2.2 389.03 38 Male
222 11/21/2023 Electronics 132.51 2.3 662.55 42 Female
223 7/1/2023 Electronics 389.03 2.2 1945.15 54 Male
224 1/21/2023 Clothing 418.39 4.9 836.78 39 Male
225 7/16/2023 Electronics 132.51 2.3 530.04 59 Male
226 1/12/2023 Clothing 350.44 1.4 1401.76 36 Female
227 2/5/2023 Clothing 33.36 4.2 100.08 42 Female
228 12/15/2023 Electronics 280.91 1.9 280.91 57 Female
229 8/20/2023 Home Appliances 325.48 3.4 1627.40 19 Male
230 5/9/2023 Clothing 145.89 1.7 291.78 55 Male
231 6/3/2023 Clothing 350.44 1.4 350.44 32 Female
232 11/4/2023 Electronics 123.63 2.1 494.52 57 Female
233 3/20/2023 Home Appliances 215.02 2.7 215.02 59 Male
234 12/14/2023 Clothing 212.98 2.6 1064.90 27 Female
235 6/25/2023 Electronics 389.03 2.2 778.06 48 Female
236 9/27/2023 Clothing 350.44 1.4 1752.20 56 Male
237 3/2/2023 Electronics 123.63 2.1 123.63 44 Male
238 1/8/2023 Home Appliances 172.25 4.3 861.25 43 Male
239 12/13/2023 Electronics 193.15 3.7 965.75 43 Male
240 10/1/2023 Home Appliances 325.48 3.4 325.48 51 Male
241 9/5/2023 Home Appliances 450.57 3.0 1802.28 57 Female
242 1/15/2023 Home Appliances 466.49 2.6 1865.96 52 Female
243 11/7/2023 Clothing 145.89 1.7 291.78 33 Female
244 8/1/2023 Home Appliances 466.49 2.6 2332.45 27 Female
245 1/25/2023 Clothing 117.70 4.9 235.40 42 Male
246 7/5/2023 Electronics 211.39 2.6 845.56 50 Male
247 7/22/2023 Clothing 243.41 5.0 486.82 19 Male
248 1/1/2023 Home Appliances 172.25 4.3 172.25 47 Male
249 2/23/2023 Home Appliances 325.48 3.4 325.48 46 Female
250 7/24/2023 Clothing 243.41 5.0 730.23 60 Male
251 2/9/2023 Clothing 243.41 5.0 486.82 29 Female
252 11/24/2023 Home Appliances 450.57 3.0 1802.28 41 Male
253 10/1/2023 Clothing 145.89 1.7 291.78 40 Female
254 8/4/2023 Electronics 123.63 2.1 123.63 40 Male
255 6/22/2023 Home Appliances 466.49 2.6 2332.45 42 Male
256 12/1/2023 Electronics 123.63 2.1 370.89 60 Female
257 12/26/2023 Home Appliances 215.02 2.7 645.06 49 Male
258 3/31/2023 Electronics 211.39 2.6 422.78 24 Male
259 3/21/2023 Home Appliances 215.02 2.7 1075.10 57 Male
260 1/24/2023 Electronics 211.39 2.6 1056.95 25 Male
261 4/22/2023 Home Appliances 466.49 2.6 1865.96 34 Male
262 6/21/2023 Electronics 211.39 2.6 211.39 49 Male
263 12/18/2023 Home Appliances 172.25 4.3 516.75 46 Female
264 12/2/2023 Electronics 193.15 3.7 386.30 42 Male
265 6/20/2023 Electronics 389.03 2.2 1167.09 40 Female
266 7/16/2023 Electronics 193.15 3.7 193.15 27 Male
267 5/12/2023 Electronics 211.39 2.6 634.17 29 Female
268 6/3/2023 Electronics 211.39 2.6 1056.95 49 Male
269 7/4/2023 Home Appliances 325.48 3.4 650.96 28 Male
270 3/19/2023 Clothing 33.36 4.2 100.08 60 Female
271 6/7/2023 Home Appliances 341.40 3.0 341.40 41 Male
272 2/25/2023 Electronics 123.63 2.1 494.52 63 Male
273 4/5/2023 Home Appliances 325.48 3.4 976.44 23 Female
274 6/29/2023 Clothing 145.89 1.7 291.78 58 Female
275 11/26/2023 Home Appliances 172.25 4.3 516.75 45 Male
276 3/24/2023 Home Appliances 325.48 3.4 1627.40 59 Male
277 4/6/2023 Electronics 132.51 2.3 397.53 27 Male
278 5/13/2023 Clothing 350.44 1.4 1752.20 31 Male
279 5/9/2023 Home Appliances 450.57 3.0 1802.28 38 Male
280 3/17/2023 Home Appliances 341.40 3.0 1024.20 29 Female
281 5/26/2023 Electronics 280.91 1.9 1123.64 50 Male
282 5/14/2023 Home Appliances 466.49 2.6 1865.96 65 Male
283 11/16/2023 Electronics 389.03 2.2 1945.15 59 Male
284 7/26/2023 Home Appliances 325.48 3.4 1627.40 27 Male
285 12/17/2023 Clothing 33.36 4.2 66.72 24 Male
286 6/27/2023 Home Appliances 325.48 3.4 1301.92 24 Male
287 6/19/2023 Home Appliances 172.25 4.3 172.25 55 Female
288 12/16/2023 Electronics 389.03 2.2 778.06 53 Male
289 1/29/2023 Electronics 193.15 3.7 386.30 26 Male
290 1/6/2023 Clothing 117.70 4.9 353.10 28 Male
291 8/20/2023 Home Appliances 325.48 3.4 1301.92 40 Male
292 11/11/2023 Electronics 123.63 2.1 247.26 32 Female
293 10/8/2023 Electronics 211.39 2.6 634.17 35 Female
294 4/15/2023 Home Appliances 172.25 4.3 344.50 59 Female
295 9/28/2023 Electronics 132.51 2.3 662.55 30 Male
296 3/13/2023 Electronics 389.03 2.2 1945.15 57 Male
297 10/5/2023 Clothing 243.41 5.0 1217.05 59 Male
298 8/2/2023 Home Appliances 341.40 3.0 1365.60 31 Male
299 11/12/2023 Electronics 389.03 2.2 778.06 63 Female
300 2/19/2023 Home Appliances 466.49 2.6 1399.47 23 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 Basic#DATA CLEANING AND REPROCESSING #Handling Missing Values # Check for missing values
TransactionID CustomerID ProductID Quantity
0 0 0 0
PaymentMethod TransactionDate ProductCategory Price
0 0 0 0
Rating TotalAmount Age Gender
0 0 8 0
Location MembershipStatus
0 0 Impute missing values for Age (using mean) and Gender (using mode)
#Handle Outliers # Detect outliers using the IQR method
Apply outlier detection to TotalAmount
Remove outliers
#EXPLORATORY DATA ANALYSIS (EDA) #Univariate Analysis # Histogram for Age
Pie chart for Gender
#Bivariate Analysis # Scatter plot for Price vs. TotalAmount
Bar chart for average TotalAmount by ProductCategory
#REGRESSION MODEL # Build a linear regression model
Call:
lm(formula = TotalAmount ~ Age + Price + Quantity + Rating, data = ecommerce_data)
Residuals:
Min 1Q Median 3Q Max
-493.41 -98.07 8.41 99.72 447.72
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) -725.22455 52.37345 -13.847 <2e-16 ***
Age 0.08356 0.74111 0.113 0.910
Price 3.14352 0.08184 38.412 <2e-16 ***
Quantity 238.95753 6.71918 35.564 <2e-16 ***
Rating -8.46482 9.18344 -0.922 0.357
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 166.5 on 291 degrees of freedom
Multiple R-squared: 0.9076, Adjusted R-squared: 0.9063
F-statistic: 714.4 on 4 and 291 DF, p-value: < 2.2e-16#CORRELATION ANALYSIS # Correlation matrix
Age Price Quantity Rating TotalAmount
Age 1.00000000 -0.04408382 0.02224395 0.03805062 -0.01471413
Price -0.04408382 1.00000000 0.02973474 -0.06313723 0.70665706
Quantity 0.02224395 0.02973474 1.00000000 -0.09877651 0.65943058
Rating 0.03805062 -0.06313723 -0.09877651 1.00000000 -0.12278622
TotalAmount -0.01471413 0.70665706 0.65943058 -0.12278622 1.00000000Visualize correlation matrix
#STATISTICAL TESTS (Compare the average TotalAmount spent by male and female customers.) #T-test # Load necessary library
Check column names
[1] "TransactionID" "CustomerID" "ProductID" "Quantity"
[5] "PaymentMethod" "TransactionDate" "ProductCategory" "Price"
[9] "Rating" "TotalAmount" "Age" "Gender"
[13] "Location" "MembershipStatus" "Outlier" Convert TotalAmount to numeric
Convert Gender to factor
Check for missing values
[1] 0[1] 0Remove rows with missing values
Check levels of Gender
[1] "" "Female" "Male" Filter data to include only Male and Female
Perform the t-test
Print the result
Welch Two Sample t-test
data: TotalAmount by Gender
t = -2.4726, df = 274.83, p-value = 0.01402
alternative hypothesis: true difference in means between group Female and group Male is not equal to 0
95 percent confidence interval:
-285.1822 -32.3603
sample estimates:
mean in group Female mean in group Male
696.0371 854.8084 #Chi-Square Test (Check the association between Product-Category and Payment-Method) # Create a contingency table
Perform chi-square test
Pearson's Chi-squared test
data: contingency_table
X-squared = 2.3691, df = 6, p-value = 0.8828#ANOVA (Compare the average Total Amount across different Membership Status levels.) # Perform ANOVA
Df Sum Sq Mean Sq F value Pr(>F)
MembershipStatus 2 272752 136376 0.455 0.635
Residuals 280 83980962 299932 #DATA VISUALIZATION (Create visualizations to summarize findings.) # Box plot for Total Amount by Membership Status
Donut chart for PaymentMethod
Create a summary table for PaymentMethod
Calculate percentages
Create the donut chart using ggplot2
