Terminé

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

Compétences : Python, Architecture Logicielle

en voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Dubai, United Arab Emirates

Nº du projet : #24570738

Décerné à:

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!

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 7 jours
(2 Commentaires)
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 Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 7 jours
(0 Commentaires)
0.0

22 freelance font une offre moyenne de $26 pour ce travail

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(287 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(166 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(43 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(32 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(68 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(12 Commentaires)
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" # Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(16 Commentaires)
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] Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(13 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(26 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
1.7
gopalkrgautam

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(4 Commentaires)
1.8
msrajuds

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
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]

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0