for k in range(0, 23566):
    for locality_name in real_estate_spb['locality_name']:
        if 'городской поселок' in locality_name:
            locality_name = locality_name.replace('городской поселок', 'поселок')
        elif 'городской посёлок' in locality_name:
            locality_name = locality_name.replace('городской посёлок', 'поселок')
        elif 'поселок городского типа' in locality_name:
            locality_name = locality_name.replace('поселок городского типа', 'поселок')
        elif 'посёлок городского типа' in locality_name:
            locality_name = locality_name.replace('посёлок городского типа', 'поселок')
        elif 'посёлок' in locality_name:
            locality_name = locality_name.replace('посёлок', 'поселок')
    real_estate_spb.loc[k, 'locality_name'] = locality_name