Mercurial > repos > jay > pdaug_merge_dataframes

view PDAUG_Merge_Dataframes/PDAUG_Merge_Dataframes.py @ 3:c47762435082 draft

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit edb37634e419f75dd66292e712de51278746d883"
author jay
date Wed, 30 Dec 2020 02:50:35 +0000
parents 5bb52d4bf172
children b5a9f541c6f8
line wrap: on
line source

import glob
import pandas as pd 
import sys

files = sys.argv[1]
out_file = sys.argv[2]


data_frame = pd.read_csv(files.split(',')[0],sep='\t')


for file in files.split(',')[1:]: 

    df1 = pd.read_csv(file,sep='\t')
    data_frame =  pd.concat([data_frame,df1])

final_DF = data_frame.fillna(0)

final_DF.to_csv(out_file,sep="\t", index=False)