Update cell values of a big pandas dataframe

Question

I have a dataframe with 7K columns and and same 7K values as indices

ex.

            c1 c2 .... c7000
          c1
          c2
          .
          .
          .
          c7000

I want to update each cell of this dataframe on some condition.

Can anyone please suggest fastest way to achieve this.

Please give moe information about the condition – gtomer Aug 11 '22 at 07:34 — gtomer, Aug 11 '22 at 07:34

score 0 · Answer 1 · answered Aug 11 '22 at 08:10

Without knowing more about the question it is hard to give an answer. Please be more specific and ideally provide code to reproduce part of the dataframe that you are working with.

Usually apply() is used in such cases if I understand your description correctly:

df["update"] = df.apply(lambda row: 1 if row["conditional_column_boolean"] == "yes" else 0, axis = 1)

# for example
df = pd.DataFrame([[4, 9], [6, 2], [6, 10]], columns=['A', 'B'])
df.apply(lambda row: 1 if row["B"] > 8 else 0, axis = 1) # conditional column is column "B"
0    1
1    0
2    1
dtype: int64

Update cell values of a big pandas dataframe

1 Answers1