Posts

Showing posts with the label Split Text

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 Split String: Techniques and Best Practices

Image
Here is an example for  splitting a string in Python . The functions you need are strip and split to split string, or text.  Here's the string taken for split My task is I want to split address string. Historically, the address is lengthy. It contains the door number, floor number, street number, and street name. Rama Krishna 20/3 ABC street EFG Nagar US 234567 How to Split a string The python split string works in two steps. The first step is to use  strip function , which removes both leading and trailing spaces. Next, use the the split function, which splits the input string, or text into a list. Python program user_address = input("Enter an address") if user_address. strip() : #check that string is not empty (after removing leading #and trailing spaces)     print("Your address is " + user_address) split_address = user_address. split() print(split_address) Output Interactively, it asks the user to enter the address. After the code runs, the address splits i