Dear Team,
I am facing an error while performing a manipulation using a dplyr package.
In the code below, I am using mutate to build a new calculated column:
kp<-read.csv("collection_last.csv",header=TRUE)
mutate(kp,dif=DOC_AMOUNT-RECEIPT_AMT+TDS_AMT+REBATE)
However it gives an error:-
Warning messages:
1: In Ops.factor(c(28831L, 28831L, 17504L, 4184L, 36187L, 25819L, 699L, :
'-' not meaningful for factors
2: In Ops.factor(c(28831L, 28831L, 17504L, 4184L, 36187L, 25819L, 699L, :
'+' not meaningful for factors
3: In Ops.factor(c(28831L, 28831L, 17504L, 4184L, 36187L, 25819L, 699L, :
'+' not meaningful for factors
This is an error when some of my variables are factors hence I have tried to
change these to numeric so used the expression as:
kp$DOC_TYPE=as.numeric(kp$DOC_TYPE).
this now shows as variable type of as "double". So expedite help on this one
i was trying to create a reproducible example and i am highly struggling to
create one. the data i have is approx. around 1 million rows with 21 columns
hence when i use a dput option it does not capture the entire detailing and
row level info required to share and even dput(head(kp$DOC_TYPE) does not
help either.
I have seen many stack overflow & r help column before composing this email.
Hence i need help to create this reproducible example to share with the
experts in the community. Apologies if this is a repeat.
PLEASE HELP AS I AM HIGHLY STRUGGLING TO BUILD ANY OUTCOME.
Regards, Shivi
This e-mail is confidential. It may also be legally privileged. If you are not
the addressee you may not copy, forward, disclose or use any part of it. If you
have received this message in error, please delete it and all copies from your
system and notify the sender immediately by return e-mail. Internet
communications cannot be guaranteed to be timely, secure, error or virus-free.
The sender does not accept liability for any errors or omissions.
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
