Normalize column pandas

import pandas as pd
from sklearn import preprocessing

x = df.values #returns a numpy array
min_max_scaler = preprocessing.MinMaxScaler()
x_scaled = min_max_scaler.fit_transform(x)
df = pd.DataFrame(x_scaled)

Source: stackoverflow.com

import pandas as pd

df = pd.DataFrame(
    columns=['term', '2002', '2003', '2004', '2005'],
    data=[['climate', 1, 10, 1, 14],
          ['global', 12, 11, 2, 12],
          ['nuclear', 10, 1, 0, 4], ])
normalized = df.select_dtypes('int').apply(lambda x: x / sum(x))
df = df.merge(
    right=normalized,
    left_index=True,
    right_index=True,
    suffixes=['', '_norm']
)

Source: stackoverflow.com

In [5]: %paste                                                                                                                                                                                                                                                                       
cols = ['2002', '2003', '2004', '2005']
df[cols] = df[cols] / df[cols].sum()

## -- End pasted text --

In [6]: df                                                                                                                                                                                                                                                                           
Out[6]: 
      term      2002      2003      2004      2005
0  climate  0.043478  0.454545  0.333333  0.466667
1   global  0.521739  0.500000  0.666667  0.400000
2  nuclear  0.434783  0.045455  0.000000  0.133333

Source: stackoverflow.com

# define a method to scale data, looping thru the columns, and passing a scaler
def scale_data(data, columns, scaler):
    for col in columns:
        data[col] = scaler.fit_transform(data[col].values.reshape(-1, 1))
    return data

-1

Source: stackoverflow.com

Similar codes

2 votes137 views1 answer
How to save a model fast ai
Python
2 votes137 views1 answer
Mulitplication symbo for unpacking in python
Python
0 vote122 views1 answer
Return the intersection of this RDD and another one
Python
1 vote162 views1 answer
Django celery results
Python Django
4 votes124 views1 answer
Get path to file without filename python
Python
15 votes156 views2 answers
Ansi colors
Python
11 votes135 views3 answers
Dataframe delete row
Python
11 votes121 views6 answers
Get file size python
Python
0 vote122 views1 answer
Create button in pyqt
Python
0 vote137 views1 answer
Python yeild
Python