Author: Vitosh

Go – Define Test Coverage in Golang – With Picture and Coverprofile – With YouTube Video!

Ever dreamt to have a picture of the test coverage of your code? In green for the covered rows and red for the non-covered ones? No? Anyway, read this article to see what you have missed 🙂

Tagged with: , , , , , ,

Go – Function that gets a website and returns its title – With ChatGPT

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

Tagged with: , , , , ,

Go – “While Do” and “Do While” loops in go

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

Tagged with: , , ,

Python – Split worksheet to worksheets, save Excel worksheets to csv

Same article, but for VBA is here – https://www.vitoshacademy.com/vba-split-worksheet-to-worksheets-save-excel-worksheets-to-csv/ This article does 2 things: Splits one worksheet to multiple worksheets Then goes through the worksheets and saves them as *.CSV files So what is the idea? Having this excel file,

Tagged with: , , ,

VBA – Check if resource or url exists in the internet

If you are one of the many VBA developers, then most probably you have been asked once or twice to download some file from a local eshare or site. Before downloading it, it really makes sense to check, whether this

Tagged with: , , , ,

Python – Filtering values from a Pandas DataFrame

Some time ago, probably yesterday or the day before, I had to filter a pandas dataframe and somehow it did not come intuitively into my mind how to do it. As I did not have an article about it, I

Tagged with: , , ,

VBA – Insert Into String

Inserting into string in Excel should be a trivial task, but it always makes sense to have something prepared in the boilerplate, before you start working. Ok, why is it important to have a nice function, if something like this

Git Log tricks

The idea here would be to show some git log tricks and to develop the article, whenever I find something more and more worthy. Before starting this one, please remember that exiting vim editors in the command prompt is with

Tagged with: , , , ,

Python – Just a bit about datetime and timedelta

Ok, dates in VBA and Excel are somehow complicated, because of some “feature” that Microsoft Excel has introduced, due to compatibility issues. I have already wrote a few articles about these here, and separate one about what day is Friday

Tagged with: , , ,

Python – Init a class with a default list property correctly

Sometimes, (but only sometimes) we think that writing too much code is useless and writing less code in python is more readable and performs faster. While in the general case this is true, this article is simply going to show

Tagged with: , , , ,

Python – Reading and writing to the console

Reading from the console and writing to it is a piece of cake in python. These two functions do it for you perfectly:

Then why am I writing a whole article about it? Well, there is something fancy, if

Tagged with: , , , ,

Python – Enumerate Lists in a Loop

Plenty of times, when you are looping with a for-each loop in python, you somehow realize that you need a counter. Then you most probably write something ugly like this one:

Why is this ugly? Mainly because the next

Tagged with: , , , ,

Python – Write a DataFrame or List to multiple tabs in Excel

The idea of the article is to provide a Python code that does the following: Takes a list or DataFrame; Splits it into quite a few smaller parts; Writes each one on a separate Excel worksheet; Pretty much like this:

Tagged with: , , , , ,

VBA – Split worksheet to worksheets, save Excel worksheets to csv

Same article, but for Python is here – https://www.vitoshacademy.com/python-split-worksheet-to-worksheets-save-excel-worksheets-to-csv/ This article does 2 things: Splits one worksheet to multiple worksheets Then goes through the worksheets and saves them as *.CSV files I hope that is enough for you. Ok, so

Tagged with: , , ,

VBA – Option Compare (Text || Binary || Database)

Option Compare  in VBA is the thing, that will save you ugly stuff like this one:

Yup, it is a bit ugly, using UCase  to compare all the time, between small letter text and big letter text. So, if you

Tagged with: , , , , ,

Python – Plotting a circle with matplotlib

Plotting a circle with matplotlib library in python is an interesting task. If you google it, you will find quite good answers, but anyway, I am here because I want to summarize my point of view. Pretty much, the idea

Tagged with: , , , , ,

VBA – Get Substring Between 2 Substrings – Locate value of Nth XML

Getting N-th string between two substrings might sound a bad idea, until you do not need it. And with VBA, you better have something prepared. So, imagine the following XML (from this article here):

Your task is to get

Tagged with: , , , , , , , ,

Python – dictionary to CSV

Dictionary to a CSV file is probably a good question, if you are hiring a VBA developer. For a python person it should be a trivial one, as this one should not be even a tough search in Google. Anyway,

Tagged with: , ,

How to get redirect url using Excel VBA or Python

Getting some tiny URL, that redirects you to somewhere else might be dangerous. There are a lot of people, that would never ever click on bit.ly/something or goo.gl/something, just because they do not know where the redirect is going to

Tagged with: , , , , , ,

Python – Find All Substrings Between Two Character Pairs with RegEx

Sometimes you need to do what you need to do – use Regular Expressions for a trivial task. Now, imagine that you have some big text and you need to extract all substrings from the text between two specific words

Tagged with: , , , ,

Python – Parsing PDFs with Tika

Reading from a pdf is actually quite an easy task with Python. If the PDF is of course “readable”, e.g. made from a word processor. The first thing to do is to install Tika and Java:

Having this, the

Tagged with: , , , ,

VBA – VLookup with Multiple Criteria in Excel without Excel Formula but with VBA

Ok, the title became too lengthy, but the idea is to try to duplicate the beauty of what this formula does:

And this is the cell of the formula above: Anyway, the strange thing was that we have beautiful

Migrate Vue project from Vue 2 to Vue 3

Bash Commands

Changes in src/main.js Additionally, change main.js  from this:

To this:

Changes in src/router/index.js After changes the code should be looking like this:

Changes in src/store/index.js This is how it should be looking:

Tagged with: ,

Python – Ordered Dictionary and Heap Queue

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.

Tagged with: , , , ,

Python – Read and Write to Excel ActiveX Textbox

Reading and writing to an Excel ActiveX textbox with Python can be fun. If you really do not have anything better to do. Anyway, if this is your current task, you are on the correct place to see how it

Tagged with: , , , , ,

Python – Docstring – Help and Comments

Docstrings in Python are actually quite simple – the are 3 times this """ and the code between opening and closing them can be formatted in any possible way. The reason I have decided to dedicate a whole article to

Tagged with: , , , , ,

Python – How to fill Excel cell with image, using python

If you have ever dreamed that it will be possible to fill out an Excel cell with a picture, using Python, then you should probably reevaluate your dreams. Seriously, who dreams of something like that? Without further dreaming, the code

Python – Logging in Python. Formatting with Black

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

Tagged with: , , ,

Python – Multisets – A class to count the elements of a set

Ok, so you probably have heard about set in Python – it is a collection with non-repeatable elements – as if you are a stamp collector and you need to collect only the unique stamps into your album. However, in

Tagged with: , ,

Python – Writing a Logger in Python with a decorator

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.

Tagged with: , ,
Top