pandasql

Query library

A Python library that allows users to query pandas DataFrames using SQL syntax.

sqldf for pandas

GitHub

1k stars
49 watching
185 forks
Language: Python
last commit: 4 months ago
Linked from 1 awesome list


Backlinks from these awesome lists:

Related projects:

Repository Description Stars
nickelkr/yfi A library providing a Python interface to query Yahoo!'s YQL datatables 2
web2py/pydal A pure Python Database Abstraction Layer that generates SQL/noSQL in real-time for different databases. 498
paul-wolf/djaq A query language and API that provides an alternative to Django's ORM 76
googleapis/python-bigquery-pandas Provides an interface to Google BigQuery from pandas data structures 448
jaimegildesagredo/booby A Python library for defining and validating data structures with built-in support for complex data models and relationships. 177
davidastephens/pandas-finance A Python library providing an interface to financial data and analysis tools. 152
qqtop/nimdataframe A data manipulation and display library for Nim programming language 15
wq/django-rest-pandas An API that serves pandas DataFrames via Django REST Framework for data visualization and offline analysis. 1,254
graphql-python/graphql-core A Python implementation of GraphQL's query language and API framework 512
yathit/ydn-db A JavaScript module providing a unified data access layer for IndexedDB, WebDatabase, and WebStorage storage mechanisms. 503
fazibear/defql A library providing a simple, high-level interface to interact with SQL databases using Elixir functions as the query language. 103
pymssql/pymssql A Python interface to Microsoft SQL Server 840
youshido-php/graphql A PHP implementation of the GraphQL protocol for building query languages in APIs 710
asherber/petapoco.sqlkata A set of extension methods for using SqlKata with PetaPoco, allowing more flexible and powerful querying capabilities 27
eitsupi/querying-with-prql A book and project demonstrating the use of PRQL with data manipulation libraries like dplyr and DuckDB for querying table data. 22