Warning in data.matrix(data): NA's introduced by coercion [Time Series]
The dataset looks like this from an Excel point of view 
So, this is the full code i did prior to including the time series part.
library(tidyverse)
library(xts)
library(fpp)
library(astsa)
library(DT)
library(dygraphs)
library(lubridate)
library(readxl)
Aust_Beer_Production <- read_excel("D:/Working Directory/monthly-beer-production-in-austr.xlsx")
Aust_Beer_Production2 <- as.data.frame(Aust_Beer_Production, stringsAsFactors = F)
names(Aust_Beer_Production2)[2] <- "MegaLiters_Monthly"
Aust_Beer_Production3 <- Aust_Beer_Production2 %>%
mutate(Revenue = MegaLiters_Monthly * 1000 * 15)
Does anyone know how to prevent this thing here that popped up in my R Markdown file:
## Warning in data.matrix(data): NAs introduced by coercion
I was in the process of converting a dataset into a ts
Aust_Beer_TS <- ts(Aust_Beer_Production2, frequency = 12, start = c(1956,1), end = c(1990, 12))
The end result looked like this
Should i try to convert it via lubridate?. On a previous attempt, i tried
Aust_Beer_Production3$Month <- as.Date(Aust_Beer_Production3$Month, "yearmon")
yet nothing has apparently changed
How can i forcibly remove the NAs coerced and rectify the error?
r
asked Nov 14 '18 at 23:26
Joel Jr RudinasJoel Jr Rudinas
134
add a comment |
The dataset looks like this from an Excel point of view
So, this is the full code i did prior to including the time series part.
library(tidyverse)
library(xts)
library(fpp)
library(astsa)
library(DT)
library(dygraphs)
library(lubridate)
library(readxl)
Aust_Beer_Production <- read_excel("D:/Working Directory/monthly-beer-production-in-austr.xlsx")
Aust_Beer_Production2 <- as.data.frame(Aust_Beer_Production, stringsAsFactors = F)
names(Aust_Beer_Production2)[2] <- "MegaLiters_Monthly"
Aust_Beer_Production3 <- Aust_Beer_Production2 %>%
mutate(Revenue = MegaLiters_Monthly * 1000 * 15)
Does anyone know how to prevent this thing here that popped up in my R Markdown file:
## Warning in data.matrix(data): NAs introduced by coercion
I was in the process of converting a dataset into a ts
Aust_Beer_TS <- ts(Aust_Beer_Production2, frequency = 12, start = c(1956,1), end = c(1990, 12))
The end result looked like this
Should i try to convert it via lubridate?. On a previous attempt, i tried
Aust_Beer_Production3$Month <- as.Date(Aust_Beer_Production3$Month, "yearmon")
yet nothing has apparently changed
How can i forcibly remove the NAs coerced and rectify the error?
r
asked Nov 14 '18 at 23:26
Joel Jr RudinasJoel Jr Rudinas
134
add a comment |
The dataset looks like this from an Excel point of view
So, this is the full code i did prior to including the time series part.
library(tidyverse)
library(xts)
library(fpp)
library(astsa)
library(DT)
library(dygraphs)
library(lubridate)
library(readxl)
Aust_Beer_Production <- read_excel("D:/Working Directory/monthly-beer-production-in-austr.xlsx")
Aust_Beer_Production2 <- as.data.frame(Aust_Beer_Production, stringsAsFactors = F)
names(Aust_Beer_Production2)[2] <- "MegaLiters_Monthly"
Aust_Beer_Production3 <- Aust_Beer_Production2 %>%
mutate(Revenue = MegaLiters_Monthly * 1000 * 15)
Does anyone know how to prevent this thing here that popped up in my R Markdown file:
## Warning in data.matrix(data): NAs introduced by coercion
I was in the process of converting a dataset into a ts
Aust_Beer_TS <- ts(Aust_Beer_Production2, frequency = 12, start = c(1956,1), end = c(1990, 12))
The end result looked like this
Should i try to convert it via lubridate?. On a previous attempt, i tried
Aust_Beer_Production3$Month <- as.Date(Aust_Beer_Production3$Month, "yearmon")
yet nothing has apparently changed
How can i forcibly remove the NAs coerced and rectify the error?
r
asked Nov 14 '18 at 23:26
Joel Jr RudinasJoel Jr Rudinas
134
The dataset looks like this from an Excel point of view
So, this is the full code i did prior to including the time series part.
library(tidyverse)
library(xts)
library(fpp)
library(astsa)
library(DT)
library(dygraphs)
library(lubridate)
library(readxl)
Aust_Beer_Production <- read_excel("D:/Working Directory/monthly-beer-production-in-austr.xlsx")
Aust_Beer_Production2 <- as.data.frame(Aust_Beer_Production, stringsAsFactors = F)
names(Aust_Beer_Production2)[2] <- "MegaLiters_Monthly"
Aust_Beer_Production3 <- Aust_Beer_Production2 %>%
mutate(Revenue = MegaLiters_Monthly * 1000 * 15)
Does anyone know how to prevent this thing here that popped up in my R Markdown file:
## Warning in data.matrix(data): NAs introduced by coercion
I was in the process of converting a dataset into a ts
Aust_Beer_TS <- ts(Aust_Beer_Production2, frequency = 12, start = c(1956,1), end = c(1990, 12))
The end result looked like this
Should i try to convert it via lubridate?. On a previous attempt, i tried
Aust_Beer_Production3$Month <- as.Date(Aust_Beer_Production3$Month, "yearmon")
yet nothing has apparently changed
How can i forcibly remove the NAs coerced and rectify the error?
r
r
asked Nov 14 '18 at 23:26
Joel Jr RudinasJoel Jr Rudinas
134
asked Nov 14 '18 at 23:26
Joel Jr RudinasJoel Jr Rudinas
134
edited Nov 14 '18 at 23:35
Joel Jr Rudinas
asked Nov 14 '18 at 23:26
Joel Jr RudinasJoel Jr Rudinas
134
asked Nov 14 '18 at 23:26
Joel Jr RudinasJoel Jr Rudinas
134
asked Nov 14 '18 at 23:26
Joel Jr RudinasJoel Jr Rudinas
134
134
add a comment |
add a comment |
0
active
oldest
votes
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
});
}
});
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%2f53310292%2fwarning-in-data-matrixdata-nas-introduced-by-coercion-time-series%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
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%2f53310292%2fwarning-in-data-matrixdata-nas-introduced-by-coercion-time-series%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
