title: Pandas split CSV into multiple CSV's (or DataFrames) by a column
body: <p>I'm very lost with a problem and some help or tips will be appreciated.</p>
  
  <p>The problem: I've a csv file with a column with the possibility of multiple values like:</p>
  
  <pre><code>Fruit;Color;The_evil_column
  Apple;Red;something1
  Apple;Green;something1
  Orange;Orange;something1
  Orange;Green;something2
  Apple;Red;something2
  Apple;Red;something3
  </code></pre>
  
  <p>I've loaded the data into a dataframe and i need to split that dataframe into multiple dataframes based on the value of the column "The_evil_column":</p>
  
  <pre><code>df1
  Fruit;Color;The_evil_column
  Apple;Red;something1
  Apple;Green;something1
  Orange;Orange;something1
  
  df2
  Fruit;Color;The_evil_column
  Orange;Green;something2
  Apple;Red;something2
  
  df3
  Fruit;Color;The_evil_column
  Apple;Red;something3
  </code></pre>
  
  <p>After reading some posts i'm even more confused and i need some tip about this please.</p>