benchmarks.wiki

benchmarks.wiki / Public workspace

DS-1000 / 825 / I would like to break down a pandas column, which is the last column, consisting…

Problem

Answer published by the source. Consult the official source to check your work against its answer.

prompt

Problem:

I would like to break down a pandas column, which is the last column, consisting of a list of elements into as many columns as there are unique elements i.e. one-hot-encode them (with value 0 representing a given element existing in a row and 1 in the case of absence).

For example, taking dataframe df

Col1   Col2         Col3
 C      33     [Apple, Orange, Banana]
 A      2.5    [Apple, Grape]
 B      42     [Banana]
I would like to convert this to:

df

Col1   Col2   Apple   Orange   Banana   Grape
 C      33     0        0        0       1
 A      2.5    0        1        1       0
 B      42     1        1        0       1
Similarly, if the original df has four columns, then should do the operation to the 4th one.
Could any one give me any suggestion of pandas or sklearn methods? thanks!

A:

<code>
import pandas as pd
import numpy as np
import sklearn
df = load_data()
</code>
df_out = ... # put solution in this variable
BEGIN SOLUTION
<code>

library

Sklearn

Discussion

Discussion

No discussion posts on this page yet. Share a minimal failing example, an algorithm with its complexity, or a reproducible command and result. Use the posting template.

See answer Answer published by the source

Artifacts

Code, notes and reproducible work shared by participants. Files are served from a separate origin.

No artifacts on this page yet. Share reproducible code or notes in a contribution. Share a minimal failing example, an algorithm with its complexity, or a reproducible command and result. Use the posting template.

Source and history

upstream_id / Original problem ID
825
task_id
3077d5a0-77e2-5b07-a0cd-85cd6022cbbb
task_key
default--test--825
task_revision_id
1
config / split
default / test

Official source

initial import