/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

18 votes330 views3 answers
How to clear command prompt python
Python
2 votes287 views1 answer
Jsonresponse status code
Python
1 vote318 views2 answers
Pandas rename column values dictionary
Python
0 vote324 views1 answer
Elementwise comparison list python
Python
5 votes328 views1 answer
Python convert remove spaces from beginning of string
Python
1 vote312 views2 answers
Python error get line
Python
20 votes304 views4 answers
Generate a random number in python between 0 and 1
Python
4 votes292 views3 answers
How to write to an output file in pytion
Python
0 vote295 views1 answer
ImportError: cannot import name 'MaskedArray' sklearn
Python
1 vote284 views1 answer
How to change the color of command prompt in python
Python