How to fill in abbreviation in one column based on state name in another column?

Path	csiph.com!fu-berlin.de!uni-berlin.de!not-for-mail
From	David Shi <davidgshi@yahoo.co.uk>
Newsgroups	comp.lang.python
Subject	How to fill in abbreviation in one column based on state name in another column?
Date	Sat, 30 Apr 2016 20:40:31 +0000 (UTC)
Lines	42
Message-ID	<mailman.271.1462049007.32212.python-list@python.org> (permalink)
References	<225454564.8325693.1462048831951.JavaMail.yahoo.ref@mail.yahoo.com> <225454564.8325693.1462048831951.JavaMail.yahoo@mail.yahoo.com>
Reply-To	David Shi <davidgshi@yahoo.co.uk>
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	quoted-printable
X-Trace	news.uni-berlin.de 6poWssjezuagxaHKulBAsgBN80aVVg+Sx3bZXoDbsqJQ==
Return-Path	<davidgshi@yahoo.co.uk>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.013
X-Spam-Evidence	'H': 0.97; 'S': 0.00; 'from:addr:yahoo.co.uk': 0.05; 'subject:How': 0.09; 'lookup': 0.09; 'skip:# 20': 0.13; 'subject: \n ': 0.15; '"new': 0.16; 'from:addr:davidgshi': 0.16; 'from:name:david shi': 0.16; 'received:io': 0.16; 'received:psf.io': 0.16; 'reply-to:addr:davidgshi': 0.16; 'reply- to:name:david shi': 0.16; 'subject:based': 0.16; 'subject:fill': 0.16; 'to:name:python-list@python.org': 0.20; 'function,': 0.22; 'trying': 0.22; '8bit%:5': 0.23; 'skip:" 20': 0.26; 'forces': 0.29; 'print': 0.30; 'skip:s 30': 0.31; 'anyone': 0.32; 'another': 0.32; 'knows': 0.32; 'header:Received:8': 0.35; 'skip:c 30': 0.35; 'to:addr:python-list': 0.36; 'subject:?': 0.36; 'does': 0.39; 'to:addr:python.org': 0.40; 'regards.': 0.67; 'skip:\xc2 10': 0.67; 'header:Reply-To:1': 0.67; 'column.': 0.84; 'mariana': 0.84; 'message-id:@mail.yahoo.com': 0.84; 'received:98.138.121': 0.84
DKIM-Signature	v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.uk; s=s2048; t=1462049004; bh=uL0jr4zokY5Nt1qptv/kLgL4TxOyihdACBowHqd8XLk=; h=Date:From:Reply-To:To:Subject:References:From:Subject; b=HYOmTmtIHbaP9zRoNwjCTsQoJS7HG0RGOGJjzHikIDfZcyde9b5g6V27O0U1Iui51qjvkwS8wFV5q9LzhGBReppe3zxnOdR1VWrdJaTHGGWXqUFBO7bLMj+UWt2v8ipFjFr5UJl65ztgmP030L1utXxuIuZemYULoHOPhaTp0PnMBGtgfUrviPX65Q4Buc00B/2I9RXznLBowhdTWss2Y5QZpPklJlSskpQBq1nOEL351TnZJmVC+1O5eAYrjdYEAFskrEI4xPNR/8VoaGRDJex+8Xgp/w+933nJ0QnU6ChqS13xktsCqyMhbBIu2JegWcw6MjzFGAgDtB9VxQ9I+Q==
X-Yahoo-Newman-Property	ymail-4
X-Yahoo-Newman-Id	723626.3463.bm@omp1044.mail.ir2.yahoo.com
X-YMail-OSG	V2Smg7YVM1lLo3otcKLVJIh5taMi31DRlFy4A3Ey3xGSQjI_XmRCkO5PSVZkQCB yZ.sy8NxaseJ8wH81tQ3CVZjiNXp3d1XdPxBOw7fUXoussy.IQAVDso3uQyX3M06g8iEtNdMoWnp j5m0LOhh1d86gRj.WRWMCmGRKhuSVGwRfTUsv2vBHUHPb7NpsUe9KGyoTu07AZP1GY5ZrP54.ts1 BqyxYVdLSHBJ6vO3DezrbKribYgcb0CsXTTuhlG3i5GeYWi0BaM0qfr2VjUAzJXnsqc__NEPAOMW gyPprcwngDedgG1cwM9k3C6RzzedQePKkabqHD13XNtiHuNv4X8oosfjbKXg_Tz3HNoddWDY8AlF EYMoLAQCOTiwuuuLai99ut2nINJl1L7LPdOZL8.LBMfnqU_GlKVSb6WwARRwYuAamhHLkF.8nJQB AcPU642l_y4wQ1AIR366wf9gNL7tekaX5hLhGRDOCY_hlhRYN1sHgRkn6fIG6eZVXzsQg8KTKqUr iwiBR_j10RgGDxqUyf0Pyng--
X-Content-Filtered-By	Mailman/MimeDel 2.1.22
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.22
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list/>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
X-Mailman-Original-Message-ID	<225454564.8325693.1462048831951.JavaMail.yahoo@mail.yahoo.com>
X-Mailman-Original-References	<225454564.8325693.1462048831951.JavaMail.yahoo.ref@mail.yahoo.com>
Xref	csiph.com comp.lang.python:107924

Show key headers only | View raw

I am trying to use apply to execute a lookup function, so that we can put abbreviation in a new column, in accordance to a state name in another column.
Does anyone knows how to make this to work?
Regards.
David
state_to_code = {"VERMONT": "VT", "GEORGIA": "GA", "IOWA": "IA", "Armed Forces Pacific": "AP", "GUAM": "GU",                 "KANSAS": "KS", "FLORIDA": "FL", "AMERICAN SAMOA": "AS", "NORTH CAROLINA": "NC", "HAWAII": "HI",                 "NEW YORK": "NY", "CALIFORNIA": "CA", "ALABAMA": "AL", "IDAHO": "ID", "FEDERATED STATES OF MICRONESIA": "FM",                 "Armed Forces Americas": "AA", "DELAWARE": "DE", "ALASKA": "AK", "ILLINOIS": "IL",                 "Armed Forces Africa": "AE", "SOUTH DAKOTA": "SD", "CONNECTICUT": "CT", "MONTANA": "MT", "MASSACHUSETTS": "MA",                 "PUERTO RICO": "PR", "Armed Forces Canada": "AE", "NEW HAMPSHIRE": "NH", "MARYLAND": "MD", "NEW MEXICO": "NM",                 "MISSISSIPPI": "MS", "TENNESSEE": "TN", "PALAU": "PW", "COLORADO": "CO", "Armed Forces Middle East": "AE",                 "NEW JERSEY": "NJ", "UTAH": "UT", "MICHIGAN": "MI", "WEST VIRGINIA": "WV", "WASHINGTON": "WA",                 "MINNESOTA": "MN", "OREGON": "OR", "VIRGINIA": "VA", "VIRGIN ISLANDS": "VI", "MARSHALL ISLANDS": "MH",                 "WYOMING": "WY", "OHIO": "OH", "SOUTH CAROLINA": "SC", "INDIANA": "IN", "NEVADA": "NV", "LOUISIANA": "LA",                 "NORTHERN MARIANA ISLANDS": "MP", "NEBRASKA": "NE", "ARIZONA": "AZ", "WISCONSIN": "WI", "NORTH DAKOTA": "ND",                 "Armed Forces Europe": "AE", "PENNSYLVANIA": "PA", "OKLAHOMA": "OK", "KENTUCKY": "KY", "RHODE ISLAND": "RI",                 "DISTRICT OF COLUMBIA": "DC", "ARKANSAS": "AR", "MISSOURI": "MO", "TEXAS": "TX", "MAINE": "ME"}
#table['moa_state_name'] = map(lambda x: x.upper(), table['moa_state_name'])def convert_state(row):    abbrev1 =  state_to_code(table['moa_state_name']) #'aatest'    if abbrev1:         return abbrev1 ##state_to_code[abbrev[0]]    return np.nan#print convert_state(table['moa_state_name'])
table.insert(0, "abbrev", np.nan)table['abbrev'] = table.apply(convert_state, axis=1)
print state_to_code['ARKANSAS']

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

How to fill in abbreviation in one column based on state name in another column? David Shi <davidgshi@yahoo.co.uk> - 2016-04-30 20:40 +0000

csiph-web