Home > Software design >  Take value of a cell and store it in a variable for given values of column and row in python
Take value of a cell and store it in a variable for given values of column and row in python

Time:12-29

I want to trace back value of X and store it as a variable for given values of columns and rows.

in this case, table is relation between yield strength and slenderness ratio, provided in local building byelaws, I want to use it in a script (Rest API) and call it through flask (local host) in flutter app.

I am storing table as libre-calc/csv file, should I use sql-lite? I have tried using pandas

example, i want python to take value of sigma(pink) if value of yield strength is 250 and value of slenderness ratio is 60: enter image description here

Now if you prefer this as a variable...

percentageSpent = round((df['Rent_Cost']/df['Salary']*100), 2)

If you already have the column with the values you need then it becomes way easier.

percentageSpent = df['Salary_%_Spent']

or

caseyPercentage = df['Salary_%_Spent'][df['Name']=='Casey']

I hope this helps you, or at least guide you to solve your issue.

  • Related