Fast Book Combination

Encerrado Postado há 3 anos Pago na entrega
Encerrado Pago na entrega

Dataframe contains 4 columns as follows:

price1 - contains prices in a list

price2 - contains prices in a list

size1 - contains sizes in a list correspond to each each price in price1

size2 - contains sizes in a list correspond to each each price in price2

i want to get two new columns

price_best - contains the price1 combined with price2 with no dupes

size_best - contains the corresponding size to price_best. If there was a dupe price that was in both price1 and price2 this should be the sum of size from size1 and size2 corresponding to that price entry.

i included a sample showing how the data is in the DF and the end result.

I am current using apply to do this but it is painfully slow. I am able to store the data in another format if need be if there is a faster way to get this end result.

Python

ID do Projeto: #25638572

Sobre o projeto

6 propostas Projeto remoto Ativo em há 3 anos

6 freelancers estão ofertando em média $57 nesse trabalho

ashikmohann

hi i have already implemented many projects in python and R for processing ,visualisation and analytics.I have also done projects in domains like machine learning, deep learning and others. i have done this on various Mais

$50 USD em 1 dia
(28 Comentários)
7.4
akshayhome348

Hey there, hope you are doing great. I have a Masters in Data Science and I have very good experience in Data Science and Machine Learning from past 2-3 years. I can surely help you in this and seems like a easy task w Mais

$30 USD em 1 dia
(27 Comentários)
5.0
gokulanand

Hello I can get you this done using a simple excel macro on a button click. I can get this task done right away and get in done in 1 or 2 hours. Please ping me if interested. Thanks Gokul

$50 USD em 1 dia
(12 Comentários)
3.7
crduran

Hi there, Very glad to bid on your project. Because this is just what I wanted by now. I am a Data scientist with enough experience in ML, DL and NLP. My skills: Python , Matlab, PowerBI, MS Office etc. I've just finis Mais

$100 USD in 3 dias
(4 Comentários)
3.1
mamoonaakbar

hi, i have experience of 3 year of python project, i can do your project within one day. if you give me your project send me message

$80 USD in 7 dias
(0 Comentários)
0.4
bouaaza

Hello sir, I was looking for exactly this,i get familiar with this and I can do well what you asked

$30 USD em 1 dia
(0 Comentários)
0.0