title: sending output of linux command into pandas dataframe
body: <p>i have the following linux command:</p>
  <pre><code>os.system('cat *' + FILENAME + '*comp_value/' + VARINLASTLINE + '.csv | grep -v SOMETHING | sort -u &gt; test.csv')
  </code></pre>
  <p>As can be seen, I first cat some csv files, grep to eliminate the last line, and then use sort to create a test.csv file.
  However I will be doing this for a large list of large files and I do not want to create dummy test.csv files every time I cat the files together. Is there a way to output the cat of these files directly into the pandas dataframe instead of creating a csv file?</p>