22 Dec Remove Whitespace or specific characters tin Pandas
To remove whitespace (including newlines) or specific characters on text data in a Series or DataFrame, use the following methods in Python Pandas:
- strip(): Strip whitespace (including newlines) or specific characters from the left and right
- lstrip(): Strip whitespace (including newlines) or specific characters from only the left side
- rstrip(): Strip whitespace (including newlines) or specific characters from only the right side
strip() method
To strip whitespace (including newlines) or specific characters from both the left and right side of values in a Series or DataFrame, use the strip() method in Pandas. Let us see an example:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
# strip() method in Python Pandas # Code by Studyopedia import pandas as pd # Data to be stored in the Pandas Series data = ["!Jacob", "Amit\n\n", "Trent", "Nathan\t", "Martin"] # Create a Series using the Series() method series = pd.Series(data) # Display the Series print("Series:\n", series) # Strip the values print("\nStrip from both the sides\n",series.str.strip("!\n\t")) |
Output
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
Series: 0 !Jacob 1 Amit\n\n 2 Trent 3 Nathan\t 4 Martin dtype: object Strip from both the sides 0 Jacob 1 Amit 2 Trent 3 Nathan 4 Martin dtype: object |
lstrip() method
To strip whitespace (including newlines) or specific characters from the left side of values in a Series or DataFrame, use the lstrip() method in Pandas. Let us see an example:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
# lstrip() method in Python Pandas # Code by Studyopedia import pandas as pd # Data to be stored in the Pandas Series data = ["!Jacob", "\n\tAmit\n\n", "!Trent!", "Nathan\t", "Martin"] # Create a Series using the Series() method series = pd.Series(data) # Display the Series print("Series:\n", series) # Strip from the left print("\nStrip from the left side:\n", series.str.lstrip("!\n\t")) |
Output
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
Series: 0 !Jacob 1 \n\tAmit\n\n 2 !Trent! 3 Nathan\t 4 Martin dtype: object Strip from the left side: 0 Jacob 1 Amit\n\n 2 Trent! 3 Nathan\t 4 Martin dtype: object |
rstrip() method
To strip whitespace (including newlines) or specific characters from the right side of values in a Series or DataFrame, use the rstrip() method in Pandas. Let us see an example:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
# rstrip() method in Python Pandas # Code by Studyopedia import pandas as pd # Data to be stored in the Pandas Series data = ["!Jacob", "\n\tAmit\n\n", "!Trent!", "Nathan\t", "Martin"] # Create a Series using the Series() method series = pd.Series(data) # Display the Series print("Series:\n", series) # Remove characters from the right side print("\nRemove from the right:\n", series.str.rstrip("\n\t!")) |
Output
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
Series: 0 !Jacob 1 \n\tAmit\n\n 2 !Trent! 3 Nathan\t 4 Martin dtype: object Remove from the right: 0 !Jacob 1 \n\tAmit 2 !Trent 3 Nathan 4 Martin dtype: object |
If you liked the tutorial, spread the word and share the link and our website Studyopedia with others.
For Videos, Join Our YouTube Channel: Join Now
Read More:
No Comments