So i have a file with column that has information on salary (eg. 2674 dollars) -indi  salary   sam    2674   john   6375   max    9547and another file with the scale of the salary (column1&colum2) on its corresponding rank (column3)salary_min salary_max Rank2000           4000    Deputy4000           6000    secretary6000           8000    Assistant8000           10000   ManagerNow I would like to assign those individuals from file 1 based on the salary to their corresponding rankso the final output would be    indi    Rank     sam    Deputy     john   Assistant     max    ManagerHow can I achieve this in linux on the same dataset type but with larger data?
Take the value of another column if the query column is between two column values
text processing;numeric data