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 …

Excel – Remove Everything But Duplicate Rows

In Excel, we all know that, there will be a moment in which we need the opposite the people usually need on usual Excel worksheets: this is the case of searching and filtering, from a dataset, only duplicates values, removing the unique ones. Read More …

SQL Server – ANSI_Padding and Scripting from SSMS

Let’s say that you want to quickly create a table from an existing table in another database. If you are Read More …