Hi Ziyad R. Al Ashhab ,

I think at first you should tell us what kind of string is in your data.

For example, there is a column that contains:

http://www.yahoo.com/mail

http://www.yahoo.com/123

http://www.yahoo.com/123

http://www.yahoo.com/mail/yahoo

http://www.yahoo.com/mail

Hi Ziyad R. Al Ashhab,

You could try pandas package for Python. It’s easy-way to use and transform your data. You can convert your string columns to categories, and then to numbers.

Here an example code:

import pandas as pd

df = pd.read_csv("your_excel_finel_in_CSV_format.csv")

df.your_string_col_name1 = pd.Categorical(df.your_string_col_name1).codes

df.your_string_col_name2 = pd.Categorical(df.your_string_col_name2).codes

...

Here a dummy example based on your data:

import pandas as pd

df = pd.DataFrame({"col1":[1, 2, 3, 4, 5], "col2":[22.5, -3.45, 5.12, 48.00, 33.33], "col3": ["http://www.yahoo.com/123", "http://www.yahoo.com/mail", "http://www.yahoo.com/mail/yahoo", "http://www.yahoo.com/123", "http://www.yahoo.com/mail"]})

print(df)

df.col3 = pd.Categorical(df.col3).codes print(df)

I hope I have been able to help you with this task.

@ francisco

Many thanks for your replied 👍⚘

Francisco M. Garcia-Moreno

Many thanks...

What about normalization/scaling Please