Electron microscopy
 
PythonML
Check Whether or Not  a Cell Value in a Column of a CSV File Matchs a Value in a Column of Another CSV File, then Do Something   
- Python Automation and Machine Learning for ICs -
- An Online Book -
Python Automation and Machine Learning for ICs                                                           http://www.globalsino.com/ICs/        


Chapter/Index: Introduction | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | Appendix

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

Check whether or not a cell value in a column of a csv file matchs a value in a column of another csv file. If there no match, then add it to the csv file (Code).  

          

     Input:

        FileAA.csv: 

          

        FileBB.csv: 

          

     Output (Values in column 'U' of csv_f2 not in column 'X' of csv_f1): 

          

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

Merge the cells into one file if one column in another file is different. Code:
         

     Input:

        FileAA.csv: 

          

        FileBB.csv: 

          
       Output:    
         
         
       Output after executing the script again:    
         
                   

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

 

         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         

 

 

 

 

 



















































 

 

 

 

 

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