Executing an SQL query over a pandas dataset

by

This is not what pandas.query is supposed to do. You can look at package pandasql (same like sqldf in R )

import pandas as pd
import pandasql as ps

df = pd.DataFrame([[1234, 'Customer A', '123 Street', np.nan],
               [1234, 'Customer A', np.nan, '333 Street'],
               [1233, 'Customer B', '444 Street', '333 Street'],
              [1233, 'Customer B', '444 Street', '666 Street']], columns=
['ID', 'Customer', 'Billing Address', 'Shipping Address'])

q1 = """SELECT ID FROM df """

print(ps.sqldf(q1, locals()))

     ID
0  1234
1  1234
2  1233
3  1233

Update 2020-07-10

update the pandasql

ps.sqldf("select * from df")

More Related Contents:

  1. HDF5 – concurrency, compression & I/O performance [closed]
  2. How to open and convert sqlite database to pandas dataframe
  3. How can I pivot a dataframe?
  4. GroupBy pandas DataFrame and select most common value
  5. String concatenation of two pandas columns
  6. Reshape wide to long in pandas
  7. How to create a large pandas dataframe from an sql query without running out of memory?
  8. Find column name in pandas that matches an array
  9. How to add hovering annotations to a plot
  10. Sort a pandas dataframe series by month name
  11. Neural Network LSTM input shape from dataframe
  12. pandas get the row-wise minimum value of two or more columns
  13. Diff of two Dataframes
  14. Apply function to pandas DataFrame that can return multiple rows
  15. Write to StringIO object using Pandas Excelwriter?
  16. Auto Increment on Composite Primary Key – Sqlite3 + Python
  17. Scikit Learn OneHotEncoder fit and transform Error: ValueError: X has different shape than during fitting
  18. Pandas – write Multiindex rows with to_csv
  19. Writing a Python Pandas DataFrame to Word document
  20. Select row from a DataFrame based on the type of the object(i.e. str)
  21. Selecting Data between Specific hours in a pandas dataframe
  22. How to annotate a seaborn barplot with the aggregated value
  23. Add numpy array as column to Pandas data frame
  24. Python: How to drop a row whose particular column is empty/NaN?
  25. Discrete legend in seaborn heatmap plot
  26. How to use ast.literal_eval in a pandas dataframe and handle exceptions
  27. Why is NaN considered as a float?
  28. Clean way to convert quarterly periods to datetime in pandas
  29. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  30. Wide to long data transform in pandas

Leave a Comment