In [1]:

data='''taxonomy	coverage
ko04141,map04141	338.586386
ko00970,map00970 	338.586386
ko00970,map00970	338.586386'''
%store data >test_data.txt

Writing 'data' (str) to file 'test_data.txt'.

In [2]:

import pandas as pd 
df51 = pd.read_csv("test_data.txt",sep="\t")

In [3]:

df51

Out[3]:

In [5]:

def split_at_comma_n_get_2nd(item):
    parts = item.split(",")
    return parts[1]
df51.taxonomy = df51.taxonomy.apply(split_at_comma_n_get_2nd)

In [6]:

df51

Out[6]:

In [7]:

# reset back to 'unfixed'
import pandas as pd 
df51 = pd.read_csv("test_data.txt",sep="\t")

In [8]:

df51.taxonomy = df51.taxonomy.apply(lambda x: x.split(',')[1])
df51

Out[8]:

In [ ]: