Python Numpy and DataFrame Project

[isabelleckard]

Hi! I left a python project until the last minute, and now I'm super confused and don't know how to start. The project is laid out by the pseudocode which is:

Read initial tableau from excel, using pandas DataFrame
Assign values from DataFrame to a numpy array
Find the entering variable by checking row zero (largest negative) – If no negative, Optimal Solution
Conduct a ratio test (column of rhs/column of entry variable with coefficient>0) – report the winner row
Carry out ERO for the winner row
Carry out ERO for row zero
Carry out ERO for other row
Use the updated numpy array and the column labels from DataFrame to make a new DataFrame
Print the new DataFrame
Write the DataFrame into Excel

The data for the project in a .csv file is:

z x1 x2 s1 s2 s3 rhs
1 -3 -2 0 0 0 0
0 2 1 1 0 0 100
0 1 1 0 1 0 80
0 1 0 0 0 1 40

I am willing to hire help for this question.

[jefsummers]

Regarding the last comment, there is a jobs section on the board.
Start with your imports (pandas, numpy)
Use the read_excel() function in pandas to read the dataframe
Use the dataframe.to_numpy function to convert to numpy.

That will get you started.