How to write value from a dataframe column to another column based in a condition?

Juan Rodrigues

I'm having some bad time here trying to figured out how to set a column-based in a condition. Basically, I want to copy the value from column "Customer" to the rows of the column "Call Ref", if the row is different from 'Enterprise' and 'Client'.

Follow the code I'm trying:

df_OCB['Call Ref'] = np.select([np.logical_and(df_OCB['Call Ref'] != 'Enterprise',df_OCB['Call Ref'] != 'Client')], df_OCB['Costomer'],default='')

Please, Does anyone have a good solution to share with me?

Antoine

Have you tried with np.where()?

df_OCB['Call Ref'] = np.where((df_OCB['Call Ref'] != 'Enterprise') & (df_OCB['Call Ref'] != 'Client'), df_OCB['Customer'],'')

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-09-12

Comments

0 comments

How to find minimum value in a column based on condition in an another column of a dataframe?

Setting value for dataframe column from another dataframe based on condition

how to add column in dataframe based on some condition from another column?

How to match column value in a dataframe based on condition in another dataframe?

Extract Value From Pandas Dataframe Based On Condition in Another Column

Get value from another dataframe column based on condition

Copy a column value from another dataframe based on a condition

how to set the value from a column to another based on a condition

How to fill the value into a new column based on the condition of another column in Pandas dataframe?

Fill DataFrame based on value from another column

How to add a new column based another column condition in pandas dataframe

How to populate a dataframe column based on condition met in another column

Assign value to a column from another column based on condition

Create a column with value from another column based on condition

Obtain value from a column based off condition in another column in R?

Selecting a column value based on the value from another dataframe column

Adding a new column to a dataframe from the values of another dataframe based on a condition

Create custom column based on condition of how another column value starts with

How to replace NaN value in column in Dataframe based on values from another column in same dataframe

how to write a query to set the value of a column based on another column

How to replace the values in a dataframe column based on another dataframe condition

Select from column in dataframe based on value in another column

Applying function in new dataframe column based on value from another column

update pandas dataframe column with value from another dataframe with condition

How to apply an operation in a column based on a condition from another column

How to update a column based on date condition from another column?

How to select a column's values from a dataframe based on a datetime condition in another dataframe?

pandas add column to dataframe having the value from another row based on condition

How to fill column values from dataframe column names based on condition?

TOP Ranking

Article

How to write value from a dataframe column to another column based in a condition?

How to write value from a dataframe column to another column based in a condition?

pump.io port in URL

How to import an asset in swift using Bundle.main.path() in a react-native native module

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

Double spacing in rmarkdown pdf

SQL Server : need add a dot before two last character

C++ 16 bit grayscale gradient image from 2D array

JMeter: Why get error when try to save test plan

JWT gives JsonWebTokenError "invalid token"

How to make thrown errors visible outside of a Promise?

How to tell if iOS Today Widget is being updated in the background?

Calling Doctrine clear() with an argument is deprecated

Capybara Selenium Chrome opens About Google Chrome

How to update azerothcore-wotlk docker container

Adding Ripple Effect to RecyclerView item

mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on '127.0.0.1:3306' (111 Connection refused)

Error while applying filter on dataframe - PySpark

Unable to add slack to bluemix project

MyPy fails dataclass argument with optional list of objects type

How can I validate and parse phone numbers to extract their country calling code and area code?

Single Sign-On in Spring by using SAML Extension and Shibboleth

python how to create many-to-many of lists inside one list