Advertisements I have dataframe with column d1 and now i am trying calculate ‘out’ column after ranking that column when there in ‘nan’ value with in a column. data_input = {‘Name’:[‘Renault’, ‘Renault’, ‘Renault’, ‘Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’], ‘type’:[‘Duster’, ‘Duster’, ‘Duster’,’Duster’,’Duster’,’Duster’,’Duster’,’Triber’,’Triber’,’Triber’,’Triber’,’Triber’,’Triber’,’Triber’], ‘d1’:[‘nan’,’10’,’10’,’10’,’nan’,’nan’,’20’,’20’,’nan’,’nan’,’30’,’30’,’30’,’nan’]} df_input = pd.DataFrame(data_input) data_out = {‘Name’:[‘Renault’, ‘Renault’, ‘Renault’, ‘Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’,’Renault’], ‘type’:[‘Duster’, ‘Duster’, ‘Duster’,’Duster’,’Duster’,’Duster’,’Duster’,’Triber’,’Triber’,’Triber’,’Triber’,’Triber’,’Triber’,’Triber’], ‘d1’:[‘nan’,’10’,’10’,’10’,’nan’,’nan’,’20’,’20’,’nan’,’nan’,’30’,’30’,’30’,’nan’], ‘out’:[1,np.NaN,np.NaN,np.NaN,2,2,np.NaN,np.NaN,1,1,np.NaN,np.NaN,np.NaN,2]} df_out = pd.DataFrame(data_out)… Read More rank for nan values based on group