Path: csiph.com!fu-berlin.de!uni-berlin.de!not-for-mail From: David Shi 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: References: <225454564.8325693.1462048831951.JavaMail.yahoo.ref@mail.yahoo.com> <225454564.8325693.1462048831951.JavaMail.yahoo@mail.yahoo.com> Reply-To: David Shi 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: 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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 I am trying to use apply to execute a lookup function, so that we can put a= bbreviation in a new column, in accordance to a state name in another colum= n. Does anyone knows how to make this to work? Regards. David state_to_code =3D {"VERMONT": "VT", "GEORGIA": "GA", "IOWA": "IA", "Armed F= orces Pacific": "AP", "GUAM": "GU",=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0"KANSAS": "KS", "FLORIDA": "FL", "AMERICAN SAMOA": = "AS", "NORTH CAROLINA": "NC", "HAWAII": "HI",=C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0"NEW YORK": "NY", "CALIFORNIA": "CA", "AL= ABAMA": "AL", "IDAHO": "ID", "FEDERATED STATES OF MICRONESIA": "FM",=C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0"Armed Forces Americ= as": "AA", "DELAWARE": "DE", "ALASKA": "AK", "ILLINOIS": "IL",=C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0"Armed Forces Africa": "AE= ", "SOUTH DAKOTA": "SD", "CONNECTICUT": "CT", "MONTANA": "MT", "MASSACHUSET= TS": "MA",=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0"PU= ERTO RICO": "PR", "Armed Forces Canada": "AE", "NEW HAMPSHIRE": "NH", "MARY= LAND": "MD", "NEW MEXICO": "NM",=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0"MISSISSIPPI": "MS", "TENNESSEE": "TN", "PALAU": "PW", = "COLORADO": "CO", "Armed Forces Middle East": "AE",=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0"NEW JERSEY": "NJ", "UTAH": "UT", "MI= CHIGAN": "MI", "WEST VIRGINIA": "WV", "WASHINGTON": "WA",=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0"MINNESOTA": "MN", "OREGON": "= OR", "VIRGINIA": "VA", "VIRGIN ISLANDS": "VI", "MARSHALL ISLANDS": "MH",=C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0"WYOMING": "WY",= "OHIO": "OH", "SOUTH CAROLINA": "SC", "INDIANA": "IN", "NEVADA": "NV", "LO= UISIANA": "LA",=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0"NORTHERN MARIANA ISLANDS": "MP", "NEBRASKA": "NE", "ARIZONA": "AZ", "WI= SCONSIN": "WI", "NORTH DAKOTA": "ND",=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0"Armed Forces Europe": "AE", "PENNSYLVANIA": "PA", = "OKLAHOMA": "OK", "KENTUCKY": "KY", "RHODE ISLAND": "RI",=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0"DISTRICT OF COLUMBIA": "DC", = "ARKANSAS": "AR", "MISSOURI": "MO", "TEXAS": "TX", "MAINE": "ME"} #table['moa_state_name'] =3D map(lambda x: x.upper(), table['moa_state_name= '])def convert_state(row):=C2=A0 =C2=A0 abbrev1 =3D =C2=A0state_to_code(tab= le['moa_state_name']) #'aatest'=C2=A0 =C2=A0 if abbrev1:=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0return abbrev1 ##state_to_code[abbrev[0]]=C2=A0 =C2=A0 ret= urn np.nan#print convert_state(table['moa_state_name']) table.insert(0, "abbrev", np.nan)table['abbrev'] =3D table.apply(convert_st= ate, axis=3D1) print state_to_code['ARKANSAS']