Merging data from multiple files
So in my case I have multiple Linux VM's and each one of them there is a file called
output.txt (or other extension like excel?). They look like:
Average download time:8647
Average whatever : 153
Now I want to merge them all into one file with the average results from all files.
Which files extension is best to use or how it can be done with simple txt?
linux microsoft-excel merge
edited Jan 16 at 7:18
Xen2050
10.9k31536
asked Jan 15 at 14:39
GokingGoking
165
add a comment |
So in my case I have multiple Linux VM's and each one of them there is a file called
output.txt (or other extension like excel?). They look like:
Average download time:8647
Average whatever : 153
Now I want to merge them all into one file with the average results from all files.
Which files extension is best to use or how it can be done with simple txt?
linux microsoft-excel merge
edited Jan 16 at 7:18
Xen2050
10.9k31536
asked Jan 15 at 14:39
GokingGoking
165
Are the files in plain text format, or microsoft excel, or something else? What exactly are in the two (or more) different files, and how exactly do you want to merge them? Just cat them all together, or add some numbers (which ones) and find their averages?
– Xen2050
Jan 16 at 7:20
I've catted them together and used the following awk awk ' { c[$1]++; for (i=2;i<=NF;i++) { s[$1"."i]+=$i}; } END { for (k in c) { printf "%st", k; for(i=2;i<NF;i++) printf "%.1ft", s[k"."i]/c[k]; printf "%.1fn", s[k"."NF]/c[k]; } }' full.txt >> resulting.txt
– Goking
Jan 16 at 11:27
Is that your own answer then? You could post it as an answer, and editing samples of the files into the original question would be helpful too
– Xen2050
Jan 16 at 14:01
add a comment |
So in my case I have multiple Linux VM's and each one of them there is a file called
output.txt (or other extension like excel?). They look like:
Average download time:8647
Average whatever : 153
Now I want to merge them all into one file with the average results from all files.
Which files extension is best to use or how it can be done with simple txt?
linux microsoft-excel merge
edited Jan 16 at 7:18
Xen2050
10.9k31536
asked Jan 15 at 14:39
GokingGoking
165
So in my case I have multiple Linux VM's and each one of them there is a file called
output.txt (or other extension like excel?). They look like:
Average download time:8647
Average whatever : 153
Now I want to merge them all into one file with the average results from all files.
Which files extension is best to use or how it can be done with simple txt?
linux microsoft-excel merge
linux microsoft-excel merge
edited Jan 16 at 7:18
Xen2050
10.9k31536
asked Jan 15 at 14:39
GokingGoking
165
edited Jan 16 at 7:18
Xen2050
10.9k31536
asked Jan 15 at 14:39
GokingGoking
165
edited Jan 16 at 7:18
Xen2050
10.9k31536
edited Jan 16 at 7:18
Xen2050
10.9k31536
edited Jan 16 at 7:18
Xen2050
10.9k31536
10.9k31536
asked Jan 15 at 14:39
GokingGoking
165
asked Jan 15 at 14:39
GokingGoking
165
asked Jan 15 at 14:39
GokingGoking
165
165
Are the files in plain text format, or microsoft excel, or something else? What exactly are in the two (or more) different files, and how exactly do you want to merge them? Just cat them all together, or add some numbers (which ones) and find their averages?
– Xen2050
Jan 16 at 7:20
I've catted them together and used the following awk awk ' { c[$1]++; for (i=2;i<=NF;i++) { s[$1"."i]+=$i}; } END { for (k in c) { printf "%st", k; for(i=2;i<NF;i++) printf "%.1ft", s[k"."i]/c[k]; printf "%.1fn", s[k"."NF]/c[k]; } }' full.txt >> resulting.txt
– Goking
Jan 16 at 11:27
Is that your own answer then? You could post it as an answer, and editing samples of the files into the original question would be helpful too
– Xen2050
Jan 16 at 14:01
add a comment |
Are the files in plain text format, or microsoft excel, or something else? What exactly are in the two (or more) different files, and how exactly do you want to merge them? Just cat them all together, or add some numbers (which ones) and find their averages?
– Xen2050
Jan 16 at 7:20
I've catted them together and used the following awk awk ' { c[$1]++; for (i=2;i<=NF;i++) { s[$1"."i]+=$i}; } END { for (k in c) { printf "%st", k; for(i=2;i<NF;i++) printf "%.1ft", s[k"."i]/c[k]; printf "%.1fn", s[k"."NF]/c[k]; } }' full.txt >> resulting.txt
– Goking
Jan 16 at 11:27
Is that your own answer then? You could post it as an answer, and editing samples of the files into the original question would be helpful too
– Xen2050
Jan 16 at 14:01
Are the files in plain text format, or microsoft excel, or something else? What exactly are in the two (or more) different files, and how exactly do you want to merge them? Just cat them all together, or add some numbers (which ones) and find their averages?
– Xen2050
Jan 16 at 7:20
Are the files in plain text format, or microsoft excel, or something else? What exactly are in the two (or more) different files, and how exactly do you want to merge them? Just cat them all together, or add some numbers (which ones) and find their averages?
– Xen2050
Jan 16 at 7:20
I've catted them together and used the following awk awk ' { c[$1]++; for (i=2;i<=NF;i++) { s[$1"."i]+=$i}; } END { for (k in c) { printf "%st", k; for(i=2;i<NF;i++) printf "%.1ft", s[k"."i]/c[k]; printf "%.1fn", s[k"."NF]/c[k]; } }' full.txt >> resulting.txt
– Goking
Jan 16 at 11:27
I've catted them together and used the following awk awk ' { c[$1]++; for (i=2;i<=NF;i++) { s[$1"."i]+=$i}; } END { for (k in c) { printf "%st", k; for(i=2;i<NF;i++) printf "%.1ft", s[k"."i]/c[k]; printf "%.1fn", s[k"."NF]/c[k]; } }' full.txt >> resulting.txt
– Goking
Jan 16 at 11:27
Is that your own answer then? You could post it as an answer, and editing samples of the files into the original question would be helpful too
– Xen2050
Jan 16 at 14:01
Is that your own answer then? You could post it as an answer, and editing samples of the files into the original question would be helpful too
– Xen2050
Jan 16 at 14:01
add a comment |
1 Answer
1
active
oldest
votes
I've cat them together and used the following awk script
awk ' { c[$1]++; for (i=2;i<=NF;i++) { s[$1"."i]+=$i}; } END { for (k in c) { printf "%st", k; for(i=2;i> resulting.txt
which redirects from input file:
a:123
b:213
a:234
b:42 and so on to get the average values
answered Jan 16 at 15:11
GokingGoking
165
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
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%2fsuperuser.com%2fquestions%2f1394548%2fmerging-data-from-multiple-files%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I've cat them together and used the following awk script
awk ' { c[$1]++; for (i=2;i<=NF;i++) { s[$1"."i]+=$i}; } END { for (k in c) { printf "%st", k; for(i=2;i> resulting.txt
which redirects from input file:
a:123
b:213
a:234
b:42 and so on to get the average values
answered Jan 16 at 15:11
GokingGoking
165
add a comment |
I've cat them together and used the following awk script
awk ' { c[$1]++; for (i=2;i<=NF;i++) { s[$1"."i]+=$i}; } END { for (k in c) { printf "%st", k; for(i=2;i> resulting.txt
which redirects from input file:
a:123
b:213
a:234
b:42 and so on to get the average values
answered Jan 16 at 15:11
GokingGoking
165
add a comment |
I've cat them together and used the following awk script
awk ' { c[$1]++; for (i=2;i<=NF;i++) { s[$1"."i]+=$i}; } END { for (k in c) { printf "%st", k; for(i=2;i> resulting.txt
which redirects from input file:
a:123
b:213
a:234
b:42 and so on to get the average values
answered Jan 16 at 15:11
GokingGoking
165
I've cat them together and used the following awk script
awk ' { c[$1]++; for (i=2;i<=NF;i++) { s[$1"."i]+=$i}; } END { for (k in c) { printf "%st", k; for(i=2;i> resulting.txt
which redirects from input file:
a:123
b:213
a:234
b:42 and so on to get the average values
answered Jan 16 at 15:11
GokingGoking
165
answered Jan 16 at 15:11
GokingGoking
165
answered Jan 16 at 15:11
GokingGoking
165
answered Jan 16 at 15:11
GokingGoking
165
165
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1394548%2fmerging-data-from-multiple-files%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
Are the files in plain text format, or microsoft excel, or something else? What exactly are in the two (or more) different files, and how exactly do you want to merge them? Just cat them all together, or add some numbers (which ones) and find their averages?
– Xen2050
Jan 16 at 7:20
I've catted them together and used the following awk awk ' { c[$1]++; for (i=2;i<=NF;i++) { s[$1"."i]+=$i}; } END { for (k in c) { printf "%st", k; for(i=2;i<NF;i++) printf "%.1ft", s[k"."i]/c[k]; printf "%.1fn", s[k"."NF]/c[k]; } }' full.txt >> resulting.txt
– Goking
Jan 16 at 11:27
Is that your own answer then? You could post it as an answer, and editing samples of the files into the original question would be helpful too
– Xen2050
Jan 16 at 14:01