title: Exclude item from value_counts over multiple columns
body: <p>I got the following dataframe:</p>
  <pre><code>      ae264e3637204a6fb9bb56bc8210ddfd  ... 2906b810c7d4411798c6938adc9daaa5
  1                         not received  ...                     not received
  3                            completed  ...                     not received
  5                         not received  ...                           viewed
  8                         not received  ...                        completed
  12                        not received  ...                     not received
                                 ...  ...                              ...
  16995                     not received  ...                     not received
  16996                     not received  ...                     not received
  16997                     not received  ...                     not received
  16998                        completed  ...                     not received
  16999                     not received  ...                     not received
  </code></pre>
  <p>There are 10 columns were I apply the <code>value_counts()</code> method on and get the percentages of the values.</p>
  <p>I do it like this:</p>
  <pre><code>overall = profile[relevant_columns].apply(lambda x: round(pd.Series.value_counts(x) / len(x), 4)* 100)
  overall
  </code></pre>
  <p>Result:</p>
  <pre><code>              ae264e3637204a6fb9bb56bc8210ddfd  ...  2906b810c7d4411798c6938adc9daaa5
  completed                                21.22  ...                             22.82
  not received                             62.47  ...                             63.04
  unresponsive                              1.59  ...                              9.29
  viewed                                   14.73  ...                              4.86
  </code></pre>
  <p>Expected output:</p>
  <pre><code>              ae264e3637204a6fb9bb56bc8210ddfd  ...  2906b810c7d4411798c6938adc9daaa5
  completed                                56.52  ...                             61.82
  unresponsive                              4.23  ...                              25.12
  viewed                                   39.23  ...                              13.14
  </code></pre>
  <p>However, I do not want the percentages of &quot;not received&quot; in my results. I know I could remove the values from each column in  a loop and then apply <code>table_counts()</code> to the column, but it would be much better to keep the <code>apply</code> workflow over multiple columns in a one-liner. Does anyone know how to achieve this?</p>