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 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 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 is missing. The sheet then sorts as 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
