Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write a Python Code to sort / compare Through Two Excel Files . The sheets contain 6 columns and an uncertain amount of rows.The code

Write a Python Code to sort/compare Through Two Excel Files. The sheets contain 6 columns and an uncertain amount of rows.The code must:
1) Sort the rows by the first Column( smallest to greatest)* this row contains Identification Number*
2)Any additions need to be highlighted in Green(Additions have blank ID)
3) Any deletions highlighted in Red
4) Deletions and Additions need to be moved to the end so the remainder of the columns match accordingly to be compared
5)Any changes highlighted in Yellow.
Any format with those colors to denote differences is fine. I just need a basic code and I can change accordingly.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

4. Describe cultural differences that influence perception

Answered: 1 week ago