Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > cz.comp.lang.python > #3260

Re: [python] table querying

Path csiph.com!news.redatomik.org!news.uzoreto.com!ecngs!feeder.ecngs.de!81.171.118.62.MISMATCH!peer02.fr7!futter-mich.highwinds-media.com!news.highwinds-media.com!fx29.am4.POSTED!not-for-mail
Received-SPF pass (Address passes the Sender Policy Framework) SPF=MAILFROM; sender=encukou@gmail.com; remoteip=::ffff:74.125.82.52; remotehost=; helo=mail-wm0-f52.google.com; receiver=hugo.zagamma.cz;
DKIM-Signature v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language:content-transfer-encoding; bh=Xoj/PR3HocORY3D7sIN8L+ApN4PaSKfH9UgILW3UtkE=; b=YU2AHtvNpe66jd08aTCf1YzUbw9uKI0ShFSgsMbDzz9OdS5KBj3nVEFI/9xhz1moCm w6pNhFCqKGA0Py4ttEFEZs03zHOZvdcIcpEL6I9EQthIId9I6U11BnMSAxdxVz/XYXq/ Z7Z4udBu3bt0o6bXZGLgpiMT+Qg65HgcdB3m5n9EThaXq+o78LNgAcgGiraMPZjUzyLC 56MxcibR30e109jnraeo+Afq2gvtaMwf85kHA9UEZluF5oRe9FHzLVkDd0OiGafeFlUr cIGw1fmMVubBJPyrNBb6mfYemglCinHQhfj6hohra8J5CRLBm29amH6cgUjHY9e2yt6J 8TvA==
X-Google-DKIM-Signature v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=Xoj/PR3HocORY3D7sIN8L+ApN4PaSKfH9UgILW3UtkE=; b=PavEG8aknpJFCj8tTViAnccLoOKByrDEMAbprPPZ3IXCGExznkBtlfQi5Yv/Kg7ryv COhJbDr8hd+RvqQXtql4Kf5tQEy7aZJbrM0PPl3XAItgF9qf84h5+DjKIVO3D1xXHi3H qvWews/AtWU2ItvmW7IYA70ysp6/C5RHwIlD+LSt3s3m2kxnq8fcmUuRdb6lOMKn4mpw Eu39VSpkUeeBFFNxhL79S2IP5id+kUc3o68V+h9OLDfeqZqvU1kQMN8EF3MmnwKzHZOt cQYcqK02NYt6+zGQs8GIijAItuQYxeuEg3ybUEQENoawiNPVqN2Y54q0cTzy23W9A29j 8bOg==
X-Gm-Message-State AElRT7E8P7nANH4+ArJAIfl3psFZV6ciwMb7QW6YkCLsHa3Bm9cKJYwg O7Ecr+NPTEVQ28G6x7DOMAKP0Q==
X-Google-Smtp-Source AG47ELut/8aPNYaOfkiT4YnpvmDHwhZ4PWWLfIuZTz3jmr3HW1muGUGNeMjmblGQYgBlew5d2Tgb2w==
X-Received by 10.28.14.6 with SMTP id 6mr8968513wmo.2.1520257024666; Mon, 05 Mar 2018 05:37:04 -0800 (PST)
Old-Return-Path <encukou@gmail.com>
From Petr Viktorin <encukou@gmail.com>
User-Agent Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.6.0
MIME-Version 1.0
In-Reply-To <018d61d9-21a9-dcdf-943b-f4e37f4e8ed9@sandbox.cz>
Content-Type text/plain; charset=iso-8859-2; format=flowed
Content-Language en-US
Content-Transfer-Encoding 8bit
Subject Re: [python] table querying
X-BeenThere python@py.cz
X-Mailman-Version 2.1.24
Precedence list
List-Id Konference PyCZ <python.py.cz>
List-Unsubscribe <http://www.py.cz/mailman/options/python>, <mailto:python-request@py.cz?subject=unsubscribe>
List-Archive <http://www.py.cz/pipermail/python/>
List-Post <mailto:python@py.cz>
List-Help <mailto:python-request@py.cz?subject=help>
List-Subscribe <http://www.py.cz/mailman/listinfo/python>, <mailto:python-request@py.cz?subject=subscribe>
Newsgroups cz.comp.lang.python
Message-ID <mailman.9.1520257026.4925.python@py.cz> (permalink)
X-Mailman-Original-Message-ID <65ad0f84-d5e9-df4b-cd6e-230d97634f4c@gmail.com>
X-Mailman-Original-References <018d61d9-21a9-dcdf-943b-f4e37f4e8ed9@sandbox.cz>
References <018d61d9-21a9-dcdf-943b-f4e37f4e8ed9@sandbox.cz> <65ad0f84-d5e9-df4b-cd6e-230d97634f4c@gmail.com>
Lines 20
X-Complaints-To abuse@usenet-news.net
NNTP-Posting-Date Mon, 05 Mar 2018 13:37:06 UTC
Organization usenet-news.net
Date Mon, 5 Mar 2018 14:37:03 +0100
X-Received-Bytes 3995
X-Received-Body-CRC 1045054553
Xref csiph.com cz.comp.lang.python:3260

Show key headers only | View raw


On 03/05/2018 02:31 PM, Vláďa Macek wrote:
> Zdar,
> 
> mějme tabulková data načtená třeba z CSV nebo Google Tabulku. Víte o
> elegantním nástroji (modulu) pro Python implementujícím jednoduchý
> dotazovací jazyk?
> 
> Jako "dej mi všechny řádky, které mají ve sloupci B hodnotu V (příp.
> regexp), ve sloupci C nemají hodnoty V1 ani V2" atd.
> 
> Jde mi o etablovanou věc. Ne něco spíchnutého pro vlastní potřebu a hrdě
> zveřejněného, aby si autor otestoval psaní setup.py. :-)

Pandas umí věci jako:

table = pandas.read_csv('foo.csv')
print(table[(table['B'].str.match(V_regex)) && (table['C'] != V1) && 
(table['C'] != V2)])

(Nevyzkoušeno; jestli tě zradí Google, dej vědět.)

Back to cz.comp.lang.python | Previous | Next | Find similar


Thread

Re: [python] table querying Petr Viktorin <encukou@gmail.com> - 2018-03-05 14:37 +0100

csiph-web