Hi
I cannot say anything about mutate but
read.csv results in data frame
you can use then
wbpractice$gap <- with(wbpractice, total.food.exp-total.nfood.exp)
Cheers
Petr
BTW, do not use HTML formating your email is a mess.
> -----Original Message-----
> From: R-help <r-help-boun...@r-project.org> On Behalf Of Admire Tarisirayi
> Chirume
> Sent: Monday, October 18, 2021 1:26 PM
> To: Jim Lemon <drjimle...@gmail.com>
> Cc: r-help mailing list <r-help@r-project.org>
> Subject: [R] creating a new variable and merging it on the dataframe
>
> Good day colleagues. Below is a csv file attached which i am using in my
> analysis.
>
>
>
> hh.id
>
> hd17.perm
>
> hd17employ
>
> health.exp
>
> total.food.exp
>
> total.nfood.exp
>
> 1
>
> 2
>
> yes
>
> 1654
>
> 23654
>
> 23655
>
> 2
>
> 2
>
> yes
>
> 2564
>
> 265897
>
> 65984
>
> 3
>
> 6
>
> no
>
> 2547
>
> 123311
>
> 52416
>
> 4
>
> 8
>
> no
>
> 5698
>
> 13648
>
> 12544
>
> 5
>
> 6
>
> no
>
> 1254
>
> 36549
>
> 12365
>
> 6
>
> 8
>
> yes
>
> 1236
>
> 236541
>
> 26522
>
> 7
>
> 8
>
> no
>
> 4521
>
> 13264
>
> 23698
>
>
>
>
>
> So I created a df using the above csv file as follows
>
> wbpractice <- read.csv("world_practice.csv")
>
> Now, I wanted to create a new variable called gap and scripted and
executed
> the following command :
>
> wbpractice %>%
>
> mutate(gap = total.food.exp-total.nfood.exp) #gen a variable
>
>
>
> By recalling wbpractice, I could not see the new variable created.
Running
> the command;
>
> names(wbpractice)
>
>
>
> shows the old variables only. Any help on how to append the newly created
> variable on my data?
>
>
> Alternative email: addtar...@icloud.com/tchir...@rbz.co.zw
> Skype: admirechirume
> Call: +263773369884
> whatsapp: +818099861504
>
>
>
> >
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> 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.
______________________________________________
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.
