Apr-22-2019, 05:05 PM
Hello, I am very new to python. trying to solve below issue.
We have two .csv files.
For example:
File Master: Column_A Column_B Column_C ..... Column Z
123 XYZ Z 1X
234 PQR Y 2X
File New: Column_C Column_A Colum_B
X 001 PQR
Y 123 XYZ
Y 234 PQR
Each file has similar data but not in the same order in terms of columns or rows. When there is a match between Master file and New file, Master file needs an update by adding new column and populate with Match or No Match. And also add weights, for example if ALL columns & values are matching then 1, partial match then 0.5 else 0
These files are large running into several GBs.
Please help!
We have two .csv files.
For example:
File Master: Column_A Column_B Column_C ..... Column Z
123 XYZ Z 1X
234 PQR Y 2X
File New: Column_C Column_A Colum_B
X 001 PQR
Y 123 XYZ
Y 234 PQR
Each file has similar data but not in the same order in terms of columns or rows. When there is a match between Master file and New file, Master file needs an update by adding new column and populate with Match or No Match. And also add weights, for example if ALL columns & values are matching then 1, partial match then 0.5 else 0
These files are large running into several GBs.
Please help!