Options

Copy and paste results

shafiqshafiq Member Posts: 1 Contributor I
edited November 2018 in Help
Hi,
I'm using rapidminer version 5.2.008 for generating word frequency lists. I need to copy the results/lists in excel. I select a column and then use the command "copy" (from edit menu as well as shortcut) and "paste" it into excel. Surprisingly, sometimes it works and sometimes it does not. I wonder why it does not work often.

Any explanation or help will be highly appreciated.

Best regards,
Shafiq

Answers

  • Options
    MariusHelfMariusHelf RapidMiner Certified Expert, Member Posts: 1,869 Unicorn
    Hi Shafiq, I could not reproduce the problem, for me it works all the time. Which operating system are you using? Can you remember a situation where this fails regularly and reproducible?
    However, why not simply use the Write Excel operator? Please see the attached process for an example.

    Best, Marius
    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
    <process version="5.2.009">
      <context>
        <input/>
        <output/>
        <macros/>
      </context>
      <operator activated="true" class="process" compatibility="5.2.009" expanded="true" name="Process">
        <process expanded="true" height="290" width="701">
          <operator activated="true" class="text:create_document" compatibility="5.2.005" expanded="true" height="60" name="Create Document" width="90" x="45" y="30">
            <parameter key="text" value="Rapid-I rockz"/>
          </operator>
          <operator activated="true" class="text:create_document" compatibility="5.2.005" expanded="true" height="60" name="Create Document (2)" width="90" x="45" y="120">
            <parameter key="text" value="Rapid-I rulez"/>
          </operator>
          <operator activated="true" class="text:process_documents" compatibility="5.2.005" expanded="true" height="112" name="Process Documents" width="90" x="313" y="30">
            <parameter key="vector_creation" value="Term Frequency"/>
            <process expanded="true" height="308" width="615">
              <operator activated="true" class="text:tokenize" compatibility="5.2.005" expanded="true" height="60" name="Tokenize" width="90" x="112" y="30">
                <parameter key="mode" value="specify characters"/>
                <parameter key="characters" value=".: "/>
              </operator>
              <connect from_port="document" to_op="Tokenize" to_port="document"/>
              <connect from_op="Tokenize" from_port="document" to_port="document 1"/>
              <portSpacing port="source_document" spacing="0"/>
              <portSpacing port="sink_document 1" spacing="0"/>
              <portSpacing port="sink_document 2" spacing="0"/>
            </process>
          </operator>
          <operator activated="true" class="write_excel" compatibility="5.2.009" expanded="true" height="76" name="Write Excel" width="90" x="581" y="30">
            <parameter key="excel_file" value="c:\tmp\test1.xls"/>
          </operator>
          <operator activated="true" class="text:wordlist_to_data" compatibility="5.2.005" expanded="true" height="76" name="WordList to Data" width="90" x="447" y="120"/>
          <operator activated="true" class="write_excel" compatibility="5.2.009" expanded="true" height="76" name="Write Excel (2)" width="90" x="581" y="120">
            <parameter key="excel_file" value="c:\tmp\test2.xls"/>
          </operator>
          <connect from_op="Create Document" from_port="output" to_op="Process Documents" to_port="documents 1"/>
          <connect from_op="Create Document (2)" from_port="output" to_op="Process Documents" to_port="documents 2"/>
          <connect from_op="Process Documents" from_port="example set" to_op="Write Excel" to_port="input"/>
          <connect from_op="Process Documents" from_port="word list" to_op="WordList to Data" to_port="word list"/>
          <connect from_op="Write Excel" from_port="through" to_port="result 1"/>
          <connect from_op="WordList to Data" from_port="example set" to_op="Write Excel (2)" to_port="input"/>
          <connect from_op="Write Excel (2)" from_port="through" to_port="result 2"/>
          <portSpacing port="source_input 1" spacing="0"/>
          <portSpacing port="sink_result 1" spacing="0"/>
          <portSpacing port="sink_result 2" spacing="0"/>
          <portSpacing port="sink_result 3" spacing="0"/>
        </process>
      </operator>
    </process>
Sign In or Register to comment.