1 | # Standard modules |
---|
2 | from os import sep |
---|
3 | import os, glob |
---|
4 | from os.path import join |
---|
5 | |
---|
6 | # Related major packages |
---|
7 | from anuga.utilities.csv_tools import merge_csv_key_values |
---|
8 | |
---|
9 | # Application specific imports |
---|
10 | from setup_model import project # Definition of file names and polygons |
---|
11 | import csv |
---|
12 | directory = project.output_folder |
---|
13 | |
---|
14 | time_dir1 = '20090508_150215_run_final_0_51469_lfountai' |
---|
15 | time_dir2 = '20090511_161526_run_final_1.1_51469_kvanputt' |
---|
16 | time_dir3 = '20090511_165539_run_final_0_50863_lfountai' |
---|
17 | time_dir4 = '20090521_220101_run_final_1.1_50863_kvanputt' |
---|
18 | time_dir5 = '20090518_154710_run_final_0_50994_lfountai' |
---|
19 | time_dir6 = '20090519_160510_run_final_1.1_50994_lfountai' |
---|
20 | time_dir7 = '20090522_164526_run_final_0_51392_lfountai' |
---|
21 | time_dir8 = '20090522_164640_run_final_1.1_51392_lfountai' |
---|
22 | time_dir9 = '20090522_164948_run_final_0_51423_lfountai' |
---|
23 | time_dir10 = '20090522_165600_run_final_1.1_51423_lfountai' |
---|
24 | |
---|
25 | time_dirs = [time_dir1, time_dir2, time_dir3, time_dir4, time_dir5, |
---|
26 | time_dir6, time_dir7, time_dir8, time_dir9, time_dir10] |
---|
27 | |
---|
28 | data = 'stage' |
---|
29 | output_filename = 'gauges_combined_' + data + '.csv' |
---|
30 | for time_dir in time_dirs: |
---|
31 | print time_dir |
---|
32 | folder = join(directory, time_dir) |
---|
33 | output_file = join(folder, output_filename) |
---|
34 | #Looking for 'gauge_<alphabetic>.csv' filename |
---|
35 | input_csv = glob.glob(folder + sep + 'gauge*.csv') |
---|
36 | |
---|
37 | csv_files = [] |
---|
38 | for infile in input_csv: |
---|
39 | title = os.path.basename(infile)[:-4] |
---|
40 | title = title.replace('gauge_', '') |
---|
41 | if title in csv_files: |
---|
42 | print 'Title (%s) already in use' % title |
---|
43 | sys.exit(10) |
---|
44 | csv_files.append([infile, title]) |
---|
45 | |
---|
46 | # print 'csv_files=%s' % str(csv_files) |
---|
47 | merge_csv_key_values(csv_files, output_file, |
---|
48 | key_col='hours', data_col=data) |
---|