daily stock to weekly stock values

SO_34598339.ipynb

Beautiful !! thanks.

this is fantastic and has helped me move along, thanks.
It gives a warning:

Warning (from warnings module):line 79
loffset=pandas.offsets.timedelta(days=-6)) # to put the labels to Monday
FutureWarning: how in .resample() is deprecated
the new syntax is .resample(...)..apply()

I am not skilled enough to rewrite it into the new syntax, anyone up to the task?
thanks in advance!

I can't comment on original stackoverflow post but I have two questions for this:

1. Why using custom handlers for taking the first and last value, when pandas has 'first' and 'last' aggregators
2. What's the purpose of the last line of code
   output = output[['Open', 'High', 'Low', 'Close', 'Volume']]
   Isn't output the same before and after this line? This is only for ordering the columns?

@aristid73, you can use agg() function, simply:

output = df.resample('W')                                 # Weekly resample
                    .agg({'Open': take_first, 
                          'High': 'max',
                          'Low': 'min',
                          'Close': take_last,
                          'Volume': 'sum'}) 
output.index = output.index + pd.DateOffset(days=-6  # to put the labels to Monday

Thanks all of you:
the final code that worked for me after reading all of those comments and some other:

`import pandas as pd
import pandas_datareader as web
import datetime

ticker = "MMM"
start = datetime.datetime(2018, 2, 5)
end = datetime.datetime(2018, 2, 25)

f = web.DataReader(ticker, 'yahoo', start, end)
f.index = pd.to_datetime(f.index)

def take_first(array_like):
return array_like[0]

def take_last(array_like):
return array_like[-1]
output = f.resample('W').agg({'Open': take_first,
'High': 'max',
'Low': 'min',
'Close': take_last,
'Adj Close': take_last,
'Volume': 'sum'}) # to put the labels to Monday

output = output[['Open', 'High', 'Low', 'Close','Adj Close', 'Volume']]
output.index = output.index + pd.DateOffset(days=-6)
print (output)`

Now (pandas 1.0.5) we don't even need to define the take_first and take_last functions. 'first' and 'last' would work fine.

output = df.resample('W')                                 # Weekly resample
                    .agg({'Open': 'first', 
                          'High': 'max',
                          'Low': 'min',
                          'Close': 'last',
                          'Volume': 'sum'}) 
output.index = output.index + pd.DateOffset(days=-6)  # to put the labels to Monday