dataframe column contains string
df[df['A'].str.contains("hello")]
dataframe column contains string
df[df['A'].str.contains("hello")]
pandas select rows that contain substring
# Basic syntax to select rows that contain one substring:
import pandas as pd
df[df['column_name'].str.contains('substring')]
# Note, this only returns rows that contain substring in the specified
# column, it doesn't look for the substring in all columns
# Note, substring can be replaced with any REGEX expression
# Basic syntax to select rows that contain 2+ substrings:
import pandas as pd
df[df['column_name'].str.contains('substring_1|substring_2')]
# Where you can keep adding substrings to look for separated by |
# Basic syntax to select rows that do not contain substring:
import pandas as pd
df[~df['column_name'].str.contains('substring')]
# Where the ~ acts as a NOT to negate the results of the search
Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us