use excel if conditions in dataframes

Asked Apr 09 '21 at 04:49

Active Apr 09 '21 at 04:53

Viewed 19 times

I have an excel binary sheet, so there are limited libraries i can refer to. I want to implement a multiple if condition. IF A column = False ,then "Not found" should be printed in column d with header name as "Exist". If "true" then check If column b= 2021 then "product coming soon" should be displayed else "product exist" is printed.

Excel equivalent:
=IF(A2=FALSE,"Not found",IF(A2=true ,IF(B=2021,"Product coming soon","Product exist")))

It should work for all the rows of column A.

edited Apr 09 '21 at 04:53

OneCricketeer

151,199
17
111
216

asked Apr 09 '21 at 04:49

Adi

Can you use `xlsxwriter`? https://xlsxwriter.readthedocs.io/working_with_formulas.html – PacketLoss Apr 09 '21 at 04:50
No, As i want to add this column in existing sheet and Xlsxwriter does not allows it – Adi Apr 09 '21 at 04:51
So what are the libraries you can use? – PacketLoss Apr 09 '21 at 04:52
1

We can use Pandas or Xlwings. I wanted to use openpyxl but i came to know that it is not compatible with binary files. – Adi Apr 09 '21 at 04:52
Conditionals work in pandas, so have you tried anything with them? – OneCricketeer Apr 09 '21 at 04:54
It seems need `np.select` – jezrael Apr 09 '21 at 04:59

use excel if conditions in dataframes

0 Answers0