如何转换此 SQL 代码:
SELECT
COUNT(DISTINCT DATEn) as count (*)
FROM weather_data
WHERE cast (rain as integer) = 1
使用 Pandas 表示法,像这样:df.groupby ('rain') DATEn.sum ()
请您参考如下方法:
IIUC:
df.loc[pd.to_numeric(df['rain'], errors='coerce') == 1, 'DATEn'].nunique()
