In this tutorial, we will learn to use the Pandas function pivot_table(). This function is used to create a pivot table as a data frame. It allows for lots of customization possibilities to provide informative insights into our data. Syntax Table Here are the parameters from the official documentation: Parameter Type Description data DataFrame values … Read more
PowerShell foreach Loop Syntax: The keyword ‘foreach‘ is used in Windows PowerShell to iterate through a series or list of items, usually with the intent of performing operations using each item. Example: In the following example, we use PowerShell to read the contents of a text file (C:\Temp\ServerList.txt) filled with server names, storing the values … Read more
Problema: Se dan dos listas l1 y l2. Quieres realizar una de las siguientes acciones: 1. Comparación booleana: comparar las listas por elementos y devolver True si la métrica de comparación devuelve True para todos los pares de elementos y False en caso contrario. 2. Diferencia: encontrar la diferencia entre los elementos de la primera … Read more
Mutable Data Types The objects whose values can change after the creation of the objects are known as mutable data types. The values can be changed — you can’t add an item to the object, delete an item from the object, or change any value in the object with another value. Sets are mutable. Lists … Read more
Python Mutliline Strings In this article we are going to look at how to properly indent your code for Python multiline strings, so let’s start by clarifying what a multiline string is and why indentation is important. Readability for other users is one of the key requirements of writing effective Python code, so having a … Read more
The Pandas DataFrame is a data structure that organizes data into a two-dimensional format. If you are familiar with Excel or Databases, the setup is similar. Each DataFrame contains a schema that defines a Column (Field) Name and a Data Type. This article delves into the methods available for DataFrame Indexing. This article also … Read more
The Pandas DataFrame is a data structure that organizes data into a two-dimensional format. If you are familiar with Excel or Databases, the setup is similar. Each DataFrame contains a schema that defines a Column (Field) Name and a Data Type. Below is the Database Schema for our Hockey Teams example. This article delves into … Read more
The Pandas DataFrame is a data structure that organizes data into a two-dimensional format. If you are familiar with Excel or Databases, the setup is similar. Each DataFrame contains a schema that defines a Column (Field) Name and a Data Type. Below is an example of a Database Schema for Employees of the Finxter Academy. … Read more
XML stands for Extensible Mark-Up Language. This language is another way to store data. Python can parse, modify and store this file with the appropriate libraries installed. This article covers the commonly used parameters for each function listed above. For a complete list of all parameters and their use, click here. Preparation Before any data … Read more
In my previous article, we looked at how to set up Brownie, create a project with a simple smart contract, interact with it on a local blockchain and run a unit test. If you haven’t read it yet, please check the following link. Brownie – Smart Contracts in Python Now, we are ready to deploy … Read more
In this tutorial, we will learn how to read and write flat files with Pandas. We will learn what a flat file is, how to read a flat file using the Pandas functions read_csv() and read_table(), how these two functions differ from each other, and how to write a data frame to a CSV file. … Read more
In this tutorial, we will learn how to use the Pandas melt() function which turns a wide data frame into a long one. The function unpivots selected parts of the data frame, so these columns get turned into rows. Here are the parameters from the official documentation: Parameter Type Description id_vars tuple, list, or ndarray, … Read more