Suljettu

Python tasks - Excel function recreation, and recreation of deprecated pandas .rolling() regression.

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

Taidot: Excel, Python, Tilastotiede

Näytä lisää: excel function open url, excel function price, excel function call, excel function morgage payment, lotto excel function, excel function creator, excel function maker, ord excel function, report excel function oracle apps, java call excel function, excel function extract numbers phone numbers, cut paste vba excel function, excel function list, implement financial excel function rate, excel function pictures, php excel function traditional chinese, excel function style, stock valuation excel function, historical stock prices yahoo finance excel function, paste excel function vba

Tietoa työnantajasta:
( 0 arvostelua ) United Kingdom

Projektin tunnus: #17557420

14 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

$25 USD 1 päivässä
(60 arvostelua)
5.7
$100 USD 1 päivässä
(24 arvostelua)
4.9
Techiedev

I have good experiences developing code in Python Programming language for web scraping , data science and Machine learning projects. I've worked with Pandas library in data science projects since 2 years ago. I think Lisää

$25 USD 1 päivässä
(9 arvostelua)
3.6
$77 USD 1 päivässä
(1 arvostelu)
2.4
itsparx

Hi, Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have got Rich experience in Jooml Lisää

$21 USD 7 päivässä
(0 arvostelua)
0.0
numberten1992

Hello i have vast knowledge on the topic which can help me get the work done perfectly and on time. i am looking forward to working with you. Evans Regards

$25 USD 1 päivässä
(0 arvostelua)
0.0
$25 USD 1 päivässä
(0 arvostelua)
0.0
Jainsuvigya

Hi, I am a certified Python Programmer with full time client Facing role as a Data Scientist. I have 3+ years of experience in Python focused in Data Science and use Pandas on a regular basis. Relevant Skills and Exp Lisää

$30 USD 2 päivässä
(0 arvostelua)
0.0
$15 USD 3 päivässä
(0 arvostelua)
0.0
techbluesoft6

"Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on si Lisää

$25 USD 1 päivässä
(0 arvostelua)
0.0
$30 USD 2 päivässä
(0 arvostelua)
0.0
$55 USD 5 päivässä
(0 arvostelua)
0.0
htudu

I can get it done!

$77 USD 1 päivässä
(1 arvostelu)
0.0
nungerle

I am a postdoctoral fellow involved in data science and have lots of experience with tasks like this. I know how to do what you are asking - we handle dataframes and xls files all the time. Relevant Skills and Experie Lisää

$80 USD 3 päivässä
(0 arvostelua)
0.0