In Python code for the following question. Do not do in excel.

Import pandas and pyomo. Code for constraints and decision variables and objective function. Below is the question and the question done in solver to show the solutions that python should get as well.

In Python code to solve:

Excel Solver Solutions:

6.4 Selecting New Products: A video game company has an R\&D group with 30 programmers. The group has been given a budget of $1 million for this year to develop and test new game designs for introduction next year. The new games have been outlined, each with the ancillary expenses that will be incurred and the number of programmers that will be needed. A panel of marketing specialists has estimated the potential revenues from each game. The problem for the R\&D group is to generate the maximum level of potential revenues from its limited expense budget and its available programmers. R\&D Projects \begin{tabular}{|l|l|l|l|l|l|l|l|l|l|l|l|l|} \hline & Game Project & 1 & \multicolumn{1}{|c|}{2} & 3 & 4 & 5 & 6 & 7 & 8 & \\ \hline & Revenue & 325 & 275 & 320 & 220 & 190 & 265 & 360 & 285 & \\ \hline & Expense & 200 & 130 & 240 & 120 & 115 & 135 & 105 & 280 & \\ \hline & & & & & & & & & \\ \hline \end{tabular}