Posts

Showing posts with the label Calculate

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

Python How to Find Day of the Week

Image
DAY of the week Python code you will know here. One is from Calendar, and another one is from a function. Here, I have given my ideas on a better method. Also, the result you can get in a tuple. You might also like Attitude is Everything That Changes Your Life. Day of Week and Day_Name Monday 0 Tuesday 1 Wednesday 2 Thursday 3 Friday 4 Saturday 5 Sunday 6 Python: Day of Week How to Calculate 1. Python Logic to get Day of Week from Calendar from datetime import datetime import calendar dt = datetime.today() dn = dt.weekday() print ("Today is day number: {0}".format(dn)) print ("Today is a {0}".format(calendar.day_name[dn])) Here, the print uses string.format method to print output. Check out   the best example to use this method . The Output The result from the first logic Instead of directly using DateTime, you can write a function - that creates a tuple with Day of week and Day name. 2. Python Logic to get Day and Day_name  User defined function from datetime i