Python – What is a Dataframe?

A dataframe is a two-dimensional data structure, i.e., data is aligned in a tabular fashion in rows and columns, exactly as you would see in a classic Excel spreadsheet. In other terms, Pandas DataFrame is nothing but an in-memory representation of an Excel sheet via Python programming language.
Read More …

Searching through files for matching text strings (Powershell)

Let’s see some Powershell ways to search for text or files, also in Word and Excel programs, on a Windows system (server and client). A scripting way to this common tedious activity (searching for files and text in files) would be useful to not waste time, most of the time. 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 …