Python – List Comprehension
List comprehension in Python is creation of lists from iterables and other lists, following a condition. It is lightning fast and it looks nice, because it is a 1 liner. In this article, I will show a few examples of …
Year: 2020
Python – What is the idea of “-1” in numpy reshape?
Today I was “fighting” with the numpy reshape function and I found something strange like matrix.reshape(1, -1). Thus, I have researched quite some time and I found, that the -1 is actually a placeholder for python to change the dimensions …
Python – What is the idea of “-1” in numpy reshape? Read more →
Python – How to write string into a matrix. Printing a matrix.
Writing string into a matrix seems like a non-interesting and somehow trivial task. Anyway, manipulating with matrices and strings in Python is actually somehow interesting, thus I have decided to present a small algorithmic challenge. The task is pretty much …
Python – How to write string into a matrix. Printing a matrix. Read more →
VBA – String.Format or how to put variables in a string
C#, Python, Java and all the other “fancy” languages have a built-in method, which writes variables into a string. VBA does not have one. Depending on why do we need it, and if we can guarantee that no injection would …
VBA – String.Format or how to put variables in a string Read more →
VBA – Make a list of the formula errors in an Excel
Errors in Excel are different – from “Division by Zero” (#Div/0) and #Name to #REF! and #Num. There are lots of ways to summarize these into some kind of report and in the current article I will show the VBA …
VBA – Make a list of the formula errors in an Excel Read more →