At the heart of Machine Learning is to process data. Your . This blog deals with the various steps of . Your data needs to go through a few steps before it is could be used for making predictions. machine learning tools are as good as the quality of your data cleaning data Steps involved in data preprocessing : Importing the required Libraries Importing the data set Handling the Missing Data. Encoding Categorical Data. Splitting the data set into test set and training set. Feature Scaling. So let us look at these steps one by one. Step 1: Importing the required Libraries To follow along you will need to download this dataset  : Data.csv Every time we make a new model, we will require to import Numpy and Pandas. Numpy is a Library which contains Mathematical functions and is used for scientific computing while Pandas  is used to import and manage the data sets. pandas pd numpy np import as import as Here we are importing the pandas and Numpy library and assigning a shortcut "pd" and "np" respectively. Step 2: Importing the Dataset Data sets are available in .csv format. A CSV file stores tabular data in plain text. Each line of the file is a data record. We use the read_csv method of the pandas library to read a local CSV file as a . dataframe dataset = pd.read_csv( ) 'Data.csv' After carefully inspecting our dataset, we are going to create a matrix of features in our dataset (X) and create a dependent vector (Y) with their respective observations. To read the columns, we will use iloc of pandas (used to fix the indexes for selection) which takes two parameters — [row selection, column selection]. X = dataset.iloc[:, : ].values
y = dataset.iloc[:, ].values -1 3 Step 3: Handling the Missing Data The data we get is rarely homogenous. Sometimes data can be missing and it needs to be handled so that it does not reduce the performance of our machine learning model. To do this we need to replace the missing data by the Mean or Median of the entire column. For this we will be using the sklearn.preprocessing Library which contains a class called Imputer which will help us in taking care of our missing data. sklearn.preprocessing Imputer
imputer = Imputer(missing_values = , strategy = , axis = ) from import "NaN" "mean" 0 Our object name is The Imputer class can take parameters like : imputer. : It is the placeholder for the missing values. All occurrences of missing_values will be imputed. We can give it an integer or "NaN" for it to find missing values. missing_values : It is the imputation strategy - If "mean", then replace missing values using the mean along the axis (Column). Other strategies include "median" and "most_frequent". : It can be assigned 0 or 1, 0 to impute along columns and 1 to impute along rows. strategy axis Now we fit the imputer object to our data. imputer = imputer.fit(X[:, : ]) 1 3 Now replacing the missing values with the mean of the column by using transform method. X[:, : ] = imputer.transform(X[:, : ]) 1 3 1 3 Step 4: Encoding categorical data Any variable that is not quantitative is categorical. Examples include Hair color, gender, field of study, college attended, political affiliation, status of disease infection. But why encoding ? We cannot use values like "Male" and "Female" in mathematical equations of the model so we need to encode these variables into numbers. To do this we import "LabelEncoder" class from "sklearn.preprocessing" library and create an object labelencoder_X of the LabelEncoder class. After that we use the fit_transform method on the categorical features. After Encoding it is necessary to distinguish between between the variables in the same column, for this we will use OneHotEncoder class from sklearn.preprocessing library. One-Hot Encoding One hot encoding transforms categorical features to a format that works better with classification and regression algorithms. sklearn.preprocessing LabelEncoder, OneHotEncoder
labelencoder_X = LabelEncoder()
X[:, ] = labelencoder_X.fit_transform(X[:, ])onehotencoder = OneHotEncoder(categorical_features = [ ])
X = onehotencoder.fit_transform(X).toarray()labelencoder_y = LabelEncoder()
y = labelencoder_y.fit_transform(y) from import 0 0 0 Step 5: Splitting the Data set into Training set and Test Set Now we divide our data into two sets, one for training our model called the and the other for testing the performance of our model called the . The split is generally 80/20. To do this we import the "train_test_split" method of "sklearn.model_selection" library. training set test set sklearn.model_selection train_test_split from import Now to build our training and test sets, we will create 4 sets — (training part of the matrix of features), X_train (test part of the matrix of features), X_test (training part of the dependent variables associated with the X train sets, and therefore also the same indices) , Y_train (test part of the dependent variables associated with the X test sets, and therefore also the same indices). Y_test We will assign to them the test_train_split, which takes the parameters — arrays (X and Y), test_size (Specifies the ratio in which to split the data set). X_train, X_test, Y_train, = train_test_split( X , Y , = , = ) Y_test test_size 0.2 random_state 0 Step 6: Feature Scaling Most of the machine learning algorithms use the between two data points in their computations . Because of this, in the distance calculations . To avoid this Feature standardization or Z-score normalization is used. This is done by using "StandardScaler" class of "sklearn.preprocessing". Euclidean distance high magnitudes features will weigh more than features with low magnitudes sklearn.preprocessing StandardScaler
sc_X = StandardScaler() from import Further we will transform our X_test set while we will need to fit as well as transform our X_train set. The transform function will transform all the data to a same standardized scale. X_train = sc_X.fit_transform(X_train)
X_test = sc_X.transform(X_test) So here you go, you have learned the basics steps involved in data preprocessing. Now you can try applying these preprocessing techniques on some real-world data sets.

Winner of Noonies 2020 for the award Hacker Noon Contributor of the Year - DATA SCIENCE.

2020 - Hacker Noon Contributor of the Year in DATA SCIENCE

Read my Stories on Medium

Book a call

Read My Stories

Software Engineer @ Tietoevry

Too Long; Didn't Read

In your car, at home, or at work — Bosch technology shapes many areas of life.

Data Preprocessing

Too Long; Didn't Read

Company Mentioned

Afroz Chakure

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

Data Preprocessing

Too Long; Didn't Read

Company Mentioned

Afroz Chakure

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

RELATED STORIES