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

                    List directoties down one level, excluding some named directories and files

                    Image
                    1 I want to send a list of all folders including one level down to a txt file. Excluding some named folders and no files. Imagine a folder structure like this. CAPS are folders. FOLDER 1 .hidden TEMP somefile ========= ========= FOLDER 2 .hidden TEMP DATA1 DATA2 somefile ======== ======== FOLDER 3 .hidden TEMP DATA1 somefile I would like to run "insert magic command here" and end up with an output that looks like below FOLDER 1 FOLDER 2 DATA1 DATA2 FOLDER 3 DATA1 bash shell-script share | improve this question edited Dec 16 at 4:15 Rui F Ribeiro ...
                    Read more

                    Województwo

                    Image
                    Podział administracyjny Polski (stan na 1 stycznia 2010) Województwo – jednostka podziału administracyjnego najwyższego stopnia w Polsce, od 1990 r. jednostka zasadniczego podziału terytorialnego administracji rządowej, od 1999 r. także jednostka samorządu terytorialnego. Podział kraju na województwa ma swoje korzenie w okresie rozbicia dzielnicowego, stąd ich zróżnicowanie pod względem wielkości w czasach Rzeczypospolitej. Pierwsze województwa powstawały na przełomie XIV i XV w. Pierwotnie były to samodzielne zgromadzenia wojskowe na określonych terenach Polski, którymi zarządzali wyznaczani przez władcę wojewodowie – od: wodzić woje. Status województwa reguluje w Polsce ustawa o samorządzie województwa z dnia 5 czerwca 1998 r. [1] Spis treści 1 Liczba województw 2 Stan aktualny – 16 województw 2.1 Podział na województwa od 1999 r. 3 Województwa w przeszłości 3.1 Pierwsze województwa w Polsce 3.2 Województwa w okresie I Rzeczypospolitej 3....
                    Read more

                    What dialect is “You wants I should do it for ya?”

                    Image
                    0 I heard this phrasing in an episode of a TV show, but I can't remember what for the life of me. I just remember how weird it sounded, because no one else talked like that in the series? It was a white character in a rural setting, if that helps. A criminal henchman. Is there an area or something where "You wants I..." is commonplace? slang dialects share | improve this question asked 12 hours ago Patroclus 21 2 2 ...
                    Read more