matching data and plotting in for loop

say i have data saved as a txt file:

number length valid
3 5 1
6 7 0
7 4 1
4 3 1

and a csv saved table such as

csv file data

How would I:

  1. clean data from table so that the ones which are valid are used.
  2. match up data points from table to csv file data depending on their 'number'.
  3. plot a graph of width by intensity for each 'number'. So in this case ie there would be 3 graphs of width by intensity, as the invalid data is excluded.

I'm not sure if what I'm asking is clear, but I am quite new to coding and am desperate for help.

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum