Question: Write a Python program a ) That will read those numbers in from the Excel file, rearrange them from the smallest to the largest, and
Write a Python program
a That will read those numbers in from the Excel file, rearrange them from the smallest to the largest, and write them down in that order on to a new Excel file, Fibonacciarranged.xlsx with header explaining the list below and no index.
b That asks the user to enter an integer, checks whether there is a Fibonacci number in the given list that is greater than the entered number, and prints the following:
Print all the Fibonacci numbers greater than the entered number, if there are such numbers
If the entered number is greater than all the Fibonacci numbers, print the largest Fibonacci number from the list
You need to follow the rules below for this assignment:
Use arrays to store and manipulate the numbers
You can use builtin array functions like len, max, min, etc. but DO NOT use any builtin Python functions that ordersarranges numbers.
Use functions to organize your code and comments to explain the steps
The code should be written such that any set of random numbers on the first Excel file can be arranged from the smallest to the largest and found on the new Excel file, without changing the code at all. The numbers in this problem happen to be part of the Fibonacci series; that shouldnt affect your code in any way.
Excel list:
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
