0

I am learning to use python for data science and I have a dataset "Comcast complaints" in which there is a column called "Status" which contains the following strings.

enter image description here

How can I use if else condition to categorize strings of "Open" & "Pending" as "Open Cases", "Closed" & "Solved" as "Closed Cases"

comcast_df['Status_New'] = comcast_df["Open Cases" if Status=="Open" or Status=="Pending" else "Closed Cases" for Status in comcast_df["Status"]]

I attempted the above line but it is going nowhere. I would appreciate any help in figuring out where I am going wrong.

Eunice Dhivya
  • 309
  • 4
  • 13
  • Can you test `d = {"Open":"Open Cases", "Pending" :"Open Cases", "Closed" :"Closed Cases", "Solved":"Closed Cases"}` and then `comcast_df['Status_New'] = comcast_df["Status"].map(d)` – jezrael Apr 13 '20 at 12:07
  • solution in dupe is general, here is possible use `map`, I guess better solution here – jezrael Apr 13 '20 at 12:12

0 Answers0