Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.freenet.ag!news2.euro.net!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.002 X-Spam-Evidence: '*H*': 1.00; '*S*': 0.00; 'subject:two': 0.07; 'delimited': 0.09; 'subject:files': 0.09; 'to:addr:comp.lang.python': 0.09; 'cc:addr:python-list': 0.10; 'subject:Help': 0.10; 'concat': 0.16; 'from:addr:miki.tebeka': 0.16; 'from:name:miki tebeka': 0.16; 'subject:joining': 0.16; 'url:html)': 0.16; 'wrote:': 0.17; 'url:dev': 0.17; 'appears': 0.18; 'pipe': 0.22; 'wednesday,': 0.22; 'cc:2**0': 0.23; 'cc:addr:python.org': 0.25; 'header:In-Reply-To:1': 0.25; 'header :User-Agent:1': 0.26; 'received:209.85.212': 0.28; 'daniel': 0.30; 'december': 0.32; 'received:google.com': 0.34; 'received:209.85': 0.35; 'there': 0.35; 'url:org': 0.36; 'subject:" ': 0.36; 'method': 0.36; 'subject:with': 0.36; 'two': 0.37; 'received:209': 0.37; 'subject:: ': 0.38; 'files': 0.38; 'charset:windows-1252': 0.65 Newsgroups: comp.lang.python Date: Wed, 5 Dec 2012 10:17:27 -0800 (PST) In-Reply-To: Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=75.82.8.111; posting-account=uo-8fwoAAACKsFzFX78JHudx1V7WDXZ0 References: User-Agent: G2/1.0 X-Google-Web-Client: true X-Google-IP: 75.82.8.111 MIME-Version: 1.0 Subject: Re: Help "joining" two files delimited with pipe character ("|") From: Miki Tebeka To: comp.lang.python@googlegroups.com Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Cc: "python-list@python.org" X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.15 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Message-ID: Lines: 5 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1354731456 news.xs4all.nl 6884 [2001:888:2000:d::a6]:59036 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:34306 On Wednesday, December 5, 2012 9:57:31 AM UTC-8, Daniel Doo wrote: > I am new to Python.=A0 Is there a method to =93join=94 two pipe delimited= files using a unique key that appears in both files?=A0 Have a look at Panda's concat (http://pandas.pydata.org/pandas-docs/dev/mer= ging.html). It also have utilities to read delimited files into DataFrame.