In [63]:

    

import csv
import pandas as pd
import numpy as np


    

In [64]:

    

### load
fpath = "2018-01-24_E14_X31_pep.gal"
fpath_vir = "2018-01-24_E14_X31_vir.gal"

this_gal = pd.read_csv(fpath, sep='\t', index_col="ID", dtype=str)


# rewrite row
def new_row(block, old_row):
    return ((block-1)*12) + old_row


    

In [65]:

    

#change 'blank'
this_gal.replace(['blank'], ['NO'], inplace=True)

#new row
this_gal["NewRow"] = new_row(this_gal["Block"].astype(int),this_gal["Row"].astype(int))
this_gal["Row"] = this_gal["NewRow"]
del this_gal["NewRow"]

# change index
this_gal.index = [i for i, _ in enumerate(this_gal["Block"])]


    

In [66]:

    

this_gal.to_csv("new_"+fpath, sep='\t', index=True,index_label='ID' )


    

In [67]:

    

virus_gal = this_gal
virus_gal["Name"]='X31A'
virus_gal.to_csv("new_"+fpath_vir, sep='\t', index=True, index_label='ID' )


    

In [ ]: