if column exists code example

Example 1: check if column exists in dataframe

if 'A' in df.columns:

Example 2: sql check if column exists

* Using the below query, You can check whether the table1 has a column named "id"

SHOW COLUMNS FROM table1 LIKE 'id'