Menu
I have a Series of strings, the series looks like;
Series
"1, 2, 6, 7, 6"
"1, 3, 7, 9, 9"
"1, 1, 3, 5, 6"
"1, 2, 7, 7, 8"
"1, 4, 6, 8, 9"
"1"
I want to remove all elements apart from the first and last, so the output would look like;
Series
"1, 6"
"1, 9"
"1, 6"
"1, 8"
"1, 9"
"1"
To use Split(), do I need to loop over each element in the series? I've tried this but can't get the output I'm looking for.
497
Method: In Python, we can use the function split() to split a string and join() to join a string. the split() method in Python split a string into a list of strings after breaking the given string by the specified separator.
The str. split() function is used to split strings around given separator/delimiter. The function splits the string in the Series/Index from the beginning, at the specified delimiter string.
You can use split() function to split a string based on a delimiter to a list of strings. You can use join() function to join a list of strings based on a delimiter to give a single string.
Method 1: Split multiple characters from string using re. split() This is the most efficient and commonly used method to split multiple characters at once. It makes use of regex(regular expressions) in order to do this.
You can use split and rsplit to get the various parts:
result = [f"{x.split(',', 1)[0]},{x.rsplit(',', 1)[1]}" if x.find(',') > 0 else x
for x in strings]
If strings is a pd.Series object then you can convert it back to a series:
result = pd.Series(result, index=strings.index)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
