擅长:python、mysql、java
<pre><code>import pandas as pd
data = pd.read_csv('states.csv')
print(data)
Address
0 311 Jalan Springhill SELANGOR
1 31 Jalan Segamat JOHOR
for index, row in data.iterrows():
value = row.Address
State = value.split()[-1:][0]
data.loc[index,'State'] = State
print(data)
Address State
0 311 Jalan Springhill SELANGOR SELANGOR
1 31 Jalan Segamat JOHOR JOHOR
</code></pre>