I need to define a function that will perform several operations on a dataframe containing a DatetimeIndex. One of these operations is to slice the dataframe based on a period or date passed as one of the function arguments.
When using loc within a code, the slice objects accept different options. For instance:
df.loc['2004']
to slice all rows with dates in 2004
df.loc['2004-01':'2005-02']
to slice all rows with dates between Jan 2004 and Feb 2005
I would like to be able to use only one argument of the function to construct the slice object that goes inside loc[]. Something like:
df.loc[period]
Where period is the variable passed to the function as one of the arguments, and that can be defined in different formats to be correctly interpreted by the function.
I've tried:
Passing a string variable to loc, for instance with a value constructed as "\'2004\'"+':'+"\'2005\'", but it returns a KeyError "'2002':'2010'".
Converting a string to datetime objects using pd.to_datetime. But this results in "2004" converted to Timestamp('2004-01-01 00:00:00')
I've found this answer and this answer to be similar, but not specific to what I need.
I could use two arguments in the function to solve this (something like start_date, end_date) but was wondering if there is anyway to achieve it with only one.
The slice built-in should work for this:
# equivalent to df.loc['2004':]
period = slice('2004', None)
df.loc[period]
# equivalent to df.loc['2004-01':'2005-02']
period = slice('2004-01', '2005-02')
df.loc[period]