Compare columns in 2 files and put information according to file 1 [duplicate]












0
















This question already has an answer here:




  • intersection of two files according to the first column

    1 answer




I have 2 files, file 1 and file 2 and I want to compare column 1 in file to column 1 in file 2 and have additional column generated with column 2 in file 3
File 1:



9001    Whitby          On

9002    Toronto         On

9003    Scarborough On

9004    Victoria    BC

9005    Vancouver   BC


File 2:



9001   501

9002   502

9003   503

9004   504

9005   505


Output:



501   9001  Whitby          On

502   9002  Toronto         On

503   9003  Scarborough     On

504   9004  Victoria        BC

505   9005  Vancouver       BC





text-processing join







share|improve this question















marked as duplicate by don_crissti, Mr Shunz, Jeff Schaller, Shadur, Christopher Jan 10 at 13:41


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.




















    0
















    This question already has an answer here:




    • intersection of two files according to the first column

      1 answer




    I have 2 files, file 1 and file 2 and I want to compare column 1 in file to column 1 in file 2 and have additional column generated with column 2 in file 3
    File 1:



    9001    Whitby          On
    
9002    Toronto         On
    
9003    Scarborough On
    
9004    Victoria    BC
    
9005    Vancouver   BC


    File 2:



    9001   501
    
9002   502
    
9003   503
    
9004   504
    
9005   505


    Output:



    501   9001  Whitby          On
    
502   9002  Toronto         On
    
503   9003  Scarborough     On
    
504   9004  Victoria        BC
    
505   9005  Vancouver       BC





    text-processing join







    share|improve this question















    marked as duplicate by don_crissti, Mr Shunz, Jeff Schaller, Shadur, Christopher Jan 10 at 13:41


    This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


















      0












      0








      0









      This question already has an answer here:




      • intersection of two files according to the first column

        1 answer




      I have 2 files, file 1 and file 2 and I want to compare column 1 in file to column 1 in file 2 and have additional column generated with column 2 in file 3
      File 1:



      9001    Whitby          On
      
9002    Toronto         On
      
9003    Scarborough On
      
9004    Victoria    BC
      
9005    Vancouver   BC


      File 2:



      9001   501
      
9002   502
      
9003   503
      
9004   504
      
9005   505


      Output:



      501   9001  Whitby          On
      
502   9002  Toronto         On
      
503   9003  Scarborough     On
      
504   9004  Victoria        BC
      
505   9005  Vancouver       BC





      text-processing join







      share|improve this question

















      This question already has an answer here:




      • intersection of two files according to the first column

        1 answer




      I have 2 files, file 1 and file 2 and I want to compare column 1 in file to column 1 in file 2 and have additional column generated with column 2 in file 3
      File 1:



      9001    Whitby          On
      
9002    Toronto         On
      
9003    Scarborough On
      
9004    Victoria    BC
      
9005    Vancouver   BC


      File 2:



      9001   501
      
9002   502
      
9003   503
      
9004   504
      
9005   505


      Output:



      501   9001  Whitby          On
      
502   9002  Toronto         On
      
503   9003  Scarborough     On
      
504   9004  Victoria        BC
      
505   9005  Vancouver       BC




      This question already has an answer here:




      • intersection of two files according to the first column

        1 answer







      text-processing join




      text-processing join






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Jan 10 at 19:00









      Rui F Ribeiro

      39.5k1479133




      39.5k1479133










      asked Jan 9 at 21:00









      Muhammad Umair KhanMuhammad Umair Khan

      11




      11




      marked as duplicate by don_crissti, Mr Shunz, Jeff Schaller, Shadur, Christopher Jan 10 at 13:41


      This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.






      marked as duplicate by don_crissti, Mr Shunz, Jeff Schaller, Shadur, Christopher Jan 10 at 13:41


      This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
























          1 Answer
          1






          active

          oldest

          votes


















          0
















          you could use Miller http://johnkerl.org/miller/doc/



          If your files are two TSV the command is



          mlr --tsv --implicit-csv-header --headerless-csv-output  join --ul -l 1 -r 1 -j 1 --lp l --rp r -f file1.csv file2.csv


          And you have



          9001    Whitby  On      501
          
9002    Toronto On      502
          
9003    Scarborough     On      503
          
9004    Victoria        BC      504
          
9005    Vancouver       BC      505





          share|improve this answer
































            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0
















            you could use Miller http://johnkerl.org/miller/doc/



            If your files are two TSV the command is



            mlr --tsv --implicit-csv-header --headerless-csv-output  join --ul -l 1 -r 1 -j 1 --lp l --rp r -f file1.csv file2.csv


            And you have



            9001    Whitby  On      501
            
9002    Toronto On      502
            
9003    Scarborough     On      503
            
9004    Victoria        BC      504
            
9005    Vancouver       BC      505





            share|improve this answer






























              0
















              you could use Miller http://johnkerl.org/miller/doc/



              If your files are two TSV the command is



              mlr --tsv --implicit-csv-header --headerless-csv-output  join --ul -l 1 -r 1 -j 1 --lp l --rp r -f file1.csv file2.csv


              And you have



              9001    Whitby  On      501
              
9002    Toronto On      502
              
9003    Scarborough     On      503
              
9004    Victoria        BC      504
              
9005    Vancouver       BC      505





              share|improve this answer




























                0












                0








                0









                you could use Miller http://johnkerl.org/miller/doc/



                If your files are two TSV the command is



                mlr --tsv --implicit-csv-header --headerless-csv-output  join --ul -l 1 -r 1 -j 1 --lp l --rp r -f file1.csv file2.csv


                And you have



                9001    Whitby  On      501
                
9002    Toronto On      502
                
9003    Scarborough     On      503
                
9004    Victoria        BC      504
                
9005    Vancouver       BC      505





                share|improve this answer

















                you could use Miller http://johnkerl.org/miller/doc/



                If your files are two TSV the command is



                mlr --tsv --implicit-csv-header --headerless-csv-output  join --ul -l 1 -r 1 -j 1 --lp l --rp r -f file1.csv file2.csv


                And you have



                9001    Whitby  On      501
                
9002    Toronto On      502
                
9003    Scarborough     On      503
                
9004    Victoria        BC      504
                
9005    Vancouver       BC      505






                share|improve this answer














                share|improve this answer



                share|improve this answer








                edited Jan 10 at 8:38

























                answered Jan 10 at 7:58









                aborrusoaborruso

                20619




                20619















                    -

                    Popular posts from this blog

                    Morgemoulin

                    Image
                    Morgemoulin — miejscowość i gmina — Państwo   Francja Region Grand Est Departament Moza Okręg Verdun Kod INSEE 55357 Powierzchnia 6,82 km² Populacja  (1990) • liczba ludności 75 • gęstość 11 os./km² Kod pocztowy 55400 Położenie na mapie Francji Morgemoulin 49°14′N   5°35′E / 49,233333   5,583333 Portal Francja Morgemoulin – miejscowość i gmina we Francji, w regionie Grand Est, w departamencie Moza. Według danych na rok 1990 gminę zamieszkiwało 75 osób, a gęstość zaludnienia wynosiła 11 osób/km² (wśród 2335 gmin Lotaryngii Morgemoulin plasuje się na 970. miejscu pod względem liczby ludności, natomiast pod względem powierzchni na miejscu 848.). Bibliografia | Francuski urząd statystyczny ( fr. ) . p   •   d   •   e Gminy okręgu Verdun Abaucourt-Hautecourt • Aincreville • Ambly-sur-Meuse • Amel-sur-l'Étang • Ancemont • Arrancy-sur-Crusne • Aubréville • Autré
                    Read more

                    Scott Moir

                    Image
                    Scott Moir Tessa Virtue i Scott Moir w 2016 r. Reprezentacja   Kanada Data i miejsce urodzenia 2 września 1987 London Wzrost 180 cm Konkurencja Pary taneczne Partner sportowy Tessa Virtue Trener Marie-France Dubreuil, Patrice Lauzon, Romain Haguenauer Poprzednio: Marina Zujewa, Oleg Epstein, Igor Szpilband, Johnny Johns, Carol Moir, Paul MacIntosh, Suzanne Killing Klub Montreal International School of Skating Poprzednio: Arctic Edge FSC Ilderton Skating Club Lokalizacja treningowa Montreal Poprzednio: Canton Kitchener Rekordy życiowe ISU przed sezonem 2018/2019 Nota łączna 206,07 Igrzyska Olimpijskie 2018 Taniec krótki 83,67 Igrzyska Olimpijskie 2018 Taniec dowolny 122,40 Igrzyska Olimpijskie 2018 Dorobek medalowy Reprezentacja   Kanada Igrzyska olimpijskie Złoto Vancouver 2010 pary taneczne Złoto Pjongczang 2018 pary taneczne Złoto Pjongczang 2018 drużynowo Srebro S
                    Read more

                    Souastre

                    Image
                    Souastre — miejscowość i gmina — Herb Państwo   Francja Region Hauts-de-France Departament Pas-de-Calais Okręg Arras Kod INSEE 62800 Powierzchnia 7,18 km² Populacja  (1990) • liczba ludności 352 • gęstość 49 os./km² Kod pocztowy 62111 Położenie na mapie Francji Souastre 50°09′N   2°34′E / 50,150000   2,566667 Portal Francja Souastre – miejscowość i gmina we Francji, w regionie Hauts-de-France, w departamencie Pas-de-Calais. Według danych na rok 1990 gminę zamieszkiwały 352 osoby, a gęstość zaludnienia wynosiła 49 osób/km² (wśród 1549 gmin regionu Nord-Pas-de-Calais Souastre plasuje się na 887. miejscu pod względem liczby ludności, natomiast pod względem powierzchni na miejscu 507.). Bibliografia | Francuski urząd statystyczny ( fr. ) . p   •   d   •   e Gminy okręgu Arras Ablain-Saint-Nazaire Ablainzevelle Acheville Achicourt Achiet-le-Grand Achiet-le-Pe
                    Read more