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

Evner: Python, Software Arkitektur

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) Dubai, United Arab Emirates

Projekt ID: #24570738

Tildelt til:


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 in 7 dage
(1 bedømmelse)

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 Flere

$30 USD in 7 dage
(0 bedømmelser)

22 freelancere byder i gennemsnit $26 på dette job


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 Flere

$20 USD på 1 dag
(287 bedømmelser)

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 på 1 dag
(166 bedømmelser)

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 på 1 dag
(41 bedømmelser)

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 dage
(32 bedømmelser)

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 Flere

$50 USD på 1 dag
(68 bedømmelser)

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 på 1 dag
(12 bedømmelser)

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" # Flere

$25 USD på 1 dag
(16 bedømmelser)

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] Flere

$35 USD på 1 dag
(12 bedømmelser)

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 Flere

$20 USD på 1 dag
(26 bedømmelser)

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 Flere

$30 USD på 1 dag
(3 bedømmelser)

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 dage
(4 bedømmelser)

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 Flere

$20 USD på 1 dag
(1 bedømmelse)

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 Flere

$24 USD på 1 dag
(2 bedømmelser)

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

$20 USD in 2 dage
(0 bedømmelser)

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 Flere

$15 USD in 2 dage
(0 bedømmelser)

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 på 1 dag
(0 bedømmelser)

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 Flere

$15 USD på 1 dag
(0 bedømmelser)

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. Flere

$15 USD in 2 dage
(0 bedømmelser)

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 på 1 dag
(1 bedømmelse)

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 dage
(0 bedømmelser)