dataframe_apply.py

import pandas as pd
def region(row):
    #print(row)
    state = row["state"]
    if state in ("FL", "GA"): return "South"
    elif state in ("CA", "WA"): return "West"
    elif state in ("MT", "MN"): return "Central"
    elif state in ("NY", "ME"): return "North"
    else: return "Unknown"
    
#example data since I don't have your db.
df = pd.DataFrame(data={"d": [1,4,9,16], "state":["NY", "FL", "CA", "MT"]})

regions = df.apply(region, axis=1)

df["region"] = regions