convert collection to a single table (ExampleSet)

Answers

• Options

  Marco_Boeck Administrator, Moderator, Employee, Member, University Professor Posts: 1,993 RM Engineering

  January 2015

  Hi,
  
  you've posted in the Development forum, so I'm assuming you want to know how to do it in Java. You will need to create a new ExampleSet with the same attributes as your existing sets have. You can then loop over each example (row) of each example set and add a row for each to the new one. See below for a quick example:

  
  MemoryExampleTable table = new MemoryExampleTable(listOfAtts);
  
  for (ExampleSet exSet : listOfExampleSets) {
  	for (Example e : exSet) {
  		table.addDataRow(e.getDataRow());
  	}
  }
  
  ExampleSet exSet = table.createExampleSet();
  

  In case you were looking for a solution inside RapidMiner Studio, just use the "Append" operator.
  
  Regards,
  Marco

  0
• Options

  VinayakThote Member Posts: 2 Learner I

  May 2023

  Append is also giving single collection object
  Whats the solution?? I want single example set.
  
  

  0
• Options

  BalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn

  May 2023

  Hi,
  
  if you use Append correctly, it will give you an example set. This is working every time in hundreds of processes.
  
  Please post a screenshot and the process XML if it doesn't work for you.
  
  Regards,
  Balázs

  0
• Options

  machbrown2 Member Posts: 3 Contributor I

  January 1

  Hello,
  
  It sounds like you want to concatenate or combine the tables generated for different values into a single table in your Example Set. If you are using a programming language or a tool that supports loops, you can achieve this by appending the tables for each value. Here's a general example using Python and pandas:
  </code>import pandas as pd # Initialize an empty DataFrame to store the combined tables combined_table = pd.DataFrame(columns=["USER_ID", "ITEM_ID"]) # Example loop (replace this with your actual loop) for value in [23, 54, ...]: # Add all your loop values # Assuming you have a function to generate each table based on the loop value table_for_value = generate_table(value) # Append the table for the current value to the combined_table combined_table = pd.concat([combined_table, table_for_value], ignore_index=True) # Display the combined table print(combined_table)</pre><div><br>In this example:<br><ul><li>Replace <code>[23, 54, ...] with the actual values you are looping through.Replace generate_table(value) with the function or code that generates the table for each value.The pd.concat function is used to concatenate the tables vertically (row-wise). The ignore_index=True parameter ensures that the resulting DataFrame has a new index.Note: The exact implementation may vary based on the language or tool you are using. If you provide more details about your environment, I can offer a more specific solution.
  
  

  0