Simple Python / Excel project: Take 2-line address and split into 2 columns
Budget: $10 – $30 USD
I have an excel file. It has some address that are in one single excel column (cell) but on two lines like this:
3424 Spring Road
Apt 10
I need these types of addresses to be split into 2 columns so that "3424 Spring Road" is in one column and "Apt 10" is in a second column. I need a python script that will take the path of the file (Windows - open a file dialogue box so I can choose the file!) as the input, and then output a new excel file with the additional column. Most addresses do NOT have 2 lines, so the new column in the exported excel file will be blank. But for those addresses that DO have a second line, the new column in the exported excel file will have a value. Make sure you understand this before bidding !
3424 Spring Road
Apt 10
I need these types of addresses to be split into 2 columns so that "3424 Spring Road" is in one column and "Apt 10" is in a second column. I need a python script that will take the path of the file (Windows - open a file dialogue box so I can choose the file!) as the input, and then output a new excel file with the additional column. Most addresses do NOT have 2 lines, so the new column in the exported excel file will be blank. But for those addresses that DO have a second line, the new column in the exported excel file will have a value. Make sure you understand this before bidding !