How to convert column that has text element to column of numerics before modelling

Question

I am working on a dataset that has

How can I change Elements and Area with numbers before modelling

Answer 1

If need factorize for strings columns use:

cols = df.select_dtypes(object).columns
df[cols] = df[cols].apply(lambda x: pd.factorize(x)[0])