eset2keggscape.py

import pandas as pd

df = pd.read_csv("./eLeuRMA.txt", sep='\t')
gene_df = df[df['Unnamed: 0'].str.contains(pat='b[0-9]{4}')]
foo = gene_df['Unnamed: 0'].str.extract(r'(b[0-9]{4})')
foo = foo[0].str.replace("b", "eco:b")
gene_df.update(foo.rename('Unnamed: 0'))
gene_df.columns = gene_df.columns.str.replace("/home/laurent/Affymetrix_data/ecoli_sample//", "")
gene_df.columns = gene_df.columns.str.replace("Unnamed: 0", "keggids")
gene_df.to_csv('ecoliLeucineRMA.csv', index=False)