/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

0 vote220 views0 answer
Python
0 vote285 views1 answer
Find maximum element in stack
Python
0 vote253 views2 answers
Copy only some columns to new dataframe in r
Python
0 vote263 views3 answers
Python strftime iso 8601
Python
0 vote248 views1 answer
How to loop through every character in a string
Python
11 votes264 views2 answers
Discord.py presence
Python
8 votes270 views2 answers
Python inner join based on two columns
Python
0 vote283 views3 answers
Hash function in Python
Python
3 votes252 views1 answer
Use column as index pandas
Python
2 votes278 views2 answers
Python program to find first n prime numbers
Python