How to Convert SQL into Python Pandas? Part 6 - Condition

Previously on How to Convert SQL into Python Pandas? Part 5, we talked about how to convert SQL statements into Pandas syntax. In this article, we will continue to discover more scenarios and operations. (Data import into Python)

Condition (if)

-- SQL
SELECT *, 
iif (BillingCountry = 'Germany' , 'Germany', 'Non-Germany') Germany
FROM main.invoices;