How to remove trailling dots from pandas series?

Question

How to remove trailing dots from pandas series?

My attempt

import numpy as np
import pandas as pd

pd.set_option('max_colwidth',1000)

s = pd.Series(["""Finally a transparant silicon case ^^ Thanks to my uncle :) #yay #Sony #Xperia #S #sonyexperias… http://instagram.com/p/YGEt5JC6JM/"""])


s.str.replace(r'(\w)\.+',r'\1',regex=True)

My results

Finally a transparant silicon case ^^ Thanks to my uncle :) #yay #Sony #Xperia #S #sonyexperias… http://instagramcom/p/YGEt5JC6JM/


wanted:
Finally a transparant silicon case ^^ Thanks to my uncle :) #yay #Sony #Xperia #S #sonyexperia http://instagramcom/p/YGEt5JC6JM/

Those aren't multiple `.` characters, they're a single ellipsis character. — Barmar, Aug 31 '20 at 19:03

score 3 · Accepted Answer · answered Aug 31 '20 at 19:05

3

Those aren't periods, they're the ellipsis character, which is Unicode character \u2026. See How should I write three dots?

s.str.replace(r'(\w)\u2026+',r'\1',regex=True)

answered Aug 31 '20 at 19:05

Barmar

669,327
51
454
560

score 2 · Answer 2 · answered Aug 31 '20 at 19:07

Could you please try following, written as per shown samples.

pd.set_option('max_colwidth',1000)
s = pd.Series(["""Finally a transparant silicon case ^^ Thanks to my uncle :) #yay #Sony #Xperia #S #sonyexperias… http://instagram.com/p/YGEt5JC6JM/"""])
s.str.replace(r'…+',r'')

score 0 · Answer 3 · answered Aug 31 '20 at 19:05

As per suggestion of Barmar:

s = pd.Series(["""Finally a transparant silicon case ^^ Thanks to my uncle :) #yay #Sony #Xperia #S #sonyexperias… http://instagram.com/p/YGEt5JC6JM/"""])


s.str.replace(r'(\w)…',r'\1',regex=True)

Gives:
Finally a transparant silicon case ^^ Thanks to my uncle :) #yay #Sony #Xperia #S #sonyexperias http://instagram.com/p/YGEt5JC6JM/

How to remove trailling dots from pandas series?

My attempt

My results

3 Answers3