Slick Tutorials.
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 …
A common activity, on many IT environments, is to move/copy files from a system to another, usually in a scheduled mode. Let’s see how to do it with Powershell on Windows systems. Read More …
Dot-sourcing is a concept in PowerShell that allows you to reference code defined in one script in a separate one. This is useful when you’re working on a project with multiple scripts and might have functions specified in one script(s) and the code to call those functions in another. Other than building a module, dot-sourcing is a good way to make that code in another script available to you.
Read More …
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 …
SQL Server temp tables are very useful for temporary modifications or transformations to data that we do not need to keep rather than manipulate or work with permanent tables. Let’s say you want full DDL or DML access to a table, but don’t have it. You can use your existing read access to pull the data into a SQL Server temporary table and make adjustments from there. Read More …