title: How to assign values based on an interval in Pandas
body: <p>I am trying to assign a value to a dataframe column based on a value that falls IN BETWEEN two values of an other dataframe:</p>
  <pre><code>intervals = pd.DataFrame(columns = ['From','To','Value'], data = [[0,100,'A'],[100,200,'B'],[200,500,'C']])
  print('intervals\n',intervals,'\n')
  
  points = pd.DataFrame(columns = ['Point', 'Value'], data = [[45,'X'],[125,'X'],[145,'X'],[345,'X']])
  print('points\n',points,'\n')
  
  DesiredResult = pd.DataFrame(columns = ['Point', 'Value'], data = [[45,'A'],[125,'B'],[145,'B'],[345,'C']])
  print('DesiredResult\n',DesiredResult,'\n')
  </code></pre>
  <p><a href="https://i.stack.imgur.com/LG7Ed.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LG7Ed.png" alt="enter image description here" /></a></p>
  <p>Many thanks</p>