[idea] Allow pivot_wider on categorical values about explorer HOT 12 CLOSED

It should be possible today. Maybe we just need to relax the checks. Can you give it a try please?

from explorer.

Sorry - I clicked enter to early, I was updating the query but it's not livebook - here it just sends the message - it works with the example I pasted but it can be simpler with just one column

from explorer.

Sorry, I am confused then. Can you please provide a more complete example?

from explorer.

I'm thinking that when we know that this is a categorical value then we don't need to create another column just to create the ones and zeros.
Explorer.DataFrame.pivot_wider(df, "g") should be enough. Maybe with an option to fill empty values with zeros. I think this is a common usecase when preparing data for further processing.

from explorer.

also instead of having second column as a single value would be an option
Explorer.DataFrame.pivot_wider(df, "g", 1)

from explorer.

Let’s go in parts then. :) A PR to support categorical values is welcome. It is probably a small change and adding categories to the list of supports columns. Do you want to give it a try? :)

from explorer.

I may try, I never looked at the code but when it's elixir then I should be fine.

from explorer.

Yes, my assumption is that we only need to change the elixir bits

from explorer.

We just need to align how it should look. I think that creating additional column is not needed here. In other places we also accept either column or scalar value.

from explorer.

I probably won't do much here - when trying to run the tests it requires nightly rust and when I run it with nightly I'm getting:

RUST_BACKTRACE=1 mix test                                                                                                                                                   
...............thread '<unnamed>' panicked at 'panic in a function that cannot unwind', library/core/src/panicking.rs:126:5
stack backtrace:
..........................[1]    343905 segmentation fault (core dumped)  RUST_BACKTRACE=1 mix test

from explorer.

@dkuku please use the nightly version from our CI, which is nightly-2023-02-14.

from explorer.

it works with this version - thanks, I installed it with asdf.
Also I found the solution to my problem. It's the dummies function.

from explorer.