import pandas
import pandasql


def num_rainy_days(filename):
    weather_data = pandas.read_csv(filename)
    q = """
    select count(*)
    from weather_data
    where rain = 1
    group by rain;
    """
    rainy_days = pandasql.sqldf(q.lower(), locals())
    return rainy_days

79e14ecdba7e446e7fd0341a7715c28fb371ffb6
<mask token>

<mask token>


def num_rainy_days(filename):
    weather_data = pandas.read_csv(filename)
    q = """
    select count(*)
    from weather_data
    where rain = 1
    group by rain;
    """
    rainy_days = pandasql.sqldf(q.lower(), locals())
    return rainy_days

import pandas
import pandasql


def num_rainy_days(filename):
    weather_data = pandas.read_csv(filename)
    q = """
    select count(*)
    from weather_data
    where rain = 1
    group by rain;
    """
    rainy_days = pandasql.sqldf(q.lower(), locals())
    return rainy_days
