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...
General Functions in Python
Pandas: How to Rename Only the Last Column in DataFrame
You can use the following basic syntax to rename only the last column in a pandas DataFrame:
df.columns = , 'new_name']
This particular example renames the...
Google Sheets
Google Sheets: How to Filter IMPORTRANGE Data
You can use the IMPORTRANGE function in Google Sheets to import data from another spreadsheet.
To apply a filter to the IMPORTRANGE function, you can...
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