02FMFaisal MalikHow do I write this regex pattern?I have a padas dataframe, from which I want to extract certain values: (' APT 2E'), (' 2ND fl'), (' #5B'), (#568'), (#1 FL' ), (FL 2' ) What kind of regex pattern would I write to select only these kind of values?Aug 7, 2019CH
00FMFaisal MalikHow to concat two data from two columns in Pandas DataFrame?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...Aug 4, 2019
01FMFaisal MalikPython/Pandas 'Merge'col_a & col_b. col_b has some data that I want to move and replace NaN values in col_a...while keeping the rest of col_a the same. How can I 'left' merge a column and get all the values from that one to replace the null values? Thank for your help!Jun 28, 2019M