import pandas as pd data2 = {'Name':['Jai', 'Anuj', 'Jai', 'Princi', 'Gaurav', 'Anuj', 'Princi', 'Abhi'], 'Age':[27, 24, 22, 32, 33, 36, 27, 32], 'Address':['Nagpur', 'Kanpur', 'Allahabad', 'Kannuaj', 'Jaunpur', 'Kanpur', 'Allahabad', 'Aligarh'], 'Qualification':['Msc', 'MA', 'MCA', 'Phd', 'B.Tech', 'B.com', 'Msc', 'MA'], 'Score':[23, 34, 35, 45, 47, 50, 52, 53]} grp2 = df2.groupby('Name') sc = lambda x: (x - x.mean()) / x.std() grp2['Age'].transform(sc)