how to perform a pandas dataframe subsetting using index and assign it a same value?

Question

How to partially split a dataset from row indexes, and column names or column indexes. I tried this df.loc[[1,2,34,'name']] = 100 and df.iloc[np.where(df.loc[,'name']<100)]=100 this do not work. Need help, thank you!

data sample:

>> df

>>    name  lag
  0   100.0 0.000000
  1   80.0  0.011161
  2   255.0 0.022321
  3   93.0  0.033482
  4   100.0  0.044643
  5   9.8  0.055804
  6   29.0  0.066964

Can you ad some small data sample to question?

jezrael
– jezrael

2021-03-29 09:36:47 +00:00
Commented Mar 29, 2021 at 9:36 — jezrael
– jezrael, Commented Mar 29, 2021 at 9:36

jezrael · Accepted Answer · 2021-03-29 09:53:52Z

3

If need set index values 1,2,34 and columns name name to 100 use:

df.loc[[1,2,34],'name'] = 100

If need set by mask use:

df.loc[df['name']<100, 'name']=100

#for set another column
df.loc[df['name']<100, 'lag']=100

edited Mar 29, 2021 at 9:53

answered Mar 29, 2021 at 9:36

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to perform a pandas dataframe subsetting using index and assign it a same value?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related