How can i strip the string below?(I just want to create a column to show city and state,you can see the city and state's name after \n)
df['Address']
array(['208 Michael Ferry Apt. 674\nLaurabury, NE 37010-5101',
'188 Johnson Views Suite 079\nKathleen, CA 48958',
'9127 Elizabeth Stravenue\nDanieltown, WI 06482-3489', ...,
'4215 Tracy Garden Suite 076\nJoshualand, VA 01707-9165',
'USS Wallace\n**FPO AE** 73316',
'37778 George Ridges Apt. 509\nEast Holly, NV 29290-3595'],
dtype=object)
You can use regex expressions to get the city name, in your case it would look something like this:
import re
example_string = '208 Michael Ferry Apt. 674\nLaurabury, NE 37010-5101'
city = re.findall(r"\n(.*?),", text)
print(city)
However, given that you have ... in your array, will probably cause problems, since that's not a string.