yhat/pandasql issues and pull requests

#112 - Update README.md

Pull Request - State: open - Opened by WhiteSymmetry 3 months ago

#111 - first commit

Pull Request - State: closed - Opened by dasarpai 7 months ago - 1 comment

#110 - Postgresql example

Pull Request - State: open - Opened by BuiHoangTu 10 months ago

#109 - fix SQLAlchemy doesn't accept raw str anymore

Pull Request - State: open - Opened by BuiHoangTu 10 months ago - 2 comments

#108 - Select statement gives "no such table: " even though it is present. Workaround is if we add the table name as a comment in the sql.

Issue - State: open - Opened by abhilash1jose over 1 year ago

#107 - Is this still being maintained?

Issue - State: open - Opened by drkleena almost 2 years ago - 5 comments

#106 - Update README.md to correct a small typo

Pull Request - State: closed - Opened by paultimothymooney almost 2 years ago

#105 - [Ignore]

Pull Request - State: closed - Opened by hrshdhgd almost 2 years ago

#104 - SQLAlchemy v2.x compliant.

Pull Request - State: closed - Opened by hrshdhgd almost 2 years ago

#103 - sqldf does not work

Issue - State: open - Opened by psads-git almost 2 years ago - 3 comments

#102 - 'str' object has no attribute '_execute_on_connection'

Issue - State: open - Opened by posidonius about 2 years ago - 8 comments

#101 - Update setup.py

Pull Request - State: open - Opened by Jtramey about 2 years ago

#100 - Fixed version of SqlAlchemy

Pull Request - State: open - Opened by minikill about 2 years ago

#99 - sqldf stopped working with sqlalchemy 2.0.0

Issue - State: open - Opened by Simgiov about 2 years ago - 5 comments

#98 - Tests workflow

Pull Request - State: closed - Opened by yrom1 over 2 years ago

#97 - Error in Reading External .SQL File

Issue - State: open - Opened by matthewfarant over 2 years ago - 1 comment

#96 - doesn't work in Flask

Issue - State: open - Opened by mpourvali almost 3 years ago - 1 comment

#95 - How to calculate statistics such as median with pandsql?

Issue - State: closed - Opened by alpha0067 almost 3 years ago

#94 - Bool columns are returned as integer

Issue - State: open - Opened by julioevi almost 3 years ago

#93 - More descriptive exceptions?

Issue - State: open - Opened by jmtekin about 3 years ago

#92 - Vertical output for result.

Issue - State: open - Opened by olegans1972 about 3 years ago

#91 - Right Join not available like merge command has

Issue - State: open - Opened by muhammadumerjaved44 over 3 years ago

#90 - documentation

Issue - State: open - Opened by JDface almost 4 years ago

#89 - Typo in README.md

Issue - State: open - Opened by AvonleaFisher almost 4 years ago

#88 - How to CONCAT two columns in pandsql like CONCAT(col1, ' ', col2)

Issue - State: closed - Opened by sundarcse1216 about 4 years ago - 1 comment

#87 - matching on datetime needs to be more robust

Issue - State: open - Opened by rugg2 over 4 years ago

#86 - LEFT JOIN WHERE column_name IS NULL is not evaluating correctly

Issue - State: open - Opened by tabs-or-spaces over 4 years ago

#85 - Added the DELETE and UPDATE clause support

Pull Request - State: open - Opened by TheGlobalist over 4 years ago - 3 comments

#84 - fix typo

Pull Request - State: closed - Opened by mohan3d over 4 years ago - 1 comment

#83 - update gives no such table error

Issue - State: open - Opened by SteveScott over 4 years ago - 2 comments

#82 - use DuckDB instead sqlite

Issue - State: open - Opened by seufagner over 4 years ago - 3 comments

#81 - Straightforward way to enable loading extensions?

Issue - State: open - Opened by tomviolin almost 5 years ago

#80 - sqldf does not support large data sets

Issue - State: open - Opened by dqaudithillstone about 5 years ago - 1 comment

#79 - pandasql (sqlite3.OperationalError) too many columns on df

Issue - State: open - Opened by Ahrli over 5 years ago - 1 comment

#78 - Standard Deviation function is not working

Issue - State: open - Opened by SivaramKanagaraj over 5 years ago - 2 comments

#77 - window Function - Row_Number not working

Issue - State: closed - Opened by saketdabi1385 over 5 years ago - 17 comments

#76 - Getting error with sql include group_concat

Issue - State: open - Opened by khorshidisamira over 5 years ago

#75 - Allow queries with parameters to avoid SQL injection

Pull Request - State: open - Opened by kljh almost 6 years ago - 1 comment

#74 - Cannot handle quotes around table name

Issue - State: open - Opened by isthisthat almost 6 years ago - 1 comment

#73 - Support of 'where exists' operations

Issue - State: open - Opened by MartinPetrov8 about 6 years ago - 1 comment

#72 - Operational Error: Too many SQL Variables

Issue - State: open - Opened by larun1616 about 6 years ago - 1 comment

#71 - Tiny typo

Pull Request - State: open - Opened by craigsdennis about 6 years ago

#70 - Minor typo correction

Pull Request - State: open - Opened by mbasilyan over 6 years ago

#69 - Updated the mistake in Readme.md file

Pull Request - State: open - Opened by VivekWisdom over 6 years ago

#68 - Support for dictionary of dataframes

Issue - State: open - Opened by juancresc over 6 years ago - 1 comment

#67 - support of math functions?

Issue - State: open - Opened by SamanthaChen over 6 years ago - 6 comments

#66 - dask.dataframe support?

Issue - State: open - Opened by tkmktime over 6 years ago - 2 comments

#65 - selecting on large dataframes

Issue - State: open - Opened by dfolch over 6 years ago - 3 comments

#64 - Left Join functioning same as Inner Join

Issue - State: open - Opened by chelsbells almost 7 years ago - 1 comment

#63 - Support for this project

Issue - State: open - Opened by javadba about 7 years ago - 6 comments

#62 - How to set text_factory to handle non ascii byte codes

Issue - State: open - Opened by javadba over 7 years ago - 1 comment

#61 - "Where" in query doesn't work in pandasql

Issue - State: open - Opened by mushtaque87 over 7 years ago - 1 comment

#60 - pandasql test failures

Issue - State: open - Opened by ajaygtm71 almost 8 years ago

#59 - New Feature Request: support Redshift syntax

Issue - State: open - Opened by dancaspi almost 8 years ago

#58 - Add a user defined regexp function when initialising sqlite connection

Pull Request - State: open - Opened by andreaslang about 8 years ago - 1 comment

#57 - Updated metadata in Setup.py

Pull Request - State: closed - Opened by baderbuddy about 8 years ago

#56 - New Feature: include HDFrame in SQL

Issue - State: open - Opened by arita37 about 8 years ago

#55 - Changes to READMEs

Pull Request - State: closed - Opened by braunmagrin over 8 years ago

#54 - insert into or update

Issue - State: open - Opened by qiweijia over 8 years ago

#53 - PandaSQL won't run inside main()

Issue - State: closed - Opened by j0ma over 8 years ago - 15 comments

#52 - Fix the Unicode issue for all connection code paths

Pull Request - State: closed - Opened by allenpc over 8 years ago

#51 - `get_outer_frame_variables()` fails in Jupyter Notebook

Issue - State: open - Opened by haobibo over 8 years ago - 1 comment

#50 - LEFT OUTER JOIN resolves to LEFT JOIN

Issue - State: closed - Opened by dreyco676 almost 9 years ago - 2 comments

#49 - avoid utf8 error

Pull Request - State: closed - Opened by shantanuo almost 9 years ago

#48 - Installation throws a PermissionError on Windows

Issue - State: closed - Opened by aburnettnf almost 9 years ago - 2 comments

#47 - data frames being written every time?

Issue - State: open - Opened by dmenin almost 9 years ago

#46 - SELECT FROM multiple tables

Issue - State: open - Opened by toqduj about 9 years ago - 5 comments

#45 - Multiple backends, better interface and others

Pull Request - State: closed - Opened by aplavin about 9 years ago - 3 comments

#44 - add acceptable format of table data

Pull Request - State: closed - Opened by airtoxin over 9 years ago

#43 - space apparently possible ?

Pull Request - State: closed - Opened by stonebig over 9 years ago

#42 - pandasql does not work in a function

Issue - State: closed - Opened by cardosan over 9 years ago - 9 comments

#41 - Request: use of params to prevent SQL-injection

Issue - State: open - Opened by r2evans over 9 years ago

#40 - Support for multiple backends

Issue - State: open - Opened by gmodena over 9 years ago

#39 - Bug in the extract table names function.

Issue - State: closed - Opened by MSDarshan91 over 9 years ago

#38 - error with large panda dataframe

Issue - State: open - Opened by praveen766 over 9 years ago - 6 comments

#37 - Ubuntu 14.04

Issue - State: open - Opened by mendiguren almost 10 years ago

#36 - exception treatment changed

Pull Request - State: closed - Opened by xmnlab over 10 years ago - 3 comments

#35 - except Exception, e:

Issue - State: closed - Opened by xmnlab over 10 years ago - 3 comments

#34 - use to_sql instead of deprecated write_frame

Issue - State: closed - Opened by lminer over 10 years ago - 1 comment

#33 - sqldf returning None if SELECT clause is not *

Issue - State: closed - Opened by RAvdek over 10 years ago - 3 comments

#32 - Handling exceptions in Python 3

Issue - State: closed - Opened by psychemedia over 10 years ago - 2 comments

#31 - Error querying dataframes with a DatetimeIndex

Issue - State: closed - Opened by kianho over 10 years ago - 1 comment

#30 - Example code does not work...

Issue - State: closed - Opened by ghost over 10 years ago - 2 comments

#29 - SELECT from WHERE ... IN ( SELECT ..) doesn't work?

Issue - State: closed - Opened by psychemedia over 10 years ago - 2 comments

#28 - SELECT * returns a dataframe with an explicit Index column?

Issue - State: closed - Opened by psychemedia over 10 years ago - 3 comments

#27 - SELECT * returns a dataframe with an explicit Index column?

Issue - State: closed - Opened by psychemedia over 10 years ago - 1 comment

#26 - Getting error with demo code.

Issue - State: closed - Opened by Tooblippe over 10 years ago - 1 comment

#25 - Bascis dyslexia fix

Pull Request - State: closed - Opened by brentpayne over 10 years ago - 1 comment

#24 - Nested SELECT doesn't work?

Issue - State: closed - Opened by psychemedia over 10 years ago - 8 comments

#23 - DataFrame column names that aren't valid SQLite3 column names?

Issue - State: open - Opened by psychemedia over 10 years ago - 9 comments

#22 - pip install error

Issue - State: closed - Opened by psychemedia almost 11 years ago - 1 comment

#21 - Error with Pandasql Using Anaconda on OSX

Issue - State: open - Opened by craigsakuma almost 11 years ago - 1 comment

#20 - Update demo.py with change from pd.Factor to pd.Categorical

Pull Request - State: closed - Opened by tomaskazemekas almost 11 years ago - 1 comment

#19 - API: pandas 0.14 will have some sql API changes

Issue - State: closed - Opened by jreback almost 11 years ago - 2 comments

#18 - Issues importing pandasql - Python 3.3 in Windows 7

Issue - State: closed - Opened by kevinwsl almost 11 years ago - 2 comments

#15 - preserve_sqlite_parameters

Pull Request - State: closed - Opened by stonebig over 11 years ago - 2 comments

#12 - working with dictionaries

Pull Request - State: closed - Opened by stonebig over 11 years ago

#11 - make tests compatible with python3

Pull Request - State: closed - Opened by stonebig over 11 years ago - 2 comments

#10 - ENH: sqldf works also with lists, tuple, dictionaries

Pull Request - State: closed - Opened by stonebig over 11 years ago - 1 comment

#9 - Working with list version 02 rebased

Pull Request - State: closed - Opened by stonebig over 11 years ago - 3 comments

GitHub / yhat/pandasql issues and pull requests