How to Delete the ".pdf" from file names I've Pulled With OS Module

Question

I've used the os module to pull file names and created a DataFrame from the titles like this:

   Invoice              Vendor       Amount
0     2131           FileName1    68.00.pdf
1     2132           FileName2    68.00.pdf

How can I delete the .pdf from the amounts so I can find the sum of that column?

score 2 · Answer 1 · answered Sep 02 '22 at 14:00

2

df['Amount'] = df['Amount'].str.rstrip('.pdf')

answered Sep 02 '22 at 14:00

Tom McLean

1

Just as a note [str.rstrip](https://pandas.pydata.org/docs/reference/api/pandas.Series.str.rstrip.html) takes a "set of characters to be removed". This command is removing any of the characters `.`, `p`, `d`, or `f` from the right side of strings. This likely _not_ the desired behaviour in most circumstances. _e.g._ the result of `pd.Series(['a.pdf', 'j.xlf', 'cap', 'q.d.f.p']).str.rstrip('.pdf')` is 'a', 'j.xl', 'ca', 'q'. – Henry Ecker Sep 02 '22 at 22:33

score 0 · Answer 2 · answered Sep 02 '22 at 14:00

0

df['Amount']=df['Amount'].str.replace('.pdf','',regex=True)
df

Invoice     Vendor  Amount
0   2131    FileName1   68.00
1   2132    FileName2   68.00

answered Sep 02 '22 at 14:00

Naveed

2 Answers2