Drawing a Boxplot With Pandas

Introduction A Boxplot is a graphical representation of a data distribution in a dataset based on a five-number summary which are the minimum, maximum, median (50th percentile), first quartile (25th percentile) and third quartile (75th percentile). It was introduced by John Tukey in his classic

vb.net IDE

A Guide to Commands in Visual Basic

What is a Command? A command is a specific instruction given to a computer application to perform a task or function. When referring to a programming language, a command is a unique word/keyword used to perform a specific operation. Unlike variables, which are named and

How to Use CountIf in VBA

In Excel, the function CountIf is used to count how many times a condition has been met within a worksheet range. However, to use this function while writing VBA code, we need to change it from CountIf to WorksheetFunction.CountIf. The full syntax of the function

option explicit is automatically filled in

Everything About Option Explicit in VBA

As a developer, it is a good practice to declare your variables in a script/code so that you immediately get the source of an error when running it. Option Explicit is used in VBA precisely to make the defining of variables mandatory while writing code.

convert table dialog box

How to Convert a Word or Excel Table to Text

The Table object in Excel and Word is underutilized by most users and developers of Excel and Word, in my not-so-humble opinion. For example, an Excel Table object with formulas calculates faster and takes less storage space than does the comparable normal range. As useful

scraping from wikipedia

GetElementById in VBA

Visual Basic for Applications allows you to get data and information from websites. This is called ‘web scraping’. Web pages are written in a markup language called HTML. Anything that interests you in a webpage can be retrieved once we know which HTML element it