Sample data:
import pandas as pd
import numpy as np
import datetimedata = {'value': [1,2,4,3], 'names': ['joe', 'bob', 'joe', 'bob']}
start, end = datetime.datetime(2015, 1, 1), datetime.datetime(2015, 1, 4)
test = pd.DataFrame(data=data, index=pd.DatetimeIndex(start=start, end=end, freq="D"), columns=["value", "names"])
gives:
value names
2015-01-01 1 joe
2015-01-02 2 bob
2015-01-03 4 joe
2015-01-04 3 bob
I want to resample by '2D' and get the max value, something like:
df.resample('2D')
The expected result should be:
value names2015-01-01 2 bob2015-01-03 4 joe
Can anyone help me?