search

yhat / pandasql

sqldf for pandas
MIT License
1.31k stars 184 forks source link

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

Closed sundarcse1216 closed 3 years ago

sundarcse1216 commented 3 years ago

I want to concat two columns in dataframe.

sundarcse1216 commented 3 years ago

Found solution.

query = """SELECT FirstName || ' ' || Team As Worker_Name FROM df"""
print(ps.sqldf(query))