import pandas as pd df = pd.DataFrame(data = {'A': [1, 2, 3, 4, 5],'B' : [3214, 443, 2987, 3309, 13259]}) df['B']=df['B'].apply(lambda x: int(x // 100) *100) print(df)