How do you sort a range containing dates in Google Sheets? Sorting a data set in columns or rows containing date data in Google Sheets can easily be done by …
How do you square a number in Python, and how do you check if a number is a square using Python? To square a number in Python use the power …
How do you find the square root of a number in Python? Can you find the square root without needing to import the math library? The most common approach in …
How do you get a unique list of duplicates from an original list using Python? And how do you get a list of all the duplicate items in a list …
How do you remove duplicates from a list using Python? To remove duplicate elements from a list in Python use a list comprehension to create a new list with no …
How do you insert a blank line into HTML? Several ways are possible, with each unique approach depending on your specific use case and what is permissible to edit with …
How do you find the most common element in a list using Python without importing any special libraries? To find the most frequent elements in a list iterate through the …
The SWITCH() function in Google Sheets is handy when dealing with multiple criteria based on a single result. The SWITCH() function takes at least 3 parameters, with the first parameter …
How can you check the version of Python you are using in PyCharm? There are three ways to check the version of your Python interpreter being used in PyCharm: 1. …
When using the slice operator [start:stop:step] to capture only a subset of data from an original list or string, what does [:] do? The slice operator containing no values for …
There are times when you want to be able to print the contents of a variable along with a string to help provide some context around what has been output …
A way to easily sort a list of strings equally is to change all the strings to lower case, but how do you change strings to lower case in Python? …
It can be easy to sort a list, whether a list of strings or even a list of dictionaries, but can you sort just a dictionary? Another handy expression that …
The built-in ord() function in Python converts any Unicode character into a number. It only takes one parameter which must be a single Unicode character, any more than one character …
A common requirement in Python is to split a string into the characters which make up the string. I’ve previously shown how you can do this by breaking up a …
To find the length of a list use the built-in len() function which takes a single parameter that is iterable. For example this could be a string, list, tuple or …
One way to determine if one value does not equal another is to use the != comparator, but what if you’re not comparing two values – how can you determine …
Previously I looked at how to use the enumerate() built-in function with a for loop to provide two variables when iterating through a list. In that article the enumerate() function …
The for loop in Python allows the user to iterate through a variable that is iterable, such as a list. In Python the syntax for the loop is simply: for …
How do you print a tab character in Python? The easiest way to print a tab character in Python is to use the short-hand abbreviation ‘\t’. To see the tab …
When you want to print the contents of a list you have a couple of different options depending upon the context. If you’re in the REPL there’s the easy method …
