Differences

This shows you the differences between two versions of the page.

--- q_as:start [2024-09-06 06:10 am] – hcho
+++ q_as:start [2024-09-20 08:23 am] (current) – hcho
@@ Line 3: / Line 3: @@
 ===== Column appending problem =====
-[[lab_members:abdullah_azzam|]]
+  * Author: [[lab_members:abdullah_azzam|]]
+  * Data: {{ q_as:column_appending_problem.zip |}}
-How do you append a new column to an object file which is for a certain coordinate and contains the timeseries of multiple climatic parameters from a source file? The source file ''vs.txt'' has wind speed values for all the coordinates in a sequence, which means starting from the n row, the wind speed value for the next day is after 36,217 rows. 36,217 is the total number of coordinates which means that the wind speed needs to be appended in 36217 files. The object files have naming pattern of ''$lat_$lon_lwave.mtc43''.
+How do you append a new column to an object file from a source file? The object file is for a certain coordinate and contains the timeseries of multiple climatic parameters. The source file ''vs.txt'' has wind speed values for all the coordinates in a sequence, which means starting from the n row, the wind speed value for the next day is after 36,217 rows. 36,217 is the total number of coordinates which means that the wind speed needs to be appended in 36,217 files. The object files have naming pattern of ''$lat_$lon_lwave.mtc43''.
-Data: {{ q_as:column_appending_problem.zip |}}
+==== Solution ====
+<file bash doit.sh>
+#!/bin/sh
+for i in *.mtc43; do
+        coor=$(echo $i | sed 's/_/,/; s/_.*//')
+        (
+                echo -e "\n\nWind\n(m/s)"
+                grep $coor vs.txt | cut -d, -f3
+        ) > tmp.$$
+        paste $i tmp.$$ > tmp2.$$
+        mv tmp2.$$ $i
+done
+rm -f tmp*.$$
+</file>
+===== Extract grid cell IDs =====
+In {{ :q_as:veg_param_nm_003125deg.zip |}}, extract grid cell IDs.
 ===== Files =====
 {{filelisting}}\\