How to Normalise a Pandas DataFrame Column?

How to Normalise a Pandas DataFrame Column?

This recipe helps you Normalise a Pandas DataFrame Column

In [1]:
## How to Normalise a Pandas DataFrame Column
def Kickstarter_Example_96():
    print(format('How to Normalise a Pandas DataFrame Column','*^82'))

    import warnings

    # load libraries
    import pandas as pd
    from sklearn import preprocessing

    # Create an example dataframe with a column of unnormalized data
    data = {'score': [234,24,14,27,-74,46,73,-18,59,160]}
    df = pd.DataFrame(data)
    print(); print(df)

    # Normalize The Column
    # Create x, where x the 'scores' column's values as floats
    x = df[['score']].values.astype(float)
    print(); print(x)

    # Create a minimum and maximum processor object
    min_max_scaler = preprocessing.MinMaxScaler()

    # Create an object to transform the data to fit minmax processor
    x_scaled = min_max_scaler.fit_transform(x)

    # Run the normalizer on the dataframe
    df_normalized = pd.DataFrame(x_scaled)

    # View the dataframe
    print(); print(df_normalized)

********************How to Normalise a Pandas DataFrame Column********************

0    234
1     24
2     14
3     27
4    -74
5     46
6     73
7    -18
8     59
9    160

 [ 24.]
 [ 14.]
 [ 27.]
 [ 46.]
 [ 73.]
 [ 59.]

0  1.000000
1  0.318182
2  0.285714
3  0.327922
4  0.000000
5  0.389610
6  0.477273
7  0.181818
8  0.431818
9  0.759740

Relevant Projects

Big Data Project PySpark Tutorial - Learn to use Apache Spark with Python
PySpark Project-Get a handle on using Python with Spark through this hands-on data processing spark python tutorial.
Big Data Project Choosing the right Time Series Forecasting Methods
There are different time series forecasting methods to forecast stock price, demand etc. In this machine learning project, you will learn to determine which forecasting method to be used when and how to apply with time series forecasting example.
Big Data Project Data Science Project in Python on BigMart Sales Prediction
The goal of this data science project is to build a predictive model and find out the sales of each product at a given Big Mart store.
Big Data Project Anomaly Detection Using Deep Learning and Autoencoders
Deep Learning Project- Learn about implementation of a machine learning algorithm using autoencoders for anomaly detection.
Big Data Project Data Science Project - Instacart Market Basket Analysis
Data Science Project - Build a recommendation engine which will predict the products to be purchased by an Instacart consumer again.
Big Data Project Deep Learning with Keras in R to Predict Customer Churn
In this deep learning project, we will predict customer churn using Artificial Neural Networks and learn how to model an ANN in R with the keras deep learning package.
Big Data Project Data Science Project on Wine Quality Prediction in R
In this R data science project, we will explore wine dataset to assess red wine quality. The objective of this data science project is to explore which chemical properties will influence the quality of red wines.
Big Data Project German Credit Dataset Analysis to Classify Loan Applications
In this data science project, you will work with German credit dataset using classification techniques like Decision Tree, Neural Networks etc to classify loan applications using R.
Big Data Project Time Series Forecasting with LSTM Neural Network Python
Deep Learning Project- Learn to apply deep learning paradigm to forecast univariate time series data.
Big Data Project Human Activity Recognition Using Smartphones Data Set
In this deep learning project, you will build a classification system where to precisely identify human fitness activities.