I effectively have two tasks that I need completed:
Quasi-replication of Excel's MATCH() and OFFSET() functions in Python/pandas.
An example of what I want to replicate is in the Excel sheet attached, as well as in the picture attached. Note that both of these function need to look forward in the dataframe, as opposed to backwards, as in pandas .rolling() functionality.
The solution does not have to be a function, but it does have to be robust (i.e. operational over 1,000,000 rows), accurate, and preserve the original dataframe.
To be clear, the only functionality I need is for the columns highlighted - in other words, Columns D and E are unnecessary and extraneous, and I don't wish to have them in the final Python script, unless they are necessary.
Recreation of pandas now-deprecated rolling() regression functionality for multivariate linear regressions.
I believe this has been deprecated, but it appears still listed in the pandas documentation. If it is still functional, this task should be easy, I just need to see how to use it. Otherwise, I have a sample available for the script I need.
The function will need to produce all of the descriptive statistics included in statsmodels.py.
I would like to have both of these tasks completed as a single job. For completion of the combination of these two jobs, I'm going to post a fixed price of $80. If you have interest at that price, or at another price point, please let me know,
12 freelancer đang chào giá trung bình $53 cho công việc này
Dear Sir, I have gone through project description and interested taking it up. Posted bid amount is indicative and a more accurate I can give once more details are shared. Looking forward to hear from you. Thanks
Python tasks - Excel function recreation, and recreation of deprecated pandas .rolling() regression Certified python scripter to ammend this function looking forward to hear from you thanks Uzair
Python tasks - Excel function recreation, and recreation of deprecated pandas .rolling() regression I have done this FIX BEFORE. yoU CAN CONTACT ME FOR THAT. tANKS