/Python/Python - find specific name in a df

Python - find specific name in a df

Get columns containing string

df2 = df.filter(regex='spike')
print(df2)

Get certain columns pandas with string

import pandas as pd

data = {'spike-2': [1,2,3], 'hey spke': [4,5,6], 'spiked-in': [7,8,9], 'no': [10,11,12]}
df = pd.DataFrame(data)

spike_cols = [col for col in df.columns if 'spike' in col]
print(list(df.columns))
print(spike_cols)

Python - find specific name in a df

i = df[df['Name']=='Will']
print(i)

Source: edureka.co

Similar codes

1 vote131 views1 answer
How to use query_params in get_object djangorestframework
Python
0 vote128 views1 answer
Python extend vs append
Python
3 votes170 views2 answers
Saving data in python
Python
0 vote136 views3 answers
Waitress
Python
-1 vote135 views1 answer
Python set multiple values at once
Python
4 votes134 views3 answers
Pandas dataframe drop rows with -ve in column value
Python
0 vote124 views1 answer
Pandas df count values less than 0
Python
-1 vote122 views1 answer
Import csv from google drive python
Python
0 vote135 views1 answer
Unindent does not match any outer indentation level
Python
0 vote124 views1 answer
Check correlation of each column with the target in python
Python