title: Extract data from specific format in Pandas DF
body: <p>I have a raw data in csv format which looks like this:</p>
  <p><code>product-name    brand-name   rating</code></p>
  <p><code>[&quot;Whole Wheat&quot;] [&quot;bb Royal&quot;] [&quot;4.1&quot;]</code></p>
  <p>Expected output:</p>
  <p><code>product-name   brand-name   rating</code></p>
  <p><code>Whole Wheat    bb Royal     4.1</code></p>
  <p>I want this to affect every entry in my dataset. I have 10,000 rows of data. How can I do this using pandas?
  Can we do this using regular expressions? Not sure how to do it.</p>
  <p>Thank you.</p>
  <p>Edit 1:
  My data looks something like this:</p>
  <pre><code>df = {
  'product-name': [
  [&quot;&quot;'Whole Wheat'&quot;&quot;], [&quot;&quot;'Milk'&quot;&quot;] ],
  
  'brand-name': [
  [&quot;&quot;'bb Royal'&quot;&quot;], [&quot;&quot;'XYZ'&quot;&quot;] ],
  
  'rating': [
  [&quot;&quot;'4.1'&quot;&quot;], [&quot;&quot;'4.0'&quot;&quot;] ]
   }
  df_p = pd.DataFrame(data=df)
  </code></pre>
  <p>It outputs like this: [&quot;bb Royal&quot;]</p>
  <p>PS: Apologies for my programming. I am quite new to programming and also to this community. I really appreciate your help here :)</p>