Featured Post

How to Check Column Nulls and Replace: Pandas

Image
Here is a post that shows how to count Nulls and replace them with the value you want in the Pandas Dataframe. We have explained the process in two steps - Counting and Replacing the Null values. Count null values (column-wise) in Pandas ## count null values column-wise null_counts = df.isnull(). sum() print(null_counts) ``` Output: ``` Column1    1 Column2    1 Column3    5 dtype: int64 ``` In the above code, we first create a sample Pandas DataFrame `df` with some null values. Then, we use the `isnull()` function to create a DataFrame of the same shape as `df`, where each element is a boolean value indicating whether that element is null or not. Finally, we use the `sum()` function to count the number of null values in each column of the resulting DataFrame. The output shows the count of null values column-wise. to count null values column-wise: ``` df.isnull().sum() ``` ##Code snippet to count null values row-wise: ``` df.isnull().sum(axis=1) ``` In the above code, `df` is the Panda

Unix: How to Write Shell Script Using vi Editor

Unix Commands
Stockphotos.io
When you login into UNIX, you are first in the home directory:

$/home:

Then you can issue

$/home: cd jthomas

Then you come to your own directory:

$/home/jthomas:

How to write your first script:
$/home/jthomas: vi test.sh

Here, you can write your script.
The first line in the script is:

#!/bin/ksh - It denotes which shell you are going to use.

Example:

$vi test.sh

 #!/bin/ksh 
################################################### # 
Written By: Jason Thomas # Purpose: This script was written to show users 
how to develop their first script 
################################################### # Denotes a comment

root

daemon bin sys adm uucp nobody lpd

How to run a script

$ sh test.sh

Also read: The complete list of UNIX basic commands

Comments

Popular posts from this blog

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers

6 Python file Methods Real Usage