Python Forum
Pandas, Assign a value in a row, to another column based on a condition
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Pandas, Assign a value in a row, to another column based on a condition
#3
(Oct-14-2020, 11:21 AM)jefsummers Wrote: Not quite sure what you are trying to do. In the for loop, are you trying to set Insu1 to the contents of the Value column if Code and ValueCount are both 1? And then are you trying to set the value of ResultValue to Insu1 in that same row?

Yes, In the for loop, for each "Code" if the Code field is equal to code (or i) and Value Count is equal to 1, then the Value in "Value" field is assigned to Variable "Insu1". Then such Value has to be assigned to entire "ResultValue" field when Code filed is equal to i.
Reply


Messages In This Thread
RE: Pandas, Assign a value in a row, to another column based on a condition - by klllmmm - Oct-14-2020, 05:40 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Get an average of the unique values of a column with group by condition and assign it klllmmm 0 323 Feb-17-2024, 05:53 PM
Last Post: klllmmm
  unable to remove all elements from list based on a condition sg_python 3 483 Jan-27-2024, 04:03 PM
Last Post: deanhystad
  Python Alteryx QS-Passing pandas dataframe column inside SQL query where condition sanky1990 0 767 Dec-04-2023, 09:48 PM
Last Post: sanky1990
  pandas : problem with conditional filling of a column Xigris 2 657 Jul-22-2023, 11:44 AM
Last Post: Xigris
  Sent email based on if condition stewietopg 1 886 Mar-15-2023, 08:54 AM
Last Post: menator01
  create new column based on condition arvin 12 2,339 Dec-13-2022, 04:53 PM
Last Post: jefsummers
  How to assign a value to pandas dataframe column rows based on a condition klllmmm 0 868 Sep-08-2022, 06:32 AM
Last Post: klllmmm
  Basic Pandas, obtaining a value from column and row JamesOzone 2 1,107 Jun-30-2022, 07:16 PM
Last Post: jefsummers
  select Eof extension files based on text list of filenames with if condition RolanRoll 1 1,545 Apr-04-2022, 09:29 PM
Last Post: Larz60+
  Openpyxl-change value of cells in column based on value that currently occupies cells phillipaj1391 5 9,921 Mar-30-2022, 11:05 PM
Last Post: Pedroski55

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020