/Python/Pandas string manipulation on column

Pandas string manipulation on column

In [21]:

def func(string):
    a_new_string =string.replace('- ','_')
    a_new_string1 =a_new_string.replace('-','_')
    a_new_string2= a_new_string1.rstrip(' months')
    return a_new_string2

df['Time'] = df['Time'].apply(func)
df
Out[21]:
    Time
0    2_3
1    1_2
2  10_11
3    4_5

Source: stackoverflow.com

Similar codes

10 votes314 views3 answers
Pacman 30th anniversary
Python
2 votes314 views1 answer
Python numpy array replace nan with string
Python
1 vote367 views1 answer
Hex to binary python3
Python
0 vote399 views1 answer
Seaborn pandas annotate
Python
0 vote345 views1 answer
"get_or_create" takes 1 positional argument but 2 were given
Python
0 vote336 views1 answer
Jupyter notebook not showing all null values
Python
0 vote329 views1 answer
List of files to zip python
Python
0 vote317 views1 answer
Using built-in crawlers is very simple. A minimal example is shown as follows.
Python
2 votes329 views3 answers
Rotate matrix 90 degrees clockwise python
Python
5 votes326 views2 answers
Python pie chart
Python