|
||||||||
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: ![]()
============================================
|
||||||||
| ================================================================================= | ||||||||
|
|
||||||||