I am trying to clean up a large dataset, and the two columns im stuck on are 'address' and 'city'. The 'address' column is fine but the 'city' column which should contain only cities has 'APT 3' , '2ND FL', '#567', '55', etc... I want to add the val...
Join discussionI am analyzing a pollution data set. However, the date of each record is in the form 01-01-15, 02-01-15 , which is why I need to format it to 2015 for each row so that I can convert it to datetime . What should I use to do so?
HHimanshu commented
