Data Cleaning Exercises

Input table:Inputs are read-only. Every step works on a copy.
Input table inventory, rows 1 to 21 of 21
#
1invybqzSKU-62521760.28·CA (raw value " CA")
2invf1geSKU-7738501580.05MX
3invoi41SKU-000312-1.00USA
4invereeSKU-519123572.57·CA (raw value " CA")
5inv29z8SKU-000100.00UK
6invvnhmSKU-4924434524.17US
7invkmmsSKU-44967.5573.38CA
8inveec2SKU-684710us
9invezdpSKU-0936436956.62US
10invgt2uSKU-92594401,200.00MX
11inv4nh6SKU-6643721,200.00MX
12invi6w4SKU-0002missingabcmissing
13invqlouSKU-754347012.5mx⇥ (raw value "mx\t")
14inv04arSKU-1830empty969.00US
15invqmktSKU-6302349.999MX
16invkeprSKU-9281emptymissingCA
17invbl5xSKU-4147500missingUSA
18inv6qmzSKU-41693880empty
19invympzSKU-6955empty9.999mx⇥ (raw value "mx\t")
20invxr2kSKU-4668730.99US
21inv2c6vSKU-0917171-1.00USA

Playground: 21 input rows → 21 rows after your steps. Nothing here is graded, and your steps are saved in this browser only. Export the pipeline to keep a copy.

Raw source21 rows × 5 columnsPreview up to dateNot saved yet · sign in to save to your account