如何使用Pandasql进行过滤

Question

下面的查询将根据where条件选择行；

top4_hr_visits = pysqldf("SELECT room_name, hour, COUNT(DISTINCT user) AS user_cnt FROM user_data       
                     WHERE room_name ='Emilio's Room' OR room_name= 'Azalea's Room'
                     GROUP BY room_name, hour;")

但是，我正在收到以下错误；OperationalError: near "s": syntax error是否有适当的方法来避免它？我们很感激你的帮助。

Answer 1

单引号是通过加倍来转义的，就像您在示例中通过添加另一个单引号来替换单引号一样

"SELECT room_name, hour, COUNT(DISTINCT user) AS user_cnt FROM user_data       
                     WHERE room_name ='Emilio''s Room' OR room_name= 'Azalea''s Room'
                     GROUP BY room_name, hour;"