Skip to content

yunjiewuw/Ecommerce_Transaction_Database_Analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

18 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Ecommerce_Transaction_Database_Analysis

Overview

The E-commerce Transaction Database Analysis project aims to provide valuable business insights to an e-commerce firm by analyzing transaction data from 2019. The analysis includes various aspects such as revenue differences between new and old customers, predicting customer lifetime value, identifying sales bundles, and segmenting customers using both heuristic and machine learning techniques. Leveraging transaction, tax, and spend datasets, this project serves as a foundation for deriving actionable business strategies.

Summary of Findings:

  • TBF (to be filled)

Technologies Used

Python: Programming language used for data analysis and modeling.

  • pandas: Library for data manipulation and analysis.
  • scikit-learn: Library for machine learning algorithms and evaluation metrics.(Kmeans, LogisticRegression, SVM)
  • mlxtend: apriori algorithm
  • matplotlib and seaborn: Libraries for data visualization.

Analysis Process

  • 📖 Background Study Study on E-commerce Industry and Business Objectives Exploration on E-commerce Industry

  • 👓 Data Exploration & EDA Analysis: Gain insights into the structure and content of the dataset. EDA- descriptive approach

  • ⌛ Feature Engineering: Preprocess and transform the data to create relevant features for modeling.

  • 📊 Model Training: Build and train classification models to predict product bundles based on transactional data. Trend decomposition and KMean clustering

  • ✔️ Model Evaluation: Assess the performance of the trained models using metrics such as accuracy and confusion matrix.

Dataset

The dataset used for this analysis comprises transactional data from the public Kaggle Database: Marketing Insights for E-Commerce Company

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published