Have you ever dreamt about coding classes like a pro? No? You had “normal” dreams? Anyway, in the video below, I am solving 3 exercises with a lot of debugging and some basic tests. Exercises are from the book Python…
Have you ever dreamt about coding classes like a pro? No? You had “normal” dreams? Anyway, in the video below, I am solving 3 exercises with a lot of debugging and some basic tests. Exercises are from the book Python…
Ok, so the golang language does not exactly have the word “while” in it. Anyway, the do-while and while-do loops can be easily implemented with a for loop. The main difference between the do-while and while-do is that in the…
About two years after the “Nested loops with recursion” today I was looking for a way to avoid nested loops with recursion in google and found my article 🙂 . Lots has changed in my coding style since then as…
C# and .Net were actually thought as the technology that was going to exchange VBA and make it useless. Well, it did not happen because of many reasons, mainly because plenty of companies still use macros and noone has the…
Ok, C# and .Net have features that people from the VBA world can only … dream about. In a way. I was recently taking a look at the Type.GetEnumNames() function in .Net and I simply thought that it would be…
JavaScript is probably the language that I have decided to specialize during the first half of the 2016. 🙂 Thus, today I have taken some 3 of the homework tasks of the SoftUni in the Advanced JavaScript Course, just to…
JavaScript seems to be the language for me for December. Although I am really working with VBA only, JS has really a lot to show. Thus, today I will simply write some easy OOP samples, that I can use later…
There is a new article on the same subject here – https://www.vitoshacademy.com/vba-avoid-nested-loops-with-recursion-part-2/ Everyone knows how ugly it looks from a programming point of view to have 5 or 6 nested loops. But what can you do to avoid this? The answer…
Object oriented programming (OOP) in general is a huge topic, but I have decided to make a 30 minute video, based on the book Math for Programmers, as I liked the way it was explained there: Generally, in the video,…
Excel with VBA is really a powerful tool. There should be some 5 more years, until Python really becomes a standard for the Excel people and I am not sure that it would actually happen that quickly. Anyway, working with…
Python allows decent built-in logging. As I am going to explain in the video below, the built-in logging is actually rather neat – it allows everyone to log into a file or into the console within minutes – just the…
Perlin random noise.
I took a look at that new ChatGPT and I can officially say – the future is now. Take a look at what it does, after writing it a simple nice request: The first result did not work, as it…
After writing about Default Dictionary in Python some time ago, now it is time to take a look at the ordered dictionary and the heap queue as these are built-in structures, coming out of the box. And they are fancy.…
Logging in Python is beautifully implemented with the logging library – https://docs.python.org/3/howto/logging.html It simply does anything you need and you do not need to write something yourself, like I did some time ago here in my VBA Boilerplate. So, if…
Functions in Python are objects. If this is the first time you read this sentence, then you will not get a lot from this article, but it will show you, that there is quite a lot to learn about Python.…
Class variables vs instance variables could seem a bit strange, if you have no OOP experience, but after a few thausand lines of code they become logical. So, in around two days of programming you will be getting it intuitively…
One of the benefits of having your own blog and not following any schedule for subjects to write about is that you may write for whatever you feel like, whenever you feel like. So, Iterations in Python is the subject…
Yesterday I received an email, refering to some 2 old articles in VitoshAcademy for nested loops without recursion: VBA – Nested loops with recursion (Permutations) VBA – Avoid nested loops with recursion (Part 2) As far as the person from…
Months ago, I was planning to take part in the #RailGirls event in Sofia, and I was even a partner in the event. Anyway, as it was postponed up to somewhere in the future, I have decided to go through…
In this article I am planning to give an answer of the following two questions: What is a closure? A closure is a function, inheriting variables from enclosing environment. Operationally, a closure is a record storing a function together with…
Long time ago, various people, including me, were trying to make permutations and combinations with nested loops and various other “heavy” structures. Anyway, in Python there is a library, which does this for us and sets the end of the…
Today I have decided to check whether I can pass the first homework from SoftUni OOP with Python, through a live coding session. I have not read the problem before the video, thus I may say it took me exactly…
Cartopy is a Python package designed for geospatial data processing in order to produce maps and other geospatial data analyses. Making a map with Python and Cartopy is actually easier than you might think, but still it has its own…
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,…
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…
There are quite a few methods for writing data from a text file to Excel. The main are the following: Through a Query Table Through opening the text file and Reading and writing line by line Reading the text file,…
Some time ago, I have received the book of Stephen Wolfram – Adventures of Computational Explorer for a review. Stephen is the guy behind WolframAlpha – https://www.wolframalpha.com/, a PhD in physics before his 21. birthday, considered a prodigy by some…
Although there are plenty of other tools for extracting data from a website (take a look at Beautiful Soup), VBA is somehow good, because … well, because it is somehow challenging to do it every time. Yesterday, I answered a…