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: Sun, 1 May 2016 18:27:39 +0000 (UTC) Lines: 14 Message-ID: References: <919174787.8635501.1462127259949.JavaMail.yahoo.ref@mail.yahoo.com> <919174787.8635501.1462127259949.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 11MJwEjMvI8PcXDvDCtxLgHRe3OgUmDtj3aIVfIdsMTg== Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.019 X-Spam-Evidence: '*H*': 0.96; '*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; '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; '\xc2\xa0if': 0.16; 'to:name:python-list@python.org': 0.20; 'function,': 0.22; 'trying': 0.22; '8bit%:5': 0.23; 'skip:" 20': 0.26; 'back.': 0.27; '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; 'thank': 0.38; 'does': 0.39; 'to:addr:python.org': 0.40; 'hello,': 0.40; 'your': 0.60; 'response.': 0.66; 'header:Reply-To:1': 0.67; 'column.': 0.84; 'message-id:@mail.yahoo.com': 0.84; 'received:98.138.100': 0.84; 'received:98.138.100.102': 0.84; 'received:98.138.229': 0.84 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.uk; s=s2048; t=1462127440; bh=EK8Nz9KPmlrZ2RqTLrCcH4YvfFl0mIOsKGzMvVjzl/M=; h=Date:From:Reply-To:To:Subject:References:From:Subject; b=MIGCuNE2hgiRHFa96ok2mvlK5iPaqEnrmh/9plZx6PYYlbx5IziFn8EYdDfwZLY6LwdCDgA6XcvaMwGtTtAKm4ckzvNDUfMV7Rt/uGz6IiE7ikA1jISI00jRjQZfpLPaDKZicrkrznFn4QKD7iP7C0cxIDa3dkoSZjYhOFVBxKR228Vb8S1HYdSuXrfacYPQ6l9Bp0w25ByyMCN4HdmKbel9T8s+zjXz89p81AWSEHgg9/dmx8AjOe/bfuVEEbXp/2QrBv0OMqIZkmQiX1rRPITWpyrdC7X5fBTfs9pcNla7b5qsFdD9yzpFhLK2/gLnJJTcFllc8hB1m2Bc+O9u1w== X-Yahoo-Newman-Property: ymail-4 X-Yahoo-Newman-Id: 623328.62758.bm@omp1010.mail.ir2.yahoo.com X-YMail-OSG: VAobwKkVM1nocZb2tL39wNG5T0V5ZaoBkS4IFUjNpYiTi6Dq0jp3RP_2i4unrKo kKg7CBEcSnhbAC_XkrDTHEPLmen22JTENispux3QSw_mvXYVrDPxXuSg5sX1RYpZ7zwsGSgaEkwi U98tWbU6oF.KwLGOI8rwmgdZz8BWhAppr1lDaSRfRWrPhIIIWZkiCxiw152fcd0xVs5.b_W_TQeF TPGr40Sv4Ae3GciuetC3o7u0OM7PoBfJyEeku4y_e3RBwPWiZapdcV73SiIp2Zqix36PPv8bMPY5 5RoAwGqzq4w3bv9hBQd30WxnODEiU2FYRm6t10IrgejSxrR54Ad5w0RWpTG0M6JhMHq0H4M77LYn XEdCysUSnpZC.SVzLrG3qIRDI1Tw7BoYMnJBm2MsEGvNphZAkXY0h7Hs2jPnlgEkb4NAwIxjMGCh 7vUCF3Egn127dN3qGq0EpgTqrBvqM0wlUFaqOH7j93RLzpLgpvuoDrEK4_diozLQhW45v1OD0J2t 1Gg_m3MNzMpSMWuwOSh0m.A-- 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: <919174787.8635501.1462127259949.JavaMail.yahoo@mail.yahoo.com> X-Mailman-Original-References: <919174787.8635501.1462127259949.JavaMail.yahoo.ref@mail.yahoo.com> Xref: csiph.com comp.lang.python:107951 Hello, I am back. =C2=A0Thank you very much for your positive response. I am trying to use Pandas apply to execute a lookup function, so that we ca= n put abbreviation in a new column, in accordance to a state name in anothe= r column. Does anyone knows how to make this to work? Regards.DavidLook up functionstate_to_code =3D {"VERMONT": "VT", "GEORGIA":= "GA", "IOWA": "IA"}#table['moa_state_name'] =3D map(lambda x: x.upper(), t= able['moa_state_name'])def convert_state(row): =C2=A0 =C2=A0abbrev1 =3D =C2= =A0state_to_code(table['moa_state_name']) #'aatest' =C2=A0 =C2=A0if abbrev1= : =C2=A0 =C2=A0 =C2=A0 =C2=A0 return abbrev1 ##state_to_code[abbrev[0]] =C2= =A0 =C2=A0return np.nan#print convert_state(table['moa_state_name']) table.insert(0, "abbrev", np.nan) table['abbrev'] =3D table.apply(convert_state, axis=3D1)print state_to_code= ['ARKANSAS']