title: How to merge list of lists with a tsv file in pandas
body: <p>I have a list of lists namely <code>mylist</code> as follows.</p>
  
  <pre><code>mylist = [[9, ["nuts", "fruits"]], [12, ["france", "italy", "rome", "paris"]], [18, ["cat", "dog", "parrot", "rabbit", "cow"]], [19, ["ebay", "wish"]]]
  </code></pre>
  
  <p>I also have a tsv file namely <code>myinput</code> as follows.</p>
  
  <pre><code>ID Category
  12 ["places", "locations"]
  19 ["online", "customer"]
  18 ["pets"]
  9  ["food"]
  </code></pre>
  
  <p>I want to combine these two with <code>ID</code> as follows.</p>
  
  <pre><code>my_output = [[9, ["nuts", "fruits"], ["food"]], [12, ["france", "italy", "rome", "paris"], ["places", "locations"]], [18, ["cat", "dog", "parrot", "rabbit", "cow"], ["pets"]], [19, ["ebay", "wish"], ["online", "customer"]]]
  </code></pre>
  
  <p>I was initially thought to convert the tsv file to a list as follows and perform a typical list processing using python.</p>
  
  <pre><code>input_data = pd.read_csv("myinput.tsv", header=0, delimiter="\t", quoting=3 )
  my_data = input_data.values.tolist()
  </code></pre>
  
  <p>However, I am wondering if it is possible to do the same using pandas.</p>
  
  <p>I am happy to provide more details if needed.</p>