TransWikia.com

CASE WHEN SQL Type Statement in pandas

Data Science Asked by Eisen on December 31, 2020

I’m trying to create a new column called Class which is a calculated column.
Basically when the Math class is NA then the class will be the CS class, otherwise it will be vice versa.

How can I do this in python? Table name is Classes

MathClass |  CSClass |  Class
------------------------------
Trig      |  NA      |  Trig
NA        |  Java    |  Java
NA        |  Python  |  Python  

One Answer

Replace the missing value with empty string and add these columns up

Classes.fillna(value='').sum(axis=1)

Answered by chzhrr on December 31, 2020

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP