Question: Write a Python Code to Sort an excel sheet w / 3 columns and an uncertain amount of rows. The sheet includes columns: ' ID

Write a Python Code to Sort an excel sheet w/3 columns and an uncertain amount of rows. The sheet includes columns: 'ID', 'Name',and 'Value'The code must Sort the rows by the ID's, and for missing ID's insert a row with a '0' or 'NaN' value.This will be used to compare two sheets, The sheets have missing ID's and added ID's. The error comes in when 'ID 4' is missing. The sheet then sorts as 1,2,3,5,6 which throws off the remainder of the comparison. Keep in mind additions have no ID, therefore the code will need to account for the name even with a blank ID.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!