Skip to main content

Using regular expressions and filters to create "or" conditions on customer data

The car_dealership.xlsx dataset contains information about the customers of a worldwide car dealership company, with relevant categories such as their names, driving experience, car manufacturer, model and year, or the city where the car was bought.

This scenario will illustrate how to use regular expressions to select specific values and create "or" conditions to match data that cannot be selected with usual filters. You will be able to perform cleansing operations on the rows that correspond to your criteria, or simply export them.

Download the file: car_dealership.xlsx.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!