In [1]:

    

import pandas as pd 
file = input("Enter the name of the file: ")
row, col = (pd.read_csv(file).shape)

for _ in file:
    if row == 7:
        df = pd.DataFrame([["a","b","c","d"]]*7,columns = ['One','Two','Three','Four'])
        df.to_csv('Dest_sc_alt1.tsv',index=False, sep = '\t')
        
    elif row == 9:
        df = pd.read_csv(file, delimiter=':')
        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
        df.to_csv('Dest_sc_alt2.tsv',index=False, sep = '\t')

    elif row == 3:
        df = pd.DataFrame([["1","2","3","4","5","6","7"]]*3,columns = ['One','Two','Three','Four', 'Five','Six','Seven'])
        df.to_csv('Dest_sc_alt3.tsv',index=False, sep = '\t')


    

    




Enter the name of the file: "alt2.csv"

In [ ]: