CODEWITHSUNDEEP
pythonpandas
G.M
G.M

Reputation: 69

delete all last string of DataFrame

Here is a column of my dataframe.

enter image description here

I want to select for example for the first image 28g and delete (1 ONZ). how can I do ?

Upvotes: 0

Views: 66

Answers (3)

BENY
BENY

Reputation: 323266

Using split

df.serving_size.str.split('(').str[0]
0    NaN
1    28g
2    28g
Name: serving_size, dtype: object

Upvotes: 1

sacuL
sacuL

Reputation: 51335

You can extract everything outside of the parentheses:

# original df
>>> df
      serving_size
0              NaN
1     28 g (1 ONZ)
2  28 g (0.25 cup)

>>> df.serving_size.str.extract('(.*)\(.*\)')
0      NaN
1    28 g 
2    28 g 
Name: serving_size, dtype: object

Upvotes: 1

meW
meW

Reputation: 3967

Use replace:

df.serving_size.str.replace('\(.*','')

0     NaN
1    28g 
2    28g 
3    28g
4    35g
5    52g
Name: serving_size, dtype: object

Upvotes: 2

Related Questions