Mercurial > repos > jay > pdaug_peptide_sequence_analysis
annotate PDAUG_Merge_Dataframes/PDAUG_Merge_Dataframes.py @ 7:44df12617f37 draft
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 32b9c48c81639a81be24bb3e2f48dc0a81c0deca"
author | jay |
---|---|
date | Sun, 09 Jan 2022 03:33:52 +0000 |
parents | b73ba641e514 |
children |
rev | line source |
---|---|
0
e59674e3a391
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 6f53ad797ec1af02b41510063a86bec7d121abf3"
jay
parents:
diff
changeset
|
1 import glob |
e59674e3a391
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 6f53ad797ec1af02b41510063a86bec7d121abf3"
jay
parents:
diff
changeset
|
2 import pandas as pd |
e59674e3a391
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 6f53ad797ec1af02b41510063a86bec7d121abf3"
jay
parents:
diff
changeset
|
3 import sys |
e59674e3a391
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 6f53ad797ec1af02b41510063a86bec7d121abf3"
jay
parents:
diff
changeset
|
4 |
4
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
5 |
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
6 def MergeData(infiles, add_class_label, class_label, OutPut): |
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
7 |
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
8 data_frame = pd.DataFrame() |
0
e59674e3a391
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 6f53ad797ec1af02b41510063a86bec7d121abf3"
jay
parents:
diff
changeset
|
9 |
4
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
10 if add_class_label == 'True' or add_class_label == 'true': |
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
11 for i, file in enumerate(infiles.split(',')): |
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
12 df1 = pd.read_csv(file,sep='\t') |
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
13 df2 = pd.DataFrame(df1.shape[0]*[i], columns=[class_label]) |
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
14 df3 = pd.concat([df1,df2], axis=1) |
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
15 data_frame = pd.concat([data_frame,df3]) |
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
16 final_DF = data_frame.fillna(0) |
0
e59674e3a391
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 6f53ad797ec1af02b41510063a86bec7d121abf3"
jay
parents:
diff
changeset
|
17 |
4
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
18 else: |
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
19 |
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
20 for file in infiles.split(','): |
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
21 df1 = pd.read_csv(file,sep='\t') |
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
22 data_frame = pd.concat([data_frame,df1]) |
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
23 final_DF = data_frame.fillna(0) |
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
24 |
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
25 final_DF.to_csv(OutPut, sep="\t", index=False) |
0
e59674e3a391
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 6f53ad797ec1af02b41510063a86bec7d121abf3"
jay
parents:
diff
changeset
|
26 |
e59674e3a391
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 6f53ad797ec1af02b41510063a86bec7d121abf3"
jay
parents:
diff
changeset
|
27 |
4
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
28 if __name__=="__main__": |
0
e59674e3a391
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 6f53ad797ec1af02b41510063a86bec7d121abf3"
jay
parents:
diff
changeset
|
29 |
4
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
30 import argparse |
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
31 parser = argparse.ArgumentParser() |
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
32 parser.add_argument("-I", "--infiles", required=True, default=None, help=".tsv") |
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
33 parser.add_argument("-L", "--add_class_label", required=False, default=False, help="Path to target tsv file") |
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
34 parser.add_argument("-C", "--class_label", required=False, default='class_label', help="Path to target tsv file") |
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
35 parser.add_argument("-O", "--OutPut", required=False, default='Out.tsv', help="Path to target tsv file") |
0
e59674e3a391
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 6f53ad797ec1af02b41510063a86bec7d121abf3"
jay
parents:
diff
changeset
|
36 |
4
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
37 args = parser.parse_args() |
0
e59674e3a391
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 6f53ad797ec1af02b41510063a86bec7d121abf3"
jay
parents:
diff
changeset
|
38 |
4
b73ba641e514
"planemo upload for repository https://github.com/jaidevjoshi83/pdaug commit 45ebf32dcaa1eed91670d3a2491f9cf3dfb535ef"
jay
parents:
0
diff
changeset
|
39 MergeData(args.infiles, args.add_class_label, args.class_label, args.OutPut) |