Convert column into same format
df['incident_no'] = df['incident_no'].str.replace('-','')
I have an incident number column that I'm trying to make consistent in terms of the format that it's in. Some are printed as '15-0019651' and others are '18490531'. All I'm trying to do is remove the hyphen for the Inci_no's that have them.
When I run df.Inci_no.dtype it returns it as object.