Statistics Tutorial
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 Only Read Specific Rows from CSV File
You can use the following basic syntax to only read in specific rows from a CSV file into a pandas DataFrame:
#specify rows to import
specific_rows...
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