[R] Need to insert various rows of data from a data frame after particular rows from another dataframe

[Ranjeet Kumar Jha]

Hi Pikal,

Now I have formatted the kharif data file in the same format as it is in
the dacnet filecode:. However, "district.id" and "state.id " columns have
"N/A" data that are appearing. If I use merge "rbind" function, it still
throws this error:

"Error in rbind(deparse.level, ...) :
  numbers of columns of arguments do not match"

code:
df3=rbind(kharif_18_19,dacnet_17)
df3=df3[order(df3$district,df3$year),]
x<-write.csv(df3,"df3.csv")
view(x)

On Wed, Jul 27, 2022 at 3:18 PM PIKAL Petr <petr.pikal using precheza.cz> wrote:

> Hallo,
>
> I do not understand what you really want and you do not help much.
>
> No error, no data, vague description of your problem, no effort to explain
> it better. Only you can see your data, only you can see the error message
> so we are clueless.
>
> Cheers
> Petr
>
>
> From: Ranjeet Kumar Jha <ranjeetjhaiitkgp using gmail.com>
> Sent: Wednesday, July 27, 2022 11:01 AM
> To: PIKAL Petr <petr.pikal using precheza.cz>
> Cc: R-help <r-help using r-project.org>
> Subject: Re: [R] Need to insert various rows of data from a data frame
> after particular rows from another dataframe
>
> yeah rbind works find bur dataframe 2 has different format and then rbind
> can be used with first dataframe. But here I am struggling to bring the 2nd
> dataframe in the same format as the 1st one.
>
> On Wed, Jul 27, 2022 at 1:13 PM PIKAL Petr <mailto:petr.pikal using precheza.cz>
> wrote:
> Hi.
>
> „is not working“ is extremelly vague.
>
> 1.
> What do you expect this code do?
>
> for(cr in seq_along(dacnet_17$district)){
>     match(arhar_18$district, dacnet_17$district)
> }
>
> See ?match and maybe also ?“for“ and try this
>
> x <- letters[1:5]
> y <- sample(letters, 100, replace=T)
> match(x,y)
> [1] 45 16 24 13 71
> for(i in 1:3) match(x,y)
>
> 2.
> rbind works as expeceted
>
> arhar_18 <- data.frame(a=1:10, b=50, c=letters[1:10])
> dacnet_17 <- data.frame(a=11:20, b=100, c=sample(letters,10))
> df3=rbind(arhar_18,dacnet_17)
>
> if your data has common column order and type.
>
> To get more specific answer you need to ask specific question preferably
> with some data included (most preferably by dput command) and error message.
>
> Cheers
> Petr
>
>
> From: Ranjeet Kumar Jha <mailto:ranjeetjhaiitkgp using gmail.com>
> Sent: Wednesday, July 27, 2022 8:35 AM
> To: PIKAL Petr <mailto:petr.pikal using precheza.cz>
> Cc: R-help <mailto:r-help using r-project.org>
> Subject: Re: [R] Need to insert various rows of data from a data frame
> after particular rows from another dataframe
>
> Hi Petr,
>
> I used r-bind but it's not working.
> Here is the code:
>
>
> arhar_18<-read.csv("D:/Ranjeet/IAMV6/input/yield/kharif_18-19_yield/Kharif_2018/arhar_18.csv")
> dacnet_17<-read.csv("D:/Ranjeet/IAMV6/input/yield/dacnet_yield_update till
> 2019.csv")
>
> for(cr in seq_along(dacnet_17$district)){
>     match(arhar_18$district, dacnet_17$district)
> }
>
> df3=rbind(arhar_18,dacnet_17)
> df3=df3[order(df3$district,df3$year),]
> x<-write.csv(df3,"df3.csv")
> view(x)
>
> On Wed, Jul 27, 2022 at 12:00 PM PIKAL Petr <mailto:petr.pikal using precheza.cz>
> wrote:
> Hi.
>
> From what you say, plain "rbind" could be used, if the columns in both sets
> are the same and in the same order. After that you can reorder the
> resulting
> data frame as you wish by "order". AFAIK for most functions row order in
> data frame does not matter.
>
> Cheers
> Petr
>
> > -----Original Message-----
> > From: R-help <mailto:r-help-bounces using r-project.org> On Behalf Of Ranjeet
> Kumar Jha
> > Sent: Monday, July 25, 2022 3:03 PM
> > To: R-help <mailto:r-help using r-project.org>
> > Subject: [R] Need to insert various rows of data from a data frame after
> > particular rows from another dataframe
> >
> > Hello Everyone,
> >
> > I have dataset in a particular format in "dacnet_yield_update till
> 2019.xlsx" file,
> > where I need to insert the data of rows 2018-2019 and
> > 2019-2020 for the districts those data are available in "Kharif crops
> yield_18-
> > 19.xlsx".  I need to insert these two rows of data belonging to every
> district, if
> > data is available in a later excel file, just after the particular crop
> group data for
> > the particular district.
> >
> > I have put the data file in the given link.
> > https://drive.google.com/drive/u/0/folders/1dNmGTI8_c9PK1QqmfIjnpbyzuiC
> > XgxFC
> >
> > Please help solving this problem.
> >
> > Regards and Thanks,
> > Ranjeet
> >
> >       [[alternative HTML version deleted]]
> >
> > ______________________________________________
> > mailto:R-help using 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.
>
>
>
> --
> Ranjeet  Kumar Jha, M.Tech. (IIT Kharagpur), Ph.D. (USA)
> https://www.linkedin.com/in/ranjeet-kumar-jha-ph-d-usa-73a5aa56
> -----------------------------------------------------------
> Email: mailto:ranjeetjhaiitkgp using gmail.com
>
>
> "Simple Heart, Humble Attitude and Surrender to Supreme Being make our
> lives beautiful!"
>
>
>
>
> --
> Ranjeet  Kumar Jha, M.Tech. (IIT Kharagpur), Ph.D. (USA)
> https://www.linkedin.com/in/ranjeet-kumar-jha-ph-d-usa-73a5aa56
> -----------------------------------------------------------
> Email: mailto:ranjeetjhaiitkgp using gmail.com
>
>
> "Simple Heart, Humble Attitude and Surrender to Supreme Being make our
> lives beautiful!"
>
>

-- 
Ranjeet  Kumar Jha, M.Tech. (IIT Kharagpur), Ph.D. (USA)
https://www.linkedin.com/in/ranjeet-kumar-jha-ph-d-usa-73a5aa56
-----------------------------------------------------------
Email: *ranjeetjhaiitkgp using gmail.com <ranjeetjhaiitkgp using gmail.com>*


*"Simple Heart, Humble Attitude and Surrender to Supreme Being make our
lives beautiful!"*

	[[alternative HTML version deleted]]