Pandas find column contains a certain value

In this article, we learn how to find columns containing a certain value in pandas. This is a very common scenario you came across during deployment. Suppose you have a data frame having the following columns – import pandas as pd1 df = pd1.DataFrame({    ‘A’: [1, 5, 7, 1, 5],    ‘B’: [2, 5,In this article, we learn how to find columns containing a certain value in pandas. This is a very common scenario you came across during deployment. Suppose you have a data frame having the following columns – import pandas as pd1 df = pd1.DataFrame({    ‘A’: [1, 5, 7, 1, 5],    ‘B’: [2, 5, […]

Read More…

Convert SQL query result to Pandas DataFrame using Python

In this article, I’ll show you How to convert a SQL query result to pandas DataFrame using python script. Python has a pandas library that provides the high-level interface to the data that exist in SQL Database.   Businesses can use this data analysis tool for data visualization and data analytics. For the demo purpose,In this article, I’ll show you How to convert a SQL query result to pandas DataFrame using python script. Python has a pandas library that provides the high-level interface to the data that exist in SQL Database.   Businesses can use this data analysis tool for data visualization and data analytics. For the demo purpose, […]

Read More…

Copy a file using PowerShell

In this tutorial, I show you how you can copy a file using PowerShell from one location to another location. I also show you how to copy a file to multiple servers using PowerShell. Copy a file using PowerShell from one location to another The copy-item cmdlet is used to copy an item or fileIn this tutorial, I show you how you can copy a file using PowerShell from one location to another location. I also show you how to copy a file to multiple servers using PowerShell. Copy a file using PowerShell from one location to another The copy-item cmdlet is used to copy an item or file […]

Read More…

Python loop through files in directory

The files are placed in directories or subdirectories in OS and this is a very common scenario when you have to iterate files over a particular directory using python. In this tutorial, I show you how to use python to loop through files in a directory recursively or non-recursively. Python provides several built-in methods orThe files are placed in directories or subdirectories in OS and this is a very common scenario when you have to iterate files over a particular directory using python. In this tutorial, I show you how to use python to loop through files in a directory recursively or non-recursively. Python provides several built-in methods or […]

Read More…

Map function in JavaScript

In this tutorial, we learn how to use the map function in JavaScript to manipulate arrays. The map function is one of the most commonly used functions to manipulate array elements. The map() method iterates an array and modifies the array elements using the callback method and returns the new array. Learn How to useIn this tutorial, we learn how to use the map function in JavaScript to manipulate arrays. The map function is one of the most commonly used functions to manipulate array elements. The map() method iterates an array and modifies the array elements using the callback method and returns the new array. Learn How to use […]

Read More…

Check if value exists in array JavaScript ES6

While writing code it is often seen that when we have to find out whether a value array may exist or not. In Javascript, there are several ways to check whether a particular value exists in the array. In this tutorial, I show you all the possible ways to check if a value exists inWhile writing code it is often seen that when we have to find out whether a value array may exist or not. In Javascript, there are several ways to check whether a particular value exists in the array. In this tutorial, I show you all the possible ways to check if a value exists in […]

Read More…