Top "Pandasql" questions

Python Pandas to_sql, how to create a table with a primary key?

I would like to create a MySQL table with Pandas' to_sql function which has a primary key (it is …

python mysql pandas primary-key pandasql

Group by without an aggregate function

I've seen a pandasql query like this: df = pd.DataFrame({'A': [1, 2, 2], 'B': [3, 4, 5]}) sqldf('select * from df group by A', locals()) …

python pandas pandasql

Pandas merge on two columns using date and another column

Hello trying to merge two data frames and sum visit counts by date and upc. Transaction data (date,upc,sales) 200…

python pandas pandasql

Convert pandas columns to comma separated lists to be used in sql statements

I have a dataframe and I am trying to turn the column into a comma separated list. The end goal …

csv pandas dataframe pandasql

Print value from a list (The truth value of a DataFrame is ambiguous error)

Having a question. I am having a list of records and there is another list of records which i am …

python pandas pandasql

Pandas Merge two rows into a single row based on columns

I have 2 rows that look like these, ------------------------------ DealName | Target | Acquirer | ----------------------------- ABC-XYZ | ABC | None | ------------------------------ ABC-XYZ | None | XYZ | ------------------------------ …

python python-2.7 pandas pandas-groupby pandasql

Merging DataFrames on multiple conditions - not specifically on equal values

Firstly, sorry if this is a bit lengthy, but I wanted to fully describe what I have having problems with …

python pandas merge pandasql

Convert unique numbers to md5 hash using pandas

Good morning, All. I want to convert my social security numbers to a md5 hash hex number. The outcome should …

python python-2.7 pandas hashlib pandasql