Build a Python Script to Process Data
$100-300 USD
Paid on delivery
I need a python script that will process data from a data element and add extra “columns” to the data.
I have included a csv file that shows the data element I am referring to. This will make it easier to conceptualize what I am describing. The code I used to output the data is the following:
data.to_csv("[login to view URL]", index=False, sep=",", encoding='utf-8')
There are two things I need the python code to be able to do:
Step 1 – Add extra columns to the existing data.
I need the data modified so that it reflects the processed version I did manually in an excel file. I have included this excel file here as an attachment to the project. Its name is: “example [login to view URL]”.
Please note, only columns G, H, and I need to be added to the data. The other columns only exist because I needed them to do the calculations manually in excel.
Step 2 –
Create the variables that are in columns X through AE in the sample excel sheet. These variables do not need to be outputted into the same data element but can instead just be saved as new variables. I will then use these variables later in my existing code where they’re needed for further use.
Please note there are 38 total variables that will need to be calculated. They are all the ones shown in the table between columns X though AE.
Just to review, the objective is to add columns G, H and I to the existing data element… and also create newly defined variables of the 38 calculations that are shown in the example (e.g., Winning Trades, Positive Returns, SQN Score, etc.)
** Please include a brief description in your PM along with your bid so I can tell that you reviewed the attached document read and fully reviewed the project description instead of using an auto-bidder to bid on the project. Just a sentence or two will do.
Project ID: #21525486
About the project
Awarded to:
PM Hi Dear I read your requirements carefully and understand. I will read csv and process column x with AE and output to xlsx file. I have rich experience with Python Django, Flask, selenium, Web Scrapy, software ar More
13 freelancers are bidding on average $176 for this job
Pro Python/Data analysis/Math/Algorithm/ Machine Learning/AI Expert! Hi client. Once saw a your project, it was very attracted my mind because I am very interested in your project and also, have rich experiences and h More
HI, I am data scientist and have good experience in python and R programming. My area of interest is statistical Analysis of dataset and apply ML/deep learning algorithm and report writing . I can intern your tasks. K More
PM I am python expert and I have rich experience with excel using python. I am going to use Python pandas and numpy.
hey i am expert in python development .. message me i can do this job for you .. thanks....................
How are you? I just have read your requirement very carefully. As a senior web developer, i am very confident in your job. ( Python and many more.) I am free now, I can start to work in your project immediately. plea More
Hi. I just read your project description and I'm interested in your job. As you can see on my profile and working history, I have rich experience with Python. Kind Regards! Kyryl.