Merge two csv files: one is at the top and one is at the bottom. Code:
         
       Input:    
         
         
         
       Output:    
         

====================================================

merge, left_index, right_index: Merge two csv files: code:
        
Input:        
        
        
Output:        
        

==========================

merge: Merge two csv files: code:
        
Input:        
        
        
Output:        
        

=========================

Merge two files with common values of two columns only and ignore the rows without common cell values in the two columns. Code:

Input file 1:

Input file 2:

Output:

=========================

Extract the rows that were not merged into the output file.  Code:

UnmergedFile1:

UnmergedFile2:

====================================================        

Merge two csv files and then write the merged data back to file1, effectively replacing it.  Code:

Input:

Output:

====================================================