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, Fibonacci_arranged.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 built-in array functions like len, max, min, etc. but DO NOT use any built-in Python functions that orders/arranges 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:
144
89
1
3
5
8
13
610
1597
4181
34
233
2
987
2584
21
0
377
55

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 Databases Questions!