def transform(row, table):
data = row._asdict()<EOL>data["<STR_LIT>"] = urljoin("<STR_LIT>", data["<STR_LIT>"])<EOL>data["<STR_LIT:name>"], data["<STR_LIT:state>"] = regexp_city_state.findall(data["<STR_LIT:name>"])[<NUM_LIT:0>]<EOL>return data<EOL>
Transform row "link" into full URL and add "state" based on "name