Build a Python Script to Process Data

Tamamlanmış İlan edilme: 4 yıl önce Teslim sırasında ödenir
Tamamlanmış Teslim sırasında ödenir

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.

Python

Proje NO: #21525486

Proje hakkında

13 teklif Uzak proje Aktif 4 yıl önce

Seçilen:

AlexanderPGR

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 Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 200%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(20 Değerlendirme)
5.3

Bu iş için 13 freelancer ortalamada $176 teklif veriyor

skfaroo123

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 Daha Fazla

$150 USD in 3 gün içinde
(21 Değerlendirme)
5.8
kipdev13

Hello,how are you? I am very interested in your project. I have experiences for many years about python programming. I have read your Build a Python Script to Process Data post and have detailed plans to dicuss with y Daha Fazla

$200 USD in 3 gün içinde
(50 Değerlendirme)
6.0
qaisrani123

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 Daha Fazla

$250 USD in 3 gün içinde
(41 Değerlendirme)
5.4
TopDesigner315

PM I am python expert and I have rich experience with excel using python. I am going to use Python pandas and numpy.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(15 Değerlendirme)
4.9
aftabyounas

hey i am expert in python development .. message me i can do this job for you .. thanks....................

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
3.4
romancoder204

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 Daha Fazla

$200 USD in 4 gün içinde
(2 Değerlendirme)
2.4
kirillmol213

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.

$200 USD in 7 gün içinde
(0 Değerlendirme)
1.0
BelisaG

Hi client I am very interested in your project. I am an expert developer who guarantees hard work, quality and perfection. As for me, I am a full-stack developer with 6+ years experience in the web development and data Daha Fazla

$150 USD in 7 gün içinde
(0 Değerlendirme)
0.0