Remove seemingly "empty" rows in Excel Sheet - Containing Spaces
Learner I
Hi guys,
I'm currently cleaning my data and also used an operator to remove missing values. I realized, after writing an excel sheet, that there were still some "empty" cells left. These cells aren't empty though, they are containing a space, thus they seem empty but are really not and Rapidminer won't detect them as such.
Is there any way to remove rows with one or two spaces in them? As there is text in the other rows I can't just remove all spaces or the text won't make sense anymore.
Do you guys have a solution for this?
I attached an exemplary file. One of the rows in question would be e.g. row number 138.
Thanks in advance!
Have a lovely day!
I'm currently cleaning my data and also used an operator to remove missing values. I realized, after writing an excel sheet, that there were still some "empty" cells left. These cells aren't empty though, they are containing a space, thus they seem empty but are really not and Rapidminer won't detect them as such.
Is there any way to remove rows with one or two spaces in them? As there is text in the other rows I can't just remove all spaces or the text won't make sense anymore.
Do you guys have a solution for this?
I attached an exemplary file. One of the rows in question would be e.g. row number 138.
Thanks in advance!
Have a lovely day!
0
Best Answer
-
kayman
Member Posts: 662 
Unicorn
Use the trim operator, this ensures non text fields are converted to missing (real blank) before export to excel
1
Answers
that worked like a charm! Thanks you so much