-
Notifications
You must be signed in to change notification settings - Fork 3
/
csv-combine.py
37 lines (33 loc) · 882 Bytes
/
csv-combine.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
import os
import csv
hdr = '"FRPline" ' \
'"FRPsample" ' \
'"FRPlats" ' \
'"FRPlons" ' \
'"FRPT21" ' \
'"FRPT31" ' \
'"FRPMeanT21" ' \
'"FRPMeanT31" ' \
'"FRPMeanDT" ' \
'"FRPMADT21" ' \
'"FRPMADT31" ' \
'"FRP_MAD_DT" ' \
'"FRPpower" ' \
'"FRP_AdjCloud" ' \
'"FRP_AdjWater" ' \
'"FRP_NumValid" ' \
'"FRP_confidence" ' \
'"HDF_File"'
dirlist = [x for x in os.listdir('.') if ".csv" in x]
newFil = open('COMBINED.csv', 'w')
newFil.write('#' + hdr + '\n')
for fil in dirlist:
with open(fil, 'r') as csvfile:
reader = csv.reader(csvfile)
for row in reader:
row = str(row)
if '#' in row:
continue
row = row.replace('\\t', '\t').replace('[', '').replace(']', '').replace("'", "") + '\t' + fil + '\n'
newFil.write(row)
newFil.close()