Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
Jacksmith12
Level IV

Merging two columns

i am trying to join two data frames but cannot get my head around the possibilities Python has to offer.

First JMP data file:

ID MODEL   REQUESTS ORDERS1  Golf    123      4
2  Passat  34       5
3  Model 3 500      8
4  M3      5        0

Second JMP data file:

MODEL   TYPE  MAKEGolf    Sedan VolkswagenM3      Coupe BMWModel 3 Sedan Tesla

What I want is to add another column in the first dataframe called "make" so that it looks like this:

ID MODEL   MAKE       REQUESTS ORDERS1  Golf    Volkswagen 123      4
2  Passat  Volkswagen 34       5
3  Model 3 Tesla      500      8
4  M3      BMW        5        0

 Any suggestions how can I start?

1 REPLY 1
Highlighted
ian_jmp
Staff

Re: Merging two columns

Looks like you need the menu option 'Tables > Join'. Your post got a little scrambled, but using the tables attached and setting up the dialog like this:

 

Screenshot 2020-03-11 at 16.53.15.png

 

you should get close. You could also look at virtual joins.

Article Labels

    There are no labels assigned to this post.