代码如下:
-*- coding:utf-8 -*-
import numpy as np
import pandas as pd
from collections import Counter
from sklearn import preprocessing
import scipy
import sys
import os
path1=os.path.abspath('.')
print(path1)
name=pd.read_table("genotype.sav",header=0,sep=',')
print(name)
print(name.columns)
for i in name.columns:
a,b,c=Counter(name[i]).keys()
if a[0]==a[1]:
#print(keys[0],keys[1])
name[i].replace(a, 0, inplace=True)
name[i].replace(b, 1, inplace=True)
name[i].replace(c, 2, inplace=True)
elif a[0]!=a[1]:
name[i].replace(a, 1, inplace=True)
name[i].replace(b, 0, inplace=True)
name[i].replace(c, 2, inplace=True)
#print(keys)
#print(name[i])
name.to_csv('rename.csv')
#recode_ID()