/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

9 votes292 views3 answers
A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead
Python
1 vote336 views1 answer
Django don't redirect on submission
Python Django
1 vote321 views1 answer
How to become python developer
Python
0 vote303 views1 answer
Restore tf model python ValueError: Unknown loss function:smoothL1
Python
0 vote353 views1 answer
Dimension of an indez pandas
Python
1 vote311 views2 answers
How to add numbers in python using for loop
Python
2 votes309 views1 answer
Django template capitalize equivalent
Python
0 vote322 views1 answer
R Return each result with an index
Python
0 vote339 views1 answer
Os.startfile on raspberry
Python
0 vote310 views1 answer
Python elementtree load from string
Python