Python-сообщество

import re
#X = xls.copy().head(2)
# Y = X['number'].to_string()
#for row in X:
#    Y = X.to_string()
#    y_n = (''.join(re.split('"[a-zA-Z0-9]+"', Y))) #"[a-zA-Z0-9]+"
#         return y_n
#    X['number'] = y_n
X

  
import re
 
text = xls['number'].copy().head(2)
text = text.to_string()
pat = r' "[a-zA-Z0-9]+"'
rep = 'DD'
 
out = re.sub(pat, rep, text)

X['number'] = out
X

  
>>> import re
>>> 
>>> text = 'abc def (ghi) jkl(lmn) opq'
>>> pat = r' \([^)]+\)'
>>> rep = 'X'
>>> 
>>> out = re.sub(pat, rep, text)
>>> 
>>> text
'abc def (ghi) jkl(lmn) opq'
>>> out
'abc defX jkl(lmn) opq'
>>>

  
import re
 
text = xls['number'].copy().head(5)
text = text.to_string()
pat = r'\([^)]+\)'
rep = ''
 
out = re.sub(pat, rep, texts)

xls['number'] = out

xls

  
>>> import re
>>> 
>>> text = 'abc (def) ghi'
>>> pat = r'(\()([^)]+)(\))'
>>> rep = r'\g<1>\g<1>\g<2> \g<2> \g<2>\g<3>\g<3>'
>>> 
>>> out = re.sub(pat, rep, text)
>>> 
>>> text
'abc (def) ghi'
>>> out
'abc ((def def def)) ghi'
>>>

X = xls['number'].copy().head(5)
text = X.to_string()
pat = r'(\()([^)]+)(\))'
rep = r''
out = re.sub(pat, rep, text)

X['number'] = out

  
>>> import pandas as pd
>>> 
>>> df = pd.DataFrame(data=[{'a': 1, 'b': 2, 'c': 3}], index=range(3))
>>> df
   a  b  c
0  1  2  3
1  1  2  3
2  1  2  3
>>> 
>>> import json
>>> 
>>> dct = json.loads(df.to_json())
>>> dct
{'a': {'0': 1, '1': 1, '2': 1}, 'b': {'0': 2, '1': 2, '2': 2}, 'c': {'0': 3, '1': 3, '2': 3}}
>>> 
>>> dct['c']['0'] *= 2
>>> dct
{'a': {'0': 1, '1': 1, '2': 1}, 'b': {'0': 2, '1': 2, '2': 2}, 'c': {'0': 6, '1': 3, '2': 3}}
>>> 
>>> out = pd.DataFrame(dct)
>>> out
   a  b  c
0  1  2  6
1  1  2  3
2  1  2  3
>>>