Cogwheel & Crank customers
customers.csv cleaned by CleanSheet · 2 blank rows skipped
194rows in
186rows out
1078values changed
8duplicates removed
5values to check
Check before you use it
- City: 8 spellings merged into 5 values; review the mapping in changes.csv.
- Country: 6 spellings merged into 2 values; review the mapping in changes.csv.
- Bike type: 13 spellings merged into 6 values; review the mapping in changes.csv.
- 8 duplicate rows removed by First name + Last name + Email, keeping the most complete of each.
- 5 values could not be cleaned and were left as they were; see issues.csv.
Columns
| Column | Read as | Filled | Changed | To check | Spellings | Examples |
|---|---|---|---|---|---|---|
| Customer ID | id | 100% | 0 | 0 | 194 | |
| First name | name | 100% | 37 | 0 | 73 → 48 | |
| Last name | name | 100% | 27 | 0 | 50 → 30 | |
| 100% | 33 | 1 | 194 → 186 | |||
| Phone | phone | 93% | 164 | 2 | 175 | |
| Signup date | date day-first | 100% | 159 | 1 | 185 → 178 | |
| Last purchase | date day-first | 81% | 179 | 0 | 121 | |
| Total spent | number | 100% | 132 | 1 | 186 | |
| Newsletter | boolean | 87% | 161 | 0 | 7 → 2 | |
| City | category | 100% | 35 | 0 | 8 → 5 | |
| Country | category | 100% | 89 | 0 | 6 → 2 | |
| Bike type | category | 96% | 62 | 0 | 13 → 6 | |
| Shop notes from Notes | text | 5% | 0 | 0 | 2 |
Values to check (5)
| Line | Column | Value | Why |
|---|---|---|---|
| 14 | Signup date | 31/02/2024 | not a date |
| 32 | ollie.hart@gmail | not an email address | |
| 32 | Phone | ask in shop | not a phone number |
| 50 | Total spent | TBC | not a number |
| 130 | Phone | ask in shop | not a phone number |
Duplicates removed (8)
| Line | Kept line | Matched on |
|---|---|---|
| 125 | 7 | Amara · Ferreira · amara.ferreira@yahoo.co.uk |
| 58 | 24 | Owen · Fenwick · owen.fenwick@icloud.com |
| 108 | 42 | Dev · Petrov · dev.petrov@outlook.com |
| 152 | 73 | Hana · Mackay · hana.mackay@yahoo.co.uk |
| 147 | 93 | Yusuf · Novak · yusuf.novak@icloud.com |
| 194 | 136 | Malik · Ashby · malik.ashby@proton.me |
| 173 | 154 | Maya · Marsh · maya.marsh@proton.me |
| 178 | 175 | Idris · Lindqvist · idris.lindqvist@icloud.com |
First 15 cleaned rows
| Customer ID | First name | Last name | Phone | Signup date | Last purchase | Total spent | Newsletter | City | Country | Bike type | Shop notes | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CC-1001 | Dara | Thorne | dara.thorne@icloud.com | +447912295217 | 2024-09-28 | 2026-08-17 | 3893.47 | true | Keynsham | Ireland | E-bike | |
| CC-1002 | Owen | Iyer | owen.iyer@outlook.com | +447705983348 | 2021-01-02 | 2026-08-01 | 3698.87 | true | Bristol | Ireland | Cargo | |
| CC-1003 | Finn | Ashby | finn.ashby@yahoo.co.uk | +447117988468 | 2023-01-03 | 2026-05-04 | 761.38 | Bristol | United Kingdom | E-bike | ||
| CC-1004 | Ollie | Petrov | ollie.petrov@yahoo.co.uk | +447576935737 | 2021-07-25 | 2026-02-23 | 69.75 | false | Bristol | United Kingdom | Gravel | |
| CC-1005 | Noah | Okafor | noah.okafor@yahoo.co.uk | +447202144153 | 2025-05-01 | 2026-10-28 | 868.21 | true | Bristol | United Kingdom | E-bike | |
| CC-1006 | Amara | Ferreira | amara.ferreira@yahoo.co.uk | +447418339477 | 2025-08-27 | 1992.38 | true | Keynsham | Ireland | E-bike | ||
| CC-1007 | Bea | Brennan | bea.brennan@gmail.com | +447632283955 | 2023-04-24 | 2026-10-27 | 3596.50 | false | Bristol | Ireland | Road | |
| CC-1008 | Ben | Marsh | ben.marsh@yahoo.co.uk | +447561447041 | 2021-03-10 | 2026-02-05 | 5934.27 | Bristol | United Kingdom | Gravel | ||
| CC-1009 | Chloe | Okafor | chloe.okafor@icloud.com | +447854872957 | 2023-06-05 | 2026-06-18 | 56.27 | true | Bristol | United Kingdom | Hybrid | |
| CC-1010 | Ben | Thorne | ben.thorne@btinternet.com | +447363536465 | 2024-07-19 | 2026-11-03 | 2355.35 | true | Bath | United Kingdom | E-bike | |
| CC-1011 | Tomás | Ferreira | tomas.ferreira@gmail.com | +447476415655 | 2021-08-25 | 745.66 | Bath | United Kingdom | Gravel | |||
| CC-1012 | Quinn | Whitfield | quinn.whitfield@proton.me | +447608467782 | 2022-04-13 | 389.26 | true | Bristol | Ireland | Hybrid | ||
| CC-1013 | Zoë | Iyer | zoe.iyer@icloud.com | +447825394723 | 31/02/2024 | 2026-10-28 | 4020.19 | true | Bristol | United Kingdom | Gravel | |
| CC-1014 | Ollie | Novak | ollie.novak@gmail.com | +447943598222 | 2021-11-18 | 2026-11-03 | 3561.00 | true | Bristol | United Kingdom | Mountain | |
| CC-1015 | Idris | Fenwick | idris.fenwick@icloud.com | +447740107053 | 2022-02-14 | 2026-08-05 | 1735.88 | true | Keynsham | United Kingdom | Hybrid |