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
22 freelancers estão ofertando em média $26 para esse trabalho
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.
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.
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
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.
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]
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