delete all last string of DataFrame

Question

Here is a column of my dataframe.

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

It is always recommended to post your samples in text format NOT in image formats, kindly edit your post by posting sample input and expected output sample in code tags. — RavinderSingh13
– RavinderSingh13, Commented Dec 7, 2018 at 2:12
Based on your comments to the answers, you want 28, not 28g. Please update the question accordingly. it is misleading. — DYZ
– DYZ, Commented Dec 7, 2018 at 3:02

meW · Accepted Answer · 2018-12-07 02:01:33Z

2

Use replace:

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

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

answered Dec 7, 2018 at 2:01

meW

3,97710 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

G.M Over a year ago

tell me you know how I can do to remove the "g" from the "28 g"?

meW Over a year ago

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

sacuL · Accepted Answer · 2018-12-07 02:03:18Z

1

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

answered Dec 7, 2018 at 2:03

sacuL

51.6k9 gold badges88 silver badges115 bronze badges

1 Comment

G.M Over a year ago

@ sacul thank you. but tell me you know how I can do to remove the "g" from the "28 g"?

BENY · Accepted Answer · 2018-12-07 02:16:57Z

1

Using split

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

answered Dec 7, 2018 at 2:16

BENY

324k22 gold badges176 silver badges250 bronze badges

2 Comments

G.M Over a year ago

@ W-B thank you, but tell me you know how I can do to remove the "g" from the "28 g"?

BENY Over a year ago

@G.M df.serving_size.str.split(' ').str[0]

Collectives™ on Stack Overflow

delete all last string of DataFrame

3 Answers 3

2 Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related