摘要：import calendar,datetimenow = datetime.datetime.now()year = now.yearmonth = now.monthweekday,monthRange = calendar.monthrange(year,month)# 获取当月第一天firs 阅读全文

摘要：select * from table where name in (select name from table2) 等效于 select * from table where exists (select name from table2) 后者查询速度更快 clock_timestamp() 阅读全文

摘要：cols = [c for c in df.columns if c[:7] != 'Unnamed'] df2 = df[cols] 阅读全文