Home / EXCEL TIPS / Comparison of data values between two excel files and creation of a new excel and csv file with PYTHON
Let’s assume that you have 2 excel files :
product_data_excel.xlsx (99 rows x 5 columns, A2:E100)
product_data_excel_2.xlsx (107 rows x 5 columns, A2:E108)
The 5 columns of the two excel files are : product_id, product_description, quantity, regular_price and category.product_data_excel.xlsx
You have changed quantity and price values for existing product_ids : “A0001” and “A0003” (column : “product_id”) and you have added 8 new products in excel file : product_data_excel_2.xlsx.
Now you want to compare product_data_excel.xlsx and product_data_excel_2.xlsx and create a new excel file : product_data_excel_changed_and_new_records.xlsx and csv file : product_data_excel_changed_and_new_data.csv with the 2 existing products you have changed and the 8 new ones you have added.
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.