Supermarket Sales - Dirty.xlsx

	A	B	C	D	E	F	G	H	I	J
1	Transaction_ID	Date	Store_City	Product_Category	Product_Name	Quantity	Unit_Price	Payment_Method	Customer_Gender	Total_Amount

2	T001	1/3/2026	Duhok	Beverages	Pepsi	3	0.75	Cash	Male	2.25
3	T002	1/3/2026	Erbil	Snacks	Chips	5	1.2	Card	Female	6
4	T003	1/4/2026	Sulaymaniyah	Dairy	Milk	2	1.5	Cash	Male	3
5	T004	1/5/2026	Duhok	Bakery	Bread	4	0.8	Card	Female	3.2
6	T005	1/5/2026	Zakho	Fruits	Apple	6	0.5	Cash	Male	3
7	T006	1/6/2026	Erbil	Vegetables	Tomato	3	0.9	Card	Female	2.7
8	T007	1/6/2026	Duhok	Beverages	Coca Cola	2	1	Cash	Male	2
9	T008	1/7/2026	Sulaymaniyah	Snacks	Biscuit	5	0.6	Card	Female	3
10	T009	1/7/2026	Duhok	Dairy	Yogurt	7	0.45	Cash	Male	3.15
11	T010	1/8/2026	Erbil	Bakery	Cake	1	5	Card	Female	5
12	T011	1/8/2026	Duhok	Fruits	Banana	8	0.4	Cash	Male	3.2
13	T012	1/9/2026	Zakho	Vegetables	Potato	10	0.3	Card	Female	3
14	T013	1/9/2026	Duhok	Beverages	Water	12	0.25	Cash	Male	3
15	T014	1/10/2026	Erbil	Snacks	Chocolate	4	1.5	Card	Female	6
16	T015	1/10/2026	Sulaymaniyah	Dairy	Cheese	2	2.75	Cash	Male	5.5
17	T016	1/11/2026	Duhok	Bakery	Croissant	3	1.25	Card	Female	3.75
18	T017	1/11/2026	Zakho	Fruits	Orange	5	0.7	Cash	Male	3.5
19	T018	1/12/2026	Erbil	Vegetables	Onion	6	0.35	Card	Female	2.1
20	T019	1/12/2026	Duhok	Beverages	Pepsi	2	0.75	Cash	Male	1.5
21	T020	1/13/2026	Sulaymaniyah	Snacks	Chips	3	1.2	Card	Female	3.6
22	T021	1/13/2026	Duhok	Dairy	Milk	2	1.5	Cash	Male	3
23	T021	1/13/2026	Duhok	Dairy	Milk	2	1.5	Cash	Male	3
24	T022	1/14/2026	Duhok	Bevereges	Pepsi	4	0.75	Card	Female	3
25	T023	2026-13-15	Erbil	Snacks	Chips	2	1.2	Cash	Male	2.4
26	T024	1/15/2026	Dhok	Dairy	Milk	3	1.5	Card	Female	4.5
27	T025	1/16/2026	Duhok	Bakery	Bread	5	0.8	Cash	Male	4
28	T026	1/16/2026	Erbil	Fruits	Apple	4	0.5	Card	Female	2
29	T027	1/17/2026	Sulaymaniah	Vegetables	Tomato	2	0.9	Cash	Male	1.8
30	T028	1/17/2026	Duhok	Beverages	كوكاكولا	3	1	Card	Female	3
31	T029	1/18/2026	Zakho	Snacks	Biscut	5	0.6	Cash	Male	3
32	T030	1/18/2026	Erbil	Dairy	Yogurt	-2	0.45	Card	Female	-0.9
33	T031	1/19/2026	Duhok	Bakery	Cake	1	5	Cash	Male	5
34	T032	1/19/2026	Zakho	Fruits	Banana	8	0.4	Card	Female	3.2
35	T033	1/20/2026	Erbil	Vegetables	Potato	10	0.3	Cash	Male	3
36	T034	1/20/2026	Duhok	Beverages	Water	12	0.25	Card	Female	3
37	T035	1/21/2026	Erbil	Snacks	Chocolate	five	1.5	Cash	Male	7.5
38	T036	1/21/2026	Sulaymaniyah	Dairy	Cheese	2	2.75	Card	Female	5.5
39	T037	1/22/2026	Duhok	Bakery	Croissant	3	1.25	Cash	Male	3.75
40	T038	1/22/2026	Zakho	Fruits	Orange	5	0.7	Card	Female	3.5
41	T039	1/23/2026	Erbil	Vegetables	Onion	6	0.35	Cash	Male	2.1
42	T040	1/23/2026	Duhok	Beverages	Pepsi	2	0.75	Card	Female	1.5
43	T041	1/24/2026	Sulaymaniyah	Snacks	Chips	3	1.2	Cash	Male	3.6
44	T042	1/24/2026	Duhok	Dairy		2	1.5	Card	Female	3
45	T043	1/25/2026	Erbil	Bakery	Bread	4	0.8	Cash	Male	3.2
46	T044	1/25/2026	Zakho	Fruits	Apple	NULL	0.5	Card	Female	3
47	T045	1/26/2026	Duhok	Vegetables	Tomato	3	0	Cash	Male	0
48	T046	1/26/2026	Erbil	Beverages	Pepsi	2	0.75	Card	Female	1.5
49	T047	1/27/2026	Duhok	Snacks	Chips	3	1.2	CASH	Male	3.6
50	T048	1/27/2026	Zakho	Dairy	Milk	2	1.5	card	Female	3
51	T049	1/28/2026	Duhok	Bakery	Bread	4	0.8		Male	3.2
52	T050	2026-02-30	Erbil	Fruits	Apple	5	0.5	Card	Female	2.5
53	T051	1/29/2026	هه‌ولێر	Vegetables	Potato	6	0.3	Cash	Male	1.8
54	T052	1/29/2026	Duhok	Beverages	Pepsi	9999	0.75	Card	Female	7499.25
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100