Ryan Sheehy
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 being the value to evaluate, the second and third parameter representing a pair of combined cases and values. There’s also an optional final parameter that …
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. check in the Settings section; 2. open a terminal prompt in your PyCharm project; 3. open the Python Console window in your Python project. Let’s …
The slice operator enables you to capture a subset of data from an original list or string using the format [start:stop:step]. Some popular use cases where I have used the slice operator include: Here is how the Python [:] operator can work when populating the values on either side of the colon: Extract Date Values …
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 to the console. So how can you print both a string and a variable in Python? The three methods of being able to print a …
How do you get a string to be all lowercase in Python? Thankfully there’s a built-in method that doesn’t require importing any external libraries to get a string to lower case, here’s how you do it. To get a string to all lowercase, use the built-in string method .lower(), which turns all characters in the …
What is the syntax for writing a for loop on one line in Python? This syntax is known as a list comprehension and enables the user to write a for loop on one lin To write a for loop on one line in Python, known more commonly as the list comprehension, wrap the for loop …