how to get the output of this SQL query in python language

Question

SELECT * FROM Sales where SKUDESC='samsung' AND Full_month='January'

i want output which this query gives but in python code

i am trying to groupby and i am getting name of groups .how to get values like it gives in SQL query

field=['product', 'month']
grouped=df.groupby(field).groups

There is no groupby in your sql query, why would you use groupby in youpython code? — Robin Nicole
– Robin Nicole, Commented Aug 1, 2019 at 7:46
i dont want to groupby i was trying groupby function to get same output as the query but its not working new_df = df.loc[(df.SKUDESC == 'samsung') & (df.Full_month == 'January')] this is working — mayank chauhan
– mayank chauhan, Commented Aug 1, 2019 at 8:38

Ankur Sinha · Accepted Answer · 2019-08-01 07:46:55Z

1

SQL:

SELECT * FROM Sales where SKUDESC='samsung' AND Full_month='January'

Python:

new_df = df.loc[(df.SKUDESC == 'samsung') & (df.Full_month == 'January')]

answered Aug 1, 2019 at 7:46

Ankur Sinha

6,6648 gold badges44 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

mayank chauhan Over a year ago

thanks it works .now i am trying to pass the variable in which samsung and january are stored i did this for sql query and it wored query="SELECT * FROM"+" "+ tablename+" "+ "where"+" " + field[0]+"="+"'"+values[0]+"'" +" "+ "AND" + " " +field[1]+"="+ "'"+values[1] query=query+ "'" print(query) but when i am doing it in this code its not working i want to pass the variable new_dfq = "(df."+field[0]+" == "+"'"+values[0]+"'"+ ") & (df." + field[1]+ " =="+"'"+ values[1]+"'"+")" print(new_dfq)

Ankur Sinha Over a year ago

Sorry, but it is unclear and difficult to comprehend. Perhaps you can post another question in a clear manner so that someone can help you.

Ankur Sinha Over a year ago

Also, if I understand you are trying to dynamically get the column name, I guess it should be something like df[(field[0]] == values[0]) & (field[1]] == values[1])]. Please try it.

mayank chauhan Over a year ago

okay forget it, the simple queston is that can i pass the variable in this df.loc function in which samsung and january are stored. i am trying but its not working

mayank chauhan Over a year ago

yes i am trying to dynamically get the column name and this is not working some key error

|

LOrD_ARaGOrN · Accepted Answer · 2019-08-01 07:41:04Z

0

You can import the output of query in python dataframe like below.

df_data = pd.DataFrame(query ,columns=[‘col_1’, ‘col_2’])

answered Aug 1, 2019 at 7:41

LOrD_ARaGOrN

4,6166 gold badges39 silver badges59 bronze badges

Collectives™ on Stack Overflow

how to get the output of this SQL query in python language

2 Answers 2

7 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related