Excel
How to Search for Special Characters in a Cell in Excel
You can use the following formula to check if a given cell in Excel contains any special characters anywhere in the cell:
=SUMPRODUCT(--ISNUMBER(SEARCH({"!","#","$","%","(",")","^","@","","{","}"},A2)))>0
This particular formula...
Excel
How to Search for a Question Mark in Excel
You can use the following formula to check if a given cell in Excel contains a question mark anywhere in the cell:
=IF(ISNUMBER(SEARCH("~?", A2)), "Yes",...
Excel
How to Search for an Asterisk in a Cell in Excel
You can use the following formula to check if a given cell in Excel contains an asterisk anywhere in the cell:
=IF(ISNUMBER(SEARCH("~*", A2)), "Yes", "No")
This...
General Functions in Python
How to Extract Number from String in Pandas
You can use the following basic syntax to extract numbers from a string in pandas:
df.str.extract('(d+)')
This particular syntax will extract the numbers from each string...
General Functions in Python
Pandas: How to Sort DataFrame Based on String Column
You can use the following methods to sort the rows of a pandas DataFrame based on the values in a particular string column:
Method 1:...
General Functions in Python
How to Rename the Rows in a Pandas DataFrame
You can use one of the following methods to rename the rows in a pandas DataFrame:
Method 1: Rename Rows Using Values from Existing Column
df...
Input/Output in Python
Pandas: Skip Specific Columns when Importing Excel File
You can use the following basic syntax to skip specific columns when importing an Excel file into a pandas DataFrame:
#define columns to skip
skip_cols =...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read