Google Sheets
Google Sheets: How to Use SEARCH with Multiple Values
You can use the following basic syntax to use the SEARCH function with multiple values in Google Sheets:
=FILTER(A2:A10, SEARCH("Backup", A2:A10), SEARCH("Guard", A2:A10))
This particular example...
Input/Output in Python
Pandas: How to Specify dtypes when Importing CSV File
You can use the following basic syntax to specify the dtype of each column in a DataFrame when importing a CSV file into pandas:
df...
Google Sheets
Google Sheets: How to Use FILTER with Wildcard
You can use the following formula in Google Sheets to use a wildcard character within a FILTER function:
=FILTER(A2:C11,search("avs",A2:A11))
This particular formula will filter the cells...
Input/Output in Python
How to Read CSV File from String into Pandas DataFrame
You can use the following basic syntax to read a CSV file from a string into a pandas DataFrame:
import pandas as pd
import io ...
Google Sheets
Google Sheets: Use IMPORTRANGE Within Same Spreadsheet
You can use the IMPORTRANGE function in Google Sheets to import data from another spreadsheet.
However, if you would like to import data from one...
Input/Output in Python
Pandas: Set Column Names when Importing CSV File
You can use the following basic syntax to set the column names of a DataFrame when importing a CSV file into pandas:
colnames =
df...
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