D
D
Daniil Bakhin2021-04-21 17:44:52
Python
Daniil Bakhin, 2021-04-21 17:44:52

How to find the intersection of a row and column of a table?

608039d1da21c811414373.jpeg
There is such a table. Input data: nominal size and letter of the main deviation. How to get the correct number?
Made a loop that checks for the presence of a row number in a column. But it outputs all the numbers that are present in the column.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
dmshar, 2021-04-21
@PhysDevMan

If you put a question under the Python tag, then the answer will also be about that language.
Python has a wonderful Pandas library - just right for representing your data.
If I had taken the trouble to bring in the question - as required (and not in vain) the rules of the site - not a picture, but a tablet you typed (at least in EXCEL), I would have taken the trouble to write code, how such data "fit" into a DataFrame . And if not - well, figure it out for yourself where to look I said.
After the DataFrame is created, the value at the intersection of the column and row is searched elementarily, in one command, like this:
df.ef[(df.Свыше==65) & (df.До==80)]

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question