title: How to keep rows that are identical between two data frames?
body: <p>I have two CSV files that both have the column &quot;study_title&quot;. I'm using that column to decide what rows will be printed. If the title shows up in the &quot;study_title&quot; column in both CSV files, then I need the title to be printed. Currently, it just keeps printing the same title multiple times.</p>
  <pre><code># Setting up the Environment
  import pandas as pd
  
  # Import the data and format to a csv file
  Instrument = pd.read_csv('/Volumes/Projects/Project/Data/Instrument_output.txt',delimiter = &quot;\t&quot;)
  Paper = pd.read_csv('/Volumes/Projects/Project/Data/Paper_output.txt',delimiter = &quot;\t&quot;)
  
  #Set up the variables
  count = []
  
  # Print Study accession values that match in both queries
  for row in Instrument[&quot;study_title&quot;]:
        for line in Paper[&quot;study_title&quot;]:
            if row == line:
              count.append(row)
  print(count)
  
  </code></pre>