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 …
A spreadsheet helps users to be able to perform calculations without doing this process manually by hand. As you come to use spreadsheets more often you’ll be impressed at the …
If a cell contains words it can be easy to split these into individual cells using the Text to columns feature in Excel. Simply select the cells you want to …
When you start entering text into a cell and the first character of that cell is a plus symbol (+) you will get an error #NAME? and you would have …
When using large numbers in Excel or any other spreadsheet application, such as Google Sheets, some cells may display a number in scientific notation like 9.991E+35. How do you get …
How do you increase a variable by one in Python? In other popular programming languages to increment a variable by one you can use the simple increment syntax of ++, …
When using a spreadsheet it can be as easy as using the TRANSPOSE function on a range to transform the rows and columns into columns and rows, but how do …
You can construct a list in a certain number of ways as detailed in the Python documentation. The most popular I use the most is by defining my list variables …
To remove an individual item from a list in Python you can use either a list method or the del statement, both approaches mutate the original list – meaning the …
The VLOOKUP formula is a popular function for getting the value from a tabular data set and has 3 required parameters and an optional fourth, and looks something like this: …
To sort a list of strings according to their length, use a lambda function on the key parameter with the lambda function using the len function on each element. This …
The QUERY formula is a great way of being able to perform basic SQL-like commands on a data range. The signature of the QUERY formula is as follows: The first …
