Path: csiph.com!fu-berlin.de!uni-berlin.de!not-for-mail
From: Shawn Brown <03sjbrown@gmail.com>
Newsgroups: comp.lang.python.announce
Subject: [ANN] Squint: Simple query interface for tabular data.
Date: Sat, 11 Jan 2020 15:03:28 -0500
Lines: 83
Approved: python-announce-list@python.org
Message-ID: <157878285175.21108.python-announce-list@python.org>
References: <CA+a2dP-4980y3YdcnDv4r8Ls2Mz1_jG2zpPLnbwv0j0mmSrENg@mail.gmail.com>
Reply-To: python-list@python.org
Mime-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
In-Reply-To:  <CA+a2dP-4980y3YdcnDv4r8Ls2Mz1_jG2zpPLnbwv0j0mmSrENg@mail.gmail.com>
Message-ID-Hash: KWHN7MMULIMZ37DNSRZ2ONM5LHJM3B32
Precedence: list
Archived-At:  <https://mail.python.org/archives/list/python-announce-list@python.org/message/KWHN7MMULIMZ37DNSRZ2ONM5LHJM3B32/>
Xref: csiph.com comp.lang.python.announce:3299

[RESEND WITH CORRECTED LINK]


Squint version 0.1.0 has been released:


* New query previews provide convenient feedback at the interactive prompt.

* Completely rewritten tutorial
https://squint.readthedocs.io/en/stable/tutorial/
<https://squint.readthedocs.io/tutorial/>

* Added support for Python 3.9 and dropped support for 3.3, 3.2, and 2.6.



What is Squint:


Squint is a simple query interface for tabular data. A core feature of
Squint is that the structure of a query's selection determines the
structure of its result.



Squint is available from the PyPI:


    pip install squint



With Squint You Can:


* Select data using Python literals=E2=80=94sets, lists, dictionaries, etc.=
=E2=80=94and
fetch results in the same format.

* Aggregate, map, filter, reduce, and otherwise manipulate data.

* Lazily iterate over results, write them to a file, or eagerly evaluate
them in memory.

* Analyze data from CSV, Excel, SQL, and other data sources.


Links:


* Docs: https://squint.readthedocs.io/

* PyPI: https://pypi.org/project/squint/

* Source: https://github.com/shawnbrown/squint



Syntax Comparison:


    # SQL

    SELECT A, SUM(B) FROM mydata WHERE C=3D'xyz' GROUP BY A;



    # Pandas

    df[['A', 'B']][df['C'] =3D=3D 'xyz'].groupby('A').sum()



    # Squint

select({'A': 'B'}, C=3D'xyz').sum()


Note: Squint uses `dict` objects to select groups of values=E2=80=94the *ke=
y*
determines the field to group by, and the *value* determines the contents
of each group. Fetching the results of such a query returns a dictionary of
selected elements.