Averaging rows in attribute table QGIS
up vote
1
down vote
favorite
I have two rows with monthly rain run off per watershed as in the picture below.
I'd like to obtain the average runoff between may and august for basin 218187 and 218265 (note that basin 218187 will be 0 but the attribute table contains more rows). To do that I've created a new field but I'm struggling to write the code in the field calculator.
qgis field-calculator attribute-table
add a comment |
up vote
1
down vote
favorite
I have two rows with monthly rain run off per watershed as in the picture below.
I'd like to obtain the average runoff between may and august for basin 218187 and 218265 (note that basin 218187 will be 0 but the attribute table contains more rows). To do that I've created a new field but I'm struggling to write the code in the field calculator.
qgis field-calculator attribute-table
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
I have two rows with monthly rain run off per watershed as in the picture below.
I'd like to obtain the average runoff between may and august for basin 218187 and 218265 (note that basin 218187 will be 0 but the attribute table contains more rows). To do that I've created a new field but I'm struggling to write the code in the field calculator.
qgis field-calculator attribute-table
I have two rows with monthly rain run off per watershed as in the picture below.
I'd like to obtain the average runoff between may and august for basin 218187 and 218265 (note that basin 218187 will be 0 but the attribute table contains more rows). To do that I've created a new field but I'm struggling to write the code in the field calculator.
qgis field-calculator attribute-table
qgis field-calculator attribute-table
edited Nov 27 at 13:38
Vince
14.3k32646
14.3k32646
asked Nov 27 at 9:36
Guillaume
1065
1065
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
4
down vote
accepted
You have to select "Update existing field" > AverageRO
and then type the following into the expression field:
("runoff_may" + "runoff_jun" + "runoff_jul" + "runoff_aug")/4
This will give you the arithmetic mean of the runoff values.
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
4
down vote
accepted
You have to select "Update existing field" > AverageRO
and then type the following into the expression field:
("runoff_may" + "runoff_jun" + "runoff_jul" + "runoff_aug")/4
This will give you the arithmetic mean of the runoff values.
add a comment |
up vote
4
down vote
accepted
You have to select "Update existing field" > AverageRO
and then type the following into the expression field:
("runoff_may" + "runoff_jun" + "runoff_jul" + "runoff_aug")/4
This will give you the arithmetic mean of the runoff values.
add a comment |
up vote
4
down vote
accepted
up vote
4
down vote
accepted
You have to select "Update existing field" > AverageRO
and then type the following into the expression field:
("runoff_may" + "runoff_jun" + "runoff_jul" + "runoff_aug")/4
This will give you the arithmetic mean of the runoff values.
You have to select "Update existing field" > AverageRO
and then type the following into the expression field:
("runoff_may" + "runoff_jun" + "runoff_jul" + "runoff_aug")/4
This will give you the arithmetic mean of the runoff values.
answered Nov 27 at 9:45
Stefan_Fairphone
946118
946118
add a comment |
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f304046%2faveraging-rows-in-attribute-table-qgis%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown