# Create a dynamic column df['dynamic_column'] = df['text'].apply(lambda x: 'Yes' if 'siterip k2s new' in x else 'No')

Let's assume you have a DataFrame and you want to create a new column dynamically based on some conditions related to "siterip k2s new".

print(df) In SQL, you might create a dynamic column using a CASE statement.