Đã hoàn thành

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

Kĩ năng: Python, Kiến trúc phần mềm

Xem nhiều hơn: 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

Về Bên Thuê:
( 0 nhận xét ) Dubai, United Arab Emirates

ID dự án: #24570738

Được trao cho:

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 trong 7 ngày
(2 Đánh Giá)
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 Thêm

$30 USD trong 7 ngày
(0 Đánh Giá)
0.0

22 freelancer đang chào giá trung bình $26 cho công việc này

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 Thêm

$20 USD trong 1 ngày
(287 Nhận xét)
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 trong 1 ngày
(166 Nhận xét)
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 trong 1 ngày
(43 Nhận xét)
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 trong 7 ngày
(32 Nhận xét)
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 Thêm

$50 USD trong 1 ngày
(68 Nhận xét)
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 trong 1 ngày
(12 Nhận xét)
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" # Thêm

$25 USD trong 1 ngày
(16 Nhận xét)
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] Thêm

$35 USD trong 1 ngày
(13 Nhận xét)
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 Thêm

$20 USD trong 1 ngày
(26 Nhận xét)
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 Thêm

$30 USD trong 1 ngày
(4 Nhận xét)
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 Thêm

$20 USD trong 1 ngày
(4 Nhận xét)
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 Thêm

$24 USD trong 1 ngày
(4 Nhận xét)
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 trong 2 ngày
(4 Nhận xét)
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 trong 2 ngày
(0 Nhận xét)
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 Thêm

$15 USD trong 2 ngày
(0 Nhận xét)
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 trong 1 ngày
(0 Nhận xét)
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 Thêm

$15 USD trong 1 ngày
(0 Nhận xét)
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. Thêm

$15 USD trong 2 ngày
(0 Nhận xét)
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 trong 1 ngày
(1 Nhận xét)
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 trong 2 ngày
(0 Nhận xét)
0.0