Data Preprocessing In Data Mining: Steps, Missing Value Imputation, Data Standardization

Probably the most time-consuming a part of a Information Scientist’s job is to arrange and preprocess the info at hand. The information we get in real-life eventualities shouldn’t be clear and appropriate for modelling. The information must be cleaned, dropped at a sure format and remodeled earlier than feeding to the Machine Studying fashions.

On the finish of this tutorial, you’ll know the next

Why Information Preprocessing?

When information is retrieved by scrapping web sites and gathering it from different information sources, it’s typically stuffed with discrepancies. It may be formatting points, lacking values, rubbish values and textual content and even errors within the information. A number of preprocessing steps should be carried out to guarantee that the info that’s fed to the mannequin is on top of things in order that the mannequin can study and generalize on it.

Information Cleansing

The primary and most important step is to scrub the irregularities within the information. With out doing this step, we can not make a lot sense out of the statistics of the info. These could be formatting points, rubbish values and outliers.

Formatting points

We’d like the info to be in a tabular format many of the occasions however it isn’t the case. The information may need lacking or incorrect column names, clean columns. Furthermore, when coping with unstructured information comparable to Pictures and Textual content, it turns into utmost important to get the 2D or 3D information loaded in Dataframes for modelling.

Rubbish Values

Many cases or full columns may need sure rubbish values appended to the precise required worth. For instance, contemplate a column “rank” which has the values comparable to: “#1”, “#3”, “#12”, “#2” and so on. Now, it is very important take away all of the previous “#” characters to have the ability to feed the numeric worth to the mannequin.


Many occasions sure numeric values are both too giant or too low than the typical worth of the precise column. These are thought-about as outliers. Outliers want particular therapy and are a delicate issue to deal with. These outliers may be measurement errors or they may be actual values as effectively. They both should be eliminated fully or dealt with individually as they may include quite a lot of essential data.

Lacking Values

It’s seldom the case that your information will include all of the values for each occasion. Many values are lacking or crammed with rubbish entry. These lacking values should be handled. These values can have a number of the reason why they may be lacking. They might be lacking on account of some cause comparable to sensor error or different components, or they may also be lacking fully at random.


Probably the most straight ahead and simplest way is to drop the rows the place values are lacking. Doing this has many disadvantages like lack of essential data. It may be a superb step to drop the lacking values when the quantity of information you might have is big. But when the info is much less and there are quite a lot of lacking values, you want higher methods to sort out this problem.

Imply/Median/Mode imputation

The quickest solution to impute lacking values is by merely imputing the imply worth of the column. Nonetheless, it has disadvantages as a result of it disturbs the unique distribution of the info. You may also impute the median worth or the mode worth which is usually higher than the straightforward imply.

Linear interpolation & KNN

Extra sensible methods may also be used to impute lacking values. 2 of that are Linear Interpolations utilizing a number of fashions by treating the column with clean values because the function to be predicted. One other method is to make use of clustering by KNN. KNN makes clusters of the values in a selected function after which assigns the worth closest to the cluster.

Information Standardization

In an information set with a number of numerical options, all of the options won’t be on the identical scale. For instance, a function “Distance” has distances in meters comparable to 1300, 800, 560, and so on. And one other function “time” has occasions in hours comparable to 1, 2.5, 3.2, 0.8, and so on. So, when these two options are fed to the mannequin, it considers the function with distances as extra weightage as its values are giant. To keep away from this situation and to have quicker convergence, it’s essential to convey all of the options on the identical scale.


A standard solution to scale the options is by normalizing them. It may be applied utilizing Scikit-learn’s Normalizer. It works not on the columns, however on the rows. L2 normalization is utilized to every statement in order that the values in a row have a unit norm after scaling.

Min Max Scaling

Min Max scaling could be applied utilizing Scikit-learn’s Min MaxScaler class. It subtracts the minimal worth of the options after which divides by the vary, the place the vary is the distinction between the unique most and unique minimal. It preserves the form of the unique distribution, with default vary in 0-1.

Normal Scaling

Normal Scaler additionally could be applied utilizing Scikit-learn’s class. It standardizes a function by subtracting the imply after which scaling to unit variance, the place unit variance means dividing all of the values by the usual deviation. It makes the imply of the distribution 0 and commonplace deviation as 1.


Numerous occasions information shouldn’t be in numeric kind as an alternative of within the categorical kind. For instance, contemplate a function “temperature” with values as “High”, “Low”, “Medium”. These textual values have to encoded in numerical kind to ready for the mannequin to coach upon. 

Categorical Information  

Categorical Information is label encoded to convey it in numerical kind. So “High”, “Medium” and “Low” could be Label Encoded to three,2, and 1. Categorical options could be both nominal or ordinal. Ordinal categorical options are these which have a sure order. For instance, within the above case, we will say that 3>2>1 because the temperatures could be measured/quantified. 

Nonetheless, in an instance the place a function of “City” which has values like “Delhi”, “Jammu” & “Agra”, can’t be measured. In different phrases, once we label encode them as 3, 2, 1, we can not say that 3>2>1 as a result of “Delhi” > ”Jammu” received’t make a lot sense. In such circumstances, we use One Scorching Encoding.

Steady Information

Options with steady values may also be discretized by binning the values into bins of particular ranges. Binning means changing a numerical or steady function right into a discrete set of values, primarily based on the ranges of the continual values. This turns out to be useful if you wish to see the tendencies primarily based on what vary the info level falls in. 

For instance, say we’ve got marks for 7 children starting from 0-100. Now, we will assign each child’s marks to a selected “bin”. Now we will divide into 3 bins with ranges 0 to 50, 51-70, and 71-100 belonging to bins 1,2, and three respectively. Due to this fact, the function will now solely include one in all these 3 values. Pandas affords 2 features to realize binning shortly: qcut and minimize.

Pandas qcut takes within the variety of quantiles and divides the info factors to every bin primarily based on the info distribution.

Pandas minimize, then again, takes within the customized ranges outlined by us and divides the info factors in these ranges.

Associated learn: Information Preprocessing in Machine Studying


Information Preprocessing is an important step in any Information Mining and Machine Studying job. All of the steps we mentioned are actually not all however do cowl many of the fundamental a part of the method. Information preprocessing methods are completely different for NLP and Picture information as effectively. Be sure that to attempt examples of above steps and implement in your Information Mining pipeline.

In case you are curious to study information science, try IIIT-B & upGrad’s PG Diploma in Information Science which is created for working professionals and affords 10+ case research & initiatives, sensible hands-on workshops, mentorship with trade consultants, 1-on-1 with trade mentors, 400+ hours of studying and job help with high companies.

Put together for a Profession of the Future



Socially Keeda

Socially Keeda, the pioneer of news sources in India operates under the philosophy of keeping its readers informed. tells the story of India and it offers fresh, compelling content that’s useful and informative for its readers.

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button

Adblock Detected

Please consider supporting us by disabling your ad blocker