0

I am trying to find a specific substring that matches the value in the column.

After merging the column results defer because values for column 1 = Salesman no1, value for column2 is = Salesman. because of this the data frame shows empty

BCnew = df.loc[(df.Table == 'VARCUST')]
BaCnew = df.loc[(df.Table == 'VBISALES')]
Inner_merged = pd.merge(BCnew,BaCnew,how='inner', on=['Column_Desc'])
print(inner_merged)
marc_s
  • 704,970
  • 168
  • 1,303
  • 1,425
Ali Fazal
  • 3
  • 2
  • Hi! Please try to provide a [minimal reproducible example](https://stackoverflow.com/help/minimal-reproducible-example) that will show what you want to do. If you want to find a substring of a string, you can follow [this answer](https://stackoverflow.com/questions/3437059/does-python-have-a-string-contains-substring-method) – Filip Kubicz Jun 16 '21 at 21:26

0 Answers0