Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR PYTHON

pandascheck if two columns match and populate new column

import numpy as np
import pandas as pd

a = [['10', '1.2', '4.2'], ['15', '70', '0.03'], ['8', '5', '0']]
df = pd.DataFrame(a, columns=['one', 'two', 'three'])

df['que'] = np.where((df['one'] >= df['two']) & (df['one'] <= df['three'])
                     , df['one'], np.nan)
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #pandascheck #columns #match #populate #column
ADD COMMENT
Topic
Name
8+7 =