|
|
|
|
|||||||
| Forums | Portal | Register | Forum Rules | FAQ | Contribute | Members List | Arcade | Search | Today's Posts | Mark Forums Read |
| UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !! |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how to average in awk | saint2006 | Shell Programming and Scripting | 4 | 06-04-2008 08:29 AM |
| Average Time | sambond | UNIX for Dummies Questions & Answers | 1 | 01-16-2008 06:57 AM |
| Low average cpu utilization. | Moodie | SUN Solaris | 3 | 12-11-2007 03:25 PM |
| Calculating the average | kekanap | Shell Programming and Scripting | 2 | 01-26-2007 05:36 AM |
| Average of arguments | TalkShowHost | Shell Programming and Scripting | 2 | 08-09-2002 06:24 AM |
 |
|
|
Submit Tools | LinkBack | Thread Tools | Display Modes |
03-10-2007
|
|||
|
|||
|
average value
If I have a file like this, could anyone please guide me how to find the average value in each metrix. The file has got about 130,000 metrixs.
Grid-ref= 142, 235 178 182 203 240 273 295 289 293 283 262 201 176 167 187 187 246 260 282 299 312 293 276 230 191 169 195 213 239 286 291 290 276 300 278 215 197 157 163 188 225 271 282 297 283 281 268 208 186 182 167 192 237 248 276 308 279 276 264 229 187 161 163 204 230 288 303 295 279 281 245 217 178 154 185 224 231 260 288 292 285 291 263 213 169 170 186 187 217 261 300 288 278 270 247 192 172 189 170 187 237 264 286 300 305 283 251 226 173 171 186 192 219 265 291 287 290 278 238 216 192 Grid-ref= 142, 236 159 166 186 226 260 285 281 274 267 240 186 157 151 179 172 233 252 276 287 297 276 253 211 172 150 182 196 225 274 285 281 272 283 256 195 176 138 148 172 210 259 284 291 270 266 246 191 171 169 144 183 222 246 278 290 263 259 241 214 167 145 152 190 219 276 283 279 266 264 230 203 158 151 179 216 215 256 281 277 271 274 244 204 156 154 171 174 203 248 291 274 263 264 240 169 154 174 154 176 228 257 276 284 291 266 234 216 151 147 175 173 206 256 285 272 273 260 221 200 179 Grid-ref= 142, 237 133 142 157 193 228 259 249 245 239 212 157 132 124 154 142 202 221 252 258 270 249 225 183 151 125 160 167 192 244 256 253 240 254 226 166 146 109 121 143 180 228 259 264 240 237 219 160 146 145 120 154 192 214 249 262 234 228 212 184 141 118 126 164 191 249 257 253 237 240 202 177 133 126 156 190 184 225 254 250 241 249 218 177 133 131 151 149 175 218 269 247 234 236 212 148 129 147 129 150 203 230 250 258 263 238 206 191 128 121 153 152 183 232 261 246 246 233 191 172 151 I wanna get the output as shown below Grid-ref= 142, 235 169.8 178.4 197.7 232.1 267.6 289.4 294.5 288 283.6 259.2 214.7 182.1 Grid-ref= 142, 236 153.8 165 183.8 218.7 258.4 282.4 281.6 274 267.9 240.5 198.9 164.1 Grid-ref= 142, 237 127.9 141.2 156.8 189.5 228.9 256.6 254 245 240.3 212.3 171.5 139 Any idea would be greatly appreciated. su_in99 
|
| Forum Sponsor | ||
|
|
|
03-10-2007
|
|||
|
|||
|
Check this post
http://www.unix.com/showpost.php?p=3...2&postcount=19
|
|
03-10-2007
|
||||
|
||||
|
nawk -f grid.awk myMatrixFile
grid.awk: Code:
function outputGrid(i) {
printf("%s\n", thisGrid)
for(i=1; i<= col; i++)
printf("%.1f%s", arr[i]/row, (i==col) ? RS : OFS)
thisGrid=$0
split("", arr)
row=0
}
/^Grid/ {
( thisGrid != "") ? outputGrid() : thisGrid=$0
next
}
/^[0-9][0-9]*/ {
row++
col=NF
for(i=1; i <= NF; i++) {
arr[i] += $i
}
}
END {
outputGrid()
}
Last edited by vgersh99; 03-10-2007 at 09:52 AM.
|
||||
| Google The UNIX and Linux Forums |
Linear Mode
