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:
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.