Replacing the first string character in python 3

Question

i have a pandas series like this:

0          $233.94
1          $214.14
2          $208.74
3          $232.14
4          $187.15
5          $262.73
6          $176.35
7          $266.33
8          $174.55
9          $221.34
10         $199.74
11         $228.54
12         $228.54
13         $196.15
14         $269.93
15         $257.33
16         $246.53
17         $226.74

i want to get rid of the dollar sign so i can convert the values to numeric. I made a function in order to do this:

def strip_dollar(series):
    for number in dollar:
        if number[0] == '$':
            number[0].replace('$', ' ')

    return dollar

This function is returning the original series untouched, nothing changes, and i don't know why.

Any ideas about how to get this right?

Thanks in advance

nonono :). You shuld use pd.to_numeric() but replace $ first. — Anton vBR
– Anton vBR, Commented Jul 3, 2018 at 12:22
replace is String function so first you should convert the values to string and then you replace — Diego Vinícius
– Diego Vinícius, Commented Jul 3, 2018 at 12:28

jezrael · Accepted Answer · 2018-07-03 12:32:07Z

6

Use lstrip and convert to floats:

s = s.str.lstrip('$').astype(float)
print (s)
0     233.94
1     214.14
2     208.74
3     232.14
4     187.15
5     262.73
6     176.35
7     266.33
8     174.55
9     221.34
10    199.74
11    228.54
12    228.54
13    196.15
14    269.93
15    257.33
16    246.53
17    226.74
Name: A, dtype: float64

Setup:

s = pd.Series(['$233.94', '$214.14', '$208.74', '$232.14', '$187.15', '$262.73', '$176.35', '$266.33', '$174.55', '$221.34', '$199.74', '$228.54', '$228.54', '$196.15', '$269.93', '$257.33', '$246.53', '$226.74'])
print (s)
0     $233.94
1     $214.14
2     $208.74
3     $232.14
4     $187.15
5     $262.73
6     $176.35
7     $266.33
8     $174.55
9     $221.34
10    $199.74
11    $228.54
12    $228.54
13    $196.15
14    $269.93
15    $257.33
16    $246.53
17    $226.74
dtype: object

edited Jul 3, 2018 at 12:32

answered Jul 3, 2018 at 12:22

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

1 Comment

Miguel 2488 Over a year ago

Thank you a lot for your help @jezrael. I marked this answer as correct because i didn't know the lstrip method. Nice and clever. Thanks!! :)

Rakesh · Accepted Answer · 2018-07-03 12:22:47Z

2

Using str.replace("$", "")

Ex:

import pandas as pd
df = pd.DataFrame({"Col" : ["$233.94", "$214.14"]})
df["Col"] = pd.to_numeric(df["Col"].str.replace("$", ""))
print(df)

Output:

      Col
0  233.94
1  214.14

answered Jul 3, 2018 at 12:22

Rakesh

82.9k17 gold badges86 silver badges122 bronze badges

Comments

Pujan Mehta · Accepted Answer · 2018-07-03 12:38:31Z

2

CODE:

ser = pd.Series(data=['$123', '$234', '$232', '$6767'])
def rmDollar(x):
    return x[1:]
serWithoutDollar = ser.apply(rmDollar)
serWithoutDollar

OUTPUT:

0     123
1     234
2     232
3    6767
dtype: object

Hope it helps!

answered Jul 3, 2018 at 12:38

Pujan Mehta

5085 silver badges8 bronze badges

Collectives™ on Stack Overflow

Replacing the first string character in python 3

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related