Dataframe (df) having column msrid(String) having values m_123,m_111,m_145,m_098,m_666
I wanted to filter out rows which are having values m_123,m_111,m_145
df.filter($"msrid".isin("m_123","m_111","m_145")).count
count =0
while
df.filter($"msrid".isin("m_123")).count
count=121212
I have tried using queries like
df.filter($"msrid" isin (List("m_123","m_111","m_145"):_*))
count =0
but
df.filter($"msrid" isin (List("m_123"):_*))
count=121212
Any suggestion will do a great help to me.
Thanks,
Nayan
