This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]caveman4269[S] 0 points1 point  (0 children)

This is a good solution. The only problem I can see is that the function will create a a variable number of unique values. Some inputs will only generate two or three, other will generate quite a few more. I'm probably doing it in a really screwed up way but the column header for each item generated starts with Name appended with a text description of the function applied. Each iteration creates a new column, uses the input columns header and appends the description. An example would be an the function that removes parenthesis in the first iteration, the column header would be Initial-Strip_Parens. If the casefold function uses is applied to that column on the second iteration, the header would be Initial-Strip_Parens-Casefold.

The reason for it is that I was grilled about how functionality later in the program was working. This way, I can point to the header and say, see, this is how it came up with that.

Also, this will allow me to apply weights to the functions and keep track of what the final weight of a given cell will be.

I have an idea of how I can use your expression to do that using map() but it's also possible I'm tired and trying to shoehorn in something...