Create column for str contain in pandas

Question

With below code I am able to create dataframe

VAT = comm[comm['Particulars'].str.contains("comm|Britain", case=False)==True]

 VAT

 But I want to create column

below code does not work

comm['VAT'] = comm[comm['Particulars'].str.contains("comm|Britain", case=False)==True]

 comm

 Can you provide proper code ?

Answer 1

Hi Juzar

So if I am not wrong you have a dataframe called COMM from which you are filtering out the column particulars. These filtered values became another dataframe called VAT. But you do not want them as another dataframe, you want it as a column?

What you can do is, append the COMM dataframe with VAT. VAT will just become another column in COMM.

Hope it helps :)