/Python/How to convert categorical data to numerical data in python

How to convert categorical data to numerical data in python

Transform categorical variables python

from sklearn.preprocessing import LabelEncoder

lb_make = LabelEncoder()
obj_df["make_code"] = lb_make.fit_transform(obj_df["make"])
obj_df[["make", "make_code"]].head(11)

Source: pbpython.com

Convert categorical variable to numeric python

# get all categorical columns in the dataframe
catCols = [col for col in df1.columns if df1[col].dtype=="O"]

from sklearn.preprocessing import LabelEncoder

lb_make = LabelEncoder()

for item in catCols:
    df1[item] = lb_make.fit_transform(df1[item])

Panda categorical data into numerica

sex = train_dataset['Sex'].replace(['female','male'],[0,1])
print(sex)

Pandas categorical to numeric

#this will label as one hot vectors (origin is split into 3 columns - USA, Europe, Japan and any one place will be 1 while the others are 0)
dataset['Origin'] = dataset['Origin'].map({1: 'USA', 2: 'Europe', 3: 'Japan'})

Source: tensorflow.org

How to convert categorical data to numerical data in python

pd.get_dummies(obj_df, columns=["body_style", "drive_wheels"], prefix=["body", "drive"]).head()

Source: pbpython.com

How to convert categorical data to numerical data in python

obj_df["body_style"] = obj_df["body_style"].astype('category')
obj_df.dtypes

Source: pbpython.com

Similar codes

33 votes175 views6 answers
Merge dataframe
Python
1 vote174 views1 answer
Python get human readable file size
Python
0 vote158 views1 answer
How to run shell command ctrl + c in python script
Python
0 vote172 views1 answer
How do i activate python on windows
Python
0 vote176 views1 answer
Western school district
Python
1 vote159 views1 answer
Mac catallina python3
Python
5 votes149 views1 answer
Pandas save file to pickle
Python
47 votes171 views6 answers
Pandas read csv
Python
2 votes176 views1 answer
Google calendar Request had insufficient authentication scopes.
Python
3 votes178 views1 answer
Python ftp upload file
Python