In [56]:

    

import pandas as pd
import csv

file = input ("ENTER FILE NAME: ")
df = pd.read_csv(file)

if len(df) == 9:
    df = pd.read_csv(file,delimiter = ":")
    alt = 2
    df["TWO"][df ["ONE"]== 1] = 3 
    df["TWO"][df ["ONE"]== 2] = 4
    df["TWO"][df ["ONE"]== 3] = 6
    df["ONE"][df ["TWO"]== 3] = 1 
    df["ONE"][df ["TWO"]== 4] = 2
    df["ONE"][df ["TWO"]== 6] = 3
    
    
elif len(df) == 7:
    alt =1
    df['One']='a'
    df['Two']='b'
    df['Three']='c' 
    df['Four']='d'
else:
    alt == 3
    df['One']
    df['Two']
    df['Three']
    df['Four']
    df['Five']
    df['Six']
    df['Seven']
   
df.to_csv('DEST_NAE_ALT_' +str(alt)+'csv',index =False,sep='\t')


    

    




ENTER FILE NAME: source.csv

In [ ]:

    




    

In [ ]: