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>
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

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.)