Find more Data Mining And Management Remote Jobs posted recently Worldwide

Required Excel VBA,Python,Python Numpy freelancer for Python Excel Data Manipulation, Concatenation and Analysis job

Posted at - Sep 24, 2023

I need a Python aplication that could read some xml/excel files, identify the right row in that files to start and finish to working on data (theres one defined group of rows that interest to my analisys), after that it need to create one new sheet on the same workbook with this group of informations, after that, it need change the first columms of data that has a date concatenated with hour (need to split it in two columms, one with the date other with the hour), and than save this file. This program have to be abble to do this job on all workbooks on the directory that its in. After it did this changes, the software need to create one new file concatenating the date/hour/and a specif value on one of the collumns of all files, this news file have to has the first columm with the date, the second, with the hours, and the others colums with the title of name of the file that has originated the information and their respected value, and than, on the columms of other files that dont have a value for that specif date or hour, that other have a value, it could put a '0' on the cell. After this data base construction, i want one program to run a Markowitz analysis on this data, returning what the better weight of each strategy (origin file) on the portfolio.
The project coul be composed of 3 programs:
1) Program 1: read the xml/excel origin workbooks and adapt/split the date-hour collumn;
2) Program 2: concatenate all of the specific result-value of each workbook on one spreadsheet with all dates/hours of each results, separate on collumns of each base workbook;
3)Program 3: Run the markowitz portfolio analysis.

About the recuiterMember since May 20, 2018 Sona Dubey
from Connecticut, United States

Skills & Expertise Required

Excel VBA Python Python Numpy 

Open for hiringApply before - Sep 23, 2024

Work from Anywhere
40 hrs / week
Fixed Type
Remote Job

Offer to work on this project closes in 203 days!
Are you interested in this Opportunity?

Apply Now

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Apply on more work from home jobs posted in Data Mining And Management category.

Related Jobs

Latest In Excel VBA Jobs

Latest In Python Jobs

Latest In Python Numpy Jobs