Pages: [1]
Author Topic: Apply filter of 'date and time' attribute  (Read 1635 times)
Posts: 1

« on: November 22, 2013, 10:41:25 PM »

I have one attribute named ‘rental time’ contain 2008, 2009, 2010, 2011, 2012 years of data sets of this format like “Mon Jan 14 07:32:30 CET 2008”. I want to apply filter for exclude 2008 and 2009 data. How should I apply filter in rapid miner to exclude this data.

I would be grateful to you.

Best regards,
« Last Edit: November 24, 2013, 05:49:28 PM by Sohaib » Logged
Marco Boeck
Hero Member
Posts: 1450

« Reply #1 on: November 25, 2013, 11:41:14 AM »


in RapidMiner Studio 6 this is very easy: Just add a "Filter Examples" operator, and add one condition which says "date < 01/01/2008" and a second condition which says "date > 12/31/2009", set the filters to "Match any" and you are done. You don't even need to enter this yourself, you can use the new filter GUI to do so Wink

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="6.0.000">
  <operator activated="true" class="process" compatibility="6.0.000" expanded="true" name="Process">
    <process expanded="true">
      <operator activated="true" class="generate_sales_data" compatibility="6.0.000" expanded="true" height="60" name="Generate Sales Data" width="90" x="45" y="30"/>
      <operator activated="true" class="filter_examples" compatibility="6.0.000" expanded="true" height="76" name="Filter Examples" width="90" x="246" y="30">
        <list key="filters_list">
          <parameter key="filters_entry_key" value=""/>
          <parameter key="filters_entry_key" value=""/>
        <parameter key="filters_logic_and" value="false"/>
      <connect from_op="Generate Sales Data" from_port="output" to_op="Filter Examples" to_port="example set input"/>
      <connect from_op="Filter Examples" from_port="example set output" to_port="result 1"/>
      <portSpacing port="source_input 1" spacing="0"/>
      <portSpacing port="sink_result 1" spacing="0"/>
      <portSpacing port="sink_result 2" spacing="0"/>

« Last Edit: November 25, 2013, 11:43:13 AM by Marco Boeck » Logged

Are you from a scientific background and want to use professional features of RapidMiner Studio 7? Check out our RapidMiner Academia program!

Looking for more information? Check out our docs page here:
Pages: [1]
Jump to: