Excel – Create and add a custom Ribbon Tab (Menu)

Adding a custom tab into a specific Office document (2007+ documents) can be very useful if we need to transport, with the document, custom VBA/macro codes. Read More …

What are Data URLs?

A Data URL is a URI scheme that provides a way to inline data in a document, and it’s commonly used to embed images in HTML and CSS. Data URLs are a form of Uniform Resource Locators, although they do not in fact remotely locate anything. Instead, the resource data is contained within the URL string itself as a base64-encoded string. This saves the browser from having to make additional HTTP requests for the external resources, and can thus increase page loading speed. Read More …

Python – Pandas – Using Dictionary to remap values in Dataframe

While working with data in Pandas, we perform a vast array of operations on the data to get the data in the desired form, before, for example, creating diagrams or passing to the visualization phase. One of these operations could be that we want to remap the values of a specific column in the Dataframe. This can be done in several ways. Read More …

Python – Pandas – Converting XLSX to Dictionary (key and values)

During data import process in a Jupyter Notebook, using Python and Pandas module for data science, we would need to manipulate or import directly an Excel file into a notebook and transfor all the data into a dictionary, so in this article we will focus on this particular need. Read More …