Mercurial > repos > jay > pdaug_merge_dataframes

view PDAUG_Merge_Dataframes/PDAUG_Merge_Dataframes.py @ 0:5bb52d4bf172 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 a9bd83f6a1afa6338cb6e4358b63ebff5bed155e"
author jay
date Wed, 28 Oct 2020 01:54:31 +0000
parents
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)