finding part of string in panda list

Question

I have a pandas dataframe in which I have 1300 brain parts with 21 columns of information about them. In there is a structure_id_path, a tree-like structure of brain regions. I want to find every structure_id_path that contains e.g. '315' in it.

import pandas as pd
import numpy as np
df = pd.read_csv('/home/anja/Schreibtisch/Master/vonIsa/structure_tree_safe_2017.csv')

df[df.structure_id_path == '/997/8/567/688/695/315/184/526157192/']

When I do it like that I find exactly that one brain part with that specific structure_id_path.

But if I want to find every structure_id_path that contains 315, it returns an empty dataFrame, because it can't find 315.

isocortex = '315'
x = structure_list[structure_list['structure_id_path'] == isocortex]

Is there a method to find it, like *315 ?

Does this answer your question? Select by partial string from a pandas DataFrame — Cleb
– Cleb, Commented Nov 6, 2019 at 14:40

Aryerez · Accepted Answer · 2019-11-18 11:25:28Z

1

Try:

df[df.structure_id_path.str.contains('/315/')]

edited Nov 18, 2019 at 11:25

answered Nov 6, 2019 at 14:30

Aryerez

3,5052 gold badges12 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Cleb Over a year ago

@Anja: If it answers your question, please accept the answer by clicking the small check next to it which then turns green.

Anja Over a year ago

I have now the problem that it also finds '1315' but I only want to find exactly '315'. Do you know how I can do this?

Aryerez Over a year ago

@Anja Since your numbers always come between "/", I added those to the string in search

Collectives™ on Stack Overflow

finding part of string in panda list

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related