Mixing
how to get the column mismatch report when i have two dataframes in which second dataframe has more column...
0
I have two data frames:
a1 <- data.frame(a = 1:5, b=letters[1:5], c=c('a','t','f','e','v'))
a2 <- data.frame(a = 1:3, b=letters[1:3])
which i want to compare and want to get the number of column mismatch in both dataframe.
comparison <- compare(a2,a1,allowAll=TRUE)
r
edited Jan 2 at 11:51
meW
2,858120
asked Jan 2 at 10:25
Dharmendra singhDharmendra singh
1
add a comment |
0
I have two data frames:
a1 <- data.frame(a = 1:5, b=letters[1:5], c=c('a','t','f','e','v'))
a2 <- data.frame(a = 1:3, b=letters[1:3])
which i want to compare and want to get the number of column mismatch in both dataframe.
comparison <- compare(a2,a1,allowAll=TRUE)
r
edited Jan 2 at 11:51
meW
2,858120
asked Jan 2 at 10:25
Dharmendra singhDharmendra singh
1
1
what is the expected output ?
– YOLO
Jan 2 at 10:30
add a comment |
0
0
0
I have two data frames:
a1 <- data.frame(a = 1:5, b=letters[1:5], c=c('a','t','f','e','v'))
a2 <- data.frame(a = 1:3, b=letters[1:3])
which i want to compare and want to get the number of column mismatch in both dataframe.
comparison <- compare(a2,a1,allowAll=TRUE)
r
edited Jan 2 at 11:51
meW
2,858120
asked Jan 2 at 10:25
Dharmendra singhDharmendra singh
1
I have two data frames:
a1 <- data.frame(a = 1:5, b=letters[1:5], c=c('a','t','f','e','v'))
a2 <- data.frame(a = 1:3, b=letters[1:3])
which i want to compare and want to get the number of column mismatch in both dataframe.
comparison <- compare(a2,a1,allowAll=TRUE)
r
r
edited Jan 2 at 11:51
meW
2,858120
asked Jan 2 at 10:25
Dharmendra singhDharmendra singh
1
edited Jan 2 at 11:51
meW
2,858120
asked Jan 2 at 10:25
Dharmendra singhDharmendra singh
1
edited Jan 2 at 11:51
meW
2,858120
edited Jan 2 at 11:51
meW
2,858120
edited Jan 2 at 11:51
meW
2,858120
2,858120
asked Jan 2 at 10:25
Dharmendra singhDharmendra singh
1
asked Jan 2 at 10:25
Dharmendra singhDharmendra singh
1
asked Jan 2 at 10:25
Dharmendra singhDharmendra singh
1
1
1
what is the expected output ?
– YOLO
Jan 2 at 10:30
add a comment |
1
what is the expected output ?
– YOLO
Jan 2 at 10:30
1
1
what is the expected output ?
– YOLO
Jan 2 at 10:30
what is the expected output ?
– YOLO
Jan 2 at 10:30
add a comment |
3 Answers
3
active
oldest
votes
0
use the dplyr method given below :-
require(dplyr)
new <- anti_join(a1,a2)
answered Jan 2 at 10:38
HunaidkhanHunaidkhan
1,014516
add a comment |
0
To just get the number of missing columns:
length(c(setdiff(names(a1), names(a2)), setdiff(names(a2), names(a1))))
[1] 1
To get the names:
c(setdiff(names(a1), names(a2)), setdiff(names(a2), names(a1)))
[1] "c"
answered Jan 2 at 10:49
Bram Van RensbergenBram Van Rensbergen
32516
add a comment |
0
The column mismatch report, this will give you the list of the column that is not available in the second database
setdiff(colnames(a1),colnames(a2))
answered Jan 2 at 10:58
GhanshyamGhanshyam
11310
1
Thanks, this works for me
– Dharmendra singh
Jan 2 at 13:00
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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
});
}
});
draft saved
draft discarded
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%2fstackoverflow.com%2fquestions%2f54004649%2fhow-to-get-the-column-mismatch-report-when-i-have-two-dataframes-in-which-second%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
use the dplyr method given below :-
require(dplyr)
new <- anti_join(a1,a2)
answered Jan 2 at 10:38
HunaidkhanHunaidkhan
1,014516
add a comment |
0
use the dplyr method given below :-
require(dplyr)
new <- anti_join(a1,a2)
answered Jan 2 at 10:38
HunaidkhanHunaidkhan
1,014516
add a comment |
0
0
0
use the dplyr method given below :-
require(dplyr)
new <- anti_join(a1,a2)
answered Jan 2 at 10:38
HunaidkhanHunaidkhan
1,014516
use the dplyr method given below :-
require(dplyr)
new <- anti_join(a1,a2)
answered Jan 2 at 10:38
HunaidkhanHunaidkhan
1,014516
answered Jan 2 at 10:38
HunaidkhanHunaidkhan
1,014516
answered Jan 2 at 10:38
HunaidkhanHunaidkhan
1,014516
answered Jan 2 at 10:38
HunaidkhanHunaidkhan
1,014516
1,014516
add a comment |
add a comment |
0
To just get the number of missing columns:
length(c(setdiff(names(a1), names(a2)), setdiff(names(a2), names(a1))))
[1] 1
To get the names:
c(setdiff(names(a1), names(a2)), setdiff(names(a2), names(a1)))
[1] "c"
answered Jan 2 at 10:49
Bram Van RensbergenBram Van Rensbergen
32516
add a comment |
0
To just get the number of missing columns:
length(c(setdiff(names(a1), names(a2)), setdiff(names(a2), names(a1))))
[1] 1
To get the names:
c(setdiff(names(a1), names(a2)), setdiff(names(a2), names(a1)))
[1] "c"
answered Jan 2 at 10:49
Bram Van RensbergenBram Van Rensbergen
32516
add a comment |
0
0
0
To just get the number of missing columns:
length(c(setdiff(names(a1), names(a2)), setdiff(names(a2), names(a1))))
[1] 1
To get the names:
c(setdiff(names(a1), names(a2)), setdiff(names(a2), names(a1)))
[1] "c"
answered Jan 2 at 10:49
Bram Van RensbergenBram Van Rensbergen
32516
To just get the number of missing columns:
length(c(setdiff(names(a1), names(a2)), setdiff(names(a2), names(a1))))
[1] 1
To get the names:
c(setdiff(names(a1), names(a2)), setdiff(names(a2), names(a1)))
[1] "c"
answered Jan 2 at 10:49
Bram Van RensbergenBram Van Rensbergen
32516
answered Jan 2 at 10:49
Bram Van RensbergenBram Van Rensbergen
32516
answered Jan 2 at 10:49
Bram Van RensbergenBram Van Rensbergen
32516
answered Jan 2 at 10:49
Bram Van RensbergenBram Van Rensbergen
32516
32516
add a comment |
add a comment |
0
The column mismatch report, this will give you the list of the column that is not available in the second database
setdiff(colnames(a1),colnames(a2))
answered Jan 2 at 10:58
GhanshyamGhanshyam
11310
1
Thanks, this works for me
– Dharmendra singh
Jan 2 at 13:00
add a comment |
0
The column mismatch report, this will give you the list of the column that is not available in the second database
setdiff(colnames(a1),colnames(a2))
answered Jan 2 at 10:58
GhanshyamGhanshyam
11310
1
Thanks, this works for me
– Dharmendra singh
Jan 2 at 13:00
add a comment |
0
0
0
The column mismatch report, this will give you the list of the column that is not available in the second database
setdiff(colnames(a1),colnames(a2))
answered Jan 2 at 10:58
GhanshyamGhanshyam
11310
The column mismatch report, this will give you the list of the column that is not available in the second database
setdiff(colnames(a1),colnames(a2))
answered Jan 2 at 10:58
GhanshyamGhanshyam
11310
answered Jan 2 at 10:58
GhanshyamGhanshyam
11310
answered Jan 2 at 10:58
GhanshyamGhanshyam
11310
answered Jan 2 at 10:58
GhanshyamGhanshyam
11310
11310
1
Thanks, this works for me
– Dharmendra singh
Jan 2 at 13:00
add a comment |
1
Thanks, this works for me
– Dharmendra singh
Jan 2 at 13:00
1
1
Thanks, this works for me
– Dharmendra singh
Jan 2 at 13:00
Thanks, this works for me
– Dharmendra singh
Jan 2 at 13:00
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- 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.
draft saved
draft discarded
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%2fstackoverflow.com%2fquestions%2f54004649%2fhow-to-get-the-column-mismatch-report-when-i-have-two-dataframes-in-which-second%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
1
what is the expected output ?
– YOLO
Jan 2 at 10:30