11:34 a.m.
Dear Gretl community
*, * I have two datasets A and B.
Both A and B have different variables but with common variable i.e. ID. I
want to merge these two data sets using ID as the common variable as given
below : data set C. Thanking you in advanceI would be thankful for
providing the solution. Note: A : Household data and B members data.
Dhanasekaran K
Merging data frames with different number of rows
<https://community.rstudio.com/t/merging-data-frames-with-different-number...
<https://community.rstudio.com/c/tidyverse/6>data set:A
*ID*
*x1*
*x2*
*x3*
1
50
2
1
2
60
5
3
3
30
6
5
4
20
9
6
5
90
7
9
data set:B
*ID*
*x4*
*x5*
1
5
male
1
4
female
1
3
male
2
2
male
2
5
female
3
6
male
3
1
female
3
8
female
4
2
male
5
3
female
5
10
male
merged data set: C
ID
x1
x2
x3
x4.1
x4.2
x4.3
x5.1
x5.2
x5.3
1
50
2
1
5
4
3
male
female
male
2
60
5
3
2
5
NA
male
female
NA
3
30
6
5
6
1
8
male
female
female
4
20
9
6
2
NA
NA
male
NA
NA
5
90
7
9
3
10
NA
female
male
NA
9:25 a.m.
On 17/01/2024 12:34, Dhanasekaran Kuppusamy wrote:
Dear Gretl community*,
* I have two datasets A and B.
Both A and B have different variables but with common variable i.e. ID.
I want to merge these two data sets using ID as the common variable as
given below : data set C. Thanking you in advanceI would be thankful for
providing the solution. Note: A : Household data and B members data.
Dhanasekaran K
Generally speaking, what you need is the "join" command.: assuming your
two example dataset are in gdt format (but csv would work just as well),
you can add the data from A to B via
<hansl>
open dataset_b.gdt
join dataset_a.gdt x1 x2 x3 --ikey=ID
</hansl>
Reformatting the data as you dataset C is less easy, since you can't
assume that each household has the same number of members. The following
example shows what happens if you set the maximum number of family
members to 3:
<hansl>
open dataset_a.gdt
maxn = 3
loop i = 1 .. maxn
loop foreach j x4 x5
sname = sprintf("$j_%d", i)
join dataset_b.gdt @sname --data=$j --ikey=ID --aggr="seq:$i"
endloop
endloop
</hansl>
Having said all this, I'd recommend reading the Guide chapter titled
"Joining data sources".
-------------------------------------------------------
Riccardo (Jack) Lucchetti
Dipartimento di Scienze Economiche e Sociali (DiSES)
Università Politecnica delle Marche
(formerly known as Università di Ancona)
r.lucchetti(a)univpm.it
http://www2.econ.univpm.it/servizi/hpp/lucchetti
-------------------------------------------------------
11:33 a.m.
Thank you very much for your solution,Prof. Lucchetti. I will try to join
the data sets with your code.
With best regards
Dhanasekaran K
On Wed, 17 Jan 2024 at 3:13 PM, Riccardo (Jack) Lucchetti <
p002264(a)staff.univpm.it> wrote:
On 17/01/2024 12:34, Dhanasekaran Kuppusamy wrote:
> Dear Gretl community*,
> * I have two datasets A and B.
> Both A and B have different variables but with common variable i.e. ID.
> I want to merge these two data sets using ID as the common variable as
> given below : data set C. Thanking you in advanceI would be thankful for
> providing the solution. Note: A : Household data and B members data.
>
> Dhanasekaran K
Generally speaking, what you need is the "join" command.: assuming your
two example dataset are in gdt format (but csv would work just as well),
you can add the data from A to B via
<hansl>
open dataset_b.gdt
join dataset_a.gdt x1 x2 x3 --ikey=ID
</hansl>
Reformatting the data as you dataset C is less easy, since you can't
assume that each household has the same number of members. The following
example shows what happens if you set the maximum number of family
members to 3:
<hansl>
open dataset_a.gdt
maxn = 3
loop i = 1 .. maxn
loop foreach j x4 x5
sname = sprintf("$j_%d", i)
join dataset_b.gdt @sname --data=$j --ikey=ID --aggr="seq:$i"
endloop
endloop
</hansl>
Having said all this, I'd recommend reading the Guide chapter titled
"Joining data sources".
-------------------------------------------------------
Riccardo (Jack) Lucchetti
Dipartimento di Scienze Economiche e Sociali (DiSES)
Università Politecnica delle Marche
(formerly known as Università di Ancona)
r.lucchetti(a)univpm.it
http://www2.econ.univpm.it/servizi/hpp/lucchetti
-------------------------------------------------------
_______________________________________________
Gretl-users mailing list -- gretl-users(a)gretlml.univpm.it
To unsubscribe send an email to gretl-users-leave(a)gretlml.univpm.it
Website:
https://gretlml.univpm.it/postorius/lists/gretl-users.gretlml.univpm.it/
12:26 p.m.
Dear Prof. Lucchetti,
Thank you very much for your excellent
solution. I used your code and joined the two sets very well.
With best regards
Dhanasekaran K
On Wed, Jan 17, 2024 at 5:03 PM Dhanasekaran Kuppusamy <drgkdphd(a)gmail.com>
wrote:
Thank you very much for your solution,Prof. Lucchetti. I will try to
join
the data sets with your code.
With best regards
Dhanasekaran K
On Wed, 17 Jan 2024 at 3:13 PM, Riccardo (Jack) Lucchetti <
p002264(a)staff.univpm.it> wrote:
> On 17/01/2024 12:34, Dhanasekaran Kuppusamy wrote:
> > Dear Gretl community*,
> > * I have two datasets A and B.
> > Both A and B have different variables but with common variable i.e. ID.
> > I want to merge these two data sets using ID as the common variable as
> > given below : data set C. Thanking you in advanceI would be thankful
> for
> > providing the solution. Note: A : Household data and B members data.
> >
> > Dhanasekaran K
>
> Generally speaking, what you need is the "join" command.: assuming your
> two example dataset are in gdt format (but csv would work just as well),
> you can add the data from A to B via
>
> <hansl>
> open dataset_b.gdt
> join dataset_a.gdt x1 x2 x3 --ikey=ID
> </hansl>
>
> Reformatting the data as you dataset C is less easy, since you can't
> assume that each household has the same number of members. The following
> example shows what happens if you set the maximum number of family
> members to 3:
>
> <hansl>
> open dataset_a.gdt
>
> maxn = 3
>
> loop i = 1 .. maxn
> loop foreach j x4 x5
> sname = sprintf("$j_%d", i)
> join dataset_b.gdt @sname --data=$j --ikey=ID --aggr="seq:$i"
> endloop
> endloop
> </hansl>
>
> Having said all this, I'd recommend reading the Guide chapter titled
> "Joining data sources".
>
> -------------------------------------------------------
> Riccardo (Jack) Lucchetti
> Dipartimento di Scienze Economiche e Sociali (DiSES)
>
> Università Politecnica delle Marche
> (formerly known as Università di Ancona)
>
> r.lucchetti(a)univpm.it
> http://www2.econ.univpm.it/servizi/hpp/lucchetti
> -------------------------------------------------------
> _______________________________________________
> Gretl-users mailing list -- gretl-users(a)gretlml.univpm.it
> To unsubscribe send an email to gretl-users-leave(a)gretlml.univpm.it
> Website:
> https://gretlml.univpm.it/postorius/lists/gretl-users.gretlml.univpm.it/
>
351
days inactive
351
days old
3 comments
2 participants
participants (2)
-
Dhanasekaran Kuppusamy -
Riccardo (Jack) Lucchetti