readHTMLTable creates extra rows with null variables
0
I am trying to read a table from html file. I did it in following way:
mnydata = "file:///D:/Mampi/EastSinghbhum_updated/Treasury/TREASURY_DATA_EAST_SINGHBHUM/GHATSHILA_TREASURY_DATA/GHATSHILA_2016-17/GTSDAD001.html"
data2 <- readHTMLTable(mnydata, which = 2)
The command produces extra rows with null values. How to solve the problem?
Thanks,
Mampi
r
edited Nov 21 '18 at 12:30
hrbrmstr
61.8k693154
asked Nov 21 '18 at 11:52
Mampi BoseMampi Bose
1
add a comment |
0
I am trying to read a table from html file. I did it in following way:
mnydata = "file:///D:/Mampi/EastSinghbhum_updated/Treasury/TREASURY_DATA_EAST_SINGHBHUM/GHATSHILA_TREASURY_DATA/GHATSHILA_2016-17/GTSDAD001.html"
data2 <- readHTMLTable(mnydata, which = 2)
The command produces extra rows with null values. How to solve the problem?
Thanks,
Mampi
r
edited Nov 21 '18 at 12:30
hrbrmstr
61.8k693154
asked Nov 21 '18 at 11:52
Mampi BoseMampi Bose
1
1
Please do not use images to present your data; usedput(head(yourDataframe, 10))and copy the output in your question!
– jogo
Nov 21 '18 at 11:56
Welcome to SO. Images are neither code nor data unless the topic is image processing. You've likely been on SO before and seen good questions. This is not a good question. You have not provided a reproducible example. You have not provided data. You have likely not read stackoverflow.com/tags/r/info nor any of the links there pertaining to creating good questions. Please respect the time you're getting for free from SO contributors and help them help you.
– hrbrmstr
Nov 21 '18 at 12:32
add a comment |
0
0
0
I am trying to read a table from html file. I did it in following way:
mnydata = "file:///D:/Mampi/EastSinghbhum_updated/Treasury/TREASURY_DATA_EAST_SINGHBHUM/GHATSHILA_TREASURY_DATA/GHATSHILA_2016-17/GTSDAD001.html"
data2 <- readHTMLTable(mnydata, which = 2)
The command produces extra rows with null values. How to solve the problem?
Thanks,
Mampi
r
edited Nov 21 '18 at 12:30
hrbrmstr
61.8k693154
asked Nov 21 '18 at 11:52
Mampi BoseMampi Bose
1
I am trying to read a table from html file. I did it in following way:
mnydata = "file:///D:/Mampi/EastSinghbhum_updated/Treasury/TREASURY_DATA_EAST_SINGHBHUM/GHATSHILA_TREASURY_DATA/GHATSHILA_2016-17/GTSDAD001.html"
data2 <- readHTMLTable(mnydata, which = 2)
The command produces extra rows with null values. How to solve the problem?
Thanks,
Mampi
r
r
edited Nov 21 '18 at 12:30
hrbrmstr
61.8k693154
asked Nov 21 '18 at 11:52
Mampi BoseMampi Bose
1
edited Nov 21 '18 at 12:30
hrbrmstr
61.8k693154
asked Nov 21 '18 at 11:52
Mampi BoseMampi Bose
1
edited Nov 21 '18 at 12:30
hrbrmstr
61.8k693154
edited Nov 21 '18 at 12:30
hrbrmstr
61.8k693154
edited Nov 21 '18 at 12:30
hrbrmstr
61.8k693154
61.8k693154
asked Nov 21 '18 at 11:52
Mampi BoseMampi Bose
1
asked Nov 21 '18 at 11:52
Mampi BoseMampi Bose
1
asked Nov 21 '18 at 11:52
Mampi BoseMampi Bose
1
1
1
Please do not use images to present your data; usedput(head(yourDataframe, 10))and copy the output in your question!
– jogo
Nov 21 '18 at 11:56
Welcome to SO. Images are neither code nor data unless the topic is image processing. You've likely been on SO before and seen good questions. This is not a good question. You have not provided a reproducible example. You have not provided data. You have likely not read stackoverflow.com/tags/r/info nor any of the links there pertaining to creating good questions. Please respect the time you're getting for free from SO contributors and help them help you.
– hrbrmstr
Nov 21 '18 at 12:32
add a comment |
1
Please do not use images to present your data; usedput(head(yourDataframe, 10))and copy the output in your question!
– jogo
Nov 21 '18 at 11:56
Welcome to SO. Images are neither code nor data unless the topic is image processing. You've likely been on SO before and seen good questions. This is not a good question. You have not provided a reproducible example. You have not provided data. You have likely not read stackoverflow.com/tags/r/info nor any of the links there pertaining to creating good questions. Please respect the time you're getting for free from SO contributors and help them help you.
– hrbrmstr
Nov 21 '18 at 12:32
1
1
Please do not use images to present your data; use
dput(head(yourDataframe, 10)) and copy the output in your question!– jogo
Nov 21 '18 at 11:56
Please do not use images to present your data; use
dput(head(yourDataframe, 10)) and copy the output in your question!– jogo
Nov 21 '18 at 11:56
Welcome to SO. Images are neither code nor data unless the topic is image processing. You've likely been on SO before and seen good questions. This is not a good question. You have not provided a reproducible example. You have not provided data. You have likely not read stackoverflow.com/tags/r/info nor any of the links there pertaining to creating good questions. Please respect the time you're getting for free from SO contributors and help them help you.
– hrbrmstr
Nov 21 '18 at 12:32
Welcome to SO. Images are neither code nor data unless the topic is image processing. You've likely been on SO before and seen good questions. This is not a good question. You have not provided a reproducible example. You have not provided data. You have likely not read stackoverflow.com/tags/r/info nor any of the links there pertaining to creating good questions. Please respect the time you're getting for free from SO contributors and help them help you.
– hrbrmstr
Nov 21 '18 at 12:32
add a comment |
1 Answer
1
active
oldest
votes
0
Please read here about the difference of NULL vs. NA so you can use the names correctly.
IND <- apply(data2, 1, function(x) !all(is.na(x)))
data2[IND,]
So this approach uses apply with margin = 1 (row-wise) to give you index of all NON-(all)-NA-rows.
answered Nov 21 '18 at 12:03
Andre ElricoAndre Elrico
5,79111230
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%2f53411474%2freadhtmltable-creates-extra-rows-with-null-variables%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
0
Please read here about the difference of NULL vs. NA so you can use the names correctly.
IND <- apply(data2, 1, function(x) !all(is.na(x)))
data2[IND,]
So this approach uses apply with margin = 1 (row-wise) to give you index of all NON-(all)-NA-rows.
answered Nov 21 '18 at 12:03
Andre ElricoAndre Elrico
5,79111230
add a comment |
0
Please read here about the difference of NULL vs. NA so you can use the names correctly.
IND <- apply(data2, 1, function(x) !all(is.na(x)))
data2[IND,]
So this approach uses apply with margin = 1 (row-wise) to give you index of all NON-(all)-NA-rows.
answered Nov 21 '18 at 12:03
Andre ElricoAndre Elrico
5,79111230
add a comment |
0
0
0
Please read here about the difference of NULL vs. NA so you can use the names correctly.
IND <- apply(data2, 1, function(x) !all(is.na(x)))
data2[IND,]
So this approach uses apply with margin = 1 (row-wise) to give you index of all NON-(all)-NA-rows.
answered Nov 21 '18 at 12:03
Andre ElricoAndre Elrico
5,79111230
Please read here about the difference of NULL vs. NA so you can use the names correctly.
IND <- apply(data2, 1, function(x) !all(is.na(x)))
data2[IND,]
So this approach uses apply with margin = 1 (row-wise) to give you index of all NON-(all)-NA-rows.
answered Nov 21 '18 at 12:03
Andre ElricoAndre Elrico
5,79111230
edited Nov 21 '18 at 12:14
answered Nov 21 '18 at 12:03
Andre ElricoAndre Elrico
5,79111230
answered Nov 21 '18 at 12:03
Andre ElricoAndre Elrico
5,79111230
answered Nov 21 '18 at 12:03
Andre ElricoAndre Elrico
5,79111230
5,79111230
add a comment |
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%2f53411474%2freadhtmltable-creates-extra-rows-with-null-variables%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
Please do not use images to present your data; use
dput(head(yourDataframe, 10))and copy the output in your question!– jogo
Nov 21 '18 at 11:56
Welcome to SO. Images are neither code nor data unless the topic is image processing. You've likely been on SO before and seen good questions. This is not a good question. You have not provided a reproducible example. You have not provided data. You have likely not read stackoverflow.com/tags/r/info nor any of the links there pertaining to creating good questions. Please respect the time you're getting for free from SO contributors and help them help you.
– hrbrmstr
Nov 21 '18 at 12:32