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...
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...
Input/Output in Python
Pandas: How to Read Specific Columns from Excel File
You can use the following methods to read specific columns from an Excel file into a pandas DataFrame:
Method 1: Read Specific Columns
df = pd.read_excel('my_data.xlsx',...
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