Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.python > #107951
| 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 | Sun, 1 May 2016 18:27:39 +0000 (UTC) |
| Lines | 14 |
| Message-ID | <mailman.290.1462127444.32212.python-list@python.org> (permalink) |
| References | <919174787.8635501.1462127259949.JavaMail.yahoo.ref@mail.yahoo.com> <919174787.8635501.1462127259949.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 11MJwEjMvI8PcXDvDCtxLgHRe3OgUmDtj3aIVfIdsMTg== |
| 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.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 <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 | <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 |
Show key headers only | View raw
Hello, I am back. Thank you very much for your positive response.
I am trying to use Pandas 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.DavidLook up functionstate_to_code = {"VERMONT": "VT", "GEORGIA": "GA", "IOWA": "IA"}#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 — Next in thread | Find similar | Unroll thread
How to fill in abbreviation in one column based on state name in another column? David Shi <davidgshi@yahoo.co.uk> - 2016-05-01 18:27 +0000 Re: How to fill in abbreviation in one column based on state name in another column? Rustom Mody <rustompmody@gmail.com> - 2016-05-01 20:31 -0700
csiph-web