Concluído

Python Pandas selecting rows whose sum equals to a value in another column

I have a dataFrame where i want to get one combination of rows that sum up to a given value in another column.

The DataFrame contains a column with unique codes that have a column named Canceled and have another column among many called HO_Orders. I need to get rows whose HO_Orders combination will sum up to the canceled value of the code.

NB: The canceled column is constant per code on every row but may be different on another unique code.

The output should contain rows of each code that sum up to the canceled column.

The other rows that don't sum up or that are not seleced, must be saved to another file.

Just to make things clear for Every one look at the following scenario.

Say Code RZ has HO_Orders [1, 2,5,8,12] and the canceled is 8, i can select [1,2,5] or select 8 but not both combinations

u can see that [1,2,5] will sum up to 8. If you have many combinations that fit the value of canceled in this case its 8, then take any but not more than 1 combination

Habilidades: Python, Arquitetura de software

Veja mais: pandas series sum, pandas sum column with condition, pandas sum multiple columns at once, sum of rows in python, pandas sum rows with same value, pandas sum rows based on column, pandas sum two columns, pandas sum unique values in column, excel increment value column macro, row plus row increment equals value error, displays grade employees based value column job sql, find repeat value column excel vba, sum target value vba, excel vba sum based value column, vba sum value column excel, jquery sum input value, vba excel finding value column, excel sum multiple cell column vba, find value column vba excel, selecting rows matrix array python csv file

Acerca do Empregador:
( 0 comentários ) Dubai, United Arab Emirates

ID do Projeto: #24570738

Concedido a:

botiko123

Hi! I can provide you the python script today to select the rows you needed. To clarify your needs please contact me. Best regards, Botond!

$20 USD em 7 dias
(2 Comentários)
1.7
TalhaMunir07

I have see HO_Orders & CANCELED column in attched screenshot "Best ideas" . I am a data scientist and attaching my linkedin profile to show my skills in PANDAS + DATA ANALYSIS. I can get ROWS with HO_Order combinatio Mais

$30 USD em 7 dias
(0 Comentários)
0.0

22 freelancers estão ofertando em média $26 para esse trabalho

NovaSofts

Hello Sir/ Ma’am We are a group of Software Engineers (Programmers) having 10+ years of experience. Expert in JAVA, C, C++ , C# , Python, ANDROID,IOS, MATLAB, IONIC. Done 670+ projects here on FREELANCER.COM. The Mais

$20 USD em 1 dia
(287 Comentários)
7.4
lkhelladi

Hello, I'd be glad to do this python + pandas task for you. Looking forward to chat with you soon for more details. Best regards.

$35 USD em 1 dia
(166 Comentários)
7.3
aki003iitr

Analyst with more than 4 years of programming experience in Python and have completed more than 30 projects in Python on this platform. Proficient in using various python packages like pandas, numpy,scipy etc.

$30 USD em 1 dia
(43 Comentários)
6.3
NeaWeaR

Hello my friend! I can help you to find these rows. One question - should I find all combinations? Write me as soon as you can and we will discuss. Thanks! Best regards, Vladimir.

$50 USD in 7 dias
(32 Comentários)
5.9
ThinkAndCo

Hi, We are a team of professional software developers. We have expertise in Python and can readily work on your requirements. Kindly consider our proposal for the best results. Looking forward to talking for more info Mais

$50 USD em 1 dia
(68 Comentários)
5.5
asifkhan268

Hi there, I can help you in pandas dataframe work. Please send your dataframe /excel file. If you have any questions or doubt please feel free to contact me via inbox. Regards Karim

$29 USD em 1 dia
(12 Comentários)
4.4
shahinrahimi

I have rich experience in python (Pandas, Numpy, Matplotlib,....), and I do my best to save your time and pocket. Please feel free to contact me. Services: # Accuracy # Customer satisfaction is my first "Priority" # Mais

$25 USD em 1 dia
(16 Comentários)
4.4
Demenntor

Dear Employer, I have seen your Job description. I have good experience in python panda and have done similar projects. I have also published a research paper that you can find here [login to view URL] Mais

$35 USD em 1 dia
(13 Comentários)
3.9
xeathprynx

Hello Sir/ Ma’am As a highly skilled full stack developer, I have rich experience in JAVA, C, C++, C# Python , Arduino, [login to view URL], Word press, and ANDROID. I am very confident with my skills and I'd like to he Mais

$20 USD em 1 dia
(26 Comentários)
4.2
YunfengDev

Hello, Sir. I read your opinion seriously. I have experience of 7 years and done similar projects before. As a man of trust, I can develop your project with full perfection. Let me go on, you can get the best project t Mais

$30 USD em 1 dia
(4 Comentários)
2.7
putinhuylo000532

Thank you for taking your time to review my application. Reading the job details, I am very interested in your project and I believe I’m qualified for the task. Regarding Python frameworks, I have 8+ years in this fie Mais

$20 USD em 1 dia
(4 Comentários)
2.4
ashikmohann

hi I have done a lot of projects that matches your description. i have lot of experience in coding python with data analysis packages like pandas and numpy. i can prepare the notebook with explanations in matter of fe Mais

$24 USD em 1 dia
(4 Comentários)
1.7
gopalkrgautam

Hi, I have strong experience in Data processing using pandas. Please ping me and share the Dataset to move further. Thanks!

$20 USD in 2 dias
(4 Comentários)
1.8
msrajuds

This can be achieved. I have strong experience in Data Wrangling with Python & related libraries, please consider my bid. Thanks!

$20 USD in 2 dias
(0 Comentários)
0.0
deepaksharma0123

As a self-employed, reliable, and highly experienced Freelancer with expertise in Python( Django, Flask, Django Rest Framework), Data Science( Matplot,Plotly,Numpy,Pandas Library ,Php or in Wordpress. I am certain you Mais

$15 USD in 2 dias
(0 Comentários)
0.0
stankovic33

Hello. I've just read your job description and I can do it perfectly as you need. Please send message so that we can discuss about the project in detail. Thanks.

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

Hi How are you? I'm a Python Data Analyst expert specially in Web Scraping. I'm a professional python data analyst and I know about pandas. Its very very easy don't be worry to taking it as a hard task. I know about Mais

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

Hello, I have the technical knowledge to help you manipulate the dataset as you asked on Pandas by using Group by and Pivot table functions. Would be happy to chat with you to learn more details about the project. Mais

$15 USD in 2 dias
(0 Comentários)
0.0
CharlesWangkai

Hi, I'm good at Pandas and Python programming. I have 10+ years experience as a software engineer. Look forward to helping you. Thanks! More info about me: [login to view URL]

$20 USD em 1 dia
(1 Comentário)
0.0
mohmd1087

Hi, hopefully this proposal finds you in good health. I am a young coder who has a good grasp over python programming language and i believe i can deliver your project and meet all your requirements

$25 USD in 2 dias
(0 Comentários)
0.0