Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
Use python to read several Rapidminer ExampleSets
Learner IHi everyone!
I am a beginner of Rapidminer.
I created a Loop on rapidminer that reads a series of csv files from a folder on my pc.
The loaded ExampleSets have only two columns.
For only one of these columns I want to calculate the larger values with Python.
how can this be done?
For the moment I have written a code on Python that reads ONLY A csv file of these:
with open(r'C:\Users\FR\Desktop\First.csv') as file:
for line in file:
item = int(line)
list.append(item)
results = []
for i in range(len(list):
a = lista[i-1]
b = lista[i]
c = lista[i+1]
if b >= a and b >= c:
results.append(b)
print(results)
is there a way not to repeat this code for each file?
is there a way not to repeat this code for each file?
Tagged:
0
Answers
If you would post your process here, maybe someone could give you more specific advise. Just copy the process xml into the post. If you are not using the Execute Python operator from the Python Scripting Extension, I highly recommend to use that. With the Execute Python operator you can work on pandas DataFrame. You have to define an rm_main method in your code as well. Something like this should do the trick:
import pandas<br>def rm_main(df):<br> df["c"] = df.apply(lambda x: x["a"] if x["a"] > x["b"] else x["b"], axis=1)<br> return dfHope this helps!