This project analyzes global e-commerce trends and their impact on traditional retail. The analysis encompasses various datasets to understand consumer behavior, market dynamics, and the evolving landscape of e-commerce.
The dataset can be downloaded from the following link: Dataset
The preprocessing steps include:
- Handling duplicates
- Filling missing values
- Detecting outliers
- Standardization
- Normalization
- One-hot encoding
- Applying Principal Component Analysis (PCA) for dimensionality reduction
- Calculating Customer Lifetime Value (CLV)
- Conducting a What-if analysis to simulate the effect of different pricing strategies
![1](https://private-user-images.githubusercontent.com/144563726/380545038-f51bdb7f-385e-47bd-919f-971c71ee3af9.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzg5NTMyMDgsIm5iZiI6MTczODk1MjkwOCwicGF0aCI6Ii8xNDQ1NjM3MjYvMzgwNTQ1MDM4LWY1MWJkYjdmLTM4NWUtNDdiZC05MTlmLTk3MWM3MWVlM2FmOS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUwMjA3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MDIwN1QxODI4MjhaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0yNmMzYzkyNjcxODgzZDMzM2E0N2ZhOGQxMmU2ZDk2YTUxZTYyZTU4YjYwMDA2MDRjMWIwNWFmMzkwMzY3YTFlJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.77EdvG2P5_G1kGniBbFaKw_x7L-zEZHIzNzlaOCqICo)
![2](https://private-user-images.githubusercontent.com/144563726/380545041-bd7686c9-2bd2-4ae1-ba9b-1095df3ccaea.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzg5NTMyMDgsIm5iZiI6MTczODk1MjkwOCwicGF0aCI6Ii8xNDQ1NjM3MjYvMzgwNTQ1MDQxLWJkNzY4NmM5LTJiZDItNGFlMS1iYTliLTEwOTVkZjNjY2FlYS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUwMjA3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MDIwN1QxODI4MjhaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT04OWJiNzQ1MTI5NmYyODI0ZmMxZTBkMTg0NjkwOTU2ZjJlZDE0MDQzNWQ5NjIwZGEzODljNTA0NmJlOWY0MWU3JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.90AfEu9xnS8bbiHgo4t84dGcLW91jiKfooP5Mn7v-fs)
![3](https://private-user-images.githubusercontent.com/144563726/380545042-1afb31d9-84b9-43b5-966a-33d0b8c79a43.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzg5NTMyMDgsIm5iZiI6MTczODk1MjkwOCwicGF0aCI6Ii8xNDQ1NjM3MjYvMzgwNTQ1MDQyLTFhZmIzMWQ5LTg0YjktNDNiNS05NjZhLTMzZDBiOGM3OWE0My5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUwMjA3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MDIwN1QxODI4MjhaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1hZmMyZDdjYThkNGRlY2YzZGNmMDA5YzBhOTUyZGNjODYzNGRiNTQ3NDYzOTliN2VmOGYxZjdkZDRkYmUwZTE1JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.8Kkp4NxctCixuwj7Rm9cickKb5NfmskUMZLWH29TDVM)
![4](https://private-user-images.githubusercontent.com/144563726/380545045-3ff82e0c-8c56-417a-a9fd-c7bc5833a192.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzg5NTMyMDgsIm5iZiI6MTczODk1MjkwOCwicGF0aCI6Ii8xNDQ1NjM3MjYvMzgwNTQ1MDQ1LTNmZjgyZTBjLThjNTYtNDE3YS1hOWZkLWM3YmM1ODMzYTE5Mi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUwMjA3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MDIwN1QxODI4MjhaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0xMTkwZjhjYmZiNDJiYTgxODU0NzQwZDRiYmE2MjMyYTVlZDMwMTlhZDFiNzNiNWU0ZjI1YjIzYmQ5NjFmOWZjJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.qvWg0ukSy-jaziX6FqAMgZXHHOa0T7HSD-AkgHoSINI)
![5](https://private-user-images.githubusercontent.com/144563726/380545048-123f0306-275d-455f-b5a3-3d950e265d14.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzg5NTMyMDgsIm5iZiI6MTczODk1MjkwOCwicGF0aCI6Ii8xNDQ1NjM3MjYvMzgwNTQ1MDQ4LTEyM2YwMzA2LTI3NWQtNDU1Zi1iNWEzLTNkOTUwZTI2NWQxNC5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUwMjA3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MDIwN1QxODI4MjhaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1iNjI0MTUyOWU0MTRmYjU4YWUxZGU5ZTk0OTlmZWNmNzkwZGM2MGFlN2U4OTMxZDc1ZDZhMDRiMDc4MDMyM2Q1JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.xFEoFKb2O56GpIRvsXs2ylfafOcIF6vO-zVxLLho-Fo)
![6](https://private-user-images.githubusercontent.com/144563726/380545050-8283dad1-1bc4-4913-a611-fc15db4cbb5d.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzg5NTMyMDgsIm5iZiI6MTczODk1MjkwOCwicGF0aCI6Ii8xNDQ1NjM3MjYvMzgwNTQ1MDUwLTgyODNkYWQxLTFiYzQtNDkxMy1hNjExLWZjMTVkYjRjYmI1ZC5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUwMjA3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MDIwN1QxODI4MjhaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1iMGJkYjI3MjZjODEzNjM3YmYxMWIzZjY5MzdkNmJjMDc3NjZlZDNkMmJhYzNlMDI1NDZmODIxNDg5ZmViZjNjJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.kt8J-ZSQJs7fNNltDCu1p5pqUnPyayoliZtPNZDbCHA)
![7](https://private-user-images.githubusercontent.com/144563726/380545052-6f8b4ad2-ce3f-43cc-b7e9-f9466558dc02.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzg5NTMyMDgsIm5iZiI6MTczODk1MjkwOCwicGF0aCI6Ii8xNDQ1NjM3MjYvMzgwNTQ1MDUyLTZmOGI0YWQyLWNlM2YtNDNjYy1iN2U5LWY5NDY2NTU4ZGMwMi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUwMjA3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MDIwN1QxODI4MjhaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0xN2U5YmIwNzY3ZTZiYTg4NGQ5MDNkZDVjMWFmNzM2MmY2OTgxMzUyOWM2ZmE3OTE4NmVhNjU4Yzg5OWEwMjJkJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.eQ-bQHBAHMfVzfxgXkfd4_HIay5m4gZzLvI-Rn2FZtE)
![8](https://private-user-images.githubusercontent.com/144563726/380545053-971e4157-a2a5-4a95-86e1-73e954c2e43d.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzg5NTMyMDgsIm5iZiI6MTczODk1MjkwOCwicGF0aCI6Ii8xNDQ1NjM3MjYvMzgwNTQ1MDUzLTk3MWU0MTU3LWEyYTUtNGE5NS04NmUxLTczZTk1NGMyZTQzZC5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUwMjA3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MDIwN1QxODI4MjhaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT04Y2FjNDE4Y2E3ZDI0ZTc4M2I5OWQ1ODBlNzM5YTkwODRhNjRlZDRlOTJlYjU2ZTNhZjJmMGY1NWY0MDgyODkzJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.LK9wUQK7vOpNJgl6vgQ0mT9L_mW_Lbu8i9jw67_qfaE)
![9](https://private-user-images.githubusercontent.com/144563726/380545056-a84bd0a8-1086-4a1d-81e9-ecd47227b908.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzg5NTMyMDgsIm5iZiI6MTczODk1MjkwOCwicGF0aCI6Ii8xNDQ1NjM3MjYvMzgwNTQ1MDU2LWE4NGJkMGE4LTEwODYtNGExZC04MWU5LWVjZDQ3MjI3YjkwOC5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUwMjA3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MDIwN1QxODI4MjhaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT05OTQ0MzVhMmViNGZkNTZhZWVhYjRiMzA2NzU2YzYzZWNmYTQ0YTUyNjhlZDBjOWYwYjhkYzhlMjVlYjRkODk1JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.Rd2KE5ymWu_2lMTXoqlFYkw_kttPmtoTP09IjS60isM)
![10](https://private-user-images.githubusercontent.com/144563726/380545058-8458fcfb-0b72-4877-ba34-be29aa2e9abf.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzg5NTMyMDgsIm5iZiI6MTczODk1MjkwOCwicGF0aCI6Ii8xNDQ1NjM3MjYvMzgwNTQ1MDU4LTg0NThmY2ZiLTBiNzItNDg3Ny1iYTM0LWJlMjlhYTJlOWFiZi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUwMjA3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MDIwN1QxODI4MjhaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1jMDc0NDJkNzJkOWRmMmQ2YTAxMDllMDlkNTA4YmEwNjNjNGZmYzljZjYyODBmMDhkNDJlMzNlZWY0NDEzYjcwJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.pBbUbbhptSoZ0kSeofwHg7vrmU7cnXrVC3QX6CbAC_k)
![11](https://private-user-images.githubusercontent.com/144563726/380545059-84293bef-8f78-4cd1-9633-352d72d214ef.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzg5NTMyMDgsIm5iZiI6MTczODk1MjkwOCwicGF0aCI6Ii8xNDQ1NjM3MjYvMzgwNTQ1MDU5LTg0MjkzYmVmLThmNzgtNGNkMS05NjMzLTM1MmQ3MmQyMTRlZi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUwMjA3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MDIwN1QxODI4MjhaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1mYjhiOGVmZGZlNjk2OThiMzE3YzI5NDI3ZGE4MWNkNmZmZDU1YWU5MmNjNWMzNzc0MDk4MzM4ZGYxNDY5ZDg3JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.9OmwcpWmZ_2ewiMQywAbmynJgtY3VCx9BN3X66xxIto)
![12](https://private-user-images.githubusercontent.com/144563726/380545060-3c2dc01a-d705-4e9a-95ea-6142d3cc9c86.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzg5NTMyMDgsIm5iZiI6MTczODk1MjkwOCwicGF0aCI6Ii8xNDQ1NjM3MjYvMzgwNTQ1MDYwLTNjMmRjMDFhLWQ3MDUtNGU5YS05NWVhLTYxNDJkM2NjOWM4Ni5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjUwMjA3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI1MDIwN1QxODI4MjhaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT00NjQwMTk2OTI4Mjk4ZjQ4MjExYjc5ZGRkMWU3ZWVhYTgxMGJiOWMwMzA1ZmMwYzM3ODJkNGMxYzc5OGYyZmUxJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCJ9.LfZ1e-IQp0ZWHlDaCmiWYMedjDJP0sMaWB-D9LGnQr8)
- E-commerce Growth: The analysis shows a significant increase in e-commerce sales over the past few years, particularly during the pandemic.
- Consumer Behavior: Insights reveal changing consumer preferences towards online shopping, with younger demographics leading the trend.
- Impact on Traditional Retail: Traditional retail has faced challenges, with many businesses pivoting to online models or enhancing their online presence.
The project highlights the transformative effects of e-commerce on the retail landscape. Key insights include:
- The necessity for traditional retailers to adapt to the digital environment to remain competitive.
- Understanding consumer behavior is crucial for formulating effective marketing strategies.
- Continued growth in e-commerce is expected, emphasizing the importance of innovation and flexibility in business models.
Thank you for reviewing this project. Any feedback or questions can be directed to [laibamazhar.000@gmail.com].