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
#1
I'm trying to put a particular value in the data frame row to other rows also if it matches a condition. However i'm not getting what is expected. Can someone help to get the value as shown in the expected value column. Thanks in advance!                                                               Result I'm getting is    Code  Expected_Cum_Value   Value  ValueCount  ResultValue

0   100                1000     NaN         NaN          NaN
1   100                1000  1000.0         1.0       1000.0
2   100                1000  2000.0         2.0          NaN
3   200                2000     NaN         NaN          NaN
4   200                2000  2000.0         1.0       2000.0
df = pd.DataFrame(data = {'Code':[100,100,100,200,200],
                          'Value':[np.nan,1000,2000,np.nan,2000],
                          'ValueCount':[np.nan,1,2,np.nan,1],
                          'Expected_Cum_Value':[1000,1000,1000,2000,2000],})


for i in df['Code'].unique():
    print(i)
    Insu1= df.loc[((df['Code'] == i)&(df['ValueCount']==1)), 'Value']
    print(Insu1)
    df.loc[((df['Code'] == i)), 'ResultValue'] = Insu1
Reply


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

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 496 Feb-17-2024, 05:53 PM
Last Post: klllmmm
  unable to remove all elements from list based on a condition sg_python 3 590 Jan-27-2024, 04:03 PM
Last Post: deanhystad
  Python Alteryx QS-Passing pandas dataframe column inside SQL query where condition sanky1990 0 825 Dec-04-2023, 09:48 PM
Last Post: sanky1990
  pandas : problem with conditional filling of a column Xigris 2 703 Jul-22-2023, 11:44 AM
Last Post: Xigris
  Sent email based on if condition stewietopg 1 973 Mar-15-2023, 08:54 AM
Last Post: menator01
  create new column based on condition arvin 12 2,502 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 915 Sep-08-2022, 06:32 AM
Last Post: klllmmm
  Basic Pandas, obtaining a value from column and row JamesOzone 2 1,148 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,609 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 10,220 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