All BUSINESS ENGLISH 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.

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.

product_data_excel_changed_and_new_records.xlsx

Download

product_data_excel.xlsx,

product_data_excel_2.xlsx,

product_data_excel_changed_and_new_records.xlsx, product_data_excel_changed_and_new_records.csv

Click comparing_data_values_between_2_excel_files to see the code (html format) . . .

 

Comments are closed.

Pin It

By continuing to use the site, you agree to the use of cookies. / Συνεχίζοντας να χρησιμοποιείτε την ιστοσελίδα, συμφωνείτε με τη χρήση των cookies. more information / περισσότερες πληροφορίες

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.

Close