Finding values ​​in Pandas?

Question

Python

There is a column with values ​​of the form:

Zbx_login
Zbx_login1
Zbx_login2
Elg_login1
Elg_login3
Elg_login2

It is necessary to put records with the Elg prefix into a separate dataframe. What is the correct way to search in pandas?

Answer 1

There is a handy function - startswith , it will work well here.

import pandas as pd
df = pd.DataFrame(['Zbx_login', 'Zbx_login1', 'Zbx_login2', 'Elg_login1', 'Elg_login3', 'Elg_login2'], columns=['name'])
df_filtered = df[df.name.str.startswith('Elg_')]
df_filtered