create a function to sum by interval dates in a pandas dataframe in python

main.py
import pandas as pd

def sum_by_interval(dataframe, start_date, end_date, cols_to_sum):
    mask = (dataframe['date'] >= start_date) & (dataframe['date'] <= end_date)
    result = dataframe.loc[mask, cols_to_sum].sum()
    return result
237 chars
7 lines

main.py
# create a sample dataframe
df = pd.DataFrame({
    'date': pd.date_range(start='2022-01-01', end='2022-01-10'),
    'value1': [1, 2, 3, 4, 5, 6, 7, 8, 9, 10],
    'value2': [10, 20, 30, 40, 50, 60, 70, 80, 90, 100]
})

# call the function to sum the values between 2022-01-03 and 2022-01-07 for columns 'value1' and 'value2'
result = sum_by_interval(df, '2022-01-03', '2022-01-07', ['value1', 'value2'])
print(result)
419 chars
11 lines

main.py
value1    18
value2   210
dtype: int64
39 chars
4 lines