topic Re: Filtering large car data set based on criteria such as price, age, and odometer in Discussions

Filtering large car data set based on criteria such as price, age, and odometer

BaggingSpaces55 — Sat, 02 Dec 2023 13:59:25 GMT

Some of my car data does not make sense such as, a car from 2020 with 2506000 milage and a high price. How do I set up filter conditions based on my criteria. For example set conditions to exclude cars with:

Unusually high prices.
Unusually low or high ages.
Unusually high odometer readings.

Re: Filtering large car data set based on criteria such as price, age, and odometer

hogi — Sat, 02 Dec 2023 17:07:19 GMT

you can open a "global" data filter:

select the strange entries and then use the inverse option to show/include just the remaining rows:

Re: Filtering large car data set based on criteria such as price, age, and odometer

hogi — Sat, 02 Dec 2023 17:19:09 GMT

If the strange cars show up in a combination of properties, like you say:
car from 2020 with 2506000 milage

then you can plot the data, select the strange data points, and then label the selected rows
e.g. via Rows/Row Selection /Name Selection in Column.

Alternative - with more options: the want tool from

After labelling the outliers, you can either use the labels in Graph Builder to investigate further on the details - or use the label column to remove the labelled entries from the analysis:
"???" means: no label

Re: Filtering large car data set based on criteria such as price, age, and odometer

txnelson — Sat, 02 Dec 2023 17:26:00 GMT

You can use the Exploring Outliers analysis if you want to have JMP identify outliers for you

Analyze=>Screening=>Explore Outliers

JMP Help has a good deal of information on how to run the analysis.

You can also manually explore your data by setting up a Data Filter

Rows=>Data Filter

If you choose this route, you can setup the Data Filter to filter on Prices, Ages and Odometer Reading. Then you can open multiple platforms such as Distribution, Graph Builder etc. and the displays will automatically change as you modify your selection criteria in the Data Filter.

JMP Help also has details on how to setup and run the Data Filter