Classification Time.Dataset1 with respect to Time ranges from Dataset2

gigiorgianni

Hello, I am Gianfranco, I am new. I am Post-DOC in the field of Industrial. First of all, thanks for sharing your knowledge. You saved me for several nights J. Chemistry/Heterogeneous Catalysis.  Now, my problem is: I have two datasets (DATASET1 and DATASET2).

DATASET1 looks like:

 

DATASET2

 

 I'd like to match the Time in DATASET1 to the Time ranges reported in DATASET2, like:

 

In excel is very easy (index and match functions), but slow.

Could you help me, please?

Thanks in advance.

Gianfranco

rfuentealba

Hi Gianfranco,

 

Yes. It's actually simpler on RapidMiner. You can use the Join operator. Here is a test.

 

<?xml version="1.0" encoding="UTF-8"?><process version="9.0.002">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="9.0.002" expanded="true" name="Process">
    <process expanded="true">
      <operator activated="true" class="read_excel" compatibility="9.0.002" expanded="true" height="68" name="Read HTA" width="90" x="45" y="34">
        <parameter key="excel_file" value="/Users/rodrigo/data.xlsx"/>
        <parameter key="sheet_number" value="2"/>
        <list key="annotations"/>
        <parameter key="date_format" value="MMM d, yyyy h:mm:ss a z"/>
        <list key="data_set_meta_data_information">
          <parameter key="0" value="Date.true.date_time.attribute"/>
          <parameter key="1" value="Systolic.true.integer.attribute"/>
          <parameter key="2" value="Diastolic.true.integer.attribute"/>
        </list>
        <parameter key="read_not_matching_values_as_missings" value="false"/>
      </operator>
      <operator activated="true" class="read_excel" compatibility="9.0.002" expanded="true" height="68" name="Read Pulse" width="90" x="45" y="136">
        <parameter key="excel_file" value="/Users/rodrigo/data.xlsx"/>
        <list key="annotations"/>
        <parameter key="date_format" value="MMM d, yyyy h:mm:ss a z"/>
        <list key="data_set_meta_data_information">
          <parameter key="0" value="Date.true.date_time.attribute"/>
          <parameter key="1" value="Pulse.true.integer.attribute"/>
        </list>
        <parameter key="read_not_matching_values_as_missings" value="false"/>
      </operator>
      <operator activated="true" class="concurrency:join" compatibility="9.0.002" expanded="true" height="82" name="Join" width="90" x="179" y="85">
        <list key="key_attributes">
          <parameter key="Date" value="Date"/>
        </list>
      </operator>
      <connect from_op="Read HTA" from_port="output" to_op="Join" to_port="left"/>
      <connect from_op="Read Pulse" from_port="output" to_op="Join" to_port="right"/>
      <connect from_op="Join" from_port="join" 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"/>
    </process>
  </operator>
</process>

I wanted to attach my data.xlsx file but it doesn't let me, so here are pics:

 

This is my average pulse.This is my average systolic and diastolic blood pressure.

 

(Don't be scared, it's my cardiac monitor information and I have been doing some workout on the afternoon, so blood pressure is expected to be higher than normal).

 

The process looks like this:

 

 

You should make sure you don't use id attribute as key, and then add your date attributes to the list.

 

All the best,

 

Rodrigo.

 

Screen Shot 2018-09-07 at 00.50.34.png

Screen Shot 2018-09-07 at 00.51.57.png

Screen Shot 2018-09-07 at 00.52.18.png