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 …

Powershell – Get Permissions on folders and/or files

Sometimes it is useful to get permissions (NTFS and/or Share) on Windows systems (Server and/or Client). The following Powershell code will generate, in the same folder in which is saved the ps1 file (once the below code is copied and saved on the system as ps1 file), a CSV file which will include all the permissions (subfolders included) set in that moment. Read More …

Sharepoint – Unlock and Delete a locked Library

Sometimes, some of the libraries and lists in SharePoint, both online and on-premises, might get locked for deletion, meaning you cannot delete them by any means, this is particularly through for Record libraries. Let’s see how to unlock and/or delete a locked library on a Sharepoint site. Read More …