Mercurial > repos > jay > pdaug_merge_dataframes

view PDAUG_Merge_Dataframes/PDAUG_Merge_Dataframes.py @ 2:728e04b97852 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 8b18552f6d2b2261efebe1075ff4c18a295b94dd"
author jay
date Tue, 29 Dec 2020 18:20:59 +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)