Replacing multiple patterns
The analytics team needs to calculate average product sizes, but the size column contains text values like "30ml" instead of numbers. You can replace multiple patterns at once to clean these values.
Bu egzersiz, kursun bir parçasıdır
Data Transformation with Polars
Egzersiz talimatları
- Replace
"30ml","50ml", and"100ml"in the"size"column with their numeric equivalents"30","50", and"100". - Cast the
"size"column to a 64-bit integer.
Uygulamalı etkileşimli egzersiz
Bu egzersizi bu örnek kodu tamamlayarak deneyin.
# Replace size values with numeric strings
reviews.with_columns(
pl.col("size").str.____(["30ml","50ml","100ml"],["____","____","____"])
# Cast size column to integer
).____({"____":pl.Int64})