The difference between json.dump and json.dumps is actually quite visible: dump() – dumps into a file or StringIO dumps() – dumps a string, that could be printed Still, I am going to give a few example with these, as the…

In the previous article for abstraction and inheritance I wrote some classes, showing the basics of these two programming concepts. In this one, I will write unit tests for one of the classes, written before. Software testing is an important…

Tagged with: error catching in unit test, Python, setup, teardown, type error unit test, unittest, writing unit tests

In 2013 and 2014 (wow, already 7 years ago!) I wrote two articles about linear regression with Excel. Now, I am getting more and more interested in Python, thus I guess it would be interesting to remake the article into…

Tagged with: linear regression, plotting, plotting both predicted and real values, prediction, Python

Working with python, pandas and dataframes is quite challenging even for experienced Excel & VBA developer, as I love to consider myself for one. Thus, today I was fighting for quite some time to add new columns to a dataframe,…

Tagged with: adding columns, based on columns, based on rows, computating column, dataframe, offset, Python, shift, shifting column

About 4 years ago, I wrote an article about prime numbers in Excel and their visualisation with VBA – vba-function-in-excel-to-check-prime-numbers. Pretty much, it displays the prime numbers in a 10 x N matrix, starting from 1 and finishing at N:…

Tagged with: align, bg_color, center, Excel, first column and first row of Excel is with index 0, font_color, format, matrix, prime numbers, Python, xlsxwriter

Top