Path: csiph.com!fu-berlin.de!uni-berlin.de!not-for-mail From: Joel Goldstick Newsgroups: comp.lang.python Subject: Re: How to fill in abbreviation in one column based on state name in another column? Date: Sat, 30 Apr 2016 16:49:50 -0400 Lines: 48 Message-ID: References: <225454564.8325693.1462048831951.JavaMail.yahoo.ref@mail.yahoo.com> <225454564.8325693.1462048831951.JavaMail.yahoo@mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Trace: news.uni-berlin.de mG7Ov32XOwIRW35V/6EFjg7nPMyk3vUxyPEb3nX5P3Jw== Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.025 X-Spam-Evidence: '*H*': 0.95; '*S*': 0.00; 'cc:addr:python-list': 0.09; 'subject:How': 0.09; 'lookup': 0.09; 'url:blog': 0.10; 'skip:# 20': 0.13; 'subject: \n ': 0.15; '"new': 0.16; '2016': 0.16; 'received:io': 0.16; 'received:psf.io': 0.16; 'subject:based': 0.16; 'subject:fill': 0.16; 'wrote:': 0.16; 'cc:2**0': 0.20; 'cc:addr:python.org': 0.20; 'function,': 0.22; 'trying': 0.22; 'sat,': 0.23; 'header:In-Reply-To:1': 0.24; 'figure': 0.27; 'message-id:@mail.gmail.com': 0.27; 'forces': 0.29; 'print': 0.30; 'url:mailman': 0.30; 'code': 0.30; 'skip:s 30': 0.31; 'post': 0.31; 'anyone': 0.32; 'another': 0.32; 'knows': 0.32; 'url:python': 0.33; 'url:listinfo': 0.34; 'received:google.com': 0.35; 'skip:c 30': 0.35; 'could': 0.35; 'url:org': 0.36; 'received:209.85': 0.36; 'subject:?': 0.36; 'pm,': 0.36; 'subject:: ': 0.37; 'really': 0.37; 'doing': 0.38; 'received:209': 0.38; 'does': 0.39; 'received:209.85.214': 0.39; 'url:mail': 0.40; 'your': 0.60; '30,': 0.63; 'python-list': 0.66; 'regards.': 0.67; 'url:info': 0.71; 'column.': 0.84; 'mariana': 0.84; 'to:none': 0.91; 'joel': 0.91 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:cc :content-transfer-encoding; bh=7ZjUbPGC4V13OdpCdeUa+k+pSO6YpOM5ONBrO98l+No=; b=GXvJ/UnASfk14Uotjfm4w2La8V4D7RRDNpVQIGviCtSRorRGw64pFD/lwvGBj2/3BV yicvnU/KUtZzeOaGoBF8UZxJskZAFesbWVhhwMHYsOmy10tPMYXC5CAYNiUTdQDmmqXL 2ct4Y2SlF6Ovr66+XdDH/7MGdFQnTjWoIySuy/vrNxxMMN1oylojO6+2qgFwKxGM2vis luCA3zNE3SPIbIOiW3SOJiU/er8GwsuiAh6MIBX+nj24WEbwWy+R7Gyx7xG8SEdg6fPD bR/a7HTfVaq1a+rkclwJvzsBj7ALagfP9RDQuHPTW/aBuvORJNJB3MdxrMv1dqikcwML p4ZQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:cc:content-transfer-encoding; bh=7ZjUbPGC4V13OdpCdeUa+k+pSO6YpOM5ONBrO98l+No=; b=LQU6mBt/WkNuGWawFmACTwR7gNjTt3le+2fUSwGFMB63pPuQQ+PZvufjW86MYI3ZGn BDwpDxlhQsQ+2KmEu3ZQvEqhvci/Pf8pe6LVmgAWCySbtYvqFdUVrPwqQqM98/kD0NEY 0mNQZRiCByFGO3Q7/zZ1pDYMMUWXLFPlO4gnxk+174u4WH7B0PZI6ITMh0nF0plrQYpA wTkvvhJWWThiJ7gV1hUbDyPaUg426CA0FvzVvS7R1GPbFraV8uf4G0zY9bpaGolkojiS UTyJtGlJNyt8BP8SPdfBxHh7Oyw4wXVxoIq1mNR+F9sHwVVUcEWYhlg8UIHrsaCmRFAI C6Kg== X-Gm-Message-State: AOPr4FUrE52ncVTviQeoGXDCQPd5X38j1J57D3eUNRxuwxAH/N8q8kOVLCYTTlATnVaCuEkHZVeYAQLwWhK6uw== X-Received: by 10.60.13.132 with SMTP id h4mr11894620oec.70.1462049390736; Sat, 30 Apr 2016 13:49:50 -0700 (PDT) In-Reply-To: <225454564.8325693.1462048831951.JavaMail.yahoo@mail.yahoo.com> 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: X-Mailman-Original-References: <225454564.8325693.1462048831951.JavaMail.yahoo.ref@mail.yahoo.com> <225454564.8325693.1462048831951.JavaMail.yahoo@mail.yahoo.com> Xref: csiph.com comp.lang.python:107925 could you post in plaintext as its really hard to figure out what your code is doing On Sat, Apr 30, 2016 at 4:40 PM, David Shi via Python-list wrote: > 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 col= umn. > Does anyone knows how to make this to work? > Regards. > David > state_to_code =3D {"VERMONT": "VT", "GEORGIA": "GA", "IOWA": "IA", "Armed= Forces Pacific": "AP", "GUAM": "GU", "KANSAS": "KS", "FLOR= IDA": "FL", "AMERICAN SAMOA": "AS", "NORTH CAROLINA": "NC", "HAWAII": "HI",= "NEW YORK": "NY", "CALIFORNIA": "CA", "ALABAMA": "AL", "ID= AHO": "ID", "FEDERATED STATES OF MICRONESIA": "FM", "Armed = Forces Americas": "AA", "DELAWARE": "DE", "ALASKA": "AK", "ILLINOIS": "IL",= "Armed Forces Africa": "AE", "SOUTH DAKOTA": "SD", "CONNEC= TICUT": "CT", "MONTANA": "MT", "MASSACHUSETTS": "MA", "PUER= TO RICO": "PR", "Armed Forces Canada": "AE", "NEW HAMPSHIRE": "NH", "MARYLA= ND": "MD", "NEW MEXICO": "NM", "MISSISSIPPI": "MS", "TENNES= SEE": "TN", "PALAU": "PW", "COLORADO": "CO", "Armed Forces Middle East": "A= E", "NEW JERSEY": "NJ", "UTAH": "UT", "MICHIGAN": "MI", "WE= ST 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", "N= ORTHERN MARIANA ISLANDS": "MP", "NEBRASKA": "NE", "ARIZONA": "AZ", "WISCONS= IN": "WI", "NORTH DAKOTA": "ND", "Armed Forces Europe": "AE= ", "PENNSYLVANIA": "PA", "OKLAHOMA": "OK", "KENTUCKY": "KY", "RHODE ISLAND"= : "RI", "DISTRICT OF COLUMBIA": "DC", "ARKANSAS": "AR", "MI= SSOURI": "MO", "TEXAS": "TX", "MAINE": "ME"} > #table['moa_state_name'] =3D map(lambda x: x.upper(), table['moa_state_na= me'])def convert_state(row): abbrev1 =3D state_to_code(table['moa_state= _name']) #'aatest' if abbrev1: return abbrev1 ##state_to_code[ab= brev[0]] return 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'] > -- > https://mail.python.org/mailman/listinfo/python-list --=20 Joel Goldstick http://joelgoldstick.com/blog http://cc-baseballstats.info/stats/birthdays