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 …

Javascript / jQuery – Validation of file size while uploading

The following is a demonstration of client-side validation and is implemented to provide a nice user experience. In some cases, client-side validation is a much better method in comparison to the server-side method as it consumes less time. Read More …

Ubuntu – What is netplan?

Since Ubuntu 18.04 LTS has switched to Netplan for configuring network interfaces. Netplan is based on YAML based configuration system that makes configuration process very simple. Using netplan gives a central location to describe simple to complex networking configurations that function from Desktop to Server and from Cloud to IoT environments. 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 …