python convert column format with numeric
if those  missing values are empty strings???, which Pandas doesn't recognise as null. To fix this, you can convert the empty stings (or whatever is in your empty cells) to np.nan objects using replace(), and then call dropna()on your DataFrame to delete rows with null tenants.
I have a dataframe df




name




project111


project212





project'09


projectws22




trying to replace the column that not numeric after 'project' to none, the output is as below:




name




project111


project212


none


none


none