Is there a quick way in python to convert a string '1/100' to float 0.01?

Question

I have this df:

    Home    Away    5+ corners  6+ corners  7+ corners  8+ corners  9+ corners  10+ corners 11+ corners 12+ corners 13+ corners 14+ corners
0   Aston Villa Leeds   1/100   1/50    1/20    1/8 1/4 4/9 4/6 11/10   13/8    5/2
1   West Ham    Manchester City 1/100   1/33    1/12    1/6 1/3 4/7 10/11   11/8    2/1 3/1
2   Fulham  Crystal Palace  1/66    1/33    1/10    1/5 2/5 4/6 11/10   7/4 5/2 4/1
3   Manchester Utd  Chelsea 1/66    1/33    1/8 1/5 2/5 8/11    11/10   15/8    11/4    4/1
4   Liverpool   Sheffield Utd   1/100   1/50    1/20    1/8 2/7 4/9 8/11    11/10   7/4 5/2
5   Southampton Everton 1/66    1/33    1/12    1/5 4/11    8/13    1/1 13/8    5/2 7/2
6   Wolves  Newcastle   1/50    1/20    1/8 2/7 1/2 4/5 5/4 2/1 3/1 5/1
7   Arsenal Leicester   1/100   1/33    1/12    1/6 1/3 1/2 10/11   11/8    2/1 3/1
8   Brighton    West Brom   1/66    1/33    1/8 1/4 2/5 4/6 11/10   7/4 11/4    4/1
9   Burnley Tottenham   1/100   1/33    1/12    1/6 1/3 4/7 10/11   11/8    9/4 3/1

which I would like to convert to decimal odds.

I know i could use .split('/') to achieve this but was wondering if there was a quicker way to do this.

@n1c9 literal_eval won't do expressions. i.e. it can do `"5"`, but not `"5 + 1"`. — John Gordon, Oct 23 '20 at 17:06
ah, thanks for the correction - will remove my comment. Guess that's part of what makes it safer :P — n1c9, Oct 23 '20 at 17:07

score 1 · Accepted Answer · answered Oct 23 '20 at 17:04

1

As suggested by @ch3steR, use pd.eval and try this

df['col_name'] = pd.eval(target=df, expr=df['col_name'])

answered Oct 23 '20 at 17:04

Ajay A

1,030
1
7
19

If this solved your problem, Please accept it as answer – Ajay A Oct 24 '20 at 05:36

mzndr · Answer 2 · 2020-10-23T16:54:00.310

0

What about the eval function?

result = eval('1/2')

Edit: As commenters have pointed out, eval has security concerns, since it has the potential to execute arbitrary code.

edited Oct 23 '20 at 16:54

answered Oct 23 '20 at 16:38

mzndr

91
8

Normal eval does not work in pandas dataframe, instead look for df.eval() – Wasif Oct 23 '20 at 16:48
In addition, `eval()` has a lot of security concerns (the user being able to delete all your files, as the famous example) – Collin Heist Oct 23 '20 at 16:49
Must be ast.literal_ eval – Sergey Bushmanov Oct 23 '20 at 16:59

Shijith · Answer 3 · 2020-10-23T18:13:48.550

you can use pandas apply and eval together

df.loc[:,'5+ corners':] = df.loc[:,'5+ corners':].apply(pd.eval)

>>> print(df)
>>>
        Home            Away     5+ corners  ... 12+ corners 13+ corners 14+ corners
0     AstonVilla           Leeds       0.01  ...         1.1       1.625         2.5
1        WestHam  ManchesterCity       0.01  ...       1.375           2           3
2         Fulham   CrystalPalace  0.0151515  ...        1.75         2.5           4
3  ManchesterUtd         Chelsea  0.0151515  ...       1.875        2.75           4
4      Liverpool    SheffieldUtd       0.01  ...         1.1        1.75         2.5

This will only work for dataframe upto 100 rows , refer here

Is there a quick way in python to convert a string '1/100' to float 0.01?

3 Answers3