Remove string from a dataframe based on multiple conditions – StackOverflow import numpy as np import pandas as pd strings = """ Text,,, Associated_word Corperation,,, Corp., Coperate f,,, flat,flt,flaat 100,,, 200,30,40 block,,, 24fl,,, 24floor,25fl,36fl central,,, centre, cent 20,,, 30,40 """.splitlines() s = [[s.strip() for s in x.split(',,,')] for x in strings if x] df = pd.DataFrame(data=s[1: