Cleaned CSV Data
| order_id |
order_date |
customer_id |
customer_name |
email |
product_id |
product_title |
category |
quantity |
price |
total |
channel |
status |
| 10001 |
2024-01-03 |
2001 |
alice nguyen |
alice@gmail.com |
3001 |
wireless headphones |
electronics |
1 |
$49.99 |
$49.99 |
organic |
paid |
| 10002 |
2024-01-03 |
2002 |
mark lee |
mark23@gmail.com |
4001 |
summer dress |
fashion |
2 |
$45.00 |
$90.00 |
facebook |
paid |
| 10003 |
2024-01-04 |
2003 |
sara kim |
sara@example.com |
5001 |
lipstick |
beauty |
1 |
$14.99 |
$14.99 |
google |
paid |
| 10004 |
2024-01-04 |
2001 |
alice nguyen |
alice@bell.ca |
3004 |
bluetooth speaker |
electronics |
3 |
$39.99 |
$119.97 |
email |
paid |
| 10005 |
2024-01-05 |
2004 |
david rossi |
david@bell.ca |
4005 |
sneakers |
fashion |
1 |
$89.99 |
$89.99 |
organic |
refunded |
| 10010 |
2024-01-07 |
2006 |
emily tran |
emily.tran@gmail.com |
5008 |
perfume |
beauty |
1 |
$59.99 |
$59.99 |
organic |
paid |
| 10011 |
2024-01-08 |
2007 |
john doe |
john.doe@bell.ca |
3001 |
wireless headphones |
electronics |
2 |
$49.99 |
$99.98 |
instagram |
paid |
| 10013 |
2024-01-09 |
2008 |
jane doe |
jane.doe@bell.ca |
4006 |
t-shirt |
fashion |
1 |
$19.99 |
$19.99 |
organic |
paid |
| 10014 |
2024-01-09 |
2009 |
maria lopez |
maria.lopez@bell.ca |
5004 |
face cream |
beauty |
1 |
$24.99 |
$24.99 |
google |
paid |
| 10015 |
2024-01-10 |
2010 |
liam brown |
liam.brown@bell.ca |
3007 |
usb-c cable |
electronics |
5 |
$9.99 |
$49.95 |
email |
paid |
| 10017 |
2024-01-11 |
2011 |
olivia smith |
olivia.smith@bell.ca |
4007 |
jeans |
fashion |
1 |
$49.99 |
$49.99 |
organic |
paid |
| 10018 |
2024-01-11 |
2012 |
noah wilson |
noah.w@bell.ca |
5002 |
foundation |
beauty |
3 |
$29.99 |
$89.97 |
facebook |
paid |
| 10019 |
2024-01-12 |
2013 |
ava davis |
ava.davis@bell.ca |
3003 |
smartwatch |
electronics |
2 |
$99.00 |
$198.00 |
google |
paid |
| 10020 |
2024-01-12 |
2014 |
mia taylor |
mia.taylor@bell.ca |
5005 |
shampoo |
beauty |
1 |
$12.99 |
$12.99 |
organic |
refunded |
| 10022 |
2024-01-13 |
2016 |
ethan white |
ethan.white@rogers.ca |
3006 |
laptop sleeve |
electronics |
2 |
$25.00 |
$50.00 |
google |
paid |
| 10023 |
2024-01-14 |
2017 |
sophia harris |
sophia.harris@yahoo.com |
5007 |
hair dryer |
beauty |
1 |
$49.99 |
$49.99 |
organic |
paid |
| 10024 |
2024-01-14 |
2018 |
lucas martin |
lucas.m@bell.ca |
4008 |
winter coat |
fashion |
4 |
$129.99 |
$519.96 |
facebook |
paid |
| 10025 |
2024-01-15 |
2019 |
harper clark |
harper.c@gmail.com |
3001 |
wireless headphones |
electronics |
1 |
$49.99 |
$49.99 |
organic |
paid |
| 10026 |
2024-01-15 |
2020 |
mason lewis |
mason.l@gmail.com |
4002 |
summer dress |
fashion |
1 |
$45.00 |
$45.00 |
google |
paid |
| 10027 |
2024-01-16 |
2021 |
ella walker |
ella.w@bell.ca |
5003 |
mascara |
beauty |
1 |
$19.99 |
$19.99 |
organic |
paid |
| 10028 |
2024-01-16 |
2022 |
logan hall |
logan.h@rogers.ca |
3004 |
bluetooth speaker |
electronics |
2 |
$39.99 |
$79.98 |
email |
paid |
| 10029 |
2024-01-17 |
2023 |
grace allen |
grace.a@gmail.com |
5008 |
perfume |
beauty |
1 |
$59.99 |
$59.99 |
organic |
paid |
| 10030 |
2024-01-17 |
2024 |
jacob young |
jacob.y@gmail.com |
4005 |
sneakers |
fashion |
2 |
$89.99 |
$179.98 |
facebook |
paid |
| 10031 |
2024-01-18 |
2025 |
chloe king |
chloe.k@gmail.com |
3002 |
smartwatch |
electronics |
1 |
$99.00 |
$99.00 |
google |
paid |
| 10032 |
2024-01-18 |
2026 |
michael wright |
michael.w@yahoo.com |
5001 |
lipstick |
beauty |
3 |
$14.99 |
$44.97 |
organic |
paid |
| 10033 |
2024-01-19 |
2027 |
lily scott |
lily.s@gmail.com |
4003 |
denim jacket |
fashion |
2 |
$79.99 |
$159.98 |
tiktok |
paid |
| 10034 |
2024-01-19 |
2028 |
benjamin nguyen |
ben.nguyen@yahoo.com |
3006 |
laptop sleeve |
electronics |
1 |
$25.00 |
$25.00 |
google |
paid |