Re: Help "joining" two files delimited with pipe character ("|")

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	<miki.tebeka@gmail.com>
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	<mailman.512.1354730874.29569.python-list@python.org>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=75.82.8.111; posting-account=uo-8fwoAAACKsFzFX78JHudx1V7WDXZ0
References	<mailman.512.1354730874.29569.python-list@python.org>
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 <miki.tebeka@gmail.com>
To	comp.lang.python@googlegroups.com
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	quoted-printable
Cc	"python-list@python.org" <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 <python-list.python.org>
List-Unsubscribe	<http://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	<http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Message-ID	<mailman.513.1354731456.29569.python-list@python.org> (permalink)
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

Show key headers only | View raw

On Wednesday, December 5, 2012 9:57:31 AM UTC-8, Daniel Doo wrote:
> I am new to Python.  Is there a method to “join” two pipe delimited files using a unique key that appears in both files? 
Have a look at Panda's concat (http://pandas.pydata.org/pandas-docs/dev/merging.html). It also have utilities to read delimited files into DataFrame.

Back to comp.lang.python | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Help "joining" two files delimited with pipe character ("|") Daniel Doo <dd@topekacapitalmarkets.com> - 2012-12-05 11:57 -0600
  Re: Help "joining" two files delimited with pipe character ("|") Miki Tebeka <miki.tebeka@gmail.com> - 2012-12-05 10:17 -0800
  Re: Help "joining" two files delimited with pipe character ("|") Miki Tebeka <miki.tebeka@gmail.com> - 2012-12-05 10:17 -0800

csiph-web