title: Dendrogram with a Pandas Dataframe of Words
body: <p>i want to plot a dendrogram with the following data:</p>
  <pre><code>data_test = pd.DataFrame([['Apple', 'Juice', 200], ['Strawberry', 'Icecream', 100],
                           ['Apple', 'Icecream', 100], ['Banana', 'Icecream', 150]], columns = ['Fruits', 'Other', 'Number'])
  
  </code></pre>
  <p>Originally, the Data is much larger, but this should only be an example.</p>
  <p>What I want to do, is Vectorize the DataFrame with TfidfVectorizer from skikitlearn, so my first question is:
  How can I do this for every ROW or for every of the 3 Columns similary?
  I only know, how to do it for the first row, which I will call &quot;Fruits&quot;:</p>
  <pre><code>v = TfidfVectorizer()
  x = v.fit_transform(data_test['Fruits'])
  df1 = pd.DataFrame(x.toarray(), columns=v.get_feature_names())
  </code></pre>
  <p>In reality, my code has a lot of columns, so it would be hard work to do this step for every column. Can you help?</p>
  <p>In the next step, I want to plot a Dendrogram, but I have no idea how to do that....</p>