Skip to content

"This repository contains a cleaned and preprocessed dataset for my Data Analyst Internship task. The dataset was processed using Excel, with missing values handled, duplicates removed, and data formats standardized. The repository includes the cleaned dataset, a README file explaining the cleaning process, and screenshots of key steps."

Notifications You must be signed in to change notification settings

prachee01/data-cleaning-task

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

3 Commits
Β 
Β 
Β 
Β 

Repository files navigation

data-cleaning-task

Mall Customer Segmentation "This repository contains a cleaned and preprocessed dataset for my Data Analyst Internship task. The dataset was processed using Excel, with missing values handled, duplicates removed, and data formats standardized. The repository includes the cleaned dataset, a README file explaining the cleaning process."

πŸ“Š Dataset Overview

Column Name Description
CustomerID Unique ID assigned to each customer
Gender Gender of the customer (Male/Female)
Age Age of the customer
Annual Income (k$) Annual income in thousands of dollars
Spending Score (1-100) Score assigned by the mall based on customer behavior and spending

βœ… Features

  • Cleaned and ready-to-use
  • No missing values
  • Suitable for KMeans, DBSCAN, and other clustering algorithms
  • Ideal for visualizations using Matplotlib, Seaborn, or Excel

πŸ“‚ Files in this Repository

  • mall_customers_cleaned.csv – Cleaned dataset
  • README.md – Project documentation

πŸ’‘ Possible Use Cases

  • Customer segmentation using clustering (K-Means)
  • Marketing strategy and target analysis
  • Behavioral pattern visualization

πŸ‘©β€πŸ’» Cleaned & Uploaded by

Prachee Chahar 🏫 LinkedIn Profile


🏷 Tags

customer-segmentation data-analysis excel clustering unsupervised-learning machine-learning csv marketing

About

"This repository contains a cleaned and preprocessed dataset for my Data Analyst Internship task. The dataset was processed using Excel, with missing values handled, duplicates removed, and data formats standardized. The repository includes the cleaned dataset, a README file explaining the cleaning process, and screenshots of key steps."

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published